explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uYUd

Settings
# exclusive inclusive rows x rows loops node
1. 122.121 163.498 ↑ 1.0 520,755 1

Hash Left Join (cost=52.90..13,915.19 rows=520,755 width=43) (actual time=0.028..163.498 rows=520,755 loops=1)

  • Hash Cond: (((inv.partnumber)::text = (alloc.partnumber)::text) AND ((inv.ffmcenter_name)::text = (alloc.ffmcenter_name)::text))
  • Buffers: shared hit=3317
2. 41.373 41.373 ↑ 1.0 520,755 1

Seq Scan on inventory inv (cost=0.00..8,524.55 rows=520,755 width=23) (actual time=0.007..41.373 rows=520,755 loops=1)

  • Buffers: shared hit=3317
3. 0.000 0.004 ↓ 0.0 0 1

Hash (cost=49.90..49.90 rows=200 width=180) (actual time=0.004..0.004 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
4. 0.000 0.004 ↓ 0.0 0 1

Subquery Scan on alloc (cost=45.90..49.90 rows=200 width=180) (actual time=0.004..0.004 rows=0 loops=1)

5. 0.002 0.004 ↓ 0.0 0 1

HashAggregate (cost=45.90..47.90 rows=200 width=180) (actual time=0.003..0.004 rows=0 loops=1)

  • Group Key: allocation_subscription_false.partnumber, allocation_subscription_false.ffmcenter_name
6. 0.000 0.002 ↓ 0.0 0 1

Append (cost=0.00..31.10 rows=740 width=164) (actual time=0.002..0.002 rows=0 loops=1)

7. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on allocation_subscription_false (cost=0.00..13.70 rows=370 width=164) (actual time=0.001..0.001 rows=0 loops=1)

8. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on allocation_subscription_true (cost=0.00..13.70 rows=370 width=164) (actual time=0.001..0.001 rows=0 loops=1)

Planning time : 0.727 ms
Execution time : 186.908 ms