explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Ut : pwc_saasmaintenance

Settings
# exclusive inclusive rows x rows loops node
1. 2,421.488 27,368,006.508 ↑ 1.0 37,946 1

Hash Left Join (cost=1,221.95..6,978,563,501.27 rows=37,946 width=8,037) (actual time=1,737.017..27,368,006.508 rows=37,946 loops=1)

  • Hash Cond: (clients0.clientmanageruserid = login2.userid)
  • Buffers: shared hit=55,292,076
2. 86.346 140.876 ↑ 1.0 37,946 1

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

  • Hash Cond: (clients0.clientmanageruserid = userinfo1.id)
  • Buffers: shared hit=1,150
3. 47.965 47.965 ↑ 1.0 37,946 1

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

  • Buffers: shared hit=566
4. 2.593 6.565 ↑ 1.0 10,999 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,028kB
  • Buffers: shared hit=584
5. 3.972 3.972 ↑ 1.0 10,999 1

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

  • Buffers: shared hit=584
6. 1.860 3.216 ↑ 1.0 10,999 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 826kB
  • Buffers: shared hit=143
7. 1.356 1.356 ↑ 1.0 10,999 1

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

  • Buffers: shared hit=143
8.          

SubPlan (for Hash Left Join)

9. 189.730 1,736,940.204 ↑ 1.0 1 37,946

Aggregate (cost=8,123.06..8,123.07 rows=1 width=8) (actual time=45.774..45.774 rows=1 loops=37,946)

  • Buffers: shared hit=879,018
10. 400.465 1,736,750.474 ↓ 4.0 4 37,946

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=0) (actual time=45.755..45.769 rows=4 loops=37,946)

  • Buffers: shared hit=879,018
11. 645.082 1,735,232.634 ↓ 4.0 4 37,946

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual time=45.729..45.729 rows=4 loops=37,946)

  • Group Key: pc.projectid
  • Buffers: shared hit=240,082
12. 466,732.358 1,734,587.552 ↓ 4.0 4 37,946

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual time=13.614..45.712 rows=4 loops=37,946)

  • Hash Cond: ((projectclient.projectid = pc.projectid) AND ((max(projectclient.effectivedate)) = pc.effectivedate))
  • Buffers: shared hit=240,082
13. 1,266,931.431 1,266,944.490 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..34.251 rows=159,625 loops=36,990)

  • Group Key: projectclient.projectid
  • Buffers: shared hit=1,331
14. 13.059 13.059 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
15. 265.622 910.704 ↑ 1.0 4 37,946

Hash (cost=5.47..5.47 rows=4 width=8) (actual time=0.024..0.024 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=238,751
16. 645.082 645.082 ↑ 1.0 4 37,946

Index Scan using ixpcclientid on projectclient pc (cost=0.42..5.47 rows=4 width=8) (actual time=0.012..0.017 rows=4 loops=37,946)

  • Index Cond: (clientid = clients0.id)
  • Buffers: shared hit=238,751
17. 1,117.375 1,117.375 ↑ 1.0 1 159,625

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

  • Index Cond: (id = projectclient.projectid)
  • Heap Fetches: 159,625
  • Buffers: shared hit=638,936
18. 569.190 1,739,937.938 ↑ 1.0 1 37,946

Aggregate (cost=8,124.87..8,124.88 rows=1 width=8) (actual time=45.852..45.853 rows=1 loops=37,946)

  • Buffers: shared hit=892,835
19. 354.678 1,739,368.748 ↓ 0.0 0 37,946

Nested Loop (cost=8,121.03..8,124.87 rows=1 width=4) (actual time=45.838..45.838 rows=0 loops=37,946)

  • Buffers: shared hit=892,835
20. 645.082 1,737,737.070 ↓ 4.0 4 37,946

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual time=45.794..45.795 rows=4 loops=37,946)

  • Group Key: pc_1.projectid
  • Buffers: shared hit=240,082
21. 465,838.494 1,737,091.988 ↓ 4.0 4 37,946

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual time=13.640..45.778 rows=4 loops=37,946)

  • Hash Cond: ((projectclient_1.projectid = pc_1.projectid) AND ((max(projectclient_1.effectivedate)) = pc_1.effectivedate))
  • Buffers: shared hit=240,082
22. 1,270,518.925 1,270,532.520 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..34.348 rows=159,625 loops=36,990)

  • Group Key: projectclient_1.projectid
  • Buffers: shared hit=1,331
23. 13.595 13.595 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
24. 227.676 720.974 ↑ 1.0 4 37,946

Hash (cost=5.47..5.47 rows=4 width=8) (actual time=0.019..0.019 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=238,751
25. 493.298 493.298 ↑ 1.0 4 37,946

Index Scan using ixpcclientid on projectclient pc_1 (cost=0.42..5.47 rows=4 width=8) (actual time=0.008..0.013 rows=4 loops=37,946)

  • Index Cond: (clientid = clients0.id)
  • Buffers: shared hit=238,751
26. 1,277.000 1,277.000 ↓ 0.0 0 159,625

Index Scan using uix3ptm_projectrole on projectteammember projectteammember5 (cost=0.42..4.24 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=159,625)

  • Index Cond: (projectid = projectclient_1.projectid)
  • Filter: (userid IS NOT NULL)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=652,753
27. 75.892 1,776,479.936 ↑ 1.0 1 37,946

Aggregate (cost=8,122.95..8,122.96 rows=1 width=8) (actual time=46.816..46.816 rows=1 loops=37,946)

  • Buffers: shared hit=719,597
28. 370.360 1,776,404.044 ↓ 0.0 0 37,946

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

  • Buffers: shared hit=719,597
29. 569.190 1,775,075.934 ↓ 4.0 4 37,946

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual time=46.778..46.779 rows=4 loops=37,946)

  • Group Key: pc_2.projectid
  • Buffers: shared hit=240,082
30. 469,371.366 1,774,506.744 ↓ 4.0 4 37,946

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual time=13.920..46.764 rows=4 loops=37,946)

  • Hash Cond: ((projectclient_2.projectid = pc_2.projectid) AND ((max(projectclient_2.effectivedate)) = pc_2.effectivedate))
  • Buffers: shared hit=240,082
31. 1,304,439.419 1,304,452.350 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..35.265 rows=159,625 loops=36,990)

  • Group Key: projectclient_2.projectid
  • Buffers: shared hit=1,331
