explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Anfp

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 46,680.280 ↑ 1.0 1 1

Limit (cost=49,564,237.27..49,564,237.32 rows=1 width=32) (actual time=46,680.265..46,680.280 rows=1 loops=1)

  • Output: ($59), ($123), ($185), ($245)
  • Buffers: shared hit=15,651,474
2.          

Initplan (for Limit)

3. 0.012 23,524.841 ↑ 1.0 1 1

Aggregate (cost=24,648,817.38..24,648,817.39 rows=1 width=8) (actual time=23,524.841..23,524.841 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=7,816,527
4.          

Initplan (for Aggregate)

5. 0.002 0.041 ↓ 0.0 0 1

Nested Loop (cost=0.56..10.56 rows=1 width=0) (actual time=0.041..0.041 rows=0 loops=1)

  • Buffers: shared hit=7
6. 0.015 0.015 ↑ 1.0 1 1

Index Only Scan using userpolicyset_pkey on assuredpartnersincdemo.userpolicyset userpolicyset9 (cost=0.29..2.30 rows=1 width=16) (actual time=0.015..0.015 rows=1 loops=1)

  • Output: userpolicyset9.userid, userpolicyset9.policysetid
  • Index Cond: (userpolicyset9.userid = 6,186)
  • Heap Fetches: 1
  • Buffers: shared hit=4
7. 0.024 0.024 ↓ 0.0 0 1

Index Scan using ixpskvpolicysetid on assuredpartnersincdemo.policysetkeyvalue policysetkeyvalue10 (cost=0.27..8.24 rows=1 width=16) (actual time=0.024..0.024 rows=0 loops=1)

  • Output: policysetkeyvalue10.id, policysetkeyvalue10.policysetid, policysetkeyvalue10.parentid, policysetkeyvalue10.index, policysetkeyvalue10.key, policysetkeyvalue10.uri, policysetkeyvalue10.slug, policysetkeyvalue10."boolean", policysetkeyvalue10.date, policysetkeyvalue10.number, policysetkeyvalue10.text, policysetkeyvalue10."time", policysetkeyvalue10.timespan, policysetkeyvalue10.daterange_startdate, policysetkeyvalue10.daterange_enddate, policysetkeyvalue10.daterange_relativedaterangeuri, policysetkeyvalue10.daterange_relativedaterangeasofdate, policysetkeyvalue10.workdayduration_decimalworkdays, policysetkeyvalue10.workdayduration_workdays, policysetkeyvalue10.workdayduration_hours, policysetkeyvalue10.workdayduration_minutes
  • Index Cond: (policysetkeyvalue10.policysetid = userpolicyset9.policysetid)
  • Filter: ((policysetkeyvalue10.parentid IS NULL) AND (upper(policysetkeyvalue10.key) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-OTHERS-TIME-OFF'::text) AND (upper(policysetkeyvalue10.uri) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-OTHERS-TIME-OFF:ALLOWED'::text))
  • Rows Removed by Filter: 5
  • Buffers: shared hit=3
8. 0.724 23,524.788 ↑ 349.2 117 1

Merge Semi Join (cost=26,776.79..24,648,704.68 rows=40,858 width=0) (actual time=22,714.543..23,524.788 rows=117 loops=1)

  • Merge Cond: ("*SELECT* 1_1".timeoffid = timeoffs1.id)
  • Buffers: shared hit=7,816,527
9. 0.101 179.968 ↑ 698.4 117 1

Sort (cost=26,250.41..26,454.70 rows=81,716 width=12) (actual time=179.928..179.968 rows=117 loops=1)

  • Output: "*SELECT* 1_1".timeoffid, timeoffs39.id, timeoffs40.id
  • Sort Key: "*SELECT* 1_1".timeoffid
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=12,299
10. 16.468 179.867 ↑ 698.4 117 1

Hash Semi Join (cost=942.47..19,583.07 rows=81,716 width=12) (actual time=9.956..179.867 rows=117 loops=1)

  • Output: "*SELECT* 1_1".timeoffid, timeoffs39.id, timeoffs40.id
  • Hash Cond: ("*SELECT* 1_1".timeoffid = timeoffs39.id)
  • Buffers: shared hit=12,299
11. 18.438 162.370 ↓ 1.0 163,624 1

Append (cost=31.20..17,333.71 rows=163,431 width=4) (actual time=0.078..162.370 rows=163,624 loops=1)

  • Buffers: shared hit=11,068
12. 21.511 143.828 ↓ 1.0 163,554 1

Subquery Scan on *SELECT* 1_1 (cost=31.20..17,276.14 rows=163,362 width=4) (actual time=0.077..143.828 rows=163,554 loops=1)

  • Output: "*SELECT* 1_1".timeoffid
  • Buffers: shared hit=11,012
13. 50.524 122.317 ↓ 1.0 163,554 1

Hash Anti Join (cost=31.20..15,642.52 rows=163,362 width=1,553) (actual time=0.077..122.317 rows=163,554 loops=1)

  • Output: dm_timeofflist_facts_1.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Hash Cond: (dm_timeofflist_facts_1.timeoffid = dm_timeofflist_realtime_facts_2.timeoffid)
  • Buffers: shared hit=11,012
14. 71.726 71.726 ↓ 1.0 163,624 1

Seq Scan on assuredpartnersincdemo.dm_timeofflist_facts dm_timeofflist_facts_1 (cost=0.00..13,548.66 rows=163,418 width=4) (actual time=0.003..71.726 rows=163,624 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.totalworkdayduration, 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.displayformat
  • Filter: (dm_timeofflist_facts_1.timeoffcodeid <> 69)
  • Rows Removed by Filter: 41,594
  • Buffers: shared hit=10,986
15. 0.011 0.067 ↑ 1.0 70 1

Hash (cost=30.33..30.33 rows=70 width=4) (actual time=0.067..0.067 rows=70 loops=1)

  • Output: dm_timeofflist_realtime_facts_2.timeoffid
  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=26
16. 0.056 0.056 ↑ 1.0 70 1

Index Only Scan using dm_timeofflist_realtime_facts_pkey on assuredpartnersincdemo.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_2 (cost=0.27..30.33 rows=70 width=4) (actual time=0.015..0.056 rows=70 loops=1)

  • Output: dm_timeofflist_realtime_facts_2.timeoffid
  • Heap Fetches: 46
  • Buffers: shared hit=26
17. 0.007 0.104 ↓ 1.0 70 1

Subquery Scan on *SELECT* 2_1 (cost=0.00..57.56 rows=69 width=4) (actual time=0.011..0.104 rows=70 loops=1)

  • Output: "*SELECT* 2_1".timeoffid
  • Buffers: shared hit=56
18. 0.097 0.097 ↓ 1.0 70 1

Seq Scan on assuredpartnersincdemo.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_3 (cost=0.00..56.88 rows=69 width=1,553) (actual time=0.010..0.097 rows=70 loops=1)

  • Output: dm_timeofflist_realtime_facts_3.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Filter: ((NOT dm_timeofflist_realtime_facts_3.deleted) AND (dm_timeofflist_realtime_facts_3.timeoffcodeid <> 69))
  • Buffers: shared hit=56
19. 0.029 1.029 ↑ 4.9 169 1

Hash (cost=900.90..900.90 rows=829 width=8) (actual time=1.029..1.029 rows=169 loops=1)

  • Output: timeoffs39.id, timeoffs40.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=1,231
20. 0.060 1.000 ↑ 4.9 169 1

Nested Loop (cost=525.77..900.90 rows=829 width=8) (actual time=0.601..1.000 rows=169 loops=1)

  • Output: timeoffs39.id, timeoffs40.id
  • Inner Unique: true
  • Buffers: shared hit=1,231
21. 0.069 0.602 ↑ 4.9 169 1

HashAggregate (cost=525.35..533.64 rows=829 width=4) (actual time=0.573..0.602 rows=169 loops=1)

  • Output: timeoffs40.id
  • Group Key: timeoffs40.id
  • Buffers: shared hit=554
22. 0.097 0.533 ↑ 4.9 169 1

Nested Loop (cost=0.84..523.28 rows=829 width=4) (actual time=0.053..0.533 rows=169 loops=1)

  • Output: timeoffs40.id
  • Buffers: shared hit=554
23. 0.020 0.115 ↑ 2.5 107 1

Nested Loop (cost=0.43..145.94 rows=267 width=12) (actual time=0.035..0.115 rows=107 loops=1)

  • Output: usercostcenter41.userid, usercostcenter41.startdate, usercostcenter41.enddate
  • Buffers: shared hit=71
24. 0.012 0.012 ↑ 1.0 1 1

Index Only Scan using costcenterflathierarchy_pkey on assuredpartnersincdemo.costcenterflathierarchy costcenterflathierarchy42 (cost=0.14..1.16 rows=1 width=16) (actual time=0.011..0.012 rows=1 loops=1)

  • Output: costcenterflathierarchy42.parentid, costcenterflathierarchy42.childid
  • Index Cond: (costcenterflathierarchy42.parentid = 'badda568-ec7f-42e1-9cbb-56e53c1aeda7'::uuid)
  • Heap Fetches: 1
  • Buffers: shared hit=3
25. 0.083 0.083 ↑ 3.0 107 1

Index Scan using ixucccostcenterid on assuredpartnersincdemo.usercostcenter usercostcenter41 (cost=0.29..141.52 rows=326 width=28) (actual time=0.021..0.083 rows=107 loops=1)

  • Output: usercostcenter41.id, usercostcenter41.userid, usercostcenter41.costcenterid, usercostcenter41.startdate, usercostcenter41.enddate
  • Index Cond: (usercostcenter41.costcenterid = costcenterflathierarchy42.childid)
  • Buffers: shared hit=68
26. 0.321 0.321 ↑ 2.0 2 107

Index Scan using ixto4userid on assuredpartnersincdemo.timeoffs timeoffs40 (cost=0.42..1.37 rows=4 width=16) (actual time=0.003..0.003 rows=2 loops=107)

  • Output: timeoffs40.id, timeoffs40.guidid, timeoffs40.userid, timeoffs40.createdbyuserid, timeoffs40.timeoffcodeid, timeoffs40.startdate, timeoffs40.enddate, timeoffs40.approvalstatus, timeoffs40.comments, timeoffs40.submittedonutc, timeoffs40.modifiedonutc, timeoffs40.info1, timeoffs40.info2, timeoffs40.info3, timeoffs40.info4, timeoffs40.info5, timeoffs40.startdurationtype, timeoffs40.enddurationtype, timeoffs40.startduration, timeoffs40.endduration, timeoffs40.startdatestarttime, timeoffs40.enddateendtime, timeoffs40.entryconfigurationmethod
  • Index Cond: ((timeoffs40.userid = usercostcenter41.userid) AND (usercostcenter41.enddate >= timeoffs40.startdate) AND (usercostcenter41.startdate <= timeoffs40.enddate))
  • Buffers: shared hit=483
27. 0.338 0.338 ↑ 1.0 1 169

Index Only Scan using timeoffs_pkey on assuredpartnersincdemo.timeoffs timeoffs39 (cost=0.42..0.44 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=169)

  • Output: timeoffs39.id
  • Index Cond: (timeoffs39.id = timeoffs40.id)
  • Heap Fetches: 169
  • Buffers: shared hit=677
28. 966.887 23,344.096 ↑ 202.5 1,484 1

Nested Loop Left Join (cost=526.38..24,620,106.35 rows=300,583 width=4) (actual time=15,396.259..23,344.096 rows=1,484 loops=1)

  • Output: timeoffs1.id
  • Filter: (((userhierarchy2.supervisorid = 6,186) AND ((userhierarchy2.startdate IS NULL) OR (userhierarchy2.startdate <= '2020-07-01'::date)) AND ((userhierarchy2.enddate IS NULL) OR (userhierarchy2.enddate >= '2020-07-01'::date))) OR (timeoffs1.userid = 6,186) OR (alternatives: SubPlan 1 or hashed SubPlan 2) OR (alternatives: SubPlan 3 or hashed SubPlan 4) OR (hashed SubPlan 5) OR $12 OR (SubPlan 7) OR (SubPlan 8) OR (SubPlan 9) OR (SubPlan 10))
  • Rows Removed by Filter: 327,219
  • Buffers: shared hit=7,804,228
29. 162.910 162.910 ↑ 1.0 205,157 1

Index Scan using timeoffs_pkey on assuredpartnersincdemo.timeoffs timeoffs1 (cost=0.42..7,958.06 rows=206,776 width=16) (actual time=0.055..162.910 rows=205,157 loops=1)

  • Output: timeoffs1.id, timeoffs1.guidid, timeoffs1.userid, timeoffs1.createdbyuserid, timeoffs1.timeoffcodeid, timeoffs1.startdate, timeoffs1.enddate, timeoffs1.approvalstatus, timeoffs1.comments, timeoffs1.submittedonutc, timeoffs1.modifiedonutc, timeoffs1.info1, timeoffs1.info2, timeoffs1.info3, timeoffs1.info4, timeoffs1.info5, timeoffs1.startdurationtype, timeoffs1.enddurationtype, timeoffs1.startduration, timeoffs1.endduration, timeoffs1.startdatestarttime, timeoffs1.enddateendtime, timeoffs1.entryconfigurationmethod
  • Buffers: shared hit=84,349
30. 615.471 615.471 ↓ 2.0 2 205,157

Index Scan using ix3uh_usersuperstart on assuredpartnersincdemo.userhierarchy userhierarchy2 (cost=0.29..0.30 rows=1 width=24) (actual time=0.003..0.003 rows=2 loops=205,157)

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

SubPlan (for Nested Loop Left Join)

32. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Output: timeoffapprovalrequest4.approverid, timeoffapprovalrequest4.nodeid
  • Index Cond: ((timeoffapprovalrequest4.approverid = 6,186) AND (timeoffapprovalrequest4.nodeid = timeoffapprovalnodes3.id))
  • Heap Fetches: 0
35. 0.012 0.089 ↑ 1.0 9 1

Nested Loop (cost=0.55..24.07 rows=9 width=4) (actual time=0.043..0.089 rows=9 loops=1)

  • Output: timeoffapprovalnodes3_1.timeoffid
  • Inner Unique: true
  • Buffers: shared hit=40
36. 0.032 0.032 ↑ 1.0 9 1

Index Only Scan using uix2toaraidnid on assuredpartnersincdemo.timeoffapprovalrequest timeoffapprovalrequest4_1 (cost=0.28..8.43 rows=9 width=16) (actual time=0.020..0.032 rows=9 loops=1)

  • Output: timeoffapprovalrequest4_1.approverid, timeoffapprovalrequest4_1.nodeid
  • Index Cond: (timeoffapprovalrequest4_1.approverid = 6,186)
  • Heap Fetches: 9
  • Buffers: shared hit=13
37. 0.045 0.045 ↑ 1.0 1 9

Index Scan using timeoffapprovalnodes_pkey on assuredpartnersincdemo.timeoffapprovalnodes timeoffapprovalnodes3_1 (cost=0.28..1.74 rows=1 width=20) (actual time=0.005..0.005 rows=1 loops=9)

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

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

  • Index Cond: (timeoffapprovalhistory5.timeoffid = timeoffs1.id)
  • Filter: ((timeoffapprovalhistory5.userid = 6,186) AND (timeoffapprovalhistory5.action = ANY ('{2,3,4}'::integer[])))
39. 0.536 0.536 ↓ 1.2 529 1

Index Scan using ixtoahuserid on assuredpartnersincdemo.timeoffapprovalhistory timeoffapprovalhistory5_1 (cost=0.42..803.37 rows=424 width=4) (actual time=0.042..0.536 rows=529 loops=1)

  • Output: timeoffapprovalhistory5_1.timeoffid
  • Index Cond: (timeoffapprovalhistory5_1.userid = 6,186)
  • Filter: (timeoffapprovalhistory5_1.action = ANY ('{2,3,4}'::integer[]))
  • Rows Removed by Filter: 354
  • Buffers: shared hit=19
40. 0.108 0.565 ↑ 4.9 169 1

Nested Loop (cost=0.71..523.61 rows=829 width=4) (actual time=0.045..0.565 rows=169 loops=1)

  • Output: timeoffs6.id
  • Buffers: shared hit=552
41. 0.020 0.136 ↑ 2.5 107 1

Nested Loop (cost=0.29..146.27 rows=267 width=12) (actual time=0.029..0.136 rows=107 loops=1)

  • Output: usercostcenter7.userid, usercostcenter7.startdate, usercostcenter7.enddate
  • Buffers: shared hit=69
42. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on assuredpartnersincdemo.costcenterflathierarchy costcenterflathierarchy8 (cost=0.00..1.49 rows=1 width=16) (actual time=0.004..0.006 rows=1 loops=1)

  • Output: costcenterflathierarchy8.parentid, costcenterflathierarchy8.childid, costcenterflathierarchy8.parentdepth
  • Filter: (costcenterflathierarchy8.parentid = 'badda568-ec7f-42e1-9cbb-56e53c1aeda7'::uuid)
  • Rows Removed by Filter: 40
  • Buffers: shared hit=1
43. 0.110 0.110 ↑ 3.0 107 1

Index Scan using ixucccostcenterid on assuredpartnersincdemo.usercostcenter usercostcenter7 (cost=0.29..141.52 rows=326 width=28) (actual time=0.022..0.110 rows=107 loops=1)

  • Output: usercostcenter7.id, usercostcenter7.userid, usercostcenter7.costcenterid, usercostcenter7.startdate, usercostcenter7.enddate
  • Index Cond: (usercostcenter7.costcenterid = costcenterflathierarchy8.childid)
  • Buffers: shared hit=68
44. 0.321 0.321 ↑ 2.0 2 107

Index Scan using ixto4userid on assuredpartnersincdemo.timeoffs timeoffs6 (cost=0.42..1.37 rows=4 width=16) (actual time=0.003..0.003 rows=2 loops=107)

  • Output: timeoffs6.id, timeoffs6.guidid, timeoffs6.userid, timeoffs6.createdbyuserid, timeoffs6.timeoffcodeid, timeoffs6.startdate, timeoffs6.enddate, timeoffs6.approvalstatus, timeoffs6.comments, timeoffs6.submittedonutc, timeoffs6.modifiedonutc, timeoffs6.info1, timeoffs6.info2, timeoffs6.info3, timeoffs6.info4, timeoffs6.info5, timeoffs6.startdurationtype, timeoffs6.enddurationtype, timeoffs6.startduration, timeoffs6.endduration, timeoffs6.startdatestarttime, timeoffs6.enddateendtime, timeoffs6.entryconfigurationmethod
  • Index Cond: ((timeoffs6.userid = usercostcenter7.userid) AND (usercostcenter7.enddate >= timeoffs6.startdate) AND (usercostcenter7.startdate <= timeoffs6.enddate))
  • Buffers: shared hit=483
45. 0.000 2,291.051 ↓ 0.0 0 327,293

Nested Loop (cost=1.54..40.23 rows=1 width=32) (actual time=0.007..0.007 rows=0 loops=327,293)

  • Output: upper(tsapprovalrequestkeyvalue11.uri)
  • Inner Unique: true
  • Buffers: shared hit=1,641,932
46. 0.000 2,291.051 ↓ 0.0 0 327,293

Nested Loop (cost=1.26..36.11 rows=12 width=84) (actual time=0.007..0.007 rows=0 loops=327,293)

  • Output: tsapprovalrequestkeyvalue11.uri, tsapprovalrequestkeyvalue11.parentid
  • Buffers: shared hit=1,641,932
47. 319.847 2,291.051 ↓ 0.0 0 327,293

Nested Loop (cost=0.97..28.33 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=327,293)

  • Output: tsapprovalrequest14.id
  • Inner Unique: true
  • Buffers: shared hit=1,641,932
48. 0.000 1,963.758 ↓ 0.0 0 327,293

Nested Loop (cost=0.70..28.03 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=327,293)

  • Output: timesheetapprovalnodes13.id
  • Buffers: shared hit=1,635,715
49. 1,636.465 1,636.465 ↑ 7.0 1 327,293

Index Scan using ixtsuseridstartdateenddate on assuredpartnersincdemo.timesheet timesheet12 (cost=0.42..7.73 rows=7 width=16) (actual time=0.004..0.005 rows=1 loops=327,293)

  • Output: timesheet12.id, timesheet12.userid, timesheet12.startdate, timesheet12.enddate, timesheet12.approvalstatus, timesheet12.duedate, timesheet12.autosubmitdatetimeutc, timesheet12.lastautosubmitattemptdatetimeutc, timesheet12.createdonutc
  • Index Cond: ((timesheet12.userid = timeoffs1.userid) AND (timeoffs1.enddate >= timesheet12.startdate) AND (timeoffs1.startdate <= timesheet12.enddate))
  • Buffers: shared hit=1,278,020
50. 354.164 354.164 ↓ 0.0 0 177,082

Index Scan using ixtantimesheetid on assuredpartnersincdemo.timesheetapprovalnodes timesheetapprovalnodes13 (cost=0.28..2.88 rows=2 width=32) (actual time=0.002..0.002 rows=0 loops=177,082)

  • Output: timesheetapprovalnodes13.id, timesheetapprovalnodes13.timesheetid, timesheetapprovalnodes13.approverrole, timesheetapprovalnodes13.userid, timesheetapprovalnodes13.isapproved, timesheetapprovalnodes13.systemprocessidentifier, timesheetapprovalnodes13.scriptid, timesheetapprovalnodes13.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes13.timesheetid = timesheet12.id)
  • Buffers: shared hit=357,695
51. 7.446 7.446 ↓ 0.0 0 2,482

Index Scan using ixtarnodeid on assuredpartnersincdemo.tsapprovalrequest tsapprovalrequest14 (cost=0.28..0.31 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=2,482)

  • Output: tsapprovalrequest14.id, tsapprovalrequest14.effectivedateutc, tsapprovalrequest14.userid, tsapprovalrequest14.nodeid, tsapprovalrequest14.remindersentutc, tsapprovalrequest14.overduesentutc, tsapprovalrequest14.waitingbatchsentutc, tsapprovalrequest14.approvalagenttype, tsapprovalrequest14.systemprocessidentifier
  • Index Cond: (tsapprovalrequest14.nodeid = timesheetapprovalnodes13.id)
  • Filter: (tsapprovalrequest14.userid = 6,186)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=6,217
52. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue11 (cost=0.29..7.66 rows=12 width=88) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue15 (cost=0.29..0.34 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue15.id, tsapprovalrequestkeyvalue15.tsapprovalrequestid, tsapprovalrequestkeyvalue15.parentid, tsapprovalrequestkeyvalue15.index, tsapprovalrequestkeyvalue15.key, tsapprovalrequestkeyvalue15.uri, tsapprovalrequestkeyvalue15.slug, tsapprovalrequestkeyvalue15."boolean", tsapprovalrequestkeyvalue15.date, tsapprovalrequestkeyvalue15.number, tsapprovalrequestkeyvalue15.text, tsapprovalrequestkeyvalue15."time", tsapprovalrequestkeyvalue15.timespan, tsapprovalrequestkeyvalue15.daterange_startdate, tsapprovalrequestkeyvalue15.daterange_enddate, tsapprovalrequestkeyvalue15.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue15.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue15.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue15.workdayduration_workdays, tsapprovalrequestkeyvalue15.workdayduration_hours, tsapprovalrequestkeyvalue15.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue15.id = tsapprovalrequestkeyvalue11.parentid)
  • Filter: (tsapprovalrequestkeyvalue15.parentid IS NULL)
54. 326.923 2,945.637 ↓ 0.0 0 327,293

Nested Loop (cost=4.14..77.60 rows=1 width=32) (actual time=0.009..0.009 rows=0 loops=327,293)

  • Output: upper(sheetapprovalhistorykeyvalue16.uri)
  • Buffers: shared hit=2,200,236
55. 0.000 2,618.344 ↓ 0.0 0 327,293

Nested Loop (cost=3.71..77.02 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=327,293)

  • Output: sheetapprovalhistorykeyvalue24.id
  • Buffers: shared hit=2,199,928
56. 0.000 2,618.344 ↓ 0.0 0 327,293

Nested Loop (cost=3.27..75.09 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=327,293)

  • Output: sheetapprovalhistorykeyvalue23.id
  • Buffers: shared hit=2,199,632
57. 0.000 2,618.344 ↓ 0.0 0 327,293

Nested Loop (cost=2.83..74.52 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=327,293)

  • Output: sheetapprovalhistorykeyvalue22.id
  • Buffers: shared hit=2,199,336
58. 0.000 2,618.344 ↓ 0.0 0 327,293

Nested Loop (cost=2.40..73.20 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=327,293)

  • Output: sheetapprovalhistorykeyvalue21.id
  • Buffers: shared hit=2,199,040
59. 326.701 2,618.344 ↓ 0.0 0 327,293

Nested Loop (cost=1.97..71.09 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=327,293)

  • Output: sheetapprovalhistorykeyvalue20.parentid
  • Inner Unique: true
  • Buffers: shared hit=2,198,730
60. 0.000 2,291.051 ↓ 0.0 0 327,293

Nested Loop (cost=1.41..68.57 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=327,293)

  • Output: sheetapprovalhistorykeyvalue19.parentid
  • Buffers: shared hit=2,198,360
61. 423.762 2,291.051 ↓ 0.0 0 327,293

Nested Loop (cost=0.84..39.20 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=327,293)

  • Output: timesheetapprovalhistory18.id
  • Buffers: shared hit=2,197,670
62. 981.879 981.879 ↑ 7.0 1 327,293

Index Scan using ixtsuseridstartdateenddate on assuredpartnersincdemo.timesheet timesheet17 (cost=0.42..7.73 rows=7 width=16) (actual time=0.003..0.003 rows=1 loops=327,293)

  • Output: timesheet17.id, timesheet17.userid, timesheet17.startdate, timesheet17.enddate, timesheet17.approvalstatus, timesheet17.duedate, timesheet17.autosubmitdatetimeutc, timesheet17.lastautosubmitattemptdatetimeutc, timesheet17.createdonutc
  • Index Cond: ((timesheet17.userid = timeoffs1.userid) AND (timeoffs1.enddate >= timesheet17.startdate) AND (timeoffs1.startdate <= timesheet17.enddate))
  • Buffers: shared hit=1,278,020
63. 885.410 885.410 ↓ 0.0 0 177,082

Index Scan using ixtah2timesheetid on assuredpartnersincdemo.timesheetapprovalhistory timesheetapprovalhistory18 (cost=0.42..4.48 rows=1 width=32) (actual time=0.005..0.005 rows=0 loops=177,082)

  • Output: timesheetapprovalhistory18.id, timesheetapprovalhistory18.timesheetid, timesheetapprovalhistory18.action, timesheetapprovalhistory18.approvalcomments, timesheetapprovalhistory18.timestamputc, timesheetapprovalhistory18.serialnumber, timesheetapprovalhistory18.approvalagenttype, timesheetapprovalhistory18.userid, timesheetapprovalhistory18.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory18.timesheetid = timesheet17.id)
  • Filter: (timesheetapprovalhistory18.userid = 6,186)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=919,650
