explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qHaX

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

Sort (cost=3,324,450,442,323.50..3,324,450,446,139.76 rows=1,526,503 width=1,909) (actual rows= loops=)

  • Sort Key: ((ui.lastname)::character varying(50)) COLLATE "en_US", ((ui.firstname)::character varying(50)) COLLATE "en_US", ui.duplicatename, ((login.loginname)::character varying(255)) COLLATE "en_US", ((ui.displayname)::text) COLLATE "en_US", ((pj.name)::character varying(255)) COLLATE "en_US", ((tk.code)::character varying(50)) COLLATE "en_US", ((objectextensiontag4.name)::character varying(50)) COLLATE "en_US", ((billingrate5.name)::character varying(50)) COLLATE "en_US", "*SELECT* 1".entrydate, ((objectextensiontag11.name)::character varying(50)) COLLATE "en_US
2.          

Initplan (for Sort)

3. 0.000 0.000 ↓ 0.0

Seq Scan on systeminformation (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,662,207,122,370.99..3,324,449,564,024.91 rows=1,526,503 width=1,909) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".timeentryid = objectextensionfieldvalue12.objectid)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,662,206,900,601.69..3,324,449,126,326.89 rows=1,526,503 width=389) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".userid = userdepartmentgroup20.userid)
6. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,662,206,900,138.64..3,324,449,100,867.34 rows=3,053,006 width=397) (actual rows= loops=)

  • Merge Cond: ("*SELECT* 1".userid = ts.userid)
  • Join Filter: (("*SELECT* 1".entrydate >= ts.startdate) AND ("*SELECT* 1".entrydate <= ts.enddate))
7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,662,206,404,068.98..3,324,448,053,494.14 rows=704,577 width=231) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,662,206,404,068.27..3,324,447,461,862.10 rows=499,261 width=193) (actual rows= loops=)

  • Join Filter: ("*SELECT* 1".billingrateid = billingrate5.id)
9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,662,206,404,068.27..3,324,447,446,908.21 rows=499,261 width=187) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,662,206,404,068.00..3,324,447,302,137.08 rows=499,261 width=165) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,662,206,404,067.56..3,324,446,855,345.16 rows=499,261 width=149) (actual rows= loops=)

  • Join Filter: (tk.estimatedcostcurrencyid = exchangerate.fixedcurrencyid)
12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,662,206,404,067.56..3,324,446,847,855.22 rows=499,261 width=153) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Merge Join (cost=1,662,206,404,067.14..3,324,446,614,904.74 rows=499,261 width=147) (actual rows= loops=)

  • Merge Cond: ("*SELECT* 1".userid = login.userid)
14. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,662,206,404,066.85..3,324,446,608,423.52 rows=499,261 width=136) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,662,206,404,066.43..3,324,446,364,036.90 rows=499,261 width=100) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,662,206,404,065.99..3,324,446,135,099.98 rows=499,261 width=155) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,662,206,404,065.43..3,324,445,493,162.33 rows=359,391 width=92) (actual rows= loops=)

  • Join Filter: ("*SELECT* 1".userid = ui.id)
18. 0.000 0.000 ↓ 0.0

Index Scan using userinfo_pkey on userinfo ui (cost=0.28..303.29 rows=6,067 width=32) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Materialize (cost=1,662,206,404,065.15..3,324,412,787,379.57 rows=359,391 width=60) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,662,206,404,065.15..3,324,412,785,582.61 rows=359,391 width=60) (actual rows= loops=)

  • Hash Cond: (CASE WHEN ("substring"(timeentrymetadata13.uri, '^urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:project:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata13.uri, '^urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:project:(.*)$'::text))::integer ELSE NULL::integer END = project14.id)
21. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,662,206,388,429.87..3,324,412,768,779.30 rows=359,391 width=119) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".timeentryid = timeentrymetadata13.timeentryid)
22. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,662,205,937,216.66..3,324,412,189,815.01 rows=359,391 width=56) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".timeentryid = timeentrymetadata17.timeentryid)
  • Filter: (((timeentrymetadata17.uri IS NULL) AND ("*SELECT* 1".timeoffentryid IS NULL) AND (("*SELECT* 1".timeallocationtype = 1) OR ("*SELECT* 1".timeallocationtype IS NULL))) OR ("*SELECT* 1".timeoffentryid IS NOT NULL))
23. 0.000 0.000 ↓ 0.0

Append (cost=1,662,205,546,012.72..3,324,411,797,256.57 rows=361,197 width=64) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=1,662,205,546,012.72..1,662,206,243,005.57 rows=356,986 width=64) (actual rows= loops=)

  • Filter: ((hashed SubPlan 17) OR (hashed SubPlan 19))
25. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,001.56..690,854.67 rows=475,982 width=140) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on projectsysteminformation psi (cost=0.00..1.01 rows=1 width=32) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,001.56..670,624.43 rows=475,982 width=156) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on systeminformation si (cost=0.00..1.01 rows=1 width=33) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Gather (cost=1,001.56..665,863.60 rows=475,982 width=123) (actual rows= loops=)

  • Workers Planned: 2
30. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.56..617,265.40 rows=198,326 width=123) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.99..316,761.48 rows=198,326 width=123) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Parallel Index Scan using ixte2entrydate on timeentry te (cost=0.43..16,257.55 rows=198,326 width=60) (actual rows= loops=)

  • Index Cond: ((entrydate >= '2020-08-02'::date) AND (entrydate <= '2020-08-22'::date))
  • Filter: ((timeallocationtype <> 2) OR (timeallocationtype IS NULL))
33. 0.000 0.000 ↓ 0.0

Index Scan using ixtemtimeentryid on timeentrymetadata tembillingrate (cost=0.56..1.51 rows=1 width=79) (actual rows= loops=)

  • Index Cond: (timeentryid = te.id)
  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BILLING-RATE'::text)
34. 0.000 0.000 ↓ 0.0

Index Scan using ixtemtimeentryid on timeentrymetadata temdbreaktype (cost=0.56..1.51 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (timeentryid = te.id)
  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BREAK-TYPE'::text)
35.          

SubPlan (for Subquery Scan)

36. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.70..1,662,205,516,607.63 rows=6,707,543 width=16) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Seq Scan on timeentryrevision timeentryrevision21 (cost=0.00..560,915.96 rows=6,790,410 width=32) (actual rows= loops=)

  • Filter: (totimestamputc IS NULL)
38. 0.000 0.000 ↓ 0.0

Index Scan using timeentryrevision_pkey on timeentryrevision timeentryrevision22 (cost=1.70..244,787.13 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = timeentryrevision21.id)
  • Filter: ((SubPlan 2) OR (userid = 5,092) OR (SubPlan 3) OR (SubPlan 4) OR (SubPlan 5) OR (SubPlan 6) OR ((SubPlan 9) AND ((SubPlan 10) OR (SubPlan 11))) OR ((SubPlan 14) AND ((SubPlan 15) OR (SubPlan 16))))
39.          

SubPlan (for Index Scan)

40. 0.000 0.000 ↓ 0.0

Materialize (cost=1.14..466,290.67 rows=8,949,571 width=16) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.14..377,842.82 rows=8,949,571 width=16) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.70..7,395.36 rows=25,734 width=16) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..531.21 rows=5,997 width=12) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on departmentgroupflathierarchy departmentgroupflathierarchy26 (cost=0.00..32.81 rows=341 width=16) (actual rows= loops=)

  • Filter: (parentid = '63748a86-7004-41a9-9534-09acd5a744ea'::uuid)
45. 0.000 0.000 ↓ 0.0

