explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t2ec

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 219.726 ↑ 5.1 9 1

Hash Left Join (cost=33,175.15..34,768.64 rows=46 width=163) (actual time=219.674..219.726 rows=9 loops=1)

  • Hash Cond: (cr_a.collection_report_result_id = cr_a_result.id)
2. 0.013 219.678 ↑ 5.1 9 1

Nested Loop Left Join (cost=33,173.95..34,765.42 rows=46 width=497) (actual time=219.645..219.678 rows=9 loops=1)

3. 0.011 219.665 ↑ 5.1 9 1

Hash Left Join (cost=33,173.65..34,660.18 rows=46 width=497) (actual time=219.641..219.665 rows=9 loops=1)

  • Hash Cond: (bl.billing_loan_state_id = bls.id)
4. 0.008 219.639 ↑ 5.1 9 1

Nested Loop Left Join (cost=33,172.36..34,658.72 rows=46 width=462) (actual time=219.620..219.639 rows=9 loops=1)

5. 0.020 219.622 ↑ 5.1 9 1

Hash Left Join (cost=33,171.94..34,559.33 rows=46 width=462) (actual time=219.612..219.622 rows=9 loops=1)

  • Hash Cond: (cp.client_id = sc.client_id)
6. 13.159 219.108 ↑ 5.1 9 1

Hash Right Join (cost=33,139.57..34,526.84 rows=46 width=354) (actual time=219.102..219.108 rows=9 loops=1)

  • Hash Cond: (c.application_id = a.obj_id)
7. 10.334 10.334 ↓ 1.0 41,953 1

Seq Scan on collection c (cost=0.00..1,230.09 rows=41,909 width=16) (actual time=0.004..10.334 rows=41,953 loops=1)

8. 0.011 195.615 ↑ 5.1 9 1