32. 12.931 12.931 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
33. 227.676 683.028 ↑ 1.0 4 37,946

Hash (cost=5.47..5.47 rows=4 width=8) (actual time=0.018..0.018 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=238,751
34. 455.352 455.352 ↑ 1.0 4 37,946

Index Scan using ixpcclientid on projectclient pc_2 (cost=0.42..5.47 rows=4 width=8) (actual time=0.008..0.012 rows=4 loops=37,946)

  • Index Cond: (clientid = clients0.id)
  • Buffers: shared hit=238,751
35. 957.750 957.750 ↓ 0.0 0 159,625

Index Only Scan using uix3ptm_projectrole on projectteammember projectteammember7 (cost=0.42..2.32 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=159,625)

  • Index Cond: ((projectid = projectclient_2.projectid) AND (placeholderprojectroleid IS NOT NULL))
  • Heap Fetches: 0
  • Buffers: shared hit=479,515
36. 151.784 1,062.488 ↑ 1.0 1 37,946

Unique (cost=60.83..60.84 rows=1 width=32) (actual time=0.028..0.028 rows=1 loops=37,946)

  • Buffers: shared hit=113,838
37. 379.460 910.704 ↑ 1.0 1 37,946

Sort (cost=60.83..60.84 rows=1 width=32) (actual time=0.024..0.024 rows=1 loops=37,946)

  • 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))))
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=113,838
38. 75.892 531.244 ↑ 1.0 1 37,946

Aggregate (cost=60.81..60.82 rows=1 width=32) (actual time=0.013..0.014 rows=1 loops=37,946)

  • Buffers: shared hit=113,838
39. 37.946 455.352 ↓ 0.0 0 37,946

Nested Loop Left Join (cost=2.26..60.79 rows=1 width=48) (actual time=0.012..0.012 rows=0 loops=37,946)

  • Join Filter: (exchangerate10.fixedcurrencyid = userprojectroleratehistory9.currencyid)
  • Buffers: shared hit=113,838
40. 113.838 417.406 ↓ 0.0 0 37,946

Nested Loop Left Join (cost=2.12..60.61 rows=1 width=36) (actual time=0.011..0.011 rows=0 loops=37,946)

  • Join Filter: (project12.clientbillingallocationmethod = 0)
  • Buffers: shared hit=113,838
41. 37.946 303.568 ↓ 0.0 0 37,946

Nested Loop (cost=1.70..60.16 rows=1 width=35) (actual time=0.008..0.008 rows=0 loops=37,946)

  • Join Filter: (upper(ojecttimeallocation_metadata14.uri) = upper(('urn:replicon-tenant:1b8a55aa5f704dea918923fe2daf8cda:client:'::text || COALESCE((clients15.id)::text, ''::text))))
  • Buffers: shared hit=113,838
42. 0.000 265.622 ↓ 0.0 0 37,946

Nested Loop (cost=1.41..57.82 rows=1 width=115) (actual time=0.007..0.007 rows=0 loops=37,946)

  • Buffers: shared hit=113,838
43. 0.000 265.622 ↓ 0.0 0 37,946

Nested Loop (cost=1.13..57.41 rows=1 width=51) (actual time=0.007..0.007 rows=0 loops=37,946)

  • Buffers: shared hit=113,838
44. 0.000 265.622 ↓ 0.0 0 37,946

Nested Loop (cost=0.85..54.55 rows=9 width=48) (actual time=0.007..0.007 rows=0 loops=37,946)

  • Buffers: shared hit=113,838
45. 265.622 265.622 ↓ 0.0 0 37,946

Index Scan using dbatest on project project12 (cost=0.42..1.44 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=37,946)

  • Index Cond: (clientbillingallocationmethod = 1)
  • Buffers: shared hit=113,838
46. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

Index Scan using uix4pc_projectclienteffectiveend on projectclient projectclient13 (cost=0.42..0.44 rows=1 width=17) (never executed)

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

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

  • Index Cond: ((variablecurrencyid = 5) AND (effectivedate <= _projecttimeallocation_facts11.entrydate))
  • Filter: (enddate >= _projecttimeallocation_facts11.entrydate)
52. 75.892 762,448.978 ↑ 1.0 1 37,946

Unique (cost=1,353.43..1,353.43 rows=1 width=32) (actual time=20.093..20.093 rows=1 loops=37,946)

  • Buffers: shared hit=21,463,033
53. 189.730 762,373.086 ↑ 1.0 1 37,946

Sort (cost=1,353.43..1,353.43 rows=1 width=32) (actual time=20.091..20.091 rows=1 loops=37,946)

  • 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))))
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=21,463,033
54. 1,973.192 762,183.356 ↑ 1.0 1 37,946

Aggregate (cost=1,353.41..1,353.42 rows=1 width=32) (actual time=20.086..20.086 rows=1 loops=37,946)

  • Buffers: shared hit=21,463,033
55. 1,904.452 760,210.164 ↓ 32.0 32 37,946

Nested Loop Left Join (cost=26.05..1,353.38 rows=1 width=48) (actual time=19.930..20.034 rows=32 loops=37,946)

  • Join Filter: (exchangerate17.fixedcurrencyid = userprojectroleratehistory16.currencyid)
  • Rows Removed by Join Filter: 194
  • Buffers: shared hit=21,463,033
56. 675,615.630 755,846.374 ↓ 32.0 32 37,946

Hash Right Join (cost=25.91..1,353.21 rows=1 width=36) (actual time=19.914..19.919 rows=32 loops=37,946)

  • Hash Cond: (upper(('urn:replicon-tenant:1b8a55aa5f704dea918923fe2daf8cda:client:'::text || COALESCE((clients22.id)::text, ''::text))) = upper(ojecttimeallocation_metadata21.uri))
  • Join Filter: (project19.clientbillingallocationmethod = 1)
  • Rows Removed by Join Filter: 0
  • Buffers: shared hit=19,003,695
57. 71,161.650 71,161.650 ↑ 1.0 37,946 19,285

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

  • Buffers: shared hit=10,915,310
58. 379.460 9,069.094 ↓ 32.0 32 37,946

