explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lbw : q2

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 162,478.117 ↑ 1.0 20 1

Limit (cost=5,798,705.17..5,798,705.22 rows=20 width=236) (actual time=162,478.096..162,478.117 rows=20 loops=1)

  • Output: "*SELECT* 1".projectid, "*SELECT* 1".projectid, (("*SELECT* 1".name)::text), (("*SELECT* 1".slug)::text), (("*SELECT* 1".code)::text), (("*SELECT* 1".name)::text), "*SELECT* 1".statustype, (CASE WHEN (hashed SubPlan 3) THEN (SubPlan 4) ELSE NULL::character varying END), (CASE WHEN (hashed SubPlan 7) THEN (SubPlan 8) ELSE NULL::integer END), (CASE WHEN (hashed SubPlan 11) THEN (SubPlan 12) ELSE NULL::character varying END), "*SELECT* 1".projectleaderid, (("*SELECT* 1".projectleaderdisplayname)::text), (("*SELECT* 1".projectleaderslug)::text), "*SELECT* 1".startdate, "*SELECT* 1".enddate, "*SELECT* 1".totalactualhours, (CASE WHEN (hashed SubPlan 15) THEN "*SELECT* 1".totalactualcostinbasecurrency ELSE NULL::numeric END), (CASE WHEN (hashed SubPlan 18) THEN "*SELECT* 1".totalactualbillinginbasecurrency ELSE NULL::numeric END), (CASE WHEN (hashed SubPlan 21) THEN (SubPlan 22) ELSE NULL::bigint END), (CASE WHEN (hashed SubPlan 25) THEN (SubPlan 26) ELSE NULL::date END), (CASE WHEN (hashed SubPlan 29) THEN (SubPlan 30) ELSE NULL::integer END)
  • Buffers: shared hit=202311624 read=145
2. 45.959 162,478.103 ↑ 1,165.7 20 1

Sort (cost=5,798,705.17..5,798,763.45 rows=23,313 width=236) (actual time=162,478.094..162,478.103 rows=20 loops=1)

  • Output: "*SELECT* 1".projectid, "*SELECT* 1".projectid, (("*SELECT* 1".name)::text), (("*SELECT* 1".slug)::text), (("*SELECT* 1".code)::text), (("*SELECT* 1".name)::text), "*SELECT* 1".statustype, (CASE WHEN (hashed SubPlan 3) THEN (SubPlan 4) ELSE NULL::character varying END), (CASE WHEN (hashed SubPlan 7) THEN (SubPlan 8) ELSE NULL::integer END), (CASE WHEN (hashed SubPlan 11) THEN (SubPlan 12) ELSE NULL::character varying END), "*SELECT* 1".projectleaderid, (("*SELECT* 1".projectleaderdisplayname)::text), (("*SELECT* 1".projectleaderslug)::text), "*SELECT* 1".startdate, "*SELECT* 1".enddate, "*SELECT* 1".totalactualhours, (CASE WHEN (hashed SubPlan 15) THEN "*SELECT* 1".totalactualcostinbasecurrency ELSE NULL::numeric END), (CASE WHEN (hashed SubPlan 18) THEN "*SELECT* 1".totalactualbillinginbasecurrency ELSE NULL::numeric END), (CASE WHEN (hashed SubPlan 21) THEN (SubPlan 22) ELSE NULL::bigint END), (CASE WHEN (hashed SubPlan 25) THEN (SubPlan 26) ELSE NULL::date END), (CASE WHEN (hashed SubPlan 29) THEN (SubPlan 30) ELSE NULL::integer END)
  • Sort Key: (("*SELECT* 1".name)::text) COLLATE "en_US", "*SELECT* 1".projectid
  • Sort Method: top-N heapsort Memory: 32kB
  • Buffers: shared hit=202311624 read=145
3. 488.381 162,432.144 ↑ 1.5 15,150 1

Result (cost=234,646.26..5,798,084.82 rows=23,313 width=236) (actual time=720.225..162,432.144 rows=15,150 loops=1)

  • Output: "*SELECT* 1".projectid, "*SELECT* 1".projectid, "*SELECT* 1".name, "*SELECT* 1".slug, "*SELECT* 1".code, "*SELECT* 1".name, "*SELECT* 1".statustype, CASE WHEN (hashed SubPlan 3) THEN (SubPlan 4) ELSE NULL::character varying END, CASE WHEN (hashed SubPlan 7) THEN (SubPlan 8) ELSE NULL::integer END, CASE WHEN (hashed SubPlan 11) THEN (SubPlan 12) ELSE NULL::character varying END, "*SELECT* 1".projectleaderid, "*SELECT* 1".projectleaderdisplayname, "*SELECT* 1".projectleaderslug, "*SELECT* 1".startdate, "*SELECT* 1".enddate, "*SELECT* 1".totalactualhours, CASE WHEN (hashed SubPlan 15) THEN "*SELECT* 1".totalactualcostinbasecurrency ELSE NULL::numeric END, CASE WHEN (hashed SubPlan 18) THEN "*SELECT* 1".totalactualbillinginbasecurrency ELSE NULL::numeric END, CASE WHEN (hashed SubPlan 21) THEN (SubPlan 22) ELSE NULL::bigint END, CASE WHEN (hashed SubPlan 25) THEN (SubPlan 26) ELSE NULL::date END, CASE WHEN (hashed SubPlan 29) THEN (SubPlan 30) ELSE NULL::integer END
  • Buffers: shared hit=202311624 read=145
4. 11.222 177.706 ↑ 1.5 15,150 1

Append (cost=15,593.73..41,903.36 rows=23,313 width=236) (actual time=46.826..177.706 rows=15,150 loops=1)

  • Buffers: shared hit=51047 read=38
5. 41.404 157.797 ↓ 15,150.0 15,150 1

