explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wgp3 : Q3

Settings
# exclusive inclusive rows x rows loops node
1. 37.440 219,618.958 ↑ 1.0 1 1

Aggregate (cost=16,500.12..16,500.13 rows=1 width=60) (actual time=219,618.958..219,618.958 rows=1 loops=1)

  • Output: sum("*SELECT* 1".totalactualhours), sum(CASE WHEN (hashed SubPlan 3) THEN "*SELECT* 1".totalactualcostinbasecurrency ELSE NULL::numeric END), sum(CASE WHEN (hashed SubPlan 6) THEN "*SELECT* 1".totalactualbillinginbasecurrency ELSE NULL::numeric END)
  • Buffers: shared hit=200269561 read=5154
2. 8.111 219,339.948 ↑ 1.5 15,150 1

Append (cost=768.76..12,253.42 rows=23,313 width=60) (actual time=219,279.270..219,339.948 rows=15,150 loops=1)

  • Buffers: shared hit=200104434 read=4345
3. 59.769 219,318.962 ↓ 15,150.0 15,150 1

Subquery Scan on *SELECT* 1 (cost=768.76..6,524.63 rows=1 width=60) (actual time=219,279.269..219,318.962 rows=15,150 loops=1)

  • Output: "*SELECT* 1".totalactualhours, "*SELECT* 1".projectid, "*SELECT* 1".totalactualcostinbasecurrency, "*SELECT* 1".totalactualbillinginbasecurrency
  • Filter: ((hashed SubPlan 7) OR (hashed SubPlan 8) OR (hashed SubPlan 9))
  • Buffers: shared hit=200101831 read=3123
4. 14.354 46.921 ↓ 15,150.0 15,150 1

Merge Anti Join (cost=0.57..5,756.43 rows=1 width=60) (actual time=19.530..46.921 rows=15,150 loops=1)

  • Output: dm_projectlist_facts.projectid, NULL::text, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::text, NULL::text, NULL::uuid, NULL::text, NULL::text, NULL::numeric(19,4), dm_projectlist_facts.totalactualbillinginbasecurrency, NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), dm_projectlist_facts.totalactualcostinbasecurrency, NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, dm_projectlist_facts.totalactualhours, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Merge Cond: (dm_projectlist_facts.projectid = dm_projectlist_realtime_facts.projectid)
  • Buffers: shared hit=17725 read=3123
5. 13.059 13.059 ↓ 1.8 15,150 1

Index Scan using dm_projectlist_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_facts (cost=0.29..836.02 rows=8,400 width=60) (actual time=0.016..13.059 rows=15,150 loops=1)

  • Output: dm_projectlist_facts.projectid, dm_projectlist_facts.projectguidid, dm_projectlist_facts.name, dm_projectlist_facts.slug, dm_projectlist_facts.code, dm_projectlist_facts.statustype, dm_projectlist_facts.invoicingtype, dm_projectlist_facts.estimationmode, dm_projectlist_facts.startdate, dm_projectlist_facts.enddate, dm_projectlist_facts.projectleaderid, dm_projectlist_facts.projectleaderdisplayname, dm_projectlist_facts.projectleaderslug, dm_projectlist_facts.programid, dm_projectlist_facts.programname, dm_projectlist_facts.programslug, dm_projectlist_facts.totalestimatedbillinginbasecurrency, dm_projectlist_facts.totalactualbillinginbasecurrency, dm_projectlist_facts.totalestimatedcostinbasecurrency, dm_projectlist_facts.totalestimatedcostcapexinbasecurrency, dm_projectlist_facts.totalestimatedcostopexinbasecurrency, dm_projectlist_facts.totalactualcostinbasecurrency, dm_projectlist_facts.totalactualcostcapexinbasecurrency, dm_projectlist_facts.totalactualcostopexinbasecurrency, dm_projectlist_facts.totalestimatedhours, dm_projectlist_facts.totalactualhours, dm_projectlist_facts.hoursfte, dm_projectlist_facts.estimatedresources, dm_projectlist_facts.assignedresources, dm_projectlist_facts.placeholderresources, dm_projectlist_facts.totalactualbillingamountinbasecurrency
  • Filter: ((dm_projectlist_facts.statustype <> 5) OR (dm_projectlist_facts.statustype IS NULL))
  • Buffers: shared hit=8796 read=468