Hash (cost=25.90..25.90 rows=1 width=116) (actual time=0.239..0.239 rows=32 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=8,088,385
59. 895.307 8,689.634 ↓ 32.0 32 37,946

Nested Loop Left Join (cost=1.83..25.90 rows=1 width=116) (actual time=0.061..0.229 rows=32 loops=37,946)

  • Buffers: shared hit=8,088,385
60. 196.882 6,564.658 ↓ 32.0 32 37,946

Nested Loop (cost=1.55..25.48 rows=1 width=52) (actual time=0.057..0.173 rows=32 loops=37,946)

  • Buffers: shared hit=5,625,456
61. 482.939 3,908.438 ↓ 8.0 32 37,946

Nested Loop (cost=1.27..24.21 rows=4 width=49) (actual time=0.051..0.103 rows=32 loops=37,946)

  • Join Filter: ((_projecttimeallocation_facts18.entrydate >= projectclient20.effectivedate) AND (_projecttimeallocation_facts18.entrydate <= projectclient20.enddate))
  • Buffers: shared hit=1,931,471
62. 378.201 1,669.624 ↑ 1.0 4 37,946

Nested Loop (cost=0.84..15.24 rows=4 width=25) (actual time=0.024..0.044 rows=4 loops=37,946)

  • Buffers: shared hit=877,687
63. 493.298 493.298 ↑ 1.0 4 37,946

Index Scan using ixpcclientid on projectclient projectclient20 (cost=0.42..5.47 rows=4 width=17) (actual time=0.009..0.013 rows=4 loops=37,946)

  • Index Cond: (clientid = clients0.id)
  • Buffers: shared hit=238,751
64. 798.125 798.125 ↑ 1.0 1 159,625

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

  • Index Cond: (id = projectclient20.projectid)
  • Filter: ((clientbillingallocationmethod <> 1) AND (clientbillingallocationmethod = 0))
  • Buffers: shared hit=638,936
65. 1,755.875 1,755.875 ↑ 6.4 8 159,625

Index Scan using ixpta2projectid on dm_projecttimeallocation_facts _projecttimeallocation_facts18 (cost=0.43..1.48 rows=51 width=44) (actual time=0.005..0.011 rows=8 loops=159,625)

  • Index Cond: (projectid = project19.id)
  • Buffers: shared hit=1,053,784
66. 2,459.338 2,459.338 ↑ 1.0 1 1,229,669

Index Scan using ixuprrhuserid on userprojectroleratehistory userprojectroleratehistory16 (cost=0.29..0.31 rows=1 width=19) (actual time=0.001..0.002 rows=1 loops=1,229,669)

  • Index Cond: (userid = _projecttimeallocation_facts18.userid)
  • Filter: ((effectivedate <= _projecttimeallocation_facts18.entrydate) AND (enddate >= _projecttimeallocation_facts18.entrydate))
  • Buffers: shared hit=3,693,985
67. 1,229.669 1,229.669 ↓ 0.0 0 1,229,669

Index Scan using ixptamfactid_client on dm_projecttimeallocation_metadata ojecttimeallocation_metadata21 (cost=0.28..0.41 rows=1 width=96) (actual time=0.001..0.001 rows=0 loops=1,229,669)

  • Index Cond: (factid = _projecttimeallocation_facts18.id)
  • Buffers: shared hit=2,462,929
68. 2,459.338 2,459.338 ↓ 7.0 7 1,229,669

Index Scan using uix3er_currencyideffectivedate on exchangerate exchangerate17 (cost=0.14..0.16 rows=1 width=32) (actual time=0.001..0.002 rows=7 loops=1,229,669)

  • Index Cond: ((variablecurrencyid = 5) AND (effectivedate <= _projecttimeallocation_facts18.entrydate))
  • Filter: (enddate >= _projecttimeallocation_facts18.entrydate)
  • Buffers: shared hit=2,459,338
69. 265.622 8,689.634 ↑ 1.0 1 37,946

Aggregate (cost=296.05..296.06 rows=1 width=32) (actual time=0.229..0.229 rows=1 loops=37,946)

  • Buffers: shared hit=5,156,146
70. 1,100.434 8,424.012 ↑ 2.2 20 37,946

Nested Loop Left Join (cost=0.85..295.82 rows=45 width=23) (actual time=0.064..0.222 rows=20 loops=37,946)

  • Join Filter: ((exchangerate24.effectivedate <= billingitem223.entrydate) AND (exchangerate24.enddate >= billingitem223.entrydate) AND (exchangerate24.fixedcurrencyid = billingitem223.currencyid))
  • Rows Removed by Join Filter: 120
  • Buffers: shared hit=5,156,146
71. 204.034 7,323.578 ↑ 2.2 20 37,946

Nested Loop (cost=0.85..293.31 rows=45 width=11) (actual time=0.062..0.193 rows=20 loops=37,946)

  • Buffers: shared hit=5,156,145
72. 2,200.868 2,200.868 ↑ 2.6 32 37,946

Index Scan using ixbi2dmclientid on billingitem2denormalizedmetadata ingitem2denormalizedmetadata25 (cost=0.43..87.93 rows=84 width=16) (actual time=0.011..0.058 rows=32 loops=37,946)

  • Index Cond: (clientid = clients0.id)
  • Filter: ((billingtypeuri IS NULL) OR (upper(billingtypeuri) <> 'URN:REPLICON:BILLING-ITEM-TYPE:EXPENSE'::text))
  • Buffers: shared hit=230,936
73. 4,918.676 4,918.676 ↑ 1.0 1 1,229,669

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

  • Index Cond: (id = ingitem2denormalizedmetadata25.billingitemid)
  • Filter: isbillable
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4,925,209
74. 0.000 0.000 ↓ 7.0 7 761,274

Materialize (cost=0.00..1.62 rows=1 width=32) (actual time=0.000..0.000 rows=7 loops=761,274)

  • Buffers: shared hit=1
75. 0.007 0.007 ↓ 7.0 7 1

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

  • Filter: (variablecurrencyid = 5)
  • Rows Removed by Filter: 42
  • Buffers: shared hit=1
76. 75.892 645.082 ↑ 1.0 1 37,946

Unique (cost=61.13..61.14 rows=1 width=16) (actual time=0.017..0.017 rows=1 loops=37,946)

  • Buffers: shared hit=113,838
77. 227.676 569.190 ↑ 1.0 1 37,946

Sort (cost=61.13..61.14 rows=1 width=16) (actual time=0.015..0.015 rows=1 loops=37,946)

  • 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))
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=113,838
78. 75.892 341.514 ↑ 1.0 1 37,946

Aggregate (cost=61.11..61.12 rows=1 width=16) (actual time=0.009..0.009 rows=1 loops=37,946)

  • Buffers: shared hit=113,838
