explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CDiZ : list

Settings
# exclusive inclusive rows x rows loops node
1. 3.897 20,512.628 ↑ 7.3 40 1

WindowAgg (cost=35.33..1,390,778.41 rows=293 width=575) (actual time=389.379..20,512.628 rows=40 loops=1)

2. 0.363 1.491 ↑ 7.3 40 1

Merge Left Join (cost=35.33..40.54 rows=293 width=326) (actual time=1.030..1.491 rows=40 loops=1)

  • Merge Cond: (prop."ProposalId" = jira."ProposalId")
3. 0.182 0.990 ↑ 4.1 40 1

Sort (cost=30.48..30.89 rows=163 width=319) (actual time=0.888..0.990 rows=40 loops=1)

  • Sort Key: prop."ProposalId" DESC
  • Sort Method: quicksort Memory: 45kB
4. 0.055 0.808 ↑ 4.1 40 1

Hash Left Join (cost=18.46..24.49 rows=163 width=319) (actual time=0.561..0.808 rows=40 loops=1)

  • Hash Cond: (prop."ProposalStatus" = lkp."Lookup_Code")
5. 0.049 0.684 ↑ 1.0 40 1

Hash Left Join (cost=14.92..18.45 rows=41 width=307) (actual time=0.485..0.684 rows=40 loops=1)

  • Hash Cond: (prop."ProcessId" = bp."Id")
6. 0.049 0.582 ↑ 1.0 40 1

Hash Left Join (cost=9.22..12.64 rows=41 width=288) (actual time=0.425..0.582 rows=40 loops=1)

  • Hash Cond: (prop."ProposalId" = assign."ProposalId")
7. 0.076 0.499 ↑ 1.0 40 1

Merge Right Join (cost=8.02..11.14 rows=41 width=282) (actual time=0.383..0.499 rows=40 loops=1)

  • Merge Cond: (bu."Id" = prop."BusinessUnitId")
8. 0.055 0.055 ↑ 44.0 42 1

Index Scan using "Business_Unit_pkey" on "Business_Unit" bu (cost=0.28..108.55 rows=1,847 width=109) (actual time=0.022..0.055 rows=42 loops=1)

9. 0.092 0.368 ↑ 1.0 40 1

Sort (cost=7.74..7.84 rows=41 width=185) (actual time=0.354..0.368 rows=40 loops=1)

  • Sort Key: prop."BusinessUnitId
  • Sort Method: quicksort Memory: 37kB
10. 0.070 0.276 ↑ 1.0 40 1

Hash Join (cost=3.97..6.64 rows=41 width=185) (actual time=0.183..0.276 rows=40 loops=1)

  • Hash Cond: (est."ProposalId" = prop."ProposalId")
11. 0.062 0.062 ↑ 1.2 42 1

Seq Scan on "RPA_Estimation" est (cost=0.00..2.52 rows=52 width=21) (actual time=0.023..0.062 rows=42 loops=1)

12. 0.071 0.144 ↓ 1.0 40 1

Hash (cost=3.49..3.49 rows=39 width=172) (actual time=0.144..0.144 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
13. 0.073 0.073 ↓ 1.0 40 1

Seq Scan on "RPA_Proposal" prop (cost=0.00..3.49 rows=39 width=172) (actual time=0.013..0.073 rows=40 loops=1)

  • Filter: ("Status" = '1'::bit(1))
14. 0.010 0.034 ↓ 1.3 12 1

Hash (cost=1.09..1.09 rows=9 width=14) (actual time=0.033..0.034 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.024 0.024 ↓ 1.3 12 1

Seq Scan on "RPA_Assign" assign (cost=0.00..1.09 rows=9 width=14) (actual time=0.015..0.024 rows=12 loops=1)

16. 0.024 0.053 ↑ 1.0 31 1

Hash (cost=5.31..5.31 rows=31 width=31) (actual time=0.053..0.053 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
17. 0.029 0.029 ↑ 1.0 31 1

Seq Scan on "Business_Process" bp (cost=0.00..5.31 rows=31 width=31) (actual time=0.008..0.029 rows=31 loops=1)

18. 0.023 0.069 ↓ 1.0 34 1

Hash (cost=3.13..3.13 rows=33 width=20) (actual time=0.069..0.069 rows=34 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
19. 0.046 0.046 ↓ 1.0 34 1

Seq Scan on "Look_up" lkp (cost=0.00..3.13 rows=33 width=20) (actual time=0.022..0.046 rows=34 loops=1)

  • Filter: ("Lookup_Type" = 'ProposalStatus'::text)
  • Rows Removed by Filter: 57
20. 0.080 0.138 ↑ 70.0 1 1

Sort (cost=4.85..5.02 rows=70 width=15) (actual time=0.138..0.138 rows=1 loops=1)

  • Sort Key: jira."ProposalId" DESC
  • Sort Method: quicksort Memory: 28kB
21. 0.058 0.058 ↓ 1.0 73 1

Seq Scan on "RPA_Proposal_JiraTicketDetail" jira (cost=0.00..2.70 rows=70 width=15) (actual time=0.015..0.058 rows=73 loops=1)

22.          

SubPlan (forWindowAgg)

23. 0.720 3.720 ↑ 1.0 1 40

Aggregate (cost=18.53..18.54 rows=1 width=32) (actual time=0.093..0.093 rows=1 loops=40)

24. 1.277 3.000 ↑ 1.0 2 40

Nested Loop Left Join (cost=0.28..18.52 rows=2 width=12) (actual time=0.064..0.075 rows=2 loops=40)

25. 0.920 0.920 ↑ 1.0 2 40

Seq Scan on "RPA_ProposalApplicationName" appname (cost=0.00..1.91 rows=2 width=8) (actual time=0.017..0.023 rows=2 loops=40)

  • Filter: ("ProposalId" = prop."ProposalId")
  • Rows Removed by Filter: 72
26. 0.803 0.803 ↑ 1.0 1 73

Index Scan using "RPA_Applications_pkey" on "RPA_Applications" app (cost=0.28..8.29 rows=1 width=16) (actual time=0.011..0.011 rows=1 loops=73)

  • Index Cond: (appname."ApplicationNameCode" = "Id")
27. 11,304.880 11,304.880 ↓ 0.0 0 40

Seq Scan on "RPA_LDAPUserDetails_Test" (cost=0.00..2,363.98 rows=244 width=16) (actual time=162.843..282.622 rows=0 loops=40)

  • Filter: (lower("UserEmail") = lower(prop."BusinessAnalystSupportCOEName"))
  • Rows Removed by Filter: 48856
28. 9,198.640 9,198.640 ↓ 0.0 0 40

Seq Scan on "RPA_LDAPUserDetails_Test" "RPA_LDAPUserDetails_Test_1" (cost=0.00..2,363.98 rows=244 width=16) (actual time=184.620..229.966 rows=0 loops=40)

  • Filter: (lower("UserEmail") = lower(prop."DeveloperName"))
  • Rows Removed by Filter: 48856