explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EEO1

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 0.020 ↑ 1.0 1 1

Index Scan Backward using parcel_lkup on parcel (cost=0.42..8.44 rows=1 width=122) (actual time=0.019..0.020 rows=1 loops=1)

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