79. 113.838 265.622 ↓ 0.0 0 37,946

Nested Loop Left Join (cost=1.83..61.10 rows=1 width=25) (actual time=0.007..0.007 rows=0 loops=37,946)

  • Join Filter: (project26.clientbillingallocationmethod = 0)
  • Buffers: shared hit=113,838
80. 0.000 151.784 ↓ 0.0 0 37,946

Nested Loop (cost=1.41..60.64 rows=1 width=28) (actual time=0.004..0.004 rows=0 loops=37,946)

  • Join Filter: (upper(ojecttimeallocation_metadata29.uri) = upper(('urn:replicon-tenant:1b8a55aa5f704dea918923fe2daf8cda:client:'::text || COALESCE((clients30.id)::text, ''::text))))
  • Buffers: shared hit=113,838
81. 0.000 151.784 ↓ 0.0 0 37,946

Nested Loop (cost=1.12..58.31 rows=1 width=108) (actual time=0.004..0.004 rows=0 loops=37,946)

  • Buffers: shared hit=113,838
82. 0.000 151.784 ↓ 0.0 0 37,946

Nested Loop (cost=0.85..54.55 rows=9 width=44) (actual time=0.004..0.004 rows=0 loops=37,946)

  • Buffers: shared hit=113,838
83. 151.784 151.784 ↓ 0.0 0 37,946

Index Scan using dbatest on project project26 (cost=0.42..1.44 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=37,946)

  • Index Cond: (clientbillingallocationmethod = 1)
  • Buffers: shared hit=113,838
84. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

Index Scan using uix4pc_projectclienteffectiveend on projectclient projectclient28 (cost=0.42..0.44 rows=1 width=17) (never executed)

  • Index Cond: ((projectid = _projecttimeallocation_facts27.projectid) AND (_projecttimeallocation_facts27.entrydate >= effectivedate) AND (_projecttimeallocation_facts27.entrydate <= enddate))
88. 75.892 752,279.450 ↑ 1.0 1 37,946

Unique (cost=1,360.41..1,360.42 rows=1 width=16) (actual time=19.825..19.825 rows=1 loops=37,946)

  • Buffers: shared hit=15,309,710
89. 151.784 752,203.558 ↑ 1.0 1 37,946

Sort (cost=1,360.41..1,360.41 rows=1 width=16) (actual time=19.823..19.823 rows=1 loops=37,946)

  • 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))
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=15,309,710
90. 1,024.542 752,051.774 ↑ 1.0 1 37,946

Aggregate (cost=1,360.39..1,360.40 rows=1 width=16) (actual time=19.819..19.819 rows=1 loops=37,946)

  • Buffers: shared hit=15,309,710
91. 677,331.430 751,027.232 ↓ 8.0 32 37,946

Hash Right Join (cost=25.93..1,360.34 rows=4 width=25) (actual time=19.788..19.792 rows=32 loops=37,946)

  • Hash Cond: (upper(('urn:replicon-tenant:1b8a55aa5f704dea918923fe2daf8cda:client:'::text || COALESCE((clients35.id)::text, ''::text))) = upper(ojecttimeallocation_metadata34.uri))
  • Join Filter: (project31.clientbillingallocationmethod = 1)
  • Rows Removed by Join Filter: 0
  • Buffers: shared hit=15,309,710
92. 68,307.470 68,307.470 ↑ 1.0 37,946 19,285

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

  • Buffers: shared hit=10,915,310
93. 341.514 5,388.332 ↓ 8.0 32 37,946

Hash (cost=25.88..25.88 rows=4 width=105) (actual time=0.142..0.142 rows=32 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=4,394,400
94. 667.631 5,046.818 ↓ 8.0 32 37,946

Nested Loop Left Join (cost=1.54..25.88 rows=4 width=105) (actual time=0.039..0.133 rows=32 loops=37,946)

  • Buffers: shared hit=4,394,400
95. 376.942 3,149.518 ↓ 8.0 32 37,946

Nested Loop (cost=1.27..24.21 rows=4 width=41) (actual time=0.034..0.083 rows=32 loops=37,946)

  • Join Filter: ((_projecttimeallocation_facts32.entrydate >= projectclient33.effectivedate) AND (_projecttimeallocation_facts32.entrydate <= projectclient33.enddate))
  • Buffers: shared hit=1,931,471
96. 234.258 1,176.326 ↑ 1.0 4 37,946

Nested Loop (cost=0.84..15.24 rows=4 width=25) (actual time=0.015..0.031 rows=4 loops=37,946)

  • Buffers: shared hit=877,687
97. 303.568 303.568 ↑ 1.0 4 37,946

Index Scan using ixpcclientid on projectclient projectclient33 (cost=0.42..5.47 rows=4 width=17) (actual time=0.004..0.008 rows=4 loops=37,946)

  • Index Cond: (clientid = clients0.id)
  • Buffers: shared hit=238,751
98. 638.500 638.500 ↑ 1.0 1 159,625

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

  • Index Cond: (id = projectclient33.projectid)
  • Filter: ((clientbillingallocationmethod <> 1) AND (clientbillingallocationmethod = 0))
  • Buffers: shared hit=638,936
99. 1,596.250 1,596.250 ↑ 6.4 8 159,625

Index Scan using ixpta2projectid on dm_projecttimeallocation_facts _projecttimeallocation_facts32 (cost=0.43..1.48 rows=51 width=40) (actual time=0.004..0.010 rows=8 loops=159,625)

  • Index Cond: (projectid = project31.id)
  • Buffers: shared hit=1,053,784
100. 1,229.669 1,229.669 ↓ 0.0 0 1,229,669

Index Scan using ixptamfactid_client on dm_projecttimeallocation_metadata ojecttimeallocation_metadata34 (cost=0.28..0.41 rows=1 width=96) (actual time=0.001..0.001 rows=0 loops=1,229,669)

  • Index Cond: (factid = _projecttimeallocation_facts32.id)
  • Buffers: shared hit=2,462,929
101. 531.244 3,431,836.240 ↑ 1.0 1 37,946

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

  • Buffers: shared hit=1,520,071
102. 341.514 3,431,304.996 ↓ 4.0 4 37,946

Nested Loop Left Join (cost=11,849.00..15,640.19 rows=1 width=49) (actual time=59.367..90.426 rows=4 loops=37,946)

  • Buffers: shared hit=1,520,071
103. 710.615 3,430,963.482 ↓ 4.0 4 37,946

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=33) (actual time=59.364..90.417 rows=4 loops=37,946)

  • Buffers: shared hit=1,520,071
