explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0AWF

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

Limit (cost=3,903.49..3,903.49 rows=1 width=8) (actual time=6.043..6.044 rows=1 loops=1)

2. 2.006 6.042 ↑ 3,835.0 1 1

Sort (cost=3,903.49..3,913.08 rows=3,835 width=8) (actual time=6.042..6.042 rows=1 loops=1)

  • Sort Key: ((id * 1))
  • Sort Method: top-N heapsort Memory: 25kB
3. 4.036 4.036 ↓ 2.3 8,754 1

Index Scan using pins_product_order_item_idx on pins p (cost=0.43..3,884.31 rows=3,835 width=8) (actual time=0.032..4.036 rows=8,754 loops=1)

  • Index Cond: ((product = 3458) AND (order_item IS NULL))
  • Filter: (id IS NOT NULL)
Planning time : 0.167 ms
Execution time : 6.072 ms