explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R6Su

Settings
# exclusive inclusive rows x rows loops node
1. 0.545 25.752 ↑ 1.5 57 1

Unique (cost=137.32..2,553.14 rows=83 width=314) (actual time=1.198..25.752 rows=57 loops=1)

2. 14.417 25.207 ↑ 1.2 11,036 1

Nested Loop Left Join (cost=137.32..2,520.32 rows=13,128 width=314) (actual time=1.197..25.207 rows=11,036 loops=1)

  • Join Filter: ((c.id = t.committee_id) OR ((c.branch_id = a.branch_id) AND (c.branch_id <> 1)))
  • Rows Removed by Join Filter: 121990
  • Filter: ((a.created_by_id = 1) OR (ltmb.user_id = 1) OR (cmb.user_id = 1))
  • Rows Removed by Filter: 18196
3. 1.364 2.870 ↓ 1.3 7,920 1

Merge Left Join (cost=136.16..233.58 rows=6,298 width=325) (actual time=1.129..2.870 rows=7,920 loops=1)

  • Merge Cond: (a.id = t.application_id)
4. 0.257 0.896 ↓ 1.2 690 1

Sort (cost=72.93..74.41 rows=590 width=321) (actual time=0.861..0.896 rows=690 loops=1)

  • Sort Key: a.id
  • Sort Method: quicksort Memory: 126kB
5. 0.135 0.639 ↓ 1.2 690 1

Hash Left Join (cost=27.69..45.78 rows=590 width=321) (actual time=0.221..0.639 rows=690 loops=1)

  • Hash Cond: (lt.id = ltmb.lsm_team_id)
6. 0.118 0.496 ↓ 1.1 438 1

Hash Left Join (cost=26.49..35.73 rows=393 width=321) (actual time=0.207..0.496 rows=438 loops=1)

  • Hash Cond: (ltcf.lsm_team_id = lt.id)
  • Join Filter: ((lt.branch_id = 1) OR (lt.branch_id = a.branch_id))
  • Rows Removed by Join Filter: 250
7. 0.079 0.370 ↓ 1.1 438 1

Hash Left Join (cost=25.35..32.77 rows=393 width=321) (actual time=0.193..0.370 rows=438 loops=1)

  • Hash Cond: (a.appraisal_id = ltcf.appraisal_id)
8. 0.025 0.279 ↓ 1.0 84 1

Hash Join (cost=23.90..26.66 rows=83 width=321) (actual time=0.175..0.279 rows=84 loops=1)

  • Hash Cond: (a.appraisal_id = aa.id)
9. 0.025 0.246 ↓ 1.0 84 1

Hash Join (cost=10.30..12.83 rows=83 width=99) (actual time=0.161..0.246 rows=84 loops=1)

  • Hash Cond: (a.created_by_id = u.id)
10. 0.024 0.200 ↓ 1.0 84 1

Hash Join (cost=8.92..11.18 rows=83 width=86) (actual time=0.135..0.200 rows=84 loops=1)

  • Hash Cond: (a.status_id = s.id)
11. 0.020 0.165 ↓ 1.0 84 1

Hash Left Join (cost=7.47..9.47 rows=83 width=72) (actual time=0.119..0.165 rows=84 loops=1)

  • Hash Cond: (a.id = able.application_id)
12. 0.024 0.116 ↓ 1.0 84 1

Hash Right Join (cost=5.27..6.95 rows=83 width=56) (actual time=0.084..0.116 rows=84 loops=1)

  • Hash Cond: (abi.application_id = a.id)
13. 0.018 0.039 ↓ 1.2 12 1

Hash Right Join (cost=1.41..3.06 rows=10 width=15) (actual time=0.026..0.039 rows=12 loops=1)

  • Hash Cond: (ic.id = abi.individual_customer_id)
14. 0.008 0.008 ↓ 1.2 47 1

Seq Scan on individual_customer ic (cost=0.00..1.40 rows=40 width=15) (actual time=0.005..0.008 rows=47 loops=1)

15. 0.005 0.013 ↓ 1.2 12 1

