explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rlcu : team booking summarys3 (no cte)

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 18,765.051 ↑ 1.0 1 1

Limit (cost=32,613,618.86..32,613,618.91 rows=1 width=40) (actual time=18,765.048..18,765.051 rows=1 loops=1)

  • Output: ($36), ($69), ($97), ($131), ($162)
  • Buffers: shared hit=419575 read=21751
2.          

CTE timesheet0cte

3. 0.008 23.779 ↓ 4.0 4 1

Nested Loop (cost=1.53..49.84 rows=1 width=76) (actual time=7.400..23.779 rows=4 loops=1)

  • Output: timesheet0.userid, timesheet0.startdate, timesheet0.enddate, tsapprovalrequestkeyvalue1.key, tsapprovalrequestkeyvalue1.uri
  • Inner Unique: true
  • Buffers: shared hit=35 read=23
4. 0.012 18.907 ↓ 4.0 4 1

Nested Loop (cost=1.25..47.60 rows=1 width=176) (actual time=6.331..18.907 rows=4 loops=1)

  • Output: timesheet0.userid, timesheet0.startdate, timesheet0.enddate, tsapprovalrequestkeyvalue1.key, tsapprovalrequestkeyvalue1.uri, tsapprovalrequestkeyvalue1.parentid
  • Inner Unique: true
  • Buffers: shared hit=27 read=19
5. 0.009 18.855 ↓ 4.0 4 1

Nested Loop (cost=0.83..45.82 rows=1 width=180) (actual time=6.310..18.855 rows=4 loops=1)

  • Output: timesheetapprovalnodes2.timesheetid, tsapprovalrequestkeyvalue1.key, tsapprovalrequestkeyvalue1.uri, tsapprovalrequestkeyvalue1.parentid
  • Inner Unique: true
  • Buffers: shared hit=11 read=19
6. 0.010 11.538 ↓ 4.0 4 1

Nested Loop (cost=0.55..43.53 rows=1 width=180) (actual time=4.733..11.538 rows=4 loops=1)

  • Output: tsapprovalrequest3.nodeid, tsapprovalrequestkeyvalue1.key, tsapprovalrequestkeyvalue1.uri, tsapprovalrequestkeyvalue1.parentid
  • Buffers: shared hit=6 read=12
7. 6.076 6.076 ↑ 1.0 4 1

Index Scan using uix2tsar_nodeid_userid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequest tsapprovalrequest3 (cost=0.27..5.04 rows=4 width=20) (actual time=2.785..6.076 rows=4 loops=1)

  • Output: tsapprovalrequest3.id, tsapprovalrequest3.effectivedateutc, tsapprovalrequest3.userid, tsapprovalrequest3.nodeid, tsapprovalrequest3.remindersentutc, tsapprovalrequest3.overduesentutc, tsapprovalrequest3.waitingbatchsentutc, tsapprovalrequest3.approvalagenttype, tsapprovalrequest3.systemprocessidentifier
  • Index Cond: (tsapprovalrequest3.userid = 2892)
  • Buffers: shared read=6
8. 5.452 5.452 ↑ 1.0 1 4