104. 405,801.230 3,428,496.992 ↓ 4.0 4 37,946

Hash Join (cost=11,848.44..15,639.55 rows=1 width=48) (actual time=59.338..90.352 rows=4 loops=37,946)

  • Hash Cond: (projectclient_3.projectid = project36.id)
  • Buffers: shared hit=880,349
105. 1,270,260.534 1,270,273.590 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..34.341 rows=159,625 loops=36,990)

  • Group Key: projectclient_3.projectid
  • Buffers: shared hit=1,331
106. 13.056 13.056 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
107. 341.514 1,752,422.172 ↓ 4.0 4 37,946

Hash (cost=8,123.06..8,123.06 rows=1 width=40) (actual time=46.182..46.182 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=879,018
108. 514.303 1,752,080.658 ↓ 4.0 4 37,946

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=40) (actual time=46.157..46.173 rows=4 loops=37,946)

  • Buffers: shared hit=879,018
109. 455.352 1,750,448.980 ↓ 4.0 4 37,946

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual time=46.129..46.130 rows=4 loops=37,946)

  • Group Key: pc_4.projectid
  • Buffers: shared hit=240,082
110. 466,201.480 1,749,993.628 ↓ 4.0 4 37,946

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual time=13.725..46.118 rows=4 loops=37,946)

  • Hash Cond: ((projectclient_4.projectid = pc_4.projectid) AND ((max(projectclient_4.effectivedate)) = pc_4.effectivedate))
  • Buffers: shared hit=240,082
111. 1,283,096.024 1,283,109.120 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..34.688 rows=159,625 loops=36,990)

  • Group Key: projectclient_4.projectid
  • Buffers: shared hit=1,331
112. 13.096 13.096 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
113. 227.676 683.028 ↑ 1.0 4 37,946

Hash (cost=5.47..5.47 rows=4 width=8) (actual time=0.018..0.018 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=238,751
114. 455.352 455.352 ↑ 1.0 4 37,946

Index Scan using ixpcclientid on projectclient pc_4 (cost=0.42..5.47 rows=4 width=8) (actual time=0.008..0.012 rows=4 loops=37,946)

  • Index Cond: (clientid = clients0.id)
  • Buffers: shared hit=238,751
115. 1,117.375 1,117.375 ↑ 1.0 1 159,625

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

  • Index Cond: (id = projectclient_4.projectid)
  • Buffers: shared hit=638,936
116. 1,755.875 1,755.875 ↑ 1.0 1 159,625

Index Scan using uix4pc_projectclienteffectiveend on projectclient pc_3 (cost=0.42..0.45 rows=1 width=13) (actual time=0.010..0.011 rows=1 loops=159,625)

  • Index Cond: ((projectid = projectclient_3.projectid) AND (clientid = clients0.id) AND (effectivedate = (max(projectclient_3.effectivedate))))
  • Buffers: shared hit=639,722
117. 0.000 0.000 ↓ 0.0 0 159,625

Index Scan using uix3er_currencyideffectivedate on exchangerate exchangerate37 (cost=0.14..0.17 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=159,625)

  • Index Cond: ((variablecurrencyid = 5) AND (fixedcurrencyid = project36.estimatedcostcurrencyid) AND (effectivedate <= '2020-01-03'::date))
  • Filter: (enddate >= '2020-01-03'::date)
118. 531.244 3,413,887.782 ↑ 1.0 1 37,946

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

  • Buffers: shared hit=1,520,071
119. 303.568 3,413,356.538 ↓ 4.0 4 37,946

Nested Loop Left Join (cost=11,849.00..15,640.19 rows=1 width=49) (actual time=59.041..89.953 rows=4 loops=37,946)

  • Buffers: shared hit=1,520,071
120. 946.132 3,413,052.970 ↓ 4.0 4 37,946

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=33) (actual time=59.038..89.945 rows=4 loops=37,946)

  • Buffers: shared hit=1,520,071
121. 405,680.186 3,410,510.588 ↓ 4.0 4 37,946

Hash Join (cost=11,848.44..15,639.55 rows=1 width=48) (actual time=59.009..89.878 rows=4 loops=37,946)

  • Hash Cond: (projectclient_5.projectid = project36_1.id)
  • Buffers: shared hit=880,349
122. 1,262,640.618 1,262,653.650 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..34.135 rows=159,625 loops=36,990)

  • Group Key: projectclient_5.projectid
  • Buffers: shared hit=1,331
123. 13.032 13.032 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
124. 379.460 1,742,176.752 ↓ 4.0 4 37,946

Hash (cost=8,123.06..8,123.06 rows=1 width=40) (actual time=45.912..45.912 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=879,018
125. 438.411 1,741,797.292 ↓ 4.0 4 37,946

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=40) (actual time=45.887..45.902 rows=4 loops=37,946)

  • Buffers: shared hit=879,018
126. 493.298 1,740,241.506 ↓ 4.0 4 37,946

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual time=45.860..45.861 rows=4 loops=37,946)

  • Group Key: pc_6.projectid
  • Buffers: shared hit=240,082
127. 466,307.524 1,739,748.208 ↓ 4.0 4 37,946

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual time=13.652..45.848 rows=4 loops=37,946)

  • Hash Cond: ((projectclient_6.projectid = pc_6.projectid) AND ((max(projectclient_6.effectivedate)) = pc_6.effectivedate))
  • Buffers: shared hit=240,082
128. 1,272,516.701 1,272,529.980 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..34.402 rows=159,625 loops=36,990)

  • Group Key: projectclient_6.projectid
  • Buffers: shared hit=1,331
129. 13.279 13.279 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
130. 265.622 910.704 ↑ 1.0 4 37,946

