explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UQpz

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

Sort (cost=17,871,653,826.78..17,871,653,826.78 rows=1 width=1,329) (actual rows= loops=)

  • Sort Key: ((pj.name)::character varying(255)) COLLATE "en_US", ((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", "*SELECT* 1".entrydate
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,935,478,947.47..17,871,653,826.77 rows=1 width=1,329) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8,935,478,947.19..17,871,653,826.47 rows=1 width=104) (actual rows= loops=)

  • Filter: (((timeentrymetadata9.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))
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,935,478,946.63..17,871,653,825.47 rows=1 width=128) (actual rows= loops=)

  • Join Filter: (pj.id = project11.id)
5. 0.000 0.000 ↓ 0.0

Merge Semi Join (cost=8,935,478,946.20..17,871,653,752.63 rows=4,693 width=132) (actual rows= loops=)

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

Nested Loop (cost=8,935,478,909.99..17,871,653,692.25 rows=9,386 width=128) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8,935,478,909.57..17,871,649,097.82 rows=9,386 width=92) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8,935,478,909.13..17,871,644,793.74 rows=9,386 width=151) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8,935,478,908.57..17,871,638,022.18 rows=6,788 width=88) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8,935,478,908.14..17,871,634,305.80 rows=6,788 width=147) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,935,478,907.57..17,871,627,534.24 rows=6,788 width=84) (actual rows= loops=)

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

Nested Loop (cost=0.56..254.64 rows=34 width=36) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Only Scan using ix4ucc_userdepartmentgroupstartend on userdepartmentgroup userdepartmentgroup8 (cost=0.28..194.44 rows=34 width=4) (actual rows= loops=)

  • Index Cond: ((startdate <= '2020-09-02'::date) AND (enddate >= '2020-09-02'::date))
  • Filter: (departmentgroupid = ANY ('{5b1a9f95-e64f-414c-9bcc-72e34fbc457a,38c17637-138d-4964-a34f-edcd4d1366f8}'::uuid[]))
14. 0.000 0.000 ↓ 0.0

Index Scan using userinfo_pkey on userinfo ui (cost=0.28..1.77 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = userdepartmentgroup8.userid)
15. 0.000 0.000 ↓ 0.0

Materialize (cost=8,935,478,907.01..17,871,012,574.29 rows=1,211,242 width=48) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Append (cost=8,935,478,907.01..17,871,006,518.08 rows=1,211,242 width=48) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=8,935,478,907.01..8,936,007,920.20 rows=1,193,172 width=48) (actual rows= loops=)

  • Filter: ((hashed SubPlan 18) OR (hashed SubPlan 28))
18. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=490,693.13..995,842.88 rows=1,590,896 width=140) (actual rows= loops=)

  • Hash Cond: (te.id = temdbreaktype.timeentryid)
19. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=100,170.05..571,513.25 rows=1,590,896 width=60) (actual rows= loops=)

  • Hash Cond: (tembillingrate.timeentryid = te.id)
20. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..469,146.21 rows=434,638 width=16) (actual rows= loops=)

  • Workers Planned: 2
21. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on timeentrymetadata tembillingrate (cost=0.00..424,682.41 rows=181,099 width=16) (actual rows= loops=)

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

Hash (cost=79,283.85..79,283.85 rows=1,590,896 width=60) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..79,283.85 rows=1,590,896 width=60) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..2.03 rows=1 width=0) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

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

26. 0.000 0.000 ↓ 0.0

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

27. 0.000 0.000 ↓ 0.0

Index Scan using ixte2entrydate on timeentry te (cost=0.43..63,372.86 rows=1,590,896 width=60) (actual rows= loops=)

  • Index Cond: ((entrydate >= '2020-06-21'::date) AND (entrydate <= '2020-09-06'::date))
  • Filter: ((timeallocationtype <> 2) OR (timeallocationtype IS NULL))
28. 0.000 0.000 ↓ 0.0

Hash (cost=390,523.07..390,523.07 rows=1 width=16) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Index Scan using ixtem2timeentryid on timeentrymetadata temdbreaktype (cost=0.56..390,523.07 rows=1 width=16) (actual rows= loops=)

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

SubPlan (for Subquery Scan)

31. 0.000 0.000 ↓ 0.0

Merge Join (cost=2,756.23..8,923,256,717.75 rows=6,718,845 width=16) (actual rows= loops=)

  • Merge Cond: (timeentryrevision12.id = timeentryrevision13.id)
