explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EYLv

Settings
# exclusive inclusive rows x rows loops node
1. 13,597.686 275,384.918 ↑ 1.0 16,184,643 1

WindowAgg (cost=11,398,891.38..11,843,992.24 rows=16,185,486 width=1,051) (actual time=205,087.429..275,384.918 rows=16,184,643 loops=1)

2. 243,796.177 261,787.232 ↑ 1.0 16,184,643 1

Sort (cost=11,398,891.38..11,439,355.09 rows=16,185,486 width=1,043) (actual time=205,087.416..261,787.232 rows=16,184,643 loops=1)

  • Sort Key: a.subscriber_id, b.filename_timestamp DESC NULLS LAST, a.application_date DESC, a.completion_date DESC, a.election_type
  • Sort Method: external merge Disk: 4,560,168kB
3. 12,686.334 17,991.055 ↑ 1.0 16,184,643 1

Hash Join (cost=283.02..988,733.31 rows=16,185,486 width=1,043) (actual time=3.963..17,991.055 rows=16,184,643 loops=1)

  • Hash Cond: (a.source_info_uuid = b.uuid)
4. 5,300.921 5,300.921 ↑ 1.0 16,184,643 1

Seq Scan on convey__member_demographics_enrollment_record a (cost=0.00..765,899.86 rows=16,185,486 width=1,035) (actual time=0.057..5,300.921 rows=16,184,643 loops=1)

5. 1.287 3.800 ↑ 1.0 4,401 1

Hash (cost=228.01..228.01 rows=4,401 width=24) (actual time=3.800..3.800 rows=4,401 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 305kB
6. 2.513 2.513 ↑ 1.0 4,401 1

Seq Scan on convey__member_demographics_timing_info b (cost=0.00..228.01 rows=4,401 width=24) (actual time=0.011..2.513 rows=4,401 loops=1)

Planning time : 0.926 ms
Execution time : 276,748.593 ms