explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i5vT

Settings
# exclusive inclusive rows x rows loops node
1. 9,357.748 1,090,489.792 ↑ 3.4 11,244 1

GroupAggregate (cost=329,993,446.48..345,929,339.19 rows=37,692 width=40) (actual time=1,079,968.929..1,090,489.792 rows=11,244 loops=1)

  • Group Key: epo.credit_pull_id
  • Planning Time: 0.327 ms
  • Execution Time: 1090511.782 ms
2. 2,747.833 1,081,132.044 ↑ 327.9 4,859,690 1

Sort (cost=329,993,446.48..333,977,301.87 rows=1,593,542,156 width=24) (actual time=1,079,968.747..1,081,132.044 rows=4,859,690 loops=1)

  • Sort Key: epo.credit_pull_id
  • Sort Method: external merge Disk: 144392kB
3. 1,036.772 1,078,384.211 ↑ 327.9 4,859,690 1

Hash Left Join (cost=7,212.60..48,141,430.18 rows=1,593,542,156 width=24) (actual time=9,201.619..1,078,384.211 rows=4,859,690 loops=1)

  • Hash Cond: (epo.attribute_id = ea.id)
4. 171,565.105 1,077,347.269 ↑ 327.9 4,859,690 1

Hash Join (cost=7,187.81..43,924,524.87 rows=1,593,542,156 width=24) (actual time=9,201.411..1,077,347.269 rows=4,859,690 loops=1)

  • Hash Cond: (epo.credit_pull_id = int_dlc.target_id)
5. 905,730.213 905,730.213 ↓ 1.0 1,723,680,573 1

Seq Scan on experian_premier_override epo (cost=0.00..39,439,679.76 rows=1,705,582,433 width=24) (actual time=0.724..905,730.213 rows=1,723,680,573 loops=1)

  • Filter: (((original_value IS NOT NULL) AND (override_value IS NULL)) OR ((original_value IS NULL) AND (override_value IS NOT NULL)) OR ((original_value IS NOT NULL) AND (override_value IS NOT NULL)))
  • Rows Removed by Filter: 16091351
6. 2.074 51.951 ↑ 3.1 11,244 1

Hash (cost=6,747.61..6,747.61 rows=35,216 width=4) (actual time=51.951..51.951 rows=11,244 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 908kB
7. 16.232 49.877 ↑ 3.1 11,244 1

HashAggregate (cost=6,043.29..6,395.45 rows=35,216 width=4) (actual time=47.990..49.877 rows=11,244 loops=1)

  • Group Key: int_dlc.target_id
8. 33.645 33.645 ↓ 1.7 102,773 1

Index Scan using dw_load_control_prcs_sts_i on dw_load_control int_dlc (cost=0.43..5,894.77 rows=59,407 width=4) (actual time=0.020..33.645 rows=102,773 loops=1)

  • Index Cond: (prcs_sts = '2'::smallint)
  • Filter: (((target_type)::text = 'CREDIT'::text) AND ((type)::text = ANY ('{soft_credit,hard_credit,credit_attribute}'::text[])))
  • Rows Removed by Filter: 21322
9. 0.088 0.170 ↓ 1.0 527 1

Hash (cost=18.24..18.24 rows=524 width=16) (actual time=0.170..0.170 rows=527 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 34kB
10. 0.082 0.082 ↓ 1.0 527 1

Seq Scan on experian_attribute ea (cost=0.00..18.24 rows=524 width=16) (actual time=0.008..0.082 rows=527 loops=1)