6. 19.508 19.508 ↓ 0.0 0 1

Index Only Scan using dm_projectlist_realtime_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts (cost=0.29..4,681.54 rows=53,550 width=4) (actual time=19.508..19.508 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts.projectid
  • Heap Fetches: 12484
  • Buffers: shared hit=8929 read=2655
7.          

SubPlan (for Subquery Scan)

8. 60,754.287 219,212.272 ↓ 15,150.0 15,150 1

Nested Loop (cost=0.50..4.54 rows=1 width=4) (actual time=0.031..219,212.272 rows=15,150 loops=1)

  • Output: project13.id
  • Join Filter: (project13.id = project14.id)
  • Rows Removed by Join Filter: 229507350
  • Buffers: shared hit=200084106
9. 19.285 19.285 ↓ 15,150.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project13 (cost=0.25..2.26 rows=1 width=4) (actual time=0.014..19.285 rows=15,150 loops=1)

  • Output: project13.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
10. 158,438.700 158,438.700 ↓ 15,150.0 15,150 15,150

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project14 (cost=0.25..2.26 rows=1 width=4) (actual time=0.006..10.458 rows=15,150 loops=15,150)

  • Output: project14.id
  • Heap Fetches: 379219650
  • Buffers: shared hit=200070900
11. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project15.id
  • Filter: ((project15.projectleaderapproverid = 2) OR (projectsharingassignment16.userid = 2))
12. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project15 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: project15.id, project15.guidid, project15.name, project15.slug, project15.code, project15.clientid, project15.projectleaderapproverid, project15.projectstatuslabelid, project15.isprojectleaderapprovalrequired, project15.startdate, project15.enddate, project15.programid, project15.billingtype, project15.fixedbidamount, project15.fixedbidcurrencyid, project15.fixedbidfrequency, project15.timeentrycappercent, project15.costtype, project15.clientbillingallocationmethod, project15.description, project15.percentcomplete, project15.istimeentryallowed, project15.estimatedhours, project15.estimatedexpenses, project15.estimatedexpensescurrencyid, project15.estimatedcost, project15.estimatedcostcurrencyid, project15.timeandexpenseentrytype, project15.estimationmode, project15.billingratefrequencyid, project15.billingratefrequencyduration, project15.defaultbillingcurrencyid, project15.billingcontractid, project15.projecthealthstateid, project15.projecthealthstatedescription, project15.totalestimatedcontractamount, project15.totalestimatedcontractcurrencyid, project15.budgetedhours, project15.budgetedcost, project15.budgetedcostcurrencyid, project15.info1, project15.info2, project15.info3, project15.info4, project15.info5, project15.info6, project15.info7, project15.info8, project15.info9, project15.info10, project15.info11, project15.info12, project15.info13, project15.info14, project15.info15, project15.info16, project15.info17, project15.info18, project15.info19, project15.info20
13. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment16 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment16.projectid, projectsharingassignment16.userid
  • Index Cond: (projectsharingassignment16.projectid = project15.id)
  • Heap Fetches: 0
14. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

  • Output: project17.id
  • Hash Cond: (projectclient18.clientid = clients19.id)
  • Filter: ((clients19.clientmanageruserid = 2) OR (clientsharingassignment20.userid = 2))
15. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project17.id, projectclient18.clientid
16. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project17 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project17.id
  • Heap Fetches: 0
17. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient18 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient18.projectid, projectclient18.clientid, projectclient18.effectivedate, projectclient18.enddate
  • Index Cond: (projectclient18.projectid = project17.id)
  • Heap Fetches: 0
18. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients19.id, clients19.clientmanageruserid, clientsharingassignment20.userid
19. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients19.id, clients19.clientmanageruserid, clientsharingassignment20.userid
20. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients19 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients19.id, clients19.name, clients19.slug, clients19.code, clients19.comments, clients19.clientmanageruserid, clients19.disabled, clients19.address, clients19.city, clients19.stateprovince, clients19.zippostalcode, clients19.country, clients19.email, clients19.telephone, clients19.fax, clients19.website, clients19.billingcontact, clients19.billingaddress, clients19.billingcity, clients19.billingstateprovince, clients19.billingzippostalcode, clients19.billingcountry, clients19.billingemail, clients19.billingtelephone, clients19.billingfax, clients19.billingwebsite, clients19.info1, clients19.info2, clients19.info3, clients19.info4, clients19.info5, clients19.info6, clients19.info7, clients19.info8, clients19.info9, clients19.info10, clients19.info11, clients19.info12, clients19.defaultbillingcurrencyid
21. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment20 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment20.id, clientsharingassignment20.clientid, clientsharingassignment20.userid
  • Index Cond: (clientsharingassignment20.clientid = clients19.id)
22. 0.000 12.875 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=768.18..5,728.79 rows=23,312 width=60) (actual time=12.875..12.875 rows=0 loops=1)

  • Output: "*SELECT* 2".totalactualhours, "*SELECT* 2".projectid, "*SELECT* 2".totalactualcostinbasecurrency, "*SELECT* 2".totalactualbillinginbasecurrency
  • Filter: ((hashed SubPlan 7) OR (hashed SubPlan 8) OR (hashed SubPlan 9))
  • Buffers: shared hit=2603 read=1222