Subquery Scan on *SELECT* 1 (cost=15,593.73..21,349.60 rows=1 width=236) (actual time=46.826..157.797 rows=15,150 loops=1)

  • Output: "*SELECT* 1".projectid, "*SELECT* 1".name, "*SELECT* 1".slug, "*SELECT* 1".code, "*SELECT* 1".statustype, "*SELECT* 1".projectleaderid, "*SELECT* 1".projectleaderdisplayname, "*SELECT* 1".projectleaderslug, "*SELECT* 1".startdate, "*SELECT* 1".enddate, "*SELECT* 1".totalactualhours, "*SELECT* 1".totalactualcostinbasecurrency, "*SELECT* 1".totalactualbillinginbasecurrency
  • Filter: ((hashed SubPlan 31) OR (hashed SubPlan 32) OR (hashed SubPlan 33))
  • Buffers: shared hit=47222 read=38
6. 40.243 86.006 ↓ 15,150.0 15,150 1

Merge Anti Join (cost=0.57..5,756.43 rows=1 width=236) (actual time=10.240..86.006 rows=15,150 loops=1)

  • Output: dm_projectlist_facts.projectid, dm_projectlist_facts.name, dm_projectlist_facts.slug, dm_projectlist_facts.code, dm_projectlist_facts.statustype, NULL::integer, dm_projectlist_facts.startdate, dm_projectlist_facts.enddate, dm_projectlist_facts.projectleaderid, dm_projectlist_facts.projectleaderdisplayname, dm_projectlist_facts.projectleaderslug, 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=20810 read=38
7. 35.540 35.540 ↓ 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=236) (actual time=0.012..35.540 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=9226 read=38
8. 10.223 10.223 ↓ 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.223..10.223 rows=0 loops=1)

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

SubPlan (for Subquery Scan)

10. 12.021 30.387 ↑ 1.0 15,150 1

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

  • Output: project46.id
  • Merge Cond: (project46.id = project47.id)
  • Buffers: shared hit=26412
11. 10.562 10.562 ↑ 1.0 15,150 1

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

  • Output: project46.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
12. 7.804 7.804 ↑ 1.0 15,150 1

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

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

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

  • Output: project48.id
  • Merge Cond: (project48.id = projectsharingassignment49.projectid)
  • Filter: ((project48.projectleaderapproverid = 2) OR (projectsharingassignment49.userid = 2))
14. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project48 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

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

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

  • Output: projectsharingassignment49.projectid, projectsharingassignment49.userid
  • Heap Fetches: 0
16. 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: project50.id
  • Hash Cond: (projectclient51.clientid = clients52.id)
  • Filter: ((clients52.clientmanageruserid = 2) OR (clientsharingassignment53.userid = 2))
17. 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: project50.id, projectclient51.clientid
  • Hash Cond: (projectclient51.projectid = project50.id)
18. 0.000 0.000 ↓ 0.0 0

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

  • Output: projectclient51.id, projectclient51.projectid, projectclient51.clientid, projectclient51.costallocationpercentage, projectclient51.effectivedate, projectclient51.enddate
19. 0.000 0.000 ↓ 0.0 0

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

  • Output: project50.id
20. 0.000 0.000 ↓ 0.0 0

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

  • Output: project50.id
21. 0.000 0.000 ↓ 0.0 0

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

  • Output: clients52.id, clients52.clientmanageruserid, clientsharingassignment53.userid
22. 0.000 0.000 ↓ 0.0 0

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

  • Output: clients52.id, clients52.clientmanageruserid, clientsharingassignment53.userid
23. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Output: clientsharingassignment53.id, clientsharingassignment53.clientid, clientsharingassignment53.userid
  • Index Cond: (clientsharingassignment53.clientid = clients52.id)
25. 0.000 8.687 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=15,593.15..20,553.76 rows=23,312 width=236) (actual time=8.687..8.687 rows=0 loops=1)

  • Output: "*SELECT* 2".projectid, "*SELECT* 2".name, "*SELECT* 2".slug, "*SELECT* 2".code, "*SELECT* 2".statustype, "*SELECT* 2".projectleaderid, "*SELECT* 2".projectleaderdisplayname, "*SELECT* 2".projectleaderslug, "*SELECT* 2".startdate, "*SELECT* 2".enddate, "*SELECT* 2".totalactualhours, "*SELECT* 2".totalactualcostinbasecurrency, "*SELECT* 2".totalactualbillinginbasecurrency
  • Filter: ((hashed SubPlan 31) OR (hashed SubPlan 32) OR (hashed SubPlan 33))
  • Buffers: shared hit=3825
