explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qSwm

Settings
# exclusive inclusive rows x rows loops node
1. 219.751 699.953 ↑ 1.0 560,688 1

Hash Left Join (cost=24,563.19..39,489.12 rows=560,688 width=43) (actual time=435.123..699.953 rows=560,688 loops=1)

  • Hash Cond: (((inv.partnumber)::text = (alloc.partnumber)::text) AND ((inv.ffmcenter_name)::text = (alloc.ffmcenter_name)::text))
  • Buffers: shared hit=381777, temp read=1720 written=1720
2. 45.377 45.377 ↑ 1.0 560,688 1

Seq Scan on inventory inv (cost=0.00..9,178.88 rows=560,688 width=23) (actual time=0.010..45.377 rows=560,688 loops=1)

  • Buffers: shared hit=3572
3. 30.808 434.825 ↓ 1.6 62,912 1

Hash (cost=23,991.16..23,991.16 rows=38,135 width=35) (actual time=434.824..434.825 rows=62,912 loops=1)

  • Buckets: 65536 (originally 65536) Batches: 2 (originally 1) Memory Usage: 3585kB
  • Buffers: shared hit=378205, temp written=213
4. 8.683 404.017 ↓ 1.6 62,912 1

Subquery Scan on alloc (cost=0.71..23,991.16 rows=38,135 width=35) (actual time=0.059..404.017 rows=62,912 loops=1)

  • Buffers: shared hit=378205
5. 108.318 395.334 ↓ 1.6 62,912 1

GroupAggregate (cost=0.71..23,609.81 rows=38,135 width=35) (actual time=0.058..395.334 rows=62,912 loops=1)

  • Group Key: allocation_subscription_false.partnumber, allocation_subscription_false.ffmcenter_name
  • Buffers: shared hit=378205
6. 53.071 287.016 ↑ 1.0 381,152 1

Merge Append (cost=0.71..15,601.47 rows=381,350 width=19) (actual time=0.032..287.016 rows=381,152 loops=1)

  • Sort Key: allocation_subscription_false.partnumber, allocation_subscription_false.ffmcenter_name
  • Buffers: shared hit=378205
7. 3.660 3.660 ↓ 1.0 6,121 1

Index Scan using allocation_subscription_false_idx01 on allocation_subscription_false (cost=0.28..194.07 rows=6,119 width=19) (actual time=0.015..3.660 rows=6,121 loops=1)

  • Buffers: shared hit=5930
8. 230.285 230.285 ↑ 1.0 375,031 1

Index Scan using allocation_subscription_true_idx01 on allocation_subscription_true (cost=0.42..11,593.89 rows=375,231 width=19) (actual time=0.012..230.285 rows=375,031 loops=1)

  • Buffers: shared hit=372275
Planning time : 0.709 ms
Execution time : 724.778 ms