32. 0.000 0.000 ↓ 0.0

Index Scan using timeentryrevision_pkey on timeentryrevision timeentryrevision12 (cost=0.56..767,233.10 rows=6,760,102 width=32) (actual rows= loops=)

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

Index Scan using timeentryrevision_pkey on timeentryrevision timeentryrevision13 (cost=2,755.66..8,922,358,372.10 rows=18,809,536 width=16) (actual rows= loops=)

  • Filter: ((hashed SubPlan 1) OR (userid = 4,521) OR (alternatives: SubPlan 2 or hashed SubPlan 3) OR (SubPlan 4) OR (SubPlan 5) OR (SubPlan 6) OR (SubPlan 7) OR ((SubPlan 10) AND ((SubPlan 11) OR (SubPlan 12))) OR ((SubPlan 15) AND ((SubPlan 16) OR (SubPlan 17))))
34.          

SubPlan (for Index Scan)

35. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.75..2,602.98 rows=60,847 width=16) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.31..109.36 rows=174 width=16) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.89..64.36 rows=39 width=12) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2.61..2.64 rows=3 width=16) (actual rows= loops=)

  • Group Key: departmentgroupflathierarchy17.childid
39. 0.000 0.000 ↓ 0.0

Index Only Scan using departmentgroupflathierarchy_pkey on departmentgroupflathierarchy departmentgroupflathierarchy17 (cost=0.28..2.60 rows=3 width=16) (actual rows= loops=)

  • Index Cond: (parentid = ANY ('{38c17637-138d-4964-a34f-edcd4d1366f8,5b1a9f95-e64f-414c-9bcc-72e34fbc457a}'::uuid[]))
40. 0.000 0.000 ↓ 0.0

Index Scan using ixudgdepartmentgroupid on userdepartmentgroup userdepartmentgroup16 (cost=0.28..20.34 rows=23 width=28) (actual rows= loops=)

  • Index Cond: (departmentgroupid = departmentgroupflathierarchy17.childid)
41. 0.000 0.000 ↓ 0.0

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

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

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

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

Index Scan using ix3uh_usersuperstart on userhierarchy userhierarchy18 (cost=0.28..2.31 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((userid = timeentryrevision13.userid) AND (supervisorid = 4,521) AND (startdate <= '2020-09-02'::date))
  • Filter: (enddate >= '2020-09-02'::date)
44. 0.000 0.000 ↓ 0.0

Index Scan using ixuhsupervisorid on userhierarchy userhierarchy18_1 (cost=0.28..5.35 rows=3 width=4) (actual rows= loops=)

  • Index Cond: (supervisorid = 4,521)
  • Filter: ((startdate <= '2020-09-02'::date) AND (enddate >= '2020-09-02'::date))
45. 0.000 0.000 ↓ 0.0

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

46. 0.000 0.000 ↓ 0.0

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

47. 0.000 0.000 ↓ 0.0

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

48. 0.000 0.000 ↓ 0.0

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

49. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
50. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = tsapprovalrequest22.nodeid)
51. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = timesheetapprovalnodes21.timesheetid)
  • Filter: ((startdate <= timeentryrevision13.entrydate) AND (enddate >= timeentryrevision13.entrydate) AND (userid = timeentryrevision13.userid))
52. 0.000 0.000 ↓ 0.0

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

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

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

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

Nested Loop (cost=18.43..47.65 rows=1 width=32) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.87..46.80 rows=1 width=16) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.30..44.68 rows=1 width=16) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.74..43.87 rows=1 width=16) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.18..41.82 rows=1 width=16) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.62..38.48 rows=1 width=16) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.05..35.90 rows=1 width=16) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.93..23.74 rows=1 width=16) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

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

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

Bitmap Heap Scan on timesheetapprovalhistory timesheetapprovalhistory26 (cost=3.51..4.53 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetid = timesheet25.id) AND (userid = 4,521))
64. 0.000 0.000 ↓ 0.0

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

65. 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 = timesheet25.id)
66. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
67. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue27 (cost=11.12..12.15 rows=1 width=32) (actual rows= loops=)

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

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

69. 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 = timesheetapprovalhistory26.id)
70. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:4,521'::text)
71. 0.000 0.000 ↓ 0.0

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

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

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue29.id)
74. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue31.id)
76. 0.000 0.000 ↓ 0.0

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

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

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

