explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hjVS

Settings
# exclusive inclusive rows x rows loops node
1. 0.057 1,026.675 ↑ 1.0 1 1

Aggregate (cost=3,333.68..3,333.69 rows=1 width=32) (actual time=1,026.675..1,026.675 rows=1 loops=1)

2.          

CTE objdb

3. 0.002 1,026.597 ↑ 10.0 1 1

Limit (cost=1,005.53..3,333.42 rows=10 width=1,006) (actual time=1,026.449..1,026.597 rows=1 loops=1)

4. 0.009 1,026.595 ↑ 492.0 1 1

Nested Loop Left Join (cost=1,005.53..115,537.72 rows=492 width=1,006) (actual time=1,026.448..1,026.595 rows=1 loops=1)

5. 0.003 1,026.582 ↑ 492.0 1 1

Nested Loop Left Join (cost=1,005.26..115,366.62 rows=492 width=969) (actual time=1,026.436..1,026.582 rows=1 loops=1)

6. 0.003 1,026.576 ↑ 492.0 1 1

Nested Loop Left Join (cost=1,004.98..115,221.19 rows=492 width=908) (actual time=1,026.430..1,026.576 rows=1 loops=1)

7. 0.007 1,026.569 ↑ 492.0 1 1

Nested Loop Left Join (cost=1,004.70..115,070.19 rows=492 width=844) (actual time=1,026.423..1,026.569 rows=1 loops=1)

8. 0.002 1,026.556 ↑ 492.0 1 1

Nested Loop Left Join (cost=1,004.41..114,919.19 rows=492 width=780) (actual time=1,026.411..1,026.556 rows=1 loops=1)

  • Join Filter: (cpf.id = pr.familystatus_id)
  • Rows Removed by Join Filter: 1
9. 0.002 1,026.548 ↑ 492.0 1 1

Nested Loop Left Join (cost=1,004.41..114,882.97 rows=492 width=753) (actual time=1,026.403..1,026.548 rows=1 loops=1)

  • Join Filter: (cpg.id = pr.gender_id)
10. 0.004 1,026.541 ↑ 492.0 1 1

Nested Loop Left Join (cost=1,004.41..114,868.80 rows=492 width=742) (actual time=1,026.397..1,026.541 rows=1 loops=1)

  • Join Filter: (cpp.id = pr.client_personal_property_id)
  • Rows Removed by Join Filter: 5
11. 0.005 1,026.527 ↑ 492.0 1 1

Nested Loop Left Join (cost=1,004.41..114,825.31 rows=492 width=703) (actual time=1,026.383..1,026.527 rows=1 loops=1)

  • Join Filter: (cs.client_social_detail_id = csd.id)
  • Rows Removed by Join Filter: 11
12. 0.003 1,026.507 ↑ 492.0 1 1

Nested Loop Left Join (cost=1,004.41..114,744.09 rows=492 width=676) (actual time=1,026.364..1,026.507 rows=1 loops=1)

  • Join Filter: (cs.client_social_education_id = cse.id)
  • Rows Removed by Join Filter: 2
13. 0.005 1,026.497 ↑ 492.0 1 1

Nested Loop Left Join (cost=1,004.41..114,694.02 rows=492 width=652) (actual time=1,026.354..1,026.497 rows=1 loops=1)

  • Join Filter: (cet.id = e.type_id)
  • Rows Removed by Join Filter: 13
14. 0.005 1,026.471 ↑ 492.0 1 1

Nested Loop Left Join (cost=1,004.41..114,599.42 rows=492 width=621) (actual time=1,026.328..1,026.471 rows=1 loops=1)

  • Join Filter: (ces.id = e.state_id)
  • Rows Removed by Join Filter: 5
15. 0.085 1,026.450 ↑ 492.0 1 1

Merge Left Join (cost=1,004.41..114,556.58 rows=492 width=600) (actual time=1,026.308..1,026.450 rows=1 loops=1)

  • Merge Cond: (c.id = s.client_id)
16. 0.000 1,026.147 ↑ 492.0 1 1