26. 8.685 8.685 ↓ 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=236) (actual time=8.685..8.685 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts_1.projectid, dm_projectlist_realtime_facts_1.name, dm_projectlist_realtime_facts_1.slug, dm_projectlist_realtime_facts_1.code, dm_projectlist_realtime_facts_1.statustype, NULL::integer, dm_projectlist_realtime_facts_1.startdate, dm_projectlist_realtime_facts_1.enddate, dm_projectlist_realtime_facts_1.projectleaderid, dm_projectlist_realtime_facts_1.projectleaderdisplayname, dm_projectlist_realtime_facts_1.projectleaderslug, 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
27.          

SubPlan (for Subquery Scan)

28. 12.021 30.387 ↑ 1.0 15,150 1

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

  • Output: project46.id
  • Merge Cond: (project46.id = project47.id)
  • Buffers: shared hit=26412
29. 10.562 10.562 ↑ 1.0 15,150 1

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

  • Output: project46.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
30. 7.804 7.804 ↑ 1.0 15,150 1

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

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

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

  • Output: project48.id
  • Merge Cond: (project48.id = projectsharingassignment49.projectid)
  • Filter: ((project48.projectleaderapproverid = 2) OR (projectsharingassignment49.userid = 2))
32. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project48 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

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

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

  • Output: projectsharingassignment49.projectid, projectsharingassignment49.userid
  • Heap Fetches: 0
34. 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: project50.id
  • Hash Cond: (projectclient51.clientid = clients52.id)
  • Filter: ((clients52.clientmanageruserid = 2) OR (clientsharingassignment53.userid = 2))
35. 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: project50.id, projectclient51.clientid
  • Hash Cond: (projectclient51.projectid = project50.id)
36. 0.000 0.000 ↓ 0.0 0

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

  • Output: projectclient51.id, projectclient51.projectid, projectclient51.clientid, projectclient51.costallocationpercentage, projectclient51.effectivedate, projectclient51.enddate
37. 0.000 0.000 ↓ 0.0 0

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

  • Output: project50.id
38. 0.000 0.000 ↓ 0.0 0

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

  • Output: project50.id
39. 0.000 0.000 ↓ 0.0 0

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

  • Output: clients52.id, clients52.clientmanageruserid, clientsharingassignment53.userid
40. 0.000 0.000 ↓ 0.0 0

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

  • Output: clients52.id, clients52.clientmanageruserid, clientsharingassignment53.userid
41. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Output: clientsharingassignment53.id, clientsharingassignment53.clientid, clientsharingassignment53.userid
  • Index Cond: (clientsharingassignment53.clientid = clients52.id)
43.          

SubPlan (for Result)

44. 18.258 78.805 ↑ 46.9 15,150 1

Hash Left Join (cost=2,404.83..25,606.94 rows=709,850 width=4) (actual time=39.370..78.805 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=19550 read=107
45. 11.161 50.700 ↑ 11.8 15,150 1

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

  • Output: project1.id, project1.projectleaderapproverid, projectsharingassignment2.userid, projectclient3.clientid
  • Hash Cond: (projectclient3.projectid = project1.id)
  • Buffers: shared hit=14847 read=107
46. 15.980 15.980 ↑ 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..15.980 rows=15,150 loops=1)

  • Output: projectclient3.id, projectclient3.projectid, projectclient3.clientid, projectclient3.costallocationpercentage, projectclient3.effectivedate, projectclient3.enddate
  • Buffers: shared hit=1640 read=107
47. 4.861 23.559 ↑ 1.0 15,150 1

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

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

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

  • Output: project1.id, project1.projectleaderapproverid, projectsharingassignment2.userid
  • Merge Cond: (project1.id = projectsharingassignment2.projectid)
  • Buffers: shared hit=13207
49. 10.325 10.325 ↑ 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.009..10.325 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
50. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Output: projectsharingassignment2.projectid, projectsharingassignment2.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
51. 0.500 3.472 ↓ 189.4 1,515 1

Hash (cost=9.64..9.64 rows=8 width=12) (actual time=3.472..3.472 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
52. 1.879 2.972 ↓ 189.4 1,515 1

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

  • Output: clients4.id, clients4.clientmanageruserid, clientsharingassignment5.userid
  • Buffers: shared hit=2921
53. 1.093 1.093 ↓ 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.093 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
54. 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
55.          

SubPlan (for Hash Left Join)

56. 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
57. 6.375 6.375 ↑ 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..6.375 rows=15,150 loops=1)

  • Output: project6_1.id
  • Buffers: shared hit=1782
58. 30.300 53,646.150 ↑ 1.0 1 15,150

Limit (cost=4.60..4.61 rows=1 width=536) (actual time=3.540..3.541 rows=1 loops=15,150)

  • Output: ((clients7.name)::character varying(255)), projectclient8.costallocationpercentage
  • Buffers: shared hit=67316710
59. 90.900 53,615.850 ↑ 1.0 1 15,150

Sort (cost=4.60..4.61 rows=1 width=536) (actual time=3.539..3.539 rows=1 loops=15,150)

  • Output: ((clients7.name)::character varying(255)), projectclient8.costallocationpercentage
  • Sort Key: projectclient8.costallocationpercentage DESC, ((clients7.name)::character varying(255)) COLLATE "en_US
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=67316710
60. 15,983.250 53,524.950 ↑ 1.0 1 15,150

Nested Loop (cost=0.54..4.59 rows=1 width=536) (actual time=1.761..3.533 rows=1 loops=15,150)

  • Output: clients7.name, projectclient8.costallocationpercentage
  • Buffers: shared hit=67316710
61. 14,589.450 14,589.450 ↓ 1,515.0 1,515 15,150

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients7 (cost=0.25..2.26 rows=1 width=520) (actual time=0.006..0.963 rows=1,515 loops=15,150)

  • Output: clients7.id, clients7.name, clients7.slug, clients7.code, clients7.comments, clients7.clientmanageruserid, clients7.disabled, clients7.address, clients7.city, clients7.stateprovince, clients7.zippostalcode, clients7.country, clients7.email, clients7.telephone, clients7.fax, clients7.website, clients7.billingcontact, clients7.billingaddress, clients7.billingcity, clients7.billingstateprovince, clients7.billingzippostalcode, clients7.billingcountry, clients7.billingemail, clients7.billingtelephone, clients7.billingfax, clients7.billingwebsite, clients7.info1, clients7.info2, clients7.info3, clients7.info4, clients7.info5, clients7.info6, clients7.info7, clients7.info8, clients7.info9, clients7.info10, clients7.info11, clients7.info12, clients7.defaultbillingcurrencyid
  • Buffers: shared hit=21300900
62. 22,952.250 22,952.250 ↓ 0.0 0 22,952,250

Index Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient8 (cost=0.29..2.32 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=22,952,250)

  • Output: projectclient8.id, projectclient8.projectid, projectclient8.clientid, projectclient8.costallocationpercentage, projectclient8.effectivedate, projectclient8.enddate
  • Index Cond: ((projectclient8.projectid = "*SELECT* 1".projectid) AND (projectclient8.clientid = clients7.id) AND (projectclient8.effectivedate <= '2019-08-08'::date) AND (projectclient8.enddate >= '2019-08-08'::date))
  • Buffers: shared hit=46015810
63. 17.766 68.518 ↑ 46.9 15,150 1

Hash Left Join (cost=2,404.83..25,606.94 rows=709,850 width=4) (actual time=40.183..68.518 rows=15,150 loops=1)

  • Output: project1_1.id
  • Hash Cond: (projectclient3_1.clientid = clients4_1.id)
  • Filter: ((alternatives: SubPlan 5 or hashed SubPlan 6) OR (project1_1.projectleaderapproverid = 2) OR (projectsharingassignment2_1.userid = 2) OR (clients4_1.clientmanageruserid = 2) OR (clientsharingassignment5_1.userid = 2))
  • Buffers: shared hit=19657
64. 10.704 40.635 ↑ 11.8 15,150 1

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

  • Output: project1_1.id, project1_1.projectleaderapproverid, projectsharingassignment2_1.userid, projectclient3_1.clientid
  • Hash Cond: (projectclient3_1.projectid = project1_1.id)
  • Buffers: shared hit=14954
65. 5.991 5.991 ↑ 11.8 15,150 1

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

  • Output: projectclient3_1.id, projectclient3_1.projectid, projectclient3_1.clientid, projectclient3_1.costallocationpercentage, projectclient3_1.effectivedate, projectclient3_1.enddate
  • Buffers: shared hit=1747
66. 4.934 23.940 ↑ 1.0 15,150 1

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

  • Output: project1_1.id, project1_1.projectleaderapproverid, projectsharingassignment2_1.userid
  • Buckets: 16384 Batches: 1 Memory Usage: 661kB
  • Buffers: shared hit=13207
67. 8.486 19.006 ↑ 1.0 15,150 1

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

  • Output: project1_1.id, project1_1.projectleaderapproverid, projectsharingassignment2_1.userid
  • Merge Cond: (project1_1.id = projectsharingassignment2_1.projectid)
  • Buffers: shared hit=13207
68. 10.518 10.518 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1_1 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.008..10.518 rows=15,150 loops=1)

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

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

  • Output: projectsharingassignment2_1.projectid, projectsharingassignment2_1.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
