explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eb2L

Settings
# exclusive inclusive rows x rows loops node
1. 6.712 69.415 ↓ 17.4 8,034 1

HashAggregate (cost=20,846.90..20,851.53 rows=463 width=8) (actual time=67.570..69.415 rows=8,034 loops=1)

  • Group Key: p.product_id
2. 15.260 62.703 ↓ 27.2 12,600 1

Nested Loop (cost=4,735.74..20,845.74 rows=463 width=8) (actual time=24.642..62.703 rows=12,600 loops=1)

3. 7.737 34.843 ↓ 11.2 12,600 1

Hash Join (cost=4,735.31..19,545.04 rows=1,126 width=16) (actual time=24.631..34.843 rows=12,600 loops=1)

  • Hash Cond: (pn.product_id = pl.product_id)
4. 2.541 3.090 ↓ 1.1 8,226 1

Bitmap Heap Scan on product_node pn (cost=399.97..13,095.21 rows=7,683 width=8) (actual time=0.582..3.090 rows=8,226 loops=1)

  • Recheck Cond: (node_id = 1310)
  • Heap Blocks: exact=305
5. 0.549 0.549 ↓ 1.1 8,226 1

Bitmap Index Scan on pn_idx_nodeid (cost=0.00..398.05 rows=7,683 width=0) (actual time=0.549..0.549 rows=8,226 loops=1)

  • Index Cond: (node_id = 1310)
6. 11.719 24.016 ↑ 1.0 45,857 1

Hash (cost=3,755.97..3,755.97 rows=46,350 width=8) (actual time=24.016..24.016 rows=45,857 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 1792kB
7. 12.297 12.297 ↑ 1.0 45,857 1

Index Only Scan using pld_idx_logical_key on pricelistdetail pl (cost=0.42..3,755.97 rows=46,350 width=8) (actual time=0.012..12.297 rows=45,857 loops=1)

  • Index Cond: (pricelist_id = ANY ('{15,74}'::bigint[]))
  • Heap Fetches: 0
8. 12.600 12.600 ↑ 1.0 1 12,600

Index Only Scan using product_pkey on product p (cost=0.42..1.15 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=12,600)

  • Index Cond: (product_id = pl.product_id)
  • Heap Fetches: 0