explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1sBe : Q2

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 385,757.884 ↑ 1.0 20 1

Limit (cost=5,565,007.84..5,565,007.89 rows=20 width=236) (actual time=385,757.873..385,757.884 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=402871693 read=4268
2. 47.040 385,757.875 ↑ 1,165.7 20 1

Sort (cost=5,565,007.84..5,565,066.13 rows=23,313 width=236) (actual time=385,757.871..385,757.875 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=402871693 read=4268
3. 462.044 385,710.835 ↑ 1.5 15,150 1

Result (cost=16,589.87..5,564,387.49 rows=23,313 width=236) (actual time=222,190.083..385,710.835 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=402871686 read=4268
4. 10.846 221,437.327 ↑ 1.5 15,150 1

Append (cost=768.76..12,253.42 rows=23,313 width=236) (actual time=221,288.035..221,437.327 rows=15,150 loops=1)

  • Buffers: shared hit=200106607 read=2172
5. 86.471 221,412.912 ↓ 15,150.0 15,150 1

Subquery Scan on *SELECT* 1 (cost=768.76..6,524.63 rows=1 width=236) (actual time=221,288.035..221,412.912 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=200104359 read=595
6. 47.611 98.381 ↓ 15,150.0 15,150 1

Merge Anti Join (cost=0.57..5,756.43 rows=1 width=236) (actual time=10.551..98.381 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=20253 read=595
7. 40.240 40.240 ↓ 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.016..40.240 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=8669 read=595
8. 10.530 10.530 ↓ 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.530..10.530 rows=0 loops=1)

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

SubPlan (forSubquery Scan)

10. 59,117.888 221,228.060 ↓ 15,150.0 15,150 1

Nested Loop (cost=0.50..4.54 rows=1 width=4) (actual time=0.043..221,228.060 rows=15,150 loops=1)

  • Output: project46.id
  • Join Filter: (project46.id = project47.id)
  • Rows Removed by Join Filter: 229507350
  • Buffers: shared hit=200084106
11. 20.322 20.322 ↓ 15,150.0 15,150 1

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

  • Output: project46.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
12. 162,089.850 162,089.850 ↓ 15,150.0 15,150 15,150

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

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

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

  • Output: project48.id
  • 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.25..2.26 rows=1 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..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment49.projectid, projectsharingassignment49.userid
  • Index Cond: (projectsharingassignment49.projectid = project48.id)
  • Heap Fetches: 0
16. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 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

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

  • Output: project50.id, projectclient51.clientid
18. 0.000 0.000 ↓ 0.0 0

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

  • Output: project50.id
  • Heap Fetches: 0
19. 0.000 0.000 ↓ 0.0 0

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

  • Output: projectclient51.projectid, projectclient51.clientid, projectclient51.effectivedate, projectclient51.enddate
  • Index Cond: (projectclient51.projectid = project50.id)
  • Heap Fetches: 0
20. 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
21. 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
22. 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
23. 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)
24. 0.000 13.569 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=768.18..5,728.79 rows=23,312 width=236) (actual time=13.569..13.569 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=2248 read=1577
25. 13.569 13.569 ↓ 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=13.569..13.569 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=2248 read=1577
26.          

SubPlan (forSubquery Scan)

27. 59,117.888 221,228.060 ↓ 15,150.0 15,150 1

Nested Loop (cost=0.50..4.54 rows=1 width=4) (actual time=0.043..221,228.060 rows=15,150 loops=1)

  • Output: project46.id
  • Join Filter: (project46.id = project47.id)
  • Rows Removed by Join Filter: 229507350
  • Buffers: shared hit=200084106
28. 20.322 20.322 ↓ 15,150.0 15,150 1

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

  • Output: project46.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
29. 162,089.850 162,089.850 ↓ 15,150.0 15,150 15,150

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

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

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

  • Output: project48.id
  • Filter: ((project48.projectleaderapproverid = 2) OR (projectsharingassignment49.userid = 2))
31. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project48 (cost=0.25..2.26 rows=1 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
32. 0.000 0.000 ↓ 0.0 0

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

  • Output: projectsharingassignment49.projectid, projectsharingassignment49.userid
  • Index Cond: (projectsharingassignment49.projectid = project48.id)
  • Heap Fetches: 0
33. 0.000 0.000 ↓ 0.0 0

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

  • Output: project50.id
  • Hash Cond: (projectclient51.clientid = clients52.id)
  • Filter: ((clients52.clientmanageruserid = 2) OR (clientsharingassignment53.userid = 2))
34. 0.000 0.000 ↓ 0.0 0

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

  • Output: project50.id, projectclient51.clientid
35. 0.000 0.000 ↓ 0.0 0

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

  • Output: project50.id
  • Heap Fetches: 0
36. 0.000 0.000 ↓ 0.0 0

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

  • Output: projectclient51.projectid, projectclient51.clientid, projectclient51.effectivedate, projectclient51.enddate
  • Index Cond: (projectclient51.projectid = project50.id)
  • Heap Fetches: 0
37. 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
38. 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
39. 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
40. 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)
41.          

SubPlan (forResult)

42. 21.360 129.725 ↑ 2.6 15,150 1

Hash Left Join (cost=10.44..1,879.56 rows=39,233 width=4) (actual time=22.367..129.725 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=80872 read=2096
43. 7.295 93.015 ↓ 1.5 15,150 1

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

  • Output: project1.id, project1.projectleaderapproverid, projectsharingassignment2.userid, projectclient3.clientid
  • Merge Cond: (project1.id = projectsharingassignment2.projectid)
  • Buffers: shared hit=65026 read=1815
44. 13.912 85.713 ↓ 17.0 15,150 1

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

  • Output: project1.id, project1.projectleaderapproverid, projectclient3.clientid
  • Buffers: shared hit=65025 read=1815
45. 11.201 11.201 ↓ 15,150.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1 (cost=0.25..2.26 rows=1 width=8) (actual time=0.007..11.201 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
46. 60.600 60.600 ↑ 891.0 1 15,150

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

  • Output: projectclient3.projectid, projectclient3.clientid, projectclient3.effectivedate, projectclient3.enddate
  • Index Cond: (projectclient3.projectid = project1.id)
  • Heap Fetches: 25037
  • Buffers: shared hit=51819 read=1815
47. 0.004 0.007 ↓ 0.0 0 1

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

  • Output: projectsharingassignment2.projectid, projectsharingassignment2.userid
  • Buffers: shared hit=1
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.546 4.685 ↓ 189.4 1,515 1

Hash (cost=9.64..9.64 rows=8 width=12) (actual time=4.685..4.685 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=2640 read=281
50. 1.911 4.139 ↓ 189.4 1,515 1

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

  • Output: clients4.id, clients4.clientmanageruserid, clientsharingassignment5.userid
  • Buffers: shared hit=2640 read=281
51. 2.228 2.228 ↓ 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.027..2.228 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=1125 read=281
52. 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
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.25..2.27 rows=1 width=0) (never executed)

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

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

  • Output: project6_1.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
56. 15.150 53,964.300 ↑ 1.0 1 15,150

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

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

Sort (cost=4.60..4.61 rows=1 width=536) (actual time=3.561..3.561 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=67316713
58. 16,316.550 53,858.250 ↑ 1.0 1 15,150

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

  • Output: clients7.name, projectclient8.costallocationpercentage
  • Buffers: shared hit=67316710
59. 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
60. 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
61. 21.471 99.651 ↑ 2.6 15,150 1

Hash Left Join (cost=10.44..1,879.56 rows=39,233 width=4) (actual time=20.742..99.651 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=82968
62. 7.093 64.345 ↓ 1.5 15,150 1

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

  • Output: project1_1.id, project1_1.projectleaderapproverid, projectsharingassignment2_1.userid, projectclient3_1.clientid
  • Merge Cond: (project1_1.id = projectsharingassignment2_1.projectid)
  • Buffers: shared hit=66841
63. 15.862 57.241 ↓ 17.0 15,150 1

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

  • Output: project1_1.id, project1_1.projectleaderapproverid, projectclient3_1.clientid
  • Buffers: shared hit=66840
64. 11.079 11.079 ↓ 15,150.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1_1 (cost=0.25..2.26 rows=1 width=8) (actual time=0.007..11.079 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
65. 30.300 30.300 ↑ 891.0 1 15,150

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

  • Output: projectclient3_1.projectid, projectclient3_1.clientid, projectclient3_1.effectivedate, projectclient3_1.enddate
  • Index Cond: (projectclient3_1.projectid = project1_1.id)
  • Heap Fetches: 25037
  • Buffers: shared hit=53634
66. 0.008 0.011 ↓ 0.0 0 1

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

  • Output: projectsharingassignment2_1.projectid, projectsharingassignment2_1.userid
  • Buffers: shared hit=1
67. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Output: projectsharingassignment2_1.projectid, projectsharingassignment2_1.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
68. 0.550 3.276 ↓ 189.4 1,515 1

Hash (cost=9.64..9.64 rows=8 width=12) (actual time=3.276..3.276 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
69. 1.859 2.726 ↓ 189.4 1,515 1

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

  • Output: clients4_1.id, clients4_1.clientmanageruserid, clientsharingassignment5_1.userid
  • Buffers: shared hit=2921
70. 0.867 0.867 ↓ 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.007..0.867 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
71. 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
72.          

SubPlan (forHash Left Join)

73. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project6_2.id = project1_1.id)
  • Heap Fetches: 0
74. 10.559 10.559 ↓ 15,150.0 15,150 1

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

  • Output: project6_3.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
75. 30.300 54,449.100 ↑ 1.0 1 15,150

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

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

Sort (cost=4.60..4.61 rows=1 width=540) (actual time=3.592..3.592 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
77. 16,725.600 54,327.900 ↑ 1.0 1 15,150

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

  • Output: clients9.id, projectclient10.costallocationpercentage, clients9.name
  • Buffers: shared hit=67316710
78. 14,650.050 14,650.050 ↓ 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.967 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
79. 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
80. 21.317 99.736 ↑ 2.6 15,150 1

Hash Left Join (cost=10.44..1,879.56 rows=39,233 width=4) (actual time=20.960..99.736 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=82968
81. 7.339 64.512 ↓ 1.5 15,150 1

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

  • Output: project1_2.id, project1_2.projectleaderapproverid, projectsharingassignment2_2.userid, projectclient3_2.clientid
  • Merge Cond: (project1_2.id = projectsharingassignment2_2.projectid)
  • Buffers: shared hit=66841
82. 15.796 57.168 ↓ 17.0 15,150 1

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

  • Output: project1_2.id, project1_2.projectleaderapproverid, projectclient3_2.clientid
  • Buffers: shared hit=66840
83. 11.072 11.072 ↓ 15,150.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1_2 (cost=0.25..2.26 rows=1 width=8) (actual time=0.008..11.072 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
84. 30.300 30.300 ↑ 891.0 1 15,150

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

  • Output: projectclient3_2.projectid, projectclient3_2.clientid, projectclient3_2.effectivedate, projectclient3_2.enddate
  • Index Cond: (projectclient3_2.projectid = project1_2.id)
  • Heap Fetches: 25037
  • Buffers: shared hit=53634
85. 0.003 0.005 ↓ 0.0 0 1

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

  • Output: projectsharingassignment2_2.projectid, projectsharingassignment2_2.userid
  • Buffers: shared hit=1
86. 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
87. 0.550 3.432 ↓ 189.4 1,515 1

Hash (cost=9.64..9.64 rows=8 width=12) (actual time=3.432..3.432 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
88. 1.885 2.882 ↓ 189.4 1,515 1

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

  • Output: clients4_2.id, clients4_2.clientmanageruserid, clientsharingassignment5_2.userid
  • Buffers: shared hit=2921
89. 0.997 0.997 ↓ 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..0.997 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
90. 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
91.          

SubPlan (forHash Left Join)

92. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project6_4.id = project1_2.id)
  • Heap Fetches: 0
93. 10.475 10.475 ↓ 15,150.0 15,150 1

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

  • Output: project6_5.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
94. 30.300 54,297.600 ↑ 1.0 1 15,150

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

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

Sort (cost=4.60..4.61 rows=1 width=1,052) (actual time=3.582..3.582 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
96. 16,558.950 54,176.400 ↑ 1.0 1 15,150

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

  • Output: clients11.slug, projectclient12.costallocationpercentage, clients11.name
  • Buffers: shared hit=67316710
97. 14,665.200 14,665.200 ↓ 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.968 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
98. 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
99. 20.736 98.479 ↑ 2.6 15,150 1

Hash Left Join (cost=10.44..1,879.56 rows=39,233 width=4) (actual time=20.980..98.479 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=82968
100. 7.311 63.787 ↓ 1.5 15,150 1

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

  • Output: project13.id, project13.projectleaderapproverid, projectsharingassignment14.userid, projectclient15.clientid
  • Merge Cond: (project13.id = projectsharingassignment14.projectid)
  • Buffers: shared hit=66841
101. 15.307 56.471 ↓ 17.0 15,150 1

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

  • Output: project13.id, project13.projectleaderapproverid, projectclient15.clientid
  • Buffers: shared hit=66840
102. 10.864 10.864 ↓ 15,150.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project13 (cost=0.25..2.26 rows=1 width=8) (actual time=0.008..10.864 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
103. 30.300 30.300 ↑ 891.0 1 15,150

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

  • Output: projectclient15.projectid, projectclient15.clientid, projectclient15.effectivedate, projectclient15.enddate
  • Index Cond: (projectclient15.projectid = project13.id)
  • Heap Fetches: 25037
  • Buffers: shared hit=53634
104. 0.003 0.005 ↓ 0.0 0 1

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

  • Output: projectsharingassignment14.projectid, projectsharingassignment14.userid
  • Buffers: shared hit=1
105. 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
106. 0.490 3.420 ↓ 189.4 1,515 1

Hash (cost=9.64..9.64 rows=8 width=12) (actual time=3.420..3.420 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
107. 1.923 2.930 ↓ 189.4 1,515 1

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

  • Output: clients16.id, clients16.clientmanageruserid, clientsharingassignment17.userid
  • Buffers: shared hit=2921
108. 1.007 1.007 ↓ 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.008..1.007 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
109. 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
110.          

SubPlan (forHash Left Join)

111. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project18.id = project13.id)
  • Heap Fetches: 0
112. 10.536 10.536 ↓ 15,150.0 15,150 1

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

  • Output: project18_1.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
113. 21.435 101.684 ↑ 2.6 15,150 1

Hash Left Join (cost=10.44..1,879.56 rows=39,233 width=4) (actual time=21.142..101.684 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=82968
114. 7.427 66.098 ↓ 1.5 15,150 1

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

  • Output: project19.id, project19.projectleaderapproverid, projectsharingassignment20.userid, projectclient21.clientid
  • Merge Cond: (project19.id = projectsharingassignment20.projectid)
  • Buffers: shared hit=66841
115. 17.007 58.666 ↓ 17.0 15,150 1

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

  • Output: project19.id, project19.projectleaderapproverid, projectclient21.clientid
  • Buffers: shared hit=66840
116. 11.359 11.359 ↓ 15,150.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project19 (cost=0.25..2.26 rows=1 width=8) (actual time=0.008..11.359 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
117. 30.300 30.300 ↑ 891.0 1 15,150

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

  • Output: projectclient21.projectid, projectclient21.clientid, projectclient21.effectivedate, projectclient21.enddate
  • Index Cond: (projectclient21.projectid = project19.id)
  • Heap Fetches: 25037
  • Buffers: shared hit=53634
118. 0.003 0.005 ↓ 0.0 0 1

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

  • Output: projectsharingassignment20.projectid, projectsharingassignment20.userid
  • Buffers: shared hit=1
119. 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
120. 0.578 3.607 ↓ 189.4 1,515 1

Hash (cost=9.64..9.64 rows=8 width=12) (actual time=3.607..3.607 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
121. 1.932 3.029 ↓ 189.4 1,515 1

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

  • Output: clients22.id, clients22.clientmanageruserid, clientsharingassignment23.userid
  • Buffers: shared hit=2921
122. 1.097 1.097 ↓ 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.097 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
123. 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
124.          

SubPlan (forHash Left Join)

125. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project24.id = project19.id)
  • Heap Fetches: 0
126. 10.544 10.544 ↓ 15,150.0 15,150 1

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

  • Output: project24_1.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
127. 21.531 99.459 ↑ 2.6 15,150 1

Hash Left Join (cost=10.44..1,879.56 rows=39,233 width=4) (actual time=21.157..99.459 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=82968
128. 7.217 63.791 ↓ 1.5 15,150 1

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

  • Output: project25.id, project25.projectleaderapproverid, projectsharingassignment26.userid, projectclient27.clientid
  • Merge Cond: (project25.id = projectsharingassignment26.projectid)
  • Buffers: shared hit=66841
129. 15.331 56.567 ↓ 17.0 15,150 1

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

  • Output: project25.id, project25.projectleaderapproverid, projectclient27.clientid
  • Buffers: shared hit=66840
130. 10.936 10.936 ↓ 15,150.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project25 (cost=0.25..2.26 rows=1 width=8) (actual time=0.009..10.936 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
131. 30.300 30.300 ↑ 891.0 1 15,150

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

  • Output: projectclient27.projectid, projectclient27.clientid, projectclient27.effectivedate, projectclient27.enddate
  • Index Cond: (projectclient27.projectid = project25.id)
  • Heap Fetches: 25037
  • Buffers: shared hit=53634
132. 0.004 0.007 ↓ 0.0 0 1

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

  • Output: projectsharingassignment26.projectid, projectsharingassignment26.userid
  • Buffers: shared hit=1
133. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Output: projectsharingassignment26.projectid, projectsharingassignment26.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
134. 0.511 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
135. 1.905 3.024 ↓ 189.4 1,515 1

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

  • Output: clients28.id, clients28.clientmanageruserid, clientsharingassignment29.userid
  • Buffers: shared hit=2921
136. 1.119 1.119 ↓ 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.008..1.119 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
137. 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
138.          

SubPlan (forHash Left Join)

139. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project30.id = project25.id)
  • Heap Fetches: 0
140. 10.602 10.602 ↓ 15,150.0 15,150 1

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

  • Output: project30_1.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
141. 60.600 106.050 ↑ 1.0 1 15,150

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

  • Output: count(*)
  • Buffers: shared hit=53634
142. 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
143. 21.041 99.251 ↑ 2.6 15,150 1

Hash Left Join (cost=10.44..1,879.56 rows=39,233 width=4) (actual time=20.934..99.251 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=82968
144. 7.401 64.145 ↓ 1.5 15,150 1

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

  • Output: project32.id, project32.projectleaderapproverid, projectsharingassignment33.userid, projectclient34.clientid
  • Merge Cond: (project32.id = projectsharingassignment33.projectid)
  • Buffers: shared hit=66841
145. 15.439 56.737 ↓ 17.0 15,150 1

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

  • Output: project32.id, project32.projectleaderapproverid, projectclient34.clientid
  • Buffers: shared hit=66840
146. 10.998 10.998 ↓ 15,150.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project32 (cost=0.25..2.26 rows=1 width=8) (actual time=0.012..10.998 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
147. 30.300 30.300 ↑ 891.0 1 15,150

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

  • Output: projectclient34.projectid, projectclient34.clientid, projectclient34.effectivedate, projectclient34.enddate
  • Index Cond: (projectclient34.projectid = project32.id)
  • Heap Fetches: 25037
  • Buffers: shared hit=53634
148. 0.005 0.007 ↓ 0.0 0 1

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

  • Output: projectsharingassignment33.projectid, projectsharingassignment33.userid
  • Buffers: shared hit=1
149. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Output: projectsharingassignment33.projectid, projectsharingassignment33.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
150. 0.508 3.658 ↓ 189.4 1,515 1

Hash (cost=9.64..9.64 rows=8 width=12) (actual time=3.658..3.658 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
151. 1.952 3.150 ↓ 189.4 1,515 1

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

  • Output: clients35.id, clients35.clientmanageruserid, clientsharingassignment36.userid
  • Buffers: shared hit=2921
152. 1.198 1.198 ↓ 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.013..1.198 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
153. 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
154.          

SubPlan (forHash Left Join)

155. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project37.id = project32.id)
  • Heap Fetches: 0
156. 10.407 10.407 ↓ 15,150.0 15,150 1

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

  • Output: project37_1.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
157. 45.450 90.900 ↑ 1.0 1 15,150

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

  • Output: projectclient38.effectivedate
  • Group Key: projectclient38.effectivedate
  • Buffers: shared hit=53634
158. 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
159. 21.025 99.779 ↑ 2.6 15,150 1

Hash Left Join (cost=10.44..1,879.56 rows=39,233 width=4) (actual time=21.393..99.779 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=82968
160. 7.191 64.325 ↓ 1.5 15,150 1

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

  • Output: project39.id, project39.projectleaderapproverid, projectsharingassignment40.userid, projectclient41.clientid
  • Merge Cond: (project39.id = projectsharingassignment40.projectid)
  • Buffers: shared hit=66841
161. 15.647 57.129 ↓ 17.0 15,150 1

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

  • Output: project39.id, project39.projectleaderapproverid, projectclient41.clientid
  • Buffers: shared hit=66840
162. 11.182 11.182 ↓ 15,150.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project39 (cost=0.25..2.26 rows=1 width=8) (actual time=0.008..11.182 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
163. 30.300 30.300 ↑ 891.0 1 15,150

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

  • Output: projectclient41.projectid, projectclient41.clientid, projectclient41.effectivedate, projectclient41.enddate
  • Index Cond: (projectclient41.projectid = project39.id)
  • Heap Fetches: 25037
  • Buffers: shared hit=53634
164. 0.003 0.005 ↓ 0.0 0 1

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

  • Output: projectsharingassignment40.projectid, projectsharingassignment40.userid
  • Buffers: shared hit=1
165. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Output: projectsharingassignment40.projectid, projectsharingassignment40.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
166. 0.522 3.635 ↓ 189.4 1,515 1

Hash (cost=9.64..9.64 rows=8 width=12) (actual time=3.635..3.635 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
167. 1.956 3.113 ↓ 189.4 1,515 1

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

  • Output: clients42.id, clients42.clientmanageruserid, clientsharingassignment43.userid
  • Buffers: shared hit=2921
168. 1.157 1.157 ↓ 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.008..1.157 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
169. 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
170.          

SubPlan (forHash Left Join)

171. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (project44.id = project39.id)
  • Heap Fetches: 0
172. 10.794 10.794 ↓ 15,150.0 15,150 1

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

  • Output: project44_1.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
173. 75.750 75.750 ↑ 1.0 1 15,150

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project45 (cost=0.25..2.27 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 : 8.558 ms
Execution time : 385,761.080 ms