70. 0.504 3.627 ↓ 189.4 1,515 1

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

  • Output: clients4_1.id, clients4_1.clientmanageruserid, clientsharingassignment5_1.userid
  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 70kB
  • Buffers: shared hit=2921
71. 1.970 3.123 ↓ 189.4 1,515 1

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

  • Output: clients4_1.id, clients4_1.clientmanageruserid, clientsharingassignment5_1.userid
  • Buffers: shared hit=2921
72. 1.153 1.153 ↓ 1,515.0 1,515 1

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

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

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

  • Output: clientsharingassignment5_1.id, clientsharingassignment5_1.clientid, clientsharingassignment5_1.userid
  • Index Cond: (clientsharingassignment5_1.clientid = clients4_1.id)
  • Buffers: shared hit=1515
74.          

SubPlan (for Hash Left Join)

75. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project6_2.id = project1_1.id)
  • Heap Fetches: 0
76. 6.490 6.490 ↑ 1.0 15,150 1

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

  • Output: project6_3.id
  • Buffers: shared hit=1782
77. 30.300 53,706.750 ↑ 1.0 1 15,150

Limit (cost=4.60..4.61 rows=1 width=540) (actual time=3.544..3.545 rows=1 loops=15,150)

  • Output: clients9.id, projectclient10.costallocationpercentage, ((clients9.name)::character varying(255))
  • Buffers: shared hit=67316710
78. 90.900 53,676.450 ↑ 1.0 1 15,150

Sort (cost=4.60..4.61 rows=1 width=540) (actual time=3.543..3.543 rows=1 loops=15,150)

  • Output: clients9.id, projectclient10.costallocationpercentage, ((clients9.name)::character varying(255))
  • Sort Key: projectclient10.costallocationpercentage DESC, ((clients9.name)::character varying(255)) COLLATE "en_US
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=67316710
79. 16,165.050 53,585.550 ↑ 1.0 1 15,150

Nested Loop (cost=0.54..4.59 rows=1 width=540) (actual time=1.766..3.537 rows=1 loops=15,150)

  • Output: clients9.id, projectclient10.costallocationpercentage, clients9.name
  • Buffers: shared hit=67316710
80. 14,468.250 14,468.250 ↓ 1,515.0 1,515 15,150

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients9 (cost=0.25..2.26 rows=1 width=520) (actual time=0.006..0.955 rows=1,515 loops=15,150)

  • Output: clients9.id, clients9.name, clients9.slug, clients9.code, clients9.comments, clients9.clientmanageruserid, clients9.disabled, clients9.address, clients9.city, clients9.stateprovince, clients9.zippostalcode, clients9.country, clients9.email, clients9.telephone, clients9.fax, clients9.website, clients9.billingcontact, clients9.billingaddress, clients9.billingcity, clients9.billingstateprovince, clients9.billingzippostalcode, clients9.billingcountry, clients9.billingemail, clients9.billingtelephone, clients9.billingfax, clients9.billingwebsite, clients9.info1, clients9.info2, clients9.info3, clients9.info4, clients9.info5, clients9.info6, clients9.info7, clients9.info8, clients9.info9, clients9.info10, clients9.info11, clients9.info12, clients9.defaultbillingcurrencyid
  • Buffers: shared hit=21300900
81. 22,952.250 22,952.250 ↓ 0.0 0 22,952,250