23. 12.873 12.873 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_1 (cost=0.00..4,494.38 rows=26,642 width=60) (actual time=12.873..12.873 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts_1.projectid, NULL::text, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::text, NULL::text, NULL::uuid, NULL::text, NULL::text, NULL::numeric(19,4), dm_projectlist_realtime_facts_1.totalactualbillinginbasecurrency, NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), dm_projectlist_realtime_facts_1.totalactualcostinbasecurrency, NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, dm_projectlist_realtime_facts_1.totalactualhours, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Filter: ((NOT dm_projectlist_realtime_facts_1.deleted) AND ((dm_projectlist_realtime_facts_1.statustype <> 5) OR (dm_projectlist_realtime_facts_1.statustype IS NULL)))
  • Buffers: shared hit=2603 read=1222
24.          

SubPlan (for Subquery Scan)

25. 60,754.287 219,212.272 ↓ 15,150.0 15,150 1

Nested Loop (cost=0.50..4.54 rows=1 width=4) (actual time=0.031..219,212.272 rows=15,150 loops=1)

  • Output: project13.id
  • Join Filter: (project13.id = project14.id)
  • Rows Removed by Join Filter: 229507350
  • Buffers: shared hit=200084106
26. 19.285 19.285 ↓ 15,150.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project13 (cost=0.25..2.26 rows=1 width=4) (actual time=0.014..19.285 rows=15,150 loops=1)

  • Output: project13.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
27. 158,438.700 158,438.700 ↓ 15,150.0 15,150 15,150

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project14 (cost=0.25..2.26 rows=1 width=4) (actual time=0.006..10.458 rows=15,150 loops=15,150)

  • Output: project14.id
  • Heap Fetches: 379219650
  • Buffers: shared hit=200070900
28. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project15.id
  • Filter: ((project15.projectleaderapproverid = 2) OR (projectsharingassignment16.userid = 2))
29. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project15 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: project15.id, project15.guidid, project15.name, project15.slug, project15.code, project15.clientid, project15.projectleaderapproverid, project15.projectstatuslabelid, project15.isprojectleaderapprovalrequired, project15.startdate, project15.enddate, project15.programid, project15.billingtype, project15.fixedbidamount, project15.fixedbidcurrencyid, project15.fixedbidfrequency, project15.timeentrycappercent, project15.costtype, project15.clientbillingallocationmethod, project15.description, project15.percentcomplete, project15.istimeentryallowed, project15.estimatedhours, project15.estimatedexpenses, project15.estimatedexpensescurrencyid, project15.estimatedcost, project15.estimatedcostcurrencyid, project15.timeandexpenseentrytype, project15.estimationmode, project15.billingratefrequencyid, project15.billingratefrequencyduration, project15.defaultbillingcurrencyid, project15.billingcontractid, project15.projecthealthstateid, project15.projecthealthstatedescription, project15.totalestimatedcontractamount, project15.totalestimatedcontractcurrencyid, project15.budgetedhours, project15.budgetedcost, project15.budgetedcostcurrencyid, project15.info1, project15.info2, project15.info3, project15.info4, project15.info5, project15.info6, project15.info7, project15.info8, project15.info9, project15.info10, project15.info11, project15.info12, project15.info13, project15.info14, project15.info15, project15.info16, project15.info17, project15.info18, project15.info19, project15.info20
30. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment16 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment16.projectid, projectsharingassignment16.userid
  • Index Cond: (projectsharingassignment16.projectid = project15.id)
  • Heap Fetches: 0
31. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

  • Output: project17.id
  • Hash Cond: (projectclient18.clientid = clients19.id)
  • Filter: ((clients19.clientmanageruserid = 2) OR (clientsharingassignment20.userid = 2))
32. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project17.id, projectclient18.clientid
33. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project17 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project17.id
  • Heap Fetches: 0
34. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient18 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient18.projectid, projectclient18.clientid, projectclient18.effectivedate, projectclient18.enddate
  • Index Cond: (projectclient18.projectid = project17.id)
  • Heap Fetches: 0
35. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients19.id, clients19.clientmanageruserid, clientsharingassignment20.userid
36. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients19.id, clients19.clientmanageruserid, clientsharingassignment20.userid
37. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients19 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients19.id, clients19.name, clients19.slug, clients19.code, clients19.comments, clients19.clientmanageruserid, clients19.disabled, clients19.address, clients19.city, clients19.stateprovince, clients19.zippostalcode, clients19.country, clients19.email, clients19.telephone, clients19.fax, clients19.website, clients19.billingcontact, clients19.billingaddress, clients19.billingcity, clients19.billingstateprovince, clients19.billingzippostalcode, clients19.billingcountry, clients19.billingemail, clients19.billingtelephone, clients19.billingfax, clients19.billingwebsite, clients19.info1, clients19.info2, clients19.info3, clients19.info4, clients19.info5, clients19.info6, clients19.info7, clients19.info8, clients19.info9, clients19.info10, clients19.info11, clients19.info12, clients19.defaultbillingcurrencyid
38. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment20 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment20.id, clientsharingassignment20.clientid, clientsharingassignment20.userid
  • Index Cond: (clientsharingassignment20.clientid = clients19.id)
39.          

SubPlan (for Aggregate)

40. 24.135 113.929 ↑ 2.6 15,150 1

Hash Left Join (cost=10.44..1,879.56 rows=39,233 width=4) (actual time=25.456..113.929 rows=15,150 loops=1)

  • Output: project1.id
  • Hash Cond: (projectclient3.clientid = clients4.id)
  • Filter: ((alternatives: SubPlan 1 or hashed SubPlan 2) OR (project1.projectleaderapproverid = 2) OR (projectsharingassignment2.userid = 2) OR (clients4.clientmanageruserid = 2) OR (clientsharingassignment5.userid = 2))
  • Buffers: shared hit=82968
41. 8.537 73.071 ↓ 1.5 15,150 1

