explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ec71

Settings
# exclusive inclusive rows x rows loops node
1. 0.601 26.003 ↑ 1.5 57 1

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

2. 14.434 25.402 ↑ 1.2 11,036 1

Nested Loop Left Join (cost=137.32..2,520.32 rows=13,128 width=314) (actual time=1.373..25.402 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: 121,990
  • Filter: ((a.created_by_id = 1) OR (ltmb.user_id = 1) OR (cmb.user_id = 1))
  • Rows Removed by Filter: 18,196
3. 1.370 3.048 ↓ 1.3 7,920 1

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

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

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

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

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

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

Hash Left Join (cost=26.49..35.73 rows=393 width=321) (actual time=0.282..0.582 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.086 0.427 ↓ 1.1 438 1

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

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

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

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

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

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

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

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

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

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

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

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

Hash Right Join (cost=1.41..3.06 rows=10 width=15) (actual time=0.033..0.047 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.012..0.013 rows=12 loops=1)

  • Buckets: 1,024 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.006..0.008 rows=12 loops=1)

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

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
18. 0.032 0.032 ↓ 1.0 84 1

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

19. 0.004 0.030 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
20. 0.014 0.026 ↑ 1.0 1 1

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

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

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

22. 0.002 0.008 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
23. 0.006 0.006 ↑ 1.0 1 1

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

  • Filter: is_main
24. 0.005 0.012 ↑ 1.0 20 1

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

  • Buckets: 1,024 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.005..0.007 rows=20 loops=1)

26. 0.011 0.025 ↓ 1.1 18 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
27. 0.014 0.014 ↓ 1.1 18 1

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

28. 0.003 0.007 ↑ 32.0 5 1

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

  • Buckets: 1,024 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.013 ↓ 1.2 24 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
31. 0.008 0.008 ↓ 1.2 24 1

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

32. 0.020 0.024 ↓ 1.5 9 1

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

  • Buckets: 1,024 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.009 ↑ 1.0 9 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
35. 0.005 0.005 ↑ 1.0 9 1

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

36. 0.489 0.623 ↓ 8.8 7,823 1

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

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

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

38. 7.886 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.017 0.034 ↓ 1.5 19 1

Hash Right Join (cost=1.16..2.34 rows=13 width=12) (actual time=0.027..0.034 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.007 0.012 ↓ 1.1 8 1

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

  • Buckets: 1,024 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 : 3.425 ms
Execution time : 26.234 ms