explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b5b3 : Optimization for: plan #rmD1

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.036 0.036 ↑ 1.0 1 1

Index Scan using parcel_lkup on parcel (cost=0.42..8.44 rows=1 width=123) (actual time=0.035..0.036 rows=1 loops=1)

  • Index Cond: ((pin = '0'::numeric) AND (property_id = '24581'::numeric) AND (pinyear = '2001'::numeric))
Planning time : 0.980 ms
Execution time : 0.082 ms