Index Scan using ixudgdepartmentgroupid on userdepartmentgroup userdepartmentgroup25 (cost=0.28..1.22 rows=24 width=28) (actual rows= loops=)

  • Index Cond: (departmentgroupid = departmentgroupflathierarchy26.childid)
46. 0.000 0.000 ↓ 0.0

Index Only Scan using ixtsuseridstartdateenddate on timesheet timesheet24 (cost=0.42..1.10 rows=4 width=12) (actual rows= loops=)

  • Index Cond: ((userid = userdepartmentgroup25.userid) AND (startdate <= userdepartmentgroup25.enddate) AND (enddate >= userdepartmentgroup25.startdate))
47. 0.000 0.000 ↓ 0.0

Index Scan using ixter2userid on timeentryrevision timeentryrevision23 (cost=0.44..10.74 rows=366 width=24) (actual rows= loops=)

  • Index Cond: ((userid = timesheet24.userid) AND (timesheet24.startdate <= entrydate) AND (timesheet24.enddate >= entrydate))
48. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.53..28.82 rows=3 width=32) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.25..20.07 rows=12 width=84) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.97..7.42 rows=1 width=4) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.55..4.59 rows=1 width=20) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Index Scan using uix2tsar_nodeid_userid on tsapprovalrequest tsapprovalrequest30 (cost=0.27..2.29 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (userid = 5,092)
53. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalnodes_pkey on timesheetapprovalnodes timesheetapprovalnodes29 (cost=0.28..2.29 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequest30.nodeid)
54. 0.000 0.000 ↓ 0.0

Index Scan using timesheet_pkey on timesheet timesheet28 (cost=0.42..2.14 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = timesheetapprovalnodes29.timesheetid)
  • Filter: ((startdate <= timeentryrevision22.entrydate) AND (enddate >= timeentryrevision22.entrydate) AND (userid = timeentryrevision22.userid))
55. 0.000 0.000 ↓ 0.0

Index Scan using ixtsarkvtsapprovalrequestid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue27 (cost=0.28..12.53 rows=12 width=88) (actual rows= loops=)

  • Index Cond: (tsapprovalrequestid = tsapprovalrequest30.id)
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
56. 0.000 0.000 ↓ 0.0

Index Scan using tsapprovalrequestkeyvalue_pkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue31 (cost=0.28..0.73 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequestkeyvalue27.parentid)
  • Filter: (parentid IS NULL)
57. 0.000 0.000 ↓ 0.0

Nested Loop (cost=18.48..47.66 rows=1 width=32) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.91..46.81 rows=1 width=16) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.35..44.69 rows=1 width=16) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.79..43.88 rows=1 width=16) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.23..41.83 rows=1 width=16) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.66..38.51 rows=1 width=16) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.10..35.92 rows=1 width=16) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.92..23.71 rows=1 width=16) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet33 (cost=0.42..5.60 rows=4 width=16) (actual rows= loops=)

  • Index Cond: ((userid = timeentryrevision22.userid) AND (startdate <= timeentryrevision22.entrydate) AND (enddate >= timeentryrevision22.entrydate))
66. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistory timesheetapprovalhistory34 (cost=3.50..4.52 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetid = timesheet33.id) AND (userid = 5,092))
67. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=3.50..3.50 rows=1 width=0) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtah2timesheetid (cost=0.00..1.46 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (timesheetid = timesheet33.id)
69. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahuserid (cost=0.00..1.78 rows=48 width=0) (actual rows= loops=)

  • Index Cond: (userid = 5,092)
70. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue35 (cost=11.18..12.20 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetapprovalhistoryid = timesheetapprovalhistory34.id) AND (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:5,092'::text))
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
71. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=11.18..11.18 rows=1 width=0) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..2.08 rows=69 width=0) (actual rows= loops=)

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory34.id)
73. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahkvuri (cost=0.00..8.79 rows=413 width=0) (actual rows= loops=)

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:5,092'::text)
74. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue36 (cost=0.56..2.59 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = sheetapprovalhistorykeyvalue35.parentid)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
75. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue37 (cost=0.56..3.31 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue36.parentid)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
76. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue38 (cost=0.56..1.96 rows=9 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue37.id)
77. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue39 (cost=0.56..0.80 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue38.id)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
78. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue40 (cost=0.56..2.03 rows=9 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue39.id)
79. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue32 (cost=0.56..0.75 rows=9 width=89) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue40.id)
80. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.53..21.81 rows=1 width=32) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.25..19.96 rows=1 width=84) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.97..7.42 rows=1 width=4) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.55..4.59 rows=1 width=20) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Index Scan using uix2tsar_nodeid_userid on tsapprovalrequest tsapprovalrequest44 (cost=0.27..2.29 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (userid = 5,092)
85. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalnodes_pkey on timesheetapprovalnodes timesheetapprovalnodes43 (cost=0.28..2.29 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequest44.nodeid)
86. 0.000 0.000 ↓ 0.0

Index Scan using timesheet_pkey on timesheet timesheet42 (cost=0.42..2.14 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = timesheetapprovalnodes43.timesheetid)
  • Filter: ((startdate <= timeentryrevision22.entrydate) AND (enddate >= timeentryrevision22.entrydate) AND (userid = timeentryrevision22.userid))
87. 0.000 0.000 ↓ 0.0

Index Scan using ixtsarkvtsapprovalrequestid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue41 (cost=0.28..12.53 rows=1 width=88) (actual rows= loops=)

  • Index Cond: (tsapprovalrequestid = tsapprovalrequest44.id)
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
88. 0.000 0.000 ↓ 0.0

Index Scan using tsapprovalrequestkeyvalue_pkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue45 (cost=0.28..1.84 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequestkeyvalue41.parentid)
  • Filter: (parentid IS NULL)
89. 0.000 0.000 ↓ 0.0

Nested Loop (cost=18.48..47.66 rows=1 width=32) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.91..46.81 rows=1 width=16) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.35..44.69 rows=1 width=16) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.79..43.88 rows=1 width=16) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.23..41.83 rows=1 width=16) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.66..38.51 rows=1 width=16) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.10..35.92 rows=1 width=16) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.92..23.71 rows=1 width=16) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet47 (cost=0.42..5.60 rows=4 width=16) (actual rows= loops=)

  • Index Cond: ((userid = timeentryrevision22.userid) AND (startdate <= timeentryrevision22.entrydate) AND (enddate >= timeentryrevision22.entrydate))
98. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistory timesheetapprovalhistory48 (cost=3.50..4.52 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetid = timesheet47.id) AND (userid = 5,092))
99. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=3.50..3.50 rows=1 width=0) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtah2timesheetid (cost=0.00..1.46 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (timesheetid = timesheet47.id)
101. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahuserid (cost=0.00..1.78 rows=48 width=0) (actual rows= loops=)

  • Index Cond: (userid = 5,092)
102. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue49 (cost=11.18..12.20 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetapprovalhistoryid = timesheetapprovalhistory48.id) AND (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:5,092'::text))
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
103. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=11.18..11.18 rows=1 width=0) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..2.08 rows=69 width=0) (actual rows= loops=)

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory48.id)
105. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahkvuri (cost=0.00..8.79 rows=413 width=0) (actual rows= loops=)

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:5,092'::text)
106. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue50 (cost=0.56..2.59 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = sheetapprovalhistorykeyvalue49.parentid)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
107. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue51 (cost=0.56..3.31 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue50.parentid)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
108. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue52 (cost=0.56..1.96 rows=9 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue51.id)
109. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue53 (cost=0.56..0.80 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue52.id)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
110. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue54 (cost=0.56..2.03 rows=9 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue53.id)
111. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue46 (cost=0.56..0.75 rows=9 width=89) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue54.id)
112. 0.000 0.000 ↓ 0.0

