explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iTVQ

Settings
# exclusive inclusive rows x rows loops node
1. 8,436.701 37,876.410 ↓ 20.3 784,271 1

HashAggregate (cost=1,739,926.36..1,740,312.17 rows=38,581 width=54) (actual time=37,536.790..37,876.410 rows=784,271 loops=1)

  • Group Key: ams_consignees.consignee_name
2. 14,104.055 29,439.709 ↑ 1.0 11,813,497 1

Hash Left Join (cost=779,853.74..1,680,858.88 rows=11,813,497 width=36) (actual time=10,830.777..29,439.709 rows=11,813,497 loops=1)

  • Hash Cond: ((ams_consignees.identifier)::text = (ams_lading.identifier)::text)
3. 4,556.818 4,556.818 ↑ 1.0 11,813,497 1

Seq Scan on ams_consignees (cost=0.00..334,976.97 rows=11,813,497 width=36) (actual time=0.015..4,556.818 rows=11,813,497 loops=1)

4. 4,502.428 10,778.836 ↑ 1.0 11,585,633 1

Hash (cost=578,462.33..578,462.33 rows=11,585,633 width=13) (actual time=10,778.836..10,778.836 rows=11,585,633 loops=1)

  • Buckets: 131072 Batches: 256 Memory Usage: 3023kB
5. 6,276.408 6,276.408 ↑ 1.0 11,585,633 1

Seq Scan on ams_lading (cost=0.00..578,462.33 rows=11,585,633 width=13) (actual time=1.000..6,276.408 rows=11,585,633 loops=1)

Planning time : 0.571 ms
Execution time : 37,943.166 ms