explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ceo3

Settings
# exclusive inclusive rows x rows loops node
1. 13,328.284 365,742.666 ↓ 20.3 784,271 1

GroupAggregate (cost=4,325,195.90..4,709,520.36 rows=38,581 width=86) (actual time=321,549.026..365,742.666 rows=784,271 loops=1)

  • Group Key: ams_consignees.consignee_name
2. 309,752.473 352,414.382 ↑ 1.0 11,813,497 1

Sort (cost=4,325,195.90..4,354,729.64 rows=11,813,497 width=51) (actual time=321,548.889..352,414.382 rows=11,813,497 loops=1)

  • Sort Key: ams_consignees.consignee_name
  • Sort Method: external merge Disk: 668984kB
3. 23,558.702 42,661.909 ↑ 1.0 11,813,497 1

Hash Left Join (cost=802,481.74..1,726,114.88 rows=11,813,497 width=51) (actual time=15,212.314..42,661.909 rows=11,813,497 loops=1)

  • Hash Cond: ((ams_consignees.identifier)::text = (ams_lading.identifier)::text)
4. 3,928.264 3,928.264 ↑ 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.026..3,928.264 rows=11,813,497 loops=1)

5. 5,838.980 15,174.943 ↑ 1.0 11,585,633 1

Hash (cost=578,462.33..578,462.33 rows=11,585,633 width=28) (actual time=15,174.943..15,174.943 rows=11,585,633 loops=1)

  • Buckets: 65536 Batches: 256 Memory Usage: 3321kB
6. 9,335.963 9,335.963 ↑ 1.0 11,585,633 1

Seq Scan on ams_lading (cost=0.00..578,462.33 rows=11,585,633 width=28) (actual time=1.738..9,335.963 rows=11,585,633 loops=1)