Index Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient10 (cost=0.29..2.32 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=22,952,250)

  • Output: projectclient10.id, projectclient10.projectid, projectclient10.clientid, projectclient10.costallocationpercentage, projectclient10.effectivedate, projectclient10.enddate
  • Index Cond: ((projectclient10.projectid = "*SELECT* 1".projectid) AND (projectclient10.clientid = clients9.id) AND (projectclient10.effectivedate <= '2019-08-08'::date) AND (projectclient10.enddate >= '2019-08-08'::date))
  • Buffers: shared hit=46015810
82. 17.974 68.743 ↑ 46.9 15,150 1

Hash Left Join (cost=2,404.83..25,606.94 rows=709,850 width=4) (actual time=39.874..68.743 rows=15,150 loops=1)

  • Output: project1_2.id
  • Hash Cond: (projectclient3_2.clientid = clients4_2.id)
  • Filter: ((alternatives: SubPlan 9 or hashed SubPlan 10) OR (project1_2.projectleaderapproverid = 2) OR (projectsharingassignment2_2.userid = 2) OR (clients4_2.clientmanageruserid = 2) OR (clientsharingassignment5_2.userid = 2))
  • Buffers: shared hit=19657
83. 11.057 40.886 ↑ 11.8 15,150 1

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

  • Output: project1_2.id, project1_2.projectleaderapproverid, projectsharingassignment2_2.userid, projectclient3_2.clientid
  • Hash Cond: (projectclient3_2.projectid = project1_2.id)
  • Buffers: shared hit=14954
84. 5.869 5.869 ↑ 11.8 15,150 1

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

  • Output: projectclient3_2.id, projectclient3_2.projectid, projectclient3_2.clientid, projectclient3_2.costallocationpercentage, projectclient3_2.effectivedate, projectclient3_2.enddate
  • Buffers: shared hit=1747
85. 4.959 23.960 ↑ 1.0 15,150 1

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

  • Output: project1_2.id, project1_2.projectleaderapproverid, projectsharingassignment2_2.userid
  • Buckets: 16384 Batches: 1 Memory Usage: 661kB
  • Buffers: shared hit=13207
86. 8.457 19.001 ↑ 1.0 15,150 1

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

  • Output: project1_2.id, project1_2.projectleaderapproverid, projectsharingassignment2_2.userid
  • Merge Cond: (project1_2.id = projectsharingassignment2_2.projectid)
  • Buffers: shared hit=13207
87. 10.542 10.542 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1_2 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.010..10.542 rows=15,150 loops=1)

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

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

  • Output: projectsharingassignment2_2.projectid, projectsharingassignment2_2.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
89. 0.497 3.490 ↓ 189.4 1,515 1

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

  • Output: clients4_2.id, clients4_2.clientmanageruserid, clientsharingassignment5_2.userid
  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 70kB
  • Buffers: shared hit=2921
90. 1.859 2.993 ↓ 189.4 1,515 1

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

  • Output: clients4_2.id, clients4_2.clientmanageruserid, clientsharingassignment5_2.userid
  • Buffers: shared hit=2921
91. 1.134 1.134 ↓ 1,515.0 1,515 1

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

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

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

  • Output: clientsharingassignment5_2.id, clientsharingassignment5_2.clientid, clientsharingassignment5_2.userid
  • Index Cond: (clientsharingassignment5_2.clientid = clients4_2.id)
  • Buffers: shared hit=1515
93.          

SubPlan (for Hash Left Join)

94. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project6_4.id = project1_2.id)
  • Heap Fetches: 0
95. 6.393 6.393 ↑ 1.0 15,150 1

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

  • Output: project6_5.id
  • Buffers: shared hit=1782
96. 15.150 53,570.400 ↑ 1.0 1 15,150

Limit (cost=4.60..4.61 rows=1 width=1,052) (actual time=3.536..3.536 rows=1 loops=15,150)

  • Output: ((clients11.slug)::character varying(255)), projectclient12.costallocationpercentage, ((clients11.name)::character varying(255))
  • Buffers: shared hit=67316710
97. 90.900 53,555.250 ↑ 1.0 1 15,150

Sort (cost=4.60..4.61 rows=1 width=1,052) (actual time=3.535..3.535 rows=1 loops=15,150)

  • Output: ((clients11.slug)::character varying(255)), projectclient12.costallocationpercentage, ((clients11.name)::character varying(255))
  • Sort Key: projectclient12.costallocationpercentage DESC, ((clients11.name)::character varying(255)) COLLATE "en_US
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=67316710
98. 15,952.950 53,464.350 ↑ 1.0 1 15,150

Nested Loop (cost=0.54..4.59 rows=1 width=1,052) (actual time=1.762..3.529 rows=1 loops=15,150)

  • Output: clients11.slug, projectclient12.costallocationpercentage, clients11.name
  • Buffers: shared hit=67316710
99. 14,559.150 14,559.150 ↓ 1,515.0 1,515 15,150

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients11 (cost=0.25..2.26 rows=1 width=1,036) (actual time=0.006..0.961 rows=1,515 loops=15,150)

  • Output: clients11.id, clients11.name, clients11.slug, clients11.code, clients11.comments, clients11.clientmanageruserid, clients11.disabled, clients11.address, clients11.city, clients11.stateprovince, clients11.zippostalcode, clients11.country, clients11.email, clients11.telephone, clients11.fax, clients11.website, clients11.billingcontact, clients11.billingaddress, clients11.billingcity, clients11.billingstateprovince, clients11.billingzippostalcode, clients11.billingcountry, clients11.billingemail, clients11.billingtelephone, clients11.billingfax, clients11.billingwebsite, clients11.info1, clients11.info2, clients11.info3, clients11.info4, clients11.info5, clients11.info6, clients11.info7, clients11.info8, clients11.info9, clients11.info10, clients11.info11, clients11.info12, clients11.defaultbillingcurrencyid
  • Buffers: shared hit=21300900