Hash (cost=5.47..5.47 rows=4 width=8) (actual time=0.024..0.024 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=238,751
131. 645.082 645.082 ↑ 1.0 4 37,946

Index Scan using ixpcclientid on projectclient pc_6 (cost=0.42..5.47 rows=4 width=8) (actual time=0.013..0.017 rows=4 loops=37,946)

  • Index Cond: (clientid = clients0.id)
  • Buffers: shared hit=238,751
132. 1,117.375 1,117.375 ↑ 1.0 1 159,625

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

  • Index Cond: (id = projectclient_6.projectid)
  • Buffers: shared hit=638,936
133. 1,596.250 1,596.250 ↑ 1.0 1 159,625

Index Scan using uix4pc_projectclienteffectiveend on projectclient pc_5 (cost=0.42..0.45 rows=1 width=13) (actual time=0.010..0.010 rows=1 loops=159,625)

  • Index Cond: ((projectid = projectclient_5.projectid) AND (clientid = clients0.id) AND (effectivedate = (max(projectclient_5.effectivedate))))
  • Buffers: shared hit=639,722
134. 0.000 0.000 ↓ 0.0 0 159,625

Index Scan using uix3er_currencyideffectivedate on exchangerate exchangerate37_1 (cost=0.14..0.17 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=159,625)

  • 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 0

Aggregate (cost=15,640.20..15,640.21 rows=1 width=32) (never executed)

136. 0.000 0.000 ↓ 0.0 0

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

137. 0.000 0.000 ↓ 0.0 0

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

138. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

141. 0.000 0.000 ↓ 0.0 0

Hash (cost=8,123.06..8,123.06 rows=1 width=40) (never executed)

142. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=40) (never executed)

143. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (never executed)

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

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (never executed)

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

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

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

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

147. 0.000 0.000 ↓ 0.0 0

Hash (cost=5.47..5.47 rows=4 width=8) (never executed)

148. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Index Scan using uix4pc_projectclienteffectiveend on projectclient pc_7 (cost=0.42..0.45 rows=1 width=13) (never executed)

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

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

  • 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 0

Aggregate (cost=15,641.11..15,641.12 rows=1 width=32) (never executed)

153. 0.000 0.000 ↓ 0.0 0

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

154. 0.000 0.000 ↓ 0.0 0

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

155. 0.000 0.000 ↓ 0.0 0

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

156. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

159. 0.000 0.000 ↓ 0.0 0

Hash (cost=8,123.06..8,123.06 rows=1 width=16) (never executed)

160. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=16) (never executed)

161. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (never executed)

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

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (never executed)

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

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

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

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

165. 0.000 0.000 ↓ 0.0 0

Hash (cost=5.47..5.47 rows=4 width=8) (never executed)

166. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Index Scan using uix4pc_projectclienteffectiveend on projectclient pc_9 (cost=0.42..0.45 rows=1 width=13) (never executed)

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

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

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

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

  • Index Cond: ((variablecurrencyid = 5) AND (fixedcurrencyid = task41.estimatedcostcurrencyid) AND (effectivedate <= '2020-01-03'::date))
  • Filter: (enddate >= '2020-01-03'::date)
171. 607.136 3,447,469.992 ↑ 1.0 1 37,946

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

  • Buffers: shared hit=2,281,262
172. 569.190 3,446,862.856 ↓ 23.0 23 37,946

Nested Loop Left Join (cost=11,849.43..15,641.10 rows=1 width=32) (actual time=71.603..90.836 rows=23 loops=37,946)

  • Buffers: shared hit=2,281,262
173. 520.885 3,446,293.666 ↓ 23.0 23 37,946

Nested Loop (cost=11,849.29..15,640.92 rows=1 width=16) (actual time=71.600..90.821 rows=23 loops=37,946)

  • Buffers: shared hit=2,281,222
174. 984.078 3,444,016.906 ↓ 4.0 4 37,946

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=29) (actual time=59.031..90.761 rows=4 loops=37,946)

  • Buffers: shared hit=1,520,071
175. 407,607.706 3,441,436.578 ↓ 4.0 4 37,946

Hash Join (cost=11,848.44..15,639.55 rows=1 width=24) (actual time=59.002..90.693 rows=4 loops=37,946)

  • Hash Cond: (projectclient_11.projectid = project40_1.id)
  • Buffers: shared hit=880,349
176. 1,304,920.159 1,304,933.220 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..35.278 rows=159,625 loops=36,990)

  • Group Key: projectclient_11.projectid
  • Buffers: shared hit=1,331
177. 13.061 13.061 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
178. 379.460 1,728,895.652 ↓ 4.0 4 37,946

Hash (cost=8,123.06..8,123.06 rows=1 width=16) (actual time=45.562..45.562 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=879,018
179. 476.357 1,728,516.192 ↓ 4.0 4 37,946

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=16) (actual time=45.537..45.552 rows=4 loops=37,946)

  • Buffers: shared hit=879,018
180. 493.298 1,726,922.460 ↓ 4.0 4 37,946

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual time=45.509..45.510 rows=4 loops=37,946)

  • Group Key: pc_12.projectid
  • Buffers: shared hit=240,082
181. 466,009.914 1,726,429.162 ↓ 4.0 4 37,946

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual time=13.550..45.497 rows=4 loops=37,946)

  • Hash Cond: ((projectclient_12.projectid = pc_12.projectid) AND ((max(projectclient_12.effectivedate)) = pc_12.effectivedate))
  • Buffers: shared hit=240,082
182. 1,259,532.790 1,259,546.490 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..34.051 rows=159,625 loops=36,990)

  • Group Key: projectclient_12.projectid
  • Buffers: shared hit=1,331
183. 13.700 13.700 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
184. 227.676 872.758 ↑ 1.0 4 37,946

Hash (cost=5.47..5.47 rows=4 width=8) (actual time=0.023..0.023 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=238,751
185. 645.082 645.082 ↑ 1.0 4 37,946

Index Scan using ixpcclientid on projectclient pc_12 (cost=0.42..5.47 rows=4 width=8) (actual time=0.013..0.017 rows=4 loops=37,946)

  • Index Cond: (clientid = clients0.id)
  • Buffers: shared hit=238,751
186. 1,117.375 1,117.375 ↑ 1.0 1 159,625

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

  • Index Cond: (id = projectclient_12.projectid)
  • Buffers: shared hit=638,936
187. 1,596.250 1,596.250 ↑ 1.0 1 159,625

Index Scan using uix4pc_projectclienteffectiveend on projectclient pc_11 (cost=0.42..0.45 rows=1 width=13) (actual time=0.010..0.010 rows=1 loops=159,625)

  • Index Cond: ((projectid = projectclient_11.projectid) AND (clientid = clients0.id) AND (effectivedate = (max(projectclient_11.effectivedate))))
  • Buffers: shared hit=639,722
188. 1,755.875 1,755.875 ↑ 2.3 6 159,625

Index Scan using ixtkprojectid on task task41_1 (cost=0.42..0.77 rows=14 width=11) (actual time=0.007..0.011 rows=6 loops=159,625)

  • Index Cond: (projectid = projectclient_11.projectid)
  • Buffers: shared hit=761,151
189. 0.000 0.000 ↓ 0.0 0 891,469

Index Scan using uix3er_currencyideffectivedate on exchangerate exchangerate42_1 (cost=0.14..0.17 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=891,469)

  • Index Cond: ((variablecurrencyid = 5) AND (fixedcurrencyid = task41_1.estimatedcostcurrencyid) AND (effectivedate <= '2020-01-03'::date))
  • Filter: (enddate >= '2020-01-03'::date)
  • Buffers: shared hit=40
190. 796.866 3,467,695.210 ↑ 1.0 1 37,946

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

  • Buffers: shared hit=1,520,071
191. 1,059.970 3,466,898.344 ↓ 4.0 4 37,946

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=25) (actual time=59.397..91.364 rows=4 loops=37,946)

  • Buffers: shared hit=1,520,071