Merge Left Join (cost=0.70..936.37 rows=9,801 width=16) (actual time=0.023..73.071 rows=15,150 loops=1)

  • Output: project1.id, project1.projectleaderapproverid, projectsharingassignment2.userid, projectclient3.clientid
  • Merge Cond: (project1.id = projectsharingassignment2.projectid)
  • Buffers: shared hit=66841
42. 21.927 64.529 ↓ 17.0 15,150 1

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=12) (actual time=0.017..64.529 rows=15,150 loops=1)

  • Output: project1.id, project1.projectleaderapproverid, projectclient3.clientid
  • Buffers: shared hit=66840
43. 12.302 12.302 ↓ 15,150.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1 (cost=0.25..2.26 rows=1 width=8) (actual time=0.007..12.302 rows=15,150 loops=1)

  • Output: project1.id, project1.guidid, project1.name, project1.slug, project1.code, project1.clientid, project1.projectleaderapproverid, project1.projectstatuslabelid, project1.isprojectleaderapprovalrequired, project1.startdate, project1.enddate, project1.programid, project1.billingtype, project1.fixedbidamount, project1.fixedbidcurrencyid, project1.fixedbidfrequency, project1.timeentrycappercent, project1.costtype, project1.clientbillingallocationmethod, project1.description, project1.percentcomplete, project1.istimeentryallowed, project1.estimatedhours, project1.estimatedexpenses, project1.estimatedexpensescurrencyid, project1.estimatedcost, project1.estimatedcostcurrencyid, project1.timeandexpenseentrytype, project1.estimationmode, project1.billingratefrequencyid, project1.billingratefrequencyduration, project1.defaultbillingcurrencyid, project1.billingcontractid, project1.projecthealthstateid, project1.projecthealthstatedescription, project1.totalestimatedcontractamount, project1.totalestimatedcontractcurrencyid, project1.budgetedhours, project1.budgetedcost, project1.budgetedcostcurrencyid, project1.info1, project1.info2, project1.info3, project1.info4, project1.info5, project1.info6, project1.info7, project1.info8, project1.info9, project1.info10, project1.info11, project1.info12, project1.info13, project1.info14, project1.info15, project1.info16, project1.info17, project1.info18, project1.info19, project1.info20
  • Buffers: shared hit=13206
44. 30.300 30.300 ↑ 891.0 1 15,150

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient3 (cost=0.29..726.89 rows=891 width=8) (actual time=0.002..0.002 rows=1 loops=15,150)

  • Output: projectclient3.projectid, projectclient3.clientid, projectclient3.effectivedate, projectclient3.enddate
  • Index Cond: (projectclient3.projectid = project1.id)
  • Heap Fetches: 25037
  • Buffers: shared hit=53634
45. 0.004 0.005 ↓ 0.0 0 1