100. 22,952.250 22,952.250 ↓ 0.0 0 22,952,250

Index Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient12 (cost=0.29..2.32 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=22,952,250)

  • Output: projectclient12.id, projectclient12.projectid, projectclient12.clientid, projectclient12.costallocationpercentage, projectclient12.effectivedate, projectclient12.enddate
  • Index Cond: ((projectclient12.projectid = "*SELECT* 1".projectid) AND (projectclient12.clientid = clients11.id) AND (projectclient12.effectivedate <= '2019-08-08'::date) AND (projectclient12.enddate >= '2019-08-08'::date))
  • Buffers: shared hit=46015810
101. 18.343 69.540 ↑ 46.9 15,150 1

Hash Left Join (cost=2,404.83..25,606.94 rows=709,850 width=4) (actual time=39.990..69.540 rows=15,150 loops=1)

  • Output: project13.id
  • Hash Cond: (projectclient15.clientid = clients16.id)
  • Filter: ((alternatives: SubPlan 13 or hashed SubPlan 14) OR (project13.projectleaderapproverid = 2) OR (projectsharingassignment14.userid = 2) OR (clients16.clientmanageruserid = 2) OR (clientsharingassignment17.userid = 2))
  • Buffers: shared hit=19657
102. 11.336 41.101 ↑ 11.8 15,150 1

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

  • Output: project13.id, project13.projectleaderapproverid, projectsharingassignment14.userid, projectclient15.clientid
  • Hash Cond: (projectclient15.projectid = project13.id)
  • Buffers: shared hit=14954
103. 5.950 5.950 ↑ 11.8 15,150 1

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

  • Output: projectclient15.id, projectclient15.projectid, projectclient15.clientid, projectclient15.costallocationpercentage, projectclient15.effectivedate, projectclient15.enddate
  • Buffers: shared hit=1747
104. 4.970 23.815 ↑ 1.0 15,150 1

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

  • Output: project13.id, project13.projectleaderapproverid, projectsharingassignment14.userid
  • Buckets: 16384 Batches: 1 Memory Usage: 661kB
  • Buffers: shared hit=13207
105. 8.325 18.845 ↑ 1.0 15,150 1

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

  • Output: project13.id, project13.projectleaderapproverid, projectsharingassignment14.userid
  • Merge Cond: (project13.id = projectsharingassignment14.projectid)
  • Buffers: shared hit=13207
106. 10.518 10.518 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project13 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.010..10.518 rows=15,150 loops=1)

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

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

  • Output: projectsharingassignment14.projectid, projectsharingassignment14.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
108. 0.495 3.521 ↓ 189.4 1,515 1

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

  • Output: clients16.id, clients16.clientmanageruserid, clientsharingassignment17.userid
  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 70kB
  • Buffers: shared hit=2921
109. 1.935 3.026 ↓ 189.4 1,515 1

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

  • Output: clients16.id, clients16.clientmanageruserid, clientsharingassignment17.userid
  • Buffers: shared hit=2921
110. 1.091 1.091 ↓ 1,515.0 1,515 1

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

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

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

  • Output: clientsharingassignment17.id, clientsharingassignment17.clientid, clientsharingassignment17.userid
  • Index Cond: (clientsharingassignment17.clientid = clients16.id)
  • Buffers: shared hit=1515
112.          

SubPlan (for Hash Left Join)

113. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project18.id = project13.id)
  • Heap Fetches: 0
114. 6.575 6.575 ↑ 1.0 15,150 1

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

  • Output: project18_1.id
  • Buffers: shared hit=1782
115. 18.541 70.229 ↑ 46.9 15,150 1

Hash Left Join (cost=2,404.83..25,606.94 rows=709,850 width=4) (actual time=40.917..70.229 rows=15,150 loops=1)

  • Output: project19.id
  • Hash Cond: (projectclient21.clientid = clients22.id)
  • Filter: ((alternatives: SubPlan 16 or hashed SubPlan 17) OR (project19.projectleaderapproverid = 2) OR (projectsharingassignment20.userid = 2) OR (clients22.clientmanageruserid = 2) OR (clientsharingassignment23.userid = 2))
  • Buffers: shared hit=19657
116. 11.005 41.217 ↑ 11.8 15,150 1

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

  • Output: project19.id, project19.projectleaderapproverid, projectsharingassignment20.userid, projectclient21.clientid
  • Hash Cond: (projectclient21.projectid = project19.id)
  • Buffers: shared hit=14954
117. 5.923 5.923 ↑ 11.8 15,150 1

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

  • Output: projectclient21.id, projectclient21.projectid, projectclient21.clientid, projectclient21.costallocationpercentage, projectclient21.effectivedate, projectclient21.enddate
  • Buffers: shared hit=1747
118. 4.990 24.289 ↑ 1.0 15,150 1

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

  • Output: project19.id, project19.projectleaderapproverid, projectsharingassignment20.userid
  • Buckets: 16384 Batches: 1 Memory Usage: 661kB
  • Buffers: shared hit=13207
119. 8.480 19.299 ↑ 1.0 15,150 1

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

  • Output: project19.id, project19.projectleaderapproverid, projectsharingassignment20.userid
  • Merge Cond: (project19.id = projectsharingassignment20.projectid)
  • Buffers: shared hit=13207
120. 10.817 10.817 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project19 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.010..10.817 rows=15,150 loops=1)

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

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

  • Output: projectsharingassignment20.projectid, projectsharingassignment20.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
122. 0.538 3.631 ↓ 189.4 1,515 1

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

  • Output: clients22.id, clients22.clientmanageruserid, clientsharingassignment23.userid
  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 70kB
  • Buffers: shared hit=2921
