explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N9f1

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,625.487 ↑ 1.0 1 1

Limit (cost=0.43..65.97 rows=1 width=4) (actual time=1,625.486..1,625.487 rows=1 loops=1)

2. 1,625.485 1,625.485 ↑ 3,360.0 1 1

Index Scan using pins_pkey on pins p (cost=0.43..220,205.25 rows=3,360 width=4) (actual time=1,625.485..1,625.485 rows=1 loops=1)

  • Filter: ((order_item IS NULL) AND (product = 3,458))
  • Rows Removed by Filter: 6,708,172
Planning time : 0.219 ms
Execution time : 1,625.500 ms