Materialize (cost=0.15..50.71 rows=2,260 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: projectsharingassignment2.projectid, projectsharingassignment2.userid
  • Buffers: shared hit=1
46. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment2 (cost=0.15..45.06 rows=2,260 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: projectsharingassignment2.projectid, projectsharingassignment2.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
47. 0.561 3.564 ↓ 189.4 1,515 1

Hash (cost=9.64..9.64 rows=8 width=12) (actual time=3.564..3.564 rows=1,515 loops=1)

  • Output: clients4.id, clients4.clientmanageruserid, clientsharingassignment5.userid
  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 70kB
  • Buffers: shared hit=2921
48. 1.921 3.003 ↓ 189.4 1,515 1

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (actual time=0.013..3.003 rows=1,515 loops=1)

  • Output: clients4.id, clients4.clientmanageruserid, clientsharingassignment5.userid
  • Buffers: shared hit=2921
49. 1.082 1.082 ↓ 1,515.0 1,515 1

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients4 (cost=0.25..2.26 rows=1 width=8) (actual time=0.008..1.082 rows=1,515 loops=1)

  • Output: clients4.id, clients4.name, clients4.slug, clients4.code, clients4.comments, clients4.clientmanageruserid, clients4.disabled, clients4.address, clients4.city, clients4.stateprovince, clients4.zippostalcode, clients4.country, clients4.email, clients4.telephone, clients4.fax, clients4.website, clients4.billingcontact, clients4.billingaddress, clients4.billingcity, clients4.billingstateprovince, clients4.billingzippostalcode, clients4.billingcountry, clients4.billingemail, clients4.billingtelephone, clients4.billingfax, clients4.billingwebsite, clients4.info1, clients4.info2, clients4.info3, clients4.info4, clients4.info5, clients4.info6, clients4.info7, clients4.info8, clients4.info9, clients4.info10, clients4.info11, clients4.info12, clients4.defaultbillingcurrencyid
  • Buffers: shared hit=1406
50. 0.000 0.000 ↓ 0.0 0 1,515

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment5 (cost=0.15..7.29 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1,515)

  • Output: clientsharingassignment5.id, clientsharingassignment5.clientid, clientsharingassignment5.userid
  • Index Cond: (clientsharingassignment5.clientid = clients4.id)
  • Buffers: shared hit=1515
51.          

SubPlan (for Hash Left Join)

52. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project6 (cost=0.25..2.27 rows=1 width=0) (never executed)

  • Index Cond: (project6.id = project1.id)
  • Heap Fetches: 0
53. 13.159 13.159 ↓ 15,150.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project6_1 (cost=0.25..2.26 rows=1 width=4) (actual time=0.010..13.159 rows=15,150 loops=1)

  • Output: project6_1.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
54. 25.157 127.641 ↑ 2.6 15,150 1

Hash Left Join (cost=10.44..1,879.56 rows=39,233 width=4) (actual time=25.029..127.641 rows=15,150 loops=1)

  • Output: project7.id
  • Hash Cond: (projectclient9.clientid = clients10.id)
  • Filter: ((alternatives: SubPlan 4 or hashed SubPlan 5) OR (project7.projectleaderapproverid = 2) OR (projectsharingassignment8.userid = 2) OR (clients10.clientmanageruserid = 2) OR (clientsharingassignment11.userid = 2))
  • Buffers: shared hit=82159 read=809
55. 8.993 85.446 ↓ 1.5 15,150 1

Merge Left Join (cost=0.70..936.37 rows=9,801 width=16) (actual time=0.070..85.446 rows=15,150 loops=1)

  • Output: project7.id, project7.projectleaderapproverid, projectsharingassignment8.userid, projectclient9.clientid
  • Merge Cond: (project7.id = projectsharingassignment8.projectid)
  • Buffers: shared hit=66032 read=809
56. 17.570 76.445 ↓ 17.0 15,150 1

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=12) (actual time=0.058..76.445 rows=15,150 loops=1)

  • Output: project7.id, project7.projectleaderapproverid, projectclient9.clientid
  • Buffers: shared hit=66031 read=809
57. 13.425 13.425 ↓ 15,150.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project7 (cost=0.25..2.26 rows=1 width=8) (actual time=0.013..13.425 rows=15,150 loops=1)

  • Output: project7.id, project7.guidid, project7.name, project7.slug, project7.code, project7.clientid, project7.projectleaderapproverid, project7.projectstatuslabelid, project7.isprojectleaderapprovalrequired, project7.startdate, project7.enddate, project7.programid, project7.billingtype, project7.fixedbidamount, project7.fixedbidcurrencyid, project7.fixedbidfrequency, project7.timeentrycappercent, project7.costtype, project7.clientbillingallocationmethod, project7.description, project7.percentcomplete, project7.istimeentryallowed, project7.estimatedhours, project7.estimatedexpenses, project7.estimatedexpensescurrencyid, project7.estimatedcost, project7.estimatedcostcurrencyid, project7.timeandexpenseentrytype, project7.estimationmode, project7.billingratefrequencyid, project7.billingratefrequencyduration, project7.defaultbillingcurrencyid, project7.billingcontractid, project7.projecthealthstateid, project7.projecthealthstatedescription, project7.totalestimatedcontractamount, project7.totalestimatedcontractcurrencyid, project7.budgetedhours, project7.budgetedcost, project7.budgetedcostcurrencyid, project7.info1, project7.info2, project7.info3, project7.info4, project7.info5, project7.info6, project7.info7, project7.info8, project7.info9, project7.info10, project7.info11, project7.info12, project7.info13, project7.info14, project7.info15, project7.info16, project7.info17, project7.info18, project7.info19, project7.info20
  • Buffers: shared hit=13206
58. 45.450 45.450 ↑ 891.0 1 15,150

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient9 (cost=0.29..726.89 rows=891 width=8) (actual time=0.002..0.003 rows=1 loops=15,150)

  • Output: projectclient9.projectid, projectclient9.clientid, projectclient9.effectivedate, projectclient9.enddate
  • Index Cond: (projectclient9.projectid = project7.id)
  • Heap Fetches: 25037
  • Buffers: shared hit=52825 read=809
59. 0.005 0.008 ↓ 0.0 0 1

Materialize (cost=0.15..50.71 rows=2,260 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: projectsharingassignment8.projectid, projectsharingassignment8.userid
  • Buffers: shared hit=1
60. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment8 (cost=0.15..45.06 rows=2,260 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: projectsharingassignment8.projectid, projectsharingassignment8.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
61. 0.813 5.270 ↓ 189.4 1,515 1

Hash (cost=9.64..9.64 rows=8 width=12) (actual time=5.270..5.270 rows=1,515 loops=1)

  • Output: clients10.id, clients10.clientmanageruserid, clientsharingassignment11.userid
  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 70kB
  • Buffers: shared hit=2921
62. 1.380 4.457 ↓ 189.4 1,515 1

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (actual time=0.022..4.457 rows=1,515 loops=1)

  • Output: clients10.id, clients10.clientmanageruserid, clientsharingassignment11.userid
  • Buffers: shared hit=2921
63. 1.562 1.562 ↓ 1,515.0 1,515 1

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients10 (cost=0.25..2.26 rows=1 width=8) (actual time=0.014..1.562 rows=1,515 loops=1)

  • Output: clients10.id, clients10.name, clients10.slug, clients10.code, clients10.comments, clients10.clientmanageruserid, clients10.disabled, clients10.address, clients10.city, clients10.stateprovince, clients10.zippostalcode, clients10.country, clients10.email, clients10.telephone, clients10.fax, clients10.website, clients10.billingcontact, clients10.billingaddress, clients10.billingcity, clients10.billingstateprovince, clients10.billingzippostalcode, clients10.billingcountry, clients10.billingemail, clients10.billingtelephone, clients10.billingfax, clients10.billingwebsite, clients10.info1, clients10.info2, clients10.info3, clients10.info4, clients10.info5, clients10.info6, clients10.info7, clients10.info8, clients10.info9, clients10.info10, clients10.info11, clients10.info12, clients10.defaultbillingcurrencyid
  • Buffers: shared hit=1406
64. 1.515 1.515 ↓ 0.0 0 1,515

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment11 (cost=0.15..7.29 rows=8 width=8) (actual time=0.001..0.001 rows=0 loops=1,515)

  • Output: clientsharingassignment11.id, clientsharingassignment11.clientid, clientsharingassignment11.userid
  • Index Cond: (clientsharingassignment11.clientid = clients10.id)
  • Buffers: shared hit=1515
65.          

SubPlan (for Hash Left Join)

66. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project12 (cost=0.25..2.27 rows=1 width=0) (never executed)

  • Index Cond: (project12.id = project7.id)
  • Heap Fetches: 0
67. 11.768 11.768 ↓ 15,150.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project12_1 (cost=0.25..2.26 rows=1 width=4) (actual time=0.010..11.768 rows=15,150 loops=1)

  • Output: project12_1.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
Planning time : 3.785 ms
Execution time : 219,620.252 ms