123. 1.927 3.093 ↓ 189.4 1,515 1

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

  • Output: clients22.id, clients22.clientmanageruserid, clientsharingassignment23.userid
  • Buffers: shared hit=2921
124. 1.166 1.166 ↓ 1,515.0 1,515 1

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

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

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

  • Output: clientsharingassignment23.id, clientsharingassignment23.clientid, clientsharingassignment23.userid
  • Index Cond: (clientsharingassignment23.clientid = clients22.id)
  • Buffers: shared hit=1515
126.          

SubPlan (for Hash Left Join)

127. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project24.id = project19.id)
  • Heap Fetches: 0
128. 6.840 6.840 ↑ 1.0 15,150 1

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

  • Output: project24_1.id
  • Buffers: shared hit=1782
129. 18.364 69.036 ↑ 46.9 15,150 1

Hash Left Join (cost=2,404.83..25,606.94 rows=709,850 width=4) (actual time=39.707..69.036 rows=15,150 loops=1)

  • Output: project25.id
  • Hash Cond: (projectclient27.clientid = clients28.id)
  • Filter: ((alternatives: SubPlan 19 or hashed SubPlan 20) OR (project25.projectleaderapproverid = 2) OR (projectsharingassignment26.userid = 2) OR (clients28.clientmanageruserid = 2) OR (clientsharingassignment29.userid = 2))
  • Buffers: shared hit=19657
130. 11.102 40.700 ↑ 11.8 15,150 1

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

  • Output: project25.id, project25.projectleaderapproverid, projectsharingassignment26.userid, projectclient27.clientid
  • Hash Cond: (projectclient27.projectid = project25.id)
  • Buffers: shared hit=14954
131. 5.945 5.945 ↑ 11.8 15,150 1

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

  • Output: projectclient27.id, projectclient27.projectid, projectclient27.clientid, projectclient27.costallocationpercentage, projectclient27.effectivedate, projectclient27.enddate
  • Buffers: shared hit=1747
132. 4.897 23.653 ↑ 1.0 15,150 1

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

  • Output: project25.id, project25.projectleaderapproverid, projectsharingassignment26.userid
  • Buckets: 16384 Batches: 1 Memory Usage: 661kB
  • Buffers: shared hit=13207
133. 8.456 18.756 ↑ 1.0 15,150 1

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

  • Output: project25.id, project25.projectleaderapproverid, projectsharingassignment26.userid
  • Merge Cond: (project25.id = projectsharingassignment26.projectid)
  • Buffers: shared hit=13207
134. 10.298 10.298 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project25 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.010..10.298 rows=15,150 loops=1)

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

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

  • Output: projectsharingassignment26.projectid, projectsharingassignment26.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
136. 0.537 3.535 ↓ 189.4 1,515 1

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

  • Output: clients28.id, clients28.clientmanageruserid, clientsharingassignment29.userid
  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 70kB
  • Buffers: shared hit=2921
137. 1.834 2.998 ↓ 189.4 1,515 1

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

  • Output: clients28.id, clients28.clientmanageruserid, clientsharingassignment29.userid
  • Buffers: shared hit=2921
138. 1.164 1.164 ↓ 1,515.0 1,515 1

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

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

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

  • Output: clientsharingassignment29.id, clientsharingassignment29.clientid, clientsharingassignment29.userid
  • Index Cond: (clientsharingassignment29.clientid = clients28.id)
  • Buffers: shared hit=1515
140.          

SubPlan (for Hash Left Join)

141. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project30.id = project25.id)
  • Heap Fetches: 0
142. 6.437 6.437 ↑ 1.0 15,150 1

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

  • Output: project30_1.id
  • Buffers: shared hit=1782
143. 60.600 106.050 ↑ 1.0 1 15,150

Aggregate (cost=110.67..110.68 rows=1 width=0) (actual time=0.006..0.007 rows=1 loops=15,150)

  • Output: count(*)
  • Buffers: shared hit=53634
144. 45.450 45.450 ↑ 99.0 1 15,150

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient31 (cost=0.29..110.42 rows=99 width=0) (actual time=0.003..0.003 rows=1 loops=15,150)

  • Output: projectclient31.projectid, projectclient31.clientid, projectclient31.effectivedate, projectclient31.enddate
  • Index Cond: ((projectclient31.projectid = "*SELECT* 1".projectid) AND (projectclient31.effectivedate <= '2019-08-08'::date) AND (projectclient31.enddate >= '2019-08-08'::date))
  • Heap Fetches: 25037
  • Buffers: shared hit=53634
145. 18.685 69.993 ↑ 46.9 15,150 1

Hash Left Join (cost=2,404.83..25,606.94 rows=709,850 width=4) (actual time=40.268..69.993 rows=15,150 loops=1)

  • Output: project32.id
  • Hash Cond: (projectclient34.clientid = clients35.id)
  • Filter: ((alternatives: SubPlan 23 or hashed SubPlan 24) OR (project32.projectleaderapproverid = 2) OR (projectsharingassignment33.userid = 2) OR (clients35.clientmanageruserid = 2) OR (clientsharingassignment36.userid = 2))
  • Buffers: shared hit=19657
146. 11.239 41.200 ↑ 11.8 15,150 1

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

  • Output: project32.id, project32.projectleaderapproverid, projectsharingassignment33.userid, projectclient34.clientid
  • Hash Cond: (projectclient34.projectid = project32.id)
  • Buffers: shared hit=14954
147. 5.897 5.897 ↑ 11.8 15,150 1

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

  • Output: projectclient34.id, projectclient34.projectid, projectclient34.clientid, projectclient34.costallocationpercentage, projectclient34.effectivedate, projectclient34.enddate
  • Buffers: shared hit=1747