Index Scan using ixtsarkvtsapprovalrequestid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue1 (cost=0.28..9.61 rows=1 width=168) (actual time=1.342..1.363 rows=1 loops=4)

  • Output: tsapprovalrequestkeyvalue1.id, tsapprovalrequestkeyvalue1.tsapprovalrequestid, tsapprovalrequestkeyvalue1.parentid, tsapprovalrequestkeyvalue1.index, tsapprovalrequestkeyvalue1.key, tsapprovalrequestkeyvalue1.uri, tsapprovalrequestkeyvalue1.slug, tsapprovalrequestkeyvalue1."boolean", tsapprovalrequestkeyvalue1.date, tsapprovalrequestkeyvalue1.number, tsapprovalrequestkeyvalue1.text, tsapprovalrequestkeyvalue1."time", tsapprovalrequestkeyvalue1.timespan, tsapprovalrequestkeyvalue1.daterange_startdate, tsapprovalrequestkeyvalue1.daterange_enddate, tsapprovalrequestkeyvalue1.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue1.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue1.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue1.workdayduration_workdays, tsapprovalrequestkeyvalue1.workdayduration_hours, tsapprovalrequestkeyvalue1.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue1.tsapprovalrequestid = tsapprovalrequest3.id)
  • Filter: ((upper(tsapprovalrequestkeyvalue1.key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text) OR ((upper(tsapprovalrequestkeyvalue1.key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text) AND (upper(tsapprovalrequestkeyvalue1.uri) = 'URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text)))
  • Rows Removed by Filter: 10
  • Buffers: shared hit=6 read=6
9. 7.308 7.308 ↑ 1.0 1 4

Index Scan using timesheetapprovalnodes_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalnodes timesheetapprovalnodes2 (cost=0.28..2.29 rows=1 width=32) (actual time=1.827..1.827 rows=1 loops=4)

  • Output: timesheetapprovalnodes2.id, timesheetapprovalnodes2.isapproved, timesheetapprovalnodes2.approverrole, timesheetapprovalnodes2.userid, timesheetapprovalnodes2.timesheetid, timesheetapprovalnodes2.systemprocessidentifier, timesheetapprovalnodes2.scriptid, timesheetapprovalnodes2.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes2.id = tsapprovalrequest3.nodeid)
  • Buffers: shared hit=5 read=7
10. 0.040 0.040 ↑ 1.0 1 4

Index Scan using timesheet_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet0 (cost=0.42..1.77 rows=1 width=28) (actual time=0.010..0.010 rows=1 loops=4)

  • Output: timesheet0.id, timesheet0.userid, timesheet0.startdate, timesheet0.enddate, timesheet0.approvalstatus, timesheet0.duedate, timesheet0.autosubmitdatetimeutc, timesheet0.lastautosubmitattemptdatetimeutc, timesheet0.createdonutc
  • Index Cond: (timesheet0.id = timesheetapprovalnodes2.timesheetid)
  • Buffers: shared hit=16
11. 4.864 4.864 ↑ 1.0 1 4

Index Scan using tsapprovalrequestkeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue4 (cost=0.28..2.23 rows=1 width=16) (actual time=1.216..1.216 rows=1 loops=4)

  • Output: tsapprovalrequestkeyvalue4.id, tsapprovalrequestkeyvalue4.tsapprovalrequestid, tsapprovalrequestkeyvalue4.parentid, tsapprovalrequestkeyvalue4.index, tsapprovalrequestkeyvalue4.key, tsapprovalrequestkeyvalue4.uri, tsapprovalrequestkeyvalue4.slug, tsapprovalrequestkeyvalue4."boolean", tsapprovalrequestkeyvalue4.date, tsapprovalrequestkeyvalue4.number, tsapprovalrequestkeyvalue4.text, tsapprovalrequestkeyvalue4."time", tsapprovalrequestkeyvalue4.timespan, tsapprovalrequestkeyvalue4.daterange_startdate, tsapprovalrequestkeyvalue4.daterange_enddate, tsapprovalrequestkeyvalue4.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue4.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue4.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue4.workdayduration_workdays, tsapprovalrequestkeyvalue4.workdayduration_hours, tsapprovalrequestkeyvalue4.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue4.id = tsapprovalrequestkeyvalue1.parentid)
  • Filter: (tsapprovalrequestkeyvalue4.parentid IS NULL)
  • Buffers: shared hit=8 read=4
12.          

Initplan (for Limit)

13. 0.000 17,867.340 ↑ 1.0 1 1

Aggregate (cost=16,884,661.32..16,884,661.33 rows=1 width=8) (actual time=17,867.340..17,867.340 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=184893 read=19294
14.          

Initplan (for Aggregate)

15. 0.004 5.174 ↓ 0.0 0 1

Nested Loop (cost=0.43..11.37 rows=1 width=0) (actual time=5.174..5.174 rows=0 loops=1)

  • Buffers: shared hit=5 read=4
16. 1.848 1.848 ↑ 1.0 2 1

Index Only Scan using userpolicyset_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userpolicyset userpolicyset20 (cost=0.29..3.23 rows=2 width=16) (actual time=1.847..1.848 rows=2 loops=1)

  • Output: userpolicyset20.userid, userpolicyset20.policysetid
  • Index Cond: (userpolicyset20.userid = 2892)
  • Heap Fetches: 2
  • Buffers: shared hit=3 read=1
17. 3.322 3.322 ↓ 0.0 0 2

Index Scan using ixpskvpolicysetid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.policysetkeyvalue policysetkeyvalue21 (cost=0.14..4.06 rows=1 width=16) (actual time=1.661..1.661 rows=0 loops=2)

  • Output: policysetkeyvalue21.id, policysetkeyvalue21.policysetid, policysetkeyvalue21.parentid, policysetkeyvalue21.index, policysetkeyvalue21.key, policysetkeyvalue21.uri, policysetkeyvalue21.slug, policysetkeyvalue21."boolean", policysetkeyvalue21.date, policysetkeyvalue21.number, policysetkeyvalue21.text, policysetkeyvalue21."time", policysetkeyvalue21.timespan, policysetkeyvalue21.daterange_startdate, policysetkeyvalue21.daterange_enddate, policysetkeyvalue21.daterange_relativedaterangeuri, policysetkeyvalue21.daterange_relativedaterangeasofdate, policysetkeyvalue21.workdayduration_decimalworkdays, policysetkeyvalue21.workdayduration_workdays, policysetkeyvalue21.workdayduration_hours, policysetkeyvalue21.workdayduration_minutes
  • Index Cond: (policysetkeyvalue21.policysetid = userpolicyset20.policysetid)
  • Filter: ((policysetkeyvalue21.parentid IS NULL) AND (upper(policysetkeyvalue21.key) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-ALL-TIME-OFF'::text) AND (upper(policysetkeyvalue21.uri) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-ALL-TIME-OFF:ALLOWED'::text))
  • Rows Removed by Filter: 12
  • Buffers: shared hit=2 read=3
18. 4.818 17,865.912 ↑ 29.3 3,661 1

Nested Loop Semi Join (cost=295.13..16,884,381.51 rows=107,378 width=0) (actual time=57.137..17,865.912 rows=3,661 loops=1)

  • Buffers: shared hit=184893 read=19294
19. 0.826 9,949.673 ↑ 58.7 3,661 1

Append (cost=294.43..24,403.57 rows=214,757 width=4) (actual time=27.966..9,949.673 rows=3,661 loops=1)

  • Buffers: shared hit=56291 read=12059
20. 81.690 9,941.348 ↑ 58.4 3,661 1

Subquery Scan on *SELECT* 1_1 (cost=294.43..23,948.04 rows=213,849 width=4) (actual time=27.965..9,941.348 rows=3,661 loops=1)

  • Output: "*SELECT* 1_1".timeoffid
  • Filter: ((hashed SubPlan 2) OR (hashed SubPlan 3) OR (hashed SubPlan 4) OR (hashed SubPlan 5))
  • Rows Removed by Filter: 224938
  • Buffers: shared hit=56211 read=11976
21. 57.025 9,845.816 ↓ 1.0 228,599 1

Merge Anti Join (cost=0.70..19,092.19 rows=228,106 width=1,553) (actual time=1.062..9,845.816 rows=228,599 loops=1)

  • Output: dm_timeofflist_facts_1.timeoffid, NULL::text, dm_timeofflist_facts_1.timeoffowneruserid, 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_1.timeoffid = dm_timeofflist_realtime_facts_2.timeoffid)
  • Buffers: shared hit=56145 read=11964
22. 9,768.091 9,768.091 ↓ 1.0 229,568 1

Index Scan using dm_timeofflist_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_facts dm_timeofflist_facts_1 (cost=0.42..18,447.82 rows=229,500 width=8) (actual time=1.024..9,768.091 rows=229,568 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 <> 5)
  • Buffers: shared hit=55951 read=11943
23. 20.700 20.700 ↑ 1.0 1,393 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..53.19 rows=1,394 width=4) (actual time=0.035..20.700 rows=1,393 loops=1)

  • Output: dm_timeofflist_realtime_facts_2.timeoffid
  • Heap Fetches: 410
  • Buffers: shared hit=194 read=21
24.          

SubPlan (for Subquery Scan)

25. 6.772 6.772 ↑ 1.0 14 2

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_remainingapprovers_facts list_remainingapprovers_facts1 (cost=0.00..12.43 rows=14 width=4) (actual time=1.578..3.386 rows=14 loops=2)

  • Output: list_remainingapprovers_facts1.timeoffid
  • Filter: (list_remainingapprovers_facts1.approveruserid = 2892)
  • Rows Removed by Filter: 500
  • Buffers: shared hit=6 read=6
26. 0.002 4.486 ↓ 0.0 0 2

Nested Loop (cost=1.41..162.73 rows=1 width=4) (actual time=2.243..2.243 rows=0 loops=2)

  • Output: timeoffapprovalhistory2.timeoffid
  • Inner Unique: true
  • Buffers: shared hit=4 read=4
27. 0.000 4.484 ↓ 0.0 0 2

Nested Loop (cost=0.98..160.28 rows=1 width=20) (actual time=2.242..2.242 rows=0 loops=2)

  • Output: timeoffapprovalhistory2.timeoffid, imeoffapprovalhistorykeyvalue3.parentid
  • Inner Unique: true
  • Buffers: shared hit=4 read=4
28. 4.484 4.484 ↓ 0.0 0 2

Index Scan using ixtoahkvuri on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistorykeyvalue imeoffapprovalhistorykeyvalue3 (cost=0.55..82.04 rows=32 width=20) (actual time=2.242..2.242 rows=0 loops=2)

  • Output: imeoffapprovalhistorykeyvalue3.id, imeoffapprovalhistorykeyvalue3.timeoffapprovalhistoryid, imeoffapprovalhistorykeyvalue3.parentid, imeoffapprovalhistorykeyvalue3.index, imeoffapprovalhistorykeyvalue3.key, imeoffapprovalhistorykeyvalue3.uri, imeoffapprovalhistorykeyvalue3.slug, imeoffapprovalhistorykeyvalue3."boolean", imeoffapprovalhistorykeyvalue3.date, imeoffapprovalhistorykeyvalue3.number, imeoffapprovalhistorykeyvalue3.text, imeoffapprovalhistorykeyvalue3."time", imeoffapprovalhistorykeyvalue3.timespan, imeoffapprovalhistorykeyvalue3.daterange_startdate, imeoffapprovalhistorykeyvalue3.daterange_enddate, imeoffapprovalhistorykeyvalue3.daterange_relativedaterangeuri, imeoffapprovalhistorykeyvalue3.daterange_relativedaterangeasofdate, imeoffapprovalhistorykeyvalue3.workdayduration_decimalworkdays, imeoffapprovalhistorykeyvalue3.workdayduration_workdays, imeoffapprovalhistorykeyvalue3.workdayduration_hours, imeoffapprovalhistorykeyvalue3.workdayduration_minutes
  • Index Cond: (upper(imeoffapprovalhistorykeyvalue3.uri) = 'URN:REPLICON-TENANT:2BC736BCEB814ED5B2CB107A69397ACD:USER:2892'::text)
  • Filter: (upper(imeoffapprovalhistorykeyvalue3.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
  • Buffers: shared hit=4 read=4
29. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalhistory_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory2 (cost=0.42..2.45 rows=1 width=8) (never executed)

  • Output: timeoffapprovalhistory2.id, timeoffapprovalhistory2.timeoffid, timeoffapprovalhistory2.effectivedateutc, timeoffapprovalhistory2.action, timeoffapprovalhistory2.approvalcomments, timeoffapprovalhistory2.approvalagenttype, timeoffapprovalhistory2.userid, timeoffapprovalhistory2.systemprocessidentifier
  • Index Cond: (timeoffapprovalhistory2.id = imeoffapprovalhistorykeyvalue3.timeoffapprovalhistoryid)
  • Filter: (timeoffapprovalhistory2.userid = 2892)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistorykeyvalue imeoffapprovalhistorykeyvalue4 (cost=0.43..2.45 rows=1 width=16) (never executed)

  • Output: imeoffapprovalhistorykeyvalue4.id, imeoffapprovalhistorykeyvalue4.timeoffapprovalhistoryid, imeoffapprovalhistorykeyvalue4.parentid, imeoffapprovalhistorykeyvalue4.index, imeoffapprovalhistorykeyvalue4.key, imeoffapprovalhistorykeyvalue4.uri, imeoffapprovalhistorykeyvalue4.slug, imeoffapprovalhistorykeyvalue4."boolean", imeoffapprovalhistorykeyvalue4.date, imeoffapprovalhistorykeyvalue4.number, imeoffapprovalhistorykeyvalue4.text, imeoffapprovalhistorykeyvalue4."time", imeoffapprovalhistorykeyvalue4.timespan, imeoffapprovalhistorykeyvalue4.daterange_startdate, imeoffapprovalhistorykeyvalue4.daterange_enddate, imeoffapprovalhistorykeyvalue4.daterange_relativedaterangeuri, imeoffapprovalhistorykeyvalue4.daterange_relativedaterangeasofdate, imeoffapprovalhistorykeyvalue4.workdayduration_decimalworkdays, imeoffapprovalhistorykeyvalue4.workdayduration_workdays, imeoffapprovalhistorykeyvalue4.workdayduration_hours, imeoffapprovalhistorykeyvalue4.workdayduration_minutes
  • Index Cond: (imeoffapprovalhistorykeyvalue4.id = imeoffapprovalhistorykeyvalue3.parentid)
  • Filter: (upper(imeoffapprovalhistorykeyvalue4.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
31. 0.356 0.356 ↓ 1.1 70 2

Index Scan using ixuhsupervisorid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userhierarchy userhierarchy5 (cost=0.29..102.10 rows=65 width=4) (actual time=0.033..0.178 rows=70 loops=2)

  • Output: userhierarchy5.userid
  • Index Cond: (userhierarchy5.supervisorid = 2892)
  • Filter: ((userhierarchy5.startdate <= '2020-02-09 00:00:00'::timestamp without time zone) AND (userhierarchy5.enddate >= '2020-02-09 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 92
  • Buffers: shared hit=90
32. 0.010 2.228 ↑ 1.0 13 2

HashAggregate (cost=16.11..16.24 rows=13 width=4) (actual time=1.112..1.114 rows=13 loops=2)

  • Output: timeoffapprovalnodes6.timeoffid
  • Group Key: timeoffapprovalnodes6.timeoffid
  • Buffers: shared hit=21 read=2
33. 0.072 2.218 ↑ 1.0 13 1

Hash Join (cost=7.35..16.07 rows=13 width=4) (actual time=2.164..2.218 rows=13 loops=1)

  • Output: timeoffapprovalnodes6.timeoffid
  • Inner Unique: true
  • Hash Cond: (timeoffapprovalnodes6.id = timeoffapprovalrequest7.nodeid)
  • Buffers: shared hit=21 read=2
34. 0.039 0.039 ↑ 1.0 294 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes6 (cost=0.00..7.94 rows=294 width=20) (actual time=0.009..0.039 rows=294 loops=1)

  • Output: timeoffapprovalnodes6.id, timeoffapprovalnodes6.timeoffid, timeoffapprovalnodes6.isapproved, timeoffapprovalnodes6.approverrole, timeoffapprovalnodes6.userid, timeoffapprovalnodes6.agentresolutionstate, timeoffapprovalnodes6.scriptid
  • Buffers: shared hit=5
35. 0.007 2.107 ↑ 1.0 13 1

Hash (cost=7.19..7.19 rows=13 width=16) (actual time=2.107..2.107 rows=13 loops=1)

  • Output: timeoffapprovalrequest7.nodeid
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=13 read=2
36. 2.100 2.100 ↑ 1.0 13 1

Index Scan using ixtoarapproverid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest7 (cost=0.27..7.19 rows=13 width=16) (actual time=2.090..2.100 rows=13 loops=1)

  • Output: timeoffapprovalrequest7.nodeid
  • Index Cond: (timeoffapprovalrequest7.approverid = 2892)
  • Buffers: shared hit=13 read=2
37. 0.620 7.499 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_1 (cost=293.73..455.53 rows=908 width=4) (actual time=7.499..7.499 rows=0 loops=1)

  • Output: "*SELECT* 2_1".timeoffid
  • Filter: ((hashed SubPlan 2) OR (hashed SubPlan 3) OR (hashed SubPlan 4) OR (hashed SubPlan 5))
  • Rows Removed by Filter: 969
  • Buffers: shared hit=80 read=83
38. 6.879 6.879 ↑ 1.0 969 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_3 (cost=0.00..142.43 rows=969 width=1,553) (actual time=0.006..6.879 rows=969 loops=1)

  • Output: dm_timeofflist_realtime_facts_3.timeoffid, NULL::text, dm_timeofflist_realtime_facts_3.timeoffowneruserid, 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 <> 5))
  • Rows Removed by Filter: 424
  • Buffers: shared hit=25 read=83
39. 24.740 7,911.421 ↑ 3.0 1 3,661

Nested Loop Left Join (cost=0.71..119.43 rows=3 width=4) (actual time=2.161..2.161 rows=1 loops=3,661)

  • Output: timeoffs15.id
  • Filter: (((userhierarchy16.supervisorid = 2892) AND ((userhierarchy16.startdate IS NULL) OR (userhierarchy16.startdate <= '2020-02-09'::date)) AND ((userhierarchy16.enddate IS NULL) OR (userhierarchy16.enddate >= '2020-02-09'::date))) OR (timeoffs15.userid = 2892) OR (alternatives: SubPlan 6 or hashed SubPlan 7) OR (alternatives: SubPlan 8 or hashed SubPlan 9) OR $17 OR (SubPlan 11) OR (SubPlan 12))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=128602 read=7235
40. 29.288 29.288 ↑ 1.0 1 3,661

Index Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs15 (cost=0.42..0.47 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=3,661)

  • Output: timeoffs15.id, timeoffs15.guidid, timeoffs15.userid, timeoffs15.createdbyuserid, timeoffs15.timeoffcodeid, timeoffs15.startdate, timeoffs15.enddate, timeoffs15.approvalstatus, timeoffs15.comments, timeoffs15.submittedonutc, timeoffs15.modifiedonutc, timeoffs15.info1, timeoffs15.info2, timeoffs15.info3, timeoffs15.info4, timeoffs15.info5, timeoffs15.startdurationtype, timeoffs15.enddurationtype, timeoffs15.startduration, timeoffs15.endduration, timeoffs15.startdatestarttime, timeoffs15.enddateendtime, timeoffs15.entryconfigurationmethod
  • Index Cond: (timeoffs15.id = "*SELECT* 1_1".timeoffid)
  • Buffers: shared hit=14636 read=17
41. 14.644 14.644 ↑ 1.0 2 3,661

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

  • Output: userhierarchy16.id, userhierarchy16.userid, userhierarchy16.supervisorid, userhierarchy16.startdate, userhierarchy16.enddate
  • Index Cond: (userhierarchy16.userid = timeoffs15.userid)
  • Buffers: shared hit=12801
42.          

SubPlan (for Nested Loop Left Join)

43. 8.666 17.895 ↓ 0.0 0 5,965

Nested Loop (cost=0.55..4.87 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=5,965)

  • Inner Unique: true
  • Buffers: shared hit=13343 read=3
44. 5.965 5.965 ↓ 0.0 0 5,965

Index Scan using ixtoantimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes17 (cost=0.27..2.29 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=5,965)

  • Output: timeoffapprovalnodes17.id, timeoffapprovalnodes17.timeoffid, timeoffapprovalnodes17.isapproved, timeoffapprovalnodes17.approverrole, timeoffapprovalnodes17.userid, timeoffapprovalnodes17.agentresolutionstate, timeoffapprovalnodes17.scriptid
  • Index Cond: (timeoffapprovalnodes17.timeoffid = timeoffs15.id)
  • Buffers: shared hit=13309
45. 3.264 3.264 ↑ 1.0 1 12

Index Only Scan using uix2toaraidnid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest18 (cost=0.27..2.29 rows=1 width=16) (actual time=0.272..0.272 rows=1 loops=12)

  • Output: timeoffapprovalrequest18.approverid, timeoffapprovalrequest18.nodeid
  • Index Cond: ((timeoffapprovalrequest18.approverid = 2892) AND (timeoffapprovalrequest18.nodeid = timeoffapprovalnodes17.id))
  • Heap Fetches: 12
  • Buffers: shared hit=34 read=3
46. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7.35..16.07 rows=13 width=4) (never executed)

  • Output: timeoffapprovalnodes17_1.timeoffid
  • Inner Unique: true
  • Hash Cond: (timeoffapprovalnodes17_1.id = timeoffapprovalrequest18_1.nodeid)
47. 0.000 0.000 ↓ 0.0 0

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes17_1 (cost=0.00..7.94 rows=294 width=20) (never executed)

  • Output: timeoffapprovalnodes17_1.id, timeoffapprovalnodes17_1.timeoffid, timeoffapprovalnodes17_1.isapproved, timeoffapprovalnodes17_1.approverrole, timeoffapprovalnodes17_1.userid, timeoffapprovalnodes17_1.agentresolutionstate, timeoffapprovalnodes17_1.scriptid
48. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.19..7.19 rows=13 width=16) (never executed)

  • Output: timeoffapprovalrequest18_1.nodeid
49. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoarapproverid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest18_1 (cost=0.27..7.19 rows=13 width=16) (never executed)

  • Output: timeoffapprovalrequest18_1.nodeid
  • Index Cond: (timeoffapprovalrequest18_1.approverid = 2892)
50. 196.449 196.449 ↓ 0.0 0 5,953

Index Scan using ixtoahtimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory19 (cost=0.42..3.47 rows=1 width=0) (actual time=0.033..0.033 rows=0 loops=5,953)

  • Index Cond: (timeoffapprovalhistory19.timeoffid = timeoffs15.id)
  • Filter: ((timeoffapprovalhistory19.userid = 2892) AND (timeoffapprovalhistory19.action = ANY ('{2,3,4}'::integer[])))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=27431 read=135
51. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahuserid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory19_1 (cost=0.42..1,239.28 rows=657 width=4) (never executed)

  • Output: timeoffapprovalhistory19_1.timeoffid
  • Index Cond: (timeoffapprovalhistory19_1.userid = 2892)
  • Filter: (timeoffapprovalhistory19_1.action = ANY ('{2,3,4}'::integer[]))
52. 26.005 26.005 ↓ 0.0 0 5,201

CTE Scan on timesheet0cte timesheet22 (cost=0.00..0.06 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=5,201)

  • Filter: ((timeoffs15.startdate <= timesheet22.enddate2) AND (timeoffs15.enddate >= timesheet22.startdate1) AND (timesheet22.userid0 = timeoffs15.userid) AND ((('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text = upper(timesheet22.key3)) AND ('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper(timesheet22.uri4))) OR (('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text = upper(timesheet22.key3)) AND (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15.id)::text, ''::text))) = upper(timesheet22.uri4)))))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=35 read=23
53. 6.176 7,602.400 ↓ 0.0 0 5,200

Nested Loop (cost=3.87..50.90 rows=1 width=0) (actual time=1.462..1.462 rows=0 loops=5,200)

  • Join Filter: (((upper(esheetapprovalhistorykeyvalue6.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text) OR ((upper(esheetapprovalhistorykeyvalue6.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text) AND (upper(esheetapprovalhistorykeyvalue7.uri) = 'URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text))) AND ((('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text = upper((esheetapprovalhistorykeyvalue6.uri)::text)) AND ('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper((esheetapprovalhistorykeyvalue7.uri)::text))) OR (('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text = upper((esheetapprovalhistorykeyvalue6.uri)::text)) AND (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15.id)::text, ''::text))) = upper((esheetapprovalhistorykeyvalue7.uri)::text)))))
  • Buffers: shared hit=60351 read=7053
54. 5.880 6,822.400 ↓ 0.0 0 5,200

Nested Loop (cost=3.44..50.27 rows=1 width=85) (actual time=1.311..1.312 rows=0 loops=5,200)

  • Output: esheetapprovalhistorykeyvalue6.uri, sheetapprovalhistorykeyvalue13.id
  • Buffers: shared hit=57190 read=6374
55. 0.176 6,224.400 ↓ 0.0 0 5,200

Nested Loop (cost=3.01..45.82 rows=1 width=85) (actual time=1.197..1.197 rows=0 loops=5,200)

  • Output: esheetapprovalhistorykeyvalue6.id, esheetapprovalhistorykeyvalue6.uri
  • Buffers: shared hit=54131 read=5807
56. 3.248 5,616.000 ↓ 0.0 0 5,200

Nested Loop (cost=2.57..45.23 rows=1 width=16) (actual time=1.079..1.080 rows=0 loops=5,200)

  • Output: sheetapprovalhistorykeyvalue12.id
  • Buffers: shared hit=51052 read=5225
57. 5.376 4,997.200 ↓ 0.0 0 5,200

Nested Loop (cost=2.14..43.87 rows=1 width=16) (actual time=0.960..0.961 rows=0 loops=5,200)

  • Output: sheetapprovalhistorykeyvalue11.id
  • Buffers: shared hit=47961 read=4648
58. 2.624 4,383.600 ↓ 0.0 0 5,200

Nested Loop (cost=1.71..41.76 rows=1 width=16) (actual time=0.842..0.843 rows=0 loops=5,200)

  • Output: sheetapprovalhistorykeyvalue10.parentid
  • Inner Unique: true
  • Buffers: shared hit=44753 read=4074
59. 4.136 3,432.000 ↓ 0.0 0 5,200

Nested Loop (cost=1.27..39.38 rows=1 width=16) (actual time=0.659..0.660 rows=0 loops=5,200)

  • Output: esheetapprovalhistorykeyvalue9.parentid
  • Buffers: shared hit=41870 read=3286
60. 9.234 1,638.000 ↓ 0.0 0 5,200

Nested Loop (cost=0.84..14.26 rows=1 width=16) (actual time=0.315..0.315 rows=0 loops=5,200)

  • Output: timesheetapprovalhistory8.id
  • Buffers: shared hit=38912 read=1645
61. 26.000 26.000 ↑ 2.0 1 5,200

Index Scan using ixtsuseridstartdateenddate on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet5 (cost=0.42..3.24 rows=2 width=16) (actual time=0.005..0.005 rows=1 loops=5,200)

  • Output: timesheet5.id, timesheet5.userid, timesheet5.startdate, timesheet5.enddate, timesheet5.approvalstatus, timesheet5.duedate, timesheet5.autosubmitdatetimeutc, timesheet5.lastautosubmitattemptdatetimeutc, timesheet5.createdonutc
  • Index Cond: ((timesheet5.userid = timeoffs15.userid) AND (timeoffs15.enddate >= timesheet5.startdate) AND (timeoffs15.startdate <= timesheet5.enddate))
  • Buffers: shared hit=20211 read=6
62. 1,602.766 1,602.766 ↓ 0.0 0 3,938

Index Scan using ixtah2timesheetid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory8 (cost=0.42..5.50 rows=1 width=32) (actual time=0.407..0.407 rows=0 loops=3,938)

  • Output: timesheetapprovalhistory8.id, timesheetapprovalhistory8.action, timesheetapprovalhistory8.approvalcomments, timesheetapprovalhistory8.timestamputc, timesheetapprovalhistory8.serialnumber, timesheetapprovalhistory8.timesheetid, timesheetapprovalhistory8.approvalagenttype, timesheetapprovalhistory8.userid, timesheetapprovalhistory8.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory8.timesheetid = timesheet5.id)
  • Filter: (timesheetapprovalhistory8.userid = 2892)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=18701 read=1639
63. 1,789.864 1,789.864 ↑ 1.0 1 916

Index Scan using ixtahkvtimesheetapprovalhistoryid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue9 (cost=0.43..25.11 rows=1 width=32) (actual time=1.953..1.954 rows=1 loops=916)

  • Output: esheetapprovalhistorykeyvalue9.id, esheetapprovalhistorykeyvalue9.timesheetapprovalhistoryid, esheetapprovalhistorykeyvalue9.parentid, esheetapprovalhistorykeyvalue9.index, esheetapprovalhistorykeyvalue9.key, esheetapprovalhistorykeyvalue9.uri, esheetapprovalhistorykeyvalue9.slug, esheetapprovalhistorykeyvalue9."boolean", esheetapprovalhistorykeyvalue9.date, esheetapprovalhistorykeyvalue9.number, esheetapprovalhistorykeyvalue9.text, esheetapprovalhistorykeyvalue9."time", esheetapprovalhistorykeyvalue9.timespan, esheetapprovalhistorykeyvalue9.daterange_startdate, esheetapprovalhistorykeyvalue9.daterange_enddate, esheetapprovalhistorykeyvalue9.daterange_relativedaterangeuri, esheetapprovalhistorykeyvalue9.daterange_relativedaterangeasofdate, esheetapprovalhistorykeyvalue9.workdayduration_decimalworkdays, esheetapprovalhistorykeyvalue9.workdayduration_workdays, esheetapprovalhistorykeyvalue9.workdayduration_hours, esheetapprovalhistorykeyvalue9.workdayduration_minutes
  • Index Cond: (esheetapprovalhistorykeyvalue9.timesheetapprovalhistoryid = timesheetapprovalhistory8.id)
  • Filter: ((upper(esheetapprovalhistorykeyvalue9.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(esheetapprovalhistorykeyvalue9.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2892'::text))
  • Rows Removed by Filter: 22
  • Buffers: shared hit=2958 read=1641
64. 948.976 948.976 ↑ 1.0 1 916

Index Scan using timesheetapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue10 (cost=0.43..2.38 rows=1 width=32) (actual time=1.036..1.036 rows=1 loops=916)

  • Output: sheetapprovalhistorykeyvalue10.id, sheetapprovalhistorykeyvalue10.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue10.parentid, sheetapprovalhistorykeyvalue10.index, sheetapprovalhistorykeyvalue10.key, sheetapprovalhistorykeyvalue10.uri, sheetapprovalhistorykeyvalue10.slug, sheetapprovalhistorykeyvalue10."boolean", sheetapprovalhistorykeyvalue10.date, sheetapprovalhistorykeyvalue10.number, sheetapprovalhistorykeyvalue10.text, sheetapprovalhistorykeyvalue10."time", sheetapprovalhistorykeyvalue10.timespan, sheetapprovalhistorykeyvalue10.daterange_startdate, sheetapprovalhistorykeyvalue10.daterange_enddate, sheetapprovalhistorykeyvalue10.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue10.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue10.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue10.workdayduration_workdays, sheetapprovalhistorykeyvalue10.workdayduration_hours, sheetapprovalhistorykeyvalue10.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue10.id = esheetapprovalhistorykeyvalue9.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue10.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
  • Buffers: shared hit=2883 read=788
65. 608.224 608.224 ↑ 1.0 1 916

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue11 (cost=0.43..2.10 rows=1 width=32) (actual time=0.664..0.664 rows=1 loops=916)

  • Output: sheetapprovalhistorykeyvalue11.id, sheetapprovalhistorykeyvalue11.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue11.parentid, sheetapprovalhistorykeyvalue11.index, sheetapprovalhistorykeyvalue11.key, sheetapprovalhistorykeyvalue11.uri, sheetapprovalhistorykeyvalue11.slug, sheetapprovalhistorykeyvalue11."boolean", sheetapprovalhistorykeyvalue11.date, sheetapprovalhistorykeyvalue11.number, sheetapprovalhistorykeyvalue11.text, sheetapprovalhistorykeyvalue11."time", sheetapprovalhistorykeyvalue11.timespan, sheetapprovalhistorykeyvalue11.daterange_startdate, sheetapprovalhistorykeyvalue11.daterange_enddate, sheetapprovalhistorykeyvalue11.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue11.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue11.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue11.workdayduration_workdays, sheetapprovalhistorykeyvalue11.workdayduration_hours, sheetapprovalhistorykeyvalue11.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue11.parentid = sheetapprovalhistorykeyvalue10.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue11.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=3208 read=574
66. 615.552 615.552 ↑ 3.0 1 916

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue12 (cost=0.43..1.33 rows=3 width=32) (actual time=0.672..0.672 rows=1 loops=916)

  • Output: sheetapprovalhistorykeyvalue12.id, sheetapprovalhistorykeyvalue12.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue12.parentid, sheetapprovalhistorykeyvalue12.index, sheetapprovalhistorykeyvalue12.key, sheetapprovalhistorykeyvalue12.uri, sheetapprovalhistorykeyvalue12.slug, sheetapprovalhistorykeyvalue12."boolean", sheetapprovalhistorykeyvalue12.date, sheetapprovalhistorykeyvalue12.number, sheetapprovalhistorykeyvalue12.text, sheetapprovalhistorykeyvalue12."time", sheetapprovalhistorykeyvalue12.timespan, sheetapprovalhistorykeyvalue12.daterange_startdate, sheetapprovalhistorykeyvalue12.daterange_enddate, sheetapprovalhistorykeyvalue12.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue12.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue12.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue12.workdayduration_workdays, sheetapprovalhistorykeyvalue12.workdayduration_hours, sheetapprovalhistorykeyvalue12.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue12.parentid = sheetapprovalhistorykeyvalue11.id)
  • Buffers: shared hit=3091 read=577
67. 608.224 608.224 ↑ 1.0 1 916

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue6 (cost=0.43..0.58 rows=1 width=101) (actual time=0.664..0.664 rows=1 loops=916)

  • Output: esheetapprovalhistorykeyvalue6.id, esheetapprovalhistorykeyvalue6.timesheetapprovalhistoryid, esheetapprovalhistorykeyvalue6.parentid, esheetapprovalhistorykeyvalue6.index, esheetapprovalhistorykeyvalue6.key, esheetapprovalhistorykeyvalue6.uri, esheetapprovalhistorykeyvalue6.slug, esheetapprovalhistorykeyvalue6."boolean", esheetapprovalhistorykeyvalue6.date, esheetapprovalhistorykeyvalue6.number, esheetapprovalhistorykeyvalue6.text, esheetapprovalhistorykeyvalue6."time", esheetapprovalhistorykeyvalue6.timespan, esheetapprovalhistorykeyvalue6.daterange_startdate, esheetapprovalhistorykeyvalue6.daterange_enddate, esheetapprovalhistorykeyvalue6.daterange_relativedaterangeuri, esheetapprovalhistorykeyvalue6.daterange_relativedaterangeasofdate, esheetapprovalhistorykeyvalue6.workdayduration_decimalworkdays, esheetapprovalhistorykeyvalue6.workdayduration_workdays, esheetapprovalhistorykeyvalue6.workdayduration_hours, esheetapprovalhistorykeyvalue6.workdayduration_minutes
  • Index Cond: (esheetapprovalhistorykeyvalue6.parentid = sheetapprovalhistorykeyvalue12.id)
  • Filter: (((upper(esheetapprovalhistorykeyvalue6.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text) OR (upper(esheetapprovalhistorykeyvalue6.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)) AND (('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text = upper((esheetapprovalhistorykeyvalue6.uri)::text)) OR ('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text = upper((esheetapprovalhistorykeyvalue6.uri)::text))))
  • Buffers: shared hit=3079 read=582
68. 592.120 592.120 ↑ 3.0 1 904

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue13 (cost=0.43..4.42 rows=3 width=32) (actual time=0.655..0.655 rows=1 loops=904)

  • Output: sheetapprovalhistorykeyvalue13.id, sheetapprovalhistorykeyvalue13.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue13.parentid, sheetapprovalhistorykeyvalue13.index, sheetapprovalhistorykeyvalue13.key, sheetapprovalhistorykeyvalue13.uri, sheetapprovalhistorykeyvalue13.slug, sheetapprovalhistorykeyvalue13."boolean", sheetapprovalhistorykeyvalue13.date, sheetapprovalhistorykeyvalue13.number, sheetapprovalhistorykeyvalue13.text, sheetapprovalhistorykeyvalue13."time", sheetapprovalhistorykeyvalue13.timespan, sheetapprovalhistorykeyvalue13.daterange_startdate, sheetapprovalhistorykeyvalue13.daterange_enddate, sheetapprovalhistorykeyvalue13.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue13.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue13.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue13.workdayduration_workdays, sheetapprovalhistorykeyvalue13.workdayduration_hours, sheetapprovalhistorykeyvalue13.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue13.parentid = esheetapprovalhistorykeyvalue6.id)
  • Buffers: shared hit=3059 read=567
69. 773.824 773.824 ↑ 1.0 1 904

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue7 (cost=0.43..0.58 rows=1 width=85) (actual time=0.856..0.856 rows=1 loops=904)

  • Output: esheetapprovalhistorykeyvalue7.id, esheetapprovalhistorykeyvalue7.timesheetapprovalhistoryid, esheetapprovalhistorykeyvalue7.parentid, esheetapprovalhistorykeyvalue7.index, esheetapprovalhistorykeyvalue7.key, esheetapprovalhistorykeyvalue7.uri, esheetapprovalhistorykeyvalue7.slug, esheetapprovalhistorykeyvalue7."boolean", esheetapprovalhistorykeyvalue7.date, esheetapprovalhistorykeyvalue7.number, esheetapprovalhistorykeyvalue7.text, esheetapprovalhistorykeyvalue7."time", esheetapprovalhistorykeyvalue7.timespan, esheetapprovalhistorykeyvalue7.daterange_startdate, esheetapprovalhistorykeyvalue7.daterange_enddate, esheetapprovalhistorykeyvalue7.daterange_relativedaterangeuri, esheetapprovalhistorykeyvalue7.daterange_relativedaterangeasofdate, esheetapprovalhistorykeyvalue7.workdayduration_decimalworkdays, esheetapprovalhistorykeyvalue7.workdayduration_workdays, esheetapprovalhistorykeyvalue7.workdayduration_hours, esheetapprovalhistorykeyvalue7.workdayduration_minutes
  • Index Cond: (esheetapprovalhistorykeyvalue7.parentid = sheetapprovalhistorykeyvalue13.id)
  • Filter: (('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper((esheetapprovalhistorykeyvalue7.uri)::text)) OR (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15.id)::text, ''::text))) = upper((esheetapprovalhistorykeyvalue7.uri)::text)))
  • Rows Removed by Filter: 5
  • Buffers: shared hit=3161 read=679
70. 0.000 304.414 ↑ 1.0 1 1

Aggregate (cost=23,697.72..23,697.73 rows=1 width=8) (actual time=304.413..304.414 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=11804 read=2454
71.          

Initplan (for Aggregate)

72. 0.003 0.067 ↓ 0.0 0 1

Nested Loop (cost=0.43..11.37 rows=1 width=0) (actual time=0.067..0.067 rows=0 loops=1)

  • Buffers: shared hit=9
73. 0.012 0.012 ↑ 1.0 2 1

Index Only Scan using userpolicyset_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userpolicyset userpolicyset20_1 (cost=0.29..3.23 rows=2 width=16) (actual time=0.012..0.012 rows=2 loops=1)

  • Output: userpolicyset20_1.userid, userpolicyset20_1.policysetid
  • Index Cond: (userpolicyset20_1.userid = 2892)
  • Heap Fetches: 2
  • Buffers: shared hit=4
74. 0.052 0.052 ↓ 0.0 0 2

Index Scan using ixpskvpolicysetid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.policysetkeyvalue policysetkeyvalue21_1 (cost=0.14..4.06 rows=1 width=16) (actual time=0.026..0.026 rows=0 loops=2)

  • Output: policysetkeyvalue21_1.id, policysetkeyvalue21_1.policysetid, policysetkeyvalue21_1.parentid, policysetkeyvalue21_1.index, policysetkeyvalue21_1.key, policysetkeyvalue21_1.uri, policysetkeyvalue21_1.slug, policysetkeyvalue21_1."boolean", policysetkeyvalue21_1.date, policysetkeyvalue21_1.number, policysetkeyvalue21_1.text, policysetkeyvalue21_1."time", policysetkeyvalue21_1.timespan, policysetkeyvalue21_1.daterange_startdate, policysetkeyvalue21_1.daterange_enddate, policysetkeyvalue21_1.daterange_relativedaterangeuri, policysetkeyvalue21_1.daterange_relativedaterangeasofdate, policysetkeyvalue21_1.workdayduration_decimalworkdays, policysetkeyvalue21_1.workdayduration_workdays, policysetkeyvalue21_1.workdayduration_hours, policysetkeyvalue21_1.workdayduration_minutes
  • Index Cond: (policysetkeyvalue21_1.policysetid = userpolicyset20_1.policysetid)
  • Filter: ((policysetkeyvalue21_1.parentid IS NULL) AND (upper(policysetkeyvalue21_1.key) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-ALL-TIME-OFF'::text) AND (upper(policysetkeyvalue21_1.uri) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-ALL-TIME-OFF:ALLOWED'::text))
  • Rows Removed by Filter: 12
  • Buffers: shared hit=5
75. 0.024 304.407 ↑ 5.5 20 1

Nested Loop Semi Join (cost=1,278.44..23,686.08 rows=111 width=0) (actual time=40.368..304.407 rows=20 loops=1)

  • Buffers: shared hit=11804 read=2454
76. 0.004 303.443 ↑ 5.5 20 1

Append (cost=1,277.74..16,356.19 rows=111 width=4) (actual time=40.152..303.443 rows=20 loops=1)

  • Buffers: shared hit=10695 read=2454
77. 0.000 302.622 ↑ 5.0 20 1

Subquery Scan on *SELECT* 1_2 (cost=1,277.74..15,932.61 rows=101 width=4) (actual time=40.151..302.622 rows=20 loops=1)

  • Output: "*SELECT* 1_2".timeoffid
  • Filter: ((hashed SubPlan 14) OR (hashed SubPlan 15) OR (hashed SubPlan 16))
  • Rows Removed by Filter: 93
  • Buffers: shared hit=10515 read=2454
78. 120.438 302.319 ↑ 1.0 113 1

Gather (cost=1,000.28..15,653.14 rows=115 width=1,553) (actual time=4.030..302.319 rows=113 loops=1)

  • Output: dm_timeofflist_facts_2.timeoffid, NULL::text, dm_timeofflist_facts_2.timeoffowneruserid, 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
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=10460 read=2454
79. 0.053 181.881 ↑ 1.3 38 3 / 3

Nested Loop Anti Join (cost=0.28..14,641.64 rows=48 width=1,553) (actual time=0.425..181.881 rows=38 loops=3)

  • Output: dm_timeofflist_facts_2.timeoffid, NULL::text, dm_timeofflist_facts_2.timeoffowneruserid, 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=10460 read=2454
  • Worker 0: actual time=0.022..289.015 rows=35 loops=1
  • Buffers: shared hit=2955 read=490
  • Worker 1: actual time=1.042..191.826 rows=22 loops=1
  • Buffers: shared hit=2633 read=388
80. 181.751 181.751 ↑ 1.3 38 3 / 3

Parallel Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_facts dm_timeofflist_facts_2 (cost=0.00..14,614.79 rows=48 width=8) (actual time=0.410..181.751 rows=38 loops=3)

  • 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 <> 5) AND (dm_timeofflist_facts_2.timeoffstatus = 3))
  • Rows Removed by Filter: 76484
  • Buffers: shared hit=10226 read=2454
  • Worker 0: actual time=0.010..288.898 rows=35 loops=1
  • Buffers: shared hit=2884 read=490
  • Worker 1: actual time=1.027..191.754 rows=22 loops=1
  • Buffers: shared hit=2587 read=388
81. 0.077 0.077 ↓ 0.0 0 115 / 3

Index Only Scan using dm_timeofflist_realtime_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_4 (cost=0.28..0.55 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=115)

  • 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=234
  • Worker 0: actual time=0.002..0.002 rows=0 loops=35
  • Buffers: shared hit=71
  • Worker 1: actual time=0.002..0.002 rows=0 loops=22
  • Buffers: shared hit=46
82.          

SubPlan (for Subquery Scan)

83. 0.128 0.128 ↑ 1.0 14 2

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_remainingapprovers_facts list_remainingapprovers_facts9 (cost=0.00..12.43 rows=14 width=4) (actual time=0.034..0.064 rows=14 loops=2)

  • Output: list_remainingapprovers_facts9.timeoffid
  • Filter: (list_remainingapprovers_facts9.approveruserid = 2892)
  • Rows Removed by Filter: 500
  • Buffers: shared hit=12
84. 0.002 0.072 ↓ 0.0 0 2

Nested Loop (cost=1.41..162.73 rows=1 width=4) (actual time=0.036..0.036 rows=0 loops=2)

  • Output: timeoffapprovalhistory10.timeoffid
  • Inner Unique: true
  • Buffers: shared hit=8
85. 0.000 0.070 ↓ 0.0 0 2

Nested Loop (cost=0.98..160.28 rows=1 width=20) (actual time=0.035..0.035 rows=0 loops=2)

  • Output: timeoffapprovalhistory10.timeoffid, meoffapprovalhistorykeyvalue11.parentid
  • Inner Unique: true
  • Buffers: shared hit=8
86. 0.070 0.070 ↓ 0.0 0 2

Index Scan using ixtoahkvuri on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistorykeyvalue meoffapprovalhistorykeyvalue11 (cost=0.55..82.04 rows=32 width=20) (actual time=0.035..0.035 rows=0 loops=2)

  • Output: meoffapprovalhistorykeyvalue11.id, meoffapprovalhistorykeyvalue11.timeoffapprovalhistoryid, meoffapprovalhistorykeyvalue11.parentid, meoffapprovalhistorykeyvalue11.index, meoffapprovalhistorykeyvalue11.key, meoffapprovalhistorykeyvalue11.uri, meoffapprovalhistorykeyvalue11.slug, meoffapprovalhistorykeyvalue11."boolean", meoffapprovalhistorykeyvalue11.date, meoffapprovalhistorykeyvalue11.number, meoffapprovalhistorykeyvalue11.text, meoffapprovalhistorykeyvalue11."time", meoffapprovalhistorykeyvalue11.timespan, meoffapprovalhistorykeyvalue11.daterange_startdate, meoffapprovalhistorykeyvalue11.daterange_enddate, meoffapprovalhistorykeyvalue11.daterange_relativedaterangeuri, meoffapprovalhistorykeyvalue11.daterange_relativedaterangeasofdate, meoffapprovalhistorykeyvalue11.workdayduration_decimalworkdays, meoffapprovalhistorykeyvalue11.workdayduration_workdays, meoffapprovalhistorykeyvalue11.workdayduration_hours, meoffapprovalhistorykeyvalue11.workdayduration_minutes
  • Index Cond: (upper(meoffapprovalhistorykeyvalue11.uri) = 'URN:REPLICON-TENANT:2BC736BCEB814ED5B2CB107A69397ACD:USER:2892'::text)
  • Filter: (upper(meoffapprovalhistorykeyvalue11.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
  • Buffers: shared hit=8
87. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalhistory_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory10 (cost=0.42..2.45 rows=1 width=8) (never executed)

  • Output: timeoffapprovalhistory10.id, timeoffapprovalhistory10.timeoffid, timeoffapprovalhistory10.effectivedateutc, timeoffapprovalhistory10.action, timeoffapprovalhistory10.approvalcomments, timeoffapprovalhistory10.approvalagenttype, timeoffapprovalhistory10.userid, timeoffapprovalhistory10.systemprocessidentifier
  • Index Cond: (timeoffapprovalhistory10.id = meoffapprovalhistorykeyvalue11.timeoffapprovalhistoryid)
  • Filter: (timeoffapprovalhistory10.userid = 2892)
88. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistorykeyvalue meoffapprovalhistorykeyvalue12 (cost=0.43..2.45 rows=1 width=16) (never executed)

  • Output: meoffapprovalhistorykeyvalue12.id, meoffapprovalhistorykeyvalue12.timeoffapprovalhistoryid, meoffapprovalhistorykeyvalue12.parentid, meoffapprovalhistorykeyvalue12.index, meoffapprovalhistorykeyvalue12.key, meoffapprovalhistorykeyvalue12.uri, meoffapprovalhistorykeyvalue12.slug, meoffapprovalhistorykeyvalue12."boolean", meoffapprovalhistorykeyvalue12.date, meoffapprovalhistorykeyvalue12.number, meoffapprovalhistorykeyvalue12.text, meoffapprovalhistorykeyvalue12."time", meoffapprovalhistorykeyvalue12.timespan, meoffapprovalhistorykeyvalue12.daterange_startdate, meoffapprovalhistorykeyvalue12.daterange_enddate, meoffapprovalhistorykeyvalue12.daterange_relativedaterangeuri, meoffapprovalhistorykeyvalue12.daterange_relativedaterangeasofdate, meoffapprovalhistorykeyvalue12.workdayduration_decimalworkdays, meoffapprovalhistorykeyvalue12.workdayduration_workdays, meoffapprovalhistorykeyvalue12.workdayduration_hours, meoffapprovalhistorykeyvalue12.workdayduration_minutes
  • Index Cond: (meoffapprovalhistorykeyvalue12.id = meoffapprovalhistorykeyvalue11.parentid)
  • Filter: (upper(meoffapprovalhistorykeyvalue12.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
89. 0.414 0.414 ↓ 1.1 70 2

Index Scan using ixuhsupervisorid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userhierarchy userhierarchy13 (cost=0.29..102.10 rows=65 width=4) (actual time=0.036..0.207 rows=70 loops=2)

  • Output: userhierarchy13.userid
  • Index Cond: (userhierarchy13.supervisorid = 2892)
  • Filter: ((userhierarchy13.startdate <= '2020-02-09 00:00:00'::timestamp without time zone) AND (userhierarchy13.enddate >= '2020-02-09 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 92
  • Buffers: shared hit=90
90. 0.303 0.817 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_2 (cost=277.46..423.58 rows=10 width=4) (actual time=0.817..0.817 rows=0 loops=1)

  • Output: "*SELECT* 2_2".timeoffid
  • Filter: ((hashed SubPlan 14) OR (hashed SubPlan 15) OR (hashed SubPlan 16))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=180
91. 0.514 0.514 ↑ 6.0 2 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_5 (cost=0.00..145.91 rows=12 width=1,553) (actual time=0.144..0.514 rows=2 loops=1)

  • Output: dm_timeofflist_realtime_facts_5.timeoffid, NULL::text, dm_timeofflist_realtime_facts_5.timeoffowneruserid, 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 <> 5) AND (dm_timeofflist_realtime_facts_5.timeoffstatus = 3))
  • Rows Removed by Filter: 1391
  • Buffers: shared hit=125
92. 0.180 0.940 ↑ 3.0 1 20

Nested Loop Left Join (cost=0.71..121.32 rows=3 width=4) (actual time=0.047..0.047 rows=1 loops=20)

  • Output: timeoffs15_1.id
  • Filter: (((userhierarchy16_1.supervisorid = 2892) AND ((userhierarchy16_1.startdate IS NULL) OR (userhierarchy16_1.startdate <= '2020-02-09'::date)) AND ((userhierarchy16_1.enddate IS NULL) OR (userhierarchy16_1.enddate >= '2020-02-09'::date))) OR (timeoffs15_1.userid = 2892) OR (alternatives: SubPlan 17 or hashed SubPlan 18) OR (alternatives: SubPlan 19 or hashed SubPlan 20) OR $48 OR (SubPlan 22) OR (SubPlan 23))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=1109
93. 0.060 0.060 ↑ 1.0 1 20

Index Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs15_1 (cost=0.42..2.37 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=20)

  • Output: timeoffs15_1.id, timeoffs15_1.guidid, timeoffs15_1.userid, timeoffs15_1.createdbyuserid, timeoffs15_1.timeoffcodeid, timeoffs15_1.startdate, timeoffs15_1.enddate, timeoffs15_1.approvalstatus, timeoffs15_1.comments, timeoffs15_1.submittedonutc, timeoffs15_1.modifiedonutc, timeoffs15_1.info1, timeoffs15_1.info2, timeoffs15_1.info3, timeoffs15_1.info4, timeoffs15_1.info5, timeoffs15_1.startdurationtype, timeoffs15_1.enddurationtype, timeoffs15_1.startduration, timeoffs15_1.endduration, timeoffs15_1.startdatestarttime, timeoffs15_1.enddateendtime, timeoffs15_1.entryconfigurationmethod
  • Index Cond: (timeoffs15_1.id = "*SELECT* 1_2".timeoffid)
  • Buffers: shared hit=80
94. 0.040 0.040 ↓ 2.0 4 20

Index Scan using ix3uh_usersuperstart on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userhierarchy userhierarchy16_1 (cost=0.29..0.32 rows=2 width=24) (actual time=0.002..0.002 rows=4 loops=20)

  • Output: userhierarchy16_1.id, userhierarchy16_1.userid, userhierarchy16_1.supervisorid, userhierarchy16_1.startdate, userhierarchy16_1.enddate
  • Index Cond: (userhierarchy16_1.userid = timeoffs15_1.userid)
  • Buffers: shared hit=60
95.          

SubPlan (for Nested Loop Left Join)

96. 0.000 0.060 ↓ 0.0 0 60

Nested Loop (cost=0.55..4.87 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=60)

  • Inner Unique: true
  • Buffers: shared hit=120
97. 0.060 0.060 ↓ 0.0 0 60

Index Scan using ixtoantimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes17_2 (cost=0.27..2.29 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=60)

  • Output: timeoffapprovalnodes17_2.id, timeoffapprovalnodes17_2.timeoffid, timeoffapprovalnodes17_2.isapproved, timeoffapprovalnodes17_2.approverrole, timeoffapprovalnodes17_2.userid, timeoffapprovalnodes17_2.agentresolutionstate, timeoffapprovalnodes17_2.scriptid
  • Index Cond: (timeoffapprovalnodes17_2.timeoffid = timeoffs15_1.id)
  • Buffers: shared hit=120
98. 0.000 0.000 ↓ 0.0 0

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

  • Output: timeoffapprovalrequest18_2.approverid, timeoffapprovalrequest18_2.nodeid
  • Index Cond: ((timeoffapprovalrequest18_2.approverid = 2892) AND (timeoffapprovalrequest18_2.nodeid = timeoffapprovalnodes17_2.id))
  • Heap Fetches: 0
99. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7.35..16.07 rows=13 width=4) (never executed)

  • Output: timeoffapprovalnodes17_3.timeoffid
  • Inner Unique: true
  • Hash Cond: (timeoffapprovalnodes17_3.id = timeoffapprovalrequest18_3.nodeid)
100. 0.000 0.000 ↓ 0.0 0

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes17_3 (cost=0.00..7.94 rows=294 width=20) (never executed)

  • Output: timeoffapprovalnodes17_3.id, timeoffapprovalnodes17_3.timeoffid, timeoffapprovalnodes17_3.isapproved, timeoffapprovalnodes17_3.approverrole, timeoffapprovalnodes17_3.userid, timeoffapprovalnodes17_3.agentresolutionstate, timeoffapprovalnodes17_3.scriptid
101. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.19..7.19 rows=13 width=16) (never executed)

  • Output: timeoffapprovalrequest18_3.nodeid
102. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoarapproverid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest18_3 (cost=0.27..7.19 rows=13 width=16) (never executed)

  • Output: timeoffapprovalrequest18_3.nodeid
  • Index Cond: (timeoffapprovalrequest18_3.approverid = 2892)
103. 0.120 0.120 ↓ 0.0 0 60

Index Scan using ixtoahtimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory19_2 (cost=0.42..3.47 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=60)

  • Index Cond: (timeoffapprovalhistory19_2.timeoffid = timeoffs15_1.id)
  • Filter: ((timeoffapprovalhistory19_2.userid = 2892) AND (timeoffapprovalhistory19_2.action = ANY ('{2,3,4}'::integer[])))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=300
104. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahuserid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory19_3 (cost=0.42..1,239.28 rows=657 width=4) (never executed)

  • Output: timeoffapprovalhistory19_3.timeoffid
  • Index Cond: (timeoffapprovalhistory19_3.userid = 2892)
  • Filter: (timeoffapprovalhistory19_3.action = ANY ('{2,3,4}'::integer[]))
105. 0.060 0.060 ↓ 0.0 0 60

CTE Scan on timesheet0cte timesheet22_1 (cost=0.00..0.06 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=60)

  • Filter: ((timeoffs15_1.startdate <= timesheet22_1.enddate2) AND (timeoffs15_1.enddate >= timesheet22_1.startdate1) AND (timesheet22_1.userid0 = timeoffs15_1.userid) AND ((('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text = upper(timesheet22_1.key3)) AND ('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper(timesheet22_1.uri4))) OR (('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text = upper(timesheet22_1.key3)) AND (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15_1.id)::text, ''::text))) = upper(timesheet22_1.uri4)))))
  • Rows Removed by Filter: 4
106. 0.000 0.420 ↓ 0.0 0 60

Nested Loop (cost=3.87..50.90 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=60)

  • Join Filter: (((upper(esheetapprovalhistorykeyvalue6_1.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text) OR ((upper(esheetapprovalhistorykeyvalue6_1.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text) AND (upper(esheetapprovalhistorykeyvalue7_1.uri) = 'URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text))) AND ((('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text = upper((esheetapprovalhistorykeyvalue6_1.uri)::text)) AND ('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper((esheetapprovalhistorykeyvalue7_1.uri)::text))) OR (('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text = upper((esheetapprovalhistorykeyvalue6_1.uri)::text)) AND (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15_1.id)::text, ''::text))) = upper((esheetapprovalhistorykeyvalue7_1.uri)::text)))))
  • Buffers: shared hit=540
107. 0.060 0.420 ↓ 0.0 0 60

Nested Loop (cost=3.44..50.27 rows=1 width=85) (actual time=0.007..0.007 rows=0 loops=60)

  • Output: esheetapprovalhistorykeyvalue6_1.uri, sheetapprovalhistorykeyvalue13_1.id
  • Buffers: shared hit=540
108. 0.000 0.360 ↓ 0.0 0 60

Nested Loop (cost=3.01..45.82 rows=1 width=85) (actual time=0.006..0.006 rows=0 loops=60)

  • Output: esheetapprovalhistorykeyvalue6_1.id, esheetapprovalhistorykeyvalue6_1.uri
  • Buffers: shared hit=540
109. 0.000 0.360 ↓ 0.0 0 60

Nested Loop (cost=2.57..45.23 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=60)

  • Output: sheetapprovalhistorykeyvalue12_1.id
  • Buffers: shared hit=540
110. 0.000 0.360 ↓ 0.0 0 60

Nested Loop (cost=2.14..43.87 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=60)

  • Output: sheetapprovalhistorykeyvalue11_1.id
  • Buffers: shared hit=540
111. 0.000 0.360 ↓ 0.0 0 60

Nested Loop (cost=1.71..41.76 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=60)

  • Output: sheetapprovalhistorykeyvalue10_1.parentid
  • Inner Unique: true
  • Buffers: shared hit=540
112. 0.000 0.360 ↓ 0.0 0 60

Nested Loop (cost=1.27..39.38 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=60)

  • Output: esheetapprovalhistorykeyvalue9_1.parentid
  • Buffers: shared hit=540
113. 0.060 0.360 ↓ 0.0 0 60

Nested Loop (cost=0.84..14.26 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=60)

  • Output: timesheetapprovalhistory8_1.id
  • Buffers: shared hit=540
114. 0.120 0.120 ↑ 2.0 1 60

Index Scan using ixtsuseridstartdateenddate on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet5_1 (cost=0.42..3.24 rows=2 width=16) (actual time=0.002..0.002 rows=1 loops=60)

  • Output: timesheet5_1.id, timesheet5_1.userid, timesheet5_1.startdate, timesheet5_1.enddate, timesheet5_1.approvalstatus, timesheet5_1.duedate, timesheet5_1.autosubmitdatetimeutc, timesheet5_1.lastautosubmitattemptdatetimeutc, timesheet5_1.createdonutc
  • Index Cond: ((timesheet5_1.userid = timeoffs15_1.userid) AND (timeoffs15_1.enddate >= timesheet5_1.startdate) AND (timeoffs15_1.startdate <= timesheet5_1.enddate))
  • Buffers: shared hit=240
115. 0.180 0.180 ↓ 0.0 0 60

Index Scan using ixtah2timesheetid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory8_1 (cost=0.42..5.50 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=60)

  • Output: timesheetapprovalhistory8_1.id, timesheetapprovalhistory8_1.action, timesheetapprovalhistory8_1.approvalcomments, timesheetapprovalhistory8_1.timestamputc, timesheetapprovalhistory8_1.serialnumber, timesheetapprovalhistory8_1.timesheetid, timesheetapprovalhistory8_1.approvalagenttype, timesheetapprovalhistory8_1.userid, timesheetapprovalhistory8_1.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory8_1.timesheetid = timesheet5_1.id)
  • Filter: (timesheetapprovalhistory8_1.userid = 2892)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=300
116. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue9_1 (cost=0.43..25.11 rows=1 width=32) (never executed)

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

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

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

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

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

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue12_1 (cost=0.43..1.33 rows=3 width=32) (never executed)

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

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue6_1 (cost=0.43..0.58 rows=1 width=101) (never executed)

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

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue13_1 (cost=0.43..4.42 rows=3 width=32) (never executed)

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

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue7_1 (cost=0.43..0.58 rows=1 width=85) (never executed)

  • Output: esheetapprovalhistorykeyvalue7_1.id, esheetapprovalhistorykeyvalue7_1.timesheetapprovalhistoryid, esheetapprovalhistorykeyvalue7_1.parentid, esheetapprovalhistorykeyvalue7_1.index, esheetapprovalhistorykeyvalue7_1.key, esheetapprovalhistorykeyvalue7_1.uri, esheetapprovalhistorykeyvalue7_1.slug, esheetapprovalhistorykeyvalue7_1."boolean", esheetapprovalhistorykeyvalue7_1.date, esheetapprovalhistorykeyvalue7_1.number, esheetapprovalhistorykeyvalue7_1.text, esheetapprovalhistorykeyvalue7_1."time", esheetapprovalhistorykeyvalue7_1.timespan, esheetapprovalhistorykeyvalue7_1.daterange_startdate, esheetapprovalhistorykeyvalue7_1.daterange_enddate, esheetapprovalhistorykeyvalue7_1.daterange_relativedaterangeuri, esheetapprovalhistorykeyvalue7_1.daterange_relativedaterangeasofdate, esheetapprovalhistorykeyvalue7_1.workdayduration_decimalworkdays, esheetapprovalhistorykeyvalue7_1.workdayduration_workdays, esheetapprovalhistorykeyvalue7_1.workdayduration_hours, esheetapprovalhistorykeyvalue7_1.workdayduration_minutes
  • Index Cond: (esheetapprovalhistorykeyvalue7_1.parentid = sheetapprovalhistorykeyvalue13_1.id)
  • Filter: (('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper((esheetapprovalhistorykeyvalue7_1.uri)::text)) OR (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15_1.id)::text, ''::text))) = upper((esheetapprovalhistorykeyvalue7_1.uri)::text)))
123. 0.011 43.172 ↑ 1.0 1 1

Aggregate (cost=17,391.20..17,391.21 rows=1 width=8) (actual time=43.171..43.172 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=14024
124.          

Initplan (for Aggregate)

125. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..11.37 rows=1 width=0) (never executed)

126. 0.000 0.000 ↓ 0.0 0

Index Only Scan using userpolicyset_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userpolicyset userpolicyset20_2 (cost=0.29..3.23 rows=2 width=16) (never executed)

  • Output: userpolicyset20_2.userid, userpolicyset20_2.policysetid
  • Index Cond: (userpolicyset20_2.userid = 2892)
  • Heap Fetches: 0
127. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpskvpolicysetid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.policysetkeyvalue policysetkeyvalue21_2 (cost=0.14..4.06 rows=1 width=16) (never executed)

  • Output: policysetkeyvalue21_2.id, policysetkeyvalue21_2.policysetid, policysetkeyvalue21_2.parentid, policysetkeyvalue21_2.index, policysetkeyvalue21_2.key, policysetkeyvalue21_2.uri, policysetkeyvalue21_2.slug, policysetkeyvalue21_2."boolean", policysetkeyvalue21_2.date, policysetkeyvalue21_2.number, policysetkeyvalue21_2.text, policysetkeyvalue21_2."time", policysetkeyvalue21_2.timespan, policysetkeyvalue21_2.daterange_startdate, policysetkeyvalue21_2.daterange_enddate, policysetkeyvalue21_2.daterange_relativedaterangeuri, policysetkeyvalue21_2.daterange_relativedaterangeasofdate, policysetkeyvalue21_2.workdayduration_decimalworkdays, policysetkeyvalue21_2.workdayduration_workdays, policysetkeyvalue21_2.workdayduration_hours, policysetkeyvalue21_2.workdayduration_minutes
  • Index Cond: (policysetkeyvalue21_2.policysetid = userpolicyset20_2.policysetid)
  • Filter: ((policysetkeyvalue21_2.parentid IS NULL) AND (upper(policysetkeyvalue21_2.key) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-ALL-TIME-OFF'::text) AND (upper(policysetkeyvalue21_2.uri) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-ALL-TIME-OFF:ALLOWED'::text))
128. 0.018 43.161 ↓ 1.4 13 1

Nested Loop Semi Join (cost=1,017.30..17,379.81 rows=9 width=0) (actual time=13.330..43.161 rows=13 loops=1)

  • Buffers: shared hit=14024
129. 0.413 42.857 ↑ 1.5 13 1

Nested Loop (cost=1,016.59..15,907.52 rows=19 width=8) (actual time=13.244..42.857 rows=13 loops=1)

  • Output: "*SELECT* 1_3".timeoffid, timeoffapprovalnodes15.timeoffid
  • Join Filter: ("*SELECT* 1_3".timeoffid = timeoffapprovalnodes15.timeoffid)
  • Rows Removed by Join Filter: 3354
  • Buffers: shared hit=13860
130. 0.005 0.142 ↑ 1.0 13 1

Unique (cost=16.31..16.38 rows=13 width=4) (actual time=0.134..0.142 rows=13 loops=1)

  • Output: timeoffapprovalnodes15.timeoffid
  • Buffers: shared hit=20
131. 0.017 0.137 ↑ 1.0 13 1

Sort (cost=16.31..16.35 rows=13 width=4) (actual time=0.133..0.137 rows=13 loops=1)

  • Output: timeoffapprovalnodes15.timeoffid
  • Sort Key: timeoffapprovalnodes15.timeoffid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=20
132. 0.044 0.120 ↑ 1.0 13 1

Hash Join (cost=7.35..16.07 rows=13 width=4) (actual time=0.068..0.120 rows=13 loops=1)

  • Output: timeoffapprovalnodes15.timeoffid
  • Inner Unique: true
  • Hash Cond: (timeoffapprovalnodes15.id = timeoffapprovalrequest16.nodeid)
  • Buffers: shared hit=20
133. 0.035 0.035 ↑ 1.0 294 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes15 (cost=0.00..7.94 rows=294 width=20) (actual time=0.006..0.035 rows=294 loops=1)

  • Output: timeoffapprovalnodes15.id, timeoffapprovalnodes15.timeoffid, timeoffapprovalnodes15.isapproved, timeoffapprovalnodes15.approverrole, timeoffapprovalnodes15.userid, timeoffapprovalnodes15.agentresolutionstate, timeoffapprovalnodes15.scriptid
  • Buffers: shared hit=5
134. 0.006 0.041 ↑ 1.0 13 1

Hash (cost=7.19..7.19 rows=13 width=16) (actual time=0.041..0.041 rows=13 loops=1)

  • Output: timeoffapprovalrequest16.nodeid
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=15
135. 0.035 0.035 ↑ 1.0 13 1

Index Scan using ixtoarapproverid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest16 (cost=0.27..7.19 rows=13 width=16) (actual time=0.026..0.035 rows=13 loops=1)

  • Output: timeoffapprovalrequest16.nodeid
  • Index Cond: (timeoffapprovalrequest16.approverid = 2892)
  • Buffers: shared hit=15
136. 0.310 42.302 ↑ 1.1 259 13

Materialize (cost=1,000.28..15,835.38 rows=289 width=4) (actual time=0.303..3.254 rows=259 loops=13)

  • Output: "*SELECT* 1_3".timeoffid
  • Buffers: shared hit=13840
137. 0.036 41.992 ↑ 1.1 259 1

Append (cost=1,000.28..15,833.94 rows=289 width=4) (actual time=3.934..41.992 rows=259 loops=1)

  • Buffers: shared hit=13840
138. 0.000 41.251 ↑ 1.0 254 1

Subquery Scan on *SELECT* 1_3 (cost=1,000.28..15,687.68 rows=254 width=4) (actual time=3.933..41.251 rows=254 loops=1)

  • Output: "*SELECT* 1_3".timeoffid
  • Buffers: shared hit=13715
139. 11.715 41.296 ↑ 1.0 254 1

Gather (cost=1,000.28..15,685.14 rows=254 width=1,553) (actual time=3.932..41.296 rows=254 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
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=13715
140. 0.082 29.581 ↑ 1.2 85 3 / 3

Nested Loop Anti Join (cost=0.28..14,659.74 rows=106 width=1,553) (actual time=0.994..29.581 rows=85 loops=3)

  • 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=13715
  • Worker 0: actual time=1.580..27.299 rows=104 loops=1
  • Buffers: shared hit=5446
  • Worker 1: actual time=1.325..24.485 rows=69 loops=1
  • Buffers: shared hit=3222
141. 29.240 29.240 ↑ 1.2 86 3 / 3

Parallel Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_facts dm_timeofflist_facts_3 (cost=0.00..14,614.79 rows=107 width=4) (actual time=0.978..29.240 rows=86 loops=3)

  • 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 <> 5) AND (dm_timeofflist_facts_3.timeoffstatus = 1))
  • Rows Removed by Filter: 76436
  • Buffers: shared hit=13180
  • Worker 0: actual time=1.566..26.984 rows=106 loops=1
  • Buffers: shared hit=5228
  • Worker 1: actual time=1.308..24.148 rows=70 loops=1
  • Buffers: shared hit=3080
142. 0.259 0.259 ↓ 0.0 0 259 / 3

Index Only Scan using dm_timeofflist_realtime_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_6 (cost=0.28..0.42 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=259)

  • Output: dm_timeofflist_realtime_facts_6.timeoffid
  • Index Cond: (dm_timeofflist_realtime_facts_6.timeoffid = dm_timeofflist_facts_3.timeoffid)
  • Heap Fetches: 8
  • Buffers: shared hit=535
  • Worker 0: actual time=0.002..0.002 rows=0 loops=106
  • Buffers: shared hit=218
  • Worker 1: actual time=0.004..0.004 rows=0 loops=70
  • Buffers: shared hit=142
143. 0.002 0.705 ↑ 7.0 5 1

Subquery Scan on *SELECT* 2_3 (cost=0.00..146.26 rows=35 width=4) (actual time=0.038..0.705 rows=5 loops=1)

  • Output: "*SELECT* 2_3".timeoffid
  • Buffers: shared hit=125
144. 0.703 0.703 ↑ 7.0 5 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_7 (cost=0.00..145.91 rows=35 width=1,553) (actual time=0.037..0.703 rows=5 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 <> 5) AND (dm_timeofflist_realtime_facts_7.timeoffstatus = 1))
  • Rows Removed by Filter: 1388
  • Buffers: shared hit=125
145. 0.036 0.286 ↑ 3.0 1 13

Nested Loop Left Join (cost=0.71..121.21 rows=3 width=4) (actual time=0.022..0.022 rows=1 loops=13)

  • Output: timeoffs15_2.id
  • Filter: (((userhierarchy16_2.supervisorid = 2892) AND ((userhierarchy16_2.startdate IS NULL) OR (userhierarchy16_2.startdate <= '2020-02-09'::date)) AND ((userhierarchy16_2.enddate IS NULL) OR (userhierarchy16_2.enddate >= '2020-02-09'::date))) OR (timeoffs15_2.userid = 2892) OR (alternatives: SubPlan 25 or hashed SubPlan 26) OR (alternatives: SubPlan 27 or hashed SubPlan 28) OR $76 OR (SubPlan 30) OR (SubPlan 31))
  • Buffers: shared hit=164
146. 0.078 0.078 ↑ 1.0 1 13

Index Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs15_2 (cost=0.42..2.25 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=13)

  • Output: timeoffs15_2.id, timeoffs15_2.guidid, timeoffs15_2.userid, timeoffs15_2.createdbyuserid, timeoffs15_2.timeoffcodeid, timeoffs15_2.startdate, timeoffs15_2.enddate, timeoffs15_2.approvalstatus, timeoffs15_2.comments, timeoffs15_2.submittedonutc, timeoffs15_2.modifiedonutc, timeoffs15_2.info1, timeoffs15_2.info2, timeoffs15_2.info3, timeoffs15_2.info4, timeoffs15_2.info5, timeoffs15_2.startdurationtype, timeoffs15_2.enddurationtype, timeoffs15_2.startduration, timeoffs15_2.endduration, timeoffs15_2.startdatestarttime, timeoffs15_2.enddateendtime, timeoffs15_2.entryconfigurationmethod
  • Index Cond: (timeoffs15_2.id = "*SELECT* 1_3".timeoffid)
  • Buffers: shared hit=52
147. 0.052 0.052 ↑ 2.0 1 13

Index Scan using ix3uh_usersuperstart on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userhierarchy userhierarchy16_2 (cost=0.29..0.32 rows=2 width=24) (actual time=0.004..0.004 rows=1 loops=13)

  • Output: userhierarchy16_2.id, userhierarchy16_2.userid, userhierarchy16_2.supervisorid, userhierarchy16_2.startdate, userhierarchy16_2.enddate
  • Index Cond: (userhierarchy16_2.userid = timeoffs15_2.userid)
  • Buffers: shared hit=39
148.          

SubPlan (for Nested Loop Left Join)

149. 0.024 0.120 ↑ 1.0 1 12

Nested Loop (cost=0.55..4.87 rows=1 width=0) (actual time=0.010..0.010 rows=1 loops=12)

  • Inner Unique: true
  • Buffers: shared hit=73
150. 0.048 0.048 ↑ 1.0 1 12

Index Scan using ixtoantimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes17_4 (cost=0.27..2.29 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=12)

  • Output: timeoffapprovalnodes17_4.id, timeoffapprovalnodes17_4.timeoffid, timeoffapprovalnodes17_4.isapproved, timeoffapprovalnodes17_4.approverrole, timeoffapprovalnodes17_4.userid, timeoffapprovalnodes17_4.agentresolutionstate, timeoffapprovalnodes17_4.scriptid
  • Index Cond: (timeoffapprovalnodes17_4.timeoffid = timeoffs15_2.id)
  • Buffers: shared hit=36
151. 0.048 0.048 ↑ 1.0 1 12

Index Only Scan using uix2toaraidnid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest18_4 (cost=0.27..2.29 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=12)

  • Output: timeoffapprovalrequest18_4.approverid, timeoffapprovalrequest18_4.nodeid
  • Index Cond: ((timeoffapprovalrequest18_4.approverid = 2892) AND (timeoffapprovalrequest18_4.nodeid = timeoffapprovalnodes17_4.id))
  • Heap Fetches: 12
  • Buffers: shared hit=37
152. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7.35..16.07 rows=13 width=4) (never executed)

  • Output: timeoffapprovalnodes17_5.timeoffid
  • Inner Unique: true
  • Hash Cond: (timeoffapprovalnodes17_5.id = timeoffapprovalrequest18_5.nodeid)
153. 0.000 0.000 ↓ 0.0 0

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes17_5 (cost=0.00..7.94 rows=294 width=20) (never executed)

  • Output: timeoffapprovalnodes17_5.id, timeoffapprovalnodes17_5.timeoffid, timeoffapprovalnodes17_5.isapproved, timeoffapprovalnodes17_5.approverrole, timeoffapprovalnodes17_5.userid, timeoffapprovalnodes17_5.agentresolutionstate, timeoffapprovalnodes17_5.scriptid
154. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.19..7.19 rows=13 width=16) (never executed)

  • Output: timeoffapprovalrequest18_5.nodeid
155. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoarapproverid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest18_5 (cost=0.27..7.19 rows=13 width=16) (never executed)

  • Output: timeoffapprovalrequest18_5.nodeid
  • Index Cond: (timeoffapprovalrequest18_5.approverid = 2892)
156. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (timeoffapprovalhistory19_4.timeoffid = timeoffs15_2.id)
  • Filter: ((timeoffapprovalhistory19_4.userid = 2892) AND (timeoffapprovalhistory19_4.action = ANY ('{2,3,4}'::integer[])))
157. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahuserid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory19_5 (cost=0.42..1,239.28 rows=657 width=4) (never executed)

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

CTE Scan on timesheet0cte timesheet22_2 (cost=0.00..0.06 rows=1 width=0) (never executed)

  • Filter: ((timeoffs15_2.startdate <= timesheet22_2.enddate2) AND (timeoffs15_2.enddate >= timesheet22_2.startdate1) AND (timesheet22_2.userid0 = timeoffs15_2.userid) AND ((('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text = upper(timesheet22_2.key3)) AND ('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper(timesheet22_2.uri4))) OR (('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text = upper(timesheet22_2.key3)) AND (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15_2.id)::text, ''::text))) = upper(timesheet22_2.uri4)))))
159. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.87..50.90 rows=1 width=0) (never executed)

  • Join Filter: (((upper(esheetapprovalhistorykeyvalue6_2.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text) OR ((upper(esheetapprovalhistorykeyvalue6_2.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text) AND (upper(esheetapprovalhistorykeyvalue7_2.uri) = 'URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text))) AND ((('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text = upper((esheetapprovalhistorykeyvalue6_2.uri)::text)) AND ('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper((esheetapprovalhistorykeyvalue7_2.uri)::text))) OR (('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text = upper((esheetapprovalhistorykeyvalue6_2.uri)::text)) AND (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15_2.id)::text, ''::text))) = upper((esheetapprovalhistorykeyvalue7_2.uri)::text)))))
160. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.44..50.27 rows=1 width=85) (never executed)

  • Output: esheetapprovalhistorykeyvalue6_2.uri, sheetapprovalhistorykeyvalue13_2.id
161. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.01..45.82 rows=1 width=85) (never executed)

  • Output: esheetapprovalhistorykeyvalue6_2.id, esheetapprovalhistorykeyvalue6_2.uri
162. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.57..45.23 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue12_2.id
163. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.14..43.87 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue11_2.id
164. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.71..41.76 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue10_2.parentid
  • Inner Unique: true
165. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..39.38 rows=1 width=16) (never executed)

  • Output: esheetapprovalhistorykeyvalue9_2.parentid
166. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..14.26 rows=1 width=16) (never executed)

  • Output: timesheetapprovalhistory8_2.id
167. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using ixtah2timesheetid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory8_2 (cost=0.42..5.50 rows=1 width=32) (never executed)

  • Output: timesheetapprovalhistory8_2.id, timesheetapprovalhistory8_2.action, timesheetapprovalhistory8_2.approvalcomments, timesheetapprovalhistory8_2.timestamputc, timesheetapprovalhistory8_2.serialnumber, timesheetapprovalhistory8_2.timesheetid, timesheetapprovalhistory8_2.approvalagenttype, timesheetapprovalhistory8_2.userid, timesheetapprovalhistory8_2.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory8_2.timesheetid = timesheet5_2.id)
  • Filter: (timesheetapprovalhistory8_2.userid = 2892)
169. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue9_2 (cost=0.43..25.11 rows=1 width=32) (never executed)

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

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

  • Output: sheetapprovalhistorykeyvalue10_2.id, sheetapprovalhistorykeyvalue10_2.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue10_2.parentid, sheetapprovalhistorykeyvalue10_2.index, sheetapprovalhistorykeyvalue10_2.key, sheetapprovalhistorykeyvalue10_2.uri, sheetapprovalhistorykeyvalue10_2.slug, sheetapprovalhistorykeyvalue10_2."boolean", sheetapprovalhistorykeyvalue10_2.date, sheetapprovalhistorykeyvalue10_2.number, sheetapprovalhistorykeyvalue10_2.text, sheetapprovalhistorykeyvalue10_2."time", sheetapprovalhistorykeyvalue10_2.timespan, sheetapprovalhistorykeyvalue10_2.daterange_startdate, sheetapprovalhistorykeyvalue10_2.daterange_enddate, sheetapprovalhistorykeyvalue10_2.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue10_2.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue10_2.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue10_2.workdayduration_workdays, sheetapprovalhistorykeyvalue10_2.workdayduration_hours, sheetapprovalhistorykeyvalue10_2.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue10_2.id = esheetapprovalhistorykeyvalue9_2.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue10_2.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 sheetapprovalhistorykeyvalue11_2 (cost=0.43..2.10 rows=1 width=32) (never executed)

  • Output: sheetapprovalhistorykeyvalue11_2.id, sheetapprovalhistorykeyvalue11_2.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue11_2.parentid, sheetapprovalhistorykeyvalue11_2.index, sheetapprovalhistorykeyvalue11_2.key, sheetapprovalhistorykeyvalue11_2.uri, sheetapprovalhistorykeyvalue11_2.slug, sheetapprovalhistorykeyvalue11_2."boolean", sheetapprovalhistorykeyvalue11_2.date, sheetapprovalhistorykeyvalue11_2.number, sheetapprovalhistorykeyvalue11_2.text, sheetapprovalhistorykeyvalue11_2."time", sheetapprovalhistorykeyvalue11_2.timespan, sheetapprovalhistorykeyvalue11_2.daterange_startdate, sheetapprovalhistorykeyvalue11_2.daterange_enddate, sheetapprovalhistorykeyvalue11_2.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue11_2.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue11_2.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue11_2.workdayduration_workdays, sheetapprovalhistorykeyvalue11_2.workdayduration_hours, sheetapprovalhistorykeyvalue11_2.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue11_2.parentid = sheetapprovalhistorykeyvalue10_2.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue11_2.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 sheetapprovalhistorykeyvalue12_2 (cost=0.43..1.33 rows=3 width=32) (never executed)

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

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue6_2 (cost=0.43..0.58 rows=1 width=101) (never executed)

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

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue13_2 (cost=0.43..4.42 rows=3 width=32) (never executed)

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

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue7_2 (cost=0.43..0.58 rows=1 width=85) (never executed)

  • Output: esheetapprovalhistorykeyvalue7_2.id, esheetapprovalhistorykeyvalue7_2.timesheetapprovalhistoryid, esheetapprovalhistorykeyvalue7_2.parentid, esheetapprovalhistorykeyvalue7_2.index, esheetapprovalhistorykeyvalue7_2.key, esheetapprovalhistorykeyvalue7_2.uri, esheetapprovalhistorykeyvalue7_2.slug, esheetapprovalhistorykeyvalue7_2."boolean", esheetapprovalhistorykeyvalue7_2.date, esheetapprovalhistorykeyvalue7_2.number, esheetapprovalhistorykeyvalue7_2.text, esheetapprovalhistorykeyvalue7_2."time", esheetapprovalhistorykeyvalue7_2.timespan, esheetapprovalhistorykeyvalue7_2.daterange_startdate, esheetapprovalhistorykeyvalue7_2.daterange_enddate, esheetapprovalhistorykeyvalue7_2.daterange_relativedaterangeuri, esheetapprovalhistorykeyvalue7_2.daterange_relativedaterangeasofdate, esheetapprovalhistorykeyvalue7_2.workdayduration_decimalworkdays, esheetapprovalhistorykeyvalue7_2.workdayduration_workdays, esheetapprovalhistorykeyvalue7_2.workdayduration_hours, esheetapprovalhistorykeyvalue7_2.workdayduration_minutes
  • Index Cond: (esheetapprovalhistorykeyvalue7_2.parentid = sheetapprovalhistorykeyvalue13_2.id)
  • Filter: (('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper((esheetapprovalhistorykeyvalue7_2.uri)::text)) OR (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15_2.id)::text, ''::text))) = upper((esheetapprovalhistorykeyvalue7_2.uri)::text)))
176. 0.003 35.442 ↑ 1.0 1 1

Aggregate (cost=24,748.34..24,748.35 rows=1 width=8) (actual time=35.442..35.442 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=13970
177.          

Initplan (for Aggregate)

178. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..11.37 rows=1 width=0) (never executed)

179. 0.000 0.000 ↓ 0.0 0

Index Only Scan using userpolicyset_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userpolicyset userpolicyset20_3 (cost=0.29..3.23 rows=2 width=16) (never executed)

  • Output: userpolicyset20_3.userid, userpolicyset20_3.policysetid
  • Index Cond: (userpolicyset20_3.userid = 2892)
  • Heap Fetches: 0
180. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpskvpolicysetid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.policysetkeyvalue policysetkeyvalue21_3 (cost=0.14..4.06 rows=1 width=16) (never executed)

  • Output: policysetkeyvalue21_3.id, policysetkeyvalue21_3.policysetid, policysetkeyvalue21_3.parentid, policysetkeyvalue21_3.index, policysetkeyvalue21_3.key, policysetkeyvalue21_3.uri, policysetkeyvalue21_3.slug, policysetkeyvalue21_3."boolean", policysetkeyvalue21_3.date, policysetkeyvalue21_3.number, policysetkeyvalue21_3.text, policysetkeyvalue21_3."time", policysetkeyvalue21_3.timespan, policysetkeyvalue21_3.daterange_startdate, policysetkeyvalue21_3.daterange_enddate, policysetkeyvalue21_3.daterange_relativedaterangeuri, policysetkeyvalue21_3.daterange_relativedaterangeasofdate, policysetkeyvalue21_3.workdayduration_decimalworkdays, policysetkeyvalue21_3.workdayduration_workdays, policysetkeyvalue21_3.workdayduration_hours, policysetkeyvalue21_3.workdayduration_minutes
  • Index Cond: (policysetkeyvalue21_3.policysetid = userpolicyset20_3.policysetid)
  • Filter: ((policysetkeyvalue21_3.parentid IS NULL) AND (upper(policysetkeyvalue21_3.key) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-ALL-TIME-OFF'::text) AND (upper(policysetkeyvalue21_3.uri) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-ALL-TIME-OFF:ALLOWED'::text))
181. 0.001 35.439 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1,294.71..24,736.66 rows=126 width=0) (actual time=35.439..35.439 rows=0 loops=1)

  • Buffers: shared hit=13970
182. 0.001 35.438 ↓ 0.0 0 1

Append (cost=1,294.01..16,424.29 rows=126 width=4) (actual time=35.438..35.438 rows=0 loops=1)

  • Buffers: shared hit=13970
183. 0.000 34.652 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_4 (cost=1,294.01..15,983.95 rows=111 width=4) (actual time=34.652..34.652 rows=0 loops=1)

  • Output: "*SELECT* 1_4".timeoffid
  • Filter: ((NOT (hashed SubPlan 36)) AND ((hashed SubPlan 33) OR (hashed SubPlan 34) OR (hashed SubPlan 35)))
  • Rows Removed by Filter: 254
  • Buffers: shared hit=13790
184. 10.600 34.229 ↑ 1.0 254 1

Gather (cost=1,000.28..15,685.14 rows=254 width=1,553) (actual time=4.200..34.229 rows=254 loops=1)

  • Output: dm_timeofflist_facts_4.timeoffid, NULL::text, dm_timeofflist_facts_4.timeoffowneruserid, 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
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=13715
185. 0.083 23.629 ↑ 1.2 85 3 / 3

Nested Loop Anti Join (cost=0.28..14,659.74 rows=106 width=1,553) (actual time=1.034..23.629 rows=85 loops=3)

  • Output: dm_timeofflist_facts_4.timeoffid, NULL::text, dm_timeofflist_facts_4.timeoffowneruserid, 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=13715
  • Worker 0: actual time=2.051..20.482 rows=64 loops=1
  • Buffers: shared hit=3981
  • Worker 1: actual time=0.984..20.908 rows=78 loops=1
  • Buffers: shared hit=4108
186. 23.373 23.373 ↑ 1.2 86 3 / 3

Parallel Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_facts dm_timeofflist_facts_4 (cost=0.00..14,614.79 rows=107 width=8) (actual time=1.020..23.373 rows=86 loops=3)

  • 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 <> 5) AND (dm_timeofflist_facts_4.timeoffstatus = 1))
  • Rows Removed by Filter: 76436
  • Buffers: shared hit=13180
  • Worker 0: actual time=2.036..20.250 rows=64 loops=1
  • Buffers: shared hit=3848
  • Worker 1: actual time=0.969..20.658 rows=79 loops=1
  • Buffers: shared hit=3948
187. 0.173 0.173 ↓ 0.0 0 259 / 3

Index Only Scan using dm_timeofflist_realtime_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_8 (cost=0.28..0.42 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=259)

  • Output: dm_timeofflist_realtime_facts_8.timeoffid
  • Index Cond: (dm_timeofflist_realtime_facts_8.timeoffid = dm_timeofflist_facts_4.timeoffid)
  • Heap Fetches: 9
  • Buffers: shared hit=535
  • Worker 0: actual time=0.003..0.003 rows=0 loops=64
  • Buffers: shared hit=133
  • Worker 1: actual time=0.002..0.002 rows=0 loops=79
  • Buffers: shared hit=160
188.          

SubPlan (for Subquery Scan)

189. 0.010 0.110 ↑ 1.0 13 2

HashAggregate (cost=16.11..16.24 rows=13 width=4) (actual time=0.054..0.055 rows=13 loops=2)

  • Output: timeoffapprovalnodes23.timeoffid
  • Group Key: timeoffapprovalnodes23.timeoffid
  • Buffers: shared hit=20
190. 0.036 0.100 ↑ 1.0 13 1

Hash Join (cost=7.35..16.07 rows=13 width=4) (actual time=0.049..0.100 rows=13 loops=1)

  • Output: timeoffapprovalnodes23.timeoffid
  • Inner Unique: true
  • Hash Cond: (timeoffapprovalnodes23.id = timeoffapprovalrequest24.nodeid)
  • Buffers: shared hit=20
191. 0.034 0.034 ↑ 1.0 294 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes23 (cost=0.00..7.94 rows=294 width=20) (actual time=0.006..0.034 rows=294 loops=1)

  • Output: timeoffapprovalnodes23.id, timeoffapprovalnodes23.timeoffid, timeoffapprovalnodes23.isapproved, timeoffapprovalnodes23.approverrole, timeoffapprovalnodes23.userid, timeoffapprovalnodes23.agentresolutionstate, timeoffapprovalnodes23.scriptid
  • Buffers: shared hit=5
192. 0.006 0.030 ↑ 1.0 13 1

Hash (cost=7.19..7.19 rows=13 width=16) (actual time=0.030..0.030 rows=13 loops=1)

  • Output: timeoffapprovalrequest24.nodeid
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=15
193. 0.024 0.024 ↑ 1.0 13 1

Index Scan using ixtoarapproverid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest24 (cost=0.27..7.19 rows=13 width=16) (actual time=0.015..0.024 rows=13 loops=1)

  • Output: timeoffapprovalrequest24.nodeid
  • Index Cond: (timeoffapprovalrequest24.approverid = 2892)
  • Buffers: shared hit=15
194. 0.106 0.106 ↑ 1.0 14 2

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_remainingapprovers_facts ist_remainingapprovers_facts18 (cost=0.00..12.43 rows=14 width=4) (actual time=0.033..0.053 rows=14 loops=2)

  • Output: ist_remainingapprovers_facts18.timeoffid
  • Filter: (ist_remainingapprovers_facts18.approveruserid = 2892)
  • Rows Removed by Filter: 500
  • Buffers: shared hit=12
195. 0.000 0.062 ↓ 0.0 0 2

Nested Loop (cost=1.41..162.73 rows=1 width=4) (actual time=0.031..0.031 rows=0 loops=2)

  • Output: timeoffapprovalhistory19_6.timeoffid
  • Inner Unique: true
  • Buffers: shared hit=8
196. 0.000 0.062 ↓ 0.0 0 2

Nested Loop (cost=0.98..160.28 rows=1 width=20) (actual time=0.031..0.031 rows=0 loops=2)

  • Output: timeoffapprovalhistory19_6.timeoffid, meoffapprovalhistorykeyvalue20.parentid
  • Inner Unique: true
  • Buffers: shared hit=8
197. 0.062 0.062 ↓ 0.0 0 2

Index Scan using ixtoahkvuri on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistorykeyvalue meoffapprovalhistorykeyvalue20 (cost=0.55..82.04 rows=32 width=20) (actual time=0.031..0.031 rows=0 loops=2)

  • Output: meoffapprovalhistorykeyvalue20.id, meoffapprovalhistorykeyvalue20.timeoffapprovalhistoryid, meoffapprovalhistorykeyvalue20.parentid, meoffapprovalhistorykeyvalue20.index, meoffapprovalhistorykeyvalue20.key, meoffapprovalhistorykeyvalue20.uri, meoffapprovalhistorykeyvalue20.slug, meoffapprovalhistorykeyvalue20."boolean", meoffapprovalhistorykeyvalue20.date, meoffapprovalhistorykeyvalue20.number, meoffapprovalhistorykeyvalue20.text, meoffapprovalhistorykeyvalue20."time", meoffapprovalhistorykeyvalue20.timespan, meoffapprovalhistorykeyvalue20.daterange_startdate, meoffapprovalhistorykeyvalue20.daterange_enddate, meoffapprovalhistorykeyvalue20.daterange_relativedaterangeuri, meoffapprovalhistorykeyvalue20.daterange_relativedaterangeasofdate, meoffapprovalhistorykeyvalue20.workdayduration_decimalworkdays, meoffapprovalhistorykeyvalue20.workdayduration_workdays, meoffapprovalhistorykeyvalue20.workdayduration_hours, meoffapprovalhistorykeyvalue20.workdayduration_minutes
  • Index Cond: (upper(meoffapprovalhistorykeyvalue20.uri) = 'URN:REPLICON-TENANT:2BC736BCEB814ED5B2CB107A69397ACD:USER:2892'::text)
  • Filter: (upper(meoffapprovalhistorykeyvalue20.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
  • Buffers: shared hit=8
198. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalhistory_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory19_6 (cost=0.42..2.45 rows=1 width=8) (never executed)

  • Output: timeoffapprovalhistory19_6.id, timeoffapprovalhistory19_6.timeoffid, timeoffapprovalhistory19_6.effectivedateutc, timeoffapprovalhistory19_6.action, timeoffapprovalhistory19_6.approvalcomments, timeoffapprovalhistory19_6.approvalagenttype, timeoffapprovalhistory19_6.userid, timeoffapprovalhistory19_6.systemprocessidentifier
  • Index Cond: (timeoffapprovalhistory19_6.id = meoffapprovalhistorykeyvalue20.timeoffapprovalhistoryid)
  • Filter: (timeoffapprovalhistory19_6.userid = 2892)
199. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistorykeyvalue meoffapprovalhistorykeyvalue21 (cost=0.43..2.45 rows=1 width=16) (never executed)

  • Output: meoffapprovalhistorykeyvalue21.id, meoffapprovalhistorykeyvalue21.timeoffapprovalhistoryid, meoffapprovalhistorykeyvalue21.parentid, meoffapprovalhistorykeyvalue21.index, meoffapprovalhistorykeyvalue21.key, meoffapprovalhistorykeyvalue21.uri, meoffapprovalhistorykeyvalue21.slug, meoffapprovalhistorykeyvalue21."boolean", meoffapprovalhistorykeyvalue21.date, meoffapprovalhistorykeyvalue21.number, meoffapprovalhistorykeyvalue21.text, meoffapprovalhistorykeyvalue21."time", meoffapprovalhistorykeyvalue21.timespan, meoffapprovalhistorykeyvalue21.daterange_startdate, meoffapprovalhistorykeyvalue21.daterange_enddate, meoffapprovalhistorykeyvalue21.daterange_relativedaterangeuri, meoffapprovalhistorykeyvalue21.daterange_relativedaterangeasofdate, meoffapprovalhistorykeyvalue21.workdayduration_decimalworkdays, meoffapprovalhistorykeyvalue21.workdayduration_workdays, meoffapprovalhistorykeyvalue21.workdayduration_hours, meoffapprovalhistorykeyvalue21.workdayduration_minutes
  • Index Cond: (meoffapprovalhistorykeyvalue21.id = meoffapprovalhistorykeyvalue20.parentid)
  • Filter: (upper(meoffapprovalhistorykeyvalue21.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
200. 0.354 0.354 ↓ 1.1 70 2

Index Scan using ixuhsupervisorid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userhierarchy userhierarchy22 (cost=0.29..102.10 rows=65 width=4) (actual time=0.031..0.177 rows=70 loops=2)

  • Output: userhierarchy22.userid
  • Index Cond: (userhierarchy22.supervisorid = 2892)
  • Filter: ((userhierarchy22.startdate <= '2020-02-09 00:00:00'::timestamp without time zone) AND (userhierarchy22.enddate >= '2020-02-09 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 92
  • Buffers: shared hit=90
201. 0.310 0.785 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_4 (cost=293.73..440.34 rows=15 width=4) (actual time=0.785..0.785 rows=0 loops=1)

  • Output: "*SELECT* 2_4".timeoffid
  • Filter: ((NOT (hashed SubPlan 36)) AND ((hashed SubPlan 33) OR (hashed SubPlan 34) OR (hashed SubPlan 35)))
  • Rows Removed by Filter: 5
  • Buffers: shared hit=180
202. 0.475 0.475 ↑ 7.0 5 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_9 (cost=0.00..145.91 rows=35 width=1,553) (actual time=0.031..0.475 rows=5 loops=1)

  • Output: dm_timeofflist_realtime_facts_9.timeoffid, NULL::text, dm_timeofflist_realtime_facts_9.timeoffowneruserid, 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 <> 5) AND (dm_timeofflist_realtime_facts_9.timeoffstatus = 1))
  • Rows Removed by Filter: 1388
  • Buffers: shared hit=125
203. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..121.32 rows=3 width=4) (never executed)

  • Output: timeoffs15_3.id
  • Filter: (((userhierarchy16_3.supervisorid = 2892) AND ((userhierarchy16_3.startdate IS NULL) OR (userhierarchy16_3.startdate <= '2020-02-09'::date)) AND ((userhierarchy16_3.enddate IS NULL) OR (userhierarchy16_3.enddate >= '2020-02-09'::date))) OR (timeoffs15_3.userid = 2892) OR (alternatives: SubPlan 37 or hashed SubPlan 38) OR (alternatives: SubPlan 39 or hashed SubPlan 40) OR $110 OR (SubPlan 42) OR (SubPlan 43))
204. 0.000 0.000 ↓ 0.0 0

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

  • Output: timeoffs15_3.id, timeoffs15_3.guidid, timeoffs15_3.userid, timeoffs15_3.createdbyuserid, timeoffs15_3.timeoffcodeid, timeoffs15_3.startdate, timeoffs15_3.enddate, timeoffs15_3.approvalstatus, timeoffs15_3.comments, timeoffs15_3.submittedonutc, timeoffs15_3.modifiedonutc, timeoffs15_3.info1, timeoffs15_3.info2, timeoffs15_3.info3, timeoffs15_3.info4, timeoffs15_3.info5, timeoffs15_3.startdurationtype, timeoffs15_3.enddurationtype, timeoffs15_3.startduration, timeoffs15_3.endduration, timeoffs15_3.startdatestarttime, timeoffs15_3.enddateendtime, timeoffs15_3.entryconfigurationmethod
  • Index Cond: (timeoffs15_3.id = "*SELECT* 1_4".timeoffid)
205. 0.000 0.000 ↓ 0.0 0

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

  • Output: userhierarchy16_3.id, userhierarchy16_3.userid, userhierarchy16_3.supervisorid, userhierarchy16_3.startdate, userhierarchy16_3.enddate
  • Index Cond: (userhierarchy16_3.userid = timeoffs15_3.userid)
206.          

SubPlan (for Nested Loop Left Join)

207. 0.000 0.000 ↓ 0.0 0

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

  • Inner Unique: true
208. 0.000 0.000 ↓ 0.0 0

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

  • Output: timeoffapprovalnodes17_6.id, timeoffapprovalnodes17_6.timeoffid, timeoffapprovalnodes17_6.isapproved, timeoffapprovalnodes17_6.approverrole, timeoffapprovalnodes17_6.userid, timeoffapprovalnodes17_6.agentresolutionstate, timeoffapprovalnodes17_6.scriptid
  • Index Cond: (timeoffapprovalnodes17_6.timeoffid = timeoffs15_3.id)
209. 0.000 0.000 ↓ 0.0 0

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

  • Output: timeoffapprovalrequest18_6.approverid, timeoffapprovalrequest18_6.nodeid
  • Index Cond: ((timeoffapprovalrequest18_6.approverid = 2892) AND (timeoffapprovalrequest18_6.nodeid = timeoffapprovalnodes17_6.id))
  • Heap Fetches: 0
210. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7.35..16.07 rows=13 width=4) (never executed)

  • Output: timeoffapprovalnodes17_7.timeoffid
  • Inner Unique: true
  • Hash Cond: (timeoffapprovalnodes17_7.id = timeoffapprovalrequest18_7.nodeid)
211. 0.000 0.000 ↓ 0.0 0

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes17_7 (cost=0.00..7.94 rows=294 width=20) (never executed)

  • Output: timeoffapprovalnodes17_7.id, timeoffapprovalnodes17_7.timeoffid, timeoffapprovalnodes17_7.isapproved, timeoffapprovalnodes17_7.approverrole, timeoffapprovalnodes17_7.userid, timeoffapprovalnodes17_7.agentresolutionstate, timeoffapprovalnodes17_7.scriptid
212. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.19..7.19 rows=13 width=16) (never executed)

  • Output: timeoffapprovalrequest18_7.nodeid
213. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoarapproverid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest18_7 (cost=0.27..7.19 rows=13 width=16) (never executed)

  • Output: timeoffapprovalrequest18_7.nodeid
  • Index Cond: (timeoffapprovalrequest18_7.approverid = 2892)
214. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (timeoffapprovalhistory19_7.timeoffid = timeoffs15_3.id)
  • Filter: ((timeoffapprovalhistory19_7.userid = 2892) AND (timeoffapprovalhistory19_7.action = ANY ('{2,3,4}'::integer[])))
215. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahuserid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory19_8 (cost=0.42..1,239.28 rows=657 width=4) (never executed)

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

CTE Scan on timesheet0cte timesheet22_3 (cost=0.00..0.06 rows=1 width=0) (never executed)

  • Filter: ((timeoffs15_3.startdate <= timesheet22_3.enddate2) AND (timeoffs15_3.enddate >= timesheet22_3.startdate1) AND (timesheet22_3.userid0 = timeoffs15_3.userid) AND ((('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text = upper(timesheet22_3.key3)) AND ('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper(timesheet22_3.uri4))) OR (('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text = upper(timesheet22_3.key3)) AND (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15_3.id)::text, ''::text))) = upper(timesheet22_3.uri4)))))
217. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.87..50.90 rows=1 width=0) (never executed)

  • Join Filter: (((upper(esheetapprovalhistorykeyvalue6_3.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text) OR ((upper(esheetapprovalhistorykeyvalue6_3.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text) AND (upper(esheetapprovalhistorykeyvalue7_3.uri) = 'URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text))) AND ((('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text = upper((esheetapprovalhistorykeyvalue6_3.uri)::text)) AND ('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper((esheetapprovalhistorykeyvalue7_3.uri)::text))) OR (('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text = upper((esheetapprovalhistorykeyvalue6_3.uri)::text)) AND (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15_3.id)::text, ''::text))) = upper((esheetapprovalhistorykeyvalue7_3.uri)::text)))))
218. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.44..50.27 rows=1 width=85) (never executed)

  • Output: esheetapprovalhistorykeyvalue6_3.uri, sheetapprovalhistorykeyvalue13_3.id
219. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.01..45.82 rows=1 width=85) (never executed)

  • Output: esheetapprovalhistorykeyvalue6_3.id, esheetapprovalhistorykeyvalue6_3.uri
220. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.57..45.23 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue12_3.id
221. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.14..43.87 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue11_3.id
222. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.71..41.76 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue10_3.parentid
  • Inner Unique: true
223. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..39.38 rows=1 width=16) (never executed)

  • Output: esheetapprovalhistorykeyvalue9_3.parentid
224. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..14.26 rows=1 width=16) (never executed)

  • Output: timesheetapprovalhistory8_3.id
225. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using ixtah2timesheetid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory8_3 (cost=0.42..5.50 rows=1 width=32) (never executed)

  • Output: timesheetapprovalhistory8_3.id, timesheetapprovalhistory8_3.action, timesheetapprovalhistory8_3.approvalcomments, timesheetapprovalhistory8_3.timestamputc, timesheetapprovalhistory8_3.serialnumber, timesheetapprovalhistory8_3.timesheetid, timesheetapprovalhistory8_3.approvalagenttype, timesheetapprovalhistory8_3.userid, timesheetapprovalhistory8_3.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory8_3.timesheetid = timesheet5_3.id)
  • Filter: (timesheetapprovalhistory8_3.userid = 2892)
227. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue9_3 (cost=0.43..25.11 rows=1 width=32) (never executed)

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

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

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

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

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

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue12_3 (cost=0.43..1.33 rows=3 width=32) (never executed)

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

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue6_3 (cost=0.43..0.58 rows=1 width=101) (never executed)

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

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue13_3 (cost=0.43..4.42 rows=3 width=32) (never executed)

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

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue7_3 (cost=0.43..0.58 rows=1 width=85) (never executed)

  • Output: esheetapprovalhistorykeyvalue7_3.id, esheetapprovalhistorykeyvalue7_3.timesheetapprovalhistoryid, esheetapprovalhistorykeyvalue7_3.parentid, esheetapprovalhistorykeyvalue7_3.index, esheetapprovalhistorykeyvalue7_3.key, esheetapprovalhistorykeyvalue7_3.uri, esheetapprovalhistorykeyvalue7_3.slug, esheetapprovalhistorykeyvalue7_3."boolean", esheetapprovalhistorykeyvalue7_3.date, esheetapprovalhistorykeyvalue7_3.number, esheetapprovalhistorykeyvalue7_3.text, esheetapprovalhistorykeyvalue7_3."time", esheetapprovalhistorykeyvalue7_3.timespan, esheetapprovalhistorykeyvalue7_3.daterange_startdate, esheetapprovalhistorykeyvalue7_3.daterange_enddate, esheetapprovalhistorykeyvalue7_3.daterange_relativedaterangeuri, esheetapprovalhistorykeyvalue7_3.daterange_relativedaterangeasofdate, esheetapprovalhistorykeyvalue7_3.workdayduration_decimalworkdays, esheetapprovalhistorykeyvalue7_3.workdayduration_workdays, esheetapprovalhistorykeyvalue7_3.workdayduration_hours, esheetapprovalhistorykeyvalue7_3.workdayduration_minutes
  • Index Cond: (esheetapprovalhistorykeyvalue7_3.parentid = sheetapprovalhistorykeyvalue13_3.id)
  • Filter: (('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper((esheetapprovalhistorykeyvalue7_3.uri)::text)) OR (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15_3.id)::text, ''::text))) = upper((esheetapprovalhistorykeyvalue7_3.uri)::text)))
234. 0.358 510.355 ↑ 1.0 1 1

Aggregate (cost=15,663,069.69..15,663,069.70 rows=1 width=8) (actual time=510.355..510.355 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=194880
235.          

Initplan (for Aggregate)

236. 0.002 0.074 ↓ 0.0 0 1

Nested Loop (cost=0.43..11.37 rows=1 width=0) (actual time=0.074..0.074 rows=0 loops=1)

  • Buffers: shared hit=9
237. 0.022 0.022 ↑ 1.0 2 1

Index Only Scan using userpolicyset_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userpolicyset userpolicyset20_4 (cost=0.29..3.23 rows=2 width=16) (actual time=0.021..0.022 rows=2 loops=1)

  • Output: userpolicyset20_4.userid, userpolicyset20_4.policysetid
  • Index Cond: (userpolicyset20_4.userid = 2892)
  • Heap Fetches: 2
  • Buffers: shared hit=4
238. 0.050 0.050 ↓ 0.0 0 2

Index Scan using ixpskvpolicysetid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.policysetkeyvalue policysetkeyvalue21_4 (cost=0.14..4.06 rows=1 width=16) (actual time=0.025..0.025 rows=0 loops=2)

  • Output: policysetkeyvalue21_4.id, policysetkeyvalue21_4.policysetid, policysetkeyvalue21_4.parentid, policysetkeyvalue21_4.index, policysetkeyvalue21_4.key, policysetkeyvalue21_4.uri, policysetkeyvalue21_4.slug, policysetkeyvalue21_4."boolean", policysetkeyvalue21_4.date, policysetkeyvalue21_4.number, policysetkeyvalue21_4.text, policysetkeyvalue21_4."time", policysetkeyvalue21_4.timespan, policysetkeyvalue21_4.daterange_startdate, policysetkeyvalue21_4.daterange_enddate, policysetkeyvalue21_4.daterange_relativedaterangeuri, policysetkeyvalue21_4.daterange_relativedaterangeasofdate, policysetkeyvalue21_4.workdayduration_decimalworkdays, policysetkeyvalue21_4.workdayduration_workdays, policysetkeyvalue21_4.workdayduration_hours, policysetkeyvalue21_4.workdayduration_minutes
  • Index Cond: (policysetkeyvalue21_4.policysetid = userpolicyset20_4.policysetid)
  • Filter: ((policysetkeyvalue21_4.parentid IS NULL) AND (upper(policysetkeyvalue21_4.key) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-ALL-TIME-OFF'::text) AND (upper(policysetkeyvalue21_4.uri) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-ALL-TIME-OFF:ALLOWED'::text))
  • Rows Removed by Filter: 12
  • Buffers: shared hit=5
239. 1.663 509.923 ↑ 27.5 3,622 1

Nested Loop Semi Join (cost=278.86..15,662,809.32 rows=99,598 width=0) (actual time=0.551..509.923 rows=3,622 loops=1)

  • Buffers: shared hit=194880
240. 0.407 334.404 ↑ 55.0 3,622 1

Append (cost=278.16..24,347.76 rows=199,195 width=4) (actual time=0.318..334.404 rows=3,622 loops=1)

  • Buffers: shared hit=60612
241. 53.225 332.929 ↑ 54.8 3,622 1

Subquery Scan on *SELECT* 1_5 (cost=278.16..23,911.60 rows=198,555 width=4) (actual time=0.317..332.929 rows=3,622 loops=1)

  • Output: "*SELECT* 1_5".timeoffid
  • Filter: ((hashed SubPlan 45) OR (hashed SubPlan 46) OR (hashed SubPlan 47))
  • Rows Removed by Filter: 223791
  • Buffers: shared hit=60432
242. 49.203 279.270 ↓ 1.0 227,413 1

Merge Anti Join (cost=0.70..19,663.04 rows=226,920 width=1,553) (actual time=0.057..279.270 rows=227,413 loops=1)

  • Output: dm_timeofflist_facts_5.timeoffid, NULL::text, dm_timeofflist_facts_5.timeoffowneruserid, 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_5.timeoffid = dm_timeofflist_realtime_facts_10.timeoffid)
  • Buffers: shared hit=60377
243. 229.501 229.501 ↓ 1.0 228,372 1

Index Scan using dm_timeofflist_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_facts dm_timeofflist_facts_5 (cost=0.42..19,021.74 rows=228,306 width=8) (actual time=0.031..229.501 rows=228,372 loops=1)

  • Output: dm_timeofflist_facts_5.timeoffid, dm_timeofflist_facts_5.timeoffslug, dm_timeofflist_facts_5.timeoffowneruserid, dm_timeofflist_facts_5.timeoffowneruserdisplayname, dm_timeofflist_facts_5.timeoffowneruserslug, dm_timeofflist_facts_5.timeoffowneruserenabled, dm_timeofflist_facts_5.timeoffownerdepartmentid, dm_timeofflist_facts_5.timeoffownerdepartmentdisplayname, dm_timeofflist_facts_5.timeoffownerdepartmentslug, dm_timeofflist_facts_5.timeoffownersupervisoruserid, dm_timeofflist_facts_5.timeoffownersupervisoruserdisplayname, dm_timeofflist_facts_5.timeoffownersupervisoruserslug, dm_timeofflist_facts_5.timeoffcodeid, dm_timeofflist_facts_5.timeoffcodedisplayname, dm_timeofflist_facts_5.timeoffcodeslug, dm_timeofflist_facts_5.approvalstatus, dm_timeofflist_facts_5.timeoffstatus, dm_timeofflist_facts_5.startdate, dm_timeofflist_facts_5.enddate, dm_timeofflist_facts_5.startdaydurationtype, dm_timeofflist_facts_5.enddaydurationtype, dm_timeofflist_facts_5.startdayduration, dm_timeofflist_facts_5.enddayduration, dm_timeofflist_facts_5.startdaystarttime, dm_timeofflist_facts_5.enddayendtime, dm_timeofflist_facts_5.totalduration, dm_timeofflist_facts_5.effectivehoursperday, dm_timeofflist_facts_5.lastactiondatetimeutc, dm_timeofflist_facts_5.waitingonapproveruserid, dm_timeofflist_facts_5.waitingonapproveruserslug, dm_timeofflist_facts_5.waitingonapproveruserdisplayname, dm_timeofflist_facts_5.generatedonutc, dm_timeofflist_facts_5.timeoffowneruseremployeeid, dm_timeofflist_facts_5.timeoffowneruserloginname, dm_timeofflist_facts_5.totalworkdayduration, dm_timeofflist_facts_5.displayformat
  • Filter: ((dm_timeofflist_facts_5.timeoffcodeid <> 5) AND (dm_timeofflist_facts_5.timeoffstatus = 2))
  • Rows Removed by Filter: 1196
  • Buffers: shared hit=60150
244. 0.566 0.566 ↑ 1.0 1,393 1

Index Only Scan using dm_timeofflist_realtime_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_10 (cost=0.28..53.19 rows=1,394 width=4) (actual time=0.022..0.566 rows=1,393 loops=1)

  • Output: dm_timeofflist_realtime_facts_10.timeoffid
  • Heap Fetches: 410
  • Buffers: shared hit=227
245.          

SubPlan (for Subquery Scan)

246. 0.092 0.092 ↑ 1.0 14 2

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_remainingapprovers_facts ist_remainingapprovers_facts26 (cost=0.00..12.43 rows=14 width=4) (actual time=0.025..0.046 rows=14 loops=2)

  • Output: ist_remainingapprovers_facts26.timeoffid
  • Filter: (ist_remainingapprovers_facts26.approveruserid = 2892)
  • Rows Removed by Filter: 500
  • Buffers: shared hit=12
247. 0.002 0.058 ↓ 0.0 0 2

Nested Loop (cost=1.41..162.73 rows=1 width=4) (actual time=0.029..0.029 rows=0 loops=2)

  • Output: timeoffapprovalhistory27.timeoffid
  • Inner Unique: true
  • Buffers: shared hit=8
248. 0.000 0.056 ↓ 0.0 0 2

Nested Loop (cost=0.98..160.28 rows=1 width=20) (actual time=0.028..0.028 rows=0 loops=2)

  • Output: timeoffapprovalhistory27.timeoffid, meoffapprovalhistorykeyvalue28.parentid
  • Inner Unique: true
  • Buffers: shared hit=8
249. 0.056 0.056 ↓ 0.0 0 2

Index Scan using ixtoahkvuri on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistorykeyvalue meoffapprovalhistorykeyvalue28 (cost=0.55..82.04 rows=32 width=20) (actual time=0.028..0.028 rows=0 loops=2)

  • Output: meoffapprovalhistorykeyvalue28.id, meoffapprovalhistorykeyvalue28.timeoffapprovalhistoryid, meoffapprovalhistorykeyvalue28.parentid, meoffapprovalhistorykeyvalue28.index, meoffapprovalhistorykeyvalue28.key, meoffapprovalhistorykeyvalue28.uri, meoffapprovalhistorykeyvalue28.slug, meoffapprovalhistorykeyvalue28."boolean", meoffapprovalhistorykeyvalue28.date, meoffapprovalhistorykeyvalue28.number, meoffapprovalhistorykeyvalue28.text, meoffapprovalhistorykeyvalue28."time", meoffapprovalhistorykeyvalue28.timespan, meoffapprovalhistorykeyvalue28.daterange_startdate, meoffapprovalhistorykeyvalue28.daterange_enddate, meoffapprovalhistorykeyvalue28.daterange_relativedaterangeuri, meoffapprovalhistorykeyvalue28.daterange_relativedaterangeasofdate, meoffapprovalhistorykeyvalue28.workdayduration_decimalworkdays, meoffapprovalhistorykeyvalue28.workdayduration_workdays, meoffapprovalhistorykeyvalue28.workdayduration_hours, meoffapprovalhistorykeyvalue28.workdayduration_minutes
  • Index Cond: (upper(meoffapprovalhistorykeyvalue28.uri) = 'URN:REPLICON-TENANT:2BC736BCEB814ED5B2CB107A69397ACD:USER:2892'::text)
  • Filter: (upper(meoffapprovalhistorykeyvalue28.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
  • Buffers: shared hit=8
250. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalhistory_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory27 (cost=0.42..2.45 rows=1 width=8) (never executed)

  • Output: timeoffapprovalhistory27.id, timeoffapprovalhistory27.timeoffid, timeoffapprovalhistory27.effectivedateutc, timeoffapprovalhistory27.action, timeoffapprovalhistory27.approvalcomments, timeoffapprovalhistory27.approvalagenttype, timeoffapprovalhistory27.userid, timeoffapprovalhistory27.systemprocessidentifier
  • Index Cond: (timeoffapprovalhistory27.id = meoffapprovalhistorykeyvalue28.timeoffapprovalhistoryid)
  • Filter: (timeoffapprovalhistory27.userid = 2892)
251. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistorykeyvalue meoffapprovalhistorykeyvalue29 (cost=0.43..2.45 rows=1 width=16) (never executed)

  • Output: meoffapprovalhistorykeyvalue29.id, meoffapprovalhistorykeyvalue29.timeoffapprovalhistoryid, meoffapprovalhistorykeyvalue29.parentid, meoffapprovalhistorykeyvalue29.index, meoffapprovalhistorykeyvalue29.key, meoffapprovalhistorykeyvalue29.uri, meoffapprovalhistorykeyvalue29.slug, meoffapprovalhistorykeyvalue29."boolean", meoffapprovalhistorykeyvalue29.date, meoffapprovalhistorykeyvalue29.number, meoffapprovalhistorykeyvalue29.text, meoffapprovalhistorykeyvalue29."time", meoffapprovalhistorykeyvalue29.timespan, meoffapprovalhistorykeyvalue29.daterange_startdate, meoffapprovalhistorykeyvalue29.daterange_enddate, meoffapprovalhistorykeyvalue29.daterange_relativedaterangeuri, meoffapprovalhistorykeyvalue29.daterange_relativedaterangeasofdate, meoffapprovalhistorykeyvalue29.workdayduration_decimalworkdays, meoffapprovalhistorykeyvalue29.workdayduration_workdays, meoffapprovalhistorykeyvalue29.workdayduration_hours, meoffapprovalhistorykeyvalue29.workdayduration_minutes
  • Index Cond: (meoffapprovalhistorykeyvalue29.id = meoffapprovalhistorykeyvalue28.parentid)
  • Filter: (upper(meoffapprovalhistorykeyvalue29.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
252. 0.284 0.284 ↓ 1.1 70 2

Index Scan using ixuhsupervisorid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userhierarchy userhierarchy30 (cost=0.29..102.10 rows=65 width=4) (actual time=0.026..0.142 rows=70 loops=2)

  • Output: userhierarchy30.userid
  • Index Cond: (userhierarchy30.supervisorid = 2892)
  • Filter: ((userhierarchy30.startdate <= '2020-02-09 00:00:00'::timestamp without time zone) AND (userhierarchy30.enddate >= '2020-02-09 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 92
  • Buffers: shared hit=90
253. 0.473 1.068 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_5 (cost=277.46..436.16 rows=640 width=4) (actual time=1.067..1.068 rows=0 loops=1)

  • Output: "*SELECT* 2_5".timeoffid
  • Filter: ((hashed SubPlan 45) OR (hashed SubPlan 46) OR (hashed SubPlan 47))
  • Rows Removed by Filter: 959
  • Buffers: shared hit=180
254. 0.595 0.595 ↓ 1.3 959 1

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_11 (cost=0.00..145.91 rows=731 width=1,553) (actual time=0.011..0.595 rows=959 loops=1)

  • Output: dm_timeofflist_realtime_facts_11.timeoffid, NULL::text, dm_timeofflist_realtime_facts_11.timeoffowneruserid, 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_11.deleted) AND (dm_timeofflist_realtime_facts_11.timeoffcodeid <> 5) AND (dm_timeofflist_realtime_facts_11.timeoffstatus = 2))
  • Rows Removed by Filter: 434
  • Buffers: shared hit=125
255. 12.631 173.856 ↑ 3.0 1 3,622

Nested Loop Left Join (cost=0.71..119.43 rows=3 width=4) (actual time=0.048..0.048 rows=1 loops=3,622)

  • Output: timeoffs15_4.id
  • Filter: (((userhierarchy16_4.supervisorid = 2892) AND ((userhierarchy16_4.startdate IS NULL) OR (userhierarchy16_4.startdate <= '2020-02-09'::date)) AND ((userhierarchy16_4.enddate IS NULL) OR (userhierarchy16_4.enddate >= '2020-02-09'::date))) OR (timeoffs15_4.userid = 2892) OR (alternatives: SubPlan 48 or hashed SubPlan 49) OR (alternatives: SubPlan 50 or hashed SubPlan 51) OR $143 OR (SubPlan 53) OR (SubPlan 54))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=134268
256. 7.244 7.244 ↑ 1.0 1 3,622

Index Scan using timeoffs_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffs timeoffs15_4 (cost=0.42..0.47 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=3,622)

  • Output: timeoffs15_4.id, timeoffs15_4.guidid, timeoffs15_4.userid, timeoffs15_4.createdbyuserid, timeoffs15_4.timeoffcodeid, timeoffs15_4.startdate, timeoffs15_4.enddate, timeoffs15_4.approvalstatus, timeoffs15_4.comments, timeoffs15_4.submittedonutc, timeoffs15_4.modifiedonutc, timeoffs15_4.info1, timeoffs15_4.info2, timeoffs15_4.info3, timeoffs15_4.info4, timeoffs15_4.info5, timeoffs15_4.startdurationtype, timeoffs15_4.enddurationtype, timeoffs15_4.startduration, timeoffs15_4.endduration, timeoffs15_4.startdatestarttime, timeoffs15_4.enddateendtime, timeoffs15_4.entryconfigurationmethod
  • Index Cond: (timeoffs15_4.id = "*SELECT* 1_5".timeoffid)
  • Buffers: shared hit=14498
257. 7.244 7.244 ↑ 1.0 2 3,622

Index Scan using ix3uh_usersuperstart on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.userhierarchy userhierarchy16_4 (cost=0.29..0.32 rows=2 width=24) (actual time=0.002..0.002 rows=2 loops=3,622)

  • Output: userhierarchy16_4.id, userhierarchy16_4.userid, userhierarchy16_4.supervisorid, userhierarchy16_4.startdate, userhierarchy16_4.enddate
  • Index Cond: (userhierarchy16_4.userid = timeoffs15_4.userid)
  • Buffers: shared hit=12684
258.          

SubPlan (for Nested Loop Left Join)

259. 0.000 5.886 ↓ 0.0 0 5,886

Nested Loop (cost=0.55..4.87 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=5,886)

  • Inner Unique: true
  • Buffers: shared hit=13139
260. 5.886 5.886 ↓ 0.0 0 5,886

Index Scan using ixtoantimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes17_8 (cost=0.27..2.29 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=5,886)

  • Output: timeoffapprovalnodes17_8.id, timeoffapprovalnodes17_8.timeoffid, timeoffapprovalnodes17_8.isapproved, timeoffapprovalnodes17_8.approverrole, timeoffapprovalnodes17_8.userid, timeoffapprovalnodes17_8.agentresolutionstate, timeoffapprovalnodes17_8.scriptid
  • Index Cond: (timeoffapprovalnodes17_8.timeoffid = timeoffs15_4.id)
  • Buffers: shared hit=13139
261. 0.000 0.000 ↓ 0.0 0

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

  • Output: timeoffapprovalrequest18_8.approverid, timeoffapprovalrequest18_8.nodeid
  • Index Cond: ((timeoffapprovalrequest18_8.approverid = 2892) AND (timeoffapprovalrequest18_8.nodeid = timeoffapprovalnodes17_8.id))
  • Heap Fetches: 0
262. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7.35..16.07 rows=13 width=4) (never executed)

  • Output: timeoffapprovalnodes17_9.timeoffid
  • Inner Unique: true
  • Hash Cond: (timeoffapprovalnodes17_9.id = timeoffapprovalrequest18_9.nodeid)
263. 0.000 0.000 ↓ 0.0 0

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalnodes timeoffapprovalnodes17_9 (cost=0.00..7.94 rows=294 width=20) (never executed)

  • Output: timeoffapprovalnodes17_9.id, timeoffapprovalnodes17_9.timeoffid, timeoffapprovalnodes17_9.isapproved, timeoffapprovalnodes17_9.approverrole, timeoffapprovalnodes17_9.userid, timeoffapprovalnodes17_9.agentresolutionstate, timeoffapprovalnodes17_9.scriptid
264. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.19..7.19 rows=13 width=16) (never executed)

  • Output: timeoffapprovalrequest18_9.nodeid
265. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoarapproverid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalrequest timeoffapprovalrequest18_9 (cost=0.27..7.19 rows=13 width=16) (never executed)

  • Output: timeoffapprovalrequest18_9.nodeid
  • Index Cond: (timeoffapprovalrequest18_9.approverid = 2892)
266. 17.658 17.658 ↓ 0.0 0 5,886

Index Scan using ixtoahtimeoffid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory19_9 (cost=0.42..3.47 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=5,886)

  • Index Cond: (timeoffapprovalhistory19_9.timeoffid = timeoffs15_4.id)
  • Filter: ((timeoffapprovalhistory19_9.userid = 2892) AND (timeoffapprovalhistory19_9.action = ANY ('{2,3,4}'::integer[])))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=27236
267. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahuserid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timeoffapprovalhistory timeoffapprovalhistory19_10 (cost=0.42..1,239.28 rows=657 width=4) (never executed)

  • Output: timeoffapprovalhistory19_10.timeoffid
  • Index Cond: (timeoffapprovalhistory19_10.userid = 2892)
  • Filter: (timeoffapprovalhistory19_10.action = ANY ('{2,3,4}'::integer[]))
268. 5.134 5.134 ↓ 0.0 0 5,134

CTE Scan on timesheet0cte timesheet22_4 (cost=0.00..0.06 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=5,134)

  • Filter: ((timeoffs15_4.startdate <= timesheet22_4.enddate2) AND (timeoffs15_4.enddate >= timesheet22_4.startdate1) AND (timesheet22_4.userid0 = timeoffs15_4.userid) AND ((('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text = upper(timesheet22_4.key3)) AND ('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper(timesheet22_4.uri4))) OR (('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text = upper(timesheet22_4.key3)) AND (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15_4.id)::text, ''::text))) = upper(timesheet22_4.uri4)))))
  • Rows Removed by Filter: 4
269. 5.215 118.059 ↓ 0.0 0 5,133

Nested Loop (cost=3.87..50.90 rows=1 width=0) (actual time=0.023..0.023 rows=0 loops=5,133)

  • Join Filter: (((upper(esheetapprovalhistorykeyvalue6_4.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text) OR ((upper(esheetapprovalhistorykeyvalue6_4.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text) AND (upper(esheetapprovalhistorykeyvalue7_4.uri) = 'URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text))) AND ((('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text = upper((esheetapprovalhistorykeyvalue6_4.uri)::text)) AND ('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper((esheetapprovalhistorykeyvalue7_4.uri)::text))) OR (('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text = upper((esheetapprovalhistorykeyvalue6_4.uri)::text)) AND (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15_4.id)::text, ''::text))) = upper((esheetapprovalhistorykeyvalue7_4.uri)::text)))))
  • Buffers: shared hit=66702
270. 2.430 97.527 ↓ 0.0 0 5,133

Nested Loop (cost=3.44..50.27 rows=1 width=85) (actual time=0.019..0.019 rows=0 loops=5,133)

  • Output: esheetapprovalhistorykeyvalue6_4.uri, sheetapprovalhistorykeyvalue13_4.id
  • Buffers: shared hit=62874
271. 0.000 92.394 ↓ 0.0 0 5,133

Nested Loop (cost=3.01..45.82 rows=1 width=85) (actual time=0.018..0.018 rows=0 loops=5,133)

  • Output: esheetapprovalhistorykeyvalue6_4.id, esheetapprovalhistorykeyvalue6_4.uri
  • Buffers: shared hit=59260
272. 2.394 87.261 ↓ 0.0 0 5,133

Nested Loop (cost=2.57..45.23 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=5,133)

  • Output: sheetapprovalhistorykeyvalue12_4.id
  • Buffers: shared hit=55615
273. 3.875 82.128 ↓ 0.0 0 5,133

Nested Loop (cost=2.14..43.87 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=5,133)

  • Output: sheetapprovalhistorykeyvalue11_4.id
  • Buffers: shared hit=51957
274. 0.568 71.862 ↓ 0.0 0 5,133

Nested Loop (cost=1.71..41.76 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=5,133)

  • Output: sheetapprovalhistorykeyvalue10_4.parentid
  • Inner Unique: true
  • Buffers: shared hit=48184
275. 0.000 66.729 ↓ 0.0 0 5,133

Nested Loop (cost=1.27..39.38 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=5,133)

  • Output: esheetapprovalhistorykeyvalue9_4.parentid
  • Buffers: shared hit=44523
276. 8.919 30.798 ↓ 0.0 0 5,133

Nested Loop (cost=0.84..14.26 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=5,133)

  • Output: timesheetapprovalhistory8_4.id
  • Buffers: shared hit=39956
277. 10.266 10.266 ↑ 2.0 1 5,133

Index Scan using ixtsuseridstartdateenddate on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheet timesheet5_4 (cost=0.42..3.24 rows=2 width=16) (actual time=0.002..0.002 rows=1 loops=5,133)

  • Output: timesheet5_4.id, timesheet5_4.userid, timesheet5_4.startdate, timesheet5_4.enddate, timesheet5_4.approvalstatus, timesheet5_4.duedate, timesheet5_4.autosubmitdatetimeutc, timesheet5_4.lastautosubmitattemptdatetimeutc, timesheet5_4.createdonutc
  • Index Cond: ((timesheet5_4.userid = timeoffs15_4.userid) AND (timeoffs15_4.enddate >= timesheet5_4.startdate) AND (timeoffs15_4.startdate <= timesheet5_4.enddate))
  • Buffers: shared hit=19948
278. 11.613 11.613 ↓ 0.0 0 3,871

Index Scan using ixtah2timesheetid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistory timesheetapprovalhistory8_4 (cost=0.42..5.50 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=3,871)

  • Output: timesheetapprovalhistory8_4.id, timesheetapprovalhistory8_4.action, timesheetapprovalhistory8_4.approvalcomments, timesheetapprovalhistory8_4.timestamputc, timesheetapprovalhistory8_4.serialnumber, timesheetapprovalhistory8_4.timesheetid, timesheetapprovalhistory8_4.approvalagenttype, timesheetapprovalhistory8_4.userid, timesheetapprovalhistory8_4.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory8_4.timesheetid = timesheet5_4.id)
  • Filter: (timesheetapprovalhistory8_4.userid = 2892)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=20008
279. 36.520 36.520 ↑ 1.0 1 913

Index Scan using ixtahkvtimesheetapprovalhistoryid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue9_4 (cost=0.43..25.11 rows=1 width=32) (actual time=0.040..0.040 rows=1 loops=913)

  • Output: esheetapprovalhistorykeyvalue9_4.id, esheetapprovalhistorykeyvalue9_4.timesheetapprovalhistoryid, esheetapprovalhistorykeyvalue9_4.parentid, esheetapprovalhistorykeyvalue9_4.index, esheetapprovalhistorykeyvalue9_4.key, esheetapprovalhistorykeyvalue9_4.uri, esheetapprovalhistorykeyvalue9_4.slug, esheetapprovalhistorykeyvalue9_4."boolean", esheetapprovalhistorykeyvalue9_4.date, esheetapprovalhistorykeyvalue9_4.number, esheetapprovalhistorykeyvalue9_4.text, esheetapprovalhistorykeyvalue9_4."time", esheetapprovalhistorykeyvalue9_4.timespan, esheetapprovalhistorykeyvalue9_4.daterange_startdate, esheetapprovalhistorykeyvalue9_4.daterange_enddate, esheetapprovalhistorykeyvalue9_4.daterange_relativedaterangeuri, esheetapprovalhistorykeyvalue9_4.daterange_relativedaterangeasofdate, esheetapprovalhistorykeyvalue9_4.workdayduration_decimalworkdays, esheetapprovalhistorykeyvalue9_4.workdayduration_workdays, esheetapprovalhistorykeyvalue9_4.workdayduration_hours, esheetapprovalhistorykeyvalue9_4.workdayduration_minutes
  • Index Cond: (esheetapprovalhistorykeyvalue9_4.timesheetapprovalhistoryid = timesheetapprovalhistory8_4.id)
  • Filter: ((upper(esheetapprovalhistorykeyvalue9_4.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(esheetapprovalhistorykeyvalue9_4.uri) = 'URN:REPLICON-TENANT:JSIPRODG3TRIAL:USER:2892'::text))
  • Rows Removed by Filter: 22
  • Buffers: shared hit=4567
280. 4.565 4.565 ↑ 1.0 1 913

Index Scan using timesheetapprovalhistorykeyvalue_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue10_4 (cost=0.43..2.38 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=913)

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

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue11_4 (cost=0.43..2.10 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=913)

  • Output: sheetapprovalhistorykeyvalue11_4.id, sheetapprovalhistorykeyvalue11_4.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue11_4.parentid, sheetapprovalhistorykeyvalue11_4.index, sheetapprovalhistorykeyvalue11_4.key, sheetapprovalhistorykeyvalue11_4.uri, sheetapprovalhistorykeyvalue11_4.slug, sheetapprovalhistorykeyvalue11_4."boolean", sheetapprovalhistorykeyvalue11_4.date, sheetapprovalhistorykeyvalue11_4.number, sheetapprovalhistorykeyvalue11_4.text, sheetapprovalhistorykeyvalue11_4."time", sheetapprovalhistorykeyvalue11_4.timespan, sheetapprovalhistorykeyvalue11_4.daterange_startdate, sheetapprovalhistorykeyvalue11_4.daterange_enddate, sheetapprovalhistorykeyvalue11_4.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue11_4.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue11_4.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue11_4.workdayduration_workdays, sheetapprovalhistorykeyvalue11_4.workdayduration_hours, sheetapprovalhistorykeyvalue11_4.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue11_4.parentid = sheetapprovalhistorykeyvalue10_4.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue11_4.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=3773
282. 2.739 2.739 ↑ 3.0 1 913

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue12_4 (cost=0.43..1.33 rows=3 width=32) (actual time=0.003..0.003 rows=1 loops=913)

  • Output: sheetapprovalhistorykeyvalue12_4.id, sheetapprovalhistorykeyvalue12_4.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue12_4.parentid, sheetapprovalhistorykeyvalue12_4.index, sheetapprovalhistorykeyvalue12_4.key, sheetapprovalhistorykeyvalue12_4.uri, sheetapprovalhistorykeyvalue12_4.slug, sheetapprovalhistorykeyvalue12_4."boolean", sheetapprovalhistorykeyvalue12_4.date, sheetapprovalhistorykeyvalue12_4.number, sheetapprovalhistorykeyvalue12_4.text, sheetapprovalhistorykeyvalue12_4."time", sheetapprovalhistorykeyvalue12_4.timespan, sheetapprovalhistorykeyvalue12_4.daterange_startdate, sheetapprovalhistorykeyvalue12_4.daterange_enddate, sheetapprovalhistorykeyvalue12_4.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue12_4.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue12_4.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue12_4.workdayduration_workdays, sheetapprovalhistorykeyvalue12_4.workdayduration_hours, sheetapprovalhistorykeyvalue12_4.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue12_4.parentid = sheetapprovalhistorykeyvalue11_4.id)
  • Buffers: shared hit=3658
283. 5.478 5.478 ↑ 1.0 1 913

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue6_4 (cost=0.43..0.58 rows=1 width=101) (actual time=0.006..0.006 rows=1 loops=913)

  • Output: esheetapprovalhistorykeyvalue6_4.id, esheetapprovalhistorykeyvalue6_4.timesheetapprovalhistoryid, esheetapprovalhistorykeyvalue6_4.parentid, esheetapprovalhistorykeyvalue6_4.index, esheetapprovalhistorykeyvalue6_4.key, esheetapprovalhistorykeyvalue6_4.uri, esheetapprovalhistorykeyvalue6_4.slug, esheetapprovalhistorykeyvalue6_4."boolean", esheetapprovalhistorykeyvalue6_4.date, esheetapprovalhistorykeyvalue6_4.number, esheetapprovalhistorykeyvalue6_4.text, esheetapprovalhistorykeyvalue6_4."time", esheetapprovalhistorykeyvalue6_4.timespan, esheetapprovalhistorykeyvalue6_4.daterange_startdate, esheetapprovalhistorykeyvalue6_4.daterange_enddate, esheetapprovalhistorykeyvalue6_4.daterange_relativedaterangeuri, esheetapprovalhistorykeyvalue6_4.daterange_relativedaterangeasofdate, esheetapprovalhistorykeyvalue6_4.workdayduration_decimalworkdays, esheetapprovalhistorykeyvalue6_4.workdayduration_workdays, esheetapprovalhistorykeyvalue6_4.workdayduration_hours, esheetapprovalhistorykeyvalue6_4.workdayduration_minutes
  • Index Cond: (esheetapprovalhistorykeyvalue6_4.parentid = sheetapprovalhistorykeyvalue12_4.id)
  • Filter: (((upper(esheetapprovalhistorykeyvalue6_4.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text) OR (upper(esheetapprovalhistorykeyvalue6_4.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)) AND (('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text = upper((esheetapprovalhistorykeyvalue6_4.uri)::text)) OR ('URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text = upper((esheetapprovalhistorykeyvalue6_4.uri)::text))))
  • Buffers: shared hit=3645
284. 2.703 2.703 ↑ 3.0 1 901

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue13_4 (cost=0.43..4.42 rows=3 width=32) (actual time=0.003..0.003 rows=1 loops=901)

  • Output: sheetapprovalhistorykeyvalue13_4.id, sheetapprovalhistorykeyvalue13_4.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue13_4.parentid, sheetapprovalhistorykeyvalue13_4.index, sheetapprovalhistorykeyvalue13_4.key, sheetapprovalhistorykeyvalue13_4.uri, sheetapprovalhistorykeyvalue13_4.slug, sheetapprovalhistorykeyvalue13_4."boolean", sheetapprovalhistorykeyvalue13_4.date, sheetapprovalhistorykeyvalue13_4.number, sheetapprovalhistorykeyvalue13_4.text, sheetapprovalhistorykeyvalue13_4."time", sheetapprovalhistorykeyvalue13_4.timespan, sheetapprovalhistorykeyvalue13_4.daterange_startdate, sheetapprovalhistorykeyvalue13_4.daterange_enddate, sheetapprovalhistorykeyvalue13_4.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue13_4.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue13_4.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue13_4.workdayduration_workdays, sheetapprovalhistorykeyvalue13_4.workdayduration_hours, sheetapprovalhistorykeyvalue13_4.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue13_4.parentid = esheetapprovalhistorykeyvalue6_4.id)
  • Buffers: shared hit=3614
285. 15.317 15.317 ↑ 1.0 1 901

Index Scan using ixtahkvparentid on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue7_4 (cost=0.43..0.58 rows=1 width=85) (actual time=0.017..0.017 rows=1 loops=901)

  • Output: esheetapprovalhistorykeyvalue7_4.id, esheetapprovalhistorykeyvalue7_4.timesheetapprovalhistoryid, esheetapprovalhistorykeyvalue7_4.parentid, esheetapprovalhistorykeyvalue7_4.index, esheetapprovalhistorykeyvalue7_4.key, esheetapprovalhistorykeyvalue7_4.uri, esheetapprovalhistorykeyvalue7_4.slug, esheetapprovalhistorykeyvalue7_4."boolean", esheetapprovalhistorykeyvalue7_4.date, esheetapprovalhistorykeyvalue7_4.number, esheetapprovalhistorykeyvalue7_4.text, esheetapprovalhistorykeyvalue7_4."time", esheetapprovalhistorykeyvalue7_4.timespan, esheetapprovalhistorykeyvalue7_4.daterange_startdate, esheetapprovalhistorykeyvalue7_4.daterange_enddate, esheetapprovalhistorykeyvalue7_4.daterange_relativedaterangeuri, esheetapprovalhistorykeyvalue7_4.daterange_relativedaterangeasofdate, esheetapprovalhistorykeyvalue7_4.workdayduration_decimalworkdays, esheetapprovalhistorykeyvalue7_4.workdayduration_workdays, esheetapprovalhistorykeyvalue7_4.workdayduration_hours, esheetapprovalhistorykeyvalue7_4.workdayduration_minutes
  • Index Cond: (esheetapprovalhistorykeyvalue7_4.parentid = sheetapprovalhistorykeyvalue13_4.id)
  • Filter: (('URN:REPLICON:TIME-OFF-DATA-ACCESS-LEVEL:TIMESHEET-APPROVER'::text = upper((esheetapprovalhistorykeyvalue7_4.uri)::text)) OR (upper(('urn:replicon-tenant:jsiprodg3trial:time-off:'::text || COALESCE((timeoffs15_4.id)::text, ''::text))) = upper((esheetapprovalhistorykeyvalue7_4.uri)::text)))
  • Rows Removed by Filter: 5
  • Buffers: shared hit=3828
286. 18,760.735 18,765.047 ↑ 229,142.0 1 1

Result (cost=0.70..12,151.22 rows=229,142 width=40) (actual time=18,765.046..18,765.047 rows=1 loops=1)

  • Output: $36, $69, $97, $131, $162
  • Buffers: shared hit=419575 read=21751
287. 0.000 4.312 ↑ 229,142.0 1 1

Append (cost=0.70..9,859.80 rows=229,142 width=0) (actual time=4.312..4.312 rows=1 loops=1)

  • Buffers: shared hit=4 read=3
288. 0.000 4.312 ↑ 228,172.0 1 1

Subquery Scan on *SELECT* 1 (cost=0.70..9,711.16 rows=228,172 width=0) (actual time=4.312..4.312 rows=1 loops=1)

  • Buffers: shared hit=4 read=3
289. 0.004 4.312 ↑ 228,172.0 1 1

Merge Anti Join (cost=0.70..7,429.44 rows=228,172 width=1,553) (actual time=4.312..4.312 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=4 read=3
290. 4.242 4.242 ↑ 229,566.0 1 1

Index Only Scan using dm_timeofflist_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_facts (cost=0.42..6,784.91 rows=229,566 width=4) (actual time=4.242..4.242 rows=1 loops=1)

  • Output: dm_timeofflist_facts.timeoffid
  • Heap Fetches: 0
  • Buffers: shared hit=1 read=3
291. 0.066 0.066 ↑ 1,394.0 1 1

Index Only Scan using dm_timeofflist_realtime_facts_pkey on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts (cost=0.28..53.19 rows=1,394 width=4) (actual time=0.066..0.066 rows=1 loops=1)

  • Output: dm_timeofflist_realtime_facts.timeoffid
  • Heap Fetches: 0
  • Buffers: shared hit=3
292. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2 (cost=0.00..148.64 rows=970 width=0) (never executed)

293. 0.000 0.000 ↓ 0.0 0

Seq Scan on jsiprodg3trial_67c658be93d64a3fbc56f029e5ed9f6c.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_1 (cost=0.00..138.94 rows=970 width=1,553) (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 : 343.491 ms
Execution time : 18,768.869 ms