explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KIhv

Settings
# exclusive inclusive rows x rows loops node
1. 26.179 23,404.752 ↓ 3,092.3 9,277 1

Nested Loop Left Join (cost=4.64..123.83 rows=3 width=441) (actual time=12.348..23,404.752 rows=9,277 loops=1)

2. 8.237 10,552.507 ↓ 3,938.0 3,938 1

Nested Loop Left Join (cost=3.95..80.15 rows=1 width=336) (actual time=8.699..10,552.507 rows=3,938 loops=1)

3. 10.654 10,469.448 ↓ 3,938.0 3,938 1

Nested Loop Left Join (cost=3.67..72.24 rows=1 width=112) (actual time=8.664..10,469.448 rows=3,938 loops=1)

4. 6.359 9,958.668 ↓ 3,938.0 3,938 1

Nested Loop Left Join (cost=3.25..63.79 rows=1 width=107) (actual time=6.838..9,958.668 rows=3,938 loops=1)

5. 7.505 9,924.743 ↓ 3,938.0 3,938 1

Nested Loop Left Join (cost=2.83..58.16 rows=1 width=107) (actual time=6.340..9,924.743 rows=3,938 loops=1)

6. 10.274 9,901.486 ↓ 3,938.0 3,938 1

Nested Loop Left Join (cost=2.40..49.99 rows=1 width=91) (actual time=6.330..9,901.486 rows=3,938 loops=1)

7. 11.115 9,832.142 ↓ 3,938.0 3,938 1

Nested Loop Left Join (cost=1.98..41.86 rows=1 width=87) (actual time=5.162..9,832.142 rows=3,938 loops=1)

8. 16.426 7,981.981 ↓ 3,938.0 3,938 1

Nested Loop Left Join (cost=1.56..33.66 rows=1 width=83) (actual time=2.894..7,981.981 rows=3,938 loops=1)

9. 9.425 2,487.797 ↓ 3,938.0 3,938 1

Nested Loop Left Join (cost=0.99..25.06 rows=1 width=64) (actual time=0.634..2,487.797 rows=3,938 loops=1)

10. 7.474 1,314.796 ↓ 3,931.0 3,931 1

Nested Loop (cost=0.57..16.61 rows=1 width=56) (actual time=0.035..1,314.796 rows=3,931 loops=1)

11. 1,256.219 1,256.219 ↓ 3,931.0 3,931 1

Index Scan using application_application_id_refinance_ind_infinity on application a (cost=0.28..8.29 rows=1 width=32) (actual time=0.027..1,256.219 rows=3,931 loops=1)

12. 51.103 51.103 ↑ 1.0 1 3,931

Index Scan using refinance_offer_refinance_offer_id on refinance_offer ro (cost=0.29..8.31 rows=1 width=32) (actual time=0.012..0.013 rows=1 loops=3,931)

  • Index Cond: (refinance_offer_id = a.application_source_id)
  • Filter: (upper(asserted) = 'infinity'::timestamp with time zone)
  • Rows Removed by Filter: 0
13. 1,163.576 1,163.576 ↑ 1.0 1 3,931

Index Scan using loan_application_id_infinity on loan l (cost=0.42..8.44 rows=1 width=12) (actual time=0.296..0.296 rows=1 loops=3,931)

  • Index Cond: (a.application_id = application_id)
14. 5,477.758 5,477.758 ↑ 1.0 1 3,938

Index Scan using loan_status_archive_date_loan_id_rename on loan_status_archive base_lsa (cost=0.57..8.59 rows=1 width=31) (actual time=1.391..1.391 rows=1 loops=3,938)

  • Index Cond: ((date = (a.application_created_at)::date) AND (loan_id = ro.base_loan_id))
15. 1,839.046 1,839.046 ↑ 1.0 1 3,938

Index Scan using loan_setup_entity_loan_id on loan_setup_entity lse (cost=0.42..8.20 rows=1 width=8) (actual time=0.467..0.467 rows=1 loops=3,938)

  • Index Cond: (loan_id = l.loan_pro_loan_id)
16. 59.070 59.070 ↑ 1.0 1 3,938

Index Scan using loan_entity_loan_id on loan_entity le (cost=0.42..8.12 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=3,938)

  • Index Cond: (id = l.loan_pro_loan_id)
17. 15.752 15.752 ↑ 1.0 1 3,938

Index Scan using loan_settings_entity_loan_id on loan_settings_entity lsse (cost=0.42..8.16 rows=1 width=24) (actual time=0.003..0.004 rows=1 loops=3,938)

  • Index Cond: (loan_id = l.loan_pro_loan_id)
18. 27.566 27.566 ↑ 1.0 1 3,938

Index Only Scan using loan_settings_entity_loan_id on loan_settings_entity base_lsse (cost=0.42..5.62 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=3,938)

  • Index Cond: (loan_id = ro.base_loan_id)
  • Heap Fetches: 2,888
19. 500.126 500.126 ↑ 1.0 1 3,938

Index Scan using app_parsed_application_id on app_parsed ap (cost=0.42..8.44 rows=1 width=13) (actual time=0.125..0.127 rows=1 loops=3,938)

  • Index Cond: (application_id = a.application_id)
20. 74.822 74.822 ↑ 1.0 1 3,938

Index Scan using note_entity_parent_id_refinanced on note_entity ne (cost=0.28..7.90 rows=1 width=228) (actual time=0.018..0.019 rows=1 loops=3,938)

  • Index Cond: (parent_id = l.loan_pro_loan_id)
21. 12,826.066 12,826.066 ↑ 5.0 2 3,938

Index Scan using custom_field__entity_entity_id_entity_type_custom_field_id on custom_field__entity cfe (cost=0.69..43.58 rows=10 width=117) (actual time=1.338..3.257 rows=2 loops=3,938)

  • Index Cond: ((entity_id = lsse.id) AND (custom_field_id = ANY ('{1,73,100,52}'::integer[])))
Planning time : 108.502 ms
Execution time : 23,513.301 ms