Index Scan using ixtemrtimeentryid on timeentrymetadatarevision timeentrymetadatarevision55 (cost=131.96..155.89 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (timeentryid = timeentryrevision22.timeentryid)
  • Filter: ((fromtimestamputc <= timeentryrevision22.fromtimestamputc) AND ((totimestamputc > timeentryrevision22.fromtimestamputc) OR (totimestamputc IS NULL)) AND (((upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 7)) OR ((upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 8))))
113.          

SubPlan (for Index Scan)

114. 0.000 0.000 ↓ 0.0

Index Scan using ixprjprojectleaderapproverid on project project56 (cost=0.42..21.97 rows=20 width=32) (actual rows= loops=)

  • Index Cond: (projectleaderapproverid = 5,092)
115. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..109.27 rows=40 width=32) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Index Scan using ixprjprojectleaderapproverid on project project58 (cost=0.42..21.77 rows=20 width=4) (actual rows= loops=)

  • Index Cond: (projectleaderapproverid = 5,092)
117. 0.000 0.000 ↓ 0.0

Index Scan using ixtkprojectid on task task57 (cost=0.42..4.31 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (projectid = project58.id)
118. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.53..28.82 rows=3 width=32) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.25..20.07 rows=12 width=84) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.97..7.42 rows=1 width=4) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.55..4.59 rows=1 width=20) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Index Scan using uix2tsar_nodeid_userid on tsapprovalrequest tsapprovalrequest62 (cost=0.27..2.29 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (userid = 5,092)
123. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalnodes_pkey on timesheetapprovalnodes timesheetapprovalnodes61 (cost=0.28..2.29 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequest62.nodeid)
124. 0.000 0.000 ↓ 0.0

Index Scan using timesheet_pkey on timesheet timesheet60 (cost=0.42..2.14 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = timesheetapprovalnodes61.timesheetid)
  • Filter: ((startdate <= timeentryrevision22.entrydate) AND (enddate >= timeentryrevision22.entrydate) AND (userid = timeentryrevision22.userid))
125. 0.000 0.000 ↓ 0.0

Index Scan using ixtsarkvtsapprovalrequestid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue59 (cost=0.28..12.53 rows=12 width=88) (actual rows= loops=)

  • Index Cond: (tsapprovalrequestid = tsapprovalrequest62.id)
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
126. 0.000 0.000 ↓ 0.0

Index Scan using tsapprovalrequestkeyvalue_pkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue63 (cost=0.28..0.73 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequestkeyvalue59.parentid)
  • Filter: (parentid IS NULL)
127. 0.000 0.000 ↓ 0.0

Nested Loop (cost=18.48..47.66 rows=1 width=32) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.91..46.81 rows=1 width=16) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.35..44.69 rows=1 width=16) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.79..43.88 rows=1 width=16) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.23..41.83 rows=1 width=16) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.66..38.51 rows=1 width=16) (actual rows= loops=)

133. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.10..35.92 rows=1 width=16) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.92..23.71 rows=1 width=16) (actual rows= loops=)

135. 0.000 0.000 ↓ 0.0

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet65 (cost=0.42..5.60 rows=4 width=16) (actual rows= loops=)

  • Index Cond: ((userid = timeentryrevision22.userid) AND (startdate <= timeentryrevision22.entrydate) AND (enddate >= timeentryrevision22.entrydate))
136. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistory timesheetapprovalhistory66 (cost=3.50..4.52 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetid = timesheet65.id) AND (userid = 5,092))
137. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=3.50..3.50 rows=1 width=0) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtah2timesheetid (cost=0.00..1.46 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (timesheetid = timesheet65.id)
139. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahuserid (cost=0.00..1.78 rows=48 width=0) (actual rows= loops=)

  • Index Cond: (userid = 5,092)
140. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue67 (cost=11.18..12.20 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetapprovalhistoryid = timesheetapprovalhistory66.id) AND (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:5,092'::text))
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
141. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=11.18..11.18 rows=1 width=0) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..2.08 rows=69 width=0) (actual rows= loops=)

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory66.id)
143. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahkvuri (cost=0.00..8.79 rows=413 width=0) (actual rows= loops=)

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:5,092'::text)
144. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue68 (cost=0.56..2.59 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = sheetapprovalhistorykeyvalue67.parentid)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
145. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue69 (cost=0.56..3.31 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue68.parentid)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
146. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue70 (cost=0.56..1.96 rows=9 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue69.id)
147. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue71 (cost=0.56..0.80 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue70.id)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
148. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue72 (cost=0.56..2.03 rows=9 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue71.id)
149. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue64 (cost=0.56..0.75 rows=9 width=89) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue72.id)
150. 0.000 0.000 ↓ 0.0

Index Scan using ixtemrtimeentryid on timeentrymetadatarevision timeentrymetadatarevision73 (cost=84.25..108.18 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (timeentryid = timeentryrevision22.timeentryid)
  • Filter: ((fromtimestamputc <= timeentryrevision22.fromtimestamputc) AND ((totimestamputc > timeentryrevision22.fromtimestamputc) OR (totimestamputc IS NULL)) AND (((upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 12)) OR ((upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 13))))
151.          

SubPlan (for Index Scan)

152. 0.000 0.000 ↓ 0.0

Nested Loop (cost=32.98..39.97 rows=6 width=32) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

HashAggregate (cost=32.56..32.62 rows=6 width=4) (actual rows= loops=)

  • Group Key: resentativeprojectassignment75.projectid
154. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.30..32.55 rows=6 width=4) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

Index Scan using uix2cr_clientuser on clientrepresentative clientrepresentative76 (cost=0.15..19.01 rows=8 width=16) (actual rows= loops=)

  • Index Cond: (userid = 5,092)
156. 0.000 0.000 ↓ 0.0

Index Scan using ixcrpaclientrepresentativeid on clientrepresentativeprojectassignment resentativeprojectassignment75 (cost=0.15..1.63 rows=6 width=20) (actual rows= loops=)

  • Index Cond: (clientrepresentativeid = clientrepresentative76.id)
157. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = resentativeprojectassignment75.projectid)
158. 0.000 0.000 ↓ 0.0

Nested Loop (cost=33.41..43.64 rows=23 width=32) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Nested Loop (cost=32.98..39.91 rows=6 width=8) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

HashAggregate (cost=32.56..32.62 rows=6 width=4) (actual rows= loops=)

  • Group Key: resentativeprojectassignment75_1.projectid
161. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.30..32.55 rows=6 width=4) (actual rows= loops=)

162. 0.000 0.000 ↓ 0.0

Index Scan using uix2cr_clientuser on clientrepresentative clientrepresentative76_1 (cost=0.15..19.01 rows=8 width=16) (actual rows= loops=)

  • Index Cond: (userid = 5,092)
163. 0.000 0.000 ↓ 0.0

Index Scan using ixcrpaclientrepresentativeid on clientrepresentativeprojectassignment resentativeprojectassignment75_1 (cost=0.15..1.63 rows=6 width=20) (actual rows= loops=)

  • Index Cond: (clientrepresentativeid = clientrepresentative76_1.id)
164. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = resentativeprojectassignment75_1.projectid)
165. 0.000 0.000 ↓ 0.0

Index Scan using ixtkprojectid on task task77 (cost=0.42..0.54 rows=4 width=8) (actual rows= loops=)

  • Index Cond: (projectid = project78.id)
166. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.53..28.82 rows=3 width=32) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.25..20.07 rows=12 width=84) (actual rows= loops=)

168. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.97..7.42 rows=1 width=4) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.55..4.59 rows=1 width=20) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Index Scan using uix2tsar_nodeid_userid on tsapprovalrequest tsapprovalrequest82 (cost=0.27..2.29 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (userid = 5,092)
171. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalnodes_pkey on timesheetapprovalnodes timesheetapprovalnodes81 (cost=0.28..2.29 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequest82.nodeid)
172. 0.000 0.000 ↓ 0.0

Index Scan using timesheet_pkey on timesheet timesheet80 (cost=0.42..2.14 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = timesheetapprovalnodes81.timesheetid)
  • Filter: ((startdate <= timeentryrevision22.entrydate) AND (enddate >= timeentryrevision22.entrydate) AND (userid = timeentryrevision22.userid))
173. 0.000 0.000 ↓ 0.0

Index Scan using ixtsarkvtsapprovalrequestid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue79 (cost=0.28..12.53 rows=12 width=88) (actual rows= loops=)

  • Index Cond: (tsapprovalrequestid = tsapprovalrequest82.id)
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
174. 0.000 0.000 ↓ 0.0

Index Scan using tsapprovalrequestkeyvalue_pkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue83 (cost=0.28..0.73 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequestkeyvalue79.parentid)
  • Filter: (parentid IS NULL)
175. 0.000 0.000 ↓ 0.0

Nested Loop (cost=18.48..47.66 rows=1 width=32) (actual rows= loops=)

176. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.91..46.81 rows=1 width=16) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.35..44.69 rows=1 width=16) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.79..43.88 rows=1 width=16) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.23..41.83 rows=1 width=16) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.66..38.51 rows=1 width=16) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.10..35.92 rows=1 width=16) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.92..23.71 rows=1 width=16) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet85 (cost=0.42..5.60 rows=4 width=16) (actual rows= loops=)

  • Index Cond: ((userid = timeentryrevision22.userid) AND (startdate <= timeentryrevision22.entrydate) AND (enddate >= timeentryrevision22.entrydate))
184. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistory timesheetapprovalhistory86 (cost=3.50..4.52 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetid = timesheet85.id) AND (userid = 5,092))
185. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=3.50..3.50 rows=1 width=0) (actual rows= loops=)

186. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtah2timesheetid (cost=0.00..1.46 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (timesheetid = timesheet85.id)
187. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahuserid (cost=0.00..1.78 rows=48 width=0) (actual rows= loops=)

  • Index Cond: (userid = 5,092)
188. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue87 (cost=11.18..12.20 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetapprovalhistoryid = timesheetapprovalhistory86.id) AND (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:5,092'::text))
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
189. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=11.18..11.18 rows=1 width=0) (actual rows= loops=)

190. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..2.08 rows=69 width=0) (actual rows= loops=)

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory86.id)
191. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahkvuri (cost=0.00..8.79 rows=413 width=0) (actual rows= loops=)

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:5,092'::text)
192. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue88 (cost=0.56..2.59 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = sheetapprovalhistorykeyvalue87.parentid)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
193. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue89 (cost=0.56..3.31 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue88.parentid)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
194. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue90 (cost=0.56..1.96 rows=9 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue89.id)
195. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue91 (cost=0.56..0.80 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue90.id)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
196. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue92 (cost=0.56..2.03 rows=9 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue91.id)
197. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue84 (cost=0.56..0.75 rows=9 width=89) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue92.id)
198. 0.000 0.000 ↓ 0.0

Seq Scan on timeoffs timeoffs93 (cost=6,945.93..11,484.29 rows=60,155 width=4) (actual rows= loops=)

  • Filter: ((userid = 5,092) OR (hashed SubPlan 18))
199.          

SubPlan (for Seq Scan)

200. 0.000 0.000 ↓ 0.0

Hash Join (cost=303.20..6,913.13 rows=13,117 width=4) (actual rows= loops=)

  • Hash Cond: (timeoffs94.userid = userdepartmentgroup95.userid)
  • Join Filter: ((userdepartmentgroup95.startdate <= timeoffs94.enddate) AND (userdepartmentgroup95.enddate >= timeoffs94.startdate))
201. 0.000 0.000 ↓ 0.0

Seq Scan on timeoffs timeoffs94 (cost=0.00..3,936.91 rows=120,291 width=16) (actual rows= loops=)

202. 0.000 0.000 ↓ 0.0

Hash (cost=228.24..228.24 rows=5,997 width=12) (actual rows= loops=)

203. 0.000 0.000 ↓ 0.0

Hash Join (cost=14.79..228.24 rows=5,997 width=12) (actual rows= loops=)

  • Hash Cond: (userdepartmentgroup95.departmentgroupid = departmentgroupflathierarchy96.childid)
204. 0.000 0.000 ↓ 0.0

Index Only Scan using ix4ucc_userdepartmentgroupstartend on userdepartmentgroup userdepartmentgroup95 (cost=0.28..196.96 rows=6,312 width=28) (actual rows= loops=)

205. 0.000 0.000 ↓ 0.0

Hash (cost=10.25..10.25 rows=341 width=16) (actual rows= loops=)

206. 0.000 0.000 ↓ 0.0

Index Only Scan using departmentgroupflathierarchy_pkey on departmentgroupflathierarchy departmentgroupflathierarchy96 (cost=0.28..10.25 rows=341 width=16) (actual rows= loops=)

  • Index Cond: (parentid = '63748a86-7004-41a9-9534-09acd5a744ea'::uuid)
207. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=1,662,205,546,012.00..1,662,205,554,251.01 rows=4,211 width=64) (actual rows= loops=)

  • Filter: ((hashed SubPlan 17) OR (hashed SubPlan 19))
208. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.84..9,155.61 rows=5,615 width=140) (actual rows= loops=)

  • Workers Planned: 1
209. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..7,594.11 rows=3,303 width=140) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Parallel Index Scan using uix2toe_timeoffidentrydate on timeoffentries toe (cost=0.42..4,210.22 rows=3,303 width=28) (actual rows= loops=)

  • Index Cond: ((entrydate >= '2020-08-02'::date) AND (entrydate <= '2020-08-22'::date))
211. 0.000 0.000 ↓ 0.0

Index Scan using timeoffs_pkey on timeoffs toff (cost=0.42..1.02 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = toe.timeoffid)
212. 0.000 0.000 ↓ 0.0

Hash (cost=391,203.92..391,203.92 rows=1 width=79) (actual rows= loops=)

213. 0.000 0.000 ↓ 0.0

Index Scan using ixtem2timeentryid on timeentrymetadata timeentrymetadata17 (cost=0.56..391,203.92 rows=1 width=79) (actual rows= loops=)

  • Index Cond: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BREAK-TYPE'::text)
214. 0.000 0.000 ↓ 0.0

Hash (cost=448,417.92..448,417.92 rows=223,623 width=79) (actual rows= loops=)

215. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..448,417.92 rows=223,623 width=79) (actual rows= loops=)

  • Workers Planned: 2
216. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on timeentrymetadata timeentrymetadata13 (cost=0.00..425,055.62 rows=93,176 width=79) (actual rows= loops=)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text)
217. 0.000 0.000 ↓ 0.0

Hash (cost=9,521.25..9,521.25 rows=489,122 width=4) (actual rows= loops=)

218. 0.000 0.000 ↓ 0.0

