explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FWN2

Settings
# exclusive inclusive rows x rows loops node
1. 395.567 409.503 ↑ 13,000.0 1 1

Nested Loop Left Join (cost=6.82..51,927.01 rows=13,000 width=1,228) (actual time=409.482..409.503 rows=1 loops=1)

2. 0.003 10.830 ↑ 1,000.0 1 1

Nested Loop Left Join (cost=6.39..151.18 rows=1,000 width=1,006) (actual time=10.811..10.830 rows=1 loops=1)

3. 0.002 7.053 ↑ 1.0 1 1

Nested Loop Left Join (cost=6.14..130.93 rows=1 width=998) (actual time=7.036..7.053 rows=1 loops=1)

4. 0.003 7.050 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.87..122.63 rows=1 width=946) (actual time=7.033..7.050 rows=1 loops=1)

5. 0.002 7.046 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.58..114.32 rows=1 width=888) (actual time=7.030..7.046 rows=1 loops=1)

6. 0.002 7.042 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.30..106.02 rows=1 width=827) (actual time=7.027..7.042 rows=1 loops=1)

7. 0.003 7.038 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.16..105.86 rows=1 width=800) (actual time=7.024..7.038 rows=1 loops=1)

  • Join Filter: (cs.client_social_education_id = cse.id)
  • Rows Removed by Join Filter: 2
8. 0.003 7.032 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.16..104.70 rows=1 width=776) (actual time=7.018..7.032 rows=1 loops=1)

9. 0.001 7.027 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.88..96.40 rows=1 width=715) (actual time=7.014..7.027 rows=1 loops=1)

10. 0.003 7.022 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.74..96.24 rows=1 width=676) (actual time=7.009..7.022 rows=1 loops=1)

11. 0.002 5.959 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.32..87.80 rows=1 width=672) (actual time=5.947..5.959 rows=1 loops=1)

12. 0.002 5.954 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.19..87.64 rows=1 width=645) (actual time=5.943..5.954 rows=1 loops=1)

13. 0.003 5.949 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.06..87.49 rows=1 width=634) (actual time=5.938..5.949 rows=1 loops=1)

14. 0.002 5.943 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.92..87.33 rows=1 width=603) (actual time=5.933..5.943 rows=1 loops=1)

15. 0.002 5.936 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.79..87.18 rows=1 width=582) (actual time=5.927..5.936 rows=1 loops=1)

16. 0.003 5.137 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.36..78.73 rows=1 width=387) (actual time=5.128..5.137 rows=1 loops=1)

17. 0.002 4.332 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.93..70.28 rows=1 width=366) (actual time=4.324..4.332 rows=1 loops=1)

18. 0.002 3.255 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.51..61.84 rows=1 width=315) (actual time=3.247..3.255 rows=1 loops=1)

19. 0.006 2.106 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.08..53.40 rows=1 width=251) (actual time=2.098..2.106 rows=1 loops=1)

  • Join Filter: (bl.billing_loan_state_id = bls.id)
  • Rows Removed by Join Filter: 13
20. 0.003 2.092 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.08..52.11 rows=1 width=240) (actual time=2.085..2.092 rows=1 loops=1)

  • Join Filter: (ap.obj_id = bl.application_id)
21. 0.003 1.719 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.66..43.66 rows=1 width=232) (actual time=1.713..1.719 rows=1 loops=1)

22. 0.002 1.713 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.39..35.30 rows=1 width=232) (actual time=1.708..1.713 rows=1 loops=1)

23. 0.002 1.701 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.12..33.26 rows=1 width=231) (actual time=1.696..1.701 rows=1 loops=1)

24. 0.002 0.922 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.69..24.82 rows=1 width=210) (actual time=0.918..0.922 rows=1 loops=1)

25. 0.005 0.915 ↑ 1.0 1 1

Nested Loop (cost=0.42..16.46 rows=1 width=193) (actual time=0.911..0.915 rows=1 loops=1)

26. 0.463 0.463 ↑ 1.0 1 1

Index Scan using application_pkey_hash on application ap (cost=0.00..8.02 rows=1 width=145) (actual time=0.460..0.463 rows=1 loops=1)

  • Index Cond: (obj_id = 1629959)
27. 0.447 0.447 ↑ 1.0 1 1

Index Scan using client_pkey on client c (cost=0.42..8.44 rows=1 width=52) (actual time=0.447..0.447 rows=1 loops=1)

  • Index Cond: (id = ap.client_id)
28. 0.005 0.005 ↑ 1.0 1 1

Index Scan using scoring_product_pkey on scoring_product_params scp (cost=0.27..8.29 rows=1 width=21) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (obj_id = ap.scoring_product_params_id)
29. 0.777 0.777 ↑ 1.0 1 1

Index Scan using client_phone_pkey on client_phone p (cost=0.42..8.44 rows=1 width=29) (actual time=0.777..0.777 rows=1 loops=1)

  • Index Cond: (ap.client_phone_id = id)
30. 0.010 0.010 ↓ 0.0 0 1

Index Scan using scoring_client_blocking_client_id_key on scoring_client_blocking s (cost=0.28..2.03 rows=1 width=5) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (client_id = c.id)
31. 0.003 0.003 ↑ 1.0 1 1