Hash (cost=33,139.00..33,139.00 rows=46 width=342) (actual time=195.615..195.615 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
9. 0.012 195.604 ↑ 5.1 9 1

Nested Loop Left Join (cost=32,014.19..33,139.00 rows=46 width=342) (actual time=194.782..195.604 rows=9 loops=1)

10. 0.012 195.475 ↑ 5.1 9 1

Hash Left Join (cost=32,013.77..32,476.46 rows=46 width=338) (actual time=194.745..195.475 rows=9 loops=1)

  • Hash Cond: (vself.inn = cp.inn)
11. 0.011 0.874 ↑ 5.1 9 1

Nested Loop Left Join (cost=6.08..468.59 rows=46 width=284) (actual time=0.150..0.874 rows=9 loops=1)

  • Join Filter: (ss.obj_id = sgg.service_id)
  • Rows Removed by Join Filter: 5
12. 0.010 0.854 ↑ 5.1 9 1

Nested Loop Left Join (cost=6.08..463.22 rows=46 width=281) (actual time=0.147..0.854 rows=9 loops=1)

13. 0.007 0.826 ↑ 5.1 9 1

Nested Loop Left Join (cost=5.80..393.54 rows=46 width=223) (actual time=0.143..0.826 rows=9 loops=1)

14. 0.012 0.738 ↑ 5.1 9 1

Nested Loop (cost=5.37..287.12 rows=46 width=96) (actual time=0.130..0.738 rows=9 loops=1)

15. 0.048 0.258 ↓ 2.8 39 1

Nested Loop Left Join (cost=4.82..150.51 rows=14 width=81) (actual time=0.039..0.258 rows=39 loops=1)

  • Join Filter: (s.obj_id = sg.service_id)
  • Rows Removed by Join Filter: 86
16. 0.032 0.171 ↓ 2.8 39 1

Nested Loop Left Join (cost=4.82..148.11 rows=14 width=78) (actual time=0.033..0.171 rows=39 loops=1)

17. 0.041 0.061 ↓ 2.8 39 1

Bitmap Heap Scan on scoring_contact_all vall (cost=4.54..59.94 rows=14 width=20) (actual time=0.025..0.061 rows=39 loops=1)

  • Recheck Cond: (inn = '3133204502'::text)
  • Heap Blocks: exact=24
18. 0.020 0.020 ↓ 2.8 39 1

Bitmap Index Scan on scoring_contact_all_inn_idx (cost=0.00..4.54 rows=14 width=0) (actual time=0.019..0.020 rows=39 loops=1)

  • Index Cond: (inn = '3133204502'::text)
19. 0.078 0.078 ↑ 1.0 1 39

Index Scan using service_guide_pkey on service_guide sg (cost=0.28..6.30 rows=1 width=66) (actual time=0.002..0.002 rows=1 loops=39)

  • Index Cond: (obj_id = vall.service_guide_id)
20. 0.034 0.039 ↑ 2.3 3 39

Materialize (cost=0.00..1.10 rows=7 width=11) (actual time=0.000..0.001 rows=3 loops=39)

21. 0.005 0.005 ↑ 1.0 7 1

Seq Scan on service s (cost=0.00..1.07 rows=7 width=11) (actual time=0.003..0.005 rows=7 loops=1)

22. 0.468 0.468 ↓ 0.0 0 39

Index Only Scan using scoring_contact_all_service_id_value_inn_uniq on scoring_contact_all vself (cost=0.56..9.74 rows=2 width=31) (actual time=0.011..0.012 rows=0 loops=39)

  • Index Cond: (value_norm = vall.value_norm)
  • Filter: (inn <> '3133204502'::text)
  • Rows Removed by Filter: 3
  • Heap Fetches: 55
23. 0.081 0.081 ↓ 0.0 0 9

Index Scan using scoring_inn_blocking_inn_scoring_inn_blocking_type_id_key on scoring_inn_blocking si (cost=0.42..2.30 rows=1 width=137) (actual time=0.009..0.009 rows=0 loops=9)

  • Index Cond: (inn = vself.inn)
  • Filter: is_forbidden
24. 0.018 0.018 ↑ 1.0 1 9

Index Scan using service_guide_pkey on service_guide sgg (cost=0.28..1.51 rows=1 width=66) (actual time=0.002..0.002 rows=1 loops=9)

  • Index Cond: (obj_id = vself.service_guide_id)
25. 0.006 0.009 ↑ 3.5 2 9

Materialize (cost=0.00..1.10 rows=7 width=11) (actual time=0.000..0.001 rows=2 loops=9)

26. 0.003 0.003 ↑ 1.2 6 1

Seq Scan on service ss (cost=0.00..1.07 rows=7 width=11) (actual time=0.001..0.003 rows=6 loops=1)

27. 0.006 194.589 ↑ 3.0 1 1

Hash (cost=32,007.65..32,007.65 rows=3 width=64) (actual time=194.589..194.589 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
28. 0.002 194.583 ↑ 3.0 1 1

Subquery Scan on cp (cost=32,007.61..32,007.65 rows=3 width=64) (actual time=194.580..194.583 rows=1 loops=1)

29. 0.004 194.581 ↑ 3.0 1 1

Unique (cost=32,007.61..32,007.62 rows=3 width=309) (actual time=194.578..194.581 rows=1 loops=1)

30. 0.000 194.577 ↑ 1.5 2 1

Sort (cost=32,007.61..32,007.61 rows=3 width=309) (actual time=194.577..194.577 rows=2 loops=1)

  • Sort Key: client_personal.client_id, client_personal.id DESC
  • Sort Method: quicksort Memory: 25kB
31. 6.112 194.644 ↑ 1.5 2 1

Gather (cost=1,000.00..32,007.58 rows=3 width=309) (actual time=70.907..194.644 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
32. 188.532 188.532 ↑ 1.0 1 3

Parallel Seq Scan on client_personal (cost=0.00..31,007.28 rows=1 width=309) (actual time=105.037..188.532 rows=1 loops=3)

  • Filter: (inn = '3133204502'::text)
  • Rows Removed by Filter: 381314
33. 0.117 0.117 ↓ 0.0 0 9

Index Scan using application_m_cl_inn_idx on application a (cost=0.43..14.38 rows=2 width=15) (actual time=0.013..0.013 rows=0 loops=9)

  • Index Cond: (m_cl_inn = vself.inn)
  • Filter: (application_state_id = 10)
  • Rows Removed by Filter: 8
34. 0.258 0.494 ↓ 1.0 708 1

Hash (cost=23.83..23.83 rows=683 width=116) (actual time=0.494..0.494 rows=708 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 112kB
35. 0.236 0.236 ↓ 1.0 708 1

Seq Scan on scoring_client_blocking sc (cost=0.00..23.83 rows=683 width=116) (actual time=0.006..0.236 rows=708 loops=1)

36. 0.009 0.009 ↓ 0.0 0 9

Index Scan using billing_loan_application_id_uniq on billing_loan bl (cost=0.42..2.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=9)

  • Index Cond: (a.obj_id = application_id)
37. 0.007 0.015 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=43) (actual time=0.014..0.015 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
38. 0.008 0.008 ↑ 1.0 13 1

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

39. 0.000 0.000 ↓ 0.0 0 9

Index Scan using collection_report_last_collection_report_id_is_history on collection_report cr_a (cost=0.29..2.28 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=9)

  • Index Cond: ((c.id = collection_id) AND (is_history = false))
  • Filter: (NOT is_history)
40. 0.005 0.012 ↓ 1.1 10 1

Hash (cost=1.09..1.09 rows=9 width=18) (actual time=0.012..0.012 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
41. 0.007 0.007 ↓ 1.1 10 1

Seq Scan on collection_report_result cr_a_result (cost=0.00..1.09 rows=9 width=18) (actual time=0.004..0.007 rows=10 loops=1)