64. 5.733 5.733 ↑ 1.0 1 117

Index Scan using ixtahkvtimesheetapprovalhistoryid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue19 (cost=0.56..29.36 rows=1 width=32) (actual time=0.049..0.049 rows=1 loops=117)

  • Output: sheetapprovalhistorykeyvalue19.id, sheetapprovalhistorykeyvalue19.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue19.parentid, sheetapprovalhistorykeyvalue19.index, sheetapprovalhistorykeyvalue19.key, sheetapprovalhistorykeyvalue19.uri, sheetapprovalhistorykeyvalue19.slug, sheetapprovalhistorykeyvalue19."boolean", sheetapprovalhistorykeyvalue19.date, sheetapprovalhistorykeyvalue19.number, sheetapprovalhistorykeyvalue19.text, sheetapprovalhistorykeyvalue19."time", sheetapprovalhistorykeyvalue19.timespan, sheetapprovalhistorykeyvalue19.daterange_startdate, sheetapprovalhistorykeyvalue19.daterange_enddate, sheetapprovalhistorykeyvalue19.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue19.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue19.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue19.workdayduration_workdays, sheetapprovalhistorykeyvalue19.workdayduration_hours, sheetapprovalhistorykeyvalue19.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue19.timesheetapprovalhistoryid = timesheetapprovalhistory18.id)
  • Filter: ((upper(sheetapprovalhistorykeyvalue19.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(sheetapprovalhistorykeyvalue19.uri) = 'URN:REPLICON-TENANT:ASSURED-PARTNERS-INCDEMO:USER:6,186'::text))
  • Rows Removed by Filter: 17
  • Buffers: shared hit=690
65. 0.592 0.592 ↑ 1.0 1 74

Index Scan using timesheetapprovalhistorykeyvalue_pkey on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue20 (cost=0.56..2.52 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=74)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue21 (cost=0.43..2.10 rows=1 width=32) (actual time=0.010..0.010 rows=1 loops=74)

  • Output: sheetapprovalhistorykeyvalue21.id, sheetapprovalhistorykeyvalue21.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue21.parentid, sheetapprovalhistorykeyvalue21.index, sheetapprovalhistorykeyvalue21.key, sheetapprovalhistorykeyvalue21.uri, sheetapprovalhistorykeyvalue21.slug, sheetapprovalhistorykeyvalue21."boolean", sheetapprovalhistorykeyvalue21.date, sheetapprovalhistorykeyvalue21.number, sheetapprovalhistorykeyvalue21.text, sheetapprovalhistorykeyvalue21."time", sheetapprovalhistorykeyvalue21.timespan, sheetapprovalhistorykeyvalue21.daterange_startdate, sheetapprovalhistorykeyvalue21.daterange_enddate, sheetapprovalhistorykeyvalue21.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue21.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue21.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue21.workdayduration_workdays, sheetapprovalhistorykeyvalue21.workdayduration_hours, sheetapprovalhistorykeyvalue21.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue21.parentid = sheetapprovalhistorykeyvalue20.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue21.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=310
67. 0.296 0.296 ↑ 4.0 1 74

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue22 (cost=0.43..1.28 rows=4 width=32) (actual time=0.004..0.004 rows=1 loops=74)

  • Output: sheetapprovalhistorykeyvalue22.id, sheetapprovalhistorykeyvalue22.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue22.parentid, sheetapprovalhistorykeyvalue22.index, sheetapprovalhistorykeyvalue22.key, sheetapprovalhistorykeyvalue22.uri, sheetapprovalhistorykeyvalue22.slug, sheetapprovalhistorykeyvalue22."boolean", sheetapprovalhistorykeyvalue22.date, sheetapprovalhistorykeyvalue22.number, sheetapprovalhistorykeyvalue22.text, sheetapprovalhistorykeyvalue22."time", sheetapprovalhistorykeyvalue22.timespan, sheetapprovalhistorykeyvalue22.daterange_startdate, sheetapprovalhistorykeyvalue22.daterange_enddate, sheetapprovalhistorykeyvalue22.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue22.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue22.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue22.workdayduration_workdays, sheetapprovalhistorykeyvalue22.workdayduration_hours, sheetapprovalhistorykeyvalue22.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue22.parentid = sheetapprovalhistorykeyvalue21.id)
  • Buffers: shared hit=296
68. 0.444 0.444 ↑ 1.0 1 74

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue23 (cost=0.43..0.56 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=74)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue24 (cost=0.43..1.90 rows=4 width=32) (actual time=0.004..0.004 rows=1 loops=74)

  • Output: sheetapprovalhistorykeyvalue24.id, sheetapprovalhistorykeyvalue24.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue24.parentid, sheetapprovalhistorykeyvalue24.index, sheetapprovalhistorykeyvalue24.key, sheetapprovalhistorykeyvalue24.uri, sheetapprovalhistorykeyvalue24.slug, sheetapprovalhistorykeyvalue24."boolean", sheetapprovalhistorykeyvalue24.date, sheetapprovalhistorykeyvalue24.number, sheetapprovalhistorykeyvalue24.text, sheetapprovalhistorykeyvalue24."time", sheetapprovalhistorykeyvalue24.timespan, sheetapprovalhistorykeyvalue24.daterange_startdate, sheetapprovalhistorykeyvalue24.daterange_enddate, sheetapprovalhistorykeyvalue24.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue24.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue24.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue24.workdayduration_workdays, sheetapprovalhistorykeyvalue24.workdayduration_hours, sheetapprovalhistorykeyvalue24.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue24.parentid = sheetapprovalhistorykeyvalue23.id)
  • Buffers: shared hit=296
70. 0.370 0.370 ↓ 1.8 7 74

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue16 (cost=0.43..0.54 rows=4 width=87) (actual time=0.004..0.005 rows=7 loops=74)

  • Output: sheetapprovalhistorykeyvalue16.id, sheetapprovalhistorykeyvalue16.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue16.parentid, sheetapprovalhistorykeyvalue16.index, sheetapprovalhistorykeyvalue16.key, sheetapprovalhistorykeyvalue16.uri, sheetapprovalhistorykeyvalue16.slug, sheetapprovalhistorykeyvalue16."boolean", sheetapprovalhistorykeyvalue16.date, sheetapprovalhistorykeyvalue16.number, sheetapprovalhistorykeyvalue16.text, sheetapprovalhistorykeyvalue16."time", sheetapprovalhistorykeyvalue16.timespan, sheetapprovalhistorykeyvalue16.daterange_startdate, sheetapprovalhistorykeyvalue16.daterange_enddate, sheetapprovalhistorykeyvalue16.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue16.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue16.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue16.workdayduration_workdays, sheetapprovalhistorykeyvalue16.workdayduration_hours, sheetapprovalhistorykeyvalue16.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue16.parentid = sheetapprovalhistorykeyvalue24.id)
  • Buffers: shared hit=308
71. 0.000 13,743.198 ↓ 0.0 0 327,219

Nested Loop (cost=1.67..10.03 rows=1 width=32) (actual time=0.042..0.042 rows=0 loops=327,219)

  • Output: upper(tsapprovalrequestkeyvalue25.uri)
  • Inner Unique: true
  • Buffers: shared hit=981,657
72. 0.000 13,743.198 ↓ 0.0 0 327,219

Nested Loop (cost=1.38..7.72 rows=1 width=84) (actual time=0.042..0.042 rows=0 loops=327,219)

  • Output: tsapprovalrequestkeyvalue25.uri, tsapprovalrequestkeyvalue25.parentid
  • Inner Unique: true
  • Buffers: shared hit=981,657
73. 327.219 13,743.198 ↓ 0.0 0 327,219

Nested Loop (cost=0.96..5.35 rows=1 width=100) (actual time=0.042..0.042 rows=0 loops=327,219)

  • Output: timesheetapprovalnodes27.timesheetid, tsapprovalrequestkeyvalue25.uri, tsapprovalrequestkeyvalue25.parentid
  • Inner Unique: true
  • Buffers: shared hit=981,657
74. 0.000 13,415.979 ↓ 0.0 0 327,219

Nested Loop (cost=0.69..3.88 rows=1 width=100) (actual time=0.041..0.041 rows=0 loops=327,219)

  • Output: tsapprovalrequest28.nodeid, tsapprovalrequestkeyvalue25.uri, tsapprovalrequestkeyvalue25.parentid
  • Inner Unique: true
  • Buffers: shared hit=981,657
75. 13,415.979 13,415.979 ↓ 0.0 0 327,219

Index Scan using ixtsarkvkey on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue25 (cost=0.41..1.43 rows=1 width=88) (actual time=0.041..0.041 rows=0 loops=327,219)

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

