explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6mc3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,221.95..6,978,563,071.09 rows=37,946 width=8,037) (actual rows= loops=)

  • Hash Cond: (clients0.clientmanageruserid = login2.userid)
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=831.48..1,876.55 rows=37,946 width=7,862) (actual rows= loops=)

  • Hash Cond: (clients0.clientmanageruserid = userinfo1.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on clients clients0 (cost=0.00..945.46 rows=37,946 width=7,813) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=693.99..693.99 rows=10,999 width=49) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on userinfo userinfo1 (cost=0.00..693.99 rows=10,999 width=49) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=252.99..252.99 rows=10,999 width=31) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on login login2 (cost=0.00..252.99 rows=10,999 width=31) (actual rows= loops=)

8.          

SubPlan (for Hash Left Join)

9. 0.000 0.000 ↓ 0.0

Aggregate (cost=8,123.06..8,123.07 rows=1 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=0) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc.projectid
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient.projectid = pc.projectid) AND ((max(projectclient.effectivedate)) = pc.effectivedate))
13. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient.projectid
14. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
17. 0.000 0.000 ↓ 0.0

Index Only Scan using project_pkey on project project3 (cost=0.42..2.44 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = projectclient.projectid)
18. 0.000 0.000 ↓ 0.0

Aggregate (cost=8,124.87..8,124.88 rows=1 width=8) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,124.87 rows=1 width=4) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc_1.projectid
21. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient_1.projectid = pc_1.projectid) AND ((max(projectclient_1.effectivedate)) = pc_1.effectivedate))
22. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_1.projectid
23. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_1 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc_1 (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
26. 0.000 0.000 ↓ 0.0

Index Scan using uix3ptm_projectrole on projectteammember projectteammember5 (cost=0.42..4.24 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_1.projectid)
  • Filter: (userid IS NOT NULL)
27. 0.000 0.000 ↓ 0.0

Aggregate (cost=8,122.95..8,122.96 rows=1 width=8) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,122.95 rows=1 width=0) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc_2.projectid
30. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient_2.projectid = pc_2.projectid) AND ((max(projectclient_2.effectivedate)) = pc_2.effectivedate))
31. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_2.projectid
32. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_2 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc_2 (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
35. 0.000 0.000 ↓ 0.0

Index Only Scan using uix3ptm_projectrole on projectteammember projectteammember7 (cost=0.42..2.32 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((projectid = projectclient_2.projectid) AND (placeholderprojectroleid IS NOT NULL))
36. 0.000 0.000 ↓ 0.0

Unique (cost=60.83..60.84 rows=1 width=32) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Sort (cost=60.83..60.84 rows=1 width=32) (actual rows= loops=)

  • Sort Key: (sum((((userprojectroleratehistory9.hourlyrate * exchangerate10.exchangevalue) * ((date_part('epoch'::text, _projecttimeallocation_facts11.duration))::numeric / '3600'::numeric)) * (CASE WHEN (project12.clientbillingallocationmethod = 1) THEN '100'::numeric ELSE COALESCE(projectclient13.costallocationpercentage, '100'::numeric) END / '100'::numeric))))
38. 0.000 0.000 ↓ 0.0

Aggregate (cost=60.81..60.82 rows=1 width=32) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.26..60.79 rows=1 width=48) (actual rows= loops=)

  • Join Filter: (exchangerate10.fixedcurrencyid = userprojectroleratehistory9.currencyid)
40. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.12..60.61 rows=1 width=36) (actual rows= loops=)

  • Join Filter: (project12.clientbillingallocationmethod = 0)
41. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.70..60.16 rows=1 width=35) (actual rows= loops=)

  • Join Filter: (upper(ojecttimeallocation_metadata14.uri) = upper(('urn:replicon-tenant:1b8a55aa5f704dea918923fe2daf8cda:client:'::text || COALESCE((clients15.id)::text, ''::text))))
42. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.41..57.82 rows=1 width=115) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..57.41 rows=1 width=51) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..54.55 rows=9 width=48) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Index Scan using dbatest on project project12 (cost=0.42..1.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (clientbillingallocationmethod = 1)
46. 0.000 0.000 ↓ 0.0

Index Scan using ixpta2projectid on dm_projecttimeallocation_facts _projecttimeallocation_facts11 (cost=0.43..52.60 rows=51 width=44) (actual rows= loops=)

  • Index Cond: (projectid = project12.id)
47. 0.000 0.000 ↓ 0.0

Index Scan using ixuprrhuserid on userprojectroleratehistory userprojectroleratehistory9 (cost=0.29..0.31 rows=1 width=19) (actual rows= loops=)

  • Index Cond: (userid = _projecttimeallocation_facts11.userid)
  • Filter: ((effectivedate <= _projecttimeallocation_facts11.entrydate) AND (enddate >= _projecttimeallocation_facts11.entrydate))
48. 0.000 0.000 ↓ 0.0

Index Scan using ixptamfactid_client on dm_projecttimeallocation_metadata ojecttimeallocation_metadata14 (cost=0.28..0.41 rows=1 width=96) (actual rows= loops=)

  • Index Cond: (factid = _projecttimeallocation_facts11.id)
49. 0.000 0.000 ↓ 0.0

Index Only Scan using clients_pkey on clients clients15 (cost=0.29..2.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = clients0.id)
50. 0.000 0.000 ↓ 0.0

Index Scan using dbatest2 on projectclient projectclient13 (cost=0.42..0.44 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (projectid = _projecttimeallocation_facts11.projectid)
  • Filter: ((_projecttimeallocation_facts11.entrydate >= effectivedate) AND (_projecttimeallocation_facts11.entrydate <= enddate))
51. 0.000 0.000 ↓ 0.0

Index Scan using uix3er_currencyideffectivedate on exchangerate exchangerate10 (cost=0.14..0.16 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((variablecurrencyid = 5) AND (effectivedate <= _projecttimeallocation_facts11.entrydate))
  • Filter: (enddate >= _projecttimeallocation_facts11.entrydate)
52. 0.000 0.000 ↓ 0.0

Unique (cost=1,353.43..1,353.43 rows=1 width=32) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Sort (cost=1,353.43..1,353.43 rows=1 width=32) (actual rows= loops=)

  • Sort Key: (sum((((userprojectroleratehistory16.hourlyrate * exchangerate17.exchangevalue) * ((date_part('epoch'::text, _projecttimeallocation_facts18.duration))::numeric / '3600'::numeric)) * (CASE WHEN (project19.clientbillingallocationmethod = 1) THEN '100'::numeric ELSE COALESCE(projectclient20.costallocationpercentage, '100'::numeric) END / '100'::numeric))))
54. 0.000 0.000 ↓ 0.0

Aggregate (cost=1,353.41..1,353.42 rows=1 width=32) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=26.05..1,353.38 rows=1 width=48) (actual rows= loops=)

  • Join Filter: (exchangerate17.fixedcurrencyid = userprojectroleratehistory16.currencyid)
56. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=25.91..1,353.21 rows=1 width=36) (actual rows= loops=)

  • Hash Cond: (upper(('urn:replicon-tenant:1b8a55aa5f704dea918923fe2daf8cda:client:'::text || COALESCE((clients22.id)::text, ''::text))) = upper(ojecttimeallocation_metadata21.uri))
  • Join Filter: (project19.clientbillingallocationmethod = 1)
57. 0.000 0.000 ↓ 0.0

Seq Scan on clients clients22 (cost=0.00..945.46 rows=37,946 width=4) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Hash (cost=25.90..25.90 rows=1 width=116) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.83..25.90 rows=1 width=116) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.55..25.48 rows=1 width=52) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.27..24.21 rows=4 width=49) (actual rows= loops=)

  • Join Filter: ((_projecttimeallocation_facts18.entrydate >= projectclient20.effectivedate) AND (_projecttimeallocation_facts18.entrydate <= projectclient20.enddate))
62. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..15.24 rows=4 width=25) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient projectclient20 (cost=0.42..5.47 rows=4 width=17) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
64. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project19 (cost=0.42..2.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = projectclient20.projectid)
  • Filter: ((clientbillingallocationmethod <> 1) AND (clientbillingallocationmethod = 0))
65. 0.000 0.000 ↓ 0.0

Index Scan using ixpta2projectid on dm_projecttimeallocation_facts _projecttimeallocation_facts18 (cost=0.43..1.48 rows=51 width=44) (actual rows= loops=)

  • Index Cond: (projectid = project19.id)
66. 0.000 0.000 ↓ 0.0