192. 422,983.852 3,464,242.124 ↓ 4.0 4 37,946

Hash Join (cost=11,848.44..15,639.55 rows=1 width=40) (actual time=59.369..91.294 rows=4 loops=37,946)

  • Hash Cond: (projectclient_13.projectid = project45.id)
  • Buffers: shared hit=880,349
193. 1,302,292.894 1,302,306.930 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..35.207 rows=159,625 loops=36,990)

  • Group Key: projectclient_13.projectid
  • Buffers: shared hit=1,331
194. 14.036 14.036 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
195. 379.460 1,738,951.342 ↓ 4.0 4 37,946

Hash (cost=8,123.06..8,123.06 rows=1 width=32) (actual time=45.827..45.827 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=879,018
196. 476.357 1,738,571.882 ↓ 4.0 4 37,946

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=32) (actual time=45.801..45.817 rows=4 loops=37,946)

  • Buffers: shared hit=879,018
197. 493.298 1,736,978.150 ↓ 4.0 4 37,946

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual time=45.774..45.775 rows=4 loops=37,946)

  • Group Key: pc_14.projectid
  • Buffers: shared hit=240,082
198. 465,412.484 1,736,484.852 ↓ 4.0 4 37,946

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual time=13.634..45.762 rows=4 loops=37,946)

  • Hash Cond: ((projectclient_14.projectid = pc_14.projectid) AND ((max(projectclient_14.effectivedate)) = pc_14.effectivedate))
  • Buffers: shared hit=240,082
199. 1,270,186.558 1,270,199.610 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..34.339 rows=159,625 loops=36,990)

  • Group Key: projectclient_14.projectid
  • Buffers: shared hit=1,331
200. 13.052 13.052 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
201. 227.676 872.758 ↑ 1.0 4 37,946

Hash (cost=5.47..5.47 rows=4 width=8) (actual time=0.023..0.023 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=238,751
202. 645.082 645.082 ↑ 1.0 4 37,946

Index Scan using ixpcclientid on projectclient pc_14 (cost=0.42..5.47 rows=4 width=8) (actual time=0.012..0.017 rows=4 loops=37,946)

  • Index Cond: (clientid = clients0.id)
  • Buffers: shared hit=238,751
203. 1,117.375 1,117.375 ↑ 1.0 1 159,625

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

  • Index Cond: (id = projectclient_14.projectid)
  • Buffers: shared hit=638,936
204. 1,596.250 1,596.250 ↑ 1.0 1 159,625

Index Scan using uix4pc_projectclienteffectiveend on projectclient pc_13 (cost=0.42..0.45 rows=1 width=13) (actual time=0.010..0.010 rows=1 loops=159,625)

  • Index Cond: ((projectid = projectclient_13.projectid) AND (clientid = clients0.id) AND (effectivedate = (max(projectclient_13.effectivedate))))
  • Buffers: shared hit=639,722
205. 796.866 3,415,329.730 ↑ 1.0 1 37,946

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

  • Buffers: shared hit=1,520,071
206. 984.078 3,414,532.864 ↓ 4.0 4 37,946

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=25) (actual time=59.230..89.984 rows=4 loops=37,946)

  • Buffers: shared hit=1,520,071
207. 413,555.380 3,411,952.536 ↓ 4.0 4 37,946

Hash Join (cost=11,848.44..15,639.55 rows=1 width=40) (actual time=59.201..89.916 rows=4 loops=37,946)

  • Hash Cond: (projectclient_15.projectid = project45_1.id)
  • Buffers: shared hit=880,349
208. 1,245,810.174 1,245,823.200 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..33.680 rows=159,625 loops=36,990)

  • Group Key: projectclient_15.projectid
  • Buffers: shared hit=1,331
209. 13.026 13.026 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
210. 379.460 1,752,573.956 ↓ 4.0 4 37,946

Hash (cost=8,123.06..8,123.06 rows=1 width=32) (actual time=46.186..46.186 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=879,018
211. 476.357 1,752,194.496 ↓ 4.0 4 37,946

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=32) (actual time=46.161..46.176 rows=4 loops=37,946)

  • Buffers: shared hit=879,018
212. 493.298 1,750,600.764 ↓ 4.0 4 37,946

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual time=46.133..46.134 rows=4 loops=37,946)

  • Group Key: pc_16.projectid
  • Buffers: shared hit=240,082
213. 470,268.468 1,750,107.466 ↓ 4.0 4 37,946

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual time=13.728..46.121 rows=4 loops=37,946)

  • Hash Cond: ((projectclient_16.projectid = pc_16.projectid) AND ((max(projectclient_16.effectivedate)) = pc_16.effectivedate))
  • Buffers: shared hit=240,082
214. 1,278,952.435 1,278,966.240 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..34.576 rows=159,625 loops=36,990)

  • Group Key: projectclient_16.projectid
  • Buffers: shared hit=1,331
215. 13.805 13.805 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
216. 227.676 872.758 ↑ 1.0 4 37,946