Gather Merge (cost=1,004.14..114,495.84 rows=492 width=599) (actual time=1,025.934..1,026.147 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
17. 0.005 2,971.986 ↓ 0.0 0 3

Nested Loop Left Join (cost=4.11..113,439.03 rows=205 width=599) (actual time=990.615..990.662 rows=0 loops=3)

18. 0.006 2,971.971 ↓ 0.0 0 3

Nested Loop Left Join (cost=3.69..113,332.42 rows=205 width=595) (actual time=990.610..990.657 rows=0 loops=3)

19. 0.008 2,971.950 ↓ 0.0 0 3

Nested Loop Left Join (cost=3.41..113,271.37 rows=205 width=594) (actual time=990.603..990.650 rows=0 loops=3)

20. 0.005 2,971.926 ↓ 0.0 0 3

Nested Loop Left Join (cost=3.13..113,158.73 rows=205 width=593) (actual time=990.596..990.642 rows=0 loops=3)

21. 0.003 2,971.911 ↓ 0.0 0 3

Nested Loop Left Join (cost=2.70..112,996.58 rows=205 width=572) (actual time=990.591..990.637 rows=0 loops=3)

22. 0.003 2,971.899 ↓ 0.0 0 3

Nested Loop Left Join (cost=2.27..112,884.16 rows=205 width=521) (actual time=990.587..990.633 rows=0 loops=3)

23. 0.004 2,971.890 ↓ 0.0 0 3

Nested Loop Left Join (cost=1.98..112,809.70 rows=205 width=434) (actual time=990.584..990.630 rows=0 loops=3)

24. 0.006 2,971.875 ↓ 0.0 0 3

Nested Loop Left Join (cost=1.69..112,735.25 rows=205 width=347) (actual time=990.579..990.625 rows=0 loops=3)

25. 0.004 2,971.860 ↓ 0.0 0 3

Nested Loop Left Join (cost=1.27..112,623.31 rows=205 width=283) (actual time=990.575..990.620 rows=0 loops=3)

26. 430.969 2,971.833 ↓ 0.0 0 3

Nested Loop (cost=0.85..112,511.35 rows=205 width=274) (actual time=990.566..990.611 rows=0 loops=3)

27. 585.897 585.897 ↑ 1.3 93,094 3

Parallel Index Scan using client_pkey on client c (cost=0.42..25,914.21 rows=116,554 width=71) (actual time=0.009..195.299 rows=93,094 loops=3)

28. 1,954.967 1,954.967 ↓ 0.0 0 279,281

Index Scan using client_personal_pkey on client_personal pr (cost=0.42..0.74 rows=1 width=215) (actual time=0.007..0.007 rows=0 loops=279,281)

  • Index Cond: (id = c.personal_id)
  • Filter: ((is_history IS FALSE) AND (((((lname || ' '::text) || fname) || ' '::text) || mname) = 'Риба Павло Йосипович'::text))
  • Rows Removed by Filter: 1
29. 0.023 0.023 ↑ 1.0 1 1

Index Scan using client_phone_pkey on client_phone p (cost=0.42..0.55 rows=1 width=17) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: (c.phone_id = id)
30. 0.009 0.009 ↑ 1.0 1 1

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

  • Index Cond: (c.address_id = id)
31. 0.011 0.011 ↑ 1.0 1 1

Index Scan using location_ns_pkey on location loc_s (cost=0.29..0.36 rows=1 width=95) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (id = a.location_id)
32. 0.006 0.006 ↑ 1.0 1 1

Index Scan using location_ns_pkey on location loc_r (cost=0.29..0.36 rows=1 width=95) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (id = a.is_same_reg_location_id)
33. 0.009 0.009 ↑ 1.0 1 1

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

  • Index Cond: (c.employment_id = id)
34. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: (c.financial_id = id)
35. 0.016 0.016 ↑ 1.0 1 1

Index Scan using scoring_inn_blocking_inn_key on scoring_inn_blocking sbinn (cost=0.28..0.55 rows=1 width=12) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (inn = pr.inn)
36. 0.015 0.015 ↓ 0.0 0 1

Index Scan using scoring_telephone_blocking_tel_key on scoring_telephone_blocking sbtel (cost=0.28..0.30 rows=1 width=15) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (tel = p.main)
37. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: (id = c.social_id)
38. 0.218 0.218 ↓ 1.1 430 1

Index Scan using scoring_client_blocking_client_id_key on scoring_client_blocking s (cost=0.27..58.49 rows=402 width=5) (actual time=0.018..0.218 rows=430 loops=1)

39. 0.008 0.016 ↑ 1.0 6 1

Materialize (cost=0.00..1.09 rows=6 width=29) (actual time=0.012..0.016 rows=6 loops=1)

40. 0.008 0.008 ↑ 1.0 6 1

Seq Scan on client_employment_state ces (cost=0.00..1.06 rows=6 width=29) (actual time=0.006..0.008 rows=6 loops=1)

41. 0.013 0.021 ↑ 1.0 13 1

Materialize (cost=0.00..1.19 rows=13 width=39) (actual time=0.011..0.021 rows=13 loops=1)

42. 0.008 0.008 ↑ 1.0 13 1

Seq Scan on client_employment_type cet (cost=0.00..1.13 rows=13 width=39) (actual time=0.005..0.008 rows=13 loops=1)

43. 0.003 0.007 ↑ 2.3 3 1

Materialize (cost=0.00..1.10 rows=7 width=32) (actual time=0.005..0.007 rows=3 loops=1)

44. 0.004 0.004 ↑ 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.004 rows=3 loops=1)