Hash (cost=1.28..1.28 rows=10 width=8) (actual time=0.013..0.013 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
16. 0.008 0.008 ↓ 1.2 12 1

Seq Scan on application_borrower_individual abi (cost=0.00..1.28 rows=10 width=8) (actual time=0.005..0.008 rows=12 loops=1)

  • Filter: is_main
  • Rows Removed by Filter: 20
17. 0.024 0.053 ↓ 1.0 84 1

Hash (cost=2.83..2.83 rows=83 width=45) (actual time=0.053..0.053 rows=84 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
18. 0.029 0.029 ↓ 1.0 84 1

Seq Scan on application a (cost=0.00..2.83 rows=83 width=45) (actual time=0.006..0.029 rows=84 loops=1)

19. 0.004 0.029 ↑ 1.0 1 1

Hash (cost=2.18..2.18 rows=1 width=20) (actual time=0.029..0.029 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
20. 0.010 0.025 ↑ 1.0 1 1

Hash Right Join (cost=1.02..2.18 rows=1 width=20) (actual time=0.021..0.025 rows=1 loops=1)

  • Hash Cond: (lec.id = able.legal_entity_customer_id)
21. 0.005 0.005 ↓ 1.2 13 1

Seq Scan on legal_entity_customer lec (cost=0.00..1.11 rows=11 width=20) (actual time=0.004..0.005 rows=13 loops=1)

22. 0.006 0.010 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
23. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on application_borrower_legal_entity able (cost=0.00..1.01 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

  • Filter: is_main
24. 0.004 0.011 ↑ 1.0 20 1

Hash (cost=1.20..1.20 rows=20 width=18) (actual time=0.011..0.011 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
25. 0.007 0.007 ↑ 1.0 20 1

Seq Scan on status s (cost=0.00..1.20 rows=20 width=18) (actual time=0.004..0.007 rows=20 loops=1)

26. 0.006 0.021 ↓ 1.1 18 1

Hash (cost=1.17..1.17 rows=17 width=17) (actual time=0.021..0.021 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
27. 0.015 0.015 ↓ 1.1 18 1

Seq Scan on "user" u (cost=0.00..1.17 rows=17 width=17) (actual time=0.012..0.015 rows=18 loops=1)

28. 0.004 0.008 ↑ 32.0 5 1

Hash (cost=11.60..11.60 rows=160 width=222) (actual time=0.008..0.008 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.004 0.004 ↑ 32.0 5 1

Seq Scan on appraisal aa (cost=0.00..11.60 rows=160 width=222) (actual time=0.004..0.004 rows=5 loops=1)

30. 0.005 0.012 ↓ 1.2 24 1

Hash (cost=1.20..1.20 rows=20 width=8) (actual time=0.012..0.012 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
31. 0.007 0.007 ↓ 1.2 24 1

Seq Scan on lsm_team_config ltcf (cost=0.00..1.20 rows=20 width=8) (actual time=0.004..0.007 rows=24 loops=1)

32. 0.004 0.008 ↓ 1.5 9 1

Hash (cost=1.06..1.06 rows=6 width=8) (actual time=0.008..0.008 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
33. 0.004 0.004 ↓ 1.5 9 1

Seq Scan on lsm_team lt (cost=0.00..1.06 rows=6 width=8) (actual time=0.003..0.004 rows=9 loops=1)

34. 0.004 0.008 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=8) (actual time=0.008..0.008 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
35. 0.004 0.004 ↑ 1.0 9 1

Seq Scan on lsm_team_member ltmb (cost=0.00..1.09 rows=9 width=8) (actual time=0.003..0.004 rows=9 loops=1)

36. 0.465 0.610 ↓ 8.8 7,823 1

Sort (cost=63.23..65.45 rows=886 width=8) (actual time=0.265..0.610 rows=7,823 loops=1)

  • Sort Key: t.application_id
  • Sort Method: quicksort Memory: 66kB
37. 0.145 0.145 ↓ 1.0 889 1

Seq Scan on timeline t (cost=0.00..19.86 rows=886 width=8) (actual time=0.007..0.145 rows=889 loops=1)

38. 7.893 7.920 ↓ 1.5 19 7,920

Materialize (cost=1.16..2.41 rows=13 width=12) (actual time=0.000..0.001 rows=19 loops=7,920)

39. 0.013 0.027 ↓ 1.5 19 1

Hash Right Join (cost=1.16..2.34 rows=13 width=12) (actual time=0.020..0.027 rows=19 loops=1)

  • Hash Cond: (cmb.committee_id = c.id)
40. 0.005 0.005 ↓ 1.3 17 1

Seq Scan on committee_member cmb (cost=0.00..1.13 rows=13 width=8) (actual time=0.004..0.005 rows=17 loops=1)

41. 0.004 0.009 ↓ 1.1 8 1

Hash (cost=1.07..1.07 rows=7 width=8) (actual time=0.009..0.009 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
42. 0.005 0.005 ↓ 1.1 8 1

Seq Scan on committee c (cost=0.00..1.07 rows=7 width=8) (actual time=0.004..0.005 rows=8 loops=1)

Planning time : 2.919 ms
Execution time : 25.888 ms