explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XCBK

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

GroupAggregate (cost=18,532,802.79..18,737,703.26 rows=172,690 width=40) (actual rows= loops=)

  • Group Key: l.loan_id
2. 0.000 0.000 ↓ 0.0

Sort (cost=18,532,802.79..18,600,383.41 rows=27,032,245 width=12) (actual rows= loops=)

  • Sort Key: l.loan_id
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,886.82..13,809,981.41 rows=27,032,245 width=12) (actual rows= loops=)

  • Hash Cond: (l.loan_id = dl.loan_id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on loan_status_archive l (cost=0.00..11,666,312.40 rows=149,636,779 width=12) (actual rows= loops=)

  • Filter: (date <= '2019-04-30'::date)
5. 0.000 0.000 ↓ 0.0

Hash (cost=2,494.06..2,494.06 rows=31,421 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on dim_loan_ownership_transfers dl (cost=0.00..2,494.06 rows=31,421 width=4) (actual rows= loops=)