45. 0.009 0.015 ↑ 1.0 11 1

Materialize (cost=0.00..1.17 rows=11 width=35) (actual time=0.007..0.015 rows=11 loops=1)

46. 0.006 0.006 ↑ 1.0 11 1

Seq Scan on client_social_detail csd (cost=0.00..1.11 rows=11 width=35) (actual time=0.003..0.006 rows=11 loops=1)

47. 0.006 0.010 ↑ 1.0 6 1

Materialize (cost=0.00..1.09 rows=6 width=47) (actual time=0.007..0.010 rows=6 loops=1)

48. 0.004 0.004 ↑ 1.0 6 1

Seq Scan on client_personal_property cpp (cost=0.00..1.06 rows=6 width=47) (actual time=0.003..0.004 rows=6 loops=1)

49. 0.002 0.005 ↑ 2.0 1 1

Materialize (cost=0.00..1.03 rows=2 width=19) (actual time=0.005..0.005 rows=1 loops=1)

50. 0.003 0.003 ↑ 2.0 1 1

Seq Scan on client_personal_gender cpg (cost=0.00..1.02 rows=2 width=19) (actual time=0.002..0.003 rows=1 loops=1)

51. 0.003 0.006 ↑ 2.5 2 1

Materialize (cost=0.00..1.07 rows=5 width=35) (actual time=0.005..0.006 rows=2 loops=1)

52. 0.003 0.003 ↑ 2.5 2 1

Seq Scan on client_personal_familystatus cpf (cost=0.00..1.05 rows=5 width=35) (actual time=0.002..0.003 rows=2 loops=1)

53. 0.006 0.006 ↓ 0.0 0 1

Index Scan using client_veriff_contact_pkey on client_veriff_contact cvc1 (cost=0.29..0.31 rows=1 width=72) (actual time=0.005..0.006 rows=0 loops=1)

  • Index Cond: (c.client_veriff_contact_1_id = id)
54. 0.004 0.004 ↓ 0.0 0 1

Index Scan using client_veriff_contact_pkey on client_veriff_contact cvc2 (cost=0.29..0.31 rows=1 width=72) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (c.client_veriff_contact_2_id = id)
55. 0.003 0.003 ↓ 0.0 0 1

Index Scan using client_veriff_employment_pkey on client_veriff_employment cve (cost=0.28..0.30 rows=1 width=69) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (c.client_veriff_employment_id = id)
56. 0.004 0.004 ↓ 0.0 0 1

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

  • Index Cond: (c.client_veriff_marriage_id = id)
57. 1,026.618 1,026.618 ↑ 10.0 1 1

CTE Scan on objdb (cost=0.00..0.20 rows=10 width=24) (actual time=1,026.469..1,026.618 rows=1 loops=1)