148. 5.148 24.064 ↑ 1.0 15,150 1

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

  • Output: project32.id, project32.projectleaderapproverid, projectsharingassignment33.userid
  • Buckets: 16384 Batches: 1 Memory Usage: 661kB
  • Buffers: shared hit=13207
149. 8.419 18.916 ↑ 1.0 15,150 1

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

  • Output: project32.id, project32.projectleaderapproverid, projectsharingassignment33.userid
  • Merge Cond: (project32.id = projectsharingassignment33.projectid)
  • Buffers: shared hit=13207
150. 10.496 10.496 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project32 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.010..10.496 rows=15,150 loops=1)

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

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

  • Output: projectsharingassignment33.projectid, projectsharingassignment33.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
152. 0.550 3.534 ↓ 189.4 1,515 1

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

  • Output: clients35.id, clients35.clientmanageruserid, clientsharingassignment36.userid
  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 70kB
  • Buffers: shared hit=2921
153. 1.815 2.984 ↓ 189.4 1,515 1

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

  • Output: clients35.id, clients35.clientmanageruserid, clientsharingassignment36.userid
  • Buffers: shared hit=2921
154. 1.169 1.169 ↓ 1,515.0 1,515 1

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

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

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

  • Output: clientsharingassignment36.id, clientsharingassignment36.clientid, clientsharingassignment36.userid
  • Index Cond: (clientsharingassignment36.clientid = clients35.id)
  • Buffers: shared hit=1515
156.          

SubPlan (for Hash Left Join)

157. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project37.id = project32.id)
  • Heap Fetches: 0
158. 6.574 6.574 ↑ 1.0 15,150 1

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

  • Output: project37_1.id
  • Buffers: shared hit=1782
159. 45.450 90.900 ↑ 1.0 1 15,150

HashAggregate (cost=110.67..110.68 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=15,150)

  • Output: projectclient38.effectivedate
  • Group Key: projectclient38.effectivedate
  • Buffers: shared hit=53634
160. 45.450 45.450 ↑ 99.0 1 15,150

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient38 (cost=0.29..110.42 rows=99 width=4) (actual time=0.002..0.003 rows=1 loops=15,150)

  • Output: projectclient38.effectivedate
  • Index Cond: ((projectclient38.projectid = "*SELECT* 1".projectid) AND (projectclient38.effectivedate <= '2019-08-08'::date) AND (projectclient38.enddate >= '2019-08-08'::date))
  • Heap Fetches: 25037
  • Buffers: shared hit=53634
161. 20.044 75.193 ↑ 46.9 15,150 1

Hash Left Join (cost=2,404.83..25,606.94 rows=709,850 width=4) (actual time=43.236..75.193 rows=15,150 loops=1)

  • Output: project39.id
  • Hash Cond: (projectclient41.clientid = clients42.id)
  • Filter: ((alternatives: SubPlan 27 or hashed SubPlan 28) OR (project39.projectleaderapproverid = 2) OR (projectsharingassignment40.userid = 2) OR (clients42.clientmanageruserid = 2) OR (clientsharingassignment43.userid = 2))
  • Buffers: shared hit=19657
162. 12.150 44.093 ↑ 11.8 15,150 1

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

  • Output: project39.id, project39.projectleaderapproverid, projectsharingassignment40.userid, projectclient41.clientid
  • Hash Cond: (projectclient41.projectid = project39.id)
  • Buffers: shared hit=14954
163. 6.493 6.493 ↑ 11.8 15,150 1

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

  • Output: projectclient41.id, projectclient41.projectid, projectclient41.clientid, projectclient41.costallocationpercentage, projectclient41.effectivedate, projectclient41.enddate
  • Buffers: shared hit=1747
164. 5.148 25.450 ↑ 1.0 15,150 1

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

  • Output: project39.id, project39.projectleaderapproverid, projectsharingassignment40.userid
  • Buckets: 16384 Batches: 1 Memory Usage: 661kB
  • Buffers: shared hit=13207
165. 9.155 20.302 ↑ 1.0 15,150 1

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

  • Output: project39.id, project39.projectleaderapproverid, projectsharingassignment40.userid
  • Merge Cond: (project39.id = projectsharingassignment40.projectid)
  • Buffers: shared hit=13207
166. 11.144 11.144 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project39 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.009..11.144 rows=15,150 loops=1)

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

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

  • Output: projectsharingassignment40.projectid, projectsharingassignment40.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
168. 0.647 4.051 ↓ 189.4 1,515 1

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

  • Output: clients42.id, clients42.clientmanageruserid, clientsharingassignment43.userid
  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 70kB
  • Buffers: shared hit=2921
169. 2.135 3.404 ↓ 189.4 1,515 1

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

  • Output: clients42.id, clients42.clientmanageruserid, clientsharingassignment43.userid
  • Buffers: shared hit=2921
170. 1.269 1.269 ↓ 1,515.0 1,515 1

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

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

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

  • Output: clientsharingassignment43.id, clientsharingassignment43.clientid, clientsharingassignment43.userid
  • Index Cond: (clientsharingassignment43.clientid = clients42.id)
  • Buffers: shared hit=1515
172.          

SubPlan (for Hash Left Join)

173. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project44.id = project39.id)
  • Heap Fetches: 0
174. 7.005 7.005 ↑ 1.0 15,150 1

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

  • Output: project44_1.id
  • Buffers: shared hit=1782
175. 75.750 75.750 ↑ 1.0 1 15,150

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project45 (cost=0.29..2.30 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=15,150)

  • Output: project45.clientbillingallocationmethod
  • Index Cond: (project45.id = "*SELECT* 1".projectid)
  • Buffers: shared hit=46030
Planning time : 6.191 ms
Execution time : 162,482.346 ms