explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J5oM

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,739,926.36..1,740,312.17 rows=38,581 width=54) (actual rows= loops=)

  • Group Key: ams_consignees.consignee_name
2. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: ((ams_consignees.identifier)::text = (ams_lading.identifier)::text)
3. 0.000 0.000 ↓ 0.0

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

4. 0.000 0.000 ↓ 0.0

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

5. 0.000 0.000 ↓ 0.0

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