Index Scan using tsapprovalrequest_pkey on assuredpartnersincdemo.tsapprovalrequest tsapprovalrequest28 (cost=0.28..2.29 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest28.id, tsapprovalrequest28.effectivedateutc, tsapprovalrequest28.userid, tsapprovalrequest28.nodeid, tsapprovalrequest28.remindersentutc, tsapprovalrequest28.overduesentutc, tsapprovalrequest28.waitingbatchsentutc, tsapprovalrequest28.approvalagenttype, tsapprovalrequest28.systemprocessidentifier
  • Index Cond: (tsapprovalrequest28.id = tsapprovalrequestkeyvalue25.tsapprovalrequestid)
  • Filter: (tsapprovalrequest28.userid = 6,186)
77. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on assuredpartnersincdemo.timesheetapprovalnodes timesheetapprovalnodes27 (cost=0.28..1.46 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes27.id, timesheetapprovalnodes27.timesheetid, timesheetapprovalnodes27.approverrole, timesheetapprovalnodes27.userid, timesheetapprovalnodes27.isapproved, timesheetapprovalnodes27.systemprocessidentifier, timesheetapprovalnodes27.scriptid, timesheetapprovalnodes27.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes27.id = tsapprovalrequest28.nodeid)
78. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on assuredpartnersincdemo.timesheet timesheet26 (cost=0.42..1.98 rows=1 width=16) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue29 (cost=0.29..2.30 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue29.id, tsapprovalrequestkeyvalue29.tsapprovalrequestid, tsapprovalrequestkeyvalue29.parentid, tsapprovalrequestkeyvalue29.index, tsapprovalrequestkeyvalue29.key, tsapprovalrequestkeyvalue29.uri, tsapprovalrequestkeyvalue29.slug, tsapprovalrequestkeyvalue29."boolean", tsapprovalrequestkeyvalue29.date, tsapprovalrequestkeyvalue29.number, tsapprovalrequestkeyvalue29.text, tsapprovalrequestkeyvalue29."time", tsapprovalrequestkeyvalue29.timespan, tsapprovalrequestkeyvalue29.daterange_startdate, tsapprovalrequestkeyvalue29.daterange_enddate, tsapprovalrequestkeyvalue29.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue29.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue29.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue29.workdayduration_workdays, tsapprovalrequestkeyvalue29.workdayduration_hours, tsapprovalrequestkeyvalue29.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue29.id = tsapprovalrequestkeyvalue25.parentid)
  • Filter: (tsapprovalrequestkeyvalue29.parentid IS NULL)
80. 0.000 2,617.752 ↓ 0.0 0 327,219

Nested Loop (cost=4.14..81.20 rows=1 width=32) (actual time=0.008..0.008 rows=0 loops=327,219)

  • Output: upper(sheetapprovalhistorykeyvalue30.uri)
  • Buffers: shared hit=2,197,272
81. 0.000 2,617.752 ↓ 0.0 0 327,219

Nested Loop (cost=3.71..80.62 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=327,219)

  • Output: sheetapprovalhistorykeyvalue38.id
  • Buffers: shared hit=2,197,272
82. 327.219 2,617.752 ↓ 0.0 0 327,219

Nested Loop (cost=3.27..75.09 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=327,219)

  • Output: sheetapprovalhistorykeyvalue37.id
  • Buffers: shared hit=2,197,272
83. 0.000 2,290.533 ↓ 0.0 0 327,219

Nested Loop (cost=2.83..74.52 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=327,219)

  • Output: sheetapprovalhistorykeyvalue36.id
  • Buffers: shared hit=2,197,272
84. 0.000 2,290.533 ↓ 0.0 0 327,219

Nested Loop (cost=2.40..73.20 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=327,219)

  • Output: sheetapprovalhistorykeyvalue35.id
  • Buffers: shared hit=2,197,272
85. 0.000 2,290.533 ↓ 0.0 0 327,219

Nested Loop (cost=1.97..71.09 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=327,219)

  • Output: sheetapprovalhistorykeyvalue34.parentid
  • Inner Unique: true
  • Buffers: shared hit=2,197,272
86. 0.000 2,290.533 ↓ 0.0 0 327,219

Nested Loop (cost=1.41..68.57 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=327,219)

  • Output: sheetapprovalhistorykeyvalue33.parentid
  • Buffers: shared hit=2,197,272
87. 450.633 2,290.533 ↓ 0.0 0 327,219

Nested Loop (cost=0.84..39.20 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=327,219)

  • Output: timesheetapprovalhistory32.id
  • Buffers: shared hit=2,197,018
88. 1,308.876 1,308.876 ↑ 7.0 1 327,219

Index Scan using ixtsuseridstartdateenddate on assuredpartnersincdemo.timesheet timesheet31 (cost=0.42..7.73 rows=7 width=16) (actual time=0.004..0.004 rows=1 loops=327,219)

  • Output: timesheet31.id, timesheet31.userid, timesheet31.startdate, timesheet31.enddate, timesheet31.approvalstatus, timesheet31.duedate, timesheet31.autosubmitdatetimeutc, timesheet31.lastautosubmitattemptdatetimeutc, timesheet31.createdonutc
  • Index Cond: ((timesheet31.userid = timeoffs1.userid) AND (timeoffs1.enddate >= timesheet31.startdate) AND (timeoffs1.startdate <= timesheet31.enddate))
  • Buffers: shared hit=1,277,672
89. 531.024 531.024 ↓ 0.0 0 177,008

Index Scan using ixtah2timesheetid on assuredpartnersincdemo.timesheetapprovalhistory timesheetapprovalhistory32 (cost=0.42..4.48 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=177,008)

  • Output: timesheetapprovalhistory32.id, timesheetapprovalhistory32.timesheetid, timesheetapprovalhistory32.action, timesheetapprovalhistory32.approvalcomments, timesheetapprovalhistory32.timestamputc, timesheetapprovalhistory32.serialnumber, timesheetapprovalhistory32.approvalagenttype, timesheetapprovalhistory32.userid, timesheetapprovalhistory32.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory32.timesheetid = timesheet31.id)
  • Filter: (timesheetapprovalhistory32.userid = 6,186)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=919,346
90. 1.935 1.935 ↓ 0.0 0 43

Index Scan using ixtahkvtimesheetapprovalhistoryid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue33 (cost=0.56..29.36 rows=1 width=32) (actual time=0.045..0.045 rows=0 loops=43)

  • Output: sheetapprovalhistorykeyvalue33.id, sheetapprovalhistorykeyvalue33.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue33.parentid, sheetapprovalhistorykeyvalue33.index, sheetapprovalhistorykeyvalue33.key, sheetapprovalhistorykeyvalue33.uri, sheetapprovalhistorykeyvalue33.slug, sheetapprovalhistorykeyvalue33."boolean", sheetapprovalhistorykeyvalue33.date, sheetapprovalhistorykeyvalue33.number, sheetapprovalhistorykeyvalue33.text, sheetapprovalhistorykeyvalue33."time", sheetapprovalhistorykeyvalue33.timespan, sheetapprovalhistorykeyvalue33.daterange_startdate, sheetapprovalhistorykeyvalue33.daterange_enddate, sheetapprovalhistorykeyvalue33.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue33.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue33.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue33.workdayduration_workdays, sheetapprovalhistorykeyvalue33.workdayduration_hours, sheetapprovalhistorykeyvalue33.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue33.timesheetapprovalhistoryid = timesheetapprovalhistory32.id)
  • Filter: ((upper(sheetapprovalhistorykeyvalue33.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(sheetapprovalhistorykeyvalue33.uri) = 'URN:REPLICON-TENANT:ASSURED-PARTNERS-INCDEMO:USER:6,186'::text))
  • Rows Removed by Filter: 19
  • Buffers: shared hit=254
91. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue34 (cost=0.56..2.52 rows=1 width=32) (never executed)

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

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

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue36 (cost=0.43..1.28 rows=4 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue37 (cost=0.43..0.56 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue38 (cost=0.43..5.50 rows=4 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue30 (cost=0.43..0.54 rows=4 width=87) (never executed)

  • Output: sheetapprovalhistorykeyvalue30.id, sheetapprovalhistorykeyvalue30.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue30.parentid, sheetapprovalhistorykeyvalue30.index, sheetapprovalhistorykeyvalue30.key, sheetapprovalhistorykeyvalue30.uri, sheetapprovalhistorykeyvalue30.slug, sheetapprovalhistorykeyvalue30."boolean", sheetapprovalhistorykeyvalue30.date, sheetapprovalhistorykeyvalue30.number, sheetapprovalhistorykeyvalue30.text, sheetapprovalhistorykeyvalue30."time", sheetapprovalhistorykeyvalue30.timespan, sheetapprovalhistorykeyvalue30.daterange_startdate, sheetapprovalhistorykeyvalue30.daterange_enddate, sheetapprovalhistorykeyvalue30.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue30.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue30.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue30.workdayduration_workdays, sheetapprovalhistorykeyvalue30.workdayduration_hours, sheetapprovalhistorykeyvalue30.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue30.parentid = sheetapprovalhistorykeyvalue38.id)
97. 0.003 36.368 ↑ 1.0 1 1

Aggregate (cost=79,278.41..79,278.42 rows=1 width=8) (actual time=36.368..36.368 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=14,551
98.          

Initplan (for Aggregate)

99. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..10.56 rows=1 width=0) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Index Only Scan using userpolicyset_pkey on assuredpartnersincdemo.userpolicyset userpolicyset52 (cost=0.29..2.30 rows=1 width=16) (never executed)

  • Output: userpolicyset52.userid, userpolicyset52.policysetid
  • Index Cond: (userpolicyset52.userid = 6,186)
  • Heap Fetches: 0
101. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpskvpolicysetid on assuredpartnersincdemo.policysetkeyvalue policysetkeyvalue53 (cost=0.27..8.24 rows=1 width=16) (never executed)

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

Nested Loop Semi Join (cost=1,527.92..79,267.72 rows=53 width=0) (actual time=36.365..36.365 rows=0 loops=1)

  • Join Filter: ("*SELECT* 1_2".timeoffid = timeoffs44.id)
  • Buffers: shared hit=14,551
103. 0.054 36.364 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1,001.53..13,952.20 rows=106 width=12) (actual time=36.364..36.364 rows=0 loops=1)

  • Output: "*SELECT* 1_2".timeoffid, timeoffs82.id, timeoffs83.id
  • Buffers: shared hit=14,551
104. 0.051 32.683 ↓ 1.3 279 1

Append (cost=1,000.27..13,441.30 rows=213 width=4) (actual time=6.209..32.683 rows=279 loops=1)

  • Buffers: shared hit=11,600
105. 0.061 32.544 ↓ 1.3 279 1

Subquery Scan on *SELECT* 1_2 (cost=1,000.27..13,384.24 rows=212 width=4) (actual time=6.208..32.544 rows=279 loops=1)

  • Output: "*SELECT* 1_2".timeoffid
  • Buffers: shared hit=11,544
106. 0.119 32.483 ↓ 1.3 279 1

Nested Loop Anti Join (cost=1,000.27..13,382.12 rows=212 width=1,553) (actual time=6.207..32.483 rows=279 loops=1)

  • Output: dm_timeofflist_facts_2.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Buffers: shared hit=11,544
107. 11.837 31.806 ↓ 1.3 279 1

Gather (cost=1,000.00..13,288.53 rows=212 width=4) (actual time=6.187..31.806 rows=279 loops=1)

  • Output: dm_timeofflist_facts_2.timeoffid
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=10,986
108. 19.969 19.969 ↓ 1.1 93 3 / 3

Parallel Seq Scan on assuredpartnersincdemo.dm_timeofflist_facts dm_timeofflist_facts_2 (cost=0.00..12,267.33 rows=88 width=4) (actual time=0.662..19.969 rows=93 loops=3)

  • Output: dm_timeofflist_facts_2.timeoffid
  • Filter: ((dm_timeofflist_facts_2.timeoffcodeid <> 69) AND (dm_timeofflist_facts_2.timeoffstatus = 3))
  • Rows Removed by Filter: 68,313
  • Buffers: shared hit=10,986
  • Worker 0: actual time=0.096..14.411 rows=46 loops=1
  • Buffers: shared hit=3,034
  • Worker 1: actual time=0.309..18.785 rows=107 loops=1
  • Buffers: shared hit=3,848
109. 0.558 0.558 ↓ 0.0 0 279

Index Only Scan using dm_timeofflist_realtime_facts_pkey on assuredpartnersincdemo.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_4 (cost=0.27..0.44 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=279)

  • 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=558
110. 0.001 0.088 ↓ 0.0 0 1

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

  • Output: "*SELECT* 2_2".timeoffid
  • Buffers: shared hit=56
111. 0.087 0.087 ↓ 0.0 0 1

Seq Scan on assuredpartnersincdemo.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_5 (cost=0.00..57.05 rows=1 width=1,553) (actual time=0.087..0.087 rows=0 loops=1)

  • Output: dm_timeofflist_realtime_facts_5.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Filter: ((NOT dm_timeofflist_realtime_facts_5.deleted) AND (dm_timeofflist_realtime_facts_5.timeoffcodeid <> 69) AND (dm_timeofflist_realtime_facts_5.timeoffstatus = 3))
  • Rows Removed by Filter: 70
  • Buffers: shared hit=56
112. 0.279 3.627 ↓ 0.0 0 279

Nested Loop Semi Join (cost=1.27..2.39 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=279)

  • Output: timeoffs82.id, timeoffs83.id
  • Buffers: shared hit=2,951
113. 1.116 1.116 ↑ 1.0 1 279

Index Only Scan using timeoffs_pkey on assuredpartnersincdemo.timeoffs timeoffs82 (cost=0.42..1.42 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=279)

  • Output: timeoffs82.id
  • Index Cond: (timeoffs82.id = "*SELECT* 1_2".timeoffid)
  • Heap Fetches: 175
  • Buffers: shared hit=1,015
114. 0.150 2.232 ↓ 0.0 0 279

Nested Loop (cost=0.85..0.96 rows=1 width=4) (actual time=0.008..0.008 rows=0 loops=279)

  • Output: timeoffs83.id
  • Inner Unique: true
  • Buffers: shared hit=1,936
115. 0.558 1.953 ↓ 0.0 0 279

Nested Loop (cost=0.71..0.78 rows=1 width=20) (actual time=0.007..0.007 rows=0 loops=279)

  • Output: timeoffs83.id, usercostcenter84.costcenterid
  • Buffers: shared hit=1,807
116. 0.558 0.558 ↑ 1.0 1 279

Index Scan using timeoffs_pkey on assuredpartnersincdemo.timeoffs timeoffs83 (cost=0.42..0.46 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=279)

  • Output: timeoffs83.id, timeoffs83.guidid, timeoffs83.userid, timeoffs83.createdbyuserid, timeoffs83.timeoffcodeid, timeoffs83.startdate, timeoffs83.enddate, timeoffs83.approvalstatus, timeoffs83.comments, timeoffs83.submittedonutc, timeoffs83.modifiedonutc, timeoffs83.info1, timeoffs83.info2, timeoffs83.info3, timeoffs83.info4, timeoffs83.info5, timeoffs83.startdurationtype, timeoffs83.enddurationtype, timeoffs83.startduration, timeoffs83.endduration, timeoffs83.startdatestarttime, timeoffs83.enddateendtime, timeoffs83.entryconfigurationmethod
  • Index Cond: (timeoffs83.id = timeoffs82.id)
  • Buffers: shared hit=1,118
117. 0.837 0.837 ↓ 0.0 0 279

Index Only Scan using ix4ucc_usercostcenterstartend on assuredpartnersincdemo.usercostcenter usercostcenter84 (cost=0.29..0.31 rows=1 width=28) (actual time=0.003..0.003 rows=0 loops=279)

  • Output: usercostcenter84.userid, usercostcenter84.costcenterid, usercostcenter84.startdate, usercostcenter84.enddate
  • Index Cond: ((usercostcenter84.userid = timeoffs83.userid) AND (usercostcenter84.startdate <= timeoffs83.enddate) AND (usercostcenter84.enddate >= timeoffs83.startdate))
  • Heap Fetches: 118
  • Buffers: shared hit=689
118. 0.129 0.129 ↓ 0.0 0 129

Index Only Scan using costcenterflathierarchy_pkey on assuredpartnersincdemo.costcenterflathierarchy costcenterflathierarchy85 (cost=0.14..0.16 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=129)

  • Output: costcenterflathierarchy85.parentid, costcenterflathierarchy85.childid
  • Index Cond: ((costcenterflathierarchy85.parentid = 'badda568-ec7f-42e1-9cbb-56e53c1aeda7'::uuid) AND (costcenterflathierarchy85.childid = usercostcenter84.costcenterid))
  • Heap Fetches: 0
  • Buffers: shared hit=129
119. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=526.38..645.17 rows=1 width=4) (never executed)

  • Output: timeoffs44.id
  • Filter: (((userhierarchy45.supervisorid = 6,186) AND ((userhierarchy45.startdate IS NULL) OR (userhierarchy45.startdate <= '2020-07-01'::date)) AND ((userhierarchy45.enddate IS NULL) OR (userhierarchy45.enddate >= '2020-07-01'::date))) OR (timeoffs44.userid = 6,186) OR (alternatives: SubPlan 12 or hashed SubPlan 13) OR (alternatives: SubPlan 14 or hashed SubPlan 15) OR (hashed SubPlan 16) OR $72 OR (SubPlan 18) OR (SubPlan 19) OR (SubPlan 20) OR (SubPlan 21))
120. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using ix3uh_usersuperstart on assuredpartnersincdemo.userhierarchy userhierarchy45 (cost=0.29..0.30 rows=1 width=24) (never executed)

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

SubPlan (for Nested Loop Left Join)

123. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Output: timeoffapprovalrequest47.approverid, timeoffapprovalrequest47.nodeid
  • Index Cond: ((timeoffapprovalrequest47.approverid = 6,186) AND (timeoffapprovalrequest47.nodeid = timeoffapprovalnodes46.id))
  • Heap Fetches: 0
126. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..24.07 rows=9 width=4) (never executed)

  • Output: timeoffapprovalnodes46_1.timeoffid
  • Inner Unique: true
127. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix2toaraidnid on assuredpartnersincdemo.timeoffapprovalrequest timeoffapprovalrequest47_1 (cost=0.28..8.43 rows=9 width=16) (never executed)

  • Output: timeoffapprovalrequest47_1.approverid, timeoffapprovalrequest47_1.nodeid
  • Index Cond: (timeoffapprovalrequest47_1.approverid = 6,186)
  • Heap Fetches: 0
128. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalnodes_pkey on assuredpartnersincdemo.timeoffapprovalnodes timeoffapprovalnodes46_1 (cost=0.28..1.74 rows=1 width=20) (never executed)

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

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

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

Index Scan using ixtoahuserid on assuredpartnersincdemo.timeoffapprovalhistory timeoffapprovalhistory48_1 (cost=0.42..803.37 rows=424 width=4) (never executed)

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

Nested Loop (cost=0.71..523.61 rows=829 width=4) (never executed)

  • Output: timeoffs49.id
132. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..146.27 rows=267 width=12) (never executed)

  • Output: usercostcenter50.userid, usercostcenter50.startdate, usercostcenter50.enddate
133. 0.000 0.000 ↓ 0.0 0

Seq Scan on assuredpartnersincdemo.costcenterflathierarchy costcenterflathierarchy51 (cost=0.00..1.49 rows=1 width=16) (never executed)

  • Output: costcenterflathierarchy51.parentid, costcenterflathierarchy51.childid, costcenterflathierarchy51.parentdepth
  • Filter: (costcenterflathierarchy51.parentid = 'badda568-ec7f-42e1-9cbb-56e53c1aeda7'::uuid)
134. 0.000 0.000 ↓ 0.0 0

Index Scan using ixucccostcenterid on assuredpartnersincdemo.usercostcenter usercostcenter50 (cost=0.29..141.52 rows=326 width=28) (never executed)

  • Output: usercostcenter50.id, usercostcenter50.userid, usercostcenter50.costcenterid, usercostcenter50.startdate, usercostcenter50.enddate
  • Index Cond: (usercostcenter50.costcenterid = costcenterflathierarchy51.childid)
135. 0.000 0.000 ↓ 0.0 0

Index Scan using ixto4userid on assuredpartnersincdemo.timeoffs timeoffs49 (cost=0.42..1.37 rows=4 width=16) (never executed)

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

Nested Loop (cost=1.54..40.23 rows=1 width=32) (never executed)

  • Output: upper(tsapprovalrequestkeyvalue54.uri)
  • Inner Unique: true
137. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.26..36.11 rows=12 width=84) (never executed)

  • Output: tsapprovalrequestkeyvalue54.uri, tsapprovalrequestkeyvalue54.parentid
138. 0.000 0.000 ↓ 0.0 0

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

  • Output: tsapprovalrequest57.id
  • Inner Unique: true
139. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..28.03 rows=1 width=16) (never executed)

  • Output: timesheetapprovalnodes56.id
140. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on assuredpartnersincdemo.timesheet timesheet55 (cost=0.42..7.73 rows=7 width=16) (never executed)

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

Index Scan using ixtantimesheetid on assuredpartnersincdemo.timesheetapprovalnodes timesheetapprovalnodes56 (cost=0.28..2.88 rows=2 width=32) (never executed)

  • Output: timesheetapprovalnodes56.id, timesheetapprovalnodes56.timesheetid, timesheetapprovalnodes56.approverrole, timesheetapprovalnodes56.userid, timesheetapprovalnodes56.isapproved, timesheetapprovalnodes56.systemprocessidentifier, timesheetapprovalnodes56.scriptid, timesheetapprovalnodes56.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes56.timesheetid = timesheet55.id)
142. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtarnodeid on assuredpartnersincdemo.tsapprovalrequest tsapprovalrequest57 (cost=0.28..0.31 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest57.id, tsapprovalrequest57.effectivedateutc, tsapprovalrequest57.userid, tsapprovalrequest57.nodeid, tsapprovalrequest57.remindersentutc, tsapprovalrequest57.overduesentutc, tsapprovalrequest57.waitingbatchsentutc, tsapprovalrequest57.approvalagenttype, tsapprovalrequest57.systemprocessidentifier
  • Index Cond: (tsapprovalrequest57.nodeid = timesheetapprovalnodes56.id)
  • Filter: (tsapprovalrequest57.userid = 6,186)
143. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue54 (cost=0.29..7.66 rows=12 width=88) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue58 (cost=0.29..0.34 rows=1 width=16) (never executed)

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

Nested Loop (cost=4.14..77.60 rows=1 width=32) (never executed)

  • Output: upper(sheetapprovalhistorykeyvalue59.uri)
146. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.71..77.02 rows=1 width=16) (never executed)

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

Nested Loop (cost=3.27..75.09 rows=1 width=16) (never executed)

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

Nested Loop (cost=2.83..74.52 rows=1 width=16) (never executed)

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

Nested Loop (cost=2.40..73.20 rows=1 width=16) (never executed)

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

Nested Loop (cost=1.97..71.09 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue63.parentid
  • Inner Unique: true
151. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.41..68.57 rows=1 width=16) (never executed)

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

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

  • Output: timesheetapprovalhistory61.id
153. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on assuredpartnersincdemo.timesheet timesheet60 (cost=0.42..7.73 rows=7 width=16) (never executed)

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

Index Scan using ixtah2timesheetid on assuredpartnersincdemo.timesheetapprovalhistory timesheetapprovalhistory61 (cost=0.42..4.48 rows=1 width=32) (never executed)

  • Output: timesheetapprovalhistory61.id, timesheetapprovalhistory61.timesheetid, timesheetapprovalhistory61.action, timesheetapprovalhistory61.approvalcomments, timesheetapprovalhistory61.timestamputc, timesheetapprovalhistory61.serialnumber, timesheetapprovalhistory61.approvalagenttype, timesheetapprovalhistory61.userid, timesheetapprovalhistory61.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory61.timesheetid = timesheet60.id)
  • Filter: (timesheetapprovalhistory61.userid = 6,186)
155. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue62 (cost=0.56..29.36 rows=1 width=32) (never executed)

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

Index Scan using timesheetapprovalhistorykeyvalue_pkey on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue63 (cost=0.56..2.52 rows=1 width=32) (never executed)

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

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

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue65 (cost=0.43..1.28 rows=4 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue66 (cost=0.43..0.56 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue67 (cost=0.43..1.90 rows=4 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue59 (cost=0.43..0.54 rows=4 width=87) (never executed)

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

Nested Loop (cost=1.67..10.03 rows=1 width=32) (never executed)

  • Output: upper(tsapprovalrequestkeyvalue68.uri)
  • Inner Unique: true
163. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.38..7.72 rows=1 width=84) (never executed)

  • Output: tsapprovalrequestkeyvalue68.uri, tsapprovalrequestkeyvalue68.parentid
  • Inner Unique: true
164. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.96..5.35 rows=1 width=100) (never executed)

  • Output: timesheetapprovalnodes70.timesheetid, tsapprovalrequestkeyvalue68.uri, tsapprovalrequestkeyvalue68.parentid
  • Inner Unique: true
165. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.69..3.88 rows=1 width=100) (never executed)

  • Output: tsapprovalrequest71.nodeid, tsapprovalrequestkeyvalue68.uri, tsapprovalrequestkeyvalue68.parentid
  • Inner Unique: true
166. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvkey on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue68 (cost=0.41..1.43 rows=1 width=88) (never executed)

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

Index Scan using tsapprovalrequest_pkey on assuredpartnersincdemo.tsapprovalrequest tsapprovalrequest71 (cost=0.28..2.29 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest71.id, tsapprovalrequest71.effectivedateutc, tsapprovalrequest71.userid, tsapprovalrequest71.nodeid, tsapprovalrequest71.remindersentutc, tsapprovalrequest71.overduesentutc, tsapprovalrequest71.waitingbatchsentutc, tsapprovalrequest71.approvalagenttype, tsapprovalrequest71.systemprocessidentifier
  • Index Cond: (tsapprovalrequest71.id = tsapprovalrequestkeyvalue68.tsapprovalrequestid)
  • Filter: (tsapprovalrequest71.userid = 6,186)
168. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on assuredpartnersincdemo.timesheetapprovalnodes timesheetapprovalnodes70 (cost=0.28..1.46 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes70.id, timesheetapprovalnodes70.timesheetid, timesheetapprovalnodes70.approverrole, timesheetapprovalnodes70.userid, timesheetapprovalnodes70.isapproved, timesheetapprovalnodes70.systemprocessidentifier, timesheetapprovalnodes70.scriptid, timesheetapprovalnodes70.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes70.id = tsapprovalrequest71.nodeid)
169. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on assuredpartnersincdemo.timesheet timesheet69 (cost=0.42..1.98 rows=1 width=16) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue72 (cost=0.29..2.30 rows=1 width=16) (never executed)

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

Nested Loop (cost=4.14..81.20 rows=1 width=32) (never executed)

  • Output: upper(sheetapprovalhistorykeyvalue73.uri)
172. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.71..80.62 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue81.id
173. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.27..75.09 rows=1 width=16) (never executed)

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

Nested Loop (cost=2.83..74.52 rows=1 width=16) (never executed)

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

Nested Loop (cost=2.40..73.20 rows=1 width=16) (never executed)

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

Nested Loop (cost=1.97..71.09 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue77.parentid
  • Inner Unique: true
177. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.41..68.57 rows=1 width=16) (never executed)

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

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

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

Index Scan using ixtsuseridstartdateenddate on assuredpartnersincdemo.timesheet timesheet74 (cost=0.42..7.73 rows=7 width=16) (never executed)

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

Index Scan using ixtah2timesheetid on assuredpartnersincdemo.timesheetapprovalhistory timesheetapprovalhistory75 (cost=0.42..4.48 rows=1 width=32) (never executed)

  • Output: timesheetapprovalhistory75.id, timesheetapprovalhistory75.timesheetid, timesheetapprovalhistory75.action, timesheetapprovalhistory75.approvalcomments, timesheetapprovalhistory75.timestamputc, timesheetapprovalhistory75.serialnumber, timesheetapprovalhistory75.approvalagenttype, timesheetapprovalhistory75.userid, timesheetapprovalhistory75.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory75.timesheetid = timesheet74.id)
  • Filter: (timesheetapprovalhistory75.userid = 6,186)
181. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue76 (cost=0.56..29.36 rows=1 width=32) (never executed)

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

