explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FvSO : q3

Settings
# exclusive inclusive rows x rows loops node
1. 47.184 318.327 ↑ 1.0 1 1

Aggregate (cost=96,957.92..96,957.93 rows=1 width=60) (actual time=318.327..318.327 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=90355 read=44
2. 8.391 108.216 ↑ 1.5 15,150 1

Append (cost=15,593.73..41,903.36 rows=23,313 width=60) (actual time=50.171..108.216 rows=15,150 loops=1)

  • Buffers: shared hit=51041 read=44
3. 20.398 90.778 ↓ 15,150.0 15,150 1

Subquery Scan on *SELECT* 1 (cost=15,593.73..21,349.60 rows=1 width=60) (actual time=50.170..90.778 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=47216 read=44
4. 14.611 37.640 ↓ 15,150.0 15,150 1

Merge Anti Join (cost=0.57..5,756.43 rows=1 width=60) (actual time=10.784..37.640 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=20804 read=44
5. 12.262 12.262 ↓ 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.011..12.262 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=9220 read=44
6. 10.767 10.767 ↓ 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=10.767..10.767 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts.projectid
  • Heap Fetches: 12484
  • Buffers: shared hit=11584
7.          

SubPlan (forSubquery Scan)

8. 13.190 32.740 ↑ 1.0 15,150 1

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (actual time=0.033..32.740 rows=15,150 loops=1)

  • Output: project13.id
  • Merge Cond: (project13.id = project14.id)
  • Buffers: shared hit=26412
9. 11.247 11.247 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project13 (cost=0.29..2,094.53 rows=15,150 width=4) (actual time=0.020..11.247 rows=15,150 loops=1)

  • Output: project13.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
10. 8.303 8.303 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project14 (cost=0.29..2,094.53 rows=15,150 width=4) (actual time=0.009..8.303 rows=15,150 loops=1)

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

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project15.id
  • Merge Cond: (project15.id = projectsharingassignment16.projectid)
  • 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.29..2,094.53 rows=15,150 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..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment16.projectid, projectsharingassignment16.userid
  • Heap Fetches: 0
14. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 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

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project17.id, projectclient18.clientid
  • Hash Cond: (projectclient18.projectid = project17.id)
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient18 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient18.id, projectclient18.projectid, projectclient18.clientid, projectclient18.costallocationpercentage, projectclient18.effectivedate, projectclient18.enddate
17. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project17.id
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project17 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project17.id
19. 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
20. 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
21. 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
22. 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)
23. 0.000 9.047 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=15,593.15..20,553.76 rows=23,312 width=60) (actual time=9.047..9.047 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=3825
24. 9.045 9.045 ↓ 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=9.045..9.045 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=3825
25.          

SubPlan (forSubquery Scan)

26. 13.190 32.740 ↑ 1.0 15,150 1

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (actual time=0.033..32.740 rows=15,150 loops=1)

  • Output: project13.id
  • Merge Cond: (project13.id = project14.id)
  • Buffers: shared hit=26412
27. 11.247 11.247 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project13 (cost=0.29..2,094.53 rows=15,150 width=4) (actual time=0.020..11.247 rows=15,150 loops=1)

  • Output: project13.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
28. 8.303 8.303 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project14 (cost=0.29..2,094.53 rows=15,150 width=4) (actual time=0.009..8.303 rows=15,150 loops=1)

  • Output: project14.id
  • Heap Fetches: 25030
  • Buffers: shared hit=13206
29. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project15.id
  • Merge Cond: (project15.id = projectsharingassignment16.projectid)
  • Filter: ((project15.projectleaderapproverid = 2) OR (projectsharingassignment16.userid = 2))
30. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project15 (cost=0.29..2,094.53 rows=15,150 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
31. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment16 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment16.projectid, projectsharingassignment16.userid
  • Heap Fetches: 0
32. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

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

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project17.id, projectclient18.clientid
  • Hash Cond: (projectclient18.projectid = project17.id)
34. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient18 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient18.id, projectclient18.projectid, projectclient18.clientid, projectclient18.costallocationpercentage, projectclient18.effectivedate, projectclient18.enddate
35. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project17.id
36. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project17 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project17.id
37. 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
38. 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
39. 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
40. 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)
41.          

SubPlan (forAggregate)

42. 22.600 83.955 ↑ 46.9 15,150 1

Hash Left Join (cost=2,404.83..25,606.94 rows=709,850 width=4) (actual time=48.028..83.955 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=19657
43. 13.542 48.799 ↑ 11.8 15,150 1

Hash Right Join (cost=2,395.09..8,374.20 rows=178,194 width=16) (actual time=28.248..48.799 rows=15,150 loops=1)

  • Output: project1.id, project1.projectleaderapproverid, projectsharingassignment2.userid, projectclient3.clientid
  • Hash Cond: (projectclient3.projectid = project1.id)
  • Buffers: shared hit=14954
44. 7.093 7.093 ↑ 11.8 15,150 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient3 (cost=0.00..3,528.94 rows=178,194 width=8) (actual time=0.004..7.093 rows=15,150 loops=1)

  • Output: projectclient3.id, projectclient3.projectid, projectclient3.clientid, projectclient3.costallocationpercentage, projectclient3.effectivedate, projectclient3.enddate
  • Buffers: shared hit=1747
45. 5.891 28.164 ↑ 1.0 15,150 1

Hash (cost=2,205.72..2,205.72 rows=15,150 width=12) (actual time=28.164..28.164 rows=15,150 loops=1)

  • Output: project1.id, project1.projectleaderapproverid, projectsharingassignment2.userid
  • Buckets: 16384 Batches: 1 Memory Usage: 661kB
  • Buffers: shared hit=13207
46. 10.199 22.273 ↑ 1.0 15,150 1

Merge Left Join (cost=0.44..2,205.72 rows=15,150 width=12) (actual time=0.017..22.273 rows=15,150 loops=1)

  • Output: project1.id, project1.projectleaderapproverid, projectsharingassignment2.userid
  • Merge Cond: (project1.id = projectsharingassignment2.projectid)
  • Buffers: shared hit=13207
47. 12.071 12.071 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.011..12.071 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
48. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Output: projectsharingassignment2.projectid, projectsharingassignment2.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
49. 0.615 4.410 ↓ 189.4 1,515 1

Hash (cost=9.64..9.64 rows=8 width=12) (actual time=4.410..4.410 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
50. 0.911 3.795 ↓ 189.4 1,515 1

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

  • Output: clients4.id, clients4.clientmanageruserid, clientsharingassignment5.userid
  • Buffers: shared hit=2921
51. 1.369 1.369 ↓ 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.010..1.369 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
52. 1.515 1.515 ↓ 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.001..0.001 rows=0 loops=1,515)

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

SubPlan (forHash Left Join)

54. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project6.id = project1.id)
  • Heap Fetches: 0
55. 8.146 8.146 ↑ 1.0 15,150 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project6_1 (cost=0.00..1,933.50 rows=15,150 width=4) (actual time=0.002..8.146 rows=15,150 loops=1)

  • Output: project6_1.id
  • Buffers: shared hit=1782
56. 21.543 78.972 ↑ 46.9 15,150 1

Hash Left Join (cost=2,404.83..25,606.94 rows=709,850 width=4) (actual time=44.577..78.972 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=19657
57. 13.051 45.622 ↑ 11.8 15,150 1

Hash Right Join (cost=2,395.09..8,374.20 rows=178,194 width=16) (actual time=25.796..45.622 rows=15,150 loops=1)

  • Output: project7.id, project7.projectleaderapproverid, projectsharingassignment8.userid, projectclient9.clientid
  • Hash Cond: (projectclient9.projectid = project7.id)
  • Buffers: shared hit=14954
58. 6.861 6.861 ↑ 11.8 15,150 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient9 (cost=0.00..3,528.94 rows=178,194 width=8) (actual time=0.004..6.861 rows=15,150 loops=1)

  • Output: projectclient9.id, projectclient9.projectid, projectclient9.clientid, projectclient9.costallocationpercentage, projectclient9.effectivedate, projectclient9.enddate
  • Buffers: shared hit=1747
59. 5.405 25.710 ↑ 1.0 15,150 1

Hash (cost=2,205.72..2,205.72 rows=15,150 width=12) (actual time=25.710..25.710 rows=15,150 loops=1)

  • Output: project7.id, project7.projectleaderapproverid, projectsharingassignment8.userid
  • Buckets: 16384 Batches: 1 Memory Usage: 661kB
  • Buffers: shared hit=13207
60. 9.238 20.305 ↑ 1.0 15,150 1

Merge Left Join (cost=0.44..2,205.72 rows=15,150 width=12) (actual time=0.014..20.305 rows=15,150 loops=1)

  • Output: project7.id, project7.projectleaderapproverid, projectsharingassignment8.userid
  • Merge Cond: (project7.id = projectsharingassignment8.projectid)
  • Buffers: shared hit=13207
61. 11.065 11.065 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project7 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.009..11.065 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
62. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Output: projectsharingassignment8.projectid, projectsharingassignment8.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
63. 0.592 4.110 ↓ 189.4 1,515 1

Hash (cost=9.64..9.64 rows=8 width=12) (actual time=4.110..4.110 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
64. 2.258 3.518 ↓ 189.4 1,515 1

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

  • Output: clients10.id, clients10.clientmanageruserid, clientsharingassignment11.userid
  • Buffers: shared hit=2921
65. 1.260 1.260 ↓ 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.009..1.260 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
66. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=1,515)

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

SubPlan (forHash Left Join)

68. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project12.id = project7.id)
  • Heap Fetches: 0
69. 7.697 7.697 ↑ 1.0 15,150 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project12_1 (cost=0.00..1,933.50 rows=15,150 width=4) (actual time=0.003..7.697 rows=15,150 loops=1)

  • Output: project12_1.id
  • Buffers: shared hit=1782
Planning time : 2.498 ms
Execution time : 319.890 ms