Hash (cost=5.47..5.47 rows=4 width=8) (actual time=0.023..0.023 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=238,751
217. 645.082 645.082 ↑ 1.0 4 37,946

Index Scan using ixpcclientid on projectclient pc_16 (cost=0.42..5.47 rows=4 width=8) (actual time=0.013..0.017 rows=4 loops=37,946)

  • Index Cond: (clientid = clients0.id)
  • Buffers: shared hit=238,751
218. 1,117.375 1,117.375 ↑ 1.0 1 159,625

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

  • Index Cond: (id = projectclient_16.projectid)
  • Buffers: shared hit=638,936
219. 1,596.250 1,596.250 ↑ 1.0 1 159,625

Index Scan using uix4pc_projectclienteffectiveend on projectclient pc_15 (cost=0.42..0.45 rows=1 width=13) (actual time=0.010..0.010 rows=1 loops=159,625)

  • Index Cond: ((projectid = projectclient_15.projectid) AND (clientid = clients0.id) AND (effectivedate = (max(projectclient_15.effectivedate))))
  • Buffers: shared hit=639,722
220. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=15,640.02..15,640.03 rows=1 width=16) (never executed)

221. 0.000 0.000 ↓ 0.0 0

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

222. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

225. 0.000 0.000 ↓ 0.0 0

Hash (cost=8,123.06..8,123.06 rows=1 width=32) (never executed)

226. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=32) (never executed)

227. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (never executed)

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

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (never executed)

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

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

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

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

231. 0.000 0.000 ↓ 0.0 0

Hash (cost=5.47..5.47 rows=4 width=8) (never executed)

232. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Index Scan using uix4pc_projectclienteffectiveend on projectclient pc_17 (cost=0.42..0.45 rows=1 width=13) (never executed)

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

Aggregate (cost=15,640.93..15,640.94 rows=1 width=16) (never executed)

236. 0.000 0.000 ↓ 0.0 0

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

237. 0.000 0.000 ↓ 0.0 0

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

238. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

241. 0.000 0.000 ↓ 0.0 0

Hash (cost=8,123.06..8,123.06 rows=1 width=16) (never executed)

242. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=16) (never executed)

243. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (never executed)

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

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (never executed)

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

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

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

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

247. 0.000 0.000 ↓ 0.0 0

Hash (cost=5.47..5.47 rows=4 width=8) (never executed)

248. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Index Scan using uix4pc_projectclienteffectiveend on projectclient pc_19 (cost=0.42..0.45 rows=1 width=13) (never executed)

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

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

  • Index Cond: (projectid = projectclient_19.projectid)
252. 872.758 3,410,738.264 ↑ 1.0 1 37,946

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

  • Buffers: shared hit=2,281,222
253. 604.618 3,409,865.506 ↓ 23.0 23 37,946

Nested Loop (cost=11,849.29..15,640.92 rows=1 width=25) (actual time=71.407..89.861 rows=23 loops=37,946)

  • Buffers: shared hit=2,281,222
254. 946.132 3,407,664.638 ↓ 4.0 4 37,946

Nested Loop (cost=11,848.86..15,640.01 rows=1 width=29) (actual time=59.343..89.803 rows=4 loops=37,946)

  • Buffers: shared hit=1,520,071
255. 406,059.428 3,405,122.256 ↓ 4.0 4 37,946

Hash Join (cost=11,848.44..15,639.55 rows=1 width=24) (actual time=59.314..89.736 rows=4 loops=37,946)

  • Hash Cond: (projectclient_21.projectid = project47_1.id)
  • Buffers: shared hit=880,349
256. 1,237,672.317 1,237,685.400 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..33.460 rows=159,625 loops=36,990)

  • Group Key: projectclient_21.projectid
  • Buffers: shared hit=1,331
257. 13.083 13.083 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
258. 379.460 1,761,377.428 ↓ 4.0 4 37,946

Hash (cost=8,123.06..8,123.06 rows=1 width=16) (actual time=46.418..46.418 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=879,018
259. 438.411 1,760,997.968 ↓ 4.0 4 37,946

Nested Loop (cost=8,121.03..8,123.06 rows=1 width=16) (actual time=46.393..46.408 rows=4 loops=37,946)

  • Buffers: shared hit=879,018
260. 493.298 1,759,442.182 ↓ 4.0 4 37,946

HashAggregate (cost=8,120.61..8,120.62 rows=1 width=8) (actual time=46.366..46.367 rows=4 loops=37,946)

  • Group Key: pc_22.projectid
  • Buffers: shared hit=240,082
261. 471,933.826 1,758,948.884 ↓ 4.0 4 37,946

Hash Join (cost=3,730.91..8,120.61 rows=1 width=8) (actual time=13.796..46.354 rows=4 loops=37,946)

  • Hash Cond: ((projectclient_22.projectid = pc_22.projectid) AND ((max(projectclient_22.effectivedate)) = pc_22.effectivedate))
  • Buffers: shared hit=240,082
262. 1,286,129.241 1,286,142.300 ↑ 1.0 159,625 36,990

HashAggregate (cost=3,725.38..5,321.62 rows=159,625 width=8) (actual time=0.003..34.770 rows=159,625 loops=36,990)

  • Group Key: projectclient_22.projectid
  • Buffers: shared hit=1,331
263. 13.059 13.059 ↑ 1.0 159,625 1

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

  • Buffers: shared hit=1,331
264. 227.676 872.758 ↑ 1.0 4 37,946

Hash (cost=5.47..5.47 rows=4 width=8) (actual time=0.023..0.023 rows=4 loops=37,946)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=238,751
265. 645.082 645.082 ↑ 1.0 4 37,946

Index Scan using ixpcclientid on projectclient pc_22 (cost=0.42..5.47 rows=4 width=8) (actual time=0.013..0.017 rows=4 loops=37,946)

  • Index Cond: (clientid = clients0.id)
  • Buffers: shared hit=238,751
266. 1,117.375 1,117.375 ↑ 1.0 1 159,625

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

  • Index Cond: (id = projectclient_22.projectid)
  • Buffers: shared hit=638,936
267. 1,596.250 1,596.250 ↑ 1.0 1 159,625

Index Scan using uix4pc_projectclienteffectiveend on projectclient pc_21 (cost=0.42..0.45 rows=1 width=13) (actual time=0.010..0.010 rows=1 loops=159,625)

  • Index Cond: ((projectid = projectclient_21.projectid) AND (clientid = clients0.id) AND (effectivedate = (max(projectclient_21.effectivedate))))
  • Buffers: shared hit=639,722
268. 1,596.250 1,596.250 ↑ 2.3 6 159,625

Index Scan using ixtkprojectid on task task48_1 (cost=0.42..0.77 rows=14 width=20) (actual time=0.006..0.010 rows=6 loops=159,625)

  • Index Cond: (projectid = projectclient_21.projectid)
  • Buffers: shared hit=761,151
Planning time : 27.792 ms
Execution time : 27,368,120.788 ms