Index Scan using scoring_product_pkey on scoring_product_params spp (cost=0.27..8.29 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (ap.scoring_product_params_id = obj_id)
32. 0.370 0.370 ↓ 0.0 0 1

Index Scan using billing_loan_application_id_uniq on billing_loan bl (cost=0.42..8.44 rows=1 width=12) (actual time=0.370..0.370 rows=0 loops=1)

  • Index Cond: (application_id = 1629959)
33. 0.008 0.008 ↑ 1.0 13 1

Seq Scan on billing_loan_state bls (cost=0.00..1.13 rows=13 width=19) (actual time=0.005..0.008 rows=13 loops=1)

34. 1.147 1.147 ↑ 1.0 1 1

Index Scan using client_address_pkey on client_address a (cost=0.42..8.44 rows=1 width=72) (actual time=1.147..1.147 rows=1 loops=1)

  • Index Cond: (id = ap.client_address_id)
35. 1.075 1.075 ↑ 1.0 1 1

Index Scan using client_employment_pkey on client_employment e (cost=0.42..8.44 rows=1 width=59) (actual time=1.075..1.075 rows=1 loops=1)

  • Index Cond: (ap.client_employment_id = id)
36. 0.802 0.802 ↑ 1.0 1 1

Index Scan using client_financial_pkey on client_financial f (cost=0.43..8.45 rows=1 width=29) (actual time=0.802..0.802 rows=1 loops=1)

  • Index Cond: (ap.client_financial_id = id)
37. 0.797 0.797 ↑ 1.0 1 1

Index Scan using client_personal_pkey on client_personal pr (cost=0.43..8.45 rows=1 width=203) (actual time=0.796..0.797 rows=1 loops=1)

  • Index Cond: (ap.client_personal_id = id)
38. 0.005 0.005 ↑ 1.0 1 1

Index Scan using client_employment_state_pkey on client_employment_state ces (cost=0.13..0.15 rows=1 width=29) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (id = e.state_id)
39. 0.003 0.003 ↑ 1.0 1 1

Index Scan using client_employment_type_pkey on client_employment_type cet (cost=0.14..0.15 rows=1 width=39) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (id = e.type_id)
40. 0.003 0.003 ↑ 1.0 1 1

Index Scan using client_personal_gender_pkey on client_personal_gender cpg (cost=0.13..0.15 rows=1 width=19) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (id = pr.gender_id)
41. 0.003 0.003 ↑ 1.0 1 1

Index Scan using client_personal_familystatus_pkey on client_personal_familystatus cpf (cost=0.13..0.15 rows=1 width=35) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (id = pr.familystatus_id)
42. 1.060 1.060 ↑ 1.0 1 1

Index Scan using client_social_pkey on client_social cs (cost=0.42..8.44 rows=1 width=12) (actual time=1.060..1.060 rows=1 loops=1)

  • Index Cond: (id = ap.client_social_id)
43. 0.004 0.004 ↑ 1.0 1 1

Index Scan using client_personal_property_pkey on client_personal_property cpp (cost=0.13..0.15 rows=1 width=47) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (id = pr.client_personal_property_id)
44. 0.002 0.002 ↓ 0.0 0 1

Index Scan using client_veriff_contact_pkey on client_veriff_contact cvc1 (cost=0.29..8.30 rows=1 width=73) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (COALESCE(c.client_veriff_contact_1_id, ap.client_veriff_contact_1_id) = id)
45. 0.003 0.003 ↑ 2.3 3 1

Seq Scan on client_social_education cse (cost=0.00..1.07 rows=7 width=32) (actual time=0.003..0.003 rows=3 loops=1)

46. 0.002 0.002 ↓ 0.0 0 1

Index Scan using client_social_detail_pkey on client_social_detail csd (cost=0.14..0.15 rows=1 width=35) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (cs.client_social_detail_id = id)
47. 0.002 0.002 ↓ 0.0 0 1

Index Scan using client_veriff_contact_pkey on client_veriff_contact cvc2 (cost=0.29..8.30 rows=1 width=73) (actual time=0.001..0.002 rows=0 loops=1)

  • Index Cond: (COALESCE(c.client_veriff_contact_2_id, ap.client_veriff_contact_2_id) = id)
48. 0.001 0.001 ↓ 0.0 0 1

Index Scan using client_veriff_employment_pkey on client_veriff_employment cve (cost=0.28..8.30 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (COALESCE(c.client_veriff_employment_id, ap.client_veriff_employment_id) = id)
49. 0.001 0.001 ↓ 0.0 0 1

Index Scan using client_veriff_marriage_pkey on client_veriff_marriage cvm (cost=0.28..8.29 rows=1 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (COALESCE(c.client_veriff_marriage_id, ap.client_veriff_marriage_id) = id)
50. 3.774 3.774 ↑ 1,000.0 1 1

Function Scan on scor_processing_info r_result (cost=0.25..10.25 rows=1,000 width=8) (actual time=3.773..3.774 rows=1 loops=1)

51. 0.016 3.106 ↑ 13.0 1 1

GroupAggregate (cost=0.43..37.87 rows=13 width=20) (actual time=3.105..3.106 rows=1 loops=1)

  • Group Key: application.client_id
52. 3.090 3.090 ↑ 1.4 9 1

Index Scan using application_client_id_idx on application (cost=0.43..37.38 rows=13 width=9) (actual time=0.380..3.090 rows=9 loops=1)

  • Index Cond: (client_id = ap.client_id)