Index Scan using timesheetapprovalhistorykeyvalue_pkey on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue77 (cost=0.56..2.52 rows=1 width=32) (never executed)

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

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

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue79 (cost=0.43..1.28 rows=4 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue80 (cost=0.43..0.56 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue81 (cost=0.43..5.50 rows=4 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue73 (cost=0.43..0.54 rows=4 width=87) (never executed)

  • Output: sheetapprovalhistorykeyvalue73.id, sheetapprovalhistorykeyvalue73.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue73.parentid, sheetapprovalhistorykeyvalue73.index, sheetapprovalhistorykeyvalue73.key, sheetapprovalhistorykeyvalue73.uri, sheetapprovalhistorykeyvalue73.slug, sheetapprovalhistorykeyvalue73."boolean", sheetapprovalhistorykeyvalue73.date, sheetapprovalhistorykeyvalue73.number, sheetapprovalhistorykeyvalue73.text, sheetapprovalhistorykeyvalue73."time", sheetapprovalhistorykeyvalue73.timespan, sheetapprovalhistorykeyvalue73.daterange_startdate, sheetapprovalhistorykeyvalue73.daterange_enddate, sheetapprovalhistorykeyvalue73.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue73.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue73.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue73.workdayduration_workdays, sheetapprovalhistorykeyvalue73.workdayduration_hours, sheetapprovalhistorykeyvalue73.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue73.parentid = sheetapprovalhistorykeyvalue81.id)
188. 0.010 50.432 ↑ 1.0 1 1

Aggregate (cost=186,877.62..186,877.63 rows=1 width=8) (actual time=50.432..50.432 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=13,089
189.          

Initplan (for Aggregate)

190. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..10.56 rows=1 width=0) (never executed)

191. 0.000 0.000 ↓ 0.0 0

Index Only Scan using userpolicyset_pkey on assuredpartnersincdemo.userpolicyset userpolicyset95 (cost=0.29..2.30 rows=1 width=16) (never executed)

  • Output: userpolicyset95.userid, userpolicyset95.policysetid
  • Index Cond: (userpolicyset95.userid = 6,186)
  • Heap Fetches: 0
192. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpskvpolicysetid on assuredpartnersincdemo.policysetkeyvalue policysetkeyvalue96 (cost=0.27..8.24 rows=1 width=16) (never executed)

  • Output: policysetkeyvalue96.id, policysetkeyvalue96.policysetid, policysetkeyvalue96.parentid, policysetkeyvalue96.index, policysetkeyvalue96.key, policysetkeyvalue96.uri, policysetkeyvalue96.slug, policysetkeyvalue96."boolean", policysetkeyvalue96.date, policysetkeyvalue96.number, policysetkeyvalue96.text, policysetkeyvalue96."time", policysetkeyvalue96.timespan, policysetkeyvalue96.daterange_startdate, policysetkeyvalue96.daterange_enddate, policysetkeyvalue96.daterange_relativedaterangeuri, policysetkeyvalue96.daterange_relativedaterangeasofdate, policysetkeyvalue96.workdayduration_decimalworkdays, policysetkeyvalue96.workdayduration_workdays, policysetkeyvalue96.workdayduration_hours, policysetkeyvalue96.workdayduration_minutes
  • Index Cond: (policysetkeyvalue96.policysetid = userpolicyset95.policysetid)
  • Filter: ((policysetkeyvalue96.parentid IS NULL) AND (upper(policysetkeyvalue96.key) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-OTHERS-TIME-OFF'::text) AND (upper(policysetkeyvalue96.uri) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-OTHERS-TIME-OFF:ALLOWED'::text))
193. 0.042 50.422 ↑ 10.8 13 1

Nested Loop Semi Join (cost=2,468.85..186,866.72 rows=140 width=0) (actual time=15.085..50.422 rows=13 loops=1)

  • Join Filter: ("*SELECT* 1_3".timeoffid = timeoffs87.id)
  • Buffers: shared hit=13,089
194. 0.214 48.898 ↑ 21.5 13 1

Hash Semi Join (cost=1,942.47..14,335.14 rows=280 width=12) (actual time=13.796..48.898 rows=13 loops=1)

  • Output: "*SELECT* 1_3".timeoffid, timeoffs125.id, timeoffs126.id
  • Hash Cond: ("*SELECT* 1_3".timeoffid = timeoffs125.id)
  • Buffers: shared hit=12,419
195. 0.121 47.487 ↓ 1.2 671 1

Append (cost=1,031.20..13,419.29 rows=560 width=4) (actual time=6.245..47.487 rows=671 loops=1)

  • Buffers: shared hit=11,188
196. 0.051 47.244 ↓ 1.2 663 1

Subquery Scan on *SELECT* 1_3 (cost=1,031.20..13,362.16 rows=552 width=4) (actual time=6.245..47.244 rows=663 loops=1)

  • Output: "*SELECT* 1_3".timeoffid
  • Buffers: shared hit=11,132
197. 20.078 47.193 ↓ 1.2 663 1

Gather (cost=1,031.20..13,356.64 rows=552 width=1,553) (actual time=6.243..47.193 rows=663 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=11,132
198. 0.235 27.115 ↑ 1.0 221 3 / 3

Hash Anti Join (cost=31.20..12,301.44 rows=230 width=1,553) (actual time=0.800..27.115 rows=221 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
  • Hash Cond: (dm_timeofflist_facts_3.timeoffid = dm_timeofflist_realtime_facts_6.timeoffid)
  • Buffers: shared hit=11,132
  • Worker 0: actual time=1.341..23.460 rows=149 loops=1
  • Buffers: shared hit=3,396
  • Worker 1: actual time=0.709..18.602 rows=195 loops=1
  • Buffers: shared hit=2,884
199. 26.717 26.717 ↑ 1.0 224 3 / 3

Parallel Seq Scan on assuredpartnersincdemo.dm_timeofflist_facts dm_timeofflist_facts_3 (cost=0.00..12,267.33 rows=230 width=4) (actual time=0.556..26.717 rows=224 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.totalworkdayduration, 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.displayformat
  • Filter: ((dm_timeofflist_facts_3.timeoffcodeid <> 69) AND (dm_timeofflist_facts_3.timeoffstatus = 1))
  • Rows Removed by Filter: 68,182
  • Buffers: shared hit=10,986
  • Worker 0: actual time=1.016..23.046 rows=150 loops=1
  • Buffers: shared hit=3,336
  • Worker 1: actual time=0.439..18.232 rows=196 loops=1
  • Buffers: shared hit=2,824
200. 0.019 0.163 ↑ 1.0 70 3 / 3

Hash (cost=30.33..30.33 rows=70 width=4) (actual time=0.163..0.163 rows=70 loops=3)

  • Output: dm_timeofflist_realtime_facts_6.timeoffid
  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=80
  • Worker 0: actual time=0.196..0.196 rows=70 loops=1
  • Buffers: shared hit=27
  • Worker 1: actual time=0.166..0.166 rows=70 loops=1
  • Buffers: shared hit=27
201. 0.144 0.144 ↑ 1.0 70 3 / 3

Index Only Scan using dm_timeofflist_realtime_facts_pkey on assuredpartnersincdemo.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_6 (cost=0.27..30.33 rows=70 width=4) (actual time=0.066..0.144 rows=70 loops=3)

  • Output: dm_timeofflist_realtime_facts_6.timeoffid
  • Heap Fetches: 46
  • Buffers: shared hit=80
  • Worker 0: actual time=0.085..0.177 rows=70 loops=1
  • Buffers: shared hit=27
  • Worker 1: actual time=0.080..0.149 rows=70 loops=1
  • Buffers: shared hit=27
202. 0.003 0.122 ↑ 1.0 8 1

Subquery Scan on *SELECT* 2_3 (cost=0.00..57.13 rows=8 width=4) (actual time=0.014..0.122 rows=8 loops=1)

  • Output: "*SELECT* 2_3".timeoffid
  • Buffers: shared hit=56
203. 0.119 0.119 ↑ 1.0 8 1

Seq Scan on assuredpartnersincdemo.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_7 (cost=0.00..57.05 rows=8 width=1,553) (actual time=0.013..0.119 rows=8 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 <> 69) AND (dm_timeofflist_realtime_facts_7.timeoffstatus = 1))
  • Rows Removed by Filter: 62
  • Buffers: shared hit=56
204. 0.046 1.197 ↑ 4.9 169 1

Hash (cost=900.90..900.90 rows=829 width=8) (actual time=1.197..1.197 rows=169 loops=1)

  • Output: timeoffs125.id, timeoffs126.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=1,231
205. 0.189 1.151 ↑ 4.9 169 1

Nested Loop (cost=525.77..900.90 rows=829 width=8) (actual time=0.590..1.151 rows=169 loops=1)

  • Output: timeoffs125.id, timeoffs126.id
  • Inner Unique: true
  • Buffers: shared hit=1,231
206. 0.091 0.624 ↑ 4.9 169 1

HashAggregate (cost=525.35..533.64 rows=829 width=4) (actual time=0.580..0.624 rows=169 loops=1)

  • Output: timeoffs126.id
  • Group Key: timeoffs126.id
  • Buffers: shared hit=554
207. 0.100 0.533 ↑ 4.9 169 1

Nested Loop (cost=0.84..523.28 rows=829 width=4) (actual time=0.046..0.533 rows=169 loops=1)

  • Output: timeoffs126.id
  • Buffers: shared hit=554
208. 0.021 0.112 ↑ 2.5 107 1

Nested Loop (cost=0.43..145.94 rows=267 width=12) (actual time=0.030..0.112 rows=107 loops=1)

  • Output: usercostcenter127.userid, usercostcenter127.startdate, usercostcenter127.enddate
  • Buffers: shared hit=71
209. 0.008 0.008 ↑ 1.0 1 1

Index Only Scan using costcenterflathierarchy_pkey on assuredpartnersincdemo.costcenterflathierarchy costcenterflathierarchy128 (cost=0.14..1.16 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=1)

  • Output: costcenterflathierarchy128.parentid, costcenterflathierarchy128.childid
  • Index Cond: (costcenterflathierarchy128.parentid = 'badda568-ec7f-42e1-9cbb-56e53c1aeda7'::uuid)
  • Heap Fetches: 1
  • Buffers: shared hit=3
210. 0.083 0.083 ↑ 3.0 107 1

Index Scan using ixucccostcenterid on assuredpartnersincdemo.usercostcenter usercostcenter127 (cost=0.29..141.52 rows=326 width=28) (actual time=0.020..0.083 rows=107 loops=1)

  • Output: usercostcenter127.id, usercostcenter127.userid, usercostcenter127.costcenterid, usercostcenter127.startdate, usercostcenter127.enddate
  • Index Cond: (usercostcenter127.costcenterid = costcenterflathierarchy128.childid)
  • Buffers: shared hit=68
211. 0.321 0.321 ↑ 2.0 2 107

Index Scan using ixto4userid on assuredpartnersincdemo.timeoffs timeoffs126 (cost=0.42..1.37 rows=4 width=16) (actual time=0.003..0.003 rows=2 loops=107)

  • Output: timeoffs126.id, timeoffs126.guidid, timeoffs126.userid, timeoffs126.createdbyuserid, timeoffs126.timeoffcodeid, timeoffs126.startdate, timeoffs126.enddate, timeoffs126.approvalstatus, timeoffs126.comments, timeoffs126.submittedonutc, timeoffs126.modifiedonutc, timeoffs126.info1, timeoffs126.info2, timeoffs126.info3, timeoffs126.info4, timeoffs126.info5, timeoffs126.startdurationtype, timeoffs126.enddurationtype, timeoffs126.startduration, timeoffs126.endduration, timeoffs126.startdatestarttime, timeoffs126.enddateendtime, timeoffs126.entryconfigurationmethod
  • Index Cond: ((timeoffs126.userid = usercostcenter127.userid) AND (usercostcenter127.enddate >= timeoffs126.startdate) AND (usercostcenter127.startdate <= timeoffs126.enddate))
  • Buffers: shared hit=483
212. 0.338 0.338 ↑ 1.0 1 169

Index Only Scan using timeoffs_pkey on assuredpartnersincdemo.timeoffs timeoffs125 (cost=0.42..0.44 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=169)

  • Output: timeoffs125.id
  • Index Cond: (timeoffs125.id = timeoffs126.id)
  • Heap Fetches: 169
  • Buffers: shared hit=677
213. 0.130 1.482 ↑ 1.0 1 13

Nested Loop Left Join (cost=526.38..645.17 rows=1 width=4) (actual time=0.114..0.114 rows=1 loops=13)

  • Output: timeoffs87.id
  • Filter: (((userhierarchy88.supervisorid = 6,186) AND ((userhierarchy88.startdate IS NULL) OR (userhierarchy88.startdate <= '2020-07-01'::date)) AND ((userhierarchy88.enddate IS NULL) OR (userhierarchy88.enddate >= '2020-07-01'::date))) OR (timeoffs87.userid = 6,186) OR (alternatives: SubPlan 23 or hashed SubPlan 24) OR (alternatives: SubPlan 25 or hashed SubPlan 26) OR (hashed SubPlan 27) OR $136 OR (SubPlan 29) OR (SubPlan 30) OR (SubPlan 31) OR (SubPlan 32))
  • Buffers: shared hit=670
214. 0.091 0.091 ↑ 1.0 1 13

Index Scan using timeoffs_pkey on assuredpartnersincdemo.timeoffs timeoffs87 (cost=0.42..0.46 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=13)

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

Index Scan using ix3uh_usersuperstart on assuredpartnersincdemo.userhierarchy userhierarchy88 (cost=0.29..0.30 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=13)

  • Output: userhierarchy88.id, userhierarchy88.userid, userhierarchy88.supervisorid, userhierarchy88.startdate, userhierarchy88.enddate
  • Index Cond: (userhierarchy88.userid = timeoffs87.userid)
  • Buffers: shared hit=39
216.          

SubPlan (for Nested Loop Left Join)

217. 0.015 0.078 ↓ 0.0 0 3

Nested Loop (cost=0.55..4.99 rows=1 width=0) (actual time=0.026..0.026 rows=0 loops=3)

  • Inner Unique: true
  • Buffers: shared hit=15
218. 0.024 0.024 ↑ 1.0 1 3

Index Scan using ixtoantimeoffid on assuredpartnersincdemo.timeoffapprovalnodes timeoffapprovalnodes89 (cost=0.28..2.29 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=3)

  • Output: timeoffapprovalnodes89.id, timeoffapprovalnodes89.timeoffid, timeoffapprovalnodes89.approverrole, timeoffapprovalnodes89.userid, timeoffapprovalnodes89.isapproved, timeoffapprovalnodes89.agentresolutionstate, timeoffapprovalnodes89.scriptid
  • Index Cond: (timeoffapprovalnodes89.timeoffid = timeoffs87.id)
  • Buffers: shared hit=9
219. 0.039 0.039 ↓ 0.0 0 3

Index Only Scan using uix2toaraidnid on assuredpartnersincdemo.timeoffapprovalrequest timeoffapprovalrequest90 (cost=0.28..2.29 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=3)

  • Output: timeoffapprovalrequest90.approverid, timeoffapprovalrequest90.nodeid
  • Index Cond: ((timeoffapprovalrequest90.approverid = 6,186) AND (timeoffapprovalrequest90.nodeid = timeoffapprovalnodes89.id))
  • Heap Fetches: 0
  • Buffers: shared hit=6
220. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..24.07 rows=9 width=4) (never executed)

  • Output: timeoffapprovalnodes89_1.timeoffid
  • Inner Unique: true
221. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix2toaraidnid on assuredpartnersincdemo.timeoffapprovalrequest timeoffapprovalrequest90_1 (cost=0.28..8.43 rows=9 width=16) (never executed)

  • Output: timeoffapprovalrequest90_1.approverid, timeoffapprovalrequest90_1.nodeid
  • Index Cond: (timeoffapprovalrequest90_1.approverid = 6,186)
  • Heap Fetches: 0
222. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalnodes_pkey on assuredpartnersincdemo.timeoffapprovalnodes timeoffapprovalnodes89_1 (cost=0.28..1.74 rows=1 width=20) (never executed)

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

Index Scan using ixtoahtimeoffid on assuredpartnersincdemo.timeoffapprovalhistory timeoffapprovalhistory91 (cost=0.42..3.40 rows=1 width=0) (actual time=0.011..0.011 rows=0 loops=3)

  • Index Cond: (timeoffapprovalhistory91.timeoffid = timeoffs87.id)
  • Filter: ((timeoffapprovalhistory91.userid = 6,186) AND (timeoffapprovalhistory91.action = ANY ('{2,3,4}'::integer[])))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=12
224. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahuserid on assuredpartnersincdemo.timeoffapprovalhistory timeoffapprovalhistory91_1 (cost=0.42..803.37 rows=424 width=4) (never executed)

  • Output: timeoffapprovalhistory91_1.timeoffid
  • Index Cond: (timeoffapprovalhistory91_1.userid = 6,186)
  • Filter: (timeoffapprovalhistory91_1.action = ANY ('{2,3,4}'::integer[]))
225. 0.136 1.085 ↑ 4.9 169 1

Nested Loop (cost=0.71..523.61 rows=829 width=4) (actual time=0.068..1.085 rows=169 loops=1)

  • Output: timeoffs92.id
  • Buffers: shared hit=552
226. 0.031 0.200 ↑ 2.5 107 1

Nested Loop (cost=0.29..146.27 rows=267 width=12) (actual time=0.045..0.200 rows=107 loops=1)

  • Output: usercostcenter93.userid, usercostcenter93.startdate, usercostcenter93.enddate
  • Buffers: shared hit=69
227. 0.012 0.012 ↑ 1.0 1 1

Seq Scan on assuredpartnersincdemo.costcenterflathierarchy costcenterflathierarchy94 (cost=0.00..1.49 rows=1 width=16) (actual time=0.009..0.012 rows=1 loops=1)

  • Output: costcenterflathierarchy94.parentid, costcenterflathierarchy94.childid, costcenterflathierarchy94.parentdepth
  • Filter: (costcenterflathierarchy94.parentid = 'badda568-ec7f-42e1-9cbb-56e53c1aeda7'::uuid)
  • Rows Removed by Filter: 40
  • Buffers: shared hit=1
228. 0.157 0.157 ↑ 3.0 107 1

Index Scan using ixucccostcenterid on assuredpartnersincdemo.usercostcenter usercostcenter93 (cost=0.29..141.52 rows=326 width=28) (actual time=0.034..0.157 rows=107 loops=1)

  • Output: usercostcenter93.id, usercostcenter93.userid, usercostcenter93.costcenterid, usercostcenter93.startdate, usercostcenter93.enddate
  • Index Cond: (usercostcenter93.costcenterid = costcenterflathierarchy94.childid)
  • Buffers: shared hit=68
229. 0.749 0.749 ↑ 2.0 2 107

Index Scan using ixto4userid on assuredpartnersincdemo.timeoffs timeoffs92 (cost=0.42..1.37 rows=4 width=16) (actual time=0.005..0.007 rows=2 loops=107)

  • Output: timeoffs92.id, timeoffs92.guidid, timeoffs92.userid, timeoffs92.createdbyuserid, timeoffs92.timeoffcodeid, timeoffs92.startdate, timeoffs92.enddate, timeoffs92.approvalstatus, timeoffs92.comments, timeoffs92.submittedonutc, timeoffs92.modifiedonutc, timeoffs92.info1, timeoffs92.info2, timeoffs92.info3, timeoffs92.info4, timeoffs92.info5, timeoffs92.startdurationtype, timeoffs92.enddurationtype, timeoffs92.startduration, timeoffs92.endduration, timeoffs92.startdatestarttime, timeoffs92.enddateendtime, timeoffs92.entryconfigurationmethod
  • Index Cond: ((timeoffs92.userid = usercostcenter93.userid) AND (usercostcenter93.enddate >= timeoffs92.startdate) AND (usercostcenter93.startdate <= timeoffs92.enddate))
  • Buffers: shared hit=483
230. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.54..40.23 rows=1 width=32) (never executed)

  • Output: upper(tsapprovalrequestkeyvalue97.uri)
  • Inner Unique: true
231. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.26..36.11 rows=12 width=84) (never executed)

  • Output: tsapprovalrequestkeyvalue97.uri, tsapprovalrequestkeyvalue97.parentid
232. 0.000 0.000 ↓ 0.0 0

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

  • Output: tsapprovalrequest100.id
  • Inner Unique: true
233. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..28.03 rows=1 width=16) (never executed)

  • Output: timesheetapprovalnodes99.id
234. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on assuredpartnersincdemo.timesheet timesheet98 (cost=0.42..7.73 rows=7 width=16) (never executed)

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

Index Scan using ixtantimesheetid on assuredpartnersincdemo.timesheetapprovalnodes timesheetapprovalnodes99 (cost=0.28..2.88 rows=2 width=32) (never executed)

  • Output: timesheetapprovalnodes99.id, timesheetapprovalnodes99.timesheetid, timesheetapprovalnodes99.approverrole, timesheetapprovalnodes99.userid, timesheetapprovalnodes99.isapproved, timesheetapprovalnodes99.systemprocessidentifier, timesheetapprovalnodes99.scriptid, timesheetapprovalnodes99.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes99.timesheetid = timesheet98.id)
236. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtarnodeid on assuredpartnersincdemo.tsapprovalrequest tsapprovalrequest100 (cost=0.28..0.31 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest100.id, tsapprovalrequest100.effectivedateutc, tsapprovalrequest100.userid, tsapprovalrequest100.nodeid, tsapprovalrequest100.remindersentutc, tsapprovalrequest100.overduesentutc, tsapprovalrequest100.waitingbatchsentutc, tsapprovalrequest100.approvalagenttype, tsapprovalrequest100.systemprocessidentifier
  • Index Cond: (tsapprovalrequest100.nodeid = timesheetapprovalnodes99.id)
  • Filter: (tsapprovalrequest100.userid = 6,186)
237. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue97 (cost=0.29..7.66 rows=12 width=88) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue101 (cost=0.29..0.34 rows=1 width=16) (never executed)

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

Nested Loop (cost=4.14..77.60 rows=1 width=32) (never executed)

  • Output: upper(heetapprovalhistorykeyvalue102.uri)
240. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.71..77.02 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue110.id
241. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.27..75.09 rows=1 width=16) (never executed)

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

Nested Loop (cost=2.83..74.52 rows=1 width=16) (never executed)

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

Nested Loop (cost=2.40..73.20 rows=1 width=16) (never executed)

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

Nested Loop (cost=1.97..71.09 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue106.parentid
  • Inner Unique: true
245. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.41..68.57 rows=1 width=16) (never executed)

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

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

  • Output: timesheetapprovalhistory104.id
247. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on assuredpartnersincdemo.timesheet timesheet103 (cost=0.42..7.73 rows=7 width=16) (never executed)

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

Index Scan using ixtah2timesheetid on assuredpartnersincdemo.timesheetapprovalhistory timesheetapprovalhistory104 (cost=0.42..4.48 rows=1 width=32) (never executed)

  • Output: timesheetapprovalhistory104.id, timesheetapprovalhistory104.timesheetid, timesheetapprovalhistory104.action, timesheetapprovalhistory104.approvalcomments, timesheetapprovalhistory104.timestamputc, timesheetapprovalhistory104.serialnumber, timesheetapprovalhistory104.approvalagenttype, timesheetapprovalhistory104.userid, timesheetapprovalhistory104.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory104.timesheetid = timesheet103.id)
  • Filter: (timesheetapprovalhistory104.userid = 6,186)
249. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue105 (cost=0.56..29.36 rows=1 width=32) (never executed)

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

Index Scan using timesheetapprovalhistorykeyvalue_pkey on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue106 (cost=0.56..2.52 rows=1 width=32) (never executed)

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

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

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue108 (cost=0.43..1.28 rows=4 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue109 (cost=0.43..0.56 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue110 (cost=0.43..1.90 rows=4 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue102 (cost=0.43..0.54 rows=4 width=87) (never executed)

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

Nested Loop (cost=1.67..10.03 rows=1 width=32) (never executed)

  • Output: upper(tsapprovalrequestkeyvalue111.uri)
  • Inner Unique: true
257. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.38..7.72 rows=1 width=84) (never executed)

  • Output: tsapprovalrequestkeyvalue111.uri, tsapprovalrequestkeyvalue111.parentid
  • Inner Unique: true
258. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.96..5.35 rows=1 width=100) (never executed)

  • Output: timesheetapprovalnodes113.timesheetid, tsapprovalrequestkeyvalue111.uri, tsapprovalrequestkeyvalue111.parentid
  • Inner Unique: true
259. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.69..3.88 rows=1 width=100) (never executed)

  • Output: tsapprovalrequest114.nodeid, tsapprovalrequestkeyvalue111.uri, tsapprovalrequestkeyvalue111.parentid
  • Inner Unique: true
260. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvkey on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue111 (cost=0.41..1.43 rows=1 width=88) (never executed)

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

Index Scan using tsapprovalrequest_pkey on assuredpartnersincdemo.tsapprovalrequest tsapprovalrequest114 (cost=0.28..2.29 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest114.id, tsapprovalrequest114.effectivedateutc, tsapprovalrequest114.userid, tsapprovalrequest114.nodeid, tsapprovalrequest114.remindersentutc, tsapprovalrequest114.overduesentutc, tsapprovalrequest114.waitingbatchsentutc, tsapprovalrequest114.approvalagenttype, tsapprovalrequest114.systemprocessidentifier
  • Index Cond: (tsapprovalrequest114.id = tsapprovalrequestkeyvalue111.tsapprovalrequestid)
  • Filter: (tsapprovalrequest114.userid = 6,186)
262. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on assuredpartnersincdemo.timesheetapprovalnodes timesheetapprovalnodes113 (cost=0.28..1.46 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes113.id, timesheetapprovalnodes113.timesheetid, timesheetapprovalnodes113.approverrole, timesheetapprovalnodes113.userid, timesheetapprovalnodes113.isapproved, timesheetapprovalnodes113.systemprocessidentifier, timesheetapprovalnodes113.scriptid, timesheetapprovalnodes113.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes113.id = tsapprovalrequest114.nodeid)
263. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on assuredpartnersincdemo.timesheet timesheet112 (cost=0.42..1.98 rows=1 width=16) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue115 (cost=0.29..2.30 rows=1 width=16) (never executed)

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

Nested Loop (cost=4.14..81.20 rows=1 width=32) (never executed)

  • Output: upper(heetapprovalhistorykeyvalue116.uri)
266. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.71..80.62 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue124.id
267. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.27..75.09 rows=1 width=16) (never executed)

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

Nested Loop (cost=2.83..74.52 rows=1 width=16) (never executed)

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

Nested Loop (cost=2.40..73.20 rows=1 width=16) (never executed)

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

Nested Loop (cost=1.97..71.09 rows=1 width=16) (never executed)

  • Output: heetapprovalhistorykeyvalue120.parentid
  • Inner Unique: true
271. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.41..68.57 rows=1 width=16) (never executed)

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

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

  • Output: timesheetapprovalhistory118.id
273. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on assuredpartnersincdemo.timesheet timesheet117 (cost=0.42..7.73 rows=7 width=16) (never executed)

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

Index Scan using ixtah2timesheetid on assuredpartnersincdemo.timesheetapprovalhistory timesheetapprovalhistory118 (cost=0.42..4.48 rows=1 width=32) (never executed)

  • Output: timesheetapprovalhistory118.id, timesheetapprovalhistory118.timesheetid, timesheetapprovalhistory118.action, timesheetapprovalhistory118.approvalcomments, timesheetapprovalhistory118.timestamputc, timesheetapprovalhistory118.serialnumber, timesheetapprovalhistory118.approvalagenttype, timesheetapprovalhistory118.userid, timesheetapprovalhistory118.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory118.timesheetid = timesheet117.id)
  • Filter: (timesheetapprovalhistory118.userid = 6,186)
275. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue119 (cost=0.56..29.36 rows=1 width=32) (never executed)

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

