explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uDDC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 56,423.585 ↑ 1.0 1 1

Limit (cost=52,307,353.72..52,307,353.76 rows=1 width=0) (actual time=56,423.584..56,423.585 rows=1 loops=1)

  • Output: ($55), ($112), ($169), ($225)
  • Buffers: shared hit=30735772
2.          

Initplan (forLimit)

3. 0.012 27,852.639 ↑ 1.0 1 1

Aggregate (cost=26,052,812.71..26,052,812.72 rows=1 width=0) (actual time=27,852.638..27,852.639 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=15296846
4. 0.025 27,852.627 ↑ 102.9 7 1

Nested Loop Semi Join (cost=100,396.37..26,052,810.91 rows=720 width=0) (actual time=27,519.643..27,852.627 rows=7 loops=1)

  • Join Filter: ("*SELECT* 1_1".timeoffid = timeoffs38.id)
  • Buffers: shared hit=15296846
5. 4.893 27,852.413 ↑ 205.9 7 1

Merge Semi Join (cost=100,392.53..26,047,058.00 rows=1,441 width=8) (actual time=27,519.587..27,852.413 rows=7 loops=1)

  • Output: "*SELECT* 1_1".timeoffid, timeoffs1.id
  • Merge Cond: ("*SELECT* 1_1".timeoffid = timeoffs1.id)
  • Buffers: shared hit=15296768
6. 0.315 108.860 ↑ 7.0 410 1

Sort (cost=74,476.08..74,483.29 rows=2,882 width=4) (actual time=108.715..108.860 rows=410 loops=1)

  • Output: "*SELECT* 1_1".timeoffid
  • Sort Key: "*SELECT* 1_1".timeoffid
  • Sort Method: quicksort Memory: 44kB
  • Buffers: shared hit=70814
7. 0.191 108.545 ↑ 7.0 412 1

Append (cost=150.52..74,310.47 rows=2,882 width=4) (actual time=1.109..108.545 rows=412 loops=1)

  • Buffers: shared hit=70814
8. 0.153 107.264 ↑ 7.5 375 1

Subquery Scan on *SELECT* 1_1 (cost=150.52..73,851.78 rows=2,810 width=4) (actual time=1.108..107.264 rows=375 loops=1)

  • Output: "*SELECT* 1_1".timeoffid
  • Buffers: shared hit=70388
9. 0.384 107.111 ↑ 7.5 375 1

Hash Anti Join (cost=150.52..73,823.68 rows=2,810 width=4) (actual time=1.107..107.111 rows=375 loops=1)

  • Output: dm_timeofflist_facts_1.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Hash Cond: (dm_timeofflist_facts_1.timeoffid = dm_timeofflist_realtime_facts_2.timeoffid)
  • Buffers: shared hit=70388
10. 105.683 105.683 ↑ 6.9 412 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_facts dm_timeofflist_facts_1 (cost=0.00..73,637.58 rows=2,837 width=4) (actual time=0.050..105.683 rows=412 loops=1)

  • Output: dm_timeofflist_facts_1.timeoffid, dm_timeofflist_facts_1.timeoffslug, dm_timeofflist_facts_1.timeoffowneruserid, dm_timeofflist_facts_1.timeoffowneruserdisplayname, dm_timeofflist_facts_1.timeoffowneruserslug, dm_timeofflist_facts_1.timeoffowneruserenabled, dm_timeofflist_facts_1.timeoffownerdepartmentid, dm_timeofflist_facts_1.timeoffownerdepartmentdisplayname, dm_timeofflist_facts_1.timeoffownerdepartmentslug, dm_timeofflist_facts_1.timeoffownersupervisoruserid, dm_timeofflist_facts_1.timeoffownersupervisoruserdisplayname, dm_timeofflist_facts_1.timeoffownersupervisoruserslug, dm_timeofflist_facts_1.timeoffcodeid, dm_timeofflist_facts_1.timeoffcodedisplayname, dm_timeofflist_facts_1.timeoffcodeslug, dm_timeofflist_facts_1.approvalstatus, dm_timeofflist_facts_1.timeoffstatus, dm_timeofflist_facts_1.startdate, dm_timeofflist_facts_1.enddate, dm_timeofflist_facts_1.startdaydurationtype, dm_timeofflist_facts_1.enddaydurationtype, dm_timeofflist_facts_1.startdayduration, dm_timeofflist_facts_1.enddayduration, dm_timeofflist_facts_1.startdaystarttime, dm_timeofflist_facts_1.enddayendtime, dm_timeofflist_facts_1.totalduration, dm_timeofflist_facts_1.effectivehoursperday, dm_timeofflist_facts_1.lastactiondatetimeutc, dm_timeofflist_facts_1.waitingonapproveruserid, dm_timeofflist_facts_1.waitingonapproveruserslug, dm_timeofflist_facts_1.waitingonapproveruserdisplayname, dm_timeofflist_facts_1.generatedonutc, dm_timeofflist_facts_1.timeoffowneruseremployeeid, dm_timeofflist_facts_1.timeoffowneruserloginname, dm_timeofflist_facts_1.totalworkdayduration, dm_timeofflist_facts_1.displayformat
  • Filter: ((dm_timeofflist_facts_1.timeoffcodeid <> 34) AND (dm_timeofflist_facts_1.startdate <= '2019-10-05'::date) AND (dm_timeofflist_facts_1.enddate >= '2019-09-29'::date))
  • Rows Removed by Filter: 188308
  • Buffers: shared hit=70335
11. 0.523 1.044 ↑ 1.0 1,827 1

Hash (cost=127.68..127.68 rows=1,827 width=4) (actual time=1.044..1.044 rows=1,827 loops=1)

  • Output: dm_timeofflist_realtime_facts_2.timeoffid
  • Buckets: 2048 Batches: 1 Memory Usage: 81kB
  • Buffers: shared hit=53
12. 0.521 0.521 ↑ 1.0 1,827 1

Index Only Scan using dm_timeofflist_realtime_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_2 (cost=0.28..127.68 rows=1,827 width=4) (actual time=0.002..0.521 rows=1,827 loops=1)

  • Output: dm_timeofflist_realtime_facts_2.timeoffid
  • Heap Fetches: 55
  • Buffers: shared hit=53
13. 0.024 1.090 ↑ 1.9 37 1

Subquery Scan on *SELECT* 2_1 (cost=0.00..458.69 rows=72 width=4) (actual time=0.031..1.090 rows=37 loops=1)

  • Output: "*SELECT* 2_1".timeoffid
  • Buffers: shared hit=426
14. 1.066 1.066 ↑ 1.9 37 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_3 (cost=0.00..457.97 rows=72 width=4) (actual time=0.031..1.066 rows=37 loops=1)

  • Output: dm_timeofflist_realtime_facts_3.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Filter: ((NOT dm_timeofflist_realtime_facts_3.deleted) AND (dm_timeofflist_realtime_facts_3.timeoffcodeid <> 34) AND (dm_timeofflist_realtime_facts_3.startdate <= '2019-10-05'::date) AND (dm_timeofflist_realtime_facts_3.enddate >= '2019-09-29'::date))
  • Rows Removed by Filter: 1790
  • Buffers: shared hit=426
15. 7.518 27,738.660 ↑ 39.0 13,684 1

Materialize (cost=25,916.45..25,971,153.27 rows=533,126 width=4) (actual time=614.340..27,738.660 rows=13,684 loops=1)

  • Output: timeoffs1.id
  • Buffers: shared hit=15225954
16. 1,699.344 27,731.142 ↑ 39.0 13,684 1

Nested Loop Left Join (cost=25,916.45..25,969,820.46 rows=533,126 width=4) (actual time=614.335..27,731.142 rows=13,684 loops=1)

  • Output: timeoffs1.id
  • Filter: (((userhierarchy2.supervisorid = 2042) AND ((userhierarchy2.startdate IS NULL) OR (userhierarchy2.startdate <= '2019-10-03'::date)) AND ((userhierarchy2.enddate IS NULL) OR (userhierarchy2.enddate >= '2019-10-03'::date))) OR (alternatives: SubPlan 1 or hashed SubPlan 2) OR (alternatives: SubPlan 3 or hashed SubPlan 4) OR (hashed SubPlan 7) OR (SubPlan 8) OR (SubPlan 9) OR (SubPlan 10) OR (SubPlan 11))
  • Rows Removed by Filter: 599163
  • Buffers: shared hit=15225954
17. 194.939 194.939 ↑ 1.0 188,720 1

Index Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs1 (cost=0.42..7,602.22 rows=188,720 width=16) (actual time=0.013..194.939 rows=188,720 loops=1)

  • Output: timeoffs1.id, timeoffs1.guidid, timeoffs1.userid, timeoffs1.createdbyuserid, timeoffs1.timeoffcodeid, timeoffs1.startdate, timeoffs1.enddate, timeoffs1.approvalstatus, timeoffs1.comments, timeoffs1.submittedonutc, timeoffs1.modifiedonutc, timeoffs1.info1, timeoffs1.info2, timeoffs1.info3, timeoffs1.info4, timeoffs1.info5, timeoffs1.startdurationtype, timeoffs1.enddurationtype, timeoffs1.startduration, timeoffs1.endduration, timeoffs1.startdatestarttime, timeoffs1.enddateendtime, timeoffs1.entryconfigurationmethod
  • Buffers: shared hit=125048
18. 754.880 754.880 ↓ 1.5 3 188,720

Index Scan using ix3uh_usersuperstart on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userhierarchy userhierarchy2 (cost=0.29..0.32 rows=2 width=24) (actual time=0.003..0.004 rows=3 loops=188,720)

  • Output: userhierarchy2.id, userhierarchy2.userid, userhierarchy2.supervisorid, userhierarchy2.startdate, userhierarchy2.enddate
  • Index Cond: (userhierarchy2.userid = timeoffs1.userid)
  • Buffers: shared hit=579860
19.          

SubPlan (forNested Loop Left Join)

20. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..4.59 rows=1 width=0) (never executed)

  • Join Filter: (timeoffapprovalnodes3.id = timeoffapprovalrequest4.nodeid)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoantimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes3 (cost=0.27..2.29 rows=1 width=16) (never executed)

  • Output: timeoffapprovalnodes3.id, timeoffapprovalnodes3.timeoffid, timeoffapprovalnodes3.isapproved, timeoffapprovalnodes3.approverrole, timeoffapprovalnodes3.userid, timeoffapprovalnodes3.agentresolutionstate, timeoffapprovalnodes3.scriptid
  • Index Cond: (timeoffapprovalnodes3.timeoffid = timeoffs1.id)
22. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix2toaraidnid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest4 (cost=0.27..2.29 rows=1 width=16) (never executed)

  • Output: timeoffapprovalrequest4.approverid, timeoffapprovalrequest4.nodeid
  • Index Cond: (timeoffapprovalrequest4.approverid = 2042)
  • Heap Fetches: 0
23. 0.000 0.005 ↓ 0.0 0 1

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

  • Output: timeoffapprovalnodes3_1.timeoffid
  • Buffers: shared hit=2
24. 0.005 0.005 ↓ 0.0 0 1