Index Scan using ixuprrhuserid on userprojectroleratehistory userprojectroleratehistory16 (cost=0.29..0.31 rows=1 width=19) (actual rows= loops=)

  • Index Cond: (userid = _projecttimeallocation_facts18.userid)
  • Filter: ((effectivedate <= _projecttimeallocation_facts18.entrydate) AND (enddate >= _projecttimeallocation_facts18.entrydate))
67. 0.000 0.000 ↓ 0.0

Index Scan using ixptamfactid_client on dm_projecttimeallocation_metadata ojecttimeallocation_metadata21 (cost=0.28..0.41 rows=1 width=96) (actual rows= loops=)

  • Index Cond: (factid = _projecttimeallocation_facts18.id)
68. 0.000 0.000 ↓ 0.0

Index Scan using uix3er_currencyideffectivedate on exchangerate exchangerate17 (cost=0.14..0.16 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((variablecurrencyid = 5) AND (effectivedate <= _projecttimeallocation_facts18.entrydate))
  • Filter: (enddate >= _projecttimeallocation_facts18.entrydate)
69. 0.000 0.000 ↓ 0.0

Aggregate (cost=296.05..296.06 rows=1 width=32) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.85..295.82 rows=45 width=23) (actual rows= loops=)

  • Join Filter: ((exchangerate24.effectivedate <= billingitem223.entrydate) AND (exchangerate24.enddate >= billingitem223.entrydate) AND (exchangerate24.fixedcurrencyid = billingitem223.currencyid))
71. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..293.31 rows=45 width=11) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Index Scan using ixbi2dmclientid on billingitem2denormalizedmetadata ingitem2denormalizedmetadata25 (cost=0.43..87.93 rows=84 width=16) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
  • Filter: ((billingtypeuri IS NULL) OR (upper(billingtypeuri) <> 'URN:REPLICON:BILLING-ITEM-TYPE:EXPENSE'::text))
73. 0.000 0.000 ↓ 0.0

Index Scan using billingitem2_pkey on billingitem2 billingitem223 (cost=0.43..2.45 rows=1 width=27) (actual rows= loops=)

  • Index Cond: (id = ingitem2denormalizedmetadata25.billingitemid)
  • Filter: isbillable
74. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.62 rows=1 width=32) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Seq Scan on exchangerate exchangerate24 (cost=0.00..1.61 rows=1 width=32) (actual rows= loops=)

  • Filter: (variablecurrencyid = 5)
76. 0.000 0.000 ↓ 0.0

Unique (cost=61.13..61.14 rows=1 width=16) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Sort (cost=61.13..61.14 rows=1 width=16) (actual rows= loops=)

  • Sort Key: (sum(CASE WHEN (project26.clientbillingallocationmethod = 1) THEN _projecttimeallocation_facts27.duration ELSE (_projecttimeallocation_facts27.duration * ((COALESCE(projectclient28.costallocationpercentage, '100'::numeric) / '100'::numeric))::double precision) END))
78. 0.000 0.000 ↓ 0.0

Aggregate (cost=61.11..61.12 rows=1 width=16) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.83..61.10 rows=1 width=25) (actual rows= loops=)

  • Join Filter: (project26.clientbillingallocationmethod = 0)
80. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.41..60.64 rows=1 width=28) (actual rows= loops=)

  • Join Filter: (upper(ojecttimeallocation_metadata29.uri) = upper(('urn:replicon-tenant:1b8a55aa5f704dea918923fe2daf8cda:client:'::text || COALESCE((clients30.id)::text, ''::text))))
81. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..58.31 rows=1 width=108) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..54.55 rows=9 width=44) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Index Scan using dbatest on project project26 (cost=0.42..1.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (clientbillingallocationmethod = 1)
84. 0.000 0.000 ↓ 0.0

Index Scan using ixpta2projectid on dm_projecttimeallocation_facts _projecttimeallocation_facts27 (cost=0.43..52.60 rows=51 width=40) (actual rows= loops=)

  • Index Cond: (projectid = project26.id)
85. 0.000 0.000 ↓ 0.0

Index Scan using ixptamfactid_client on dm_projecttimeallocation_metadata ojecttimeallocation_metadata29 (cost=0.28..0.41 rows=1 width=96) (actual rows= loops=)

  • Index Cond: (factid = _projecttimeallocation_facts27.id)
86. 0.000 0.000 ↓ 0.0

Index Only Scan using clients_pkey on clients clients30 (cost=0.29..2.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = clients0.id)
87. 0.000 0.000 ↓ 0.0

Index Scan using dbatest2 on projectclient projectclient28 (cost=0.42..0.44 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (projectid = _projecttimeallocation_facts27.projectid)
  • Filter: ((_projecttimeallocation_facts27.entrydate >= effectivedate) AND (_projecttimeallocation_facts27.entrydate <= enddate))
88. 0.000 0.000 ↓ 0.0

Unique (cost=1,360.41..1,360.42 rows=1 width=16) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Sort (cost=1,360.41..1,360.41 rows=1 width=16) (actual rows= loops=)

  • Sort Key: (sum(CASE WHEN (project31.clientbillingallocationmethod = 1) THEN _projecttimeallocation_facts32.duration ELSE (_projecttimeallocation_facts32.duration * ((COALESCE(projectclient33.costallocationpercentage, '100'::numeric) / '100'::numeric))::double precision) END))
90. 0.000 0.000 ↓ 0.0

Aggregate (cost=1,360.39..1,360.40 rows=1 width=16) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=25.93..1,360.34 rows=4 width=25) (actual rows= loops=)

  • Hash Cond: (upper(('urn:replicon-tenant:1b8a55aa5f704dea918923fe2daf8cda:client:'::text || COALESCE((clients35.id)::text, ''::text))) = upper(ojecttimeallocation_metadata34.uri))
  • Join Filter: (project31.clientbillingallocationmethod = 1)
92. 0.000 0.000 ↓ 0.0

Seq Scan on clients clients35 (cost=0.00..945.46 rows=37,946 width=4) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Hash (cost=25.88..25.88 rows=4 width=105) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.54..25.88 rows=4 width=105) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.27..24.21 rows=4 width=41) (actual rows= loops=)

  • Join Filter: ((_projecttimeallocation_facts32.entrydate >= projectclient33.effectivedate) AND (_projecttimeallocation_facts32.entrydate <= projectclient33.enddate))
96. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..15.24 rows=4 width=25) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient projectclient33 (cost=0.42..5.47 rows=4 width=17) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
98. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project31 (cost=0.42..2.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = projectclient33.projectid)
  • Filter: ((clientbillingallocationmethod <> 1) AND (clientbillingallocationmethod = 0))
99. 0.000 0.000 ↓ 0.0

Index Scan using ixpta2projectid on dm_projecttimeallocation_facts _projecttimeallocation_facts32 (cost=0.43..1.48 rows=51 width=40) (actual rows= loops=)

  • Index Cond: (projectid = project31.id)
100. 0.000 0.000 ↓ 0.0

Index Scan using ixptamfactid_client on dm_projecttimeallocation_metadata ojecttimeallocation_metadata34 (cost=0.28..0.41 rows=1 width=96) (actual rows= loops=)

  • Index Cond: (factid = _projecttimeallocation_facts32.id)
101. 0.000 0.000 ↓ 0.0

Aggregate (cost=15,640.20..15,640.21 rows=1 width=32) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=11,849.00..15,640.19 rows=1 width=49) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=33) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,848.44..15,639.55 rows=1 width=48) (actual rows= loops=)

  • Hash Cond: (projectclient_3.projectid = project36.id)
105. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_3.projectid
106. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_3 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Hash (cost=8,123.06..8,123.06 rows=1 width=40) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=40) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc_4.projectid
110. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient_4.projectid = pc_4.projectid) AND ((max(projectclient_4.effectivedate)) = pc_4.effectivedate))
111. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_4.projectid
112. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_4 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc_4 (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
115. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project36 (cost=0.42..2.44 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = projectclient_4.projectid)
116. 0.000 0.000 ↓ 0.0

Index Scan using dbatest2 on projectclient pc_3 (cost=0.42..0.45 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_3.projectid)
  • Filter: ((clientid = clients0.id) AND ((max(projectclient_3.effectivedate)) = effectivedate))
117. 0.000 0.000 ↓ 0.0

Index Scan using uix3er_currencyideffectivedate on exchangerate exchangerate37 (cost=0.14..0.17 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((variablecurrencyid = 5) AND (fixedcurrencyid = project36.estimatedcostcurrencyid) AND (effectivedate <= '2020-01-03'::date))
  • Filter: (enddate >= '2020-01-03'::date)
118. 0.000 0.000 ↓ 0.0

Aggregate (cost=15,640.20..15,640.21 rows=1 width=32) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=11,849.00..15,640.19 rows=1 width=49) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=33) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,848.44..15,639.55 rows=1 width=48) (actual rows= loops=)

  • Hash Cond: (projectclient_5.projectid = project36_1.id)
122. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_5.projectid
123. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_5 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Hash (cost=8,123.06..8,123.06 rows=1 width=40) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=40) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc_6.projectid
127. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient_6.projectid = pc_6.projectid) AND ((max(projectclient_6.effectivedate)) = pc_6.effectivedate))
128. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_6.projectid
129. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_6 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc_6 (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
132. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project36_1 (cost=0.42..2.44 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = projectclient_6.projectid)
133. 0.000 0.000 ↓ 0.0

Index Scan using dbatest2 on projectclient pc_5 (cost=0.42..0.45 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_5.projectid)
  • Filter: ((clientid = clients0.id) AND ((max(projectclient_5.effectivedate)) = effectivedate))
134. 0.000 0.000 ↓ 0.0

Index Scan using uix3er_currencyideffectivedate on exchangerate exchangerate37_1 (cost=0.14..0.17 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((variablecurrencyid = 5) AND (fixedcurrencyid = project36_1.estimatedcostcurrencyid) AND (effectivedate <= '2020-01-03'::date))
  • Filter: (enddate >= '2020-01-03'::date)
135. 0.000 0.000 ↓ 0.0

Aggregate (cost=15,640.20..15,640.21 rows=1 width=32) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=11,849.00..15,640.19 rows=1 width=49) (actual rows= loops=)

137. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=33) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,848.44..15,639.55 rows=1 width=48) (actual rows= loops=)

  • Hash Cond: (projectclient_7.projectid = project36_2.id)
139. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_7.projectid
140. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_7 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

Hash (cost=8,123.06..8,123.06 rows=1 width=40) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=40) (actual rows= loops=)

143. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc_8.projectid
144. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient_8.projectid = pc_8.projectid) AND ((max(projectclient_8.effectivedate)) = pc_8.effectivedate))
145. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_8.projectid
146. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_8 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

148. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc_8 (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
149. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project36_2 (cost=0.42..2.44 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = projectclient_8.projectid)
150. 0.000 0.000 ↓ 0.0

Index Scan using dbatest2 on projectclient pc_7 (cost=0.42..0.45 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_7.projectid)
  • Filter: ((clientid = clients0.id) AND ((max(projectclient_7.effectivedate)) = effectivedate))
151. 0.000 0.000 ↓ 0.0

Index Scan using uix3er_currencyideffectivedate on exchangerate exchangerate37_2 (cost=0.14..0.17 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((variablecurrencyid = 5) AND (fixedcurrencyid = project36_2.estimatedcostcurrencyid) AND (effectivedate <= '2020-01-03'::date))
  • Filter: (enddate >= '2020-01-03'::date)
152. 0.000 0.000 ↓ 0.0

Aggregate (cost=15,641.11..15,641.12 rows=1 width=32) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=11,849.43..15,641.10 rows=1 width=32) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,849.29..15,640.92 rows=1 width=16) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=29) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,848.44..15,639.55 rows=1 width=24) (actual rows= loops=)

  • Hash Cond: (projectclient_9.projectid = project40.id)
157. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_9.projectid
158. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_9 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Hash (cost=8,123.06..8,123.06 rows=1 width=16) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=16) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc_10.projectid
162. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient_10.projectid = pc_10.projectid) AND ((max(projectclient_10.effectivedate)) = pc_10.effectivedate))
163. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_10.projectid
164. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_10 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

165. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc_10 (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
167. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project40 (cost=0.42..2.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = projectclient_10.projectid)
168. 0.000 0.000 ↓ 0.0

Index Scan using dbatest2 on projectclient pc_9 (cost=0.42..0.45 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_9.projectid)
  • Filter: ((clientid = clients0.id) AND ((max(projectclient_9.effectivedate)) = effectivedate))
169. 0.000 0.000 ↓ 0.0

Index Scan using ixtkprojectid on task task41 (cost=0.42..0.77 rows=14 width=11) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_9.projectid)
170. 0.000 0.000 ↓ 0.0