Index Only Scan using project_pkey on project project14 (cost=0.42..9,521.25 rows=489,122 width=4) (actual rows= loops=)

219. 0.000 0.000 ↓ 0.0

Index Scan using ixtemtimeentryid on timeentrymetadata timeentrymetadata15 (cost=0.56..1.78 rows=1 width=79) (actual rows= loops=)

  • Index Cond: ("*SELECT* 1".timeentryid = timeentryid)
  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text)
220. 0.000 0.000 ↓ 0.0

Index Scan using task_pkey on task task16 (cost=0.44..0.46 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (CASE WHEN ("substring"(timeentrymetadata15.uri, '^urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:task:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata15.uri, '^urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:task:(.*)$'::text))::integer ELSE NULL::integer END = id)
221. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project pj (cost=0.42..0.49 rows=1 width=44) (actual rows= loops=)

  • Index Cond: (id = COALESCE(project14.id, task16.projectid))
222. 0.000 0.000 ↓ 0.0

Index Scan using login_pkey on login (cost=0.28..225.29 rows=6,067 width=11) (actual rows= loops=)

223. 0.000 0.000 ↓ 0.0

Index Scan using task_pkey on task tk (cost=0.42..0.47 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (task16.id = id)
224. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.03 rows=1 width=4) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

Seq Scan on exchangerate (cost=0.00..1.03 rows=1 width=4) (actual rows= loops=)

  • Filter: ((variablecurrencyid = $0) AND (('now'::cstring)::date >= effectivedate) AND (('now'::cstring)::date <= enddate))
226. 0.000 0.000 ↓ 0.0

Index Scan using ixoefv_objectid on objectextensionfieldvalue objectextensionfieldvalue18 (cost=0.43..0.88 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ("*SELECT* 1".timeentryid = objectid)
  • Filter: ('4fd4e56a-a51a-4bbf-b826-fb7575748787'::uuid = definitionid)
227. 0.000 0.000 ↓ 0.0

Index Scan using objectextensiontag_pkey on objectextensiontag objectextensiontag4 (cost=0.27..0.29 rows=1 width=54) (actual rows= loops=)

  • Index Cond: (objectextensionfieldvalue18.tagid = id)
228. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.03 rows=2 width=38) (actual rows= loops=)

229. 0.000 0.000 ↓ 0.0

Seq Scan on billingrate billingrate5 (cost=0.00..1.02 rows=2 width=38) (actual rows= loops=)

230. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.71..1.18 rows=1 width=54) (actual rows= loops=)

231. 0.000 0.000 ↓ 0.0

Index Scan using ixoefv_objectid on objectextensionfieldvalue objectextensionfieldvalue19 (cost=0.43..0.88 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ("*SELECT* 1".timeentryid = objectid)
  • Filter: ('b814810f-03d6-4d06-894f-7d8b64bffed5'::uuid = definitionid)
232. 0.000 0.000 ↓ 0.0

Index Scan using objectextensiontag_pkey on objectextensiontag objectextensiontag11 (cost=0.27..0.29 rows=1 width=54) (actual rows= loops=)

  • Index Cond: (objectextensionfieldvalue19.tagid = id)
233. 0.000 0.000 ↓ 0.0

Sort (cost=496,069.66..496,659.12 rows=235,782 width=178) (actual rows= loops=)

  • Sort Key: ts.userid
234. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=27,874.48..475,029.54 rows=235,782 width=178) (actual rows= loops=)

  • Hash Cond: (tah.timesheetid = ts.id)
235. 0.000 0.000 ↓ 0.0

Gather (cost=7,666.86..453,154.12 rows=121,294 width=166) (actual rows= loops=)

  • Workers Planned: 2
236. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=6,666.86..440,024.72 rows=50,539 width=166) (actual rows= loops=)

237. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=6,666.29..234,046.85 rows=50,214 width=109) (actual rows= loops=)

238. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,665.73..28,571.12 rows=50,214 width=36) (actual rows= loops=)

  • Hash Cond: (tah.timesheetid = tahls.timesheetid)
  • Filter: ((tahls.timesheetid IS NULL) OR (tah.serialnumber > tahls.lastsubmitserialnumber))
239. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on timesheetapprovalhistory tah (cost=0.00..21,509.94 rows=150,643 width=40) (actual rows= loops=)

  • Filter: (((systemprocessidentifier IS NULL) OR (systemprocessidentifier <> 'urn:replicon:approval-system-process:timesheet-submit-script-data-and-validation'::text)) AND (action = ANY ('{2,3,6}'::integer[])))
240. 0.000 0.000 ↓ 0.0

Hash (cost=3,795.88..3,795.88 rows=229,588 width=20) (actual rows= loops=)

241. 0.000 0.000 ↓ 0.0

Seq Scan on timesheetapprovalhistorylastsubmit tahls (cost=0.00..3,795.88 rows=229,588 width=20) (actual rows= loops=)

242. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvtimesheetapprovalhistoryid on timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue7 (cost=0.56..4.07 rows=2 width=89) (actual rows= loops=)

  • Index Cond: (tah.id = timesheetapprovalhistoryid)
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:ACTING-ACTUAL-USER'::text)
243. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvtimesheetapprovalhistoryid on timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue8 (cost=0.56..4.07 rows=3 width=89) (actual rows= loops=)

  • Index Cond: (tah.id = timesheetapprovalhistoryid)
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:ACTING-EFFECTIVE-USER'::text)
244. 0.000 0.000 ↓ 0.0

Hash (cost=17,279.31..17,279.31 rows=234,265 width=28) (actual rows= loops=)

245. 0.000 0.000 ↓ 0.0

Hash Join (cost=7,899.38..17,279.31 rows=234,265 width=28) (actual rows= loops=)

  • Hash Cond: (tslist.timesheetid = ts.id)
246. 0.000 0.000 ↓ 0.0

Index Only Scan using dm_timesheetlist_facts_pkey on dm_timesheetlist_facts tslist (cost=0.42..8,765.40 rows=234,265 width=16) (actual rows= loops=)

247. 0.000 0.000 ↓ 0.0

Hash (cost=4,970.65..4,970.65 rows=234,265 width=28) (actual rows= loops=)

248. 0.000 0.000 ↓ 0.0

Seq Scan on timesheet ts (cost=0.00..4,970.65 rows=234,265 width=28) (actual rows= loops=)

249. 0.000 0.000 ↓ 0.0

Hash (cost=414.46..414.46 rows=3,888 width=4) (actual rows= loops=)

250. 0.000 0.000 ↓ 0.0

HashAggregate (cost=375.58..414.46 rows=3,888 width=4) (actual rows= loops=)

  • Group Key: userdepartmentgroup20.userid
251. 0.000 0.000 ↓ 0.0