Index Scan using timesheetapprovalhistorykeyvalue_pkey on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue120 (cost=0.56..2.52 rows=1 width=32) (never executed)

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

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

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue122 (cost=0.43..1.28 rows=4 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue123 (cost=0.43..0.56 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue124 (cost=0.43..5.50 rows=4 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue116 (cost=0.43..0.54 rows=4 width=87) (never executed)

  • Output: heetapprovalhistorykeyvalue116.id, heetapprovalhistorykeyvalue116.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue116.parentid, heetapprovalhistorykeyvalue116.index, heetapprovalhistorykeyvalue116.key, heetapprovalhistorykeyvalue116.uri, heetapprovalhistorykeyvalue116.slug, heetapprovalhistorykeyvalue116."boolean", heetapprovalhistorykeyvalue116.date, heetapprovalhistorykeyvalue116.number, heetapprovalhistorykeyvalue116.text, heetapprovalhistorykeyvalue116."time", heetapprovalhistorykeyvalue116.timespan, heetapprovalhistorykeyvalue116.daterange_startdate, heetapprovalhistorykeyvalue116.daterange_enddate, heetapprovalhistorykeyvalue116.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue116.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue116.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue116.workdayduration_workdays, heetapprovalhistorykeyvalue116.workdayduration_hours, heetapprovalhistorykeyvalue116.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue116.parentid = heetapprovalhistorykeyvalue124.id)
282. 0.000 23,068.556 ↑ 1.0 1 1

Aggregate (cost=24,649,263.13..24,649,263.14 rows=1 width=8) (actual time=23,068.555..23,068.556 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=7,807,298
283.          

Initplan (for Aggregate)

284. 0.002 0.056 ↓ 0.0 0 1

Nested Loop (cost=0.56..10.56 rows=1 width=0) (actual time=0.056..0.056 rows=0 loops=1)

  • Buffers: shared hit=7
285. 0.022 0.022 ↑ 1.0 1 1

Index Only Scan using userpolicyset_pkey on assuredpartnersincdemo.userpolicyset userpolicyset138 (cost=0.29..2.30 rows=1 width=16) (actual time=0.021..0.022 rows=1 loops=1)

  • Output: userpolicyset138.userid, userpolicyset138.policysetid
  • Index Cond: (userpolicyset138.userid = 6,186)
  • Heap Fetches: 1
  • Buffers: shared hit=4
286. 0.032 0.032 ↓ 0.0 0 1

Index Scan using ixpskvpolicysetid on assuredpartnersincdemo.policysetkeyvalue policysetkeyvalue139 (cost=0.27..8.24 rows=1 width=16) (actual time=0.032..0.032 rows=0 loops=1)

  • Output: policysetkeyvalue139.id, policysetkeyvalue139.policysetid, policysetkeyvalue139.parentid, policysetkeyvalue139.index, policysetkeyvalue139.key, policysetkeyvalue139.uri, policysetkeyvalue139.slug, policysetkeyvalue139."boolean", policysetkeyvalue139.date, policysetkeyvalue139.number, policysetkeyvalue139.text, policysetkeyvalue139."time", policysetkeyvalue139.timespan, policysetkeyvalue139.daterange_startdate, policysetkeyvalue139.daterange_enddate, policysetkeyvalue139.daterange_relativedaterangeuri, policysetkeyvalue139.daterange_relativedaterangeasofdate, policysetkeyvalue139.workdayduration_decimalworkdays, policysetkeyvalue139.workdayduration_workdays, policysetkeyvalue139.workdayduration_hours, policysetkeyvalue139.workdayduration_minutes
  • Index Cond: (policysetkeyvalue139.policysetid = userpolicyset138.policysetid)
  • Filter: ((policysetkeyvalue139.parentid IS NULL) AND (upper(policysetkeyvalue139.key) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-OTHERS-TIME-OFF'::text) AND (upper(policysetkeyvalue139.uri) = 'URN:REPLICON:POLICY:TIME-OFF:CAN-USER-VIEW-OTHERS-TIME-OFF:ALLOWED'::text))
  • Rows Removed by Filter: 5
  • Buffers: shared hit=3
287. 0.644 23,068.527 ↑ 391.0 104 1

Merge Semi Join (cost=27,230.69..24,649,150.91 rows=40,662 width=0) (actual time=22,457.820..23,068.527 rows=104 loops=1)

  • Merge Cond: ("*SELECT* 1_4".timeoffid = timeoffs130.id)
  • Buffers: shared hit=7,807,298
288. 0.102 191.144 ↑ 782.0 104 1

Sort (cost=26,704.31..26,907.62 rows=81,324 width=12) (actual time=191.120..191.144 rows=104 loops=1)

  • Output: "*SELECT* 1_4".timeoffid, timeoffs168.id, timeoffs169.id
  • Sort Key: "*SELECT* 1_4".timeoffid
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=12,299
289. 16.528 191.042 ↑ 782.0 104 1

Hash Semi Join (cost=942.47..20,071.77 rows=81,324 width=12) (actual time=12.019..191.042 rows=104 loops=1)

  • Output: "*SELECT* 1_4".timeoffid, timeoffs168.id, timeoffs169.id
  • Hash Cond: ("*SELECT* 1_4".timeoffid = timeoffs168.id)
  • Buffers: shared hit=12,299
290. 18.407 172.635 ↓ 1.0 162,664 1

Append (cost=31.20..17,828.82 rows=162,649 width=4) (actual time=0.140..172.635 rows=162,664 loops=1)

  • Buffers: shared hit=11,068
291. 21.456 154.113 ↓ 1.0 162,602 1

Subquery Scan on *SELECT* 1_4 (cost=31.20..17,771.16 rows=162,588 width=4) (actual time=0.139..154.113 rows=162,602 loops=1)

  • Output: "*SELECT* 1_4".timeoffid
  • Buffers: shared hit=11,012
292. 49.780 132.657 ↓ 1.0 162,602 1

Hash Anti Join (cost=31.20..16,145.28 rows=162,588 width=1,553) (actual time=0.139..132.657 rows=162,602 loops=1)

  • Output: dm_timeofflist_facts_4.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Hash Cond: (dm_timeofflist_facts_4.timeoffid = dm_timeofflist_realtime_facts_8.timeoffid)
  • Buffers: shared hit=11,012
293. 82.769 82.769 ↓ 1.0 162,664 1

Seq Scan on assuredpartnersincdemo.dm_timeofflist_facts dm_timeofflist_facts_4 (cost=0.00..14,061.19 rows=162,644 width=4) (actual time=0.007..82.769 rows=162,664 loops=1)

  • Output: dm_timeofflist_facts_4.timeoffid, dm_timeofflist_facts_4.timeoffslug, dm_timeofflist_facts_4.timeoffowneruserid, dm_timeofflist_facts_4.timeoffowneruserdisplayname, dm_timeofflist_facts_4.timeoffowneruserslug, dm_timeofflist_facts_4.timeoffowneruserenabled, dm_timeofflist_facts_4.timeoffownerdepartmentid, dm_timeofflist_facts_4.timeoffownerdepartmentdisplayname, dm_timeofflist_facts_4.timeoffownerdepartmentslug, dm_timeofflist_facts_4.timeoffownersupervisoruserid, dm_timeofflist_facts_4.timeoffownersupervisoruserdisplayname, dm_timeofflist_facts_4.timeoffownersupervisoruserslug, dm_timeofflist_facts_4.timeoffcodeid, dm_timeofflist_facts_4.timeoffcodedisplayname, dm_timeofflist_facts_4.timeoffcodeslug, dm_timeofflist_facts_4.approvalstatus, dm_timeofflist_facts_4.timeoffstatus, dm_timeofflist_facts_4.startdate, dm_timeofflist_facts_4.enddate, dm_timeofflist_facts_4.startdaydurationtype, dm_timeofflist_facts_4.enddaydurationtype, dm_timeofflist_facts_4.startdayduration, dm_timeofflist_facts_4.enddayduration, dm_timeofflist_facts_4.startdaystarttime, dm_timeofflist_facts_4.enddayendtime, dm_timeofflist_facts_4.totalduration, dm_timeofflist_facts_4.totalworkdayduration, 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.displayformat
  • Filter: ((dm_timeofflist_facts_4.timeoffcodeid <> 69) AND (dm_timeofflist_facts_4.timeoffstatus = 2))
  • Rows Removed by Filter: 42,554
  • Buffers: shared hit=10,986
294. 0.023 0.108 ↑ 1.0 70 1

Hash (cost=30.33..30.33 rows=70 width=4) (actual time=0.108..0.108 rows=70 loops=1)

  • Output: dm_timeofflist_realtime_facts_8.timeoffid
  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=26
295. 0.085 0.085 ↑ 1.0 70 1

Index Only Scan using dm_timeofflist_realtime_facts_pkey on assuredpartnersincdemo.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_8 (cost=0.27..30.33 rows=70 width=4) (actual time=0.029..0.085 rows=70 loops=1)

  • Output: dm_timeofflist_realtime_facts_8.timeoffid
  • Heap Fetches: 46
  • Buffers: shared hit=26
296. 0.009 0.115 ↓ 1.0 62 1

Subquery Scan on *SELECT* 2_4 (cost=0.00..57.66 rows=61 width=4) (actual time=0.007..0.115 rows=62 loops=1)

  • Output: "*SELECT* 2_4".timeoffid
  • Buffers: shared hit=56
297. 0.106 0.106 ↓ 1.0 62 1

Seq Scan on assuredpartnersincdemo.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_9 (cost=0.00..57.05 rows=61 width=1,553) (actual time=0.006..0.106 rows=62 loops=1)

  • Output: dm_timeofflist_realtime_facts_9.timeoffid, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::boolean, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::integer, NULL::interval, NULL::interval, NULL::time without time zone, NULL::time without time zone, NULL::interval, NULL::numeric(19,4), NULL::interval, NULL::timestamp without time zone, NULL::integer, NULL::text, NULL::text, NULL::timestamp without time zone, NULL::character varying(255), NULL::character varying(255), NULL::integer
  • Filter: ((NOT dm_timeofflist_realtime_facts_9.deleted) AND (dm_timeofflist_realtime_facts_9.timeoffcodeid <> 69) AND (dm_timeofflist_realtime_facts_9.timeoffstatus = 2))
  • Rows Removed by Filter: 8
  • Buffers: shared hit=56
298. 0.059 1.879 ↑ 4.9 169 1

Hash (cost=900.90..900.90 rows=829 width=8) (actual time=1.879..1.879 rows=169 loops=1)

  • Output: timeoffs168.id, timeoffs169.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=1,231
299. 0.193 1.820 ↑ 4.9 169 1

Nested Loop (cost=525.77..900.90 rows=829 width=8) (actual time=1.093..1.820 rows=169 loops=1)

  • Output: timeoffs168.id, timeoffs169.id
  • Inner Unique: true
  • Buffers: shared hit=1,231
300. 0.132 1.120 ↑ 4.9 169 1

HashAggregate (cost=525.35..533.64 rows=829 width=4) (actual time=1.069..1.120 rows=169 loops=1)

  • Output: timeoffs169.id
  • Group Key: timeoffs169.id
  • Buffers: shared hit=554
301. 0.160 0.988 ↑ 4.9 169 1

Nested Loop (cost=0.84..523.28 rows=829 width=4) (actual time=0.080..0.988 rows=169 loops=1)

  • Output: timeoffs169.id
  • Buffers: shared hit=554
302. 0.033 0.186 ↑ 2.5 107 1

Nested Loop (cost=0.43..145.94 rows=267 width=12) (actual time=0.052..0.186 rows=107 loops=1)

  • Output: usercostcenter170.userid, usercostcenter170.startdate, usercostcenter170.enddate
  • Buffers: shared hit=71
303. 0.018 0.018 ↑ 1.0 1 1

Index Only Scan using costcenterflathierarchy_pkey on assuredpartnersincdemo.costcenterflathierarchy costcenterflathierarchy171 (cost=0.14..1.16 rows=1 width=16) (actual time=0.017..0.018 rows=1 loops=1)

  • Output: costcenterflathierarchy171.parentid, costcenterflathierarchy171.childid
  • Index Cond: (costcenterflathierarchy171.parentid = 'badda568-ec7f-42e1-9cbb-56e53c1aeda7'::uuid)
  • Heap Fetches: 1
  • Buffers: shared hit=3
304. 0.135 0.135 ↑ 3.0 107 1

Index Scan using ixucccostcenterid on assuredpartnersincdemo.usercostcenter usercostcenter170 (cost=0.29..141.52 rows=326 width=28) (actual time=0.032..0.135 rows=107 loops=1)

  • Output: usercostcenter170.id, usercostcenter170.userid, usercostcenter170.costcenterid, usercostcenter170.startdate, usercostcenter170.enddate
  • Index Cond: (usercostcenter170.costcenterid = costcenterflathierarchy171.childid)
  • Buffers: shared hit=68
305. 0.642 0.642 ↑ 2.0 2 107

Index Scan using ixto4userid on assuredpartnersincdemo.timeoffs timeoffs169 (cost=0.42..1.37 rows=4 width=16) (actual time=0.005..0.006 rows=2 loops=107)

  • Output: timeoffs169.id, timeoffs169.guidid, timeoffs169.userid, timeoffs169.createdbyuserid, timeoffs169.timeoffcodeid, timeoffs169.startdate, timeoffs169.enddate, timeoffs169.approvalstatus, timeoffs169.comments, timeoffs169.submittedonutc, timeoffs169.modifiedonutc, timeoffs169.info1, timeoffs169.info2, timeoffs169.info3, timeoffs169.info4, timeoffs169.info5, timeoffs169.startdurationtype, timeoffs169.enddurationtype, timeoffs169.startduration, timeoffs169.endduration, timeoffs169.startdatestarttime, timeoffs169.enddateendtime, timeoffs169.entryconfigurationmethod
  • Index Cond: ((timeoffs169.userid = usercostcenter170.userid) AND (usercostcenter170.enddate >= timeoffs169.startdate) AND (usercostcenter170.startdate <= timeoffs169.enddate))
  • Buffers: shared hit=483
306. 0.507 0.507 ↑ 1.0 1 169

Index Only Scan using timeoffs_pkey on assuredpartnersincdemo.timeoffs timeoffs168 (cost=0.42..0.44 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=169)

  • Output: timeoffs168.id
  • Index Cond: (timeoffs168.id = timeoffs169.id)
  • Heap Fetches: 169
  • Buffers: shared hit=677
307. 857.841 22,876.739 ↑ 203.5 1,477 1

Nested Loop Left Join (cost=526.38..24,620,106.35 rows=300,583 width=4) (actual time=15,236.759..22,876.739 rows=1,477 loops=1)

  • Output: timeoffs130.id
  • Filter: (((userhierarchy131.supervisorid = 6,186) AND ((userhierarchy131.startdate IS NULL) OR (userhierarchy131.startdate <= '2020-07-01'::date)) AND ((userhierarchy131.enddate IS NULL) OR (userhierarchy131.enddate >= '2020-07-01'::date))) OR (timeoffs130.userid = 6,186) OR (alternatives: SubPlan 34 or hashed SubPlan 35) OR (alternatives: SubPlan 36 or hashed SubPlan 37) OR (hashed SubPlan 38) OR $198 OR (SubPlan 40) OR (SubPlan 41) OR (SubPlan 42) OR (SubPlan 43))
  • Rows Removed by Filter: 326,699
  • Buffers: shared hit=7,794,999
308. 166.274 166.274 ↑ 1.0 204,824 1

Index Scan using timeoffs_pkey on assuredpartnersincdemo.timeoffs timeoffs130 (cost=0.42..7,958.06 rows=206,776 width=16) (actual time=0.057..166.274 rows=204,824 loops=1)

  • Output: timeoffs130.id, timeoffs130.guidid, timeoffs130.userid, timeoffs130.createdbyuserid, timeoffs130.timeoffcodeid, timeoffs130.startdate, timeoffs130.enddate, timeoffs130.approvalstatus, timeoffs130.comments, timeoffs130.submittedonutc, timeoffs130.modifiedonutc, timeoffs130.info1, timeoffs130.info2, timeoffs130.info3, timeoffs130.info4, timeoffs130.info5, timeoffs130.startdurationtype, timeoffs130.enddurationtype, timeoffs130.startduration, timeoffs130.endduration, timeoffs130.startdatestarttime, timeoffs130.enddateendtime, timeoffs130.entryconfigurationmethod
  • Buffers: shared hit=84,306
309. 614.472 614.472 ↓ 2.0 2 204,824

Index Scan using ix3uh_usersuperstart on assuredpartnersincdemo.userhierarchy userhierarchy131 (cost=0.29..0.30 rows=1 width=24) (actual time=0.002..0.003 rows=2 loops=204,824)

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

SubPlan (for Nested Loop Left Join)

311. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Output: timeoffapprovalrequest133.approverid, timeoffapprovalrequest133.nodeid
  • Index Cond: ((timeoffapprovalrequest133.approverid = 6,186) AND (timeoffapprovalrequest133.nodeid = timeoffapprovalnodes132.id))
  • Heap Fetches: 0
314. 0.005 0.065 ↑ 1.0 9 1

Nested Loop (cost=0.55..24.07 rows=9 width=4) (actual time=0.032..0.065 rows=9 loops=1)

  • Output: timeoffapprovalnodes132_1.timeoffid
  • Inner Unique: true
  • Buffers: shared hit=40
315. 0.024 0.024 ↑ 1.0 9 1

Index Only Scan using uix2toaraidnid on assuredpartnersincdemo.timeoffapprovalrequest timeoffapprovalrequest133_1 (cost=0.28..8.43 rows=9 width=16) (actual time=0.015..0.024 rows=9 loops=1)

  • Output: timeoffapprovalrequest133_1.approverid, timeoffapprovalrequest133_1.nodeid
  • Index Cond: (timeoffapprovalrequest133_1.approverid = 6,186)
  • Heap Fetches: 9
  • Buffers: shared hit=13
316. 0.036 0.036 ↑ 1.0 1 9

Index Scan using timeoffapprovalnodes_pkey on assuredpartnersincdemo.timeoffapprovalnodes timeoffapprovalnodes132_1 (cost=0.28..1.74 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=9)

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

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

  • Index Cond: (timeoffapprovalhistory134.timeoffid = timeoffs130.id)
  • Filter: ((timeoffapprovalhistory134.userid = 6,186) AND (timeoffapprovalhistory134.action = ANY ('{2,3,4}'::integer[])))
318. 0.696 0.696 ↓ 1.2 529 1

Index Scan using ixtoahuserid on assuredpartnersincdemo.timeoffapprovalhistory timeoffapprovalhistory134_1 (cost=0.42..803.37 rows=424 width=4) (actual time=0.035..0.696 rows=529 loops=1)

  • Output: timeoffapprovalhistory134_1.timeoffid
  • Index Cond: (timeoffapprovalhistory134_1.userid = 6,186)
  • Filter: (timeoffapprovalhistory134_1.action = ANY ('{2,3,4}'::integer[]))
  • Rows Removed by Filter: 354
  • Buffers: shared hit=19
319. 0.051 0.772 ↑ 4.9 169 1

Nested Loop (cost=0.71..523.61 rows=829 width=4) (actual time=0.069..0.772 rows=169 loops=1)

  • Output: timeoffs135.id
  • Buffers: shared hit=552
320. 0.026 0.186 ↑ 2.5 107 1

Nested Loop (cost=0.29..146.27 rows=267 width=12) (actual time=0.050..0.186 rows=107 loops=1)

  • Output: usercostcenter136.userid, usercostcenter136.startdate, usercostcenter136.enddate
  • Buffers: shared hit=69
321. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on assuredpartnersincdemo.costcenterflathierarchy costcenterflathierarchy137 (cost=0.00..1.49 rows=1 width=16) (actual time=0.008..0.011 rows=1 loops=1)

  • Output: costcenterflathierarchy137.parentid, costcenterflathierarchy137.childid, costcenterflathierarchy137.parentdepth
  • Filter: (costcenterflathierarchy137.parentid = 'badda568-ec7f-42e1-9cbb-56e53c1aeda7'::uuid)
  • Rows Removed by Filter: 40
  • Buffers: shared hit=1
322. 0.149 0.149 ↑ 3.0 107 1

Index Scan using ixucccostcenterid on assuredpartnersincdemo.usercostcenter usercostcenter136 (cost=0.29..141.52 rows=326 width=28) (actual time=0.039..0.149 rows=107 loops=1)

  • Output: usercostcenter136.id, usercostcenter136.userid, usercostcenter136.costcenterid, usercostcenter136.startdate, usercostcenter136.enddate
  • Index Cond: (usercostcenter136.costcenterid = costcenterflathierarchy137.childid)
  • Buffers: shared hit=68
323. 0.535 0.535 ↑ 2.0 2 107

Index Scan using ixto4userid on assuredpartnersincdemo.timeoffs timeoffs135 (cost=0.42..1.37 rows=4 width=16) (actual time=0.004..0.005 rows=2 loops=107)

  • Output: timeoffs135.id, timeoffs135.guidid, timeoffs135.userid, timeoffs135.createdbyuserid, timeoffs135.timeoffcodeid, timeoffs135.startdate, timeoffs135.enddate, timeoffs135.approvalstatus, timeoffs135.comments, timeoffs135.submittedonutc, timeoffs135.modifiedonutc, timeoffs135.info1, timeoffs135.info2, timeoffs135.info3, timeoffs135.info4, timeoffs135.info5, timeoffs135.startdurationtype, timeoffs135.enddurationtype, timeoffs135.startduration, timeoffs135.endduration, timeoffs135.startdatestarttime, timeoffs135.enddateendtime, timeoffs135.entryconfigurationmethod
  • Index Cond: ((timeoffs135.userid = usercostcenter136.userid) AND (usercostcenter136.enddate >= timeoffs135.startdate) AND (usercostcenter136.startdate <= timeoffs135.enddate))
  • Buffers: shared hit=483
324. 0.000 2,287.411 ↓ 0.0 0 326,773

Nested Loop (cost=1.54..40.23 rows=1 width=32) (actual time=0.007..0.007 rows=0 loops=326,773)

  • Output: upper(tsapprovalrequestkeyvalue140.uri)
  • Inner Unique: true
  • Buffers: shared hit=1,639,760
325. 326.773 2,287.411 ↓ 0.0 0 326,773

Nested Loop (cost=1.26..36.11 rows=12 width=84) (actual time=0.007..0.007 rows=0 loops=326,773)

  • Output: tsapprovalrequestkeyvalue140.uri, tsapprovalrequestkeyvalue140.parentid
  • Buffers: shared hit=1,639,760
326. 0.000 1,960.638 ↓ 0.0 0 326,773

Nested Loop (cost=0.97..28.33 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=326,773)

  • Output: tsapprovalrequest143.id
  • Inner Unique: true
  • Buffers: shared hit=1,639,760
327. 299.542 1,960.638 ↓ 0.0 0 326,773

Nested Loop (cost=0.70..28.03 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=326,773)

  • Output: timesheetapprovalnodes142.id
  • Buffers: shared hit=1,633,691
328. 1,307.092 1,307.092 ↑ 7.0 1 326,773

Index Scan using ixtsuseridstartdateenddate on assuredpartnersincdemo.timesheet timesheet141 (cost=0.42..7.73 rows=7 width=16) (actual time=0.004..0.004 rows=1 loops=326,773)

  • Output: timesheet141.id, timesheet141.userid, timesheet141.startdate, timesheet141.enddate, timesheet141.approvalstatus, timesheet141.duedate, timesheet141.autosubmitdatetimeutc, timesheet141.lastautosubmitattemptdatetimeutc, timesheet141.createdonutc
  • Index Cond: ((timesheet141.userid = timeoffs130.userid) AND (timeoffs130.enddate >= timesheet141.startdate) AND (timeoffs130.startdate <= timesheet141.enddate))
  • Buffers: shared hit=1,276,187
329. 354.004 354.004 ↓ 0.0 0 177,002

Index Scan using ixtantimesheetid on assuredpartnersincdemo.timesheetapprovalnodes timesheetapprovalnodes142 (cost=0.28..2.88 rows=2 width=32) (actual time=0.002..0.002 rows=0 loops=177,002)

  • Output: timesheetapprovalnodes142.id, timesheetapprovalnodes142.timesheetid, timesheetapprovalnodes142.approverrole, timesheetapprovalnodes142.userid, timesheetapprovalnodes142.isapproved, timesheetapprovalnodes142.systemprocessidentifier, timesheetapprovalnodes142.scriptid, timesheetapprovalnodes142.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes142.timesheetid = timesheet141.id)
  • Buffers: shared hit=357,504
330. 4.844 4.844 ↓ 0.0 0 2,422

Index Scan using ixtarnodeid on assuredpartnersincdemo.tsapprovalrequest tsapprovalrequest143 (cost=0.28..0.31 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=2,422)

  • Output: tsapprovalrequest143.id, tsapprovalrequest143.effectivedateutc, tsapprovalrequest143.userid, tsapprovalrequest143.nodeid, tsapprovalrequest143.remindersentutc, tsapprovalrequest143.overduesentutc, tsapprovalrequest143.waitingbatchsentutc, tsapprovalrequest143.approvalagenttype, tsapprovalrequest143.systemprocessidentifier
  • Index Cond: (tsapprovalrequest143.nodeid = timesheetapprovalnodes142.id)
  • Filter: (tsapprovalrequest143.userid = 6,186)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=6,069
331. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue140 (cost=0.29..7.66 rows=12 width=88) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue144 (cost=0.29..0.34 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue144.id, tsapprovalrequestkeyvalue144.tsapprovalrequestid, tsapprovalrequestkeyvalue144.parentid, tsapprovalrequestkeyvalue144.index, tsapprovalrequestkeyvalue144.key, tsapprovalrequestkeyvalue144.uri, tsapprovalrequestkeyvalue144.slug, tsapprovalrequestkeyvalue144."boolean", tsapprovalrequestkeyvalue144.date, tsapprovalrequestkeyvalue144.number, tsapprovalrequestkeyvalue144.text, tsapprovalrequestkeyvalue144."time", tsapprovalrequestkeyvalue144.timespan, tsapprovalrequestkeyvalue144.daterange_startdate, tsapprovalrequestkeyvalue144.daterange_enddate, tsapprovalrequestkeyvalue144.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue144.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue144.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue144.workdayduration_workdays, tsapprovalrequestkeyvalue144.workdayduration_hours, tsapprovalrequestkeyvalue144.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue144.id = tsapprovalrequestkeyvalue140.parentid)
  • Filter: (tsapprovalrequestkeyvalue144.parentid IS NULL)
333. 326.403 2,940.957 ↓ 0.0 0 326,773

Nested Loop (cost=4.14..77.60 rows=1 width=32) (actual time=0.009..0.009 rows=0 loops=326,773)

  • Output: upper(heetapprovalhistorykeyvalue145.uri)
  • Buffers: shared hit=2,198,072
334. 0.000 2,614.184 ↓ 0.0 0 326,773

Nested Loop (cost=3.71..77.02 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=326,773)

  • Output: heetapprovalhistorykeyvalue153.id
  • Buffers: shared hit=2,197,764
335. 0.000 2,614.184 ↓ 0.0 0 326,773

Nested Loop (cost=3.27..75.09 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=326,773)

  • Output: heetapprovalhistorykeyvalue152.id
  • Buffers: shared hit=2,197,468
336. 0.000 2,614.184 ↓ 0.0 0 326,773

Nested Loop (cost=2.83..74.52 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=326,773)

  • Output: heetapprovalhistorykeyvalue151.id
  • Buffers: shared hit=2,197,172
337. 326.107 2,614.184 ↓ 0.0 0 326,773

Nested Loop (cost=2.40..73.20 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=326,773)

  • Output: heetapprovalhistorykeyvalue150.id
  • Buffers: shared hit=2,196,876
338. 0.000 2,287.411 ↓ 0.0 0 326,773

Nested Loop (cost=1.97..71.09 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=326,773)

  • Output: heetapprovalhistorykeyvalue149.parentid
  • Inner Unique: true
  • Buffers: shared hit=2,196,566
339. 0.000 2,287.411 ↓ 0.0 0 326,773

Nested Loop (cost=1.41..68.57 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=326,773)

  • Output: heetapprovalhistorykeyvalue148.parentid
  • Buffers: shared hit=2,196,196
340. 422.082 2,287.411 ↓ 0.0 0 326,773

Nested Loop (cost=0.84..39.20 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=326,773)

  • Output: timesheetapprovalhistory147.id
  • Buffers: shared hit=2,195,506
341. 980.319 980.319 ↑ 7.0 1 326,773

Index Scan using ixtsuseridstartdateenddate on assuredpartnersincdemo.timesheet timesheet146 (cost=0.42..7.73 rows=7 width=16) (actual time=0.003..0.003 rows=1 loops=326,773)

  • Output: timesheet146.id, timesheet146.userid, timesheet146.startdate, timesheet146.enddate, timesheet146.approvalstatus, timesheet146.duedate, timesheet146.autosubmitdatetimeutc, timesheet146.lastautosubmitattemptdatetimeutc, timesheet146.createdonutc
  • Index Cond: ((timesheet146.userid = timeoffs130.userid) AND (timeoffs130.enddate >= timesheet146.startdate) AND (timeoffs130.startdate <= timesheet146.enddate))
  • Buffers: shared hit=1,276,187
342. 885.010 885.010 ↓ 0.0 0 177,002

Index Scan using ixtah2timesheetid on assuredpartnersincdemo.timesheetapprovalhistory timesheetapprovalhistory147 (cost=0.42..4.48 rows=1 width=32) (actual time=0.005..0.005 rows=0 loops=177,002)

  • Output: timesheetapprovalhistory147.id, timesheetapprovalhistory147.timesheetid, timesheetapprovalhistory147.action, timesheetapprovalhistory147.approvalcomments, timesheetapprovalhistory147.timestamputc, timesheetapprovalhistory147.serialnumber, timesheetapprovalhistory147.approvalagenttype, timesheetapprovalhistory147.userid, timesheetapprovalhistory147.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory147.timesheetid = timesheet146.id)
  • Filter: (timesheetapprovalhistory147.userid = 6,186)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=919,319
343. 4.914 4.914 ↑ 1.0 1 117

Index Scan using ixtahkvtimesheetapprovalhistoryid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue148 (cost=0.56..29.36 rows=1 width=32) (actual time=0.042..0.042 rows=1 loops=117)

  • Output: heetapprovalhistorykeyvalue148.id, heetapprovalhistorykeyvalue148.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue148.parentid, heetapprovalhistorykeyvalue148.index, heetapprovalhistorykeyvalue148.key, heetapprovalhistorykeyvalue148.uri, heetapprovalhistorykeyvalue148.slug, heetapprovalhistorykeyvalue148."boolean", heetapprovalhistorykeyvalue148.date, heetapprovalhistorykeyvalue148.number, heetapprovalhistorykeyvalue148.text, heetapprovalhistorykeyvalue148."time", heetapprovalhistorykeyvalue148.timespan, heetapprovalhistorykeyvalue148.daterange_startdate, heetapprovalhistorykeyvalue148.daterange_enddate, heetapprovalhistorykeyvalue148.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue148.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue148.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue148.workdayduration_workdays, heetapprovalhistorykeyvalue148.workdayduration_hours, heetapprovalhistorykeyvalue148.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue148.timesheetapprovalhistoryid = timesheetapprovalhistory147.id)
  • Filter: ((upper(heetapprovalhistorykeyvalue148.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(heetapprovalhistorykeyvalue148.uri) = 'URN:REPLICON-TENANT:ASSURED-PARTNERS-INCDEMO:USER:6,186'::text))
  • Rows Removed by Filter: 17
  • Buffers: shared hit=690
344. 0.518 0.518 ↑ 1.0 1 74

Index Scan using timesheetapprovalhistorykeyvalue_pkey on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue149 (cost=0.56..2.52 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=74)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue150 (cost=0.43..2.10 rows=1 width=32) (actual time=0.009..0.009 rows=1 loops=74)

  • Output: heetapprovalhistorykeyvalue150.id, heetapprovalhistorykeyvalue150.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue150.parentid, heetapprovalhistorykeyvalue150.index, heetapprovalhistorykeyvalue150.key, heetapprovalhistorykeyvalue150.uri, heetapprovalhistorykeyvalue150.slug, heetapprovalhistorykeyvalue150."boolean", heetapprovalhistorykeyvalue150.date, heetapprovalhistorykeyvalue150.number, heetapprovalhistorykeyvalue150.text, heetapprovalhistorykeyvalue150."time", heetapprovalhistorykeyvalue150.timespan, heetapprovalhistorykeyvalue150.daterange_startdate, heetapprovalhistorykeyvalue150.daterange_enddate, heetapprovalhistorykeyvalue150.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue150.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue150.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue150.workdayduration_workdays, heetapprovalhistorykeyvalue150.workdayduration_hours, heetapprovalhistorykeyvalue150.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue150.parentid = heetapprovalhistorykeyvalue149.parentid)
  • Filter: (upper(heetapprovalhistorykeyvalue150.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=310
346. 0.296 0.296 ↑ 4.0 1 74

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue151 (cost=0.43..1.28 rows=4 width=32) (actual time=0.004..0.004 rows=1 loops=74)

  • Output: heetapprovalhistorykeyvalue151.id, heetapprovalhistorykeyvalue151.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue151.parentid, heetapprovalhistorykeyvalue151.index, heetapprovalhistorykeyvalue151.key, heetapprovalhistorykeyvalue151.uri, heetapprovalhistorykeyvalue151.slug, heetapprovalhistorykeyvalue151."boolean", heetapprovalhistorykeyvalue151.date, heetapprovalhistorykeyvalue151.number, heetapprovalhistorykeyvalue151.text, heetapprovalhistorykeyvalue151."time", heetapprovalhistorykeyvalue151.timespan, heetapprovalhistorykeyvalue151.daterange_startdate, heetapprovalhistorykeyvalue151.daterange_enddate, heetapprovalhistorykeyvalue151.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue151.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue151.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue151.workdayduration_workdays, heetapprovalhistorykeyvalue151.workdayduration_hours, heetapprovalhistorykeyvalue151.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue151.parentid = heetapprovalhistorykeyvalue150.id)
  • Buffers: shared hit=296
347. 0.370 0.370 ↑ 1.0 1 74

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue152 (cost=0.43..0.56 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=74)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue153 (cost=0.43..1.90 rows=4 width=32) (actual time=0.003..0.003 rows=1 loops=74)

  • Output: heetapprovalhistorykeyvalue153.id, heetapprovalhistorykeyvalue153.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue153.parentid, heetapprovalhistorykeyvalue153.index, heetapprovalhistorykeyvalue153.key, heetapprovalhistorykeyvalue153.uri, heetapprovalhistorykeyvalue153.slug, heetapprovalhistorykeyvalue153."boolean", heetapprovalhistorykeyvalue153.date, heetapprovalhistorykeyvalue153.number, heetapprovalhistorykeyvalue153.text, heetapprovalhistorykeyvalue153."time", heetapprovalhistorykeyvalue153.timespan, heetapprovalhistorykeyvalue153.daterange_startdate, heetapprovalhistorykeyvalue153.daterange_enddate, heetapprovalhistorykeyvalue153.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue153.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue153.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue153.workdayduration_workdays, heetapprovalhistorykeyvalue153.workdayduration_hours, heetapprovalhistorykeyvalue153.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue153.parentid = heetapprovalhistorykeyvalue152.id)
  • Buffers: shared hit=296
349. 0.370 0.370 ↓ 1.8 7 74

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue145 (cost=0.43..0.54 rows=4 width=87) (actual time=0.004..0.005 rows=7 loops=74)

  • Output: heetapprovalhistorykeyvalue145.id, heetapprovalhistorykeyvalue145.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue145.parentid, heetapprovalhistorykeyvalue145.index, heetapprovalhistorykeyvalue145.key, heetapprovalhistorykeyvalue145.uri, heetapprovalhistorykeyvalue145.slug, heetapprovalhistorykeyvalue145."boolean", heetapprovalhistorykeyvalue145.date, heetapprovalhistorykeyvalue145.number, heetapprovalhistorykeyvalue145.text, heetapprovalhistorykeyvalue145."time", heetapprovalhistorykeyvalue145.timespan, heetapprovalhistorykeyvalue145.daterange_startdate, heetapprovalhistorykeyvalue145.daterange_enddate, heetapprovalhistorykeyvalue145.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue145.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue145.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue145.workdayduration_workdays, heetapprovalhistorykeyvalue145.workdayduration_hours, heetapprovalhistorykeyvalue145.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue145.parentid = heetapprovalhistorykeyvalue153.id)
  • Buffers: shared hit=308
350. 326.699 13,394.659 ↓ 0.0 0 326,699

Nested Loop (cost=1.67..10.03 rows=1 width=32) (actual time=0.041..0.041 rows=0 loops=326,699)

  • Output: upper(tsapprovalrequestkeyvalue154.uri)
  • Inner Unique: true
  • Buffers: shared hit=980,097
351. 0.000 13,067.960 ↓ 0.0 0 326,699

Nested Loop (cost=1.38..7.72 rows=1 width=84) (actual time=0.040..0.040 rows=0 loops=326,699)

  • Output: tsapprovalrequestkeyvalue154.uri, tsapprovalrequestkeyvalue154.parentid
  • Inner Unique: true
  • Buffers: shared hit=980,097
352. 0.000 13,067.960 ↓ 0.0 0 326,699

Nested Loop (cost=0.96..5.35 rows=1 width=100) (actual time=0.040..0.040 rows=0 loops=326,699)

  • Output: timesheetapprovalnodes156.timesheetid, tsapprovalrequestkeyvalue154.uri, tsapprovalrequestkeyvalue154.parentid
  • Inner Unique: true
  • Buffers: shared hit=980,097
353. 0.000 13,067.960 ↓ 0.0 0 326,699

Nested Loop (cost=0.69..3.88 rows=1 width=100) (actual time=0.040..0.040 rows=0 loops=326,699)

  • Output: tsapprovalrequest157.nodeid, tsapprovalrequestkeyvalue154.uri, tsapprovalrequestkeyvalue154.parentid
  • Inner Unique: true
  • Buffers: shared hit=980,097
354. 13,067.960 13,067.960 ↓ 0.0 0 326,699

Index Scan using ixtsarkvkey on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue154 (cost=0.41..1.43 rows=1 width=88) (actual time=0.040..0.040 rows=0 loops=326,699)

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

Index Scan using tsapprovalrequest_pkey on assuredpartnersincdemo.tsapprovalrequest tsapprovalrequest157 (cost=0.28..2.29 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest157.id, tsapprovalrequest157.effectivedateutc, tsapprovalrequest157.userid, tsapprovalrequest157.nodeid, tsapprovalrequest157.remindersentutc, tsapprovalrequest157.overduesentutc, tsapprovalrequest157.waitingbatchsentutc, tsapprovalrequest157.approvalagenttype, tsapprovalrequest157.systemprocessidentifier
  • Index Cond: (tsapprovalrequest157.id = tsapprovalrequestkeyvalue154.tsapprovalrequestid)
  • Filter: (tsapprovalrequest157.userid = 6,186)
356. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on assuredpartnersincdemo.timesheetapprovalnodes timesheetapprovalnodes156 (cost=0.28..1.46 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes156.id, timesheetapprovalnodes156.timesheetid, timesheetapprovalnodes156.approverrole, timesheetapprovalnodes156.userid, timesheetapprovalnodes156.isapproved, timesheetapprovalnodes156.systemprocessidentifier, timesheetapprovalnodes156.scriptid, timesheetapprovalnodes156.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes156.id = tsapprovalrequest157.nodeid)
357. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on assuredpartnersincdemo.timesheet timesheet155 (cost=0.42..1.98 rows=1 width=16) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on assuredpartnersincdemo.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue158 (cost=0.29..2.30 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue158.id, tsapprovalrequestkeyvalue158.tsapprovalrequestid, tsapprovalrequestkeyvalue158.parentid, tsapprovalrequestkeyvalue158.index, tsapprovalrequestkeyvalue158.key, tsapprovalrequestkeyvalue158.uri, tsapprovalrequestkeyvalue158.slug, tsapprovalrequestkeyvalue158."boolean", tsapprovalrequestkeyvalue158.date, tsapprovalrequestkeyvalue158.number, tsapprovalrequestkeyvalue158.text, tsapprovalrequestkeyvalue158."time", tsapprovalrequestkeyvalue158.timespan, tsapprovalrequestkeyvalue158.daterange_startdate, tsapprovalrequestkeyvalue158.daterange_enddate, tsapprovalrequestkeyvalue158.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue158.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue158.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue158.workdayduration_workdays, tsapprovalrequestkeyvalue158.workdayduration_hours, tsapprovalrequestkeyvalue158.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue158.id = tsapprovalrequestkeyvalue154.parentid)
  • Filter: (tsapprovalrequestkeyvalue158.parentid IS NULL)
359. 0.000 2,613.592 ↓ 0.0 0 326,699

Nested Loop (cost=4.14..81.20 rows=1 width=32) (actual time=0.008..0.008 rows=0 loops=326,699)

  • Output: upper(heetapprovalhistorykeyvalue159.uri)
  • Buffers: shared hit=2,195,108
360. 0.000 2,613.592 ↓ 0.0 0 326,699

Nested Loop (cost=3.71..80.62 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=326,699)

  • Output: heetapprovalhistorykeyvalue167.id
  • Buffers: shared hit=2,195,108
361. 326.699 2,613.592 ↓ 0.0 0 326,699

Nested Loop (cost=3.27..75.09 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=326,699)

  • Output: heetapprovalhistorykeyvalue166.id
  • Buffers: shared hit=2,195,108
362. 0.000 2,286.893 ↓ 0.0 0 326,699

Nested Loop (cost=2.83..74.52 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=326,699)

  • Output: heetapprovalhistorykeyvalue165.id
  • Buffers: shared hit=2,195,108
363. 0.000 2,286.893 ↓ 0.0 0 326,699

Nested Loop (cost=2.40..73.20 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=326,699)

  • Output: heetapprovalhistorykeyvalue164.id
  • Buffers: shared hit=2,195,108
364. 0.000 2,286.893 ↓ 0.0 0 326,699

Nested Loop (cost=1.97..71.09 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=326,699)

  • Output: heetapprovalhistorykeyvalue163.parentid
  • Inner Unique: true
  • Buffers: shared hit=2,195,108
365. 325.022 2,286.893 ↓ 0.0 0 326,699

Nested Loop (cost=1.41..68.57 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=326,699)

  • Output: heetapprovalhistorykeyvalue162.parentid
  • Buffers: shared hit=2,195,108
366. 122.614 1,960.194 ↓ 0.0 0 326,699

Nested Loop (cost=0.84..39.20 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=326,699)

  • Output: timesheetapprovalhistory161.id
  • Buffers: shared hit=2,194,854
367. 1,306.796 1,306.796 ↑ 7.0 1 326,699

Index Scan using ixtsuseridstartdateenddate on assuredpartnersincdemo.timesheet timesheet160 (cost=0.42..7.73 rows=7 width=16) (actual time=0.003..0.004 rows=1 loops=326,699)

  • Output: timesheet160.id, timesheet160.userid, timesheet160.startdate, timesheet160.enddate, timesheet160.approvalstatus, timesheet160.duedate, timesheet160.autosubmitdatetimeutc, timesheet160.lastautosubmitattemptdatetimeutc, timesheet160.createdonutc
  • Index Cond: ((timesheet160.userid = timeoffs130.userid) AND (timeoffs130.enddate >= timesheet160.startdate) AND (timeoffs130.startdate <= timesheet160.enddate))
  • Buffers: shared hit=1,275,839
368. 530.784 530.784 ↓ 0.0 0 176,928

Index Scan using ixtah2timesheetid on assuredpartnersincdemo.timesheetapprovalhistory timesheetapprovalhistory161 (cost=0.42..4.48 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=176,928)

  • Output: timesheetapprovalhistory161.id, timesheetapprovalhistory161.timesheetid, timesheetapprovalhistory161.action, timesheetapprovalhistory161.approvalcomments, timesheetapprovalhistory161.timestamputc, timesheetapprovalhistory161.serialnumber, timesheetapprovalhistory161.approvalagenttype, timesheetapprovalhistory161.userid, timesheetapprovalhistory161.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory161.timesheetid = timesheet160.id)
  • Filter: (timesheetapprovalhistory161.userid = 6,186)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=919,015
369. 1.677 1.677 ↓ 0.0 0 43

Index Scan using ixtahkvtimesheetapprovalhistoryid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue162 (cost=0.56..29.36 rows=1 width=32) (actual time=0.039..0.039 rows=0 loops=43)

  • Output: heetapprovalhistorykeyvalue162.id, heetapprovalhistorykeyvalue162.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue162.parentid, heetapprovalhistorykeyvalue162.index, heetapprovalhistorykeyvalue162.key, heetapprovalhistorykeyvalue162.uri, heetapprovalhistorykeyvalue162.slug, heetapprovalhistorykeyvalue162."boolean", heetapprovalhistorykeyvalue162.date, heetapprovalhistorykeyvalue162.number, heetapprovalhistorykeyvalue162.text, heetapprovalhistorykeyvalue162."time", heetapprovalhistorykeyvalue162.timespan, heetapprovalhistorykeyvalue162.daterange_startdate, heetapprovalhistorykeyvalue162.daterange_enddate, heetapprovalhistorykeyvalue162.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue162.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue162.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue162.workdayduration_workdays, heetapprovalhistorykeyvalue162.workdayduration_hours, heetapprovalhistorykeyvalue162.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue162.timesheetapprovalhistoryid = timesheetapprovalhistory161.id)
  • Filter: ((upper(heetapprovalhistorykeyvalue162.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(heetapprovalhistorykeyvalue162.uri) = 'URN:REPLICON-TENANT:ASSURED-PARTNERS-INCDEMO:USER:6,186'::text))
  • Rows Removed by Filter: 19
  • Buffers: shared hit=254
370. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue163 (cost=0.56..2.52 rows=1 width=32) (never executed)

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

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

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue165 (cost=0.43..1.28 rows=4 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue166 (cost=0.43..0.56 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue167 (cost=0.43..5.50 rows=4 width=32) (never executed)

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

Index Scan using ixtahkvparentid on assuredpartnersincdemo.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue159 (cost=0.43..0.54 rows=4 width=87) (never executed)

  • Output: heetapprovalhistorykeyvalue159.id, heetapprovalhistorykeyvalue159.timesheetapprovalhistoryid, heetapprovalhistorykeyvalue159.parentid, heetapprovalhistorykeyvalue159.index, heetapprovalhistorykeyvalue159.key, heetapprovalhistorykeyvalue159.uri, heetapprovalhistorykeyvalue159.slug, heetapprovalhistorykeyvalue159."boolean", heetapprovalhistorykeyvalue159.date, heetapprovalhistorykeyvalue159.number, heetapprovalhistorykeyvalue159.text, heetapprovalhistorykeyvalue159."time", heetapprovalhistorykeyvalue159.timespan, heetapprovalhistorykeyvalue159.daterange_startdate, heetapprovalhistorykeyvalue159.daterange_enddate, heetapprovalhistorykeyvalue159.daterange_relativedaterangeuri, heetapprovalhistorykeyvalue159.daterange_relativedaterangeasofdate, heetapprovalhistorykeyvalue159.workdayduration_decimalworkdays, heetapprovalhistorykeyvalue159.workdayduration_workdays, heetapprovalhistorykeyvalue159.workdayduration_hours, heetapprovalhistorykeyvalue159.workdayduration_minutes
  • Index Cond: (heetapprovalhistorykeyvalue159.parentid = heetapprovalhistorykeyvalue167.id)
376. 46,680.206 46,680.264 ↑ 205,013.0 1 1

Result (cost=0.69..10,738.88 rows=205,013 width=32) (actual time=46,680.264..46,680.264 rows=1 loops=1)

  • Output: $59, $123, $185, $245
  • Buffers: shared hit=15,651,474
377. 0.000 0.058 ↑ 205,013.0 1 1

Append (cost=0.69..8,688.75 rows=205,013 width=0) (actual time=0.058..0.058 rows=1 loops=1)

  • Buffers: shared hit=9
378. 0.001 0.058 ↑ 204,943.0 1 1

Subquery Scan on *SELECT* 1 (cost=0.69..8,631.35 rows=204,943 width=0) (actual time=0.057..0.058 rows=1 loops=1)

  • Buffers: shared hit=9
379. 0.001 0.057 ↑ 204,943.0 1 1

Merge Anti Join (cost=0.69..6,581.92 rows=204,943 width=1,553) (actual time=0.057..0.057 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=9
380. 0.038 0.038 ↑ 205,013.0 1 1

Index Only Scan using dm_timeofflist_facts_pkey on assuredpartnersincdemo.dm_timeofflist_facts (cost=0.42..6,038.61 rows=205,013 width=4) (actual time=0.038..0.038 rows=1 loops=1)

  • Output: dm_timeofflist_facts.timeoffid
  • Heap Fetches: 1
  • Buffers: shared hit=5
381. 0.018 0.018 ↑ 70.0 1 1

Index Only Scan using dm_timeofflist_realtime_facts_pkey on assuredpartnersincdemo.dm_timeofflist_realtime_facts (cost=0.27..30.33 rows=70 width=4) (actual time=0.018..0.018 rows=1 loops=1)

  • Output: dm_timeofflist_realtime_facts.timeoffid
  • Heap Fetches: 1
  • Buffers: shared hit=4
382. 0.000 0.000 ↓ 0.0 0

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

383. 0.000 0.000 ↓ 0.0 0

Seq Scan on assuredpartnersincdemo.dm_timeofflist_realtime_facts dm_timeofflist_realtime_facts_1 (cost=0.00..56.70 rows=70 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 : 100.133 ms
Execution time : 46,684.305 ms