Index Scan using uix3er_currencyideffectivedate on exchangerate exchangerate42 (cost=0.14..0.17 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((variablecurrencyid = 5) AND (fixedcurrencyid = task41.estimatedcostcurrencyid) AND (effectivedate <= '2020-01-03'::date))
  • Filter: (enddate >= '2020-01-03'::date)
171. 0.000 0.000 ↓ 0.0

Aggregate (cost=15,641.11..15,641.12 rows=1 width=32) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=11,849.43..15,641.10 rows=1 width=32) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,849.29..15,640.92 rows=1 width=16) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=29) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,848.44..15,639.55 rows=1 width=24) (actual rows= loops=)

  • Hash Cond: (projectclient_11.projectid = project40_1.id)
176. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_11.projectid
177. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_11 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Hash (cost=8,123.06..8,123.06 rows=1 width=16) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=16) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc_12.projectid
181. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient_12.projectid = pc_12.projectid) AND ((max(projectclient_12.effectivedate)) = pc_12.effectivedate))
182. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_12.projectid
183. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_12 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

184. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc_12 (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
186. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project40_1 (cost=0.42..2.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = projectclient_12.projectid)
187. 0.000 0.000 ↓ 0.0

Index Scan using dbatest2 on projectclient pc_11 (cost=0.42..0.45 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_11.projectid)
  • Filter: ((clientid = clients0.id) AND ((max(projectclient_11.effectivedate)) = effectivedate))
188. 0.000 0.000 ↓ 0.0

Index Scan using ixtkprojectid on task task41_1 (cost=0.42..0.77 rows=14 width=11) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_11.projectid)
189. 0.000 0.000 ↓ 0.0

Index Scan using uix3er_currencyideffectivedate on exchangerate exchangerate42_1 (cost=0.14..0.17 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((variablecurrencyid = 5) AND (fixedcurrencyid = task41_1.estimatedcostcurrencyid) AND (effectivedate <= '2020-01-03'::date))
  • Filter: (enddate >= '2020-01-03'::date)
190. 0.000 0.000 ↓ 0.0

Aggregate (cost=15,640.02..15,640.03 rows=1 width=16) (actual rows= loops=)

191. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=25) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,848.44..15,639.55 rows=1 width=40) (actual rows= loops=)

  • Hash Cond: (projectclient_13.projectid = project45.id)
193. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_13.projectid
194. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_13 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

Hash (cost=8,123.06..8,123.06 rows=1 width=32) (actual rows= loops=)

196. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=32) (actual rows= loops=)

197. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc_14.projectid
198. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient_14.projectid = pc_14.projectid) AND ((max(projectclient_14.effectivedate)) = pc_14.effectivedate))
199. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_14.projectid
200. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_14 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

202. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc_14 (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
203. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project45 (cost=0.42..2.44 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (id = projectclient_14.projectid)
204. 0.000 0.000 ↓ 0.0

Index Scan using dbatest2 on projectclient pc_13 (cost=0.42..0.45 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_13.projectid)
  • Filter: ((clientid = clients0.id) AND ((max(projectclient_13.effectivedate)) = effectivedate))
205. 0.000 0.000 ↓ 0.0

Aggregate (cost=15,640.02..15,640.03 rows=1 width=16) (actual rows= loops=)

206. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=25) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,848.44..15,639.55 rows=1 width=40) (actual rows= loops=)

  • Hash Cond: (projectclient_15.projectid = project45_1.id)
208. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_15.projectid
209. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_15 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Hash (cost=8,123.06..8,123.06 rows=1 width=32) (actual rows= loops=)

211. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=32) (actual rows= loops=)

212. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc_16.projectid
213. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient_16.projectid = pc_16.projectid) AND ((max(projectclient_16.effectivedate)) = pc_16.effectivedate))
214. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_16.projectid
215. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_16 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

216. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

217. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc_16 (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
218. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project45_1 (cost=0.42..2.44 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (id = projectclient_16.projectid)
219. 0.000 0.000 ↓ 0.0

Index Scan using dbatest2 on projectclient pc_15 (cost=0.42..0.45 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_15.projectid)
  • Filter: ((clientid = clients0.id) AND ((max(projectclient_15.effectivedate)) = effectivedate))
220. 0.000 0.000 ↓ 0.0

Aggregate (cost=15,640.02..15,640.03 rows=1 width=16) (actual rows= loops=)

221. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=25) (actual rows= loops=)

222. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,848.44..15,639.55 rows=1 width=40) (actual rows= loops=)

  • Hash Cond: (projectclient_17.projectid = project45_2.id)
223. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_17.projectid
224. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_17 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

Hash (cost=8,123.06..8,123.06 rows=1 width=32) (actual rows= loops=)

226. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=32) (actual rows= loops=)

227. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc_18.projectid
228. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient_18.projectid = pc_18.projectid) AND ((max(projectclient_18.effectivedate)) = pc_18.effectivedate))
229. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_18.projectid
230. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_18 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

231. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

232. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc_18 (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
233. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project45_2 (cost=0.42..2.44 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (id = projectclient_18.projectid)
234. 0.000 0.000 ↓ 0.0

Index Scan using dbatest2 on projectclient pc_17 (cost=0.42..0.45 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_17.projectid)
  • Filter: ((clientid = clients0.id) AND ((max(projectclient_17.effectivedate)) = effectivedate))
235. 0.000 0.000 ↓ 0.0

Aggregate (cost=15,640.93..15,640.94 rows=1 width=16) (actual rows= loops=)

236. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,849.29..15,640.92 rows=1 width=25) (actual rows= loops=)

237. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=29) (actual rows= loops=)

238. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,848.44..15,639.55 rows=1 width=24) (actual rows= loops=)

  • Hash Cond: (projectclient_19.projectid = project47.id)
239. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_19.projectid
240. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_19 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

241. 0.000 0.000 ↓ 0.0

Hash (cost=8,123.06..8,123.06 rows=1 width=16) (actual rows= loops=)

242. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=16) (actual rows= loops=)

243. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc_20.projectid
244. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient_20.projectid = pc_20.projectid) AND ((max(projectclient_20.effectivedate)) = pc_20.effectivedate))
245. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_20.projectid
246. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_20 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

247. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

248. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc_20 (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
249. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project47 (cost=0.42..2.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = projectclient_20.projectid)
250. 0.000 0.000 ↓ 0.0

Index Scan using dbatest2 on projectclient pc_19 (cost=0.42..0.45 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_19.projectid)
  • Filter: ((clientid = clients0.id) AND ((max(projectclient_19.effectivedate)) = effectivedate))
251. 0.000 0.000 ↓ 0.0

Index Scan using ixtkprojectid on task task48 (cost=0.42..0.77 rows=14 width=20) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_19.projectid)
252. 0.000 0.000 ↓ 0.0

Aggregate (cost=15,640.93..15,640.94 rows=1 width=16) (actual rows= loops=)

253. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,849.29..15,640.92 rows=1 width=25) (actual rows= loops=)

254. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=29) (actual rows= loops=)

255. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,848.44..15,639.55 rows=1 width=24) (actual rows= loops=)

  • Hash Cond: (projectclient_21.projectid = project47_1.id)
256. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_21.projectid
257. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_21 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

258. 0.000 0.000 ↓ 0.0

Hash (cost=8,123.06..8,123.06 rows=1 width=16) (actual rows= loops=)

259. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=16) (actual rows= loops=)

260. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual rows= loops=)

  • Group Key: pc_22.projectid
261. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: ((projectclient_22.projectid = pc_22.projectid) AND ((max(projectclient_22.effectivedate)) = pc_22.effectivedate))
262. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual rows= loops=)

  • Group Key: projectclient_22.projectid
263. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient projectclient_22 (cost=0.00..2,927.25 rows=159,625 width=8) (actual rows= loops=)

264. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=4 width=8) (actual rows= loops=)

265. 0.000 0.000 ↓ 0.0

Index Scan using ixpcclientid on projectclient pc_22 (cost=0.42..5.47 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (clientid = clients0.id)
266. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project47_1 (cost=0.42..2.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = projectclient_22.projectid)
267. 0.000 0.000 ↓ 0.0

Index Scan using dbatest2 on projectclient pc_21 (cost=0.42..0.45 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_21.projectid)
  • Filter: ((clientid = clients0.id) AND ((max(projectclient_21.effectivedate)) = effectivedate))
268. 0.000 0.000 ↓ 0.0

Index Scan using ixtkprojectid on task task48_1 (cost=0.42..0.77 rows=14 width=20) (actual rows= loops=)

  • Index Cond: (projectid = projectclient_21.projectid)