Index Scan using ixudgdepartmentgroupid on userdepartmentgroup userdepartmentgroup20 (cost=0.28..365.69 rows=3,953 width=4) (actual rows= loops=)

  • Index Cond: (departmentgroupid = ANY ('{63748a86-7004-41a9-9534-09acd5a744ea,8e621d29-67cf-4952-89db-ad7dd8f791d1,15c9d6e1-0857-459b-9760-e451379f64d6,1372b5d3-6510-4b3f-932e-6a71fe046162,eecfd2f5-f2cf-4793-b52c-8df4bf912ccf,dd9238b8-1f09-47c5-8f28-3b83754396cc,d54c0ed6-da63-42a7-a36c-1434e31b7ed3,a6593f86-8113-4043-8c6e-0ccd4c1f2330,d31e8f6b-d902-4e3b-a092-39c533350c4b,6ec13843-cea4-4378-8e45-5816bd94df0e,28390661-3560-4f82-876a-0a861316da58,d619eb68-0109-4484-94aa-64daad7e45e2,6ded36b4-926f-42e8-bb76-b4841dc84daa,1431adc5-d248-4036-8f4c-3b4c92a351e1,9f7eebd8-658e-4156-a41c-b4217516249d,3210bf30-d4a5-4340-a686-8724ff5ba042,76e8b759-b850-4743-af4a-229c62bc24d4,635df3af-c5fc-4de1-9ac3-ad159fe7d2e8,8347f4dd-7ceb-4a9b-a63c-db15f97885fe,66e2609c-d09a-4d81-851f-3022ec9f86b9,3603b72b-d563-4e6e-a903-b77dc28bc77e,59d6c73e-7d73-4c7e-9aeb-cfc07fecb4dc,0dc1ed32-bbbf-43c3-9ba5-358cc8810d4c,5fbf141f-e062-471a-acfe-504f26354a7e,a34ba05e-ea27-4dd6-83a3-580bbbd88e46,35743079-9554-46cf-9027-55a8525a267f,49040497-c304-4b25-be1d-a7fe9992f02b,35839b20-cf03-45eb-9347-571c33544434,5c47eb12-b3b5-4040-b269-a1a7f784d42e,63a8aa57-d028-4fd7-8f0e-d7370a0f8ca3,0dfb0bfe-e84b-4170-821e-dd230248457d,433c099c-2399-46b6-9b36-6cdb6eb56323,3a5a38f9-948d-4e3d-a1bb-b25942d34d9d,6ee697f7-c4b1-4352-87c4-058e08e1e2d3,24639159-a17c-4ebc-bcd2-808cdf40816c,7775c4d1-4d3b-4ead-b938-6ff9b7aa7fbf,165e80b8-9a69-48b9-822e-f3e99285b07d,40058f31-2cd8-4d5b-b8b7-97c1f8d0d5f1,12216a4f-c309-4bbc-8dc4-1ffeb2d6b35e,1603bc1d-6d09-487f-8e27-9340e3d41723,b50b3576-8348-4518-8f71-ee3a68cda3f3,66055b98-0f33-4fbf-8955-ee3253f85da8,1d9c9304-dd95-4b98-bb18-fad11e486c26,e5872134-b8c9-4e04-9cc8-5a7e4304b822,daa20114-beea-47f2-a865-0b2714455bfb,ab86cd16-180e-47af-a669-3631d6dc4306,ef973d1f-8f5e-4e1f-bf15-cc8c18493c17,abce2340-6dcd-4bc3-b51d-82dbe87c466e,288c8df4-d193-4187-a206-f70eab8d05c7,070ce7fb-9fa1-416d-828c-b79e1ac46ef7,4e761b7f-f088-4090-9dc5-eee086203626,a4232b93-e61f-4745-ac13-403f03f0604e,e2da09cc-73c5-4a8c-9ba1-35bc78052255,b12f4d54-aa4c-42c9-a4e4-86ade4b45a13,35c12b1c-ae57-4d71-990f-8cd289d682e6,7579e1e6-b1e3-43e3-b461-b12f28d1d5ad,c41786ab-9e89-4854-84f1-2971e1a08744,f85c882a-3e1d-4119-ab91-8ed3e2a02e8c,346c6801-7eb9-4dd5-b661-517e26643327,d3b88ecd-8dd8-494c-9348-5fd04a39eebf,6011c3d1-e9b2-44f6-bdaa-85aa8a397045,2ff09dc5-90a3-46d7-82a0-f49e50e7b21a,a200cd7a-9fbe-42d6-b74d-95f634d03179,353ad7d3-7565-47a9-88d5-888af2e2e905,5446549c-ab9d-449b-8daa-b2a70e2595be,ca90dbb0-aacb-4a7a-8d54-1853aaa6dba4,56558278-2404-4ee2-af44-1d0312d75848,7d11c14d-11a6-45f8-bde0-291262d1d0f9,320381f9-56ab-44a4-8080-181b59f2d89c,431b8fff-153d-457b-ac31-a980580cc5c2,6f6a3add-50a5-4910-84c2-52e658cdb7ee,e5e53f15-00ce-444b-94ed-596b03f5cff9,8b2fce9e-da3d-4ce5-b1a5-f2969ff57745,babdd4d8-bc7a-4b69-b699-4ab2e05040a7,525e1ae6-d02d-442d-bfa3-73193bb3cbb1,96eaf8c5-49d0-4935-925e-969f7a390c82,dc18f638-832e-4e0c-a997-9ef2c38dd58d,4774ec08-5a2b-4f76-b40f-ce45618b42d2,6e84c9be-ded8-43c5-8fb2-c8a27969774d,b143401d-ce1f-458f-ae0d-9280e644d113,4e0ce556-2b97-4cb5-9b3f-493c14e17016,e3e44e22-694f-4f16-9c37-bd0740a12683,551e27c1-4aa0-40b3-b5fb-06e84dc529cd,74bb6af0-73cb-405d-9e83-fc0a8d15c9ce,2af7803c-af5c-49bc-9801-34247c6a567d,36d486ee-dd1d-433c-a7b4-878559fc8312,016a0b90-7fad-4190-bf9b-36e21c2a5a48,758d8018-7878-47bf-8857-c8fae66bc144,3eb7d2a6-f0d0-482a-ac61-1730f4a3be75,f5764a3d-1f52-4bd4-baff-6d54b46dc348,a13e37ed-5e75-46e3-a494-153828a35d33,cead2f3d-a852-47d8-ad5b-c900a3f944f4,bd41a941-5037-4656-b2ca-1e329784f3d7,5e5cd89a-089c-4219-b475-da0951a73eaa,fb4b63a5-6a9d-4306-b204-09da34906638,9dfc4070-af27-42f9-be68-24cf4242f960,0951edf9-d5c9-414e-ae62-c6fb7162fae6,85dcd1cb-dc11-4d3a-ae36-910f66198ff9,099b1f93-e1de-42e9-9b4b-0b0d6499bd8e,bf89d697-d059-4aa7-9dac-deb860af3ad7,f02fb3c9-c396-45e4-906f-07474de6f333,e617a439-21f6-4882-b2ab-f2a3512b9b38,c2ce1967-2335-4e8c-8f04-597283cd904c,bb6d6520-5038-41f7-91a3-456314480981,d9dadd7f-c334-4d0b-af42-df1191c5a1d8,e031d76e-f195-43e7-93e4-13e36b2146fc,240aef54-144b-4e24-9ff7-63fa7c110963,772ae0c9-d1bd-42b7-9b6c-635718c92db5,85080ec1-4f49-466b-a3f9-8fcc6e258b7a,682a92de-7249-45be-b69f-af4b45b3cf7b,b1b44e1c-4377-404e-8066-3fb0cee73f41,53af70ff-0cb8-4c7c-aff9-6d030ca858fd,12a0d4bb-6d4f-45ac-aaa7-8854f9bf91c0,b4f3ce8f-bf07-435e-95f0-465ce4f3872e,473cb95d-f86e-4341-b2c1-1359d36d1500,e6aadcab-97bb-459d-a35d-e4c5e547448d,18abf21f-fb18-419c-9bf0-04141b13a4d4,a1e912d1-b8e8-402b-9103-3dd9f25793dd,3046bbbd-0689-4213-afea-45f5eb78a0e7,2dc92cc5-1b22-4e93-96b9-f6832ab573e0,dd3bc6cf-a3df-4ce1-b89c-f49f192fdb40,ee33169a-f927-4b03-87ec-3098806aa407,76665255-ca29-411c-8de2-230a09d529b8,1c4271dc-3f71-4913-87d3-fbb7cd730a55,e0d74777-7428-45c6-bc06-2b70318a1c78,b80ee300-1e0a-4fbc-a68e-8afc168bd2bc,b7b9a235-bb99-4801-8d9c-1a0fb1e33469,be8b6a21-bdea-4d8d-8f7c-4f74bd265ece,a9e8fb08-2ba5-4984-a182-33820287896c,b9604c84-9930-4421-b3f1-2bcab0b5e1eb,f7bca334-7745-4ac0-87b3-1af99a58d0ba,c9179b87-ab2c-4e9d-84a7-20b69acdfacc,c0bd98f8-142c-4ecd-a8ea-bc6f46b84416,e09886a1-6cc1-476d-9469-59401d82f973,4691360e-fd4c-483a-9f20-04830d9c802c,f1229825-72f0-4231-a94a-a305c3cbdbbb,bcd545cd-fdd6-4e9a-851e-6c2ac7136c64,eb4bcec0-3231-46f8-a4f4-1c81374d8884,5c7ed232-ab3c-4f5d-a726-08813a901e77,6c056885-c32f-49d2-878b-74182cbe350b,545c071c-75bc-4010-b966-d5a48bcf2d54,f42f4cbe-0eed-41db-989e-4e78b94db334,c2744556-146d-4fc7-9bb1-3f66dd034aa4,1481d777-5425-4535-b4af-07cf1344045e,07aeb6ec-bbbd-442b-afac-c9d33e6256f5,415b5343-cc7f-46d6-9221-e91f3d9cbf20,06b80d19-5833-4879-acb9-b497a6c00569,d70d1a8f-a138-4579-8f37-eddc419b9058,ec76edcc-7198-45b3-8189-91c82f4ef489,5cdf39b4-5515-4872-90b6-5394d682d89a,88fcb8eb-1de6-4e3a-9c1b-e67ee8799700,b88b0ff4-8756-4f62-8c21-9249a9697ba1,9f0abd7b-36f6-4181-86bb-bfd30d4fa185,5f49cf45-0593-47ed-b4f2-4fdd31c9877c,42e53d7b-8fc6-4e7c-84a5-00d4f6e02eef,5a86cbea-a72e-47f0-ad80-471178c33f18,79202f69-4224-4aa9-9aa7-ea2d2e7960c4,cbe0ca9c-cab8-498a-9b5e-5ef8967ae895,5f99637f-8336-47fb-adc5-0ea40e840398,53bf4d0b-caee-420f-aff8-2ca5be8e3ed3,aef54f59-856a-4bc4-b4ca-5f25cf542e85,e028afbd-5edb-45fb-aaba-00646c450714,a386b17f-c3d7-4c41-a2fb-935433c8c48d,17868ed3-a073-4006-82fe-18508c4523a8,c2ec7d62-79bb-40b6-89fa-01ba79056484,c0f89a7e-8969-4cbb-ab4b-1609e834248c,90eaf634-7b13-49a4-8691-1673677aa3f3,c450eebf-eb1f-40ce-836e-568af98a3d90,4422316b-93cf-485b-87a1-bcc62c4134dd,bc6a2111-45e9-4bd1-a66d-2d240cbb069e,1afffdfe-f207-4ea8-a423-093ef8436930,3b6ccdd2-bafb-4847-81be-baf62e100d96,bc9a8812-163f-4bac-b0e0-c6ca036498e8,88b9e729-b80d-4a54-981d-a8b3d4dbfecd,fa646ec5-d008-4825-8098-a60409286438,32fc5827-965f-4e3c-828e-082417b8178b,fb2e658b-de2a-4d20-8120-0f081767b458,a7a62289-d3f2-4f07-9f06-a09df743466c,f9872977-a176-4458-8c20-ab7693186b53,05302366-b851-42ff-99a9-709edd35a3d3,23cb296c-1360-4ef6-bcfe-5cd7b14b5fde,8646a47f-cb63-4206-bea4-71a1590944ba,ab3f502f-f0b7-4a13-aa29-b971afea879a,f900118d-2183-4369-bae9-e5605d074d8b,7454aea5-30a5-4236-b90a-6741223476e5,d08cce01-60e2-43b4-9b8e-e2e13e9e9c02,48343c20-dcda-45fd-b935-5e0db0622e4d,5a040c5b-61ab-4f10-8664-391ade1a44a1,a16cfce7-6510-4806-9f2b-5c5839807ea7,0bcbaff6-0882-4165-b036-390281dbf546,a69e008a-2690-4d67-9294-eb9cce64daf2,f6552eec-9de3-4970-a9a2-bb00453805cf,82607295-d547-4027-94c1-74de4d8d74ab,27765483-f2a3-42db-a013-024bf6e83027,908fe188-f39e-4e40-b5d7-a080c734d3c6,5b1a9f95-e64f-414c-9bcc-72e34fbc457a,38c17637-138d-4964-a34f-edcd4d1366f8,e72a2d81-ff50-4d55-b078-171a00a2b09b,00b9c56a-6837-4ea7-8f43-93692c91d82b,995ff036-c64e-4117-b049-596bfeea5e11,a4434aac-a520-46bd-a358-43d30db0b5e9,e606fc71-2574-4487-bb49-6801c4b5527d,94671404-911c-446a-88b1-e9f0ca829135,cb80978a-0f1a-4c50-900e-8aac938775e8,70a4561b-dcfa-4290-a699-ffc4fb207120,df8dc109-6b8e-48c3-9edd-2ffc7ee4714f,63feb72d-c1e7-4459-a5fc-fd7cb5a90d72,7a0866d5-4326-4773-97fa-30869ae160b9,22aaa2cc-b51f-4bab-a21d-1a67a067a025,a912fbde-810f-4562-ab4b-33d691b73834,d3f3f024-5032-42cf-a423-4e1475d6593f,04a0a1d3-3885-4c36-80bf-64b04f90fd24,89455064-6f90-471d-80a2-e4fa65986326,55d72f75-d8cb-46f0-a029-55e77800a751,ac88b9ec-8cac-44e8-baa5-a62345f7f934,5d23cbec-af2c-417f-b207-04e5c50dbf9b,f86b5bc7-4a4a-4b29-b188-6d9d19f2fcb6,8fe6723b-5109-47cb-a60f-d25dc0f9fef4,36e14ea5-32a2-426d-a8a5-2fe0b08cb7db,d7f2a899-6113-4414-b448-b7a61b1eaa65,f0272dc0-f05c-495b-bd35-034435d4b56d,087cc6ef-c884-4215-bbcc-0f788694ece9,8ef49263-070e-4987-bbdf-966019effb3a,1fada185-6c37-40ca-8f79-1cb51ed7eb85,73a5f40a-ed9e-445b-8ccd-effd0523fe14,b4e83f5e-9ff7-4f20-9007-8605dffce375,3e7d7822-a861-44bd-bf96-93d5f662fbfc,49e85b23-8de0-400a-8393-783109c2fe25,678dc0ad-ebef-4897-9d13-d6a3c802ffc0,c891a653-0d04-430d-94d0-f698c958a733,b3df14ec-5a97-4b70-8794-dd5642833fb7,77d81db5-f470-435d-ac11-42a37055471b,bc708552-8f6e-4378-9eac-45352a94cbcc,04000bf2-3602-4b83-b6c4-735987b21381,0b035355-7de6-4dc4-8028-d344138407a0,730bc872-6b08-4b2d-bcc5-fb47c48671eb,8b20b960-1c49-41d4-8cbc-52fe7ee00b2d,d96a74f4-bedb-4cb8-8ec8-fd96a93a9e8a,8b95c741-4ac4-47c9-961f-f22b6a3c2859,1f89a938-9dcb-4917-884e-eada1007a002,8434347c-b200-4296-89e6-56062713511d,e1fa2be4-b5fd-4533-96be-a0965c6e40b4,23096542-b97b-4bb2-8d1e-1631471d1ffc,79a13552-0060-4bfc-a927-c7687a9551c5,b304480c-5e8a-4bf1-83e9-be0aa55e318d,20f14bac-5990-4151-8825-daf6378a4201,9b87345e-3f39-4945-aede-2791b91b3267,09e06f0b-e478-4769-a9b5-15b343d0a9e6,2b6d5154-7bd6-4a13-bff2-31c11b892862,ac7f7845-e6fe-42f9-b0e6-0514e4f0d2c8,b945a978-7d84-47e6-984f-3a43c00d7901,6d6f291a-b667-4693-bc39-f434ae3e7056,3ad5ef4b-e132-4fee-a95a-1ed9ab257101,79f761bb-4184-4d18-94c3-1e978c99d9da,586b9046-693f-4f36-93c4-77c6a79823f9,7c598816-d5c6-4322-b9a9-3d229844090a,35a035fc-fba9-4a6f-91cb-dea7d4db8b5f,e7e0a591-5435-42f2-adfa-1572a9678c1f,de47bc19-82e7-4cf0-8c84-94168b9c1f93,3bd2be6b-40fc-48f6-a3e4-90a935399fbe,0289e414-3dd5-47aa-b38f-da78b9c68427,0ceb5449-3a98-4e5a-be54-03b3bc6d55c2,e7130fb7-fcbf-4a82-ad4b-d6c446bbc873,73c4bdf9-f9ef-4acb-a671-6543d7bfb473,c82fd458-8f54-4806-b3e5-73f0654d1cdc,654da51d-a471-4a88-b5c5-c7d65b1f1a73,af827711-fdd7-48e2-b6d0-f92d971524e8,19c74da4-514c-4dbd-afb4-244cc43c631b,897170ab-d87f-4615-8c68-77e4d0852e76,6e4f7031-fb3c-41cd-b29d-949902f6e89a,1d40d09b-0fa9-4049-b726-335cb105f7a7,e3b09223-957f-40f3-92b2-fb1ad84f0ec9,112f7dc7-9f03-46c9-9613-ad96755c72ba,d85dd5ae-2d64-459d-908d-7cdab312129e,90c75e56-96b6-449c-85c5-21826c609a9d,dcf60d5e-75e7-4986-8a34-a7d2c6caf969,081f9383-8ebb-4e2d-b32f-fb908b22c05d,a17174e1-70af-413e-95d1-b618564b7724,4d65d1ab-dd8d-4277-bf86-5b36ab3dd754,ae326f30-871b-4c35-9564-21031e6a8478,cfe0d7ac-a127-4b59-a85a-b33fd1c3df02,f96f9791-62a1-431a-9e26-8ff8e67c2b11,c75490bf-d799-4bf3-b271-9ccc715fa6aa,6cededac-c0d6-48be-a975-d2c883e7b6b0,ab4e9860-ffb3-4f9b-8c79-f2a1215585c6,0488f85e-3f8f-4977-a73b-46321d77f68d,8181206e-496f-49c2-b6df-625d64148438,064507a5-40aa-4d00-be7d-ec1ed9b8af85,3d1fa0ae-a9f1-4471-ae97-ceaafb22541b,0a888b84-0d0e-4bf9-8e16-61db76fb2e19,a4160bc7-f1f2-4a51-a3e2-cfb9abc964dd,f075ebce-6cbc-41a4-9fcb-f7999be58454,5070fb96-43e7-4c6e-9868-d008d4d509fe,a4f23018-8f47-4379-ad48-5a7cac0ca1f0,5103585c-802e-4a3f-b304-f281559f8c4c,7a88d1f8-e63a-4f7f-9583-33a883b6249f,fd641c08-5fca-4565-a9ca-f9c032096bf3,0feb22cf-e4fb-49dc-b469-4d219cef9048,1d642af9-62af-4ef5-a3c7-6dc790d16267,bd416342-6960-4433-a14d-e20e88390ec1,e98bd248-704e-4d12-9a1a-f45def57d218,8bebaaab-15d8-4c65-8a1f-c163fffbaa9f,596b351a-033b-4a1d-9a4d-45b55a28dce4,9add729c-2677-47b1-81a8-b86a9e2b66be,4505933f-0c7b-4868-8914-33ed01193d77,5a48c2dc-0436-4d7a-81af-ace6cf18b851,bf6d8c85-bc2d-40b0-944f-000ba7484c07,2aad4daf-5181-48bf-99a0-f91be557449a,00b7844c-4603-45c0-8525-9b6e2cfcdf31,90c41a83-32f2-4285-8e9c-f66742ddafdb,9c7b3048-d6d8-4cf7-9011-b8b67f50f67b,895aba65-d492-4b16-966c-e4a8f90a6115,56853e42-273e-4bb8-868c-84bf3be5817b,e14d6eda-315c-4775-8ce8-d1ff242be0d5,bef0bba3-ecff-4de6-a366-df0eb0952704,5c847892-c1d8-4b73-8ac1-f1fae741f62c,9400befe-cd77-4684-841c-a82340b91a90,880cb58d-9388-4389-8ea7-01b7db93af29,5008dd18-5dbf-4489-a8da-26fe5f1b1aec,e9304ba6-1e0f-48b1-b205-dc4ddcb882ff,bf101ede-c665-4abc-aefc-3cac06c056d4,b341e12b-26d1-4b71-9f7f-1ce68ce312cf,09d7166a-1fce-4ecc-92d9-7a8b1a9e240f,fe91b354-5733-4492-a08a-822683bff927,f1995d29-f88f-4dde-a790-414addbebbb3,98210347-8075-4eab-a6dc-cd2fbc0dc8f9,39dc3c65-d01a-4e5d-b9bf-e6805c46fe88,51719d56-1569-485b-b2a6-60ff4852aad7,a22303a3-1bb7-423e-9529-e192104dd820,23e891b2-c089-4454-8292-e680ae9f06c0,d31b6240-12a3-4b08-816f-42b2b9d2f794,66a74107-df57-4600-aa14-f1d942fa801b,ce157f37-c738-4384-a793-dcf1e11735c6,75e16233-2e78-4364-8801-5a5afdaceb5b,67e67836-54e3-4b56-bc23-54caf470f0a8,25c110a8-50b8-41d7-ad88-9f7f0eace4e2,75e4ee7f-e174-4f2a-bff9-d77769a53996,206719e6-520b-4b60-a403-5ca28f6ff7b3,55ab98f2-a9a9-4158-aacc-19041283e64c,8a7b33ea-94a2-409a-8265-77070d08b804,6e47c766-449e-41a7-9095-8d1186bdfe68}'::uuid[]))
  • Filter: ((startdate <= '2020-09-02'::date) AND (enddate >= '2020-09-02'::date))
252. 0.000 0.000 ↓ 0.0

Hash (cost=213,195.46..213,195.46 rows=685,907 width=20) (actual rows= loops=)

253. 0.000 0.000 ↓ 0.0

Seq Scan on objectextensionfieldvalue objectextensionfieldvalue12 (cost=0.00..213,195.46 rows=685,907 width=20) (actual rows= loops=)

  • Filter: ('d11e18bc-d5d2-4205-8af0-cc8993994362'::uuid = definitionid)