78. 0.000 0.000 ↓ 0.0

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

79. 0.000 0.000 ↓ 0.0

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

80. 0.000 0.000 ↓ 0.0

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

81. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
82. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = tsapprovalrequest36.nodeid)
83. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = timesheetapprovalnodes35.timesheetid)
  • Filter: ((startdate <= timeentryrevision13.entrydate) AND (enddate >= timeentryrevision13.entrydate) AND (userid = timeentryrevision13.userid))
84. 0.000 0.000 ↓ 0.0

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

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

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

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

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

87. 0.000 0.000 ↓ 0.0

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

88. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.30..44.68 rows=1 width=16) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.74..43.87 rows=1 width=16) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.18..41.82 rows=1 width=16) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.62..38.48 rows=1 width=16) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.05..35.90 rows=1 width=16) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.93..23.74 rows=1 width=16) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

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

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

Bitmap Heap Scan on timesheetapprovalhistory timesheetapprovalhistory40 (cost=3.51..4.53 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetid = timesheet39.id) AND (userid = 4,521))
96. 0.000 0.000 ↓ 0.0

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

97. 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 = timesheet39.id)
98. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
99. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue41 (cost=11.12..12.15 rows=1 width=32) (actual rows= loops=)

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

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

101. 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 = timesheetapprovalhistory40.id)
102. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:4,521'::text)
103. 0.000 0.000 ↓ 0.0

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

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

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue43.id)
106. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue45.id)
108. 0.000 0.000 ↓ 0.0

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

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

Index Scan using ixtemrtimeentryid on timeentrymetadatarevision timeentrymetadatarevision47 (cost=138.47..162.40 rows=1 width=0) (actual rows= loops=)

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

SubPlan (for Index Scan)

111. 0.000 0.000 ↓ 0.0

Index Scan using ixprjprojectleaderapproverid on project project48 (cost=0.42..23.00 rows=21 width=32) (actual rows= loops=)

  • Index Cond: (projectleaderapproverid = 4,521)
112. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..114.74 rows=42 width=32) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Index Scan using ixprjprojectleaderapproverid on project project50 (cost=0.42..22.79 rows=21 width=4) (actual rows= loops=)

  • Index Cond: (projectleaderapproverid = 4,521)
114. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (projectid = project50.id)
115. 0.000 0.000 ↓ 0.0

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

116. 0.000 0.000 ↓ 0.0

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

117. 0.000 0.000 ↓ 0.0

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

118. 0.000 0.000 ↓ 0.0

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

119. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
120. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = tsapprovalrequest54.nodeid)
121. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = timesheetapprovalnodes53.timesheetid)
  • Filter: ((startdate <= timeentryrevision13.entrydate) AND (enddate >= timeentryrevision13.entrydate) AND (userid = timeentryrevision13.userid))
122. 0.000 0.000 ↓ 0.0

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

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

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

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

Nested Loop (cost=18.43..47.65 rows=1 width=32) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.87..46.80 rows=1 width=16) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.30..44.68 rows=1 width=16) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.74..43.87 rows=1 width=16) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.18..41.82 rows=1 width=16) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.62..38.48 rows=1 width=16) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.05..35.90 rows=1 width=16) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.93..23.74 rows=1 width=16) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

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

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

Bitmap Heap Scan on timesheetapprovalhistory timesheetapprovalhistory58 (cost=3.51..4.53 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetid = timesheet57.id) AND (userid = 4,521))
134. 0.000 0.000 ↓ 0.0

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

135. 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 = timesheet57.id)
136. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
137. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue59 (cost=11.12..12.15 rows=1 width=32) (actual rows= loops=)

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

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

139. 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 = timesheetapprovalhistory58.id)
140. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:4,521'::text)
141. 0.000 0.000 ↓ 0.0

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

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

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue61.id)
144. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue63.id)
146. 0.000 0.000 ↓ 0.0

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

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

Index Scan using ixtemrtimeentryid on timeentrymetadatarevision timeentrymetadatarevision65 (cost=94.01..117.94 rows=1 width=0) (actual rows= loops=)

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

SubPlan (for Index Scan)

149. 0.000 0.000 ↓ 0.0

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

150. 0.000 0.000 ↓ 0.0

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

  • Group Key: resentativeprojectassignment67.projectid
151. 0.000 0.000 ↓ 0.0

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

152. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
153. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (clientrepresentativeid = clientrepresentative68.id)
154. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = resentativeprojectassignment67.projectid)
155. 0.000 0.000 ↓ 0.0

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

156. 0.000 0.000 ↓ 0.0

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

157. 0.000 0.000 ↓ 0.0

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

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

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

159. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
160. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (clientrepresentativeid = clientrepresentative68_1.id)
161. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = resentativeprojectassignment67_1.projectid)
162. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (projectid = project70.id)
163. 0.000 0.000 ↓ 0.0

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

164. 0.000 0.000 ↓ 0.0

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

165. 0.000 0.000 ↓ 0.0

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

166. 0.000 0.000 ↓ 0.0

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

167. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
168. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = tsapprovalrequest74.nodeid)
169. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = timesheetapprovalnodes73.timesheetid)
  • Filter: ((startdate <= timeentryrevision13.entrydate) AND (enddate >= timeentryrevision13.entrydate) AND (userid = timeentryrevision13.userid))
170. 0.000 0.000 ↓ 0.0

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

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

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

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

Nested Loop (cost=18.43..47.65 rows=1 width=32) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.87..46.80 rows=1 width=16) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.30..44.68 rows=1 width=16) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.74..43.87 rows=1 width=16) (actual rows= loops=)

176. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.18..41.82 rows=1 width=16) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.62..38.48 rows=1 width=16) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.05..35.90 rows=1 width=16) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.93..23.74 rows=1 width=16) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

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

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

Bitmap Heap Scan on timesheetapprovalhistory timesheetapprovalhistory78 (cost=3.51..4.53 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetid = timesheet77.id) AND (userid = 4,521))
182. 0.000 0.000 ↓ 0.0

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

183. 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 = timesheet77.id)
184. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
185. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue79 (cost=11.12..12.15 rows=1 width=32) (actual rows= loops=)

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

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

187. 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 = timesheetapprovalhistory78.id)
188. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:4,521'::text)
189. 0.000 0.000 ↓ 0.0

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

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

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue81.id)
192. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue83.id)
194. 0.000 0.000 ↓ 0.0

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

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

Nested Loop Left Join (cost=114.65..11,714,352.35 rows=138,666 width=4) (actual rows= loops=)

  • Filter: (((userhierarchy86.supervisorid = 4,521) AND ((userhierarchy86.startdate IS NULL) OR (userhierarchy86.startdate <= '2020-09-02'::date)) AND ((userhierarchy86.enddate IS NULL) OR (userhierarchy86.enddate >= '2020-09-02'::date))) OR (timeoffs85.userid = 4,521) OR (alternatives: SubPlan 19 or hashed SubPlan 20) OR (alternatives: SubPlan 21 or hashed SubPlan 22) OR (hashed SubPlan 23) OR (SubPlan 24) OR (SubPlan 25) OR (SubPlan 26) OR (SubPlan 27))
196. 0.000 0.000 ↓ 0.0

Seq Scan on timeoffs timeoffs85 (cost=0.00..3,904.23 rows=117,023 width=16) (actual rows= loops=)

197. 0.000 0.000 ↓ 0.0