Index Only Scan using uix2toaraidnid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest4_1 (cost=0.27..2.29 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: timeoffapprovalrequest4_1.approverid, timeoffapprovalrequest4_1.nodeid
  • Index Cond: (timeoffapprovalrequest4_1.approverid = 2042)
  • Heap Fetches: 0
  • Buffers: shared hit=2
25. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes3_1 (cost=0.27..2.29 rows=1 width=20) (never executed)

  • Output: timeoffapprovalnodes3_1.id, timeoffapprovalnodes3_1.timeoffid, timeoffapprovalnodes3_1.isapproved, timeoffapprovalnodes3_1.approverrole, timeoffapprovalnodes3_1.userid, timeoffapprovalnodes3_1.agentresolutionstate, timeoffapprovalnodes3_1.scriptid
  • Index Cond: (timeoffapprovalnodes3_1.id = timeoffapprovalrequest4_1.nodeid)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahtimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory5 (cost=0.42..3.11 rows=1 width=0) (never executed)

  • Index Cond: (timeoffapprovalhistory5.timeoffid = timeoffs1.id)
  • Filter: ((timeoffapprovalhistory5.userid = 2042) AND (timeoffapprovalhistory5.action = ANY ('{2,3,4}'::integer[])))
27. 0.068 0.068 ↑ 1.0 16 1

Index Scan using ixtoahuserid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory5_1 (cost=0.42..29.92 rows=16 width=4) (actual time=0.014..0.068 rows=16 loops=1)

  • Output: timeoffapprovalhistory5_1.timeoffid
  • Index Cond: (timeoffapprovalhistory5_1.userid = 2042)
  • Filter: (timeoffapprovalhistory5_1.action = ANY ('{2,3,4}'::integer[]))
  • Rows Removed by Filter: 42
  • Buffers: shared hit=50
28. 243.835 515.131 ↑ 40.4 3,500 1

Merge Left Join (cost=3.65..25,561.89 rows=141,540 width=4) (actual time=111.631..515.131 rows=3,500 loops=1)

  • Output: timeoffs6.id
  • Merge Cond: (timeoffs6.userid = userlocation7.userid)
  • Join Filter: ((userlocation7.startdate <= timeoffs6.enddate) AND (userlocation7.enddate >= timeoffs6.startdate))
  • Rows Removed by Join Filter: 259331
  • Filter: ((hashed SubPlan 5) OR (hashed SubPlan 6))
  • Rows Removed by Filter: 185279
  • Buffers: shared hit=172080
29. 161.572 161.572 ↑ 1.0 188,720 1

Index Scan using ixto4userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs6 (cost=0.42..7,876.22 rows=188,720 width=16) (actual time=0.010..161.572 rows=188,720 loops=1)

  • Output: timeoffs6.id, timeoffs6.guidid, timeoffs6.userid, timeoffs6.createdbyuserid, timeoffs6.timeoffcodeid, timeoffs6.startdate, timeoffs6.enddate, timeoffs6.approvalstatus, timeoffs6.comments, timeoffs6.submittedonutc, timeoffs6.modifiedonutc, timeoffs6.info1, timeoffs6.info2, timeoffs6.info3, timeoffs6.info4, timeoffs6.info5, timeoffs6.startdurationtype, timeoffs6.enddurationtype, timeoffs6.startduration, timeoffs6.endduration, timeoffs6.startdatestarttime, timeoffs6.enddateendtime, timeoffs6.entryconfigurationmethod
  • Buffers: shared hit=171820
30. 102.281 109.713 ↓ 18.4 460,067 1

Materialize (cost=0.41..1,350.82 rows=25,052 width=28) (actual time=0.014..109.713 rows=460,067 loops=1)

  • Output: userlocation7.userid, userlocation7.locationid, userlocation7.startdate, userlocation7.enddate
  • Buffers: shared hit=254
31. 7.432 7.432 ↑ 1.0 25,049 1

Index Only Scan using ix4ul_userlocationstartend on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userlocation userlocation7 (cost=0.41..1,288.19 rows=25,052 width=28) (actual time=0.011..7.432 rows=25,049 loops=1)

  • Output: userlocation7.userid, userlocation7.locationid, userlocation7.startdate, userlocation7.enddate
  • Heap Fetches: 0
  • Buffers: shared hit=254
32.          

SubPlan (forMerge Left Join)

33. 0.008 0.008 ↑ 1.0 1 1

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy8 (cost=0.28..1.29 rows=1 width=16) (actual time=0.007..0.008 rows=1 loops=1)

  • Output: locationflathierarchy8.childid
  • Index Cond: (locationflathierarchy8.parentid = 'a36334cb-1074-45dd-8c37-0a0241f0416b'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
34. 0.003 0.003 ↑ 1.0 1 1

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy9 (cost=0.28..1.29 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1)

  • Output: locationflathierarchy9.childid
  • Index Cond: (locationflathierarchy9.parentid = 'c3b4b88b-163d-4ff3-aff1-2c83b2bcd1a2'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
35. 599.215 1,797.645 ↓ 0.0 0 599,215

Nested Loop (cost=1.53..18.68 rows=1 width=63) (actual time=0.003..0.003 rows=0 loops=599,215)

  • Output: upper(tsapprovalrequestkeyvalue10.uri)
  • Buffers: shared hit=1198430
36. 0.000 1,198.430 ↓ 0.0 0 599,215

Nested Loop (cost=1.25..14.33 rows=8 width=79) (actual time=0.002..0.002 rows=0 loops=599,215)

  • Output: tsapprovalrequestkeyvalue10.uri, tsapprovalrequestkeyvalue10.parentid
  • Buffers: shared hit=1198430
37. 599.215 1,198.430 ↓ 0.0 0 599,215

Nested Loop (cost=0.97..6.24 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=599,215)

  • Output: tsapprovalrequest13.id
  • Buffers: shared hit=1198430
38. 0.000 599.215 ↓ 0.0 0 599,215

Nested Loop (cost=0.55..4.59 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=599,215)

  • Output: timesheetapprovalnodes12.timesheetid, tsapprovalrequest13.id
  • Buffers: shared hit=1198430
39. 599.215 599.215 ↓ 0.0 0 599,215

Index Scan using uix2tsar_nodeid_userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequest tsapprovalrequest13 (cost=0.27..2.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=599,215)

  • Output: tsapprovalrequest13.id, tsapprovalrequest13.effectivedateutc, tsapprovalrequest13.userid, tsapprovalrequest13.nodeid, tsapprovalrequest13.remindersentutc, tsapprovalrequest13.overduesentutc, tsapprovalrequest13.waitingbatchsentutc, tsapprovalrequest13.approvalagenttype, tsapprovalrequest13.systemprocessidentifier
  • Index Cond: (tsapprovalrequest13.userid = 2042)
  • Buffers: shared hit=1198430
40. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalnodes timesheetapprovalnodes12 (cost=0.28..2.29 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes12.id, timesheetapprovalnodes12.isapproved, timesheetapprovalnodes12.approverrole, timesheetapprovalnodes12.userid, timesheetapprovalnodes12.timesheetid, timesheetapprovalnodes12.systemprocessidentifier, timesheetapprovalnodes12.scriptid, timesheetapprovalnodes12.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes12.id = tsapprovalrequest13.nodeid)
41. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet11 (cost=0.42..1.63 rows=1 width=16) (never executed)

  • Output: timesheet11.id, timesheet11.userid, timesheet11.startdate, timesheet11.enddate, timesheet11.approvalstatus, timesheet11.duedate, timesheet11.autosubmitdatetimeutc, timesheet11.lastautosubmitattemptdatetimeutc, timesheet11.createdonutc
  • Index Cond: (timesheet11.id = timesheetapprovalnodes12.timesheetid)
  • Filter: ((timeoffs1.startdate <= timesheet11.enddate) AND (timeoffs1.enddate >= timesheet11.startdate) AND (timesheet11.userid = timeoffs1.userid))
42. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue10 (cost=0.28..8.01 rows=8 width=83) (never executed)

  • Output: tsapprovalrequestkeyvalue10.id, tsapprovalrequestkeyvalue10.tsapprovalrequestid, tsapprovalrequestkeyvalue10.parentid, tsapprovalrequestkeyvalue10.index, tsapprovalrequestkeyvalue10.key, tsapprovalrequestkeyvalue10.uri, tsapprovalrequestkeyvalue10.slug, tsapprovalrequestkeyvalue10."boolean", tsapprovalrequestkeyvalue10.date, tsapprovalrequestkeyvalue10.number, tsapprovalrequestkeyvalue10.text, tsapprovalrequestkeyvalue10."time", tsapprovalrequestkeyvalue10.timespan, tsapprovalrequestkeyvalue10.daterange_startdate, tsapprovalrequestkeyvalue10.daterange_enddate, tsapprovalrequestkeyvalue10.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue10.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue10.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue10.workdayduration_workdays, tsapprovalrequestkeyvalue10.workdayduration_hours, tsapprovalrequestkeyvalue10.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue10.tsapprovalrequestid = tsapprovalrequest13.id)
  • Filter: (upper(tsapprovalrequestkeyvalue10.key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
43. 0.000 0.000 ↓ 0.0 0

Index Scan using tsapprovalrequestkeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue14 (cost=0.28..0.53 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue14.id, tsapprovalrequestkeyvalue14.tsapprovalrequestid, tsapprovalrequestkeyvalue14.parentid, tsapprovalrequestkeyvalue14.index, tsapprovalrequestkeyvalue14.key, tsapprovalrequestkeyvalue14.uri, tsapprovalrequestkeyvalue14.slug, tsapprovalrequestkeyvalue14."boolean", tsapprovalrequestkeyvalue14.date, tsapprovalrequestkeyvalue14.number, tsapprovalrequestkeyvalue14.text, tsapprovalrequestkeyvalue14."time", tsapprovalrequestkeyvalue14.timespan, tsapprovalrequestkeyvalue14.daterange_startdate, tsapprovalrequestkeyvalue14.daterange_enddate, tsapprovalrequestkeyvalue14.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue14.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue14.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue14.workdayduration_workdays, tsapprovalrequestkeyvalue14.workdayduration_hours, tsapprovalrequestkeyvalue14.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue14.id = tsapprovalrequestkeyvalue10.parentid)
  • Filter: (tsapprovalrequestkeyvalue14.parentid IS NULL)
44. 599.059 10,785.870 ↓ 0.0 0 599,215

Nested Loop (cost=11.94..28.19 rows=1 width=69) (actual time=0.018..0.018 rows=0 loops=599,215)

  • Output: upper(sheetapprovalhistorykeyvalue15.uri)
  • Buffers: shared hit=5977241
45. 0.000 10,186.655 ↓ 0.0 0 599,215

Nested Loop (cost=11.51..27.45 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=599,215)

  • Output: sheetapprovalhistorykeyvalue23.id
  • Buffers: shared hit=5977033
46. 598.955 10,186.655 ↓ 0.0 0 599,215

Nested Loop (cost=11.07..25.51 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=599,215)

  • Output: sheetapprovalhistorykeyvalue22.id
  • Buffers: shared hit=5976825
47. 0.000 9,587.440 ↓ 0.0 0 599,215

Nested Loop (cost=10.64..24.81 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=599,215)

  • Output: sheetapprovalhistorykeyvalue21.id
  • Buffers: shared hit=5976617
48. 598.903 9,587.440 ↓ 0.0 0 599,215

Nested Loop (cost=10.21..23.27 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=599,215)

  • Output: sheetapprovalhistorykeyvalue20.id
  • Buffers: shared hit=5976409
49. 0.000 8,988.225 ↓ 0.0 0 599,215

Nested Loop (cost=9.78..21.02 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=599,215)

  • Output: sheetapprovalhistorykeyvalue19.parentid
  • Buffers: shared hit=5976201
50. 595.783 8,988.225 ↓ 0.0 0 599,215

Nested Loop (cost=9.34..18.55 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=599,215)

  • Output: sheetapprovalhistorykeyvalue18.parentid
  • Buffers: shared hit=5975993
51. 698.985 8,389.010 ↓ 0.0 0 599,215

Nested Loop (cost=3.73..11.91 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=599,215)

  • Output: timesheetapprovalhistory17.id
  • Buffers: shared hit=5975491
52. 1,797.645 1,797.645 ↑ 2.0 1 599,215

Index Scan using ixtsuseridstartdateenddate on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet16 (cost=0.42..3.23 rows=2 width=16) (actual time=0.003..0.003 rows=1 loops=599,215)

  • Output: timesheet16.id, timesheet16.userid, timesheet16.startdate, timesheet16.enddate, timesheet16.approvalstatus, timesheet16.duedate, timesheet16.autosubmitdatetimeutc, timesheet16.lastautosubmitattemptdatetimeutc, timesheet16.createdonutc
  • Index Cond: ((timesheet16.userid = timeoffs1.userid) AND (timeoffs1.enddate >= timesheet16.startdate) AND (timeoffs1.startdate <= timesheet16.enddate))
  • Buffers: shared hit=2463575
53. 589.238 5,892.380 ↓ 0.0 0 589,238

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory17 (cost=3.31..4.33 rows=1 width=32) (actual time=0.010..0.010 rows=0 loops=589,238)

  • Output: timesheetapprovalhistory17.id, timesheetapprovalhistory17.action, timesheetapprovalhistory17.approvalcomments, timesheetapprovalhistory17.timestamputc, timesheetapprovalhistory17.serialnumber, timesheetapprovalhistory17.timesheetid, timesheetapprovalhistory17.approvalagenttype, timesheetapprovalhistory17.userid, timesheetapprovalhistory17.systemprocessidentifier
  • Recheck Cond: ((timesheetapprovalhistory17.timesheetid = timesheet16.id) AND (timesheetapprovalhistory17.userid = 2042))
  • Heap Blocks: exact=52
  • Buffers: shared hit=3511916
54. 656.933 5,303.142 ↓ 0.0 0 589,238

BitmapAnd (cost=3.31..3.31 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=589,238)

  • Buffers: shared hit=3511864
55. 1,767.714 1,767.714 ↑ 1.0 4 589,238

Bitmap Index Scan on ixtah2timesheetid (cost=0.00..1.45 rows=4 width=0) (actual time=0.003..0.003 rows=4 loops=589,238)

  • Index Cond: (timesheetapprovalhistory17.timesheetid = timesheet16.id)
  • Buffers: shared hit=1784767
56. 2,878.495 2,878.495 ↓ 2.4 57 575,699

Bitmap Index Scan on ixtahuserid (cost=0.00..1.60 rows=24 width=0) (actual time=0.005..0.005 rows=57 loops=575,699)

  • Index Cond: (timesheetapprovalhistory17.userid = 2042)
  • Buffers: shared hit=1727097
57. 0.572 3.432 ↑ 1.0 1 52

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue18 (cost=5.62..6.64 rows=1 width=32) (actual time=0.066..0.066 rows=1 loops=52)

  • Output: sheetapprovalhistorykeyvalue18.id, sheetapprovalhistorykeyvalue18.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue18.parentid, sheetapprovalhistorykeyvalue18.index, sheetapprovalhistorykeyvalue18.key, sheetapprovalhistorykeyvalue18.uri, sheetapprovalhistorykeyvalue18.slug, sheetapprovalhistorykeyvalue18."boolean", sheetapprovalhistorykeyvalue18.date, sheetapprovalhistorykeyvalue18.number, sheetapprovalhistorykeyvalue18.text, sheetapprovalhistorykeyvalue18."time", sheetapprovalhistorykeyvalue18.timespan, sheetapprovalhistorykeyvalue18.daterange_startdate, sheetapprovalhistorykeyvalue18.daterange_enddate, sheetapprovalhistorykeyvalue18.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue18.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue18.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue18.workdayduration_workdays, sheetapprovalhistorykeyvalue18.workdayduration_hours, sheetapprovalhistorykeyvalue18.workdayduration_minutes
  • Recheck Cond: ((sheetapprovalhistorykeyvalue18.timesheetapprovalhistoryid = timesheetapprovalhistory17.id) AND (upper(sheetapprovalhistorykeyvalue18.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text))
  • Filter: (upper(sheetapprovalhistorykeyvalue18.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=82
  • Buffers: shared hit=502
58. 0.052 2.860 ↓ 0.0 0 52

BitmapAnd (cost=5.62..5.62 rows=1 width=0) (actual time=0.055..0.055 rows=0 loops=52)

  • Buffers: shared hit=420
59. 0.364 0.364 ↓ 1.5 37 52

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..1.62 rows=25 width=0) (actual time=0.007..0.007 rows=37 loops=52)

  • Index Cond: (sheetapprovalhistorykeyvalue18.timesheetapprovalhistoryid = timesheetapprovalhistory17.id)
  • Buffers: shared hit=160
60. 2.444 2.444 ↓ 1.0 156 52

Bitmap Index Scan on ixtahkvuri (cost=0.00..3.72 rows=155 width=0) (actual time=0.047..0.047 rows=156 loops=52)

  • Index Cond: (upper(sheetapprovalhistorykeyvalue18.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text)
  • Buffers: shared hit=260
61. 0.312 0.312 ↑ 1.0 1 52

Index Scan using timesheetapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue19 (cost=0.43..2.46 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=52)

  • Output: sheetapprovalhistorykeyvalue19.id, sheetapprovalhistorykeyvalue19.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue19.parentid, sheetapprovalhistorykeyvalue19.index, sheetapprovalhistorykeyvalue19.key, sheetapprovalhistorykeyvalue19.uri, sheetapprovalhistorykeyvalue19.slug, sheetapprovalhistorykeyvalue19."boolean", sheetapprovalhistorykeyvalue19.date, sheetapprovalhistorykeyvalue19.number, sheetapprovalhistorykeyvalue19.text, sheetapprovalhistorykeyvalue19."time", sheetapprovalhistorykeyvalue19.timespan, sheetapprovalhistorykeyvalue19.daterange_startdate, sheetapprovalhistorykeyvalue19.daterange_enddate, sheetapprovalhistorykeyvalue19.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue19.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue19.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue19.workdayduration_workdays, sheetapprovalhistorykeyvalue19.workdayduration_hours, sheetapprovalhistorykeyvalue19.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue19.id = sheetapprovalhistorykeyvalue18.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue19.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
  • Buffers: shared hit=208
62. 0.312 0.312 ↑ 1.0 1 52

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue20 (cost=0.43..2.24 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=52)

  • Output: sheetapprovalhistorykeyvalue20.id, sheetapprovalhistorykeyvalue20.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue20.parentid, sheetapprovalhistorykeyvalue20.index, sheetapprovalhistorykeyvalue20.key, sheetapprovalhistorykeyvalue20.uri, sheetapprovalhistorykeyvalue20.slug, sheetapprovalhistorykeyvalue20."boolean", sheetapprovalhistorykeyvalue20.date, sheetapprovalhistorykeyvalue20.number, sheetapprovalhistorykeyvalue20.text, sheetapprovalhistorykeyvalue20."time", sheetapprovalhistorykeyvalue20.timespan, sheetapprovalhistorykeyvalue20.daterange_startdate, sheetapprovalhistorykeyvalue20.daterange_enddate, sheetapprovalhistorykeyvalue20.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue20.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue20.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue20.workdayduration_workdays, sheetapprovalhistorykeyvalue20.workdayduration_hours, sheetapprovalhistorykeyvalue20.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue20.parentid = sheetapprovalhistorykeyvalue19.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue20.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
  • Buffers: shared hit=208
63. 0.156 0.156 ↑ 10.0 1 52

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue21 (cost=0.43..1.45 rows=10 width=32) (actual time=0.003..0.003 rows=1 loops=52)

  • Output: sheetapprovalhistorykeyvalue21.id, sheetapprovalhistorykeyvalue21.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue21.parentid, sheetapprovalhistorykeyvalue21.index, sheetapprovalhistorykeyvalue21.key, sheetapprovalhistorykeyvalue21.uri, sheetapprovalhistorykeyvalue21.slug, sheetapprovalhistorykeyvalue21."boolean", sheetapprovalhistorykeyvalue21.date, sheetapprovalhistorykeyvalue21.number, sheetapprovalhistorykeyvalue21.text, sheetapprovalhistorykeyvalue21."time", sheetapprovalhistorykeyvalue21.timespan, sheetapprovalhistorykeyvalue21.daterange_startdate, sheetapprovalhistorykeyvalue21.daterange_enddate, sheetapprovalhistorykeyvalue21.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue21.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue21.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue21.workdayduration_workdays, sheetapprovalhistorykeyvalue21.workdayduration_hours, sheetapprovalhistorykeyvalue21.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue21.parentid = sheetapprovalhistorykeyvalue20.id)
  • Buffers: shared hit=208
64. 0.260 0.260 ↑ 1.0 1 52

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue22 (cost=0.43..0.69 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=52)

  • Output: sheetapprovalhistorykeyvalue22.id, sheetapprovalhistorykeyvalue22.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue22.parentid, sheetapprovalhistorykeyvalue22.index, sheetapprovalhistorykeyvalue22.key, sheetapprovalhistorykeyvalue22.uri, sheetapprovalhistorykeyvalue22.slug, sheetapprovalhistorykeyvalue22."boolean", sheetapprovalhistorykeyvalue22.date, sheetapprovalhistorykeyvalue22.number, sheetapprovalhistorykeyvalue22.text, sheetapprovalhistorykeyvalue22."time", sheetapprovalhistorykeyvalue22.timespan, sheetapprovalhistorykeyvalue22.daterange_startdate, sheetapprovalhistorykeyvalue22.daterange_enddate, sheetapprovalhistorykeyvalue22.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue22.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue22.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue22.workdayduration_workdays, sheetapprovalhistorykeyvalue22.workdayduration_hours, sheetapprovalhistorykeyvalue22.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue22.parentid = sheetapprovalhistorykeyvalue21.id)
  • Filter: (upper(sheetapprovalhistorykeyvalue22.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
  • Buffers: shared hit=208
65. 0.156 0.156 ↑ 10.0 1 52

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue23 (cost=0.43..1.84 rows=10 width=32) (actual time=0.003..0.003 rows=1 loops=52)

  • Output: sheetapprovalhistorykeyvalue23.id, sheetapprovalhistorykeyvalue23.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue23.parentid, sheetapprovalhistorykeyvalue23.index, sheetapprovalhistorykeyvalue23.key, sheetapprovalhistorykeyvalue23.uri, sheetapprovalhistorykeyvalue23.slug, sheetapprovalhistorykeyvalue23."boolean", sheetapprovalhistorykeyvalue23.date, sheetapprovalhistorykeyvalue23.number, sheetapprovalhistorykeyvalue23.text, sheetapprovalhistorykeyvalue23."time", sheetapprovalhistorykeyvalue23.timespan, sheetapprovalhistorykeyvalue23.daterange_startdate, sheetapprovalhistorykeyvalue23.daterange_enddate, sheetapprovalhistorykeyvalue23.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue23.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue23.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue23.workdayduration_workdays, sheetapprovalhistorykeyvalue23.workdayduration_hours, sheetapprovalhistorykeyvalue23.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue23.parentid = sheetapprovalhistorykeyvalue22.id)
  • Buffers: shared hit=208
66. 0.156 0.156 ↑ 10.0 1 52

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue15 (cost=0.43..0.64 rows=10 width=85) (actual time=0.003..0.003 rows=1 loops=52)

  • Output: sheetapprovalhistorykeyvalue15.id, sheetapprovalhistorykeyvalue15.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue15.parentid, sheetapprovalhistorykeyvalue15.index, sheetapprovalhistorykeyvalue15.key, sheetapprovalhistorykeyvalue15.uri, sheetapprovalhistorykeyvalue15.slug, sheetapprovalhistorykeyvalue15."boolean", sheetapprovalhistorykeyvalue15.date, sheetapprovalhistorykeyvalue15.number, sheetapprovalhistorykeyvalue15.text, sheetapprovalhistorykeyvalue15."time", sheetapprovalhistorykeyvalue15.timespan, sheetapprovalhistorykeyvalue15.daterange_startdate, sheetapprovalhistorykeyvalue15.daterange_enddate, sheetapprovalhistorykeyvalue15.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue15.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue15.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue15.workdayduration_workdays, sheetapprovalhistorykeyvalue15.workdayduration_hours, sheetapprovalhistorykeyvalue15.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue15.parentid = sheetapprovalhistorykeyvalue23.id)
  • Buffers: shared hit=208
67. 599.163 1,797.489 ↓ 0.0 0 599,163

Nested Loop (cost=1.53..9.86 rows=1 width=63) (actual time=0.003..0.003 rows=0 loops=599,163)

  • Output: upper(tsapprovalrequestkeyvalue24.uri)
  • Buffers: shared hit=1198326
68. 0.000 1,198.326 ↓ 0.0 0 599,163

Nested Loop (cost=1.25..7.55 rows=1 width=79) (actual time=0.002..0.002 rows=0 loops=599,163)

  • Output: tsapprovalrequestkeyvalue24.uri, tsapprovalrequestkeyvalue24.parentid
  • Join Filter: (tsapprovalrequest27.id = tsapprovalrequestkeyvalue24.tsapprovalrequestid)
  • Buffers: shared hit=1198326
69. 599.163 1,198.326 ↓ 0.0 0 599,163

Nested Loop (cost=0.97..6.24 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=599,163)

  • Output: tsapprovalrequest27.id
  • Buffers: shared hit=1198326
70. 0.000 599.163 ↓ 0.0 0 599,163

Nested Loop (cost=0.55..4.59 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=599,163)

  • Output: timesheetapprovalnodes26.timesheetid, tsapprovalrequest27.id
  • Buffers: shared hit=1198326
71. 599.163 599.163 ↓ 0.0 0 599,163

Index Scan using uix2tsar_nodeid_userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequest tsapprovalrequest27 (cost=0.27..2.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=599,163)

  • Output: tsapprovalrequest27.id, tsapprovalrequest27.effectivedateutc, tsapprovalrequest27.userid, tsapprovalrequest27.nodeid, tsapprovalrequest27.remindersentutc, tsapprovalrequest27.overduesentutc, tsapprovalrequest27.waitingbatchsentutc, tsapprovalrequest27.approvalagenttype, tsapprovalrequest27.systemprocessidentifier
  • Index Cond: (tsapprovalrequest27.userid = 2042)
  • Buffers: shared hit=1198326
72. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalnodes timesheetapprovalnodes26 (cost=0.28..2.29 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes26.id, timesheetapprovalnodes26.isapproved, timesheetapprovalnodes26.approverrole, timesheetapprovalnodes26.userid, timesheetapprovalnodes26.timesheetid, timesheetapprovalnodes26.systemprocessidentifier, timesheetapprovalnodes26.scriptid, timesheetapprovalnodes26.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes26.id = tsapprovalrequest27.nodeid)
73. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet25 (cost=0.42..1.63 rows=1 width=16) (never executed)

  • Output: timesheet25.id, timesheet25.userid, timesheet25.startdate, timesheet25.enddate, timesheet25.approvalstatus, timesheet25.duedate, timesheet25.autosubmitdatetimeutc, timesheet25.lastautosubmitattemptdatetimeutc, timesheet25.createdonutc
  • Index Cond: (timesheet25.id = timesheetapprovalnodes26.timesheetid)
  • Filter: ((timeoffs1.startdate <= timesheet25.enddate) AND (timeoffs1.enddate >= timesheet25.startdate) AND (timesheet25.userid = timeoffs1.userid))
74. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue24 (cost=0.28..1.30 rows=1 width=83) (never executed)

  • Output: tsapprovalrequestkeyvalue24.id, tsapprovalrequestkeyvalue24.tsapprovalrequestid, tsapprovalrequestkeyvalue24.parentid, tsapprovalrequestkeyvalue24.index, tsapprovalrequestkeyvalue24.key, tsapprovalrequestkeyvalue24.uri, tsapprovalrequestkeyvalue24.slug, tsapprovalrequestkeyvalue24."boolean", tsapprovalrequestkeyvalue24.date, tsapprovalrequestkeyvalue24.number, tsapprovalrequestkeyvalue24.text, tsapprovalrequestkeyvalue24."time", tsapprovalrequestkeyvalue24.timespan, tsapprovalrequestkeyvalue24.daterange_startdate, tsapprovalrequestkeyvalue24.daterange_enddate, tsapprovalrequestkeyvalue24.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue24.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue24.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue24.workdayduration_workdays, tsapprovalrequestkeyvalue24.workdayduration_hours, tsapprovalrequestkeyvalue24.workdayduration_minutes
  • Index Cond: (upper(tsapprovalrequestkeyvalue24.key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
75. 0.000 0.000 ↓ 0.0 0

Index Scan using tsapprovalrequestkeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue28 (cost=0.28..2.30 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue28.id, tsapprovalrequestkeyvalue28.tsapprovalrequestid, tsapprovalrequestkeyvalue28.parentid, tsapprovalrequestkeyvalue28.index, tsapprovalrequestkeyvalue28.key, tsapprovalrequestkeyvalue28.uri, tsapprovalrequestkeyvalue28.slug, tsapprovalrequestkeyvalue28."boolean", tsapprovalrequestkeyvalue28.date, tsapprovalrequestkeyvalue28.number, tsapprovalrequestkeyvalue28.text, tsapprovalrequestkeyvalue28."time", tsapprovalrequestkeyvalue28.timespan, tsapprovalrequestkeyvalue28.daterange_startdate, tsapprovalrequestkeyvalue28.daterange_enddate, tsapprovalrequestkeyvalue28.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue28.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue28.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue28.workdayduration_workdays, tsapprovalrequestkeyvalue28.workdayduration_hours, tsapprovalrequestkeyvalue28.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue28.id = tsapprovalrequestkeyvalue24.parentid)
  • Filter: (tsapprovalrequestkeyvalue28.parentid IS NULL)
76. 0.000 10,185.771 ↓ 0.0 0 599,163

Nested Loop (cost=11.94..37.92 rows=1 width=69) (actual time=0.017..0.017 rows=0 loops=599,163)

  • Output: upper(sheetapprovalhistorykeyvalue29.uri)
  • Buffers: shared hit=5974917
77. 599.163 10,185.771 ↓ 0.0 0 599,163

Nested Loop (cost=11.51..37.18 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=599,163)

  • Output: sheetapprovalhistorykeyvalue37.id
  • Buffers: shared hit=5974917
78. 599.163 9,586.608 ↓ 0.0 0 599,163

Nested Loop (cost=11.07..25.51 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=599,163)

  • Output: sheetapprovalhistorykeyvalue36.id
  • Buffers: shared hit=5974917
79. 0.000 8,987.445 ↓ 0.0 0 599,163

Nested Loop (cost=10.64..24.81 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=599,163)

  • Output: sheetapprovalhistorykeyvalue35.id
  • Buffers: shared hit=5974917
80. 599.163 8,987.445 ↓ 0.0 0 599,163

Nested Loop (cost=10.21..23.27 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=599,163)

  • Output: sheetapprovalhistorykeyvalue34.id
  • Buffers: shared hit=5974917
81. 0.000 8,388.282 ↓ 0.0 0 599,163

Nested Loop (cost=9.78..21.02 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=599,163)

  • Output: sheetapprovalhistorykeyvalue33.parentid
  • Buffers: shared hit=5974917
82. 599.163 8,388.282 ↓ 0.0 0 599,163

Nested Loop (cost=9.34..18.55 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=599,163)

  • Output: sheetapprovalhistorykeyvalue32.parentid
  • Buffers: shared hit=5974917
83. 688.956 7,789.119 ↓ 0.0 0 599,163

Nested Loop (cost=3.73..11.91 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=599,163)

  • Output: timesheetapprovalhistory31.id
  • Buffers: shared hit=5974917
84. 1,797.489 1,797.489 ↑ 2.0 1 599,163

Index Scan using ixtsuseridstartdateenddate on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet30 (cost=0.42..3.23 rows=2 width=16) (actual time=0.002..0.003 rows=1 loops=599,163)

  • Output: timesheet30.id, timesheet30.userid, timesheet30.startdate, timesheet30.enddate, timesheet30.approvalstatus, timesheet30.duedate, timesheet30.autosubmitdatetimeutc, timesheet30.lastautosubmitattemptdatetimeutc, timesheet30.createdonutc
  • Index Cond: ((timesheet30.userid = timeoffs1.userid) AND (timeoffs1.enddate >= timesheet30.startdate) AND (timeoffs1.startdate <= timesheet30.enddate))
  • Buffers: shared hit=2463367
85. 589.186 5,302.674 ↓ 0.0 0 589,186

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory31 (cost=3.31..4.33 rows=1 width=32) (actual time=0.009..0.009 rows=0 loops=589,186)

  • Output: timesheetapprovalhistory31.id, timesheetapprovalhistory31.action, timesheetapprovalhistory31.approvalcomments, timesheetapprovalhistory31.timestamputc, timesheetapprovalhistory31.serialnumber, timesheetapprovalhistory31.timesheetid, timesheetapprovalhistory31.approvalagenttype, timesheetapprovalhistory31.userid, timesheetapprovalhistory31.systemprocessidentifier
  • Recheck Cond: ((timesheetapprovalhistory31.timesheetid = timesheet30.id) AND (timesheetapprovalhistory31.userid = 2042))
  • Buffers: shared hit=3511550
86. 656.881 4,713.488 ↓ 0.0 0 589,186

BitmapAnd (cost=3.31..3.31 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=589,186)

  • Buffers: shared hit=3511550
87. 1,178.372 1,178.372 ↑ 1.0 4 589,186

Bitmap Index Scan on ixtah2timesheetid (cost=0.00..1.45 rows=4 width=0) (actual time=0.002..0.002 rows=4 loops=589,186)

  • Index Cond: (timesheetapprovalhistory31.timesheetid = timesheet30.id)
  • Buffers: shared hit=1784609
88. 2,878.235 2,878.235 ↓ 2.4 57 575,647

Bitmap Index Scan on ixtahuserid (cost=0.00..1.60 rows=24 width=0) (actual time=0.005..0.005 rows=57 loops=575,647)

  • Index Cond: (timesheetapprovalhistory31.userid = 2042)
  • Buffers: shared hit=1726941
89. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue32 (cost=5.62..6.64 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue32.id, sheetapprovalhistorykeyvalue32.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue32.parentid, sheetapprovalhistorykeyvalue32.index, sheetapprovalhistorykeyvalue32.key, sheetapprovalhistorykeyvalue32.uri, sheetapprovalhistorykeyvalue32.slug, sheetapprovalhistorykeyvalue32."boolean", sheetapprovalhistorykeyvalue32.date, sheetapprovalhistorykeyvalue32.number, sheetapprovalhistorykeyvalue32.text, sheetapprovalhistorykeyvalue32."time", sheetapprovalhistorykeyvalue32.timespan, sheetapprovalhistorykeyvalue32.daterange_startdate, sheetapprovalhistorykeyvalue32.daterange_enddate, sheetapprovalhistorykeyvalue32.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue32.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue32.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue32.workdayduration_workdays, sheetapprovalhistorykeyvalue32.workdayduration_hours, sheetapprovalhistorykeyvalue32.workdayduration_minutes
  • Recheck Cond: ((sheetapprovalhistorykeyvalue32.timesheetapprovalhistoryid = timesheetapprovalhistory31.id) AND (upper(sheetapprovalhistorykeyvalue32.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text))
  • Filter: (upper(sheetapprovalhistorykeyvalue32.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
90. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=5.62..5.62 rows=1 width=0) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..1.62 rows=25 width=0) (never executed)

  • Index Cond: (sheetapprovalhistorykeyvalue32.timesheetapprovalhistoryid = timesheetapprovalhistory31.id)
92. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahkvuri (cost=0.00..3.72 rows=155 width=0) (never executed)

  • Index Cond: (upper(sheetapprovalhistorykeyvalue32.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text)
93. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue33 (cost=0.43..2.46 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue33.id, sheetapprovalhistorykeyvalue33.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue33.parentid, sheetapprovalhistorykeyvalue33.index, sheetapprovalhistorykeyvalue33.key, sheetapprovalhistorykeyvalue33.uri, sheetapprovalhistorykeyvalue33.slug, sheetapprovalhistorykeyvalue33."boolean", sheetapprovalhistorykeyvalue33.date, sheetapprovalhistorykeyvalue33.number, sheetapprovalhistorykeyvalue33.text, sheetapprovalhistorykeyvalue33."time", sheetapprovalhistorykeyvalue33.timespan, sheetapprovalhistorykeyvalue33.daterange_startdate, sheetapprovalhistorykeyvalue33.daterange_enddate, sheetapprovalhistorykeyvalue33.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue33.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue33.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue33.workdayduration_workdays, sheetapprovalhistorykeyvalue33.workdayduration_hours, sheetapprovalhistorykeyvalue33.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue33.id = sheetapprovalhistorykeyvalue32.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue33.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
94. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue34 (cost=0.43..2.24 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue34.id, sheetapprovalhistorykeyvalue34.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue34.parentid, sheetapprovalhistorykeyvalue34.index, sheetapprovalhistorykeyvalue34.key, sheetapprovalhistorykeyvalue34.uri, sheetapprovalhistorykeyvalue34.slug, sheetapprovalhistorykeyvalue34."boolean", sheetapprovalhistorykeyvalue34.date, sheetapprovalhistorykeyvalue34.number, sheetapprovalhistorykeyvalue34.text, sheetapprovalhistorykeyvalue34."time", sheetapprovalhistorykeyvalue34.timespan, sheetapprovalhistorykeyvalue34.daterange_startdate, sheetapprovalhistorykeyvalue34.daterange_enddate, sheetapprovalhistorykeyvalue34.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue34.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue34.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue34.workdayduration_workdays, sheetapprovalhistorykeyvalue34.workdayduration_hours, sheetapprovalhistorykeyvalue34.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue34.parentid = sheetapprovalhistorykeyvalue33.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue34.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
95. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue35 (cost=0.43..1.45 rows=10 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue35.id, sheetapprovalhistorykeyvalue35.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue35.parentid, sheetapprovalhistorykeyvalue35.index, sheetapprovalhistorykeyvalue35.key, sheetapprovalhistorykeyvalue35.uri, sheetapprovalhistorykeyvalue35.slug, sheetapprovalhistorykeyvalue35."boolean", sheetapprovalhistorykeyvalue35.date, sheetapprovalhistorykeyvalue35.number, sheetapprovalhistorykeyvalue35.text, sheetapprovalhistorykeyvalue35."time", sheetapprovalhistorykeyvalue35.timespan, sheetapprovalhistorykeyvalue35.daterange_startdate, sheetapprovalhistorykeyvalue35.daterange_enddate, sheetapprovalhistorykeyvalue35.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue35.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue35.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue35.workdayduration_workdays, sheetapprovalhistorykeyvalue35.workdayduration_hours, sheetapprovalhistorykeyvalue35.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue35.parentid = sheetapprovalhistorykeyvalue34.id)
96. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue36 (cost=0.43..0.69 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue36.id, sheetapprovalhistorykeyvalue36.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue36.parentid, sheetapprovalhistorykeyvalue36.index, sheetapprovalhistorykeyvalue36.key, sheetapprovalhistorykeyvalue36.uri, sheetapprovalhistorykeyvalue36.slug, sheetapprovalhistorykeyvalue36."boolean", sheetapprovalhistorykeyvalue36.date, sheetapprovalhistorykeyvalue36.number, sheetapprovalhistorykeyvalue36.text, sheetapprovalhistorykeyvalue36."time", sheetapprovalhistorykeyvalue36.timespan, sheetapprovalhistorykeyvalue36.daterange_startdate, sheetapprovalhistorykeyvalue36.daterange_enddate, sheetapprovalhistorykeyvalue36.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue36.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue36.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue36.workdayduration_workdays, sheetapprovalhistorykeyvalue36.workdayduration_hours, sheetapprovalhistorykeyvalue36.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue36.parentid = sheetapprovalhistorykeyvalue35.id)
  • Filter: (upper(sheetapprovalhistorykeyvalue36.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
97. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue37 (cost=0.43..11.57 rows=10 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue37.id, sheetapprovalhistorykeyvalue37.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue37.parentid, sheetapprovalhistorykeyvalue37.index, sheetapprovalhistorykeyvalue37.key, sheetapprovalhistorykeyvalue37.uri, sheetapprovalhistorykeyvalue37.slug, sheetapprovalhistorykeyvalue37."boolean", sheetapprovalhistorykeyvalue37.date, sheetapprovalhistorykeyvalue37.number, sheetapprovalhistorykeyvalue37.text, sheetapprovalhistorykeyvalue37."time", sheetapprovalhistorykeyvalue37.timespan, sheetapprovalhistorykeyvalue37.daterange_startdate, sheetapprovalhistorykeyvalue37.daterange_enddate, sheetapprovalhistorykeyvalue37.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue37.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue37.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue37.workdayduration_workdays, sheetapprovalhistorykeyvalue37.workdayduration_hours, sheetapprovalhistorykeyvalue37.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue37.parentid = sheetapprovalhistorykeyvalue36.id)
98. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue29 (cost=0.43..0.64 rows=10 width=85) (never executed)

  • Output: sheetapprovalhistorykeyvalue29.id, sheetapprovalhistorykeyvalue29.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue29.parentid, sheetapprovalhistorykeyvalue29.index, sheetapprovalhistorykeyvalue29.key, sheetapprovalhistorykeyvalue29.uri, sheetapprovalhistorykeyvalue29.slug, sheetapprovalhistorykeyvalue29."boolean", sheetapprovalhistorykeyvalue29.date, sheetapprovalhistorykeyvalue29.number, sheetapprovalhistorykeyvalue29.text, sheetapprovalhistorykeyvalue29."time", sheetapprovalhistorykeyvalue29.timespan, sheetapprovalhistorykeyvalue29.daterange_startdate, sheetapprovalhistorykeyvalue29.daterange_enddate, sheetapprovalhistorykeyvalue29.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue29.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue29.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue29.workdayduration_workdays, sheetapprovalhistorykeyvalue29.workdayduration_hours, sheetapprovalhistorykeyvalue29.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue29.parentid = sheetapprovalhistorykeyvalue37.id)
99. 0.028 0.189 ↑ 1.0 1 7

Nested Loop Semi Join (cost=3.84..4.00 rows=1 width=8) (actual time=0.027..0.027 rows=1 loops=7)

  • Output: timeoffs38.id, timeoffs39.id
  • Buffers: shared hit=78
100. 0.035 0.035 ↑ 1.0 1 7

Index Only Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs38 (cost=0.42..0.44 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=7)

  • Output: timeoffs38.id
  • Index Cond: (timeoffs38.id = timeoffs1.id)
  • Heap Fetches: 0
  • Buffers: shared hit=22
101. 0.056 0.126 ↑ 1.0 1 7

Nested Loop Left Join (cost=3.42..3.55 rows=1 width=4) (actual time=0.018..0.018 rows=1 loops=7)

  • Output: timeoffs39.id
  • Filter: ((hashed SubPlan 12) OR (hashed SubPlan 13))
  • Buffers: shared hit=56
102. 0.014 0.014 ↑ 1.0 1 7

Index Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs39 (cost=0.42..0.46 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=7)

  • Output: timeoffs39.id, timeoffs39.guidid, timeoffs39.userid, timeoffs39.createdbyuserid, timeoffs39.timeoffcodeid, timeoffs39.startdate, timeoffs39.enddate, timeoffs39.approvalstatus, timeoffs39.comments, timeoffs39.submittedonutc, timeoffs39.modifiedonutc, timeoffs39.info1, timeoffs39.info2, timeoffs39.info3, timeoffs39.info4, timeoffs39.info5, timeoffs39.startdurationtype, timeoffs39.enddurationtype, timeoffs39.startduration, timeoffs39.endduration, timeoffs39.startdatestarttime, timeoffs39.enddateendtime, timeoffs39.entryconfigurationmethod
  • Index Cond: (timeoffs39.id = timeoffs38.id)
  • Buffers: shared hit=28
103. 0.042 0.042 ↑ 1.0 1 7

Index Only Scan using ix4ul_userlocationstartend on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userlocation userlocation40 (cost=0.41..0.48 rows=1 width=28) (actual time=0.006..0.006 rows=1 loops=7)

  • Output: userlocation40.userid, userlocation40.locationid, userlocation40.startdate, userlocation40.enddate
  • Index Cond: ((userlocation40.userid = timeoffs39.userid) AND (userlocation40.startdate <= timeoffs39.enddate) AND (userlocation40.enddate >= timeoffs39.startdate))
  • Heap Fetches: 0
  • Buffers: shared hit=22
104.          

SubPlan (forNested Loop Left Join)

105. 0.007 0.007 ↑ 1.0 1 1

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy41 (cost=0.28..1.29 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=1)

  • Output: locationflathierarchy41.childid
  • Index Cond: (locationflathierarchy41.parentid = 'a36334cb-1074-45dd-8c37-0a0241f0416b'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
106. 0.007 0.007 ↑ 1.0 1 1

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy42 (cost=0.28..1.29 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=1)

  • Output: locationflathierarchy42.childid
  • Index Cond: (locationflathierarchy42.parentid = 'c3b4b88b-163d-4ff3-aff1-2c83b2bcd1a2'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
107. 0.003 106.058 ↑ 1.0 1 1

Aggregate (cost=100,645.38..100,645.39 rows=1 width=0) (actual time=106.057..106.058 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=70793
108. 0.002 106.055 ↓ 0.0 0 1

Nested Loop Semi Join (cost=25,920.57..100,645.37 rows=1 width=0) (actual time=106.055..106.055 rows=0 loops=1)

  • Join Filter: ("*SELECT* 1_2".timeoffid = timeoffs44.id)
  • Buffers: shared hit=70793
109. 0.003 106.053 ↓ 0.0 0 1

Nested Loop Semi Join (cost=4.12..74,591.72 rows=1 width=12) (actual time=106.053..106.053 rows=0 loops=1)

  • Output: "*SELECT* 1_2".timeoffid, timeoffs81.id, timeoffs82.id
  • Buffers: shared hit=70793
110. 0.004 105.956 ↑ 1.5 2 1

Append (cost=0.28..74,575.56 rows=3 width=4) (actual time=0.361..105.956 rows=2 loops=1)

  • Buffers: shared hit=70765
111. 0.005 104.907 ↑ 1.0 2 1

Subquery Scan on *SELECT* 1_2 (cost=0.28..74,113.01 rows=2 width=4) (actual time=0.360..104.907 rows=2 loops=1)

  • Output: "*SELECT* 1_2".timeoffid
  • Buffers: shared hit=70339
112. 0.007 104.902 ↑ 1.0 2 1

Nested Loop Anti Join (cost=0.28..74,112.99 rows=2 width=4) (actual time=0.358..104.902 rows=2 loops=1)

  • Output: dm_timeofflist_facts_2.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Buffers: shared hit=70339
113. 104.885 104.885 ↑ 1.0 2 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_facts dm_timeofflist_facts_2 (cost=0.00..74,109.38 rows=2 width=4) (actual time=0.348..104.885 rows=2 loops=1)

  • Output: dm_timeofflist_facts_2.timeoffid, dm_timeofflist_facts_2.timeoffslug, dm_timeofflist_facts_2.timeoffowneruserid, dm_timeofflist_facts_2.timeoffowneruserdisplayname, dm_timeofflist_facts_2.timeoffowneruserslug, dm_timeofflist_facts_2.timeoffowneruserenabled, dm_timeofflist_facts_2.timeoffownerdepartmentid, dm_timeofflist_facts_2.timeoffownerdepartmentdisplayname, dm_timeofflist_facts_2.timeoffownerdepartmentslug, dm_timeofflist_facts_2.timeoffownersupervisoruserid, dm_timeofflist_facts_2.timeoffownersupervisoruserdisplayname, dm_timeofflist_facts_2.timeoffownersupervisoruserslug, dm_timeofflist_facts_2.timeoffcodeid, dm_timeofflist_facts_2.timeoffcodedisplayname, dm_timeofflist_facts_2.timeoffcodeslug, dm_timeofflist_facts_2.approvalstatus, dm_timeofflist_facts_2.timeoffstatus, dm_timeofflist_facts_2.startdate, dm_timeofflist_facts_2.enddate, dm_timeofflist_facts_2.startdaydurationtype, dm_timeofflist_facts_2.enddaydurationtype, dm_timeofflist_facts_2.startdayduration, dm_timeofflist_facts_2.enddayduration, dm_timeofflist_facts_2.startdaystarttime, dm_timeofflist_facts_2.enddayendtime, dm_timeofflist_facts_2.totalduration, dm_timeofflist_facts_2.effectivehoursperday, dm_timeofflist_facts_2.lastactiondatetimeutc, dm_timeofflist_facts_2.waitingonapproveruserid, dm_timeofflist_facts_2.waitingonapproveruserslug, dm_timeofflist_facts_2.waitingonapproveruserdisplayname, dm_timeofflist_facts_2.generatedonutc, dm_timeofflist_facts_2.timeoffowneruseremployeeid, dm_timeofflist_facts_2.timeoffowneruserloginname, dm_timeofflist_facts_2.totalworkdayduration, dm_timeofflist_facts_2.displayformat
  • Filter: ((dm_timeofflist_facts_2.timeoffcodeid <> 34) AND (dm_timeofflist_facts_2.startdate <= '2019-10-05'::date) AND (dm_timeofflist_facts_2.enddate >= '2019-09-29'::date) AND (dm_timeofflist_facts_2.timeoffstatus = 3))
  • Rows Removed by Filter: 188718
  • Buffers: shared hit=70335
114. 0.010 0.010 ↓ 0.0 0 2

Index Only Scan using dm_timeofflist_realtime_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_4 (cost=0.28..1.30 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=2)

  • Output: dm_timeofflist_realtime_facts_4.timeoffid
  • Index Cond: (dm_timeofflist_realtime_facts_4.timeoffid = dm_timeofflist_facts_2.timeoffid)
  • Heap Fetches: 0
  • Buffers: shared hit=4
115. 0.000 1.045 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_2 (cost=0.00..462.55 rows=1 width=4) (actual time=1.045..1.045 rows=0 loops=1)

  • Output: "*SELECT* 2_2".timeoffid
  • Buffers: shared hit=426
116. 1.045 1.045 ↓ 0.0 0 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_5 (cost=0.00..462.54 rows=1 width=4) (actual time=1.045..1.045 rows=0 loops=1)

  • Output: dm_timeofflist_realtime_facts_5.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Filter: ((NOT dm_timeofflist_realtime_facts_5.deleted) AND (dm_timeofflist_realtime_facts_5.timeoffcodeid <> 34) AND (dm_timeofflist_realtime_facts_5.startdate <= '2019-10-05'::date) AND (dm_timeofflist_realtime_facts_5.enddate >= '2019-09-29'::date) AND (dm_timeofflist_realtime_facts_5.timeoffstatus = 3))
  • Rows Removed by Filter: 1827
  • Buffers: shared hit=426
117. 0.012 0.094 ↓ 0.0 0 2

Nested Loop Semi Join (cost=3.84..4.99 rows=1 width=8) (actual time=0.047..0.047 rows=0 loops=2)

  • Output: timeoffs81.id, timeoffs82.id
  • Buffers: shared hit=28
118. 0.014 0.014 ↑ 1.0 1 2

Index Only Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs81 (cost=0.42..1.44 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=2)

  • Output: timeoffs81.id
  • Index Cond: (timeoffs81.id = "*SELECT* 1_2".timeoffid)
  • Heap Fetches: 0
  • Buffers: shared hit=7
119. 0.031 0.068 ↓ 0.0 0 2

Nested Loop Left Join (cost=3.42..3.55 rows=1 width=4) (actual time=0.034..0.034 rows=0 loops=2)

  • Output: timeoffs82.id
  • Filter: ((hashed SubPlan 26) OR (hashed SubPlan 27))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=21
120. 0.008 0.008 ↑ 1.0 1 2

Index Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs82 (cost=0.42..0.46 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=2)

  • Output: timeoffs82.id, timeoffs82.guidid, timeoffs82.userid, timeoffs82.createdbyuserid, timeoffs82.timeoffcodeid, timeoffs82.startdate, timeoffs82.enddate, timeoffs82.approvalstatus, timeoffs82.comments, timeoffs82.submittedonutc, timeoffs82.modifiedonutc, timeoffs82.info1, timeoffs82.info2, timeoffs82.info3, timeoffs82.info4, timeoffs82.info5, timeoffs82.startdurationtype, timeoffs82.enddurationtype, timeoffs82.startduration, timeoffs82.endduration, timeoffs82.startdatestarttime, timeoffs82.enddateendtime, timeoffs82.entryconfigurationmethod
  • Index Cond: (timeoffs82.id = timeoffs81.id)
  • Buffers: shared hit=8
121. 0.016 0.016 ↑ 1.0 1 2

Index Only Scan using ix4ul_userlocationstartend on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userlocation userlocation83 (cost=0.41..0.48 rows=1 width=28) (actual time=0.008..0.008 rows=1 loops=2)

  • Output: userlocation83.userid, userlocation83.locationid, userlocation83.startdate, userlocation83.enddate
  • Index Cond: ((userlocation83.userid = timeoffs82.userid) AND (userlocation83.startdate <= timeoffs82.enddate) AND (userlocation83.enddate >= timeoffs82.startdate))
  • Heap Fetches: 0
  • Buffers: shared hit=7
122.          

SubPlan (forNested Loop Left Join)

123. 0.007 0.007 ↑ 1.0 1 1

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy84 (cost=0.28..1.29 rows=1 width=16) (actual time=0.006..0.007 rows=1 loops=1)

  • Output: locationflathierarchy84.childid
  • Index Cond: (locationflathierarchy84.parentid = 'a36334cb-1074-45dd-8c37-0a0241f0416b'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
124. 0.006 0.006 ↑ 1.0 1 1

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy85 (cost=0.28..1.29 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=1)

  • Output: locationflathierarchy85.childid
  • Index Cond: (locationflathierarchy85.parentid = 'c3b4b88b-163d-4ff3-aff1-2c83b2bcd1a2'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
125. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=25,916.45..26,053.64 rows=3 width=4) (never executed)

  • Output: timeoffs44.id
  • Filter: (((userhierarchy45.supervisorid = 2042) AND ((userhierarchy45.startdate IS NULL) OR (userhierarchy45.startdate <= '2019-10-03'::date)) AND ((userhierarchy45.enddate IS NULL) OR (userhierarchy45.enddate >= '2019-10-03'::date))) OR (alternatives: SubPlan 15 or hashed SubPlan 16) OR (alternatives: SubPlan 17 or hashed SubPlan 18) OR (hashed SubPlan 21) OR (SubPlan 22) OR (SubPlan 23) OR (SubPlan 24) OR (SubPlan 25))
126. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs44 (cost=0.42..0.46 rows=1 width=16) (never executed)

  • Output: timeoffs44.id, timeoffs44.guidid, timeoffs44.userid, timeoffs44.createdbyuserid, timeoffs44.timeoffcodeid, timeoffs44.startdate, timeoffs44.enddate, timeoffs44.approvalstatus, timeoffs44.comments, timeoffs44.submittedonutc, timeoffs44.modifiedonutc, timeoffs44.info1, timeoffs44.info2, timeoffs44.info3, timeoffs44.info4, timeoffs44.info5, timeoffs44.startdurationtype, timeoffs44.enddurationtype, timeoffs44.startduration, timeoffs44.endduration, timeoffs44.startdatestarttime, timeoffs44.enddateendtime, timeoffs44.entryconfigurationmethod
  • Index Cond: (timeoffs44.id = timeoffs81.id)
127. 0.000 0.000 ↓ 0.0 0

Index Scan using ix3uh_usersuperstart on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userhierarchy userhierarchy45 (cost=0.29..0.32 rows=2 width=24) (never executed)

  • Output: userhierarchy45.id, userhierarchy45.userid, userhierarchy45.supervisorid, userhierarchy45.startdate, userhierarchy45.enddate
  • Index Cond: (userhierarchy45.userid = timeoffs44.userid)
128.          

SubPlan (forNested Loop Left Join)

129. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..4.59 rows=1 width=0) (never executed)

  • Join Filter: (timeoffapprovalnodes46.id = timeoffapprovalrequest47.nodeid)
130. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoantimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes46 (cost=0.27..2.29 rows=1 width=16) (never executed)

  • Output: timeoffapprovalnodes46.id, timeoffapprovalnodes46.timeoffid, timeoffapprovalnodes46.isapproved, timeoffapprovalnodes46.approverrole, timeoffapprovalnodes46.userid, timeoffapprovalnodes46.agentresolutionstate, timeoffapprovalnodes46.scriptid
  • Index Cond: (timeoffapprovalnodes46.timeoffid = timeoffs44.id)
131. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix2toaraidnid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest47 (cost=0.27..2.29 rows=1 width=16) (never executed)

  • Output: timeoffapprovalrequest47.approverid, timeoffapprovalrequest47.nodeid
  • Index Cond: (timeoffapprovalrequest47.approverid = 2042)
  • Heap Fetches: 0
132. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..4.59 rows=1 width=4) (never executed)

  • Output: timeoffapprovalnodes46_1.timeoffid
133. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix2toaraidnid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest47_1 (cost=0.27..2.29 rows=1 width=16) (never executed)

  • Output: timeoffapprovalrequest47_1.approverid, timeoffapprovalrequest47_1.nodeid
  • Index Cond: (timeoffapprovalrequest47_1.approverid = 2042)
  • Heap Fetches: 0
134. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes46_1 (cost=0.27..2.29 rows=1 width=20) (never executed)

  • Output: timeoffapprovalnodes46_1.id, timeoffapprovalnodes46_1.timeoffid, timeoffapprovalnodes46_1.isapproved, timeoffapprovalnodes46_1.approverrole, timeoffapprovalnodes46_1.userid, timeoffapprovalnodes46_1.agentresolutionstate, timeoffapprovalnodes46_1.scriptid
  • Index Cond: (timeoffapprovalnodes46_1.id = timeoffapprovalrequest47_1.nodeid)
135. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahtimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory48 (cost=0.42..3.11 rows=1 width=0) (never executed)

  • Index Cond: (timeoffapprovalhistory48.timeoffid = timeoffs44.id)
  • Filter: ((timeoffapprovalhistory48.userid = 2042) AND (timeoffapprovalhistory48.action = ANY ('{2,3,4}'::integer[])))
136. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahuserid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory48_1 (cost=0.42..29.92 rows=16 width=4) (never executed)

  • Output: timeoffapprovalhistory48_1.timeoffid
  • Index Cond: (timeoffapprovalhistory48_1.userid = 2042)
  • Filter: (timeoffapprovalhistory48_1.action = ANY ('{2,3,4}'::integer[]))
137. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=3.65..25,561.89 rows=141,540 width=4) (never executed)

  • Output: timeoffs49.id
  • Merge Cond: (timeoffs49.userid = userlocation50.userid)
  • Join Filter: ((userlocation50.startdate <= timeoffs49.enddate) AND (userlocation50.enddate >= timeoffs49.startdate))
  • Filter: ((hashed SubPlan 19) OR (hashed SubPlan 20))
138. 0.000 0.000 ↓ 0.0 0

Index Scan using ixto4userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs49 (cost=0.42..7,876.22 rows=188,720 width=16) (never executed)

  • Output: timeoffs49.id, timeoffs49.guidid, timeoffs49.userid, timeoffs49.createdbyuserid, timeoffs49.timeoffcodeid, timeoffs49.startdate, timeoffs49.enddate, timeoffs49.approvalstatus, timeoffs49.comments, timeoffs49.submittedonutc, timeoffs49.modifiedonutc, timeoffs49.info1, timeoffs49.info2, timeoffs49.info3, timeoffs49.info4, timeoffs49.info5, timeoffs49.startdurationtype, timeoffs49.enddurationtype, timeoffs49.startduration, timeoffs49.endduration, timeoffs49.startdatestarttime, timeoffs49.enddateendtime, timeoffs49.entryconfigurationmethod
139. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.41..1,350.82 rows=25,052 width=28) (never executed)

  • Output: userlocation50.userid, userlocation50.locationid, userlocation50.startdate, userlocation50.enddate
140. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ul_userlocationstartend on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userlocation userlocation50 (cost=0.41..1,288.19 rows=25,052 width=28) (never executed)

  • Output: userlocation50.userid, userlocation50.locationid, userlocation50.startdate, userlocation50.enddate
  • Heap Fetches: 0
141.          

SubPlan (forMerge Left Join)

142. 0.000 0.000 ↓ 0.0 0

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy51 (cost=0.28..1.29 rows=1 width=16) (never executed)

  • Output: locationflathierarchy51.childid
  • Index Cond: (locationflathierarchy51.parentid = 'a36334cb-1074-45dd-8c37-0a0241f0416b'::uuid)
  • Heap Fetches: 0
143. 0.000 0.000 ↓ 0.0 0

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy52 (cost=0.28..1.29 rows=1 width=16) (never executed)

  • Output: locationflathierarchy52.childid
  • Index Cond: (locationflathierarchy52.parentid = 'c3b4b88b-163d-4ff3-aff1-2c83b2bcd1a2'::uuid)
  • Heap Fetches: 0
144. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.53..18.68 rows=1 width=63) (never executed)

  • Output: upper(tsapprovalrequestkeyvalue53.uri)
145. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.25..14.33 rows=8 width=79) (never executed)

  • Output: tsapprovalrequestkeyvalue53.uri, tsapprovalrequestkeyvalue53.parentid
146. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.97..6.24 rows=1 width=4) (never executed)

  • Output: tsapprovalrequest56.id
147. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..4.59 rows=1 width=20) (never executed)

  • Output: timesheetapprovalnodes55.timesheetid, tsapprovalrequest56.id
148. 0.000 0.000 ↓ 0.0 0

Index Scan using uix2tsar_nodeid_userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequest tsapprovalrequest56 (cost=0.27..2.29 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest56.id, tsapprovalrequest56.effectivedateutc, tsapprovalrequest56.userid, tsapprovalrequest56.nodeid, tsapprovalrequest56.remindersentutc, tsapprovalrequest56.overduesentutc, tsapprovalrequest56.waitingbatchsentutc, tsapprovalrequest56.approvalagenttype, tsapprovalrequest56.systemprocessidentifier
  • Index Cond: (tsapprovalrequest56.userid = 2042)
149. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalnodes timesheetapprovalnodes55 (cost=0.28..2.29 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes55.id, timesheetapprovalnodes55.isapproved, timesheetapprovalnodes55.approverrole, timesheetapprovalnodes55.userid, timesheetapprovalnodes55.timesheetid, timesheetapprovalnodes55.systemprocessidentifier, timesheetapprovalnodes55.scriptid, timesheetapprovalnodes55.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes55.id = tsapprovalrequest56.nodeid)
150. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet54 (cost=0.42..1.63 rows=1 width=16) (never executed)

  • Output: timesheet54.id, timesheet54.userid, timesheet54.startdate, timesheet54.enddate, timesheet54.approvalstatus, timesheet54.duedate, timesheet54.autosubmitdatetimeutc, timesheet54.lastautosubmitattemptdatetimeutc, timesheet54.createdonutc
  • Index Cond: (timesheet54.id = timesheetapprovalnodes55.timesheetid)
  • Filter: ((timeoffs44.startdate <= timesheet54.enddate) AND (timeoffs44.enddate >= timesheet54.startdate) AND (timesheet54.userid = timeoffs44.userid))
151. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue53 (cost=0.28..8.01 rows=8 width=83) (never executed)

  • Output: tsapprovalrequestkeyvalue53.id, tsapprovalrequestkeyvalue53.tsapprovalrequestid, tsapprovalrequestkeyvalue53.parentid, tsapprovalrequestkeyvalue53.index, tsapprovalrequestkeyvalue53.key, tsapprovalrequestkeyvalue53.uri, tsapprovalrequestkeyvalue53.slug, tsapprovalrequestkeyvalue53."boolean", tsapprovalrequestkeyvalue53.date, tsapprovalrequestkeyvalue53.number, tsapprovalrequestkeyvalue53.text, tsapprovalrequestkeyvalue53."time", tsapprovalrequestkeyvalue53.timespan, tsapprovalrequestkeyvalue53.daterange_startdate, tsapprovalrequestkeyvalue53.daterange_enddate, tsapprovalrequestkeyvalue53.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue53.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue53.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue53.workdayduration_workdays, tsapprovalrequestkeyvalue53.workdayduration_hours, tsapprovalrequestkeyvalue53.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue53.tsapprovalrequestid = tsapprovalrequest56.id)
  • Filter: (upper(tsapprovalrequestkeyvalue53.key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
152. 0.000 0.000 ↓ 0.0 0

Index Scan using tsapprovalrequestkeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue57 (cost=0.28..0.53 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue57.id, tsapprovalrequestkeyvalue57.tsapprovalrequestid, tsapprovalrequestkeyvalue57.parentid, tsapprovalrequestkeyvalue57.index, tsapprovalrequestkeyvalue57.key, tsapprovalrequestkeyvalue57.uri, tsapprovalrequestkeyvalue57.slug, tsapprovalrequestkeyvalue57."boolean", tsapprovalrequestkeyvalue57.date, tsapprovalrequestkeyvalue57.number, tsapprovalrequestkeyvalue57.text, tsapprovalrequestkeyvalue57."time", tsapprovalrequestkeyvalue57.timespan, tsapprovalrequestkeyvalue57.daterange_startdate, tsapprovalrequestkeyvalue57.daterange_enddate, tsapprovalrequestkeyvalue57.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue57.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue57.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue57.workdayduration_workdays, tsapprovalrequestkeyvalue57.workdayduration_hours, tsapprovalrequestkeyvalue57.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue57.id = tsapprovalrequestkeyvalue53.parentid)
  • Filter: (tsapprovalrequestkeyvalue57.parentid IS NULL)
153. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.94..28.19 rows=1 width=69) (never executed)

  • Output: upper(sheetapprovalhistorykeyvalue58.uri)
154. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.51..27.45 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue66.id
155. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.07..25.51 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue65.id
156. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10.64..24.81 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue64.id
157. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10.21..23.27 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue63.id
158. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.78..21.02 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue62.parentid
159. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.34..18.55 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue61.parentid
160. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.73..11.91 rows=1 width=16) (never executed)

  • Output: timesheetapprovalhistory60.id
161. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet59 (cost=0.42..3.23 rows=2 width=16) (never executed)

  • Output: timesheet59.id, timesheet59.userid, timesheet59.startdate, timesheet59.enddate, timesheet59.approvalstatus, timesheet59.duedate, timesheet59.autosubmitdatetimeutc, timesheet59.lastautosubmitattemptdatetimeutc, timesheet59.createdonutc
  • Index Cond: ((timesheet59.userid = timeoffs44.userid) AND (timeoffs44.enddate >= timesheet59.startdate) AND (timeoffs44.startdate <= timesheet59.enddate))
162. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory60 (cost=3.31..4.33 rows=1 width=32) (never executed)

  • Output: timesheetapprovalhistory60.id, timesheetapprovalhistory60.action, timesheetapprovalhistory60.approvalcomments, timesheetapprovalhistory60.timestamputc, timesheetapprovalhistory60.serialnumber, timesheetapprovalhistory60.timesheetid, timesheetapprovalhistory60.approvalagenttype, timesheetapprovalhistory60.userid, timesheetapprovalhistory60.systemprocessidentifier
  • Recheck Cond: ((timesheetapprovalhistory60.timesheetid = timesheet59.id) AND (timesheetapprovalhistory60.userid = 2042))
163. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.31..3.31 rows=1 width=0) (never executed)

164. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtah2timesheetid (cost=0.00..1.45 rows=4 width=0) (never executed)

  • Index Cond: (timesheetapprovalhistory60.timesheetid = timesheet59.id)
165. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahuserid (cost=0.00..1.60 rows=24 width=0) (never executed)

  • Index Cond: (timesheetapprovalhistory60.userid = 2042)
166. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue61 (cost=5.62..6.64 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue61.id, sheetapprovalhistorykeyvalue61.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue61.parentid, sheetapprovalhistorykeyvalue61.index, sheetapprovalhistorykeyvalue61.key, sheetapprovalhistorykeyvalue61.uri, sheetapprovalhistorykeyvalue61.slug, sheetapprovalhistorykeyvalue61."boolean", sheetapprovalhistorykeyvalue61.date, sheetapprovalhistorykeyvalue61.number, sheetapprovalhistorykeyvalue61.text, sheetapprovalhistorykeyvalue61."time", sheetapprovalhistorykeyvalue61.timespan, sheetapprovalhistorykeyvalue61.daterange_startdate, sheetapprovalhistorykeyvalue61.daterange_enddate, sheetapprovalhistorykeyvalue61.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue61.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue61.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue61.workdayduration_workdays, sheetapprovalhistorykeyvalue61.workdayduration_hours, sheetapprovalhistorykeyvalue61.workdayduration_minutes
  • Recheck Cond: ((sheetapprovalhistorykeyvalue61.timesheetapprovalhistoryid = timesheetapprovalhistory60.id) AND (upper(sheetapprovalhistorykeyvalue61.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text))
  • Filter: (upper(sheetapprovalhistorykeyvalue61.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
167. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=5.62..5.62 rows=1 width=0) (never executed)

168. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..1.62 rows=25 width=0) (never executed)

  • Index Cond: (sheetapprovalhistorykeyvalue61.timesheetapprovalhistoryid = timesheetapprovalhistory60.id)
169. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahkvuri (cost=0.00..3.72 rows=155 width=0) (never executed)

  • Index Cond: (upper(sheetapprovalhistorykeyvalue61.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text)
170. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue62 (cost=0.43..2.46 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue62.id, sheetapprovalhistorykeyvalue62.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue62.parentid, sheetapprovalhistorykeyvalue62.index, sheetapprovalhistorykeyvalue62.key, sheetapprovalhistorykeyvalue62.uri, sheetapprovalhistorykeyvalue62.slug, sheetapprovalhistorykeyvalue62."boolean", sheetapprovalhistorykeyvalue62.date, sheetapprovalhistorykeyvalue62.number, sheetapprovalhistorykeyvalue62.text, sheetapprovalhistorykeyvalue62."time", sheetapprovalhistorykeyvalue62.timespan, sheetapprovalhistorykeyvalue62.daterange_startdate, sheetapprovalhistorykeyvalue62.daterange_enddate, sheetapprovalhistorykeyvalue62.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue62.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue62.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue62.workdayduration_workdays, sheetapprovalhistorykeyvalue62.workdayduration_hours, sheetapprovalhistorykeyvalue62.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue62.id = sheetapprovalhistorykeyvalue61.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue62.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
171. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue63 (cost=0.43..2.24 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue63.id, sheetapprovalhistorykeyvalue63.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue63.parentid, sheetapprovalhistorykeyvalue63.index, sheetapprovalhistorykeyvalue63.key, sheetapprovalhistorykeyvalue63.uri, sheetapprovalhistorykeyvalue63.slug, sheetapprovalhistorykeyvalue63."boolean", sheetapprovalhistorykeyvalue63.date, sheetapprovalhistorykeyvalue63.number, sheetapprovalhistorykeyvalue63.text, sheetapprovalhistorykeyvalue63."time", sheetapprovalhistorykeyvalue63.timespan, sheetapprovalhistorykeyvalue63.daterange_startdate, sheetapprovalhistorykeyvalue63.daterange_enddate, sheetapprovalhistorykeyvalue63.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue63.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue63.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue63.workdayduration_workdays, sheetapprovalhistorykeyvalue63.workdayduration_hours, sheetapprovalhistorykeyvalue63.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue63.parentid = sheetapprovalhistorykeyvalue62.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue63.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
172. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue64 (cost=0.43..1.45 rows=10 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue64.id, sheetapprovalhistorykeyvalue64.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue64.parentid, sheetapprovalhistorykeyvalue64.index, sheetapprovalhistorykeyvalue64.key, sheetapprovalhistorykeyvalue64.uri, sheetapprovalhistorykeyvalue64.slug, sheetapprovalhistorykeyvalue64."boolean", sheetapprovalhistorykeyvalue64.date, sheetapprovalhistorykeyvalue64.number, sheetapprovalhistorykeyvalue64.text, sheetapprovalhistorykeyvalue64."time", sheetapprovalhistorykeyvalue64.timespan, sheetapprovalhistorykeyvalue64.daterange_startdate, sheetapprovalhistorykeyvalue64.daterange_enddate, sheetapprovalhistorykeyvalue64.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue64.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue64.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue64.workdayduration_workdays, sheetapprovalhistorykeyvalue64.workdayduration_hours, sheetapprovalhistorykeyvalue64.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue64.parentid = sheetapprovalhistorykeyvalue63.id)
173. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue65 (cost=0.43..0.69 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue65.id, sheetapprovalhistorykeyvalue65.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue65.parentid, sheetapprovalhistorykeyvalue65.index, sheetapprovalhistorykeyvalue65.key, sheetapprovalhistorykeyvalue65.uri, sheetapprovalhistorykeyvalue65.slug, sheetapprovalhistorykeyvalue65."boolean", sheetapprovalhistorykeyvalue65.date, sheetapprovalhistorykeyvalue65.number, sheetapprovalhistorykeyvalue65.text, sheetapprovalhistorykeyvalue65."time", sheetapprovalhistorykeyvalue65.timespan, sheetapprovalhistorykeyvalue65.daterange_startdate, sheetapprovalhistorykeyvalue65.daterange_enddate, sheetapprovalhistorykeyvalue65.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue65.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue65.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue65.workdayduration_workdays, sheetapprovalhistorykeyvalue65.workdayduration_hours, sheetapprovalhistorykeyvalue65.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue65.parentid = sheetapprovalhistorykeyvalue64.id)
  • Filter: (upper(sheetapprovalhistorykeyvalue65.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
174. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue66 (cost=0.43..1.84 rows=10 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue66.id, sheetapprovalhistorykeyvalue66.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue66.parentid, sheetapprovalhistorykeyvalue66.index, sheetapprovalhistorykeyvalue66.key, sheetapprovalhistorykeyvalue66.uri, sheetapprovalhistorykeyvalue66.slug, sheetapprovalhistorykeyvalue66."boolean", sheetapprovalhistorykeyvalue66.date, sheetapprovalhistorykeyvalue66.number, sheetapprovalhistorykeyvalue66.text, sheetapprovalhistorykeyvalue66."time", sheetapprovalhistorykeyvalue66.timespan, sheetapprovalhistorykeyvalue66.daterange_startdate, sheetapprovalhistorykeyvalue66.daterange_enddate, sheetapprovalhistorykeyvalue66.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue66.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue66.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue66.workdayduration_workdays, sheetapprovalhistorykeyvalue66.workdayduration_hours, sheetapprovalhistorykeyvalue66.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue66.parentid = sheetapprovalhistorykeyvalue65.id)
175. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue58 (cost=0.43..0.64 rows=10 width=85) (never executed)

  • Output: sheetapprovalhistorykeyvalue58.id, sheetapprovalhistorykeyvalue58.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue58.parentid, sheetapprovalhistorykeyvalue58.index, sheetapprovalhistorykeyvalue58.key, sheetapprovalhistorykeyvalue58.uri, sheetapprovalhistorykeyvalue58.slug, sheetapprovalhistorykeyvalue58."boolean", sheetapprovalhistorykeyvalue58.date, sheetapprovalhistorykeyvalue58.number, sheetapprovalhistorykeyvalue58.text, sheetapprovalhistorykeyvalue58."time", sheetapprovalhistorykeyvalue58.timespan, sheetapprovalhistorykeyvalue58.daterange_startdate, sheetapprovalhistorykeyvalue58.daterange_enddate, sheetapprovalhistorykeyvalue58.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue58.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue58.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue58.workdayduration_workdays, sheetapprovalhistorykeyvalue58.workdayduration_hours, sheetapprovalhistorykeyvalue58.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue58.parentid = sheetapprovalhistorykeyvalue66.id)
176. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.53..9.86 rows=1 width=63) (never executed)

  • Output: upper(tsapprovalrequestkeyvalue67.uri)
177. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.25..7.55 rows=1 width=79) (never executed)

  • Output: tsapprovalrequestkeyvalue67.uri, tsapprovalrequestkeyvalue67.parentid
  • Join Filter: (tsapprovalrequest70.id = tsapprovalrequestkeyvalue67.tsapprovalrequestid)
178. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.97..6.24 rows=1 width=4) (never executed)

  • Output: tsapprovalrequest70.id
179. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..4.59 rows=1 width=20) (never executed)

  • Output: timesheetapprovalnodes69.timesheetid, tsapprovalrequest70.id
180. 0.000 0.000 ↓ 0.0 0

Index Scan using uix2tsar_nodeid_userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequest tsapprovalrequest70 (cost=0.27..2.29 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest70.id, tsapprovalrequest70.effectivedateutc, tsapprovalrequest70.userid, tsapprovalrequest70.nodeid, tsapprovalrequest70.remindersentutc, tsapprovalrequest70.overduesentutc, tsapprovalrequest70.waitingbatchsentutc, tsapprovalrequest70.approvalagenttype, tsapprovalrequest70.systemprocessidentifier
  • Index Cond: (tsapprovalrequest70.userid = 2042)
181. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalnodes timesheetapprovalnodes69 (cost=0.28..2.29 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes69.id, timesheetapprovalnodes69.isapproved, timesheetapprovalnodes69.approverrole, timesheetapprovalnodes69.userid, timesheetapprovalnodes69.timesheetid, timesheetapprovalnodes69.systemprocessidentifier, timesheetapprovalnodes69.scriptid, timesheetapprovalnodes69.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes69.id = tsapprovalrequest70.nodeid)
182. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet68 (cost=0.42..1.63 rows=1 width=16) (never executed)

  • Output: timesheet68.id, timesheet68.userid, timesheet68.startdate, timesheet68.enddate, timesheet68.approvalstatus, timesheet68.duedate, timesheet68.autosubmitdatetimeutc, timesheet68.lastautosubmitattemptdatetimeutc, timesheet68.createdonutc
  • Index Cond: (timesheet68.id = timesheetapprovalnodes69.timesheetid)
  • Filter: ((timeoffs44.startdate <= timesheet68.enddate) AND (timeoffs44.enddate >= timesheet68.startdate) AND (timesheet68.userid = timeoffs44.userid))
183. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue67 (cost=0.28..1.30 rows=1 width=83) (never executed)

  • Output: tsapprovalrequestkeyvalue67.id, tsapprovalrequestkeyvalue67.tsapprovalrequestid, tsapprovalrequestkeyvalue67.parentid, tsapprovalrequestkeyvalue67.index, tsapprovalrequestkeyvalue67.key, tsapprovalrequestkeyvalue67.uri, tsapprovalrequestkeyvalue67.slug, tsapprovalrequestkeyvalue67."boolean", tsapprovalrequestkeyvalue67.date, tsapprovalrequestkeyvalue67.number, tsapprovalrequestkeyvalue67.text, tsapprovalrequestkeyvalue67."time", tsapprovalrequestkeyvalue67.timespan, tsapprovalrequestkeyvalue67.daterange_startdate, tsapprovalrequestkeyvalue67.daterange_enddate, tsapprovalrequestkeyvalue67.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue67.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue67.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue67.workdayduration_workdays, tsapprovalrequestkeyvalue67.workdayduration_hours, tsapprovalrequestkeyvalue67.workdayduration_minutes
  • Index Cond: (upper(tsapprovalrequestkeyvalue67.key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
184. 0.000 0.000 ↓ 0.0 0

Index Scan using tsapprovalrequestkeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue71 (cost=0.28..2.30 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue71.id, tsapprovalrequestkeyvalue71.tsapprovalrequestid, tsapprovalrequestkeyvalue71.parentid, tsapprovalrequestkeyvalue71.index, tsapprovalrequestkeyvalue71.key, tsapprovalrequestkeyvalue71.uri, tsapprovalrequestkeyvalue71.slug, tsapprovalrequestkeyvalue71."boolean", tsapprovalrequestkeyvalue71.date, tsapprovalrequestkeyvalue71.number, tsapprovalrequestkeyvalue71.text, tsapprovalrequestkeyvalue71."time", tsapprovalrequestkeyvalue71.timespan, tsapprovalrequestkeyvalue71.daterange_startdate, tsapprovalrequestkeyvalue71.daterange_enddate, tsapprovalrequestkeyvalue71.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue71.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue71.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue71.workdayduration_workdays, tsapprovalrequestkeyvalue71.workdayduration_hours, tsapprovalrequestkeyvalue71.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue71.id = tsapprovalrequestkeyvalue67.parentid)
  • Filter: (tsapprovalrequestkeyvalue71.parentid IS NULL)
185. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.94..37.92 rows=1 width=69) (never executed)

  • Output: upper(sheetapprovalhistorykeyvalue72.uri)
186. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.51..37.18 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue80.id
187. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.07..25.51 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue79.id
188. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10.64..24.81 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue78.id
189. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10.21..23.27 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue77.id
190. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.78..21.02 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue76.parentid
191. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.34..18.55 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue75.parentid
192. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.73..11.91 rows=1 width=16) (never executed)

  • Output: timesheetapprovalhistory74.id
193. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet73 (cost=0.42..3.23 rows=2 width=16) (never executed)

  • Output: timesheet73.id, timesheet73.userid, timesheet73.startdate, timesheet73.enddate, timesheet73.approvalstatus, timesheet73.duedate, timesheet73.autosubmitdatetimeutc, timesheet73.lastautosubmitattemptdatetimeutc, timesheet73.createdonutc
  • Index Cond: ((timesheet73.userid = timeoffs44.userid) AND (timeoffs44.enddate >= timesheet73.startdate) AND (timeoffs44.startdate <= timesheet73.enddate))
194. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory74 (cost=3.31..4.33 rows=1 width=32) (never executed)

  • Output: timesheetapprovalhistory74.id, timesheetapprovalhistory74.action, timesheetapprovalhistory74.approvalcomments, timesheetapprovalhistory74.timestamputc, timesheetapprovalhistory74.serialnumber, timesheetapprovalhistory74.timesheetid, timesheetapprovalhistory74.approvalagenttype, timesheetapprovalhistory74.userid, timesheetapprovalhistory74.systemprocessidentifier
  • Recheck Cond: ((timesheetapprovalhistory74.timesheetid = timesheet73.id) AND (timesheetapprovalhistory74.userid = 2042))
195. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.31..3.31 rows=1 width=0) (never executed)

196. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtah2timesheetid (cost=0.00..1.45 rows=4 width=0) (never executed)

  • Index Cond: (timesheetapprovalhistory74.timesheetid = timesheet73.id)
197. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahuserid (cost=0.00..1.60 rows=24 width=0) (never executed)

  • Index Cond: (timesheetapprovalhistory74.userid = 2042)
198. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue75 (cost=5.62..6.64 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue75.id, sheetapprovalhistorykeyvalue75.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue75.parentid, sheetapprovalhistorykeyvalue75.index, sheetapprovalhistorykeyvalue75.key, sheetapprovalhistorykeyvalue75.uri, sheetapprovalhistorykeyvalue75.slug, sheetapprovalhistorykeyvalue75."boolean", sheetapprovalhistorykeyvalue75.date, sheetapprovalhistorykeyvalue75.number, sheetapprovalhistorykeyvalue75.text, sheetapprovalhistorykeyvalue75."time", sheetapprovalhistorykeyvalue75.timespan, sheetapprovalhistorykeyvalue75.daterange_startdate, sheetapprovalhistorykeyvalue75.daterange_enddate, sheetapprovalhistorykeyvalue75.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue75.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue75.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue75.workdayduration_workdays, sheetapprovalhistorykeyvalue75.workdayduration_hours, sheetapprovalhistorykeyvalue75.workdayduration_minutes
  • Recheck Cond: ((sheetapprovalhistorykeyvalue75.timesheetapprovalhistoryid = timesheetapprovalhistory74.id) AND (upper(sheetapprovalhistorykeyvalue75.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text))
  • Filter: (upper(sheetapprovalhistorykeyvalue75.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
199. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=5.62..5.62 rows=1 width=0) (never executed)

200. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..1.62 rows=25 width=0) (never executed)

  • Index Cond: (sheetapprovalhistorykeyvalue75.timesheetapprovalhistoryid = timesheetapprovalhistory74.id)
201. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahkvuri (cost=0.00..3.72 rows=155 width=0) (never executed)

  • Index Cond: (upper(sheetapprovalhistorykeyvalue75.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text)
202. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue76 (cost=0.43..2.46 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue76.id, sheetapprovalhistorykeyvalue76.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue76.parentid, sheetapprovalhistorykeyvalue76.index, sheetapprovalhistorykeyvalue76.key, sheetapprovalhistorykeyvalue76.uri, sheetapprovalhistorykeyvalue76.slug, sheetapprovalhistorykeyvalue76."boolean", sheetapprovalhistorykeyvalue76.date, sheetapprovalhistorykeyvalue76.number, sheetapprovalhistorykeyvalue76.text, sheetapprovalhistorykeyvalue76."time", sheetapprovalhistorykeyvalue76.timespan, sheetapprovalhistorykeyvalue76.daterange_startdate, sheetapprovalhistorykeyvalue76.daterange_enddate, sheetapprovalhistorykeyvalue76.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue76.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue76.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue76.workdayduration_workdays, sheetapprovalhistorykeyvalue76.workdayduration_hours, sheetapprovalhistorykeyvalue76.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue76.id = sheetapprovalhistorykeyvalue75.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue76.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
203. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue77 (cost=0.43..2.24 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue77.id, sheetapprovalhistorykeyvalue77.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue77.parentid, sheetapprovalhistorykeyvalue77.index, sheetapprovalhistorykeyvalue77.key, sheetapprovalhistorykeyvalue77.uri, sheetapprovalhistorykeyvalue77.slug, sheetapprovalhistorykeyvalue77."boolean", sheetapprovalhistorykeyvalue77.date, sheetapprovalhistorykeyvalue77.number, sheetapprovalhistorykeyvalue77.text, sheetapprovalhistorykeyvalue77."time", sheetapprovalhistorykeyvalue77.timespan, sheetapprovalhistorykeyvalue77.daterange_startdate, sheetapprovalhistorykeyvalue77.daterange_enddate, sheetapprovalhistorykeyvalue77.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue77.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue77.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue77.workdayduration_workdays, sheetapprovalhistorykeyvalue77.workdayduration_hours, sheetapprovalhistorykeyvalue77.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue77.parentid = sheetapprovalhistorykeyvalue76.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue77.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
204. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue78 (cost=0.43..1.45 rows=10 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue78.id, sheetapprovalhistorykeyvalue78.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue78.parentid, sheetapprovalhistorykeyvalue78.index, sheetapprovalhistorykeyvalue78.key, sheetapprovalhistorykeyvalue78.uri, sheetapprovalhistorykeyvalue78.slug, sheetapprovalhistorykeyvalue78."boolean", sheetapprovalhistorykeyvalue78.date, sheetapprovalhistorykeyvalue78.number, sheetapprovalhistorykeyvalue78.text, sheetapprovalhistorykeyvalue78."time", sheetapprovalhistorykeyvalue78.timespan, sheetapprovalhistorykeyvalue78.daterange_startdate, sheetapprovalhistorykeyvalue78.daterange_enddate, sheetapprovalhistorykeyvalue78.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue78.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue78.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue78.workdayduration_workdays, sheetapprovalhistorykeyvalue78.workdayduration_hours, sheetapprovalhistorykeyvalue78.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue78.parentid = sheetapprovalhistorykeyvalue77.id)
205. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue79 (cost=0.43..0.69 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue79.id, sheetapprovalhistorykeyvalue79.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue79.parentid, sheetapprovalhistorykeyvalue79.index, sheetapprovalhistorykeyvalue79.key, sheetapprovalhistorykeyvalue79.uri, sheetapprovalhistorykeyvalue79.slug, sheetapprovalhistorykeyvalue79."boolean", sheetapprovalhistorykeyvalue79.date, sheetapprovalhistorykeyvalue79.number, sheetapprovalhistorykeyvalue79.text, sheetapprovalhistorykeyvalue79."time", sheetapprovalhistorykeyvalue79.timespan, sheetapprovalhistorykeyvalue79.daterange_startdate, sheetapprovalhistorykeyvalue79.daterange_enddate, sheetapprovalhistorykeyvalue79.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue79.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue79.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue79.workdayduration_workdays, sheetapprovalhistorykeyvalue79.workdayduration_hours, sheetapprovalhistorykeyvalue79.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue79.parentid = sheetapprovalhistorykeyvalue78.id)
  • Filter: (upper(sheetapprovalhistorykeyvalue79.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
206. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue80 (cost=0.43..11.57 rows=10 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue80.id, sheetapprovalhistorykeyvalue80.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue80.parentid, sheetapprovalhistorykeyvalue80.index, sheetapprovalhistorykeyvalue80.key, sheetapprovalhistorykeyvalue80.uri, sheetapprovalhistorykeyvalue80.slug, sheetapprovalhistorykeyvalue80."boolean", sheetapprovalhistorykeyvalue80.date, sheetapprovalhistorykeyvalue80.number, sheetapprovalhistorykeyvalue80.text, sheetapprovalhistorykeyvalue80."time", sheetapprovalhistorykeyvalue80.timespan, sheetapprovalhistorykeyvalue80.daterange_startdate, sheetapprovalhistorykeyvalue80.daterange_enddate, sheetapprovalhistorykeyvalue80.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue80.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue80.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue80.workdayduration_workdays, sheetapprovalhistorykeyvalue80.workdayduration_hours, sheetapprovalhistorykeyvalue80.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue80.parentid = sheetapprovalhistorykeyvalue79.id)
207. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue72 (cost=0.43..0.64 rows=10 width=85) (never executed)

  • Output: sheetapprovalhistorykeyvalue72.id, sheetapprovalhistorykeyvalue72.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue72.parentid, sheetapprovalhistorykeyvalue72.index, sheetapprovalhistorykeyvalue72.key, sheetapprovalhistorykeyvalue72.uri, sheetapprovalhistorykeyvalue72.slug, sheetapprovalhistorykeyvalue72."boolean", sheetapprovalhistorykeyvalue72.date, sheetapprovalhistorykeyvalue72.number, sheetapprovalhistorykeyvalue72.text, sheetapprovalhistorykeyvalue72."time", sheetapprovalhistorykeyvalue72.timespan, sheetapprovalhistorykeyvalue72.daterange_startdate, sheetapprovalhistorykeyvalue72.daterange_enddate, sheetapprovalhistorykeyvalue72.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue72.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue72.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue72.workdayduration_workdays, sheetapprovalhistorykeyvalue72.workdayduration_hours, sheetapprovalhistorykeyvalue72.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue72.parentid = sheetapprovalhistorykeyvalue80.id)
208. 0.002 107.767 ↑ 1.0 1 1

Aggregate (cost=100,669.31..100,669.32 rows=1 width=0) (actual time=107.767..107.767 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=71621
209. 0.001 107.765 ↓ 0.0 0 1

Nested Loop Semi Join (cost=25,920.57..100,669.31 rows=1 width=0) (actual time=107.765..107.765 rows=0 loops=1)

  • Join Filter: ("*SELECT* 1_3".timeoffid = timeoffs87.id)
  • Buffers: shared hit=71621
210. 0.014 107.764 ↓ 0.0 0 1

Nested Loop Semi Join (cost=4.12..74,615.65 rows=1 width=12) (actual time=107.764..107.764 rows=0 loops=1)

  • Output: "*SELECT* 1_3".timeoffid, timeoffs124.id, timeoffs125.id
  • Buffers: shared hit=71621
211. 0.038 106.770 ↓ 10.0 70 1

Append (cost=0.28..74,579.48 rows=7 width=4) (actual time=0.067..106.770 rows=70 loops=1)

  • Buffers: shared hit=70905
212. 0.041 105.664 ↓ 14.0 70 1

Subquery Scan on *SELECT* 1_3 (cost=0.28..74,116.92 rows=5 width=4) (actual time=0.066..105.664 rows=70 loops=1)

  • Output: "*SELECT* 1_3".timeoffid
  • Buffers: shared hit=70479
213. 0.096 105.623 ↓ 14.0 70 1

Nested Loop Anti Join (cost=0.28..74,116.87 rows=5 width=4) (actual time=0.065..105.623 rows=70 loops=1)

  • Output: dm_timeofflist_facts_3.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Buffers: shared hit=70479
214. 105.387 105.387 ↓ 14.0 70 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_facts dm_timeofflist_facts_3 (cost=0.00..74,109.38 rows=5 width=4) (actual time=0.050..105.387 rows=70 loops=1)

  • Output: dm_timeofflist_facts_3.timeoffid, dm_timeofflist_facts_3.timeoffslug, dm_timeofflist_facts_3.timeoffowneruserid, dm_timeofflist_facts_3.timeoffowneruserdisplayname, dm_timeofflist_facts_3.timeoffowneruserslug, dm_timeofflist_facts_3.timeoffowneruserenabled, dm_timeofflist_facts_3.timeoffownerdepartmentid, dm_timeofflist_facts_3.timeoffownerdepartmentdisplayname, dm_timeofflist_facts_3.timeoffownerdepartmentslug, dm_timeofflist_facts_3.timeoffownersupervisoruserid, dm_timeofflist_facts_3.timeoffownersupervisoruserdisplayname, dm_timeofflist_facts_3.timeoffownersupervisoruserslug, dm_timeofflist_facts_3.timeoffcodeid, dm_timeofflist_facts_3.timeoffcodedisplayname, dm_timeofflist_facts_3.timeoffcodeslug, dm_timeofflist_facts_3.approvalstatus, dm_timeofflist_facts_3.timeoffstatus, dm_timeofflist_facts_3.startdate, dm_timeofflist_facts_3.enddate, dm_timeofflist_facts_3.startdaydurationtype, dm_timeofflist_facts_3.enddaydurationtype, dm_timeofflist_facts_3.startdayduration, dm_timeofflist_facts_3.enddayduration, dm_timeofflist_facts_3.startdaystarttime, dm_timeofflist_facts_3.enddayendtime, dm_timeofflist_facts_3.totalduration, dm_timeofflist_facts_3.effectivehoursperday, dm_timeofflist_facts_3.lastactiondatetimeutc, dm_timeofflist_facts_3.waitingonapproveruserid, dm_timeofflist_facts_3.waitingonapproveruserslug, dm_timeofflist_facts_3.waitingonapproveruserdisplayname, dm_timeofflist_facts_3.generatedonutc, dm_timeofflist_facts_3.timeoffowneruseremployeeid, dm_timeofflist_facts_3.timeoffowneruserloginname, dm_timeofflist_facts_3.totalworkdayduration, dm_timeofflist_facts_3.displayformat
  • Filter: ((dm_timeofflist_facts_3.timeoffcodeid <> 34) AND (dm_timeofflist_facts_3.startdate <= '2019-10-05'::date) AND (dm_timeofflist_facts_3.enddate >= '2019-09-29'::date) AND (dm_timeofflist_facts_3.timeoffstatus = 1))
  • Rows Removed by Filter: 188650
  • Buffers: shared hit=70335
215. 0.140 0.140 ↓ 0.0 0 70

Index Only Scan using dm_timeofflist_realtime_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_6 (cost=0.28..1.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=70)

  • Output: dm_timeofflist_realtime_facts_6.timeoffid
  • Index Cond: (dm_timeofflist_realtime_facts_6.timeoffid = dm_timeofflist_facts_3.timeoffid)
  • Heap Fetches: 3
  • Buffers: shared hit=144
216. 0.002 1.068 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_3 (cost=0.00..462.56 rows=2 width=4) (actual time=1.068..1.068 rows=0 loops=1)

  • Output: "*SELECT* 2_3".timeoffid
  • Buffers: shared hit=426
217. 1.066 1.066 ↓ 0.0 0 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_7 (cost=0.00..462.54 rows=2 width=4) (actual time=1.066..1.066 rows=0 loops=1)

  • Output: dm_timeofflist_realtime_facts_7.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Filter: ((NOT dm_timeofflist_realtime_facts_7.deleted) AND (dm_timeofflist_realtime_facts_7.timeoffcodeid <> 34) AND (dm_timeofflist_realtime_facts_7.startdate <= '2019-10-05'::date) AND (dm_timeofflist_realtime_facts_7.enddate >= '2019-09-29'::date) AND (dm_timeofflist_realtime_facts_7.timeoffstatus = 1))
  • Rows Removed by Filter: 1827
  • Buffers: shared hit=426
218. 0.140 0.980 ↓ 0.0 0 70

Nested Loop Semi Join (cost=3.84..4.99 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=70)

  • Output: timeoffs124.id, timeoffs125.id
  • Buffers: shared hit=716
219. 0.210 0.210 ↑ 1.0 1 70

Index Only Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs124 (cost=0.42..1.44 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=70)

  • Output: timeoffs124.id
  • Index Cond: (timeoffs124.id = "*SELECT* 1_3".timeoffid)
  • Heap Fetches: 0
  • Buffers: shared hit=213
220. 0.130 0.630 ↓ 0.0 0 70

Nested Loop Left Join (cost=3.42..3.55 rows=1 width=4) (actual time=0.009..0.009 rows=0 loops=70)

  • Output: timeoffs125.id
  • Filter: ((hashed SubPlan 40) OR (hashed SubPlan 41))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=503
221. 0.210 0.210 ↑ 1.0 1 70

Index Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs125 (cost=0.42..0.46 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=70)

  • Output: timeoffs125.id, timeoffs125.guidid, timeoffs125.userid, timeoffs125.createdbyuserid, timeoffs125.timeoffcodeid, timeoffs125.startdate, timeoffs125.enddate, timeoffs125.approvalstatus, timeoffs125.comments, timeoffs125.submittedonutc, timeoffs125.modifiedonutc, timeoffs125.info1, timeoffs125.info2, timeoffs125.info3, timeoffs125.info4, timeoffs125.info5, timeoffs125.startdurationtype, timeoffs125.enddurationtype, timeoffs125.startduration, timeoffs125.endduration, timeoffs125.startdatestarttime, timeoffs125.enddateendtime, timeoffs125.entryconfigurationmethod
  • Index Cond: (timeoffs125.id = timeoffs124.id)
  • Buffers: shared hit=282
222. 0.280 0.280 ↑ 1.0 1 70

Index Only Scan using ix4ul_userlocationstartend on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userlocation userlocation126 (cost=0.41..0.48 rows=1 width=28) (actual time=0.003..0.004 rows=1 loops=70)

  • Output: userlocation126.userid, userlocation126.locationid, userlocation126.startdate, userlocation126.enddate
  • Index Cond: ((userlocation126.userid = timeoffs125.userid) AND (userlocation126.startdate <= timeoffs125.enddate) AND (userlocation126.enddate >= timeoffs125.startdate))
  • Heap Fetches: 0
  • Buffers: shared hit=215
223.          

SubPlan (forNested Loop Left Join)

224. 0.006 0.006 ↑ 1.0 1 1

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy127 (cost=0.28..1.29 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=1)

  • Output: locationflathierarchy127.childid
  • Index Cond: (locationflathierarchy127.parentid = 'a36334cb-1074-45dd-8c37-0a0241f0416b'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
225. 0.004 0.004 ↑ 1.0 1 1

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy128 (cost=0.28..1.29 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=1)

  • Output: locationflathierarchy128.childid
  • Index Cond: (locationflathierarchy128.parentid = 'c3b4b88b-163d-4ff3-aff1-2c83b2bcd1a2'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
226. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=25,916.45..26,053.64 rows=3 width=4) (never executed)

  • Output: timeoffs87.id
  • Filter: (((userhierarchy88.supervisorid = 2042) AND ((userhierarchy88.startdate IS NULL) OR (userhierarchy88.startdate <= '2019-10-03'::date)) AND ((userhierarchy88.enddate IS NULL) OR (userhierarchy88.enddate >= '2019-10-03'::date))) OR (alternatives: SubPlan 29 or hashed SubPlan 30) OR (alternatives: SubPlan 31 or hashed SubPlan 32) OR (hashed SubPlan 35) OR (SubPlan 36) OR (SubPlan 37) OR (SubPlan 38) OR (SubPlan 39))
227. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs87 (cost=0.42..0.46 rows=1 width=16) (never executed)

  • Output: timeoffs87.id, timeoffs87.guidid, timeoffs87.userid, timeoffs87.createdbyuserid, timeoffs87.timeoffcodeid, timeoffs87.startdate, timeoffs87.enddate, timeoffs87.approvalstatus, timeoffs87.comments, timeoffs87.submittedonutc, timeoffs87.modifiedonutc, timeoffs87.info1, timeoffs87.info2, timeoffs87.info3, timeoffs87.info4, timeoffs87.info5, timeoffs87.startdurationtype, timeoffs87.enddurationtype, timeoffs87.startduration, timeoffs87.endduration, timeoffs87.startdatestarttime, timeoffs87.enddateendtime, timeoffs87.entryconfigurationmethod
  • Index Cond: (timeoffs87.id = timeoffs124.id)
228. 0.000 0.000 ↓ 0.0 0

Index Scan using ix3uh_usersuperstart on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userhierarchy userhierarchy88 (cost=0.29..0.32 rows=2 width=24) (never executed)

  • Output: userhierarchy88.id, userhierarchy88.userid, userhierarchy88.supervisorid, userhierarchy88.startdate, userhierarchy88.enddate
  • Index Cond: (userhierarchy88.userid = timeoffs87.userid)
229.          

SubPlan (forNested Loop Left Join)

230. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..4.59 rows=1 width=0) (never executed)

  • Join Filter: (timeoffapprovalnodes89.id = timeoffapprovalrequest90.nodeid)
231. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoantimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes89 (cost=0.27..2.29 rows=1 width=16) (never executed)

  • Output: timeoffapprovalnodes89.id, timeoffapprovalnodes89.timeoffid, timeoffapprovalnodes89.isapproved, timeoffapprovalnodes89.approverrole, timeoffapprovalnodes89.userid, timeoffapprovalnodes89.agentresolutionstate, timeoffapprovalnodes89.scriptid
  • Index Cond: (timeoffapprovalnodes89.timeoffid = timeoffs87.id)
232. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix2toaraidnid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest90 (cost=0.27..2.29 rows=1 width=16) (never executed)

  • Output: timeoffapprovalrequest90.approverid, timeoffapprovalrequest90.nodeid
  • Index Cond: (timeoffapprovalrequest90.approverid = 2042)
  • Heap Fetches: 0
233. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..4.59 rows=1 width=4) (never executed)

  • Output: timeoffapprovalnodes89_1.timeoffid
234. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix2toaraidnid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest90_1 (cost=0.27..2.29 rows=1 width=16) (never executed)

  • Output: timeoffapprovalrequest90_1.approverid, timeoffapprovalrequest90_1.nodeid
  • Index Cond: (timeoffapprovalrequest90_1.approverid = 2042)
  • Heap Fetches: 0
235. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes89_1 (cost=0.27..2.29 rows=1 width=20) (never executed)

  • Output: timeoffapprovalnodes89_1.id, timeoffapprovalnodes89_1.timeoffid, timeoffapprovalnodes89_1.isapproved, timeoffapprovalnodes89_1.approverrole, timeoffapprovalnodes89_1.userid, timeoffapprovalnodes89_1.agentresolutionstate, timeoffapprovalnodes89_1.scriptid
  • Index Cond: (timeoffapprovalnodes89_1.id = timeoffapprovalrequest90_1.nodeid)
236. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahtimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory91 (cost=0.42..3.11 rows=1 width=0) (never executed)

  • Index Cond: (timeoffapprovalhistory91.timeoffid = timeoffs87.id)
  • Filter: ((timeoffapprovalhistory91.userid = 2042) AND (timeoffapprovalhistory91.action = ANY ('{2,3,4}'::integer[])))
237. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahuserid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory91_1 (cost=0.42..29.92 rows=16 width=4) (never executed)

  • Output: timeoffapprovalhistory91_1.timeoffid
  • Index Cond: (timeoffapprovalhistory91_1.userid = 2042)
  • Filter: (timeoffapprovalhistory91_1.action = ANY ('{2,3,4}'::integer[]))
238. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=3.65..25,561.89 rows=141,540 width=4) (never executed)

  • Output: timeoffs92.id
  • Merge Cond: (timeoffs92.userid = userlocation93.userid)
  • Join Filter: ((userlocation93.startdate <= timeoffs92.enddate) AND (userlocation93.enddate >= timeoffs92.startdate))
  • Filter: ((hashed SubPlan 33) OR (hashed SubPlan 34))
239. 0.000 0.000 ↓ 0.0 0

Index Scan using ixto4userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs92 (cost=0.42..7,876.22 rows=188,720 width=16) (never executed)

  • Output: timeoffs92.id, timeoffs92.guidid, timeoffs92.userid, timeoffs92.createdbyuserid, timeoffs92.timeoffcodeid, timeoffs92.startdate, timeoffs92.enddate, timeoffs92.approvalstatus, timeoffs92.comments, timeoffs92.submittedonutc, timeoffs92.modifiedonutc, timeoffs92.info1, timeoffs92.info2, timeoffs92.info3, timeoffs92.info4, timeoffs92.info5, timeoffs92.startdurationtype, timeoffs92.enddurationtype, timeoffs92.startduration, timeoffs92.endduration, timeoffs92.startdatestarttime, timeoffs92.enddateendtime, timeoffs92.entryconfigurationmethod
240. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.41..1,350.82 rows=25,052 width=28) (never executed)

  • Output: userlocation93.userid, userlocation93.locationid, userlocation93.startdate, userlocation93.enddate
241. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ul_userlocationstartend on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userlocation userlocation93 (cost=0.41..1,288.19 rows=25,052 width=28) (never executed)

  • Output: userlocation93.userid, userlocation93.locationid, userlocation93.startdate, userlocation93.enddate
  • Heap Fetches: 0
242.          

SubPlan (forMerge Left Join)

243. 0.000 0.000 ↓ 0.0 0

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy94 (cost=0.28..1.29 rows=1 width=16) (never executed)

  • Output: locationflathierarchy94.childid
  • Index Cond: (locationflathierarchy94.parentid = 'a36334cb-1074-45dd-8c37-0a0241f0416b'::uuid)
  • Heap Fetches: 0
244. 0.000 0.000 ↓ 0.0 0

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy95 (cost=0.28..1.29 rows=1 width=16) (never executed)

  • Output: locationflathierarchy95.childid
  • Index Cond: (locationflathierarchy95.parentid = 'c3b4b88b-163d-4ff3-aff1-2c83b2bcd1a2'::uuid)
  • Heap Fetches: 0
245. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.53..18.68 rows=1 width=63) (never executed)

  • Output: upper(tsapprovalrequestkeyvalue96.uri)
246. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.25..14.33 rows=8 width=79) (never executed)

  • Output: tsapprovalrequestkeyvalue96.uri, tsapprovalrequestkeyvalue96.parentid
247. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.97..6.24 rows=1 width=4) (never executed)

  • Output: tsapprovalrequest99.id
248. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..4.59 rows=1 width=20) (never executed)

  • Output: timesheetapprovalnodes98.timesheetid, tsapprovalrequest99.id
249. 0.000 0.000 ↓ 0.0 0

Index Scan using uix2tsar_nodeid_userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequest tsapprovalrequest99 (cost=0.27..2.29 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest99.id, tsapprovalrequest99.effectivedateutc, tsapprovalrequest99.userid, tsapprovalrequest99.nodeid, tsapprovalrequest99.remindersentutc, tsapprovalrequest99.overduesentutc, tsapprovalrequest99.waitingbatchsentutc, tsapprovalrequest99.approvalagenttype, tsapprovalrequest99.systemprocessidentifier
  • Index Cond: (tsapprovalrequest99.userid = 2042)
250. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalnodes timesheetapprovalnodes98 (cost=0.28..2.29 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes98.id, timesheetapprovalnodes98.isapproved, timesheetapprovalnodes98.approverrole, timesheetapprovalnodes98.userid, timesheetapprovalnodes98.timesheetid, timesheetapprovalnodes98.systemprocessidentifier, timesheetapprovalnodes98.scriptid, timesheetapprovalnodes98.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes98.id = tsapprovalrequest99.nodeid)
251. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet97 (cost=0.42..1.63 rows=1 width=16) (never executed)

  • Output: timesheet97.id, timesheet97.userid, timesheet97.startdate, timesheet97.enddate, timesheet97.approvalstatus, timesheet97.duedate, timesheet97.autosubmitdatetimeutc, timesheet97.lastautosubmitattemptdatetimeutc, timesheet97.createdonutc
  • Index Cond: (timesheet97.id = timesheetapprovalnodes98.timesheetid)
  • Filter: ((timeoffs87.startdate <= timesheet97.enddate) AND (timeoffs87.enddate >= timesheet97.startdate) AND (timesheet97.userid = timeoffs87.userid))
252. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue96 (cost=0.28..8.01 rows=8 width=83) (never executed)

  • Output: tsapprovalrequestkeyvalue96.id, tsapprovalrequestkeyvalue96.tsapprovalrequestid, tsapprovalrequestkeyvalue96.parentid, tsapprovalrequestkeyvalue96.index, tsapprovalrequestkeyvalue96.key, tsapprovalrequestkeyvalue96.uri, tsapprovalrequestkeyvalue96.slug, tsapprovalrequestkeyvalue96."boolean", tsapprovalrequestkeyvalue96.date, tsapprovalrequestkeyvalue96.number, tsapprovalrequestkeyvalue96.text, tsapprovalrequestkeyvalue96."time", tsapprovalrequestkeyvalue96.timespan, tsapprovalrequestkeyvalue96.daterange_startdate, tsapprovalrequestkeyvalue96.daterange_enddate, tsapprovalrequestkeyvalue96.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue96.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue96.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue96.workdayduration_workdays, tsapprovalrequestkeyvalue96.workdayduration_hours, tsapprovalrequestkeyvalue96.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue96.tsapprovalrequestid = tsapprovalrequest99.id)
  • Filter: (upper(tsapprovalrequestkeyvalue96.key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
253. 0.000 0.000 ↓ 0.0 0

Index Scan using tsapprovalrequestkeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue100 (cost=0.28..0.53 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue100.id, tsapprovalrequestkeyvalue100.tsapprovalrequestid, tsapprovalrequestkeyvalue100.parentid, tsapprovalrequestkeyvalue100.index, tsapprovalrequestkeyvalue100.key, tsapprovalrequestkeyvalue100.uri, tsapprovalrequestkeyvalue100.slug, tsapprovalrequestkeyvalue100."boolean", tsapprovalrequestkeyvalue100.date, tsapprovalrequestkeyvalue100.number, tsapprovalrequestkeyvalue100.text, tsapprovalrequestkeyvalue100."time", tsapprovalrequestkeyvalue100.timespan, tsapprovalrequestkeyvalue100.daterange_startdate, tsapprovalrequestkeyvalue100.daterange_enddate, tsapprovalrequestkeyvalue100.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue100.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue100.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue100.workdayduration_workdays, tsapprovalrequestkeyvalue100.workdayduration_hours, tsapprovalrequestkeyvalue100.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue100.id = tsapprovalrequestkeyvalue96.parentid)
  • Filter: (tsapprovalrequestkeyvalue100.parentid IS NULL)
254. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.94..28.19 rows=1 width=69) (never executed)

  • Output: upper(heetapprovalhistorykeyvalue101.uri)
255. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.51..27.45 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue109.id
256. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.07..25.51 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue108.id
257. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10.64..24.81 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue107.id
258. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10.21..23.27 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue106.id
259. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.78..21.02 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue105.parentid
260. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.34..18.55 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue104.parentid
261. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.73..11.91 rows=1 width=16) (never executed)

  • Output: timesheetapprovalhistory103.id
262. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet102 (cost=0.42..3.23 rows=2 width=16) (never executed)

  • Output: timesheet102.id, timesheet102.userid, timesheet102.startdate, timesheet102.enddate, timesheet102.approvalstatus, timesheet102.duedate, timesheet102.autosubmitdatetimeutc, timesheet102.lastautosubmitattemptdatetimeutc, timesheet102.createdonutc
  • Index Cond: ((timesheet102.userid = timeoffs87.userid) AND (timeoffs87.enddate >= timesheet102.startdate) AND (timeoffs87.startdate <= timesheet102.enddate))
263. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory103 (cost=3.31..4.33 rows=1 width=32) (never executed)

  • Output: timesheetapprovalhistory103.id, timesheetapprovalhistory103.action, timesheetapprovalhistory103.approvalcomments, timesheetapprovalhistory103.timestamputc, timesheetapprovalhistory103.serialnumber, timesheetapprovalhistory103.timesheetid, timesheetapprovalhistory103.approvalagenttype, timesheetapprovalhistory103.userid, timesheetapprovalhistory103.systemprocessidentifier
  • Recheck Cond: ((timesheetapprovalhistory103.timesheetid = timesheet102.id) AND (timesheetapprovalhistory103.userid = 2042))
264. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.31..3.31 rows=1 width=0) (never executed)

265. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtah2timesheetid (cost=0.00..1.45 rows=4 width=0) (never executed)

  • Index Cond: (timesheetapprovalhistory103.timesheetid = timesheet102.id)
266. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahuserid (cost=0.00..1.60 rows=24 width=0) (never executed)

  • Index Cond: (timesheetapprovalhistory103.userid = 2042)
267. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue104 (cost=5.62..6.64 rows=1 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue104.id, heetapprovalhistorykeyvalue104.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue104.parentid, heetapprovalhistorykeyvalue104.index, heetapprovalhistorykeyvalue104.key, heetapprovalhistorykeyvalue104.uri, heetapprovalhistorykeyvalue104.slug, heetapprovalhistorykeyvalue104."boolean", heetapprovalhistorykeyvalue104.date, heetapprovalhistorykeyvalue104.number, heetapprovalhistorykeyvalue104.text, heetapprovalhistorykeyvalue104."time", heetapprovalhistorykeyvalue104.timespan, heetapprovalhistorykeyvalue104.daterange_startdate, heetapprovalhistorykeyvalue104.daterange_enddate, heetapprovalhistorykeyvalue104.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue104.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue104.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue104.workdayduration_workdays, heetapprovalhistorykeyvalue104.workdayduration_hours, heetapprovalhistorykeyvalue104.workdayduration_minutes
  • Recheck Cond: ((heetapprovalhistorykeyvalue104.timesheetapprovalhistoryid = timesheetapprovalhistory103.id) AND (upper(heetapprovalhistorykeyvalue104.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text))
  • Filter: (upper(heetapprovalhistorykeyvalue104.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
268. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=5.62..5.62 rows=1 width=0) (never executed)

269. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..1.62 rows=25 width=0) (never executed)

  • Index Cond: (heetapprovalhistorykeyvalue104.timesheetapprovalhistoryid = timesheetapprovalhistory103.id)
270. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahkvuri (cost=0.00..3.72 rows=155 width=0) (never executed)

  • Index Cond: (upper(heetapprovalhistorykeyvalue104.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text)
271. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue105 (cost=0.43..2.46 rows=1 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue105.id, heetapprovalhistorykeyvalue105.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue105.parentid, heetapprovalhistorykeyvalue105.index, heetapprovalhistorykeyvalue105.key, heetapprovalhistorykeyvalue105.uri, heetapprovalhistorykeyvalue105.slug, heetapprovalhistorykeyvalue105."boolean", heetapprovalhistorykeyvalue105.date, heetapprovalhistorykeyvalue105.number, heetapprovalhistorykeyvalue105.text, heetapprovalhistorykeyvalue105."time", heetapprovalhistorykeyvalue105.timespan, heetapprovalhistorykeyvalue105.daterange_startdate, heetapprovalhistorykeyvalue105.daterange_enddate, heetapprovalhistorykeyvalue105.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue105.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue105.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue105.workdayduration_workdays, heetapprovalhistorykeyvalue105.workdayduration_hours, heetapprovalhistorykeyvalue105.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue105.id = heetapprovalhistorykeyvalue104.parentid)
  • Filter: (upper(heetapprovalhistorykeyvalue105.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
272. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue106 (cost=0.43..2.24 rows=1 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue106.id, heetapprovalhistorykeyvalue106.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue106.parentid, heetapprovalhistorykeyvalue106.index, heetapprovalhistorykeyvalue106.key, heetapprovalhistorykeyvalue106.uri, heetapprovalhistorykeyvalue106.slug, heetapprovalhistorykeyvalue106."boolean", heetapprovalhistorykeyvalue106.date, heetapprovalhistorykeyvalue106.number, heetapprovalhistorykeyvalue106.text, heetapprovalhistorykeyvalue106."time", heetapprovalhistorykeyvalue106.timespan, heetapprovalhistorykeyvalue106.daterange_startdate, heetapprovalhistorykeyvalue106.daterange_enddate, heetapprovalhistorykeyvalue106.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue106.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue106.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue106.workdayduration_workdays, heetapprovalhistorykeyvalue106.workdayduration_hours, heetapprovalhistorykeyvalue106.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue106.parentid = heetapprovalhistorykeyvalue105.parentid)
  • Filter: (upper(heetapprovalhistorykeyvalue106.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
273. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue107 (cost=0.43..1.45 rows=10 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue107.id, heetapprovalhistorykeyvalue107.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue107.parentid, heetapprovalhistorykeyvalue107.index, heetapprovalhistorykeyvalue107.key, heetapprovalhistorykeyvalue107.uri, heetapprovalhistorykeyvalue107.slug, heetapprovalhistorykeyvalue107."boolean", heetapprovalhistorykeyvalue107.date, heetapprovalhistorykeyvalue107.number, heetapprovalhistorykeyvalue107.text, heetapprovalhistorykeyvalue107."time", heetapprovalhistorykeyvalue107.timespan, heetapprovalhistorykeyvalue107.daterange_startdate, heetapprovalhistorykeyvalue107.daterange_enddate, heetapprovalhistorykeyvalue107.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue107.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue107.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue107.workdayduration_workdays, heetapprovalhistorykeyvalue107.workdayduration_hours, heetapprovalhistorykeyvalue107.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue107.parentid = heetapprovalhistorykeyvalue106.id)
274. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue108 (cost=0.43..0.69 rows=1 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue108.id, heetapprovalhistorykeyvalue108.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue108.parentid, heetapprovalhistorykeyvalue108.index, heetapprovalhistorykeyvalue108.key, heetapprovalhistorykeyvalue108.uri, heetapprovalhistorykeyvalue108.slug, heetapprovalhistorykeyvalue108."boolean", heetapprovalhistorykeyvalue108.date, heetapprovalhistorykeyvalue108.number, heetapprovalhistorykeyvalue108.text, heetapprovalhistorykeyvalue108."time", heetapprovalhistorykeyvalue108.timespan, heetapprovalhistorykeyvalue108.daterange_startdate, heetapprovalhistorykeyvalue108.daterange_enddate, heetapprovalhistorykeyvalue108.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue108.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue108.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue108.workdayduration_workdays, heetapprovalhistorykeyvalue108.workdayduration_hours, heetapprovalhistorykeyvalue108.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue108.parentid = heetapprovalhistorykeyvalue107.id)
  • Filter: (upper(heetapprovalhistorykeyvalue108.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
275. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue109 (cost=0.43..1.84 rows=10 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue109.id, heetapprovalhistorykeyvalue109.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue109.parentid, heetapprovalhistorykeyvalue109.index, heetapprovalhistorykeyvalue109.key, heetapprovalhistorykeyvalue109.uri, heetapprovalhistorykeyvalue109.slug, heetapprovalhistorykeyvalue109."boolean", heetapprovalhistorykeyvalue109.date, heetapprovalhistorykeyvalue109.number, heetapprovalhistorykeyvalue109.text, heetapprovalhistorykeyvalue109."time", heetapprovalhistorykeyvalue109.timespan, heetapprovalhistorykeyvalue109.daterange_startdate, heetapprovalhistorykeyvalue109.daterange_enddate, heetapprovalhistorykeyvalue109.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue109.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue109.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue109.workdayduration_workdays, heetapprovalhistorykeyvalue109.workdayduration_hours, heetapprovalhistorykeyvalue109.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue109.parentid = heetapprovalhistorykeyvalue108.id)
276. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue101 (cost=0.43..0.64 rows=10 width=85) (never executed)

  • Output: heetapprovalhistorykeyvalue101.id, heetapprovalhistorykeyvalue101.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue101.parentid, heetapprovalhistorykeyvalue101.index, heetapprovalhistorykeyvalue101.key, heetapprovalhistorykeyvalue101.uri, heetapprovalhistorykeyvalue101.slug, heetapprovalhistorykeyvalue101."boolean", heetapprovalhistorykeyvalue101.date, heetapprovalhistorykeyvalue101.number, heetapprovalhistorykeyvalue101.text, heetapprovalhistorykeyvalue101."time", heetapprovalhistorykeyvalue101.timespan, heetapprovalhistorykeyvalue101.daterange_startdate, heetapprovalhistorykeyvalue101.daterange_enddate, heetapprovalhistorykeyvalue101.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue101.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue101.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue101.workdayduration_workdays, heetapprovalhistorykeyvalue101.workdayduration_hours, heetapprovalhistorykeyvalue101.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue101.parentid = heetapprovalhistorykeyvalue109.id)
277. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.53..9.86 rows=1 width=63) (never executed)

  • Output: upper(tsapprovalrequestkeyvalue110.uri)
278. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.25..7.55 rows=1 width=79) (never executed)

  • Output: tsapprovalrequestkeyvalue110.uri, tsapprovalrequestkeyvalue110.parentid
  • Join Filter: (tsapprovalrequest113.id = tsapprovalrequestkeyvalue110.tsapprovalrequestid)
279. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.97..6.24 rows=1 width=4) (never executed)

  • Output: tsapprovalrequest113.id
280. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..4.59 rows=1 width=20) (never executed)

  • Output: timesheetapprovalnodes112.timesheetid, tsapprovalrequest113.id
281. 0.000 0.000 ↓ 0.0 0

Index Scan using uix2tsar_nodeid_userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequest tsapprovalrequest113 (cost=0.27..2.29 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest113.id, tsapprovalrequest113.effectivedateutc, tsapprovalrequest113.userid, tsapprovalrequest113.nodeid, tsapprovalrequest113.remindersentutc, tsapprovalrequest113.overduesentutc, tsapprovalrequest113.waitingbatchsentutc, tsapprovalrequest113.approvalagenttype, tsapprovalrequest113.systemprocessidentifier
  • Index Cond: (tsapprovalrequest113.userid = 2042)
282. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalnodes timesheetapprovalnodes112 (cost=0.28..2.29 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes112.id, timesheetapprovalnodes112.isapproved, timesheetapprovalnodes112.approverrole, timesheetapprovalnodes112.userid, timesheetapprovalnodes112.timesheetid, timesheetapprovalnodes112.systemprocessidentifier, timesheetapprovalnodes112.scriptid, timesheetapprovalnodes112.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes112.id = tsapprovalrequest113.nodeid)
283. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet111 (cost=0.42..1.63 rows=1 width=16) (never executed)

  • Output: timesheet111.id, timesheet111.userid, timesheet111.startdate, timesheet111.enddate, timesheet111.approvalstatus, timesheet111.duedate, timesheet111.autosubmitdatetimeutc, timesheet111.lastautosubmitattemptdatetimeutc, timesheet111.createdonutc
  • Index Cond: (timesheet111.id = timesheetapprovalnodes112.timesheetid)
  • Filter: ((timeoffs87.startdate <= timesheet111.enddate) AND (timeoffs87.enddate >= timesheet111.startdate) AND (timesheet111.userid = timeoffs87.userid))
284. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue110 (cost=0.28..1.30 rows=1 width=83) (never executed)

  • Output: tsapprovalrequestkeyvalue110.id, tsapprovalrequestkeyvalue110.tsapprovalrequestid, tsapprovalrequestkeyvalue110.parentid, tsapprovalrequestkeyvalue110.index, tsapprovalrequestkeyvalue110.key, tsapprovalrequestkeyvalue110.uri, tsapprovalrequestkeyvalue110.slug, tsapprovalrequestkeyvalue110."boolean", tsapprovalrequestkeyvalue110.date, tsapprovalrequestkeyvalue110.number, tsapprovalrequestkeyvalue110.text, tsapprovalrequestkeyvalue110."time", tsapprovalrequestkeyvalue110.timespan, tsapprovalrequestkeyvalue110.daterange_startdate, tsapprovalrequestkeyvalue110.daterange_enddate, tsapprovalrequestkeyvalue110.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue110.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue110.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue110.workdayduration_workdays, tsapprovalrequestkeyvalue110.workdayduration_hours, tsapprovalrequestkeyvalue110.workdayduration_minutes
  • Index Cond: (upper(tsapprovalrequestkeyvalue110.key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
285. 0.000 0.000 ↓ 0.0 0

Index Scan using tsapprovalrequestkeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue114 (cost=0.28..2.30 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue114.id, tsapprovalrequestkeyvalue114.tsapprovalrequestid, tsapprovalrequestkeyvalue114.parentid, tsapprovalrequestkeyvalue114.index, tsapprovalrequestkeyvalue114.key, tsapprovalrequestkeyvalue114.uri, tsapprovalrequestkeyvalue114.slug, tsapprovalrequestkeyvalue114."boolean", tsapprovalrequestkeyvalue114.date, tsapprovalrequestkeyvalue114.number, tsapprovalrequestkeyvalue114.text, tsapprovalrequestkeyvalue114."time", tsapprovalrequestkeyvalue114.timespan, tsapprovalrequestkeyvalue114.daterange_startdate, tsapprovalrequestkeyvalue114.daterange_enddate, tsapprovalrequestkeyvalue114.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue114.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue114.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue114.workdayduration_workdays, tsapprovalrequestkeyvalue114.workdayduration_hours, tsapprovalrequestkeyvalue114.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue114.id = tsapprovalrequestkeyvalue110.parentid)
  • Filter: (tsapprovalrequestkeyvalue114.parentid IS NULL)
286. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.94..37.92 rows=1 width=69) (never executed)

  • Output: upper(heetapprovalhistorykeyvalue115.uri)
287. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.51..37.18 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue123.id
288. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.07..25.51 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue122.id
289. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10.64..24.81 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue121.id
290. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10.21..23.27 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue120.id
291. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.78..21.02 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue119.parentid
292. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.34..18.55 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue118.parentid
293. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.73..11.91 rows=1 width=16) (never executed)

  • Output: timesheetapprovalhistory117.id
294. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet116 (cost=0.42..3.23 rows=2 width=16) (never executed)

  • Output: timesheet116.id, timesheet116.userid, timesheet116.startdate, timesheet116.enddate, timesheet116.approvalstatus, timesheet116.duedate, timesheet116.autosubmitdatetimeutc, timesheet116.lastautosubmitattemptdatetimeutc, timesheet116.createdonutc
  • Index Cond: ((timesheet116.userid = timeoffs87.userid) AND (timeoffs87.enddate >= timesheet116.startdate) AND (timeoffs87.startdate <= timesheet116.enddate))
295. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory117 (cost=3.31..4.33 rows=1 width=32) (never executed)

  • Output: timesheetapprovalhistory117.id, timesheetapprovalhistory117.action, timesheetapprovalhistory117.approvalcomments, timesheetapprovalhistory117.timestamputc, timesheetapprovalhistory117.serialnumber, timesheetapprovalhistory117.timesheetid, timesheetapprovalhistory117.approvalagenttype, timesheetapprovalhistory117.userid, timesheetapprovalhistory117.systemprocessidentifier
  • Recheck Cond: ((timesheetapprovalhistory117.timesheetid = timesheet116.id) AND (timesheetapprovalhistory117.userid = 2042))
296. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=3.31..3.31 rows=1 width=0) (never executed)

297. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtah2timesheetid (cost=0.00..1.45 rows=4 width=0) (never executed)

  • Index Cond: (timesheetapprovalhistory117.timesheetid = timesheet116.id)
298. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahuserid (cost=0.00..1.60 rows=24 width=0) (never executed)

  • Index Cond: (timesheetapprovalhistory117.userid = 2042)
299. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue118 (cost=5.62..6.64 rows=1 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue118.id, heetapprovalhistorykeyvalue118.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue118.parentid, heetapprovalhistorykeyvalue118.index, heetapprovalhistorykeyvalue118.key, heetapprovalhistorykeyvalue118.uri, heetapprovalhistorykeyvalue118.slug, heetapprovalhistorykeyvalue118."boolean", heetapprovalhistorykeyvalue118.date, heetapprovalhistorykeyvalue118.number, heetapprovalhistorykeyvalue118.text, heetapprovalhistorykeyvalue118."time", heetapprovalhistorykeyvalue118.timespan, heetapprovalhistorykeyvalue118.daterange_startdate, heetapprovalhistorykeyvalue118.daterange_enddate, heetapprovalhistorykeyvalue118.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue118.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue118.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue118.workdayduration_workdays, heetapprovalhistorykeyvalue118.workdayduration_hours, heetapprovalhistorykeyvalue118.workdayduration_minutes
  • Recheck Cond: ((heetapprovalhistorykeyvalue118.timesheetapprovalhistoryid = timesheetapprovalhistory117.id) AND (upper(heetapprovalhistorykeyvalue118.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text))
  • Filter: (upper(heetapprovalhistorykeyvalue118.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
300. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=5.62..5.62 rows=1 width=0) (never executed)

301. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..1.62 rows=25 width=0) (never executed)

  • Index Cond: (heetapprovalhistorykeyvalue118.timesheetapprovalhistoryid = timesheetapprovalhistory117.id)
302. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahkvuri (cost=0.00..3.72 rows=155 width=0) (never executed)

  • Index Cond: (upper(heetapprovalhistorykeyvalue118.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text)
303. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue119 (cost=0.43..2.46 rows=1 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue119.id, heetapprovalhistorykeyvalue119.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue119.parentid, heetapprovalhistorykeyvalue119.index, heetapprovalhistorykeyvalue119.key, heetapprovalhistorykeyvalue119.uri, heetapprovalhistorykeyvalue119.slug, heetapprovalhistorykeyvalue119."boolean", heetapprovalhistorykeyvalue119.date, heetapprovalhistorykeyvalue119.number, heetapprovalhistorykeyvalue119.text, heetapprovalhistorykeyvalue119."time", heetapprovalhistorykeyvalue119.timespan, heetapprovalhistorykeyvalue119.daterange_startdate, heetapprovalhistorykeyvalue119.daterange_enddate, heetapprovalhistorykeyvalue119.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue119.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue119.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue119.workdayduration_workdays, heetapprovalhistorykeyvalue119.workdayduration_hours, heetapprovalhistorykeyvalue119.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue119.id = heetapprovalhistorykeyvalue118.parentid)
  • Filter: (upper(heetapprovalhistorykeyvalue119.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
304. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue120 (cost=0.43..2.24 rows=1 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue120.id, heetapprovalhistorykeyvalue120.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue120.parentid, heetapprovalhistorykeyvalue120.index, heetapprovalhistorykeyvalue120.key, heetapprovalhistorykeyvalue120.uri, heetapprovalhistorykeyvalue120.slug, heetapprovalhistorykeyvalue120."boolean", heetapprovalhistorykeyvalue120.date, heetapprovalhistorykeyvalue120.number, heetapprovalhistorykeyvalue120.text, heetapprovalhistorykeyvalue120."time", heetapprovalhistorykeyvalue120.timespan, heetapprovalhistorykeyvalue120.daterange_startdate, heetapprovalhistorykeyvalue120.daterange_enddate, heetapprovalhistorykeyvalue120.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue120.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue120.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue120.workdayduration_workdays, heetapprovalhistorykeyvalue120.workdayduration_hours, heetapprovalhistorykeyvalue120.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue120.parentid = heetapprovalhistorykeyvalue119.parentid)
  • Filter: (upper(heetapprovalhistorykeyvalue120.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
305. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue121 (cost=0.43..1.45 rows=10 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue121.id, heetapprovalhistorykeyvalue121.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue121.parentid, heetapprovalhistorykeyvalue121.index, heetapprovalhistorykeyvalue121.key, heetapprovalhistorykeyvalue121.uri, heetapprovalhistorykeyvalue121.slug, heetapprovalhistorykeyvalue121."boolean", heetapprovalhistorykeyvalue121.date, heetapprovalhistorykeyvalue121.number, heetapprovalhistorykeyvalue121.text, heetapprovalhistorykeyvalue121."time", heetapprovalhistorykeyvalue121.timespan, heetapprovalhistorykeyvalue121.daterange_startdate, heetapprovalhistorykeyvalue121.daterange_enddate, heetapprovalhistorykeyvalue121.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue121.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue121.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue121.workdayduration_workdays, heetapprovalhistorykeyvalue121.workdayduration_hours, heetapprovalhistorykeyvalue121.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue121.parentid = heetapprovalhistorykeyvalue120.id)
306. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue122 (cost=0.43..0.69 rows=1 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue122.id, heetapprovalhistorykeyvalue122.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue122.parentid, heetapprovalhistorykeyvalue122.index, heetapprovalhistorykeyvalue122.key, heetapprovalhistorykeyvalue122.uri, heetapprovalhistorykeyvalue122.slug, heetapprovalhistorykeyvalue122."boolean", heetapprovalhistorykeyvalue122.date, heetapprovalhistorykeyvalue122.number, heetapprovalhistorykeyvalue122.text, heetapprovalhistorykeyvalue122."time", heetapprovalhistorykeyvalue122.timespan, heetapprovalhistorykeyvalue122.daterange_startdate, heetapprovalhistorykeyvalue122.daterange_enddate, heetapprovalhistorykeyvalue122.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue122.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue122.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue122.workdayduration_workdays, heetapprovalhistorykeyvalue122.workdayduration_hours, heetapprovalhistorykeyvalue122.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue122.parentid = heetapprovalhistorykeyvalue121.id)
  • Filter: (upper(heetapprovalhistorykeyvalue122.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
307. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue123 (cost=0.43..11.57 rows=10 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue123.id, heetapprovalhistorykeyvalue123.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue123.parentid, heetapprovalhistorykeyvalue123.index, heetapprovalhistorykeyvalue123.key, heetapprovalhistorykeyvalue123.uri, heetapprovalhistorykeyvalue123.slug, heetapprovalhistorykeyvalue123."boolean", heetapprovalhistorykeyvalue123.date, heetapprovalhistorykeyvalue123.number, heetapprovalhistorykeyvalue123.text, heetapprovalhistorykeyvalue123."time", heetapprovalhistorykeyvalue123.timespan, heetapprovalhistorykeyvalue123.daterange_startdate, heetapprovalhistorykeyvalue123.daterange_enddate, heetapprovalhistorykeyvalue123.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue123.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue123.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue123.workdayduration_workdays, heetapprovalhistorykeyvalue123.workdayduration_hours, heetapprovalhistorykeyvalue123.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue123.parentid = heetapprovalhistorykeyvalue122.id)
308. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue115 (cost=0.43..0.64 rows=10 width=85) (never executed)

  • Output: heetapprovalhistorykeyvalue115.id, heetapprovalhistorykeyvalue115.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue115.parentid, heetapprovalhistorykeyvalue115.index, heetapprovalhistorykeyvalue115.key, heetapprovalhistorykeyvalue115.uri, heetapprovalhistorykeyvalue115.slug, heetapprovalhistorykeyvalue115."boolean", heetapprovalhistorykeyvalue115.date, heetapprovalhistorykeyvalue115.number, heetapprovalhistorykeyvalue115.text, heetapprovalhistorykeyvalue115."time", heetapprovalhistorykeyvalue115.timespan, heetapprovalhistorykeyvalue115.daterange_startdate, heetapprovalhistorykeyvalue115.daterange_enddate, heetapprovalhistorykeyvalue115.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue115.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue115.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue115.workdayduration_workdays, heetapprovalhistorykeyvalue115.workdayduration_hours, heetapprovalhistorykeyvalue115.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue115.parentid = heetapprovalhistorykeyvalue123.id)
309. 0.012 28,357.087 ↑ 1.0 1 1

Aggregate (cost=26,053,225.58..26,053,225.59 rows=1 width=0) (actual time=28,357.086..28,357.087 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=15296505
310. 0.027 28,357.075 ↑ 101.9 7 1

Nested Loop Semi Join (cost=100,870.20..26,053,223.80 rows=713 width=0) (actual time=28,022.962..28,357.075 rows=7 loops=1)

  • Join Filter: ("*SELECT* 1_4".timeoffid = timeoffs167.id)
  • Buffers: shared hit=15296505
311. 4.591 28,356.859 ↑ 203.7 7 1

Merge Semi Join (cost=100,866.36..26,047,530.79 rows=1,426 width=8) (actual time=28,022.896..28,356.859 rows=7 loops=1)

  • Output: "*SELECT* 1_4".timeoffid, timeoffs130.id
  • Merge Cond: ("*SELECT* 1_4".timeoffid = timeoffs130.id)
  • Buffers: shared hit=15296427
312. 0.282 108.051 ↑ 8.4 338 1

Sort (cost=74,949.91..74,957.04 rows=2,851 width=4) (actual time=107.923..108.051 rows=338 loops=1)

  • Output: "*SELECT* 1_4".timeoffid
  • Sort Key: "*SELECT* 1_4".timeoffid
  • Sort Method: quicksort Memory: 40kB
  • Buffers: shared hit=70814
313. 0.153 107.769 ↑ 8.4 338 1

Append (cost=150.52..74,786.30 rows=2,851 width=4) (actual time=1.204..107.769 rows=338 loops=1)

  • Buffers: shared hit=70814
314. 0.153 106.463 ↑ 9.3 301 1

Subquery Scan on *SELECT* 1_4 (cost=150.52..74,323.17 rows=2,792 width=4) (actual time=1.203..106.463 rows=301 loops=1)

  • Output: "*SELECT* 1_4".timeoffid
  • Buffers: shared hit=70388
315. 0.338 106.310 ↑ 9.3 301 1

Hash Anti Join (cost=150.52..74,295.25 rows=2,792 width=4) (actual time=1.203..106.310 rows=301 loops=1)

  • Output: dm_timeofflist_facts_4.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Hash Cond: (dm_timeofflist_facts_4.timeoffid = dm_timeofflist_realtime_facts_8.timeoffid)
  • Buffers: shared hit=70388
316. 104.914 104.914 ↑ 8.3 338 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_facts dm_timeofflist_facts_4 (cost=0.00..74,109.38 rows=2,819 width=4) (actual time=0.124..104.914 rows=338 loops=1)

  • Output: dm_timeofflist_facts_4.timeoffid, dm_timeofflist_facts_4.timeoffslug, dm_timeofflist_facts_4.timeoffowneruserid, dm_timeofflist_facts_4.timeoffowneruserdisplayname, dm_timeofflist_facts_4.timeoffowneruserslug, dm_timeofflist_facts_4.timeoffowneruserenabled, dm_timeofflist_facts_4.timeoffownerdepartmentid, dm_timeofflist_facts_4.timeoffownerdepartmentdisplayname, dm_timeofflist_facts_4.timeoffownerdepartmentslug, dm_timeofflist_facts_4.timeoffownersupervisoruserid, dm_timeofflist_facts_4.timeoffownersupervisoruserdisplayname, dm_timeofflist_facts_4.timeoffownersupervisoruserslug, dm_timeofflist_facts_4.timeoffcodeid, dm_timeofflist_facts_4.timeoffcodedisplayname, dm_timeofflist_facts_4.timeoffcodeslug, dm_timeofflist_facts_4.approvalstatus, dm_timeofflist_facts_4.timeoffstatus, dm_timeofflist_facts_4.startdate, dm_timeofflist_facts_4.enddate, dm_timeofflist_facts_4.startdaydurationtype, dm_timeofflist_facts_4.enddaydurationtype, dm_timeofflist_facts_4.startdayduration, dm_timeofflist_facts_4.enddayduration, dm_timeofflist_facts_4.startdaystarttime, dm_timeofflist_facts_4.enddayendtime, dm_timeofflist_facts_4.totalduration, dm_timeofflist_facts_4.effectivehoursperday, dm_timeofflist_facts_4.lastactiondatetimeutc, dm_timeofflist_facts_4.waitingonapproveruserid, dm_timeofflist_facts_4.waitingonapproveruserslug, dm_timeofflist_facts_4.waitingonapproveruserdisplayname, dm_timeofflist_facts_4.generatedonutc, dm_timeofflist_facts_4.timeoffowneruseremployeeid, dm_timeofflist_facts_4.timeoffowneruserloginname, dm_timeofflist_facts_4.totalworkdayduration, dm_timeofflist_facts_4.displayformat
  • Filter: ((dm_timeofflist_facts_4.timeoffcodeid <> 34) AND (dm_timeofflist_facts_4.startdate <= '2019-10-05'::date) AND (dm_timeofflist_facts_4.enddate >= '2019-09-29'::date) AND (dm_timeofflist_facts_4.timeoffstatus = 2))
  • Rows Removed by Filter: 188382
  • Buffers: shared hit=70335
317. 0.543 1.058 ↑ 1.0 1,827 1

Hash (cost=127.68..127.68 rows=1,827 width=4) (actual time=1.058..1.058 rows=1,827 loops=1)

  • Output: dm_timeofflist_realtime_facts_8.timeoffid
  • Buckets: 2048 Batches: 1 Memory Usage: 81kB
  • Buffers: shared hit=53
318. 0.515 0.515 ↑ 1.0 1,827 1

Index Only Scan using dm_timeofflist_realtime_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_8 (cost=0.28..127.68 rows=1,827 width=4) (actual time=0.005..0.515 rows=1,827 loops=1)

  • Output: dm_timeofflist_realtime_facts_8.timeoffid
  • Heap Fetches: 55
  • Buffers: shared hit=53
319. 0.014 1.153 ↑ 1.6 37 1

Subquery Scan on *SELECT* 2_4 (cost=0.00..463.13 rows=59 width=4) (actual time=0.034..1.153 rows=37 loops=1)

  • Output: "*SELECT* 2_4".timeoffid
  • Buffers: shared hit=426
320. 1.139 1.139 ↑ 1.6 37 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_9 (cost=0.00..462.54 rows=59 width=4) (actual time=0.033..1.139 rows=37 loops=1)

  • Output: dm_timeofflist_realtime_facts_9.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Filter: ((NOT dm_timeofflist_realtime_facts_9.deleted) AND (dm_timeofflist_realtime_facts_9.timeoffcodeid <> 34) AND (dm_timeofflist_realtime_facts_9.startdate <= '2019-10-05'::date) AND (dm_timeofflist_realtime_facts_9.enddate >= '2019-09-29'::date) AND (dm_timeofflist_realtime_facts_9.timeoffstatus = 2))
  • Rows Removed by Filter: 1790
  • Buffers: shared hit=426
321. 7.425 28,244.217 ↑ 39.0 13,682 1

Materialize (cost=25,916.45..25,971,153.27 rows=533,126 width=4) (actual time=610.349..28,244.217 rows=13,682 loops=1)

  • Output: timeoffs130.id
  • Buffers: shared hit=15225613
322. 2,202.108 28,236.792 ↑ 39.0 13,682 1

Nested Loop Left Join (cost=25,916.45..25,969,820.46 rows=533,126 width=4) (actual time=610.341..28,236.792 rows=13,682 loops=1)

  • Output: timeoffs130.id
  • Filter: (((userhierarchy131.supervisorid = 2042) AND ((userhierarchy131.startdate IS NULL) OR (userhierarchy131.startdate <= '2019-10-03'::date)) AND ((userhierarchy131.enddate IS NULL) OR (userhierarchy131.enddate >= '2019-10-03'::date))) OR (alternatives: SubPlan 43 or hashed SubPlan 44) OR (alternatives: SubPlan 45 or hashed SubPlan 46) OR (hashed SubPlan 49) OR (SubPlan 50) OR (SubPlan 51) OR (SubPlan 52) OR (SubPlan 53))
  • Rows Removed by Filter: 599145
  • Buffers: shared hit=15225613
323. 203.489 203.489 ↑ 1.0 188,715 1

Index Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs130 (cost=0.42..7,602.22 rows=188,720 width=16) (actual time=0.017..203.489 rows=188,715 loops=1)

  • Output: timeoffs130.id, timeoffs130.guidid, timeoffs130.userid, timeoffs130.createdbyuserid, timeoffs130.timeoffcodeid, timeoffs130.startdate, timeoffs130.enddate, timeoffs130.approvalstatus, timeoffs130.comments, timeoffs130.submittedonutc, timeoffs130.modifiedonutc, timeoffs130.info1, timeoffs130.info2, timeoffs130.info3, timeoffs130.info4, timeoffs130.info5, timeoffs130.startdurationtype, timeoffs130.enddurationtype, timeoffs130.startduration, timeoffs130.endduration, timeoffs130.startdatestarttime, timeoffs130.enddateendtime, timeoffs130.entryconfigurationmethod
  • Buffers: shared hit=125046
324. 754.860 754.860 ↓ 1.5 3 188,715

Index Scan using ix3uh_usersuperstart on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userhierarchy userhierarchy131 (cost=0.29..0.32 rows=2 width=24) (actual time=0.003..0.004 rows=3 loops=188,715)

  • Output: userhierarchy131.id, userhierarchy131.userid, userhierarchy131.supervisorid, userhierarchy131.startdate, userhierarchy131.enddate
  • Index Cond: (userhierarchy131.userid = timeoffs130.userid)
  • Buffers: shared hit=579845
325.          

SubPlan (forNested Loop Left Join)

326. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..4.59 rows=1 width=0) (never executed)

  • Join Filter: (timeoffapprovalnodes132.id = timeoffapprovalrequest133.nodeid)
327. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoantimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes132 (cost=0.27..2.29 rows=1 width=16) (never executed)

  • Output: timeoffapprovalnodes132.id, timeoffapprovalnodes132.timeoffid, timeoffapprovalnodes132.isapproved, timeoffapprovalnodes132.approverrole, timeoffapprovalnodes132.userid, timeoffapprovalnodes132.agentresolutionstate, timeoffapprovalnodes132.scriptid
  • Index Cond: (timeoffapprovalnodes132.timeoffid = timeoffs130.id)
328. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix2toaraidnid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest133 (cost=0.27..2.29 rows=1 width=16) (never executed)

  • Output: timeoffapprovalrequest133.approverid, timeoffapprovalrequest133.nodeid
  • Index Cond: (timeoffapprovalrequest133.approverid = 2042)
  • Heap Fetches: 0
329. 0.002 0.007 ↓ 0.0 0 1

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

  • Output: timeoffapprovalnodes132_1.timeoffid
  • Buffers: shared hit=2
330. 0.005 0.005 ↓ 0.0 0 1

Index Only Scan using uix2toaraidnid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest133_1 (cost=0.27..2.29 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: timeoffapprovalrequest133_1.approverid, timeoffapprovalrequest133_1.nodeid
  • Index Cond: (timeoffapprovalrequest133_1.approverid = 2042)
  • Heap Fetches: 0
  • Buffers: shared hit=2
331. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes132_1 (cost=0.27..2.29 rows=1 width=20) (never executed)

  • Output: timeoffapprovalnodes132_1.id, timeoffapprovalnodes132_1.timeoffid, timeoffapprovalnodes132_1.isapproved, timeoffapprovalnodes132_1.approverrole, timeoffapprovalnodes132_1.userid, timeoffapprovalnodes132_1.agentresolutionstate, timeoffapprovalnodes132_1.scriptid
  • Index Cond: (timeoffapprovalnodes132_1.id = timeoffapprovalrequest133_1.nodeid)
332. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahtimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory134 (cost=0.42..3.11 rows=1 width=0) (never executed)

  • Index Cond: (timeoffapprovalhistory134.timeoffid = timeoffs130.id)
  • Filter: ((timeoffapprovalhistory134.userid = 2042) AND (timeoffapprovalhistory134.action = ANY ('{2,3,4}'::integer[])))
333. 0.094 0.094 ↑ 1.0 16 1

Index Scan using ixtoahuserid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory134_1 (cost=0.42..29.92 rows=16 width=4) (actual time=0.019..0.094 rows=16 loops=1)

  • Output: timeoffapprovalhistory134_1.timeoffid
  • Index Cond: (timeoffapprovalhistory134_1.userid = 2042)
  • Filter: (timeoffapprovalhistory134_1.action = ANY ('{2,3,4}'::integer[]))
  • Rows Removed by Filter: 42
  • Buffers: shared hit=50
334. 247.505 510.197 ↑ 40.4 3,500 1

Merge Left Join (cost=3.65..25,561.89 rows=141,540 width=4) (actual time=111.095..510.197 rows=3,500 loops=1)

  • Output: timeoffs135.id
  • Merge Cond: (timeoffs135.userid = userlocation136.userid)
  • Join Filter: ((userlocation136.startdate <= timeoffs135.enddate) AND (userlocation136.enddate >= timeoffs135.startdate))
  • Rows Removed by Join Filter: 259331
  • Filter: ((hashed SubPlan 47) OR (hashed SubPlan 48))
  • Rows Removed by Filter: 185279
  • Buffers: shared hit=172080
335. 153.304 153.304 ↑ 1.0 188,720 1

Index Scan using ixto4userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs135 (cost=0.42..7,876.22 rows=188,720 width=16) (actual time=0.011..153.304 rows=188,720 loops=1)

  • Output: timeoffs135.id, timeoffs135.guidid, timeoffs135.userid, timeoffs135.createdbyuserid, timeoffs135.timeoffcodeid, timeoffs135.startdate, timeoffs135.enddate, timeoffs135.approvalstatus, timeoffs135.comments, timeoffs135.submittedonutc, timeoffs135.modifiedonutc, timeoffs135.info1, timeoffs135.info2, timeoffs135.info3, timeoffs135.info4, timeoffs135.info5, timeoffs135.startdurationtype, timeoffs135.enddurationtype, timeoffs135.startduration, timeoffs135.endduration, timeoffs135.startdatestarttime, timeoffs135.enddateendtime, timeoffs135.entryconfigurationmethod
  • Buffers: shared hit=171820
336. 101.968 109.378 ↓ 18.4 460,067 1

Materialize (cost=0.41..1,350.82 rows=25,052 width=28) (actual time=0.017..109.378 rows=460,067 loops=1)

  • Output: userlocation136.userid, userlocation136.locationid, userlocation136.startdate, userlocation136.enddate
  • Buffers: shared hit=254
337. 7.410 7.410 ↑ 1.0 25,049 1

Index Only Scan using ix4ul_userlocationstartend on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userlocation userlocation136 (cost=0.41..1,288.19 rows=25,052 width=28) (actual time=0.013..7.410 rows=25,049 loops=1)

  • Output: userlocation136.userid, userlocation136.locationid, userlocation136.startdate, userlocation136.enddate
  • Heap Fetches: 0
  • Buffers: shared hit=254
338.          

SubPlan (forMerge Left Join)

339. 0.006 0.006 ↑ 1.0 1 1

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy137 (cost=0.28..1.29 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=1)

  • Output: locationflathierarchy137.childid
  • Index Cond: (locationflathierarchy137.parentid = 'a36334cb-1074-45dd-8c37-0a0241f0416b'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
340. 0.004 0.004 ↑ 1.0 1 1

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy138 (cost=0.28..1.29 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=1)

  • Output: locationflathierarchy138.childid
  • Index Cond: (locationflathierarchy138.parentid = 'c3b4b88b-163d-4ff3-aff1-2c83b2bcd1a2'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
341. 0.000 1,797.591 ↓ 0.0 0 599,197

Nested Loop (cost=1.53..18.68 rows=1 width=63) (actual time=0.003..0.003 rows=0 loops=599,197)

  • Output: upper(tsapprovalrequestkeyvalue139.uri)
  • Buffers: shared hit=1198394
342. 599.197 1,797.591 ↓ 0.0 0 599,197

Nested Loop (cost=1.25..14.33 rows=8 width=79) (actual time=0.003..0.003 rows=0 loops=599,197)

  • Output: tsapprovalrequestkeyvalue139.uri, tsapprovalrequestkeyvalue139.parentid
  • Buffers: shared hit=1198394
343. 599.197 1,198.394 ↓ 0.0 0 599,197

Nested Loop (cost=0.97..6.24 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=599,197)

  • Output: tsapprovalrequest142.id
  • Buffers: shared hit=1198394
344. 0.000 599.197 ↓ 0.0 0 599,197

Nested Loop (cost=0.55..4.59 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=599,197)

  • Output: timesheetapprovalnodes141.timesheetid, tsapprovalrequest142.id
  • Buffers: shared hit=1198394
345. 599.197 599.197 ↓ 0.0 0 599,197

Index Scan using uix2tsar_nodeid_userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequest tsapprovalrequest142 (cost=0.27..2.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=599,197)

  • Output: tsapprovalrequest142.id, tsapprovalrequest142.effectivedateutc, tsapprovalrequest142.userid, tsapprovalrequest142.nodeid, tsapprovalrequest142.remindersentutc, tsapprovalrequest142.overduesentutc, tsapprovalrequest142.waitingbatchsentutc, tsapprovalrequest142.approvalagenttype, tsapprovalrequest142.systemprocessidentifier
  • Index Cond: (tsapprovalrequest142.userid = 2042)
  • Buffers: shared hit=1198394
346. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalnodes timesheetapprovalnodes141 (cost=0.28..2.29 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes141.id, timesheetapprovalnodes141.isapproved, timesheetapprovalnodes141.approverrole, timesheetapprovalnodes141.userid, timesheetapprovalnodes141.timesheetid, timesheetapprovalnodes141.systemprocessidentifier, timesheetapprovalnodes141.scriptid, timesheetapprovalnodes141.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes141.id = tsapprovalrequest142.nodeid)
347. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet140 (cost=0.42..1.63 rows=1 width=16) (never executed)

  • Output: timesheet140.id, timesheet140.userid, timesheet140.startdate, timesheet140.enddate, timesheet140.approvalstatus, timesheet140.duedate, timesheet140.autosubmitdatetimeutc, timesheet140.lastautosubmitattemptdatetimeutc, timesheet140.createdonutc
  • Index Cond: (timesheet140.id = timesheetapprovalnodes141.timesheetid)
  • Filter: ((timeoffs130.startdate <= timesheet140.enddate) AND (timeoffs130.enddate >= timesheet140.startdate) AND (timesheet140.userid = timeoffs130.userid))
348. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue139 (cost=0.28..8.01 rows=8 width=83) (never executed)

  • Output: tsapprovalrequestkeyvalue139.id, tsapprovalrequestkeyvalue139.tsapprovalrequestid, tsapprovalrequestkeyvalue139.parentid, tsapprovalrequestkeyvalue139.index, tsapprovalrequestkeyvalue139.key, tsapprovalrequestkeyvalue139.uri, tsapprovalrequestkeyvalue139.slug, tsapprovalrequestkeyvalue139."boolean", tsapprovalrequestkeyvalue139.date, tsapprovalrequestkeyvalue139.number, tsapprovalrequestkeyvalue139.text, tsapprovalrequestkeyvalue139."time", tsapprovalrequestkeyvalue139.timespan, tsapprovalrequestkeyvalue139.daterange_startdate, tsapprovalrequestkeyvalue139.daterange_enddate, tsapprovalrequestkeyvalue139.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue139.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue139.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue139.workdayduration_workdays, tsapprovalrequestkeyvalue139.workdayduration_hours, tsapprovalrequestkeyvalue139.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue139.tsapprovalrequestid = tsapprovalrequest142.id)
  • Filter: (upper(tsapprovalrequestkeyvalue139.key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
349. 0.000 0.000 ↓ 0.0 0

Index Scan using tsapprovalrequestkeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue143 (cost=0.28..0.53 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue143.id, tsapprovalrequestkeyvalue143.tsapprovalrequestid, tsapprovalrequestkeyvalue143.parentid, tsapprovalrequestkeyvalue143.index, tsapprovalrequestkeyvalue143.key, tsapprovalrequestkeyvalue143.uri, tsapprovalrequestkeyvalue143.slug, tsapprovalrequestkeyvalue143."boolean", tsapprovalrequestkeyvalue143.date, tsapprovalrequestkeyvalue143.number, tsapprovalrequestkeyvalue143.text, tsapprovalrequestkeyvalue143."time", tsapprovalrequestkeyvalue143.timespan, tsapprovalrequestkeyvalue143.daterange_startdate, tsapprovalrequestkeyvalue143.daterange_enddate, tsapprovalrequestkeyvalue143.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue143.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue143.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue143.workdayduration_workdays, tsapprovalrequestkeyvalue143.workdayduration_hours, tsapprovalrequestkeyvalue143.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue143.id = tsapprovalrequestkeyvalue139.parentid)
  • Filter: (tsapprovalrequestkeyvalue143.parentid IS NULL)
350. 0.000 10,785.546 ↓ 0.0 0 599,197

Nested Loop (cost=11.94..28.19 rows=1 width=69) (actual time=0.018..0.018 rows=0 loops=599,197)

  • Output: upper(heetapprovalhistorykeyvalue144.uri)
  • Buffers: shared hit=5977115
351. 599.041 10,785.546 ↓ 0.0 0 599,197

Nested Loop (cost=11.51..27.45 rows=1 width=16) (actual time=0.018..0.018 rows=0 loops=599,197)

  • Output: heetapprovalhistorykeyvalue152.id
  • Buffers: shared hit=5976907
352. 0.000 10,186.349 ↓ 0.0 0 599,197

Nested Loop (cost=11.07..25.51 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=599,197)

  • Output: heetapprovalhistorykeyvalue151.id
  • Buffers: shared hit=5976699
353. 599.041 10,186.349 ↓ 0.0 0 599,197

Nested Loop (cost=10.64..24.81 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=599,197)

  • Output: heetapprovalhistorykeyvalue150.id
  • Buffers: shared hit=5976491
354. 0.000 9,587.152 ↓ 0.0 0 599,197

Nested Loop (cost=10.21..23.27 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=599,197)

  • Output: heetapprovalhistorykeyvalue149.id
  • Buffers: shared hit=5976283
355. 598.885 9,587.152 ↓ 0.0 0 599,197

Nested Loop (cost=9.78..21.02 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=599,197)

  • Output: heetapprovalhistorykeyvalue148.parentid
  • Buffers: shared hit=5976075
356. 595.765 8,987.955 ↓ 0.0 0 599,197

Nested Loop (cost=9.34..18.55 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=599,197)

  • Output: heetapprovalhistorykeyvalue147.parentid
  • Buffers: shared hit=5975867
357. 698.967 8,388.758 ↓ 0.0 0 599,197

Nested Loop (cost=3.73..11.91 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=599,197)

  • Output: timesheetapprovalhistory146.id
  • Buffers: shared hit=5975365
358. 1,797.591 1,797.591 ↑ 2.0 1 599,197

Index Scan using ixtsuseridstartdateenddate on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet145 (cost=0.42..3.23 rows=2 width=16) (actual time=0.003..0.003 rows=1 loops=599,197)

  • Output: timesheet145.id, timesheet145.userid, timesheet145.startdate, timesheet145.enddate, timesheet145.approvalstatus, timesheet145.duedate, timesheet145.autosubmitdatetimeutc, timesheet145.lastautosubmitattemptdatetimeutc, timesheet145.createdonutc
  • Index Cond: ((timesheet145.userid = timeoffs130.userid) AND (timeoffs130.enddate >= timesheet145.startdate) AND (timeoffs130.startdate <= timesheet145.enddate))
  • Buffers: shared hit=2463503
359. 589.220 5,892.200 ↓ 0.0 0 589,220

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory146 (cost=3.31..4.33 rows=1 width=32) (actual time=0.010..0.010 rows=0 loops=589,220)

  • Output: timesheetapprovalhistory146.id, timesheetapprovalhistory146.action, timesheetapprovalhistory146.approvalcomments, timesheetapprovalhistory146.timestamputc, timesheetapprovalhistory146.serialnumber, timesheetapprovalhistory146.timesheetid, timesheetapprovalhistory146.approvalagenttype, timesheetapprovalhistory146.userid, timesheetapprovalhistory146.systemprocessidentifier
  • Recheck Cond: ((timesheetapprovalhistory146.timesheetid = timesheet145.id) AND (timesheetapprovalhistory146.userid = 2042))
  • Heap Blocks: exact=52
  • Buffers: shared hit=3511862
360. 656.825 5,302.980 ↓ 0.0 0 589,220

BitmapAnd (cost=3.31..3.31 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=589,220)

  • Buffers: shared hit=3511810
361. 1,767.660 1,767.660 ↑ 1.0 4 589,220

Bitmap Index Scan on ixtah2timesheetid (cost=0.00..1.45 rows=4 width=0) (actual time=0.003..0.003 rows=4 loops=589,220)

  • Index Cond: (timesheetapprovalhistory146.timesheetid = timesheet145.id)
  • Buffers: shared hit=1784713
362. 2,878.495 2,878.495 ↓ 2.4 57 575,699

Bitmap Index Scan on ixtahuserid (cost=0.00..1.60 rows=24 width=0) (actual time=0.005..0.005 rows=57 loops=575,699)

  • Index Cond: (timesheetapprovalhistory146.userid = 2042)
  • Buffers: shared hit=1727097
363. 0.572 3.432 ↑ 1.0 1 52

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue147 (cost=5.62..6.64 rows=1 width=32) (actual time=0.066..0.066 rows=1 loops=52)

  • Output: heetapprovalhistorykeyvalue147.id, heetapprovalhistorykeyvalue147.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue147.parentid, heetapprovalhistorykeyvalue147.index, heetapprovalhistorykeyvalue147.key, heetapprovalhistorykeyvalue147.uri, heetapprovalhistorykeyvalue147.slug, heetapprovalhistorykeyvalue147."boolean", heetapprovalhistorykeyvalue147.date, heetapprovalhistorykeyvalue147.number, heetapprovalhistorykeyvalue147.text, heetapprovalhistorykeyvalue147."time", heetapprovalhistorykeyvalue147.timespan, heetapprovalhistorykeyvalue147.daterange_startdate, heetapprovalhistorykeyvalue147.daterange_enddate, heetapprovalhistorykeyvalue147.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue147.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue147.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue147.workdayduration_workdays, heetapprovalhistorykeyvalue147.workdayduration_hours, heetapprovalhistorykeyvalue147.workdayduration_minutes
  • Recheck Cond: ((heetapprovalhistorykeyvalue147.timesheetapprovalhistoryid = timesheetapprovalhistory146.id) AND (upper(heetapprovalhistorykeyvalue147.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text))
  • Filter: (upper(heetapprovalhistorykeyvalue147.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=82
  • Buffers: shared hit=502
364. 0.052 2.860 ↓ 0.0 0 52

BitmapAnd (cost=5.62..5.62 rows=1 width=0) (actual time=0.055..0.055 rows=0 loops=52)

  • Buffers: shared hit=420
365. 0.364 0.364 ↓ 1.5 37 52

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..1.62 rows=25 width=0) (actual time=0.007..0.007 rows=37 loops=52)

  • Index Cond: (heetapprovalhistorykeyvalue147.timesheetapprovalhistoryid = timesheetapprovalhistory146.id)
  • Buffers: shared hit=160
366. 2.444 2.444 ↓ 1.0 156 52

Bitmap Index Scan on ixtahkvuri (cost=0.00..3.72 rows=155 width=0) (actual time=0.047..0.047 rows=156 loops=52)

  • Index Cond: (upper(heetapprovalhistorykeyvalue147.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text)
  • Buffers: shared hit=260
367. 0.312 0.312 ↑ 1.0 1 52

Index Scan using timesheetapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue148 (cost=0.43..2.46 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=52)

  • Output: heetapprovalhistorykeyvalue148.id, heetapprovalhistorykeyvalue148.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue148.parentid, heetapprovalhistorykeyvalue148.index, heetapprovalhistorykeyvalue148.key, heetapprovalhistorykeyvalue148.uri, heetapprovalhistorykeyvalue148.slug, heetapprovalhistorykeyvalue148."boolean", heetapprovalhistorykeyvalue148.date, heetapprovalhistorykeyvalue148.number, heetapprovalhistorykeyvalue148.text, heetapprovalhistorykeyvalue148."time", heetapprovalhistorykeyvalue148.timespan, heetapprovalhistorykeyvalue148.daterange_startdate, heetapprovalhistorykeyvalue148.daterange_enddate, heetapprovalhistorykeyvalue148.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue148.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue148.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue148.workdayduration_workdays, heetapprovalhistorykeyvalue148.workdayduration_hours, heetapprovalhistorykeyvalue148.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue148.id = heetapprovalhistorykeyvalue147.parentid)
  • Filter: (upper(heetapprovalhistorykeyvalue148.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
  • Buffers: shared hit=208
368. 0.312 0.312 ↑ 1.0 1 52

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue149 (cost=0.43..2.24 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=52)

  • Output: heetapprovalhistorykeyvalue149.id, heetapprovalhistorykeyvalue149.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue149.parentid, heetapprovalhistorykeyvalue149.index, heetapprovalhistorykeyvalue149.key, heetapprovalhistorykeyvalue149.uri, heetapprovalhistorykeyvalue149.slug, heetapprovalhistorykeyvalue149."boolean", heetapprovalhistorykeyvalue149.date, heetapprovalhistorykeyvalue149.number, heetapprovalhistorykeyvalue149.text, heetapprovalhistorykeyvalue149."time", heetapprovalhistorykeyvalue149.timespan, heetapprovalhistorykeyvalue149.daterange_startdate, heetapprovalhistorykeyvalue149.daterange_enddate, heetapprovalhistorykeyvalue149.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue149.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue149.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue149.workdayduration_workdays, heetapprovalhistorykeyvalue149.workdayduration_hours, heetapprovalhistorykeyvalue149.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue149.parentid = heetapprovalhistorykeyvalue148.parentid)
  • Filter: (upper(heetapprovalhistorykeyvalue149.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
  • Buffers: shared hit=208
369. 0.156 0.156 ↑ 10.0 1 52

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue150 (cost=0.43..1.45 rows=10 width=32) (actual time=0.003..0.003 rows=1 loops=52)

  • Output: heetapprovalhistorykeyvalue150.id, heetapprovalhistorykeyvalue150.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue150.parentid, heetapprovalhistorykeyvalue150.index, heetapprovalhistorykeyvalue150.key, heetapprovalhistorykeyvalue150.uri, heetapprovalhistorykeyvalue150.slug, heetapprovalhistorykeyvalue150."boolean", heetapprovalhistorykeyvalue150.date, heetapprovalhistorykeyvalue150.number, heetapprovalhistorykeyvalue150.text, heetapprovalhistorykeyvalue150."time", heetapprovalhistorykeyvalue150.timespan, heetapprovalhistorykeyvalue150.daterange_startdate, heetapprovalhistorykeyvalue150.daterange_enddate, heetapprovalhistorykeyvalue150.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue150.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue150.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue150.workdayduration_workdays, heetapprovalhistorykeyvalue150.workdayduration_hours, heetapprovalhistorykeyvalue150.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue150.parentid = heetapprovalhistorykeyvalue149.id)
  • Buffers: shared hit=208
370. 0.260 0.260 ↑ 1.0 1 52

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue151 (cost=0.43..0.69 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=52)

  • Output: heetapprovalhistorykeyvalue151.id, heetapprovalhistorykeyvalue151.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue151.parentid, heetapprovalhistorykeyvalue151.index, heetapprovalhistorykeyvalue151.key, heetapprovalhistorykeyvalue151.uri, heetapprovalhistorykeyvalue151.slug, heetapprovalhistorykeyvalue151."boolean", heetapprovalhistorykeyvalue151.date, heetapprovalhistorykeyvalue151.number, heetapprovalhistorykeyvalue151.text, heetapprovalhistorykeyvalue151."time", heetapprovalhistorykeyvalue151.timespan, heetapprovalhistorykeyvalue151.daterange_startdate, heetapprovalhistorykeyvalue151.daterange_enddate, heetapprovalhistorykeyvalue151.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue151.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue151.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue151.workdayduration_workdays, heetapprovalhistorykeyvalue151.workdayduration_hours, heetapprovalhistorykeyvalue151.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue151.parentid = heetapprovalhistorykeyvalue150.id)
  • Filter: (upper(heetapprovalhistorykeyvalue151.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
  • Buffers: shared hit=208
371. 0.156 0.156 ↑ 10.0 1 52

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue152 (cost=0.43..1.84 rows=10 width=32) (actual time=0.003..0.003 rows=1 loops=52)

  • Output: heetapprovalhistorykeyvalue152.id, heetapprovalhistorykeyvalue152.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue152.parentid, heetapprovalhistorykeyvalue152.index, heetapprovalhistorykeyvalue152.key, heetapprovalhistorykeyvalue152.uri, heetapprovalhistorykeyvalue152.slug, heetapprovalhistorykeyvalue152."boolean", heetapprovalhistorykeyvalue152.date, heetapprovalhistorykeyvalue152.number, heetapprovalhistorykeyvalue152.text, heetapprovalhistorykeyvalue152."time", heetapprovalhistorykeyvalue152.timespan, heetapprovalhistorykeyvalue152.daterange_startdate, heetapprovalhistorykeyvalue152.daterange_enddate, heetapprovalhistorykeyvalue152.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue152.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue152.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue152.workdayduration_workdays, heetapprovalhistorykeyvalue152.workdayduration_hours, heetapprovalhistorykeyvalue152.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue152.parentid = heetapprovalhistorykeyvalue151.id)
  • Buffers: shared hit=208
372. 0.156 0.156 ↑ 10.0 1 52

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue144 (cost=0.43..0.64 rows=10 width=85) (actual time=0.003..0.003 rows=1 loops=52)

  • Output: heetapprovalhistorykeyvalue144.id, heetapprovalhistorykeyvalue144.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue144.parentid, heetapprovalhistorykeyvalue144.index, heetapprovalhistorykeyvalue144.key, heetapprovalhistorykeyvalue144.uri, heetapprovalhistorykeyvalue144.slug, heetapprovalhistorykeyvalue144."boolean", heetapprovalhistorykeyvalue144.date, heetapprovalhistorykeyvalue144.number, heetapprovalhistorykeyvalue144.text, heetapprovalhistorykeyvalue144."time", heetapprovalhistorykeyvalue144.timespan, heetapprovalhistorykeyvalue144.daterange_startdate, heetapprovalhistorykeyvalue144.daterange_enddate, heetapprovalhistorykeyvalue144.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue144.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue144.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue144.workdayduration_workdays, heetapprovalhistorykeyvalue144.workdayduration_hours, heetapprovalhistorykeyvalue144.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue144.parentid = heetapprovalhistorykeyvalue152.id)
  • Buffers: shared hit=208
373. 599.145 1,797.435 ↓ 0.0 0 599,145

Nested Loop (cost=1.53..9.86 rows=1 width=63) (actual time=0.003..0.003 rows=0 loops=599,145)

  • Output: upper(tsapprovalrequestkeyvalue153.uri)
  • Buffers: shared hit=1198290
374. 0.000 1,198.290 ↓ 0.0 0 599,145

Nested Loop (cost=1.25..7.55 rows=1 width=79) (actual time=0.002..0.002 rows=0 loops=599,145)

  • Output: tsapprovalrequestkeyvalue153.uri, tsapprovalrequestkeyvalue153.parentid
  • Join Filter: (tsapprovalrequest156.id = tsapprovalrequestkeyvalue153.tsapprovalrequestid)
  • Buffers: shared hit=1198290
375. 599.145 1,198.290 ↓ 0.0 0 599,145

Nested Loop (cost=0.97..6.24 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=599,145)

  • Output: tsapprovalrequest156.id
  • Buffers: shared hit=1198290
376. 0.000 599.145 ↓ 0.0 0 599,145

Nested Loop (cost=0.55..4.59 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=599,145)

  • Output: timesheetapprovalnodes155.timesheetid, tsapprovalrequest156.id
  • Buffers: shared hit=1198290
377. 599.145 599.145 ↓ 0.0 0 599,145

Index Scan using uix2tsar_nodeid_userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequest tsapprovalrequest156 (cost=0.27..2.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=599,145)

  • Output: tsapprovalrequest156.id, tsapprovalrequest156.effectivedateutc, tsapprovalrequest156.userid, tsapprovalrequest156.nodeid, tsapprovalrequest156.remindersentutc, tsapprovalrequest156.overduesentutc, tsapprovalrequest156.waitingbatchsentutc, tsapprovalrequest156.approvalagenttype, tsapprovalrequest156.systemprocessidentifier
  • Index Cond: (tsapprovalrequest156.userid = 2042)
  • Buffers: shared hit=1198290
378. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalnodes timesheetapprovalnodes155 (cost=0.28..2.29 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes155.id, timesheetapprovalnodes155.isapproved, timesheetapprovalnodes155.approverrole, timesheetapprovalnodes155.userid, timesheetapprovalnodes155.timesheetid, timesheetapprovalnodes155.systemprocessidentifier, timesheetapprovalnodes155.scriptid, timesheetapprovalnodes155.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes155.id = tsapprovalrequest156.nodeid)
379. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet154 (cost=0.42..1.63 rows=1 width=16) (never executed)

  • Output: timesheet154.id, timesheet154.userid, timesheet154.startdate, timesheet154.enddate, timesheet154.approvalstatus, timesheet154.duedate, timesheet154.autosubmitdatetimeutc, timesheet154.lastautosubmitattemptdatetimeutc, timesheet154.createdonutc
  • Index Cond: (timesheet154.id = timesheetapprovalnodes155.timesheetid)
  • Filter: ((timeoffs130.startdate <= timesheet154.enddate) AND (timeoffs130.enddate >= timesheet154.startdate) AND (timesheet154.userid = timeoffs130.userid))
380. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue153 (cost=0.28..1.30 rows=1 width=83) (never executed)

  • Output: tsapprovalrequestkeyvalue153.id, tsapprovalrequestkeyvalue153.tsapprovalrequestid, tsapprovalrequestkeyvalue153.parentid, tsapprovalrequestkeyvalue153.index, tsapprovalrequestkeyvalue153.key, tsapprovalrequestkeyvalue153.uri, tsapprovalrequestkeyvalue153.slug, tsapprovalrequestkeyvalue153."boolean", tsapprovalrequestkeyvalue153.date, tsapprovalrequestkeyvalue153.number, tsapprovalrequestkeyvalue153.text, tsapprovalrequestkeyvalue153."time", tsapprovalrequestkeyvalue153.timespan, tsapprovalrequestkeyvalue153.daterange_startdate, tsapprovalrequestkeyvalue153.daterange_enddate, tsapprovalrequestkeyvalue153.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue153.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue153.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue153.workdayduration_workdays, tsapprovalrequestkeyvalue153.workdayduration_hours, tsapprovalrequestkeyvalue153.workdayduration_minutes
  • Index Cond: (upper(tsapprovalrequestkeyvalue153.key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
381. 0.000 0.000 ↓ 0.0 0

Index Scan using tsapprovalrequestkeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue157 (cost=0.28..2.30 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue157.id, tsapprovalrequestkeyvalue157.tsapprovalrequestid, tsapprovalrequestkeyvalue157.parentid, tsapprovalrequestkeyvalue157.index, tsapprovalrequestkeyvalue157.key, tsapprovalrequestkeyvalue157.uri, tsapprovalrequestkeyvalue157.slug, tsapprovalrequestkeyvalue157."boolean", tsapprovalrequestkeyvalue157.date, tsapprovalrequestkeyvalue157.number, tsapprovalrequestkeyvalue157.text, tsapprovalrequestkeyvalue157."time", tsapprovalrequestkeyvalue157.timespan, tsapprovalrequestkeyvalue157.daterange_startdate, tsapprovalrequestkeyvalue157.daterange_enddate, tsapprovalrequestkeyvalue157.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue157.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue157.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue157.workdayduration_workdays, tsapprovalrequestkeyvalue157.workdayduration_hours, tsapprovalrequestkeyvalue157.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue157.id = tsapprovalrequestkeyvalue153.parentid)
  • Filter: (tsapprovalrequestkeyvalue157.parentid IS NULL)
382. 0.000 10,185.465 ↓ 0.0 0 599,145

Nested Loop (cost=11.94..37.92 rows=1 width=69) (actual time=0.017..0.017 rows=0 loops=599,145)

  • Output: upper(heetapprovalhistorykeyvalue158.uri)
  • Buffers: shared hit=5974791
383. 599.145 10,185.465 ↓ 0.0 0 599,145

Nested Loop (cost=11.51..37.18 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=599,145)

  • Output: heetapprovalhistorykeyvalue166.id
  • Buffers: shared hit=5974791
384. 0.000 9,586.320 ↓ 0.0 0 599,145

Nested Loop (cost=11.07..25.51 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=599,145)

  • Output: heetapprovalhistorykeyvalue165.id
  • Buffers: shared hit=5974791
385. 599.145 9,586.320 ↓ 0.0 0 599,145

Nested Loop (cost=10.64..24.81 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=599,145)

  • Output: heetapprovalhistorykeyvalue164.id
  • Buffers: shared hit=5974791
386. 0.000 8,987.175 ↓ 0.0 0 599,145

Nested Loop (cost=10.21..23.27 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=599,145)

  • Output: heetapprovalhistorykeyvalue163.id
  • Buffers: shared hit=5974791
387. 599.145 8,987.175 ↓ 0.0 0 599,145

Nested Loop (cost=9.78..21.02 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=599,145)

  • Output: heetapprovalhistorykeyvalue162.parentid
  • Buffers: shared hit=5974791
388. 599.145 8,388.030 ↓ 0.0 0 599,145

Nested Loop (cost=9.34..18.55 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=599,145)

  • Output: heetapprovalhistorykeyvalue161.parentid
  • Buffers: shared hit=5974791
389. 688.938 7,788.885 ↓ 0.0 0 599,145

Nested Loop (cost=3.73..11.91 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=599,145)

  • Output: timesheetapprovalhistory160.id
  • Buffers: shared hit=5974791
390. 1,797.435 1,797.435 ↑ 2.0 1 599,145

Index Scan using ixtsuseridstartdateenddate on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet159 (cost=0.42..3.23 rows=2 width=16) (actual time=0.002..0.003 rows=1 loops=599,145)

  • Output: timesheet159.id, timesheet159.userid, timesheet159.startdate, timesheet159.enddate, timesheet159.approvalstatus, timesheet159.duedate, timesheet159.autosubmitdatetimeutc, timesheet159.lastautosubmitattemptdatetimeutc, timesheet159.createdonutc
  • Index Cond: ((timesheet159.userid = timeoffs130.userid) AND (timeoffs130.enddate >= timesheet159.startdate) AND (timeoffs130.startdate <= timesheet159.enddate))
  • Buffers: shared hit=2463295
391. 0.000 5,302.512 ↓ 0.0 0 589,168

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory160 (cost=3.31..4.33 rows=1 width=32) (actual time=0.009..0.009 rows=0 loops=589,168)

  • Output: timesheetapprovalhistory160.id, timesheetapprovalhistory160.action, timesheetapprovalhistory160.approvalcomments, timesheetapprovalhistory160.timestamputc, timesheetapprovalhistory160.serialnumber, timesheetapprovalhistory160.timesheetid, timesheetapprovalhistory160.approvalagenttype, timesheetapprovalhistory160.userid, timesheetapprovalhistory160.systemprocessidentifier
  • Recheck Cond: ((timesheetapprovalhistory160.timesheetid = timesheet159.id) AND (timesheetapprovalhistory160.userid = 2042))
  • Buffers: shared hit=3511496
392. 1,245.941 5,302.512 ↓ 0.0 0 589,168

BitmapAnd (cost=3.31..3.31 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=589,168)

  • Buffers: shared hit=3511496
393. 1,178.336 1,178.336 ↑ 1.0 4 589,168

Bitmap Index Scan on ixtah2timesheetid (cost=0.00..1.45 rows=4 width=0) (actual time=0.002..0.002 rows=4 loops=589,168)

  • Index Cond: (timesheetapprovalhistory160.timesheetid = timesheet159.id)
  • Buffers: shared hit=1784555
394. 2,878.235 2,878.235 ↓ 2.4 57 575,647

Bitmap Index Scan on ixtahuserid (cost=0.00..1.60 rows=24 width=0) (actual time=0.005..0.005 rows=57 loops=575,647)

  • Index Cond: (timesheetapprovalhistory160.userid = 2042)
  • Buffers: shared hit=1726941
395. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue161 (cost=5.62..6.64 rows=1 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue161.id, heetapprovalhistorykeyvalue161.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue161.parentid, heetapprovalhistorykeyvalue161.index, heetapprovalhistorykeyvalue161.key, heetapprovalhistorykeyvalue161.uri, heetapprovalhistorykeyvalue161.slug, heetapprovalhistorykeyvalue161."boolean", heetapprovalhistorykeyvalue161.date, heetapprovalhistorykeyvalue161.number, heetapprovalhistorykeyvalue161.text, heetapprovalhistorykeyvalue161."time", heetapprovalhistorykeyvalue161.timespan, heetapprovalhistorykeyvalue161.daterange_startdate, heetapprovalhistorykeyvalue161.daterange_enddate, heetapprovalhistorykeyvalue161.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue161.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue161.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue161.workdayduration_workdays, heetapprovalhistorykeyvalue161.workdayduration_hours, heetapprovalhistorykeyvalue161.workdayduration_minutes
  • Recheck Cond: ((heetapprovalhistorykeyvalue161.timesheetapprovalhistoryid = timesheetapprovalhistory160.id) AND (upper(heetapprovalhistorykeyvalue161.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text))
  • Filter: (upper(heetapprovalhistorykeyvalue161.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
396. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=5.62..5.62 rows=1 width=0) (never executed)

397. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..1.62 rows=25 width=0) (never executed)

  • Index Cond: (heetapprovalhistorykeyvalue161.timesheetapprovalhistoryid = timesheetapprovalhistory160.id)
398. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ixtahkvuri (cost=0.00..3.72 rows=155 width=0) (never executed)

  • Index Cond: (upper(heetapprovalhistorykeyvalue161.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2042'::text)
399. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue162 (cost=0.43..2.46 rows=1 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue162.id, heetapprovalhistorykeyvalue162.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue162.parentid, heetapprovalhistorykeyvalue162.index, heetapprovalhistorykeyvalue162.key, heetapprovalhistorykeyvalue162.uri, heetapprovalhistorykeyvalue162.slug, heetapprovalhistorykeyvalue162."boolean", heetapprovalhistorykeyvalue162.date, heetapprovalhistorykeyvalue162.number, heetapprovalhistorykeyvalue162.text, heetapprovalhistorykeyvalue162."time", heetapprovalhistorykeyvalue162.timespan, heetapprovalhistorykeyvalue162.daterange_startdate, heetapprovalhistorykeyvalue162.daterange_enddate, heetapprovalhistorykeyvalue162.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue162.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue162.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue162.workdayduration_workdays, heetapprovalhistorykeyvalue162.workdayduration_hours, heetapprovalhistorykeyvalue162.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue162.id = heetapprovalhistorykeyvalue161.parentid)
  • Filter: (upper(heetapprovalhistorykeyvalue162.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
400. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue163 (cost=0.43..2.24 rows=1 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue163.id, heetapprovalhistorykeyvalue163.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue163.parentid, heetapprovalhistorykeyvalue163.index, heetapprovalhistorykeyvalue163.key, heetapprovalhistorykeyvalue163.uri, heetapprovalhistorykeyvalue163.slug, heetapprovalhistorykeyvalue163."boolean", heetapprovalhistorykeyvalue163.date, heetapprovalhistorykeyvalue163.number, heetapprovalhistorykeyvalue163.text, heetapprovalhistorykeyvalue163."time", heetapprovalhistorykeyvalue163.timespan, heetapprovalhistorykeyvalue163.daterange_startdate, heetapprovalhistorykeyvalue163.daterange_enddate, heetapprovalhistorykeyvalue163.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue163.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue163.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue163.workdayduration_workdays, heetapprovalhistorykeyvalue163.workdayduration_hours, heetapprovalhistorykeyvalue163.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue163.parentid = heetapprovalhistorykeyvalue162.parentid)
  • Filter: (upper(heetapprovalhistorykeyvalue163.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
401. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue164 (cost=0.43..1.45 rows=10 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue164.id, heetapprovalhistorykeyvalue164.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue164.parentid, heetapprovalhistorykeyvalue164.index, heetapprovalhistorykeyvalue164.key, heetapprovalhistorykeyvalue164.uri, heetapprovalhistorykeyvalue164.slug, heetapprovalhistorykeyvalue164."boolean", heetapprovalhistorykeyvalue164.date, heetapprovalhistorykeyvalue164.number, heetapprovalhistorykeyvalue164.text, heetapprovalhistorykeyvalue164."time", heetapprovalhistorykeyvalue164.timespan, heetapprovalhistorykeyvalue164.daterange_startdate, heetapprovalhistorykeyvalue164.daterange_enddate, heetapprovalhistorykeyvalue164.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue164.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue164.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue164.workdayduration_workdays, heetapprovalhistorykeyvalue164.workdayduration_hours, heetapprovalhistorykeyvalue164.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue164.parentid = heetapprovalhistorykeyvalue163.id)
402. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue165 (cost=0.43..0.69 rows=1 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue165.id, heetapprovalhistorykeyvalue165.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue165.parentid, heetapprovalhistorykeyvalue165.index, heetapprovalhistorykeyvalue165.key, heetapprovalhistorykeyvalue165.uri, heetapprovalhistorykeyvalue165.slug, heetapprovalhistorykeyvalue165."boolean", heetapprovalhistorykeyvalue165.date, heetapprovalhistorykeyvalue165.number, heetapprovalhistorykeyvalue165.text, heetapprovalhistorykeyvalue165."time", heetapprovalhistorykeyvalue165.timespan, heetapprovalhistorykeyvalue165.daterange_startdate, heetapprovalhistorykeyvalue165.daterange_enddate, heetapprovalhistorykeyvalue165.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue165.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue165.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue165.workdayduration_workdays, heetapprovalhistorykeyvalue165.workdayduration_hours, heetapprovalhistorykeyvalue165.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue165.parentid = heetapprovalhistorykeyvalue164.id)
  • Filter: (upper(heetapprovalhistorykeyvalue165.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
403. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue166 (cost=0.43..11.57 rows=10 width=32) (never executed)

  • Output: heetapprovalhistorykeyvalue166.id, heetapprovalhistorykeyvalue166.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue166.parentid, heetapprovalhistorykeyvalue166.index, heetapprovalhistorykeyvalue166.key, heetapprovalhistorykeyvalue166.uri, heetapprovalhistorykeyvalue166.slug, heetapprovalhistorykeyvalue166."boolean", heetapprovalhistorykeyvalue166.date, heetapprovalhistorykeyvalue166.number, heetapprovalhistorykeyvalue166.text, heetapprovalhistorykeyvalue166."time", heetapprovalhistorykeyvalue166.timespan, heetapprovalhistorykeyvalue166.daterange_startdate, heetapprovalhistorykeyvalue166.daterange_enddate, heetapprovalhistorykeyvalue166.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue166.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue166.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue166.workdayduration_workdays, heetapprovalhistorykeyvalue166.workdayduration_hours, heetapprovalhistorykeyvalue166.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue166.parentid = heetapprovalhistorykeyvalue165.id)
404. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue158 (cost=0.43..0.64 rows=10 width=85) (never executed)

  • Output: heetapprovalhistorykeyvalue158.id, heetapprovalhistorykeyvalue158.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue158.parentid, heetapprovalhistorykeyvalue158.index, heetapprovalhistorykeyvalue158.key, heetapprovalhistorykeyvalue158.uri, heetapprovalhistorykeyvalue158.slug, heetapprovalhistorykeyvalue158."boolean", heetapprovalhistorykeyvalue158.date, heetapprovalhistorykeyvalue158.number, heetapprovalhistorykeyvalue158.text, heetapprovalhistorykeyvalue158."time", heetapprovalhistorykeyvalue158.timespan, heetapprovalhistorykeyvalue158.daterange_startdate, heetapprovalhistorykeyvalue158.daterange_enddate, heetapprovalhistorykeyvalue158.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue158.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue158.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue158.workdayduration_workdays, heetapprovalhistorykeyvalue158.workdayduration_hours, heetapprovalhistorykeyvalue158.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue158.parentid = heetapprovalhistorykeyvalue166.id)
405. 0.021 0.189 ↑ 1.0 1 7

Nested Loop Semi Join (cost=3.84..4.00 rows=1 width=8) (actual time=0.027..0.027 rows=1 loops=7)

  • Output: timeoffs167.id, timeoffs168.id
  • Buffers: shared hit=78
406. 0.035 0.035 ↑ 1.0 1 7

Index Only Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs167 (cost=0.42..0.44 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=7)

  • Output: timeoffs167.id
  • Index Cond: (timeoffs167.id = timeoffs130.id)
  • Heap Fetches: 0
  • Buffers: shared hit=22
407. 0.064 0.133 ↑ 1.0 1 7

Nested Loop Left Join (cost=3.42..3.55 rows=1 width=4) (actual time=0.019..0.019 rows=1 loops=7)

  • Output: timeoffs168.id
  • Filter: ((hashed SubPlan 54) OR (hashed SubPlan 55))
  • Buffers: shared hit=56
408. 0.014 0.014 ↑ 1.0 1 7

Index Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs168 (cost=0.42..0.46 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=7)

  • Output: timeoffs168.id, timeoffs168.guidid, timeoffs168.userid, timeoffs168.createdbyuserid, timeoffs168.timeoffcodeid, timeoffs168.startdate, timeoffs168.enddate, timeoffs168.approvalstatus, timeoffs168.comments, timeoffs168.submittedonutc, timeoffs168.modifiedonutc, timeoffs168.info1, timeoffs168.info2, timeoffs168.info3, timeoffs168.info4, timeoffs168.info5, timeoffs168.startdurationtype, timeoffs168.enddurationtype, timeoffs168.startduration, timeoffs168.endduration, timeoffs168.startdatestarttime, timeoffs168.enddateendtime, timeoffs168.entryconfigurationmethod
  • Index Cond: (timeoffs168.id = timeoffs167.id)
  • Buffers: shared hit=28
409. 0.042 0.042 ↑ 1.0 1 7

Index Only Scan using ix4ul_userlocationstartend on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userlocation userlocation169 (cost=0.41..0.48 rows=1 width=28) (actual time=0.006..0.006 rows=1 loops=7)

  • Output: userlocation169.userid, userlocation169.locationid, userlocation169.startdate, userlocation169.enddate
  • Index Cond: ((userlocation169.userid = timeoffs168.userid) AND (userlocation169.startdate <= timeoffs168.enddate) AND (userlocation169.enddate >= timeoffs168.startdate))
  • Heap Fetches: 0
  • Buffers: shared hit=22
410.          

SubPlan (forNested Loop Left Join)

411. 0.008 0.008 ↑ 1.0 1 1

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy170 (cost=0.28..1.29 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=1)

  • Output: locationflathierarchy170.childid
  • Index Cond: (locationflathierarchy170.parentid = 'a36334cb-1074-45dd-8c37-0a0241f0416b'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
412. 0.005 0.005 ↑ 1.0 1 1

Index Only Scan using locationflathierarchy_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.locationflathierarchy locationflathierarchy171 (cost=0.28..1.29 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=1)

  • Output: locationflathierarchy171.childid
  • Index Cond: (locationflathierarchy171.parentid = 'c3b4b88b-163d-4ff3-aff1-2c83b2bcd1a2'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
413. 56,423.561 56,423.582 ↑ 188,336.0 1 1

Result (cost=0.70..7,165.15 rows=188,336 width=0) (actual time=56,423.582..56,423.582 rows=1 loops=1)

  • Output: $55, $112, $169, $225
  • Buffers: shared hit=30735772
414. 0.000 0.021 ↑ 188,336.0 1 1

Append (cost=0.70..7,165.15 rows=188,336 width=0) (actual time=0.021..0.021 rows=1 loops=1)

  • Buffers: shared hit=7
415. 0.002 0.021 ↑ 186,892.0 1 1

Subquery Scan on *SELECT* 1 (cost=0.70..6,706.44 rows=186,892 width=0) (actual time=0.021..0.021 rows=1 loops=1)

  • Buffers: shared hit=7
416. 0.002 0.019 ↑ 186,892.0 1 1

Merge Anti Join (cost=0.70..4,837.52 rows=186,892 width=0) (actual time=0.019..0.019 rows=1 loops=1)

  • Output: NULL::integer, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Merge Cond: (dm_timeofflist_facts.timeoffid = dm_timeofflist_realtime_facts.timeoffid)
  • Buffers: shared hit=7
417. 0.013 0.013 ↑ 188,719.0 1 1

Index Only Scan using dm_timeofflist_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_facts (cost=0.42..4,215.20 rows=188,719 width=4) (actual time=0.013..0.013 rows=1 loops=1)

  • Output: dm_timeofflist_facts.timeoffid
  • Heap Fetches: 0
  • Buffers: shared hit=4
418. 0.004 0.004 ↑ 1,827.0 1 1

Index Only Scan using dm_timeofflist_realtime_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts (cost=0.28..127.68 rows=1,827 width=4) (actual time=0.004..0.004 rows=1 loops=1)

  • Output: dm_timeofflist_realtime_facts.timeoffid
  • Heap Fetches: 0
  • Buffers: shared hit=3
419. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2 (cost=0.00..458.71 rows=1,444 width=0) (never executed)

420. 0.000 0.000 ↓ 0.0 0

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_1 (cost=0.00..444.27 rows=1,444 width=0) (never executed)

  • Output: NULL::integer, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Filter: (NOT dm_timeofflist_realtime_facts_1.deleted)
Planning time : 92.606 ms
Execution time : 56,427.613 ms