explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IBm4

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

Limit (cost=5,895.28..5,895.28 rows=1 width=8) (actual time=4.165..4.166 rows=1 loops=1)

2. 1.445 4.164 ↑ 6,286.0 1 1

Sort (cost=5,895.28..5,910.99 rows=6,286 width=8) (actual time=4.163..4.164 rows=1 loops=1)

  • Sort Key: ((id * 1))
  • Sort Method: top-N heapsort Memory: 25kB
3. 2.719 2.719 ↓ 1.2 7,304 1

Index Scan using pins_product_order_item_idx on pins p (cost=0.29..5,863.85 rows=6,286 width=8) (actual time=0.026..2.719 rows=7,304 loops=1)

  • Index Cond: (product = 31)
Planning time : 0.160 ms
Execution time : 4.193 ms