Index Scan using ix3uh_usersuperstart on userhierarchy userhierarchy86 (cost=0.28..0.30 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (userid = timeoffs85.userid)
198.          

SubPlan (for Nested Loop Left Join)

199. 0.000 0.000 ↓ 0.0

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

  • Join Filter: (timeoffapprovalnodes87.id = timeoffapprovalrequest88.nodeid)
200. 0.000 0.000 ↓ 0.0

Index Scan using ixtoantimeoffid on timeoffapprovalnodes timeoffapprovalnodes87 (cost=0.27..2.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (timeoffid = timeoffs85.id)
201. 0.000 0.000 ↓ 0.0

Index Only Scan using uix2toaraidnid on timeoffapprovalrequest timeoffapprovalrequest88 (cost=0.27..2.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (approverid = 4,521)
202. 0.000 0.000 ↓ 0.0

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

203. 0.000 0.000 ↓ 0.0

Index Only Scan using uix2toaraidnid on timeoffapprovalrequest timeoffapprovalrequest88_1 (cost=0.27..2.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (approverid = 4,521)
204. 0.000 0.000 ↓ 0.0

Index Scan using timeoffapprovalnodes_pkey on timeoffapprovalnodes timeoffapprovalnodes87_1 (cost=0.27..2.29 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (id = timeoffapprovalrequest88_1.nodeid)
205. 0.000 0.000 ↓ 0.0

Index Scan using ixtoahtimeoffid on timeoffapprovalhistory timeoffapprovalhistory89 (cost=0.42..2.49 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (timeoffid = timeoffs85.id)
  • Filter: ((userid = 4,521) AND (action = ANY ('{2,3,4}'::integer[])))
206. 0.000 0.000 ↓ 0.0

Index Scan using ixtoahuserid on timeoffapprovalhistory timeoffapprovalhistory89_1 (cost=0.42..85.90 rows=42 width=4) (actual rows= loops=)

  • Index Cond: (userid = 4,521)
  • Filter: (action = ANY ('{2,3,4}'::integer[]))
207. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.31..114.16 rows=85 width=4) (actual rows= loops=)

208. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.89..64.36 rows=39 width=12) (actual rows= loops=)

209. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2.61..2.64 rows=3 width=16) (actual rows= loops=)

  • Group Key: departmentgroupflathierarchy92.childid
210. 0.000 0.000 ↓ 0.0

Index Only Scan using departmentgroupflathierarchy_pkey on departmentgroupflathierarchy departmentgroupflathierarchy92 (cost=0.28..2.60 rows=3 width=16) (actual rows= loops=)

  • Index Cond: (parentid = ANY ('{38c17637-138d-4964-a34f-edcd4d1366f8,5b1a9f95-e64f-414c-9bcc-72e34fbc457a}'::uuid[]))
211. 0.000 0.000 ↓ 0.0

Index Scan using ixudgdepartmentgroupid on userdepartmentgroup userdepartmentgroup91 (cost=0.28..20.34 rows=23 width=28) (actual rows= loops=)

  • Index Cond: (departmentgroupid = departmentgroupflathierarchy92.childid)
212. 0.000 0.000 ↓ 0.0

Index Scan using ixto4userid on timeoffs timeoffs90 (cost=0.42..1.26 rows=2 width=16) (actual rows= loops=)

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

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

214. 0.000 0.000 ↓ 0.0

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

215. 0.000 0.000 ↓ 0.0

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

216. 0.000 0.000 ↓ 0.0

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

217. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
218. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = tsapprovalrequest96.nodeid)
219. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = timesheetapprovalnodes95.timesheetid)
  • Filter: ((timeoffs85.startdate <= enddate) AND (timeoffs85.enddate >= startdate) AND (userid = timeoffs85.userid))
220. 0.000 0.000 ↓ 0.0

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

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

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

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

Nested Loop (cost=18.43..47.65 rows=1 width=32) (actual rows= loops=)

223. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.87..46.80 rows=1 width=16) (actual rows= loops=)

224. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.30..44.68 rows=1 width=16) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.74..43.87 rows=1 width=16) (actual rows= loops=)

226. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.18..41.82 rows=1 width=16) (actual rows= loops=)

227. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.62..38.48 rows=1 width=16) (actual rows= loops=)

228. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.05..35.90 rows=1 width=16) (actual rows= loops=)

229. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.93..23.74 rows=1 width=16) (actual rows= loops=)

230. 0.000 0.000 ↓ 0.0

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

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

Bitmap Heap Scan on timesheetapprovalhistory timesheetapprovalhistory100 (cost=3.51..4.53 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetid = timesheet99.id) AND (userid = 4,521))
232. 0.000 0.000 ↓ 0.0

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

233. 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 = timesheet99.id)
234. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
235. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue101 (cost=11.12..12.15 rows=1 width=32) (actual rows= loops=)

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

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

237. 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 = timesheetapprovalhistory100.id)
238. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:4,521'::text)
239. 0.000 0.000 ↓ 0.0

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

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

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

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

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

  • Index Cond: (parentid = heetapprovalhistorykeyvalue103.id)
242. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (parentid = heetapprovalhistorykeyvalue105.id)
244. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (parentid = heetapprovalhistorykeyvalue106.id)
245. 0.000 0.000 ↓ 0.0

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

246. 0.000 0.000 ↓ 0.0

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

247. 0.000 0.000 ↓ 0.0

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

248. 0.000 0.000 ↓ 0.0

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

249. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
250. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = tsapprovalrequest110.nodeid)
251. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = timesheetapprovalnodes109.timesheetid)
  • Filter: ((timeoffs85.startdate <= enddate) AND (timeoffs85.enddate >= startdate) AND (userid = timeoffs85.userid))
252. 0.000 0.000 ↓ 0.0

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

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

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

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

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

255. 0.000 0.000 ↓ 0.0

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

256. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.30..44.68 rows=1 width=16) (actual rows= loops=)

257. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.74..43.87 rows=1 width=16) (actual rows= loops=)

258. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.18..41.82 rows=1 width=16) (actual rows= loops=)

259. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.62..38.48 rows=1 width=16) (actual rows= loops=)

260. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.05..35.90 rows=1 width=16) (actual rows= loops=)

261. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.93..23.74 rows=1 width=16) (actual rows= loops=)

262. 0.000 0.000 ↓ 0.0

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

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

Bitmap Heap Scan on timesheetapprovalhistory timesheetapprovalhistory114 (cost=3.51..4.53 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetid = timesheet113.id) AND (userid = 4,521))
264. 0.000 0.000 ↓ 0.0

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

265. 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 = timesheet113.id)
266. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 4,521)
267. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue115 (cost=11.12..12.15 rows=1 width=32) (actual rows= loops=)

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

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

269. 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 = timesheetapprovalhistory114.id)
270. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:4,521'::text)
271. 0.000 0.000 ↓ 0.0

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

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

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

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

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

  • Index Cond: (parentid = heetapprovalhistorykeyvalue117.id)
274. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (parentid = heetapprovalhistorykeyvalue119.id)
276. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (parentid = heetapprovalhistorykeyvalue120.id)
277. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=8,934,993,581.32..8,934,998,597.87 rows=18,070 width=48) (actual rows= loops=)

  • Filter: ((hashed SubPlan 18) OR (hashed SubPlan 28))
278. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,367.44..10,022.60 rows=24,093 width=140) (actual rows= loops=)

  • Hash Cond: (toe.timeoffid = toff.id)
279. 0.000 0.000 ↓ 0.0

Index Scan using uix2toe_timeoffidentrydate on timeoffentries toe (cost=0.42..4,592.34 rows=24,093 width=28) (actual rows= loops=)

  • Index Cond: ((entrydate >= '2020-06-21'::date) AND (entrydate <= '2020-09-06'::date))
280. 0.000 0.000 ↓ 0.0

Hash (cost=3,904.23..3,904.23 rows=117,023 width=8) (actual rows= loops=)

281. 0.000 0.000 ↓ 0.0

Seq Scan on timeoffs toff (cost=0.00..3,904.23 rows=117,023 width=8) (actual rows= loops=)

282. 0.000 0.000 ↓ 0.0

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

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

Index Only Scan using project_pkey on project project5 (cost=0.43..0.55 rows=1 width=4) (actual rows= loops=)

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

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

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

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

  • Index Cond: (CASE WHEN ("substring"(timeentrymetadata6.uri, '^urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:task:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata6.uri, '^urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:task:(.*)$'::text))::integer ELSE NULL::integer END = id)
286. 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(project5.id, task7.projectid))
287. 0.000 0.000 ↓ 0.0

Sort (cost=36.21..36.30 rows=34 width=4) (actual rows= loops=)

  • Sort Key: userdepartmentgroup10.userid
288. 0.000 0.000 ↓ 0.0

Index Scan using ixudgdepartmentgroupid on userdepartmentgroup userdepartmentgroup10 (cost=0.28..35.35 rows=34 width=4) (actual rows= loops=)

  • Index Cond: (departmentgroupid = ANY ('{5b1a9f95-e64f-414c-9bcc-72e34fbc457a,38c17637-138d-4964-a34f-edcd4d1366f8}'::uuid[]))
  • Filter: ((startdate <= '2020-09-02'::date) AND (enddate >= '2020-09-02'::date))
289. 0.000 0.000 ↓ 0.0

Materialize (cost=0.42..2.44 rows=1 width=4) (actual rows= loops=)

290. 0.000 0.000 ↓ 0.0

Index Scan using ixprj_code on project project11 (cost=0.42..2.44 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (upper((code)::text) = 'ET207137'::text)
291. 0.000 0.000 ↓ 0.0

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

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

Index Scan using login_pkey on login (cost=0.28..0.30 rows=1 width=11) (actual rows= loops=)

  • Index Cond: (userid = "*SELECT* 1".userid)