explain.depesz.com

PostgreSQL's explain analyze made readable

Result: enq2 : after_analyze

Settings
# exclusive inclusive rows x rows loops node
1. 42.142 445,945.281 ↑ 8.7 7 1

Seq Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.departments departments0 (cost=1,986,686,589.16..1,986,686,592.38 rows=61 width=122) (actual time=439,673.437..445,945.281 rows=7 loops=1)

  • Output: departments0.id, departments0.code
  • Filter: ((hashed SubPlan 18) OR (hashed SubPlan 27))
  • Rows Removed by Filter: 74
  • Buffers: shared hit=332,054,245 read=52
2.          

SubPlan (for Seq Scan)

3. 28.162 439,632.550 ↑ 13.0 133,564 1

Hash Join (cost=1,980,185,664.31..1,980,467,187.93 rows=1,732,194 width=4) (actual time=438,930.112..439,632.550 rows=133,564 loops=1)

  • Output: departmentusers1.departmentid
  • Hash Cond: (timeentry2.userid = departmentusers1.userid)
  • Buffers: shared hit=326,011,357
4. 452.755 439,604.234 ↑ 13.0 133,564 1

Hash Semi Join (cost=1,980,185,646.90..1,980,443,352.85 rows=1,732,194 width=4) (actual time=438,929.945..439,604.234 rows=133,564 loops=1)

  • Output: timeentry2.userid
  • Hash Cond: (timeentry2.id = timeentryrevision3.timeentryid)
  • Buffers: shared hit=326,011,353
5. 235.675 235.675 ↑ 1.0 2,233,521 1

Seq Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeentry timeentry2 (cost=0.00..44,196.21 rows=2,233,521 width=20) (actual time=0.004..235.675 rows=2,233,521 loops=1)

  • Output: timeentry2.id, timeentry2.userid, timeentry2.entrydate, timeentry2.timeallocationtype, timeentry2.hours, timeentry2.intime, timeentry2.outtime, timeentry2.approvalstatus
  • Buffers: shared hit=21,861
6. 89.302 438,915.804 ↑ 16.6 133,564 1

Hash (cost=1,980,157,903.67..1,980,157,903.67 rows=2,219,458 width=16) (actual time=438,915.804..438,915.804 rows=133,564 loops=1)

  • Output: timeentryrevision3.timeentryid
  • Buckets: 4,194,304 Batches: 1 Memory Usage: 39,029kB
  • Buffers: shared hit=325,989,492
7. 314.381 438,826.502 ↑ 16.6 133,564 1

Merge Join (cost=16,950.73..1,980,157,903.67 rows=2,219,458 width=16) (actual time=359.130..438,826.502 rows=133,564 loops=1)

  • Output: timeentryrevision3.timeentryid
  • Inner Unique: true
  • Merge Cond: (timeentryrevision3.id = timeentryrevision4.id)
  • Buffers: shared hit=325,989,492
8. 2,628.349 2,628.349 ↓ 1.0 2,233,517 1

Index Scan using timeentryrevision_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeentryrevision timeentryrevision3 (cost=0.43..157,678.64 rows=2,233,040 width=32) (actual time=0.037..2,628.349 rows=2,233,517 loops=1)

  • Output: timeentryrevision3.id, timeentryrevision3.txid, timeentryrevision3.previousrevisionid, timeentryrevision3.timeentryid, timeentryrevision3.fromtimestamputc, timeentryrevision3.totimestamputc, timeentryrevision3.openingauditid, timeentryrevision3.closingauditid, timeentryrevision3.userid, timeentryrevision3.entrydate, timeentryrevision3.timeallocationtype, timeentryrevision3.hours, timeentryrevision3.intime, timeentryrevision3.outtime, timeentryrevision3.approvalstatus
  • Filter: (timeentryrevision3.totimestamputc IS NULL)
  • Rows Removed by Filter: 1,791,090
  • Buffers: shared hit=31,574
9. 14,366.448 435,883.772 ↑ 13.5 296,648 1

Index Scan using timeentryrevision_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeentryrevision timeentryrevision4 (cost=16,950.30..1,979,962,447.51 rows=4,000,136 width=16) (actual time=357.999..435,883.772 rows=296,648 loops=1)

  • Output: timeentryrevision4.id, timeentryrevision4.txid, timeentryrevision4.previousrevisionid, timeentryrevision4.timeentryid, timeentryrevision4.fromtimestamputc, timeentryrevision4.totimestamputc, timeentryrevision4.openingauditid, timeentryrevision4.closingauditid, timeentryrevision4.userid, timeentryrevision4.entrydate, timeentryrevision4.timeallocationtype, timeentryrevision4.hours, timeentryrevision4.intime, timeentryrevision4.outtime, timeentryrevision4.approvalstatus
  • Filter: ((hashed SubPlan 1) OR (timeentryrevision4.userid = 448) OR (alternatives: SubPlan 2 or hashed SubPlan 3) OR (SubPlan 4) OR (SubPlan 5) OR (SubPlan 6) OR (SubPlan 7) OR ((SubPlan 10) AND ((SubPlan 11) OR (SubPlan 12))) OR ((SubPlan 15) AND ((SubPlan 16) OR (SubPlan 17))))
  • Rows Removed by Filter: 3,727,966
  • Buffers: shared hit=325,957,918
10.          

SubPlan (for Index Scan)

11. 37.877 257.041 ↑ 2.0 296,674 1

Nested Loop (cost=0.99..15,457.83 rows=596,819 width=16) (actual time=0.103..257.041 rows=296,674 loops=1)

  • Output: timeentryrevision5.id
  • Buffers: shared hit=120,472
12. 1.382 6.966 ↓ 17.9 9,226 1

Nested Loop (cost=0.56..251.06 rows=514 width=16) (actual time=0.084..6.966 rows=9,226 loops=1)

  • Output: timesheet6.userid, timesheet6.startdate, timesheet6.enddate, userdivision7.userid
  • Buffers: shared hit=2,400
13. 0.590 1.336 ↓ 1.6 72 1

Nested Loop Semi Join (cost=0.14..157.10 rows=46 width=12) (actual time=0.051..1.336 rows=72 loops=1)

  • Output: userdivision7.userid, userdivision7.startdate, userdivision7.enddate
  • Buffers: shared hit=1,324
14. 0.089 0.089 ↑ 1.0 657 1

Seq Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.userdivision userdivision7 (cost=0.00..13.57 rows=657 width=28) (actual time=0.008..0.089 rows=657 loops=1)

  • Output: userdivision7.id, userdivision7.userid, userdivision7.divisionid, userdivision7.startdate, userdivision7.enddate
  • Buffers: shared hit=7
15. 0.657 0.657 ↓ 0.0 0 657

Index Scan using ixdivfhchildid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.divisionflathierarchy divisionflathierarchy8 (cost=0.14..0.22 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=657)

  • Output: divisionflathierarchy8.parentid, divisionflathierarchy8.childid, divisionflathierarchy8.parentdepth
  • Index Cond: (divisionflathierarchy8.childid = userdivision7.divisionid)
  • Filter: (divisionflathierarchy8.parentid = ANY ('{74109090-f971-4801-a053-8ce5745ff9e0,8326b382-e091-4fbf-8945-011b6c06e3be,cb54296c-470e-40ea-83f2-0e56c73bcb33,5469deb2-efa1-46da-8ff2-acd7ba27b1eb}'::uuid[]))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=1,317
16. 4.248 4.248 ↓ 10.7 128 72

Index Only Scan using ixtsuseridstartdateenddate on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet6 (cost=0.41..1.92 rows=12 width=12) (actual time=0.008..0.059 rows=128 loops=72)

  • Output: timesheet6.userid, timesheet6.startdate, timesheet6.enddate
  • Index Cond: ((timesheet6.userid = userdivision7.userid) AND (timesheet6.startdate <= userdivision7.enddate) AND (timesheet6.enddate >= userdivision7.startdate))
  • Heap Fetches: 3,763
  • Buffers: shared hit=1,076
17. 212.198 212.198 ↑ 26.6 32 9,226

Index Scan using ixter2userid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeentryrevision timeentryrevision5 (cost=0.43..21.07 rows=852 width=24) (actual time=0.004..0.023 rows=32 loops=9,226)

  • Output: timeentryrevision5.id, timeentryrevision5.txid, timeentryrevision5.previousrevisionid, timeentryrevision5.timeentryid, timeentryrevision5.fromtimestamputc, timeentryrevision5.totimestamputc, timeentryrevision5.openingauditid, timeentryrevision5.closingauditid, timeentryrevision5.userid, timeentryrevision5.entrydate, timeentryrevision5.timeallocationtype, timeentryrevision5.hours, timeentryrevision5.intime, timeentryrevision5.outtime, timeentryrevision5.approvalstatus
  • Index Cond: ((timeentryrevision5.userid = timesheet6.userid) AND (timesheet6.startdate <= timeentryrevision5.entrydate) AND (timesheet6.enddate >= timeentryrevision5.entrydate))
  • Buffers: shared hit=118,072
18. 0.000 0.000 ↓ 0.0 0

Index Scan using ix3uh_usersuperstart on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.userhierarchy userhierarchy9 (cost=0.28..2.30 rows=1 width=0) (never executed)

  • Index Cond: ((userhierarchy9.userid = timeentryrevision4.userid) AND (userhierarchy9.supervisorid = 448) AND (userhierarchy9.startdate <= '2020-06-26'::date))
  • Filter: (userhierarchy9.enddate >= '2020-06-26'::date)
19. 0.029 0.029 ↓ 1.1 9 1

Index Scan using ixuhsupervisorid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.userhierarchy userhierarchy9_1 (cost=0.28..7.32 rows=8 width=4) (actual time=0.023..0.029 rows=9 loops=1)

  • Output: userhierarchy9_1.userid
  • Index Cond: (userhierarchy9_1.supervisorid = 448)
  • Filter: ((userhierarchy9_1.startdate <= '2020-06-26'::date) AND (userhierarchy9_1.enddate >= '2020-06-26'::date))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=7
20. 0.000 104,383.048 ↓ 0.0 0 3,727,966

Nested Loop (cost=1.54..37.95 rows=1 width=32) (actual time=0.028..0.028 rows=0 loops=3,727,966)

  • Output: upper(tsapprovalrequestkeyvalue10.uri)
  • Inner Unique: true
  • Buffers: shared hit=186,398,300
21. 0.000 104,383.048 ↓ 0.0 0 3,727,966

Nested Loop (cost=1.26..34.22 rows=11 width=83) (actual time=0.028..0.028 rows=0 loops=3,727,966)

  • Output: tsapprovalrequestkeyvalue10.uri, tsapprovalrequestkeyvalue10.parentid
  • Buffers: shared hit=186,398,300
22. 3,727.966 104,383.048 ↓ 0.0 0 3,727,966

Nested Loop (cost=0.97..25.12 rows=1 width=4) (actual time=0.028..0.028 rows=0 loops=3,727,966)

  • Output: tsapprovalrequest13.id
  • Inner Unique: true
  • Buffers: shared hit=186,398,300
23. 18,639.830 55,919.490 ↑ 1.0 6 3,727,966

Nested Loop (cost=0.56..20.74 rows=6 width=20) (actual time=0.003..0.015 rows=6 loops=3,727,966)

  • Output: timesheetapprovalnodes12.timesheetid, tsapprovalrequest13.id
  • Inner Unique: true
  • Buffers: shared hit=96,927,116
24. 14,911.864 14,911.864 ↑ 1.0 6 3,727,966

Index Scan using uix2tsar_nodeid_userid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequest tsapprovalrequest13 (cost=0.28..6.95 rows=6 width=20) (actual time=0.001..0.004 rows=6 loops=3,727,966)

  • Output: tsapprovalrequest13.id, tsapprovalrequest13.nodeid, tsapprovalrequest13.effectivedateutc, tsapprovalrequest13.remindersentutc, tsapprovalrequest13.overduesentutc, tsapprovalrequest13.waitingbatchsentutc, tsapprovalrequest13.approvalagenttype, tsapprovalrequest13.userid, tsapprovalrequest13.systemprocessidentifier
  • Index Cond: (tsapprovalrequest13.userid = 448)
  • Buffers: shared hit=29,823,728
25. 22,367.796 22,367.796 ↑ 1.0 1 22,367,796

Index Scan using timesheetapprovalnodes_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalnodes timesheetapprovalnodes12 (cost=0.28..2.30 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=22,367,796)

  • Output: timesheetapprovalnodes12.id, timesheetapprovalnodes12.timesheetid, timesheetapprovalnodes12.isapproved, timesheetapprovalnodes12.approverrole, timesheetapprovalnodes12.userid, timesheetapprovalnodes12.systemprocessidentifier, timesheetapprovalnodes12.scriptid, timesheetapprovalnodes12.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes12.id = tsapprovalrequest13.nodeid)
  • Buffers: shared hit=67,103,388
26. 44,735.592 44,735.592 ↓ 0.0 0 22,367,796

Index Scan using timesheet_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet11 (cost=0.41..0.72 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=22,367,796)

  • Output: timesheet11.id, timesheet11.userid, timesheet11.startdate, timesheet11.enddate, timesheet11.approvalstatus, timesheet11.duedate, timesheet11.autosubmitdatetimeutc, timesheet11.lastautosubmitattemptdatetimeutc, timesheet11.createdonutc
  • Index Cond: (timesheet11.id = timesheetapprovalnodes12.timesheetid)
  • Filter: ((timesheet11.startdate <= timeentryrevision4.entrydate) AND (timesheet11.enddate >= timeentryrevision4.entrydate) AND (timesheet11.userid = timeentryrevision4.userid))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=89,471,184
27. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue10 (cost=0.29..9.00 rows=11 width=87) (never executed)

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

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

  • Output: tsapprovalrequestkeyvalue14.id, tsapprovalrequestkeyvalue14.tsapprovalrequestid, tsapprovalrequestkeyvalue14.parentid, tsapprovalrequestkeyvalue14.index, tsapprovalrequestkeyvalue14.key, tsapprovalrequestkeyvalue14.uri, tsapprovalrequestkeyvalue14.slug, tsapprovalrequestkeyvalue14."boolean", tsapprovalrequestkeyvalue14.date, tsapprovalrequestkeyvalue14.number, tsapprovalrequestkeyvalue14.text, tsapprovalrequestkeyvalue14."time", tsapprovalrequestkeyvalue14.timespan, tsapprovalrequestkeyvalue14.daterange_startdate, tsapprovalrequestkeyvalue14.daterange_enddate, tsapprovalrequestkeyvalue14.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue14.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue14.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue14.workdayduration_workdays, tsapprovalrequestkeyvalue14.workdayduration_hours, tsapprovalrequestkeyvalue14.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue14.id = tsapprovalrequestkeyvalue10.parentid)
  • Filter: (tsapprovalrequestkeyvalue14.parentid IS NULL)
29. 0.000 48,463.558 ↓ 0.0 0 3,727,966

Nested Loop (cost=15.53..89.60 rows=1 width=32) (actual time=0.013..0.013 rows=0 loops=3,727,966)

  • Output: upper(sheetapprovalhistorykeyvalue15.uri)
  • Buffers: shared hit=39,858,261
30. 0.000 48,463.558 ↓ 0.0 0 3,727,966

Nested Loop (cost=15.10..89.05 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue23.id
  • Buffers: shared hit=39,858,261
31. 0.000 48,463.558 ↓ 0.0 0 3,727,966

Nested Loop (cost=14.67..87.50 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue22.id
  • Buffers: shared hit=39,858,261
32. 0.000 48,463.558 ↓ 0.0 0 3,727,966

Nested Loop (cost=14.24..86.96 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue21.id
  • Buffers: shared hit=39,858,261
33. 3,727.966 48,463.558 ↓ 0.0 0 3,727,966

Nested Loop (cost=13.81..85.44 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue20.id
  • Buffers: shared hit=39,858,261
34. 0.000 44,735.592 ↓ 0.0 0 3,727,966

Nested Loop (cost=13.38..83.07 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue19.parentid
  • Inner Unique: true
  • Buffers: shared hit=39,858,261
35. 0.000 44,735.592 ↓ 0.0 0 3,727,966

Nested Loop (cost=12.95..80.62 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue18.parentid
  • Buffers: shared hit=39,858,261
36. 3,899.651 44,735.592 ↓ 0.0 0 3,727,966

Nested Loop (cost=0.83..67.48 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=3,727,966)

  • Output: timesheetapprovalhistory17.id
  • Buffers: shared hit=39,858,261
37. 22,367.796 22,367.796 ↑ 12.0 1 3,727,966

Index Scan using ixtsuseridstartdateenddate on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet16 (cost=0.41..13.60 rows=12 width=16) (actual time=0.006..0.006 rows=1 loops=3,727,966)

  • Output: timesheet16.id, timesheet16.userid, timesheet16.startdate, timesheet16.enddate, timesheet16.approvalstatus, timesheet16.duedate, timesheet16.autosubmitdatetimeutc, timesheet16.lastautosubmitattemptdatetimeutc, timesheet16.createdonutc
  • Index Cond: ((timesheet16.userid = timeentryrevision4.userid) AND (timesheet16.startdate <= timeentryrevision4.entrydate) AND (timesheet16.enddate >= timeentryrevision4.entrydate))
  • Buffers: shared hit=19,763,251
38. 18,468.145 18,468.145 ↓ 0.0 0 3,693,629

Index Scan using ixtah2timesheetid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistory timesheetapprovalhistory17 (cost=0.42..4.48 rows=1 width=32) (actual time=0.005..0.005 rows=0 loops=3,693,629)

  • Output: timesheetapprovalhistory17.id, timesheetapprovalhistory17.serialnumber, timesheetapprovalhistory17.timesheetid, timesheetapprovalhistory17.action, timesheetapprovalhistory17.approvalcomments, timesheetapprovalhistory17.timestamputc, timesheetapprovalhistory17.approvalagenttype, timesheetapprovalhistory17.userid, timesheetapprovalhistory17.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory17.timesheetid = timesheet16.id)
  • Filter: (timesheetapprovalhistory17.userid = 448)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=20,095,010
39. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue18 (cost=12.11..13.13 rows=1 width=32) (never executed)

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

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

41. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (sheetapprovalhistorykeyvalue18.timesheetapprovalhistoryid = timesheetapprovalhistory17.id)
42. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (upper(sheetapprovalhistorykeyvalue18.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text)
43. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue19 (cost=0.43..2.45 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue20 (cost=0.43..2.36 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue21 (cost=0.43..1.49 rows=3 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue22 (cost=0.43..0.53 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue23 (cost=0.43..1.53 rows=3 width=32) (never executed)

  • 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)
48. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue15 (cost=0.43..0.52 rows=3 width=87) (never executed)

  • Output: sheetapprovalhistorykeyvalue15.id, sheetapprovalhistorykeyvalue15.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue15.parentid, sheetapprovalhistorykeyvalue15.index, sheetapprovalhistorykeyvalue15.key, sheetapprovalhistorykeyvalue15.uri, sheetapprovalhistorykeyvalue15.slug, sheetapprovalhistorykeyvalue15."boolean", sheetapprovalhistorykeyvalue15.date, sheetapprovalhistorykeyvalue15.number, sheetapprovalhistorykeyvalue15.text, sheetapprovalhistorykeyvalue15."time", sheetapprovalhistorykeyvalue15.timespan, sheetapprovalhistorykeyvalue15.daterange_startdate, sheetapprovalhistorykeyvalue15.daterange_enddate, sheetapprovalhistorykeyvalue15.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue15.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue15.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue15.workdayduration_workdays, sheetapprovalhistorykeyvalue15.workdayduration_hours, sheetapprovalhistorykeyvalue15.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue15.parentid = sheetapprovalhistorykeyvalue23.id)
49. 3,727.966 130,478.810 ↓ 0.0 0 3,727,966

Nested Loop (cost=1.67..9.68 rows=1 width=32) (actual time=0.035..0.035 rows=0 loops=3,727,966)

  • Output: upper(tsapprovalrequestkeyvalue24.uri)
  • Inner Unique: true
  • Buffers: shared hit=11,183,898
50. 0.000 126,750.844 ↓ 0.0 0 3,727,966

Nested Loop (cost=1.38..7.37 rows=1 width=83) (actual time=0.034..0.034 rows=0 loops=3,727,966)

  • Output: tsapprovalrequestkeyvalue24.uri, tsapprovalrequestkeyvalue24.parentid
  • Inner Unique: true
  • Buffers: shared hit=11,183,898
51. 0.000 126,750.844 ↓ 0.0 0 3,727,966

Nested Loop (cost=0.97..6.60 rows=1 width=99) (actual time=0.034..0.034 rows=0 loops=3,727,966)

  • Output: timesheetapprovalnodes26.timesheetid, tsapprovalrequestkeyvalue24.uri, tsapprovalrequestkeyvalue24.parentid
  • Inner Unique: true
  • Buffers: shared hit=11,183,898
52. 0.000 126,750.844 ↓ 0.0 0 3,727,966

Nested Loop (cost=0.69..4.30 rows=1 width=99) (actual time=0.034..0.034 rows=0 loops=3,727,966)

  • Output: tsapprovalrequest27.nodeid, tsapprovalrequestkeyvalue24.uri, tsapprovalrequestkeyvalue24.parentid
  • Inner Unique: true
  • Buffers: shared hit=11,183,898
53. 126,750.844 126,750.844 ↓ 0.0 0 3,727,966

Index Scan using ixtsarkvkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue24 (cost=0.41..1.43 rows=1 width=87) (actual time=0.034..0.034 rows=0 loops=3,727,966)

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

Index Scan using tsapprovalrequest_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequest tsapprovalrequest27 (cost=0.28..2.30 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest27.id, tsapprovalrequest27.nodeid, tsapprovalrequest27.effectivedateutc, tsapprovalrequest27.remindersentutc, tsapprovalrequest27.overduesentutc, tsapprovalrequest27.waitingbatchsentutc, tsapprovalrequest27.approvalagenttype, tsapprovalrequest27.userid, tsapprovalrequest27.systemprocessidentifier
  • Index Cond: (tsapprovalrequest27.id = tsapprovalrequestkeyvalue24.tsapprovalrequestid)
  • Filter: (tsapprovalrequest27.userid = 448)
55. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using timesheet_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet25 (cost=0.41..0.72 rows=1 width=16) (never executed)

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

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

  • Output: tsapprovalrequestkeyvalue28.id, tsapprovalrequestkeyvalue28.tsapprovalrequestid, tsapprovalrequestkeyvalue28.parentid, tsapprovalrequestkeyvalue28.index, tsapprovalrequestkeyvalue28.key, tsapprovalrequestkeyvalue28.uri, tsapprovalrequestkeyvalue28.slug, tsapprovalrequestkeyvalue28."boolean", tsapprovalrequestkeyvalue28.date, tsapprovalrequestkeyvalue28.number, tsapprovalrequestkeyvalue28.text, tsapprovalrequestkeyvalue28."time", tsapprovalrequestkeyvalue28.timespan, tsapprovalrequestkeyvalue28.daterange_startdate, tsapprovalrequestkeyvalue28.daterange_enddate, tsapprovalrequestkeyvalue28.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue28.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue28.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue28.workdayduration_workdays, tsapprovalrequestkeyvalue28.workdayduration_hours, tsapprovalrequestkeyvalue28.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue28.id = tsapprovalrequestkeyvalue24.parentid)
  • Filter: (tsapprovalrequestkeyvalue28.parentid IS NULL)
58. 3,727.966 37,279.660 ↓ 0.0 0 3,727,966

Nested Loop (cost=15.53..92.52 rows=1 width=32) (actual time=0.010..0.010 rows=0 loops=3,727,966)

  • Output: upper(sheetapprovalhistorykeyvalue29.uri)
  • Buffers: shared hit=39,858,261
59. 0.000 33,551.694 ↓ 0.0 0 3,727,966

Nested Loop (cost=15.10..91.98 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue37.id
  • Buffers: shared hit=39,858,261
60. 0.000 33,551.694 ↓ 0.0 0 3,727,966

Nested Loop (cost=14.67..87.50 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue36.id
  • Buffers: shared hit=39,858,261
61. 0.000 33,551.694 ↓ 0.0 0 3,727,966

Nested Loop (cost=14.24..86.96 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue35.id
  • Buffers: shared hit=39,858,261
62. 0.000 33,551.694 ↓ 0.0 0 3,727,966

Nested Loop (cost=13.81..85.44 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue34.id
  • Buffers: shared hit=39,858,261
63. 3,727.966 33,551.694 ↓ 0.0 0 3,727,966

Nested Loop (cost=13.38..83.07 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue33.parentid
  • Inner Unique: true
  • Buffers: shared hit=39,858,261
64. 0.000 29,823.728 ↓ 0.0 0 3,727,966

Nested Loop (cost=12.95..80.62 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue32.parentid
  • Buffers: shared hit=39,858,261
65. 3,830.977 29,823.728 ↓ 0.0 0 3,727,966

Nested Loop (cost=0.83..67.48 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=3,727,966)

  • Output: timesheetapprovalhistory31.id
  • Buffers: shared hit=39,858,261
66. 14,911.864 14,911.864 ↑ 12.0 1 3,727,966

Index Scan using ixtsuseridstartdateenddate on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet30 (cost=0.41..13.60 rows=12 width=16) (actual time=0.004..0.004 rows=1 loops=3,727,966)

  • Output: timesheet30.id, timesheet30.userid, timesheet30.startdate, timesheet30.enddate, timesheet30.approvalstatus, timesheet30.duedate, timesheet30.autosubmitdatetimeutc, timesheet30.lastautosubmitattemptdatetimeutc, timesheet30.createdonutc
  • Index Cond: ((timesheet30.userid = timeentryrevision4.userid) AND (timesheet30.startdate <= timeentryrevision4.entrydate) AND (timesheet30.enddate >= timeentryrevision4.entrydate))
  • Buffers: shared hit=19,763,251
67. 11,080.887 11,080.887 ↓ 0.0 0 3,693,629

Index Scan using ixtah2timesheetid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistory timesheetapprovalhistory31 (cost=0.42..4.48 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=3,693,629)

  • Output: timesheetapprovalhistory31.id, timesheetapprovalhistory31.serialnumber, timesheetapprovalhistory31.timesheetid, timesheetapprovalhistory31.action, timesheetapprovalhistory31.approvalcomments, timesheetapprovalhistory31.timestamputc, timesheetapprovalhistory31.approvalagenttype, timesheetapprovalhistory31.userid, timesheetapprovalhistory31.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory31.timesheetid = timesheet30.id)
  • Filter: (timesheetapprovalhistory31.userid = 448)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=20,095,010
68. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue32 (cost=12.11..13.13 rows=1 width=32) (never executed)

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

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

70. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (upper(sheetapprovalhistorykeyvalue32.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text)
72. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue35 (cost=0.43..1.49 rows=3 width=32) (never executed)

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

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

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue37 (cost=0.43..4.45 rows=3 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)
77. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue29 (cost=0.43..0.52 rows=3 width=87) (never executed)

  • Output: sheetapprovalhistorykeyvalue29.id, sheetapprovalhistorykeyvalue29.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue29.parentid, sheetapprovalhistorykeyvalue29.index, sheetapprovalhistorykeyvalue29.key, sheetapprovalhistorykeyvalue29.uri, sheetapprovalhistorykeyvalue29.slug, sheetapprovalhistorykeyvalue29."boolean", sheetapprovalhistorykeyvalue29.date, sheetapprovalhistorykeyvalue29.number, sheetapprovalhistorykeyvalue29.text, sheetapprovalhistorykeyvalue29."time", sheetapprovalhistorykeyvalue29.timespan, sheetapprovalhistorykeyvalue29.daterange_startdate, sheetapprovalhistorykeyvalue29.daterange_enddate, sheetapprovalhistorykeyvalue29.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue29.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue29.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue29.workdayduration_workdays, sheetapprovalhistorykeyvalue29.workdayduration_hours, sheetapprovalhistorykeyvalue29.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue29.parentid = sheetapprovalhistorykeyvalue37.id)
78. 63,375.195 63,375.422 ↓ 0.0 0 3,727,966

Index Scan using ixtemrtimeentryid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeentrymetadatarevision timeentrymetadatarevision38 (cost=109.94..124.49 rows=1 width=0) (actual time=0.017..0.017 rows=0 loops=3,727,966)

  • Index Cond: (timeentrymetadatarevision38.timeentryid = timeentryrevision4.timeentryid)
  • Filter: ((timeentrymetadatarevision38.fromtimestamputc <= timeentryrevision4.fromtimestamputc) AND ((timeentrymetadatarevision38.totimestamputc > timeentryrevision4.fromtimestamputc) OR (timeentrymetadatarevision38.totimestamputc IS NULL)) AND (((upper(timeentrymetadatarevision38.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 8)) OR ((upper(timeentrymetadatarevision38.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 9))))
  • Rows Removed by Filter: 10
  • Buffers: shared hit=24,253,611
79.          

SubPlan (for Index Scan)

80. 0.057 0.057 ↑ 1.0 21 1

Index Scan using ixprjprojectleaderapproverid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.project project39 (cost=0.29..22.16 rows=21 width=32) (actual time=0.022..0.057 rows=21 loops=1)

  • Output: upper(('urn:replicon-tenant:cf6586b0d9db4b13bf8ea8c0e7ab5b1f:project:'::text || COALESCE((project39.id)::text, ''::text)))
  • Index Cond: (project39.projectleaderapproverid = 448)
  • Buffers: shared hit=32
81. 0.032 0.170 ↑ 1.3 30 1

Nested Loop (cost=0.57..87.07 rows=38 width=32) (actual time=0.039..0.170 rows=30 loops=1)

  • Output: upper(('urn:replicon-tenant:cf6586b0d9db4b13bf8ea8c0e7ab5b1f:task:'::text || COALESCE((task40.id)::text, ''::text)))
  • Buffers: shared hit=108
82. 0.054 0.054 ↑ 1.0 21 1

Index Scan using ixprjprojectleaderapproverid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.project project41 (cost=0.29..21.95 rows=21 width=4) (actual time=0.022..0.054 rows=21 loops=1)

  • Output: project41.id
  • Index Cond: (project41.projectleaderapproverid = 448)
  • Buffers: shared hit=32
83. 0.084 0.084 ↑ 2.0 1 21

Index Scan using ixtkprojectid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.task task40 (cost=0.29..3.06 rows=2 width=8) (actual time=0.003..0.004 rows=1 loops=21)

  • Output: task40.id, task40.projectid, task40.parentid, task40.name, task40.code, task40.description, task40.isclosed, task40.orderindex, task40.percentcomplete, task40.istimeentryallowed, task40.estimatedhours, task40.timeentrystartdate, task40.timeentryenddate, task40.estimatedexpenses, task40.estimatedexpensescurrencyid, task40.expenseentrystartdate, task40.expenseentryenddate, task40.costtype, task40.estimatedcost, task40.estimatedcostcurrencyid, task40.timeandexpenseentrytype, task40.info1, task40.info2, task40.info3, task40.info4, task40.info5, task40.info6, task40.info7, task40.info8, task40.info9, task40.info10, task40.info11, task40.info12, task40.info13, task40.info14, task40.info15, task40.info16, task40.info17, task40.info18, task40.info19, task40.info20, task40.closeddate
  • Index Cond: (task40.projectid = project41.id)
  • Buffers: shared hit=76
84. 0.001 0.063 ↓ 0.0 0 1

Nested Loop (cost=1.54..37.95 rows=1 width=32) (actual time=0.063..0.063 rows=0 loops=1)

  • Output: upper(tsapprovalrequestkeyvalue42.uri)
  • Inner Unique: true
  • Buffers: shared hit=50
85. 0.002 0.062 ↓ 0.0 0 1

Nested Loop (cost=1.26..34.22 rows=11 width=83) (actual time=0.062..0.062 rows=0 loops=1)

  • Output: tsapprovalrequestkeyvalue42.uri, tsapprovalrequestkeyvalue42.parentid
  • Buffers: shared hit=50
86. 0.005 0.060 ↓ 0.0 0 1

Nested Loop (cost=0.97..25.12 rows=1 width=4) (actual time=0.060..0.060 rows=0 loops=1)

  • Output: tsapprovalrequest45.id
  • Inner Unique: true
  • Buffers: shared hit=50
87. 0.002 0.037 ↑ 1.0 6 1

Nested Loop (cost=0.56..20.74 rows=6 width=20) (actual time=0.025..0.037 rows=6 loops=1)

  • Output: timesheetapprovalnodes44.timesheetid, tsapprovalrequest45.id
  • Inner Unique: true
  • Buffers: shared hit=26
88. 0.017 0.017 ↑ 1.0 6 1

Index Scan using uix2tsar_nodeid_userid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequest tsapprovalrequest45 (cost=0.28..6.95 rows=6 width=20) (actual time=0.015..0.017 rows=6 loops=1)

  • Output: tsapprovalrequest45.id, tsapprovalrequest45.nodeid, tsapprovalrequest45.effectivedateutc, tsapprovalrequest45.remindersentutc, tsapprovalrequest45.overduesentutc, tsapprovalrequest45.waitingbatchsentutc, tsapprovalrequest45.approvalagenttype, tsapprovalrequest45.userid, tsapprovalrequest45.systemprocessidentifier
  • Index Cond: (tsapprovalrequest45.userid = 448)
  • Buffers: shared hit=8
89. 0.018 0.018 ↑ 1.0 1 6

Index Scan using timesheetapprovalnodes_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalnodes timesheetapprovalnodes44 (cost=0.28..2.30 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=6)

  • Output: timesheetapprovalnodes44.id, timesheetapprovalnodes44.timesheetid, timesheetapprovalnodes44.isapproved, timesheetapprovalnodes44.approverrole, timesheetapprovalnodes44.userid, timesheetapprovalnodes44.systemprocessidentifier, timesheetapprovalnodes44.scriptid, timesheetapprovalnodes44.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes44.id = tsapprovalrequest45.nodeid)
  • Buffers: shared hit=18
90. 0.018 0.018 ↓ 0.0 0 6

Index Scan using timesheet_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet43 (cost=0.41..0.72 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=6)

  • Output: timesheet43.id, timesheet43.userid, timesheet43.startdate, timesheet43.enddate, timesheet43.approvalstatus, timesheet43.duedate, timesheet43.autosubmitdatetimeutc, timesheet43.lastautosubmitattemptdatetimeutc, timesheet43.createdonutc
  • Index Cond: (timesheet43.id = timesheetapprovalnodes44.timesheetid)
  • Filter: ((timesheet43.startdate <= timeentryrevision4.entrydate) AND (timesheet43.enddate >= timeentryrevision4.entrydate) AND (timesheet43.userid = timeentryrevision4.userid))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=24
91. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue42 (cost=0.29..9.00 rows=11 width=87) (never executed)

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

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

  • Output: tsapprovalrequestkeyvalue46.id, tsapprovalrequestkeyvalue46.tsapprovalrequestid, tsapprovalrequestkeyvalue46.parentid, tsapprovalrequestkeyvalue46.index, tsapprovalrequestkeyvalue46.key, tsapprovalrequestkeyvalue46.uri, tsapprovalrequestkeyvalue46.slug, tsapprovalrequestkeyvalue46."boolean", tsapprovalrequestkeyvalue46.date, tsapprovalrequestkeyvalue46.number, tsapprovalrequestkeyvalue46.text, tsapprovalrequestkeyvalue46."time", tsapprovalrequestkeyvalue46.timespan, tsapprovalrequestkeyvalue46.daterange_startdate, tsapprovalrequestkeyvalue46.daterange_enddate, tsapprovalrequestkeyvalue46.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue46.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue46.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue46.workdayduration_workdays, tsapprovalrequestkeyvalue46.workdayduration_hours, tsapprovalrequestkeyvalue46.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue46.id = tsapprovalrequestkeyvalue42.parentid)
  • Filter: (tsapprovalrequestkeyvalue46.parentid IS NULL)
93. 0.001 0.033 ↓ 0.0 0 1

Nested Loop (cost=15.53..89.60 rows=1 width=32) (actual time=0.033..0.033 rows=0 loops=1)

  • Output: upper(sheetapprovalhistorykeyvalue47.uri)
  • Buffers: shared hit=11
94. 0.001 0.032 ↓ 0.0 0 1

Nested Loop (cost=15.10..89.05 rows=1 width=16) (actual time=0.032..0.032 rows=0 loops=1)

  • Output: sheetapprovalhistorykeyvalue55.id
  • Buffers: shared hit=11
95. 0.000 0.031 ↓ 0.0 0 1

Nested Loop (cost=14.67..87.50 rows=1 width=16) (actual time=0.031..0.031 rows=0 loops=1)

  • Output: sheetapprovalhistorykeyvalue54.id
  • Buffers: shared hit=11
96. 0.001 0.031 ↓ 0.0 0 1

Nested Loop (cost=14.24..86.96 rows=1 width=16) (actual time=0.031..0.031 rows=0 loops=1)

  • Output: sheetapprovalhistorykeyvalue53.id
  • Buffers: shared hit=11
97. 0.001 0.030 ↓ 0.0 0 1

Nested Loop (cost=13.81..85.44 rows=1 width=16) (actual time=0.030..0.030 rows=0 loops=1)

  • Output: sheetapprovalhistorykeyvalue52.id
  • Buffers: shared hit=11
98. 0.000 0.029 ↓ 0.0 0 1

Nested Loop (cost=13.38..83.07 rows=1 width=16) (actual time=0.029..0.029 rows=0 loops=1)

  • Output: sheetapprovalhistorykeyvalue51.parentid
  • Inner Unique: true
  • Buffers: shared hit=11
99. 0.001 0.029 ↓ 0.0 0 1

Nested Loop (cost=12.95..80.62 rows=1 width=16) (actual time=0.029..0.029 rows=0 loops=1)

  • Output: sheetapprovalhistorykeyvalue50.parentid
  • Buffers: shared hit=11
100. 0.002 0.028 ↓ 0.0 0 1

Nested Loop (cost=0.83..67.48 rows=1 width=16) (actual time=0.028..0.028 rows=0 loops=1)

  • Output: timesheetapprovalhistory49.id
  • Buffers: shared hit=11
101. 0.016 0.016 ↑ 12.0 1 1

Index Scan using ixtsuseridstartdateenddate on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet48 (cost=0.41..13.60 rows=12 width=16) (actual time=0.016..0.016 rows=1 loops=1)

  • Output: timesheet48.id, timesheet48.userid, timesheet48.startdate, timesheet48.enddate, timesheet48.approvalstatus, timesheet48.duedate, timesheet48.autosubmitdatetimeutc, timesheet48.lastautosubmitattemptdatetimeutc, timesheet48.createdonutc
  • Index Cond: ((timesheet48.userid = timeentryrevision4.userid) AND (timesheet48.startdate <= timeentryrevision4.entrydate) AND (timesheet48.enddate >= timeentryrevision4.entrydate))
  • Buffers: shared hit=6
102. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ixtah2timesheetid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistory timesheetapprovalhistory49 (cost=0.42..4.48 rows=1 width=32) (actual time=0.009..0.010 rows=0 loops=1)

  • Output: timesheetapprovalhistory49.id, timesheetapprovalhistory49.serialnumber, timesheetapprovalhistory49.timesheetid, timesheetapprovalhistory49.action, timesheetapprovalhistory49.approvalcomments, timesheetapprovalhistory49.timestamputc, timesheetapprovalhistory49.approvalagenttype, timesheetapprovalhistory49.userid, timesheetapprovalhistory49.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory49.timesheetid = timesheet48.id)
  • Filter: (timesheetapprovalhistory49.userid = 448)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=5
103. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue50 (cost=12.11..13.13 rows=1 width=32) (never executed)

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

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

105. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (sheetapprovalhistorykeyvalue50.timesheetapprovalhistoryid = timesheetapprovalhistory49.id)
106. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (upper(sheetapprovalhistorykeyvalue50.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text)
107. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue51 (cost=0.43..2.45 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue52 (cost=0.43..2.36 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue53 (cost=0.43..1.49 rows=3 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue54 (cost=0.43..0.53 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue55 (cost=0.43..1.53 rows=3 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue47 (cost=0.43..0.52 rows=3 width=87) (never executed)

  • Output: sheetapprovalhistorykeyvalue47.id, sheetapprovalhistorykeyvalue47.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue47.parentid, sheetapprovalhistorykeyvalue47.index, sheetapprovalhistorykeyvalue47.key, sheetapprovalhistorykeyvalue47.uri, sheetapprovalhistorykeyvalue47.slug, sheetapprovalhistorykeyvalue47."boolean", sheetapprovalhistorykeyvalue47.date, sheetapprovalhistorykeyvalue47.number, sheetapprovalhistorykeyvalue47.text, sheetapprovalhistorykeyvalue47."time", sheetapprovalhistorykeyvalue47.timespan, sheetapprovalhistorykeyvalue47.daterange_startdate, sheetapprovalhistorykeyvalue47.daterange_enddate, sheetapprovalhistorykeyvalue47.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue47.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue47.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue47.workdayduration_workdays, sheetapprovalhistorykeyvalue47.workdayduration_hours, sheetapprovalhistorykeyvalue47.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue47.parentid = sheetapprovalhistorykeyvalue55.id)
113. 37,279.639 37,279.660 ↓ 0.0 0 3,727,966

Index Scan using ixtemrtimeentryid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeentrymetadatarevision timeentrymetadatarevision56 (cost=73.89..88.44 rows=1 width=0) (actual time=0.010..0.010 rows=0 loops=3,727,966)

  • Index Cond: (timeentrymetadatarevision56.timeentryid = timeentryrevision4.timeentryid)
  • Filter: ((timeentrymetadatarevision56.fromtimestamputc <= timeentryrevision4.fromtimestamputc) AND ((timeentrymetadatarevision56.totimestamputc > timeentryrevision4.fromtimestamputc) OR (timeentrymetadatarevision56.totimestamputc IS NULL)) AND (((upper(timeentrymetadatarevision56.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 13)) OR ((upper(timeentrymetadatarevision56.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 14))))
  • Rows Removed by Filter: 10
  • Buffers: shared hit=24,253,473
114.          

SubPlan (for Index Scan)

115. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=32.85..35.41 rows=6 width=32) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: upper(('urn:replicon-tenant:cf6586b0d9db4b13bf8ea8c0e7ab5b1f:project:'::text || COALESCE((project57.id)::text, ''::text)))
  • Inner Unique: true
  • Buffers: shared hit=1
116. 0.001 0.009 ↓ 0.0 0 1

HashAggregate (cost=32.56..32.62 rows=6 width=4) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: resentativeprojectassignment58.projectid
  • Group Key: resentativeprojectassignment58.projectid
  • Buffers: shared hit=1
117. 0.001 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.30..32.55 rows=6 width=4) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: resentativeprojectassignment58.projectid
  • Buffers: shared hit=1
118. 0.007 0.007 ↓ 0.0 0 1

Index Scan using uix2cr_clientuser on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.clientrepresentative clientrepresentative59 (cost=0.15..19.01 rows=8 width=16) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: clientrepresentative59.id, clientrepresentative59.clientid, clientrepresentative59.userid
  • Index Cond: (clientrepresentative59.userid = 448)
  • Buffers: shared hit=1
119. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcrpaclientrepresentativeid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.clientrepresentativeprojectassignment resentativeprojectassignment58 (cost=0.15..1.63 rows=6 width=20) (never executed)

  • Output: resentativeprojectassignment58.id, resentativeprojectassignment58.clientrepresentativeid, resentativeprojectassignment58.projectid
  • Index Cond: (resentativeprojectassignment58.clientrepresentativeid = clientrepresentative59.id)
120. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.project project57 (cost=0.29..0.46 rows=1 width=4) (never executed)

  • Output: project57.id
  • Index Cond: (project57.id = resentativeprojectassignment58.projectid)
  • Heap Fetches: 0
121. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=33.13..37.88 rows=11 width=32) (actual time=0.012..0.012 rows=0 loops=1)

  • Output: upper(('urn:replicon-tenant:cf6586b0d9db4b13bf8ea8c0e7ab5b1f:task:'::text || COALESCE((task60.id)::text, ''::text)))
  • Buffers: shared hit=1
122. 0.000 0.011 ↓ 0.0 0 1

Nested Loop (cost=32.85..35.35 rows=6 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Output: project61.id, resentativeprojectassignment58_1.projectid
  • Inner Unique: true
  • Buffers: shared hit=1
123. 0.001 0.011 ↓ 0.0 0 1

HashAggregate (cost=32.56..32.62 rows=6 width=4) (actual time=0.011..0.011 rows=0 loops=1)

  • Output: resentativeprojectassignment58_1.projectid
  • Group Key: resentativeprojectassignment58_1.projectid
  • Buffers: shared hit=1
124. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.30..32.55 rows=6 width=4) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: resentativeprojectassignment58_1.projectid
  • Buffers: shared hit=1
125. 0.009 0.009 ↓ 0.0 0 1

Index Scan using uix2cr_clientuser on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.clientrepresentative clientrepresentative59_1 (cost=0.15..19.01 rows=8 width=16) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: clientrepresentative59_1.id, clientrepresentative59_1.clientid, clientrepresentative59_1.userid
  • Index Cond: (clientrepresentative59_1.userid = 448)
  • Buffers: shared hit=1
126. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcrpaclientrepresentativeid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.clientrepresentativeprojectassignment resentativeprojectassignment58_1 (cost=0.15..1.63 rows=6 width=20) (never executed)

  • Output: resentativeprojectassignment58_1.id, resentativeprojectassignment58_1.clientrepresentativeid, resentativeprojectassignment58_1.projectid
  • Index Cond: (resentativeprojectassignment58_1.clientrepresentativeid = clientrepresentative59_1.id)
127. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.project project61 (cost=0.29..0.46 rows=1 width=4) (never executed)

  • Output: project61.id
  • Index Cond: (project61.id = resentativeprojectassignment58_1.projectid)
  • Heap Fetches: 0
128. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtkprojectid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.task task60 (cost=0.29..0.38 rows=2 width=8) (never executed)

  • Output: task60.id, task60.projectid, task60.parentid, task60.name, task60.code, task60.description, task60.isclosed, task60.orderindex, task60.percentcomplete, task60.istimeentryallowed, task60.estimatedhours, task60.timeentrystartdate, task60.timeentryenddate, task60.estimatedexpenses, task60.estimatedexpensescurrencyid, task60.expenseentrystartdate, task60.expenseentryenddate, task60.costtype, task60.estimatedcost, task60.estimatedcostcurrencyid, task60.timeandexpenseentrytype, task60.info1, task60.info2, task60.info3, task60.info4, task60.info5, task60.info6, task60.info7, task60.info8, task60.info9, task60.info10, task60.info11, task60.info12, task60.info13, task60.info14, task60.info15, task60.info16, task60.info17, task60.info18, task60.info19, task60.info20, task60.closeddate
  • Index Cond: (task60.projectid = project61.id)
129. 0.000 0.000 ↓ 0.0 0

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

  • Output: upper(tsapprovalrequestkeyvalue62.uri)
  • Inner Unique: true
130. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.26..34.22 rows=11 width=83) (never executed)

  • Output: tsapprovalrequestkeyvalue62.uri, tsapprovalrequestkeyvalue62.parentid
131. 0.000 0.000 ↓ 0.0 0

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

  • Output: tsapprovalrequest65.id
  • Inner Unique: true
132. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..20.74 rows=6 width=20) (never executed)

  • Output: timesheetapprovalnodes64.timesheetid, tsapprovalrequest65.id
  • Inner Unique: true
133. 0.000 0.000 ↓ 0.0 0

Index Scan using uix2tsar_nodeid_userid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequest tsapprovalrequest65 (cost=0.28..6.95 rows=6 width=20) (never executed)

  • Output: tsapprovalrequest65.id, tsapprovalrequest65.nodeid, tsapprovalrequest65.effectivedateutc, tsapprovalrequest65.remindersentutc, tsapprovalrequest65.overduesentutc, tsapprovalrequest65.waitingbatchsentutc, tsapprovalrequest65.approvalagenttype, tsapprovalrequest65.userid, tsapprovalrequest65.systemprocessidentifier
  • Index Cond: (tsapprovalrequest65.userid = 448)
134. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalnodes timesheetapprovalnodes64 (cost=0.28..2.30 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes64.id, timesheetapprovalnodes64.timesheetid, timesheetapprovalnodes64.isapproved, timesheetapprovalnodes64.approverrole, timesheetapprovalnodes64.userid, timesheetapprovalnodes64.systemprocessidentifier, timesheetapprovalnodes64.scriptid, timesheetapprovalnodes64.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes64.id = tsapprovalrequest65.nodeid)
135. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet63 (cost=0.41..0.72 rows=1 width=16) (never executed)

  • Output: timesheet63.id, timesheet63.userid, timesheet63.startdate, timesheet63.enddate, timesheet63.approvalstatus, timesheet63.duedate, timesheet63.autosubmitdatetimeutc, timesheet63.lastautosubmitattemptdatetimeutc, timesheet63.createdonutc
  • Index Cond: (timesheet63.id = timesheetapprovalnodes64.timesheetid)
  • Filter: ((timesheet63.startdate <= timeentryrevision4.entrydate) AND (timesheet63.enddate >= timeentryrevision4.entrydate) AND (timesheet63.userid = timeentryrevision4.userid))
136. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue62 (cost=0.29..9.00 rows=11 width=87) (never executed)

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

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

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

Nested Loop (cost=15.53..89.60 rows=1 width=32) (never executed)

  • Output: upper(sheetapprovalhistorykeyvalue67.uri)
139. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=15.10..89.05 rows=1 width=16) (never executed)

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

Nested Loop (cost=14.67..87.50 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue74.id
141. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=14.24..86.96 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue73.id
142. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=13.81..85.44 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue72.id
143. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=13.38..83.07 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue71.parentid
  • Inner Unique: true
144. 0.000 0.000 ↓ 0.0 0

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

  • Output: sheetapprovalhistorykeyvalue70.parentid
145. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..67.48 rows=1 width=16) (never executed)

  • Output: timesheetapprovalhistory69.id
146. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet68 (cost=0.41..13.60 rows=12 width=16) (never executed)

  • Output: timesheet68.id, timesheet68.userid, timesheet68.startdate, timesheet68.enddate, timesheet68.approvalstatus, timesheet68.duedate, timesheet68.autosubmitdatetimeutc, timesheet68.lastautosubmitattemptdatetimeutc, timesheet68.createdonutc
  • Index Cond: ((timesheet68.userid = timeentryrevision4.userid) AND (timesheet68.startdate <= timeentryrevision4.entrydate) AND (timesheet68.enddate >= timeentryrevision4.entrydate))
147. 0.000 0.000 ↓ 0.0 0

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

  • Output: timesheetapprovalhistory69.id, timesheetapprovalhistory69.serialnumber, timesheetapprovalhistory69.timesheetid, timesheetapprovalhistory69.action, timesheetapprovalhistory69.approvalcomments, timesheetapprovalhistory69.timestamputc, timesheetapprovalhistory69.approvalagenttype, timesheetapprovalhistory69.userid, timesheetapprovalhistory69.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory69.timesheetid = timesheet68.id)
  • Filter: (timesheetapprovalhistory69.userid = 448)
148. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue70 (cost=12.11..13.13 rows=1 width=32) (never executed)

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

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

150. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (sheetapprovalhistorykeyvalue70.timesheetapprovalhistoryid = timesheetapprovalhistory69.id)
151. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (upper(sheetapprovalhistorykeyvalue70.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text)
152. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue71 (cost=0.43..2.45 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue72 (cost=0.43..2.36 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue73 (cost=0.43..1.49 rows=3 width=32) (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 = sheetapprovalhistorykeyvalue72.id)
155. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue74 (cost=0.43..0.53 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue75 (cost=0.43..1.53 rows=3 width=32) (never executed)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue67 (cost=0.43..0.52 rows=3 width=87) (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 = sheetapprovalhistorykeyvalue75.id)
158. 0.078 0.154 ↑ 1.0 596 1

Hash (cost=9.96..9.96 rows=596 width=8) (actual time=0.154..0.154 rows=596 loops=1)

  • Output: departmentusers1.departmentid, departmentusers1.userid
  • Buckets: 1,024 Batches: 1 Memory Usage: 32kB
  • Buffers: shared hit=4
159. 0.076 0.076 ↑ 1.0 596 1

Seq Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.departmentusers departmentusers1 (cost=0.00..9.96 rows=596 width=8) (actual time=0.010..0.076 rows=596 loops=1)

  • Output: departmentusers1.departmentid, departmentusers1.userid
  • Buffers: shared hit=4
160. 0.872 6,270.589 ↑ 34.2 1,527 1

Nested Loop (cost=0.84..6,214,940.30 rows=52,178 width=4) (actual time=1.302..6,270.589 rows=1,527 loops=1)

  • Output: departmentusers76.departmentid
  • Buffers: shared hit=6,042,886 read=52
161. 49.947 6,266.663 ↑ 34.2 1,527 1

Nested Loop Semi Join (cost=0.56..6,199,148.45 rows=52,178 width=4) (actual time=1.288..6,266.663 rows=1,527 loops=1)

  • Output: timeoffs77.userid
  • Buffers: shared hit=6,038,305 read=52
162. 7.534 7.534 ↑ 1.0 52,178 1

Seq Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeoffs timeoffs77 (cost=0.00..1,621.78 rows=52,178 width=8) (actual time=0.006..7.534 rows=52,178 loops=1)

  • Output: timeoffs77.id, timeoffs77.guidid, timeoffs77.userid, timeoffs77.createdbyuserid, timeoffs77.timeoffcodeid, timeoffs77.startdate, timeoffs77.enddate, timeoffs77.startdurationtype, timeoffs77.enddurationtype, timeoffs77.startduration, timeoffs77.endduration, timeoffs77.startdatestarttime, timeoffs77.enddateendtime, timeoffs77.approvalstatus, timeoffs77.comments, timeoffs77.submittedonutc, timeoffs77.modifiedonutc, timeoffs77.entryconfigurationmethod, timeoffs77.info1, timeoffs77.info2, timeoffs77.info3, timeoffs77.info4, timeoffs77.info5
  • Buffers: shared hit=1,100
163. 108.390 6,209.182 ↓ 0.0 0 52,178

Nested Loop Left Join (cost=0.56..141.35 rows=1 width=4) (actual time=0.119..0.119 rows=0 loops=52,178)

  • Output: timeoffs78.id
  • Filter: (((userhierarchy79.supervisorid = 448) AND ((userhierarchy79.startdate IS NULL) OR (userhierarchy79.startdate <= '2020-06-26'::date)) AND ((userhierarchy79.enddate IS NULL) OR (userhierarchy79.enddate >= '2020-06-26'::date))) OR (timeoffs78.userid = 448) OR (alternatives: SubPlan 19 or hashed SubPlan 20) OR (alternatives: SubPlan 21 or hashed SubPlan 22) OR (SubPlan 23) OR (SubPlan 24) OR (SubPlan 25) OR (SubPlan 26))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=6,037,205 read=52
164. 104.356 104.356 ↑ 1.0 1 52,178

Index Scan using timeoffs_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeoffs timeoffs78 (cost=0.29..0.33 rows=1 width=16) (actual time=0.001..0.002 rows=1 loops=52,178)

  • Output: timeoffs78.id, timeoffs78.guidid, timeoffs78.userid, timeoffs78.createdbyuserid, timeoffs78.timeoffcodeid, timeoffs78.startdate, timeoffs78.enddate, timeoffs78.startdurationtype, timeoffs78.enddurationtype, timeoffs78.startduration, timeoffs78.endduration, timeoffs78.startdatestarttime, timeoffs78.enddateendtime, timeoffs78.approvalstatus, timeoffs78.comments, timeoffs78.submittedonutc, timeoffs78.modifiedonutc, timeoffs78.entryconfigurationmethod, timeoffs78.info1, timeoffs78.info2, timeoffs78.info3, timeoffs78.info4, timeoffs78.info5
  • Index Cond: (timeoffs78.id = timeoffs77.id)
  • Buffers: shared hit=157,135
165. 104.356 104.356 ↑ 1.0 1 52,178

Index Scan using ix3uh_usersuperstart on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.userhierarchy userhierarchy79 (cost=0.28..0.29 rows=1 width=24) (actual time=0.001..0.002 rows=1 loops=52,178)

  • Output: userhierarchy79.id, userhierarchy79.userid, userhierarchy79.supervisorid, userhierarchy79.startdate, userhierarchy79.enddate
  • Index Cond: (userhierarchy79.userid = timeoffs78.userid)
  • Buffers: shared hit=161,280
166.          

SubPlan (for Nested Loop Left Join)

167. 0.000 72.846 ↓ 0.0 0 72,846

Nested Loop (cost=0.55..5.42 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=72,846)

  • Inner Unique: true
  • Join Filter: (timeoffapprovalnodes80.id = timeoffapprovalrequest81.nodeid)
  • Rows Removed by Join Filter: 0
  • Buffers: shared hit=151,559
168. 72.846 72.846 ↓ 0.0 0 72,846

Index Scan using ixtoantimeoffid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeoffapprovalnodes timeoffapprovalnodes80 (cost=0.28..2.29 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=72,846)

  • Output: timeoffapprovalnodes80.id, timeoffapprovalnodes80.timeoffid, timeoffapprovalnodes80.approverrole, timeoffapprovalnodes80.userid, timeoffapprovalnodes80.isapproved, timeoffapprovalnodes80.agentresolutionstate, timeoffapprovalnodes80.scriptid
  • Index Cond: (timeoffapprovalnodes80.timeoffid = timeoffs78.id)
  • Buffers: shared hit=147,335
169. 2.816 2.816 ↑ 1.0 2 1,408

Index Scan using ixtoarapproverid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeoffapprovalrequest timeoffapprovalrequest81 (cost=0.28..3.10 rows=2 width=16) (actual time=0.001..0.002 rows=2 loops=1,408)

  • Output: timeoffapprovalrequest81.id, timeoffapprovalrequest81.effectivedateutc, timeoffapprovalrequest81.approverid, timeoffapprovalrequest81.nodeid
  • Index Cond: (timeoffapprovalrequest81.approverid = 448)
  • Buffers: shared hit=4,224
170. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..7.70 rows=2 width=4) (never executed)

  • Output: timeoffapprovalnodes80_1.timeoffid
  • Inner Unique: true
171. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoarapproverid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeoffapprovalrequest timeoffapprovalrequest81_1 (cost=0.28..3.10 rows=2 width=16) (never executed)

  • Output: timeoffapprovalrequest81_1.id, timeoffapprovalrequest81_1.effectivedateutc, timeoffapprovalrequest81_1.approverid, timeoffapprovalrequest81_1.nodeid
  • Index Cond: (timeoffapprovalrequest81_1.approverid = 448)
172. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffapprovalnodes_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeoffapprovalnodes timeoffapprovalnodes80_1 (cost=0.28..2.29 rows=1 width=20) (never executed)

  • Output: timeoffapprovalnodes80_1.id, timeoffapprovalnodes80_1.timeoffid, timeoffapprovalnodes80_1.approverrole, timeoffapprovalnodes80_1.userid, timeoffapprovalnodes80_1.isapproved, timeoffapprovalnodes80_1.agentresolutionstate, timeoffapprovalnodes80_1.scriptid
  • Index Cond: (timeoffapprovalnodes80_1.id = timeoffapprovalrequest81_1.nodeid)
173. 145.692 145.692 ↓ 0.0 0 72,846

Index Scan using ixtoahtimeoffid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeoffapprovalhistory timeoffapprovalhistory82 (cost=0.29..3.24 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=72,846)

  • Index Cond: (timeoffapprovalhistory82.timeoffid = timeoffs78.id)
  • Filter: ((timeoffapprovalhistory82.userid = 448) AND (timeoffapprovalhistory82.action = ANY ('{2,3,4}'::integer[])))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=266,702
174. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahuserid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeoffapprovalhistory timeoffapprovalhistory82_1 (cost=0.29..699.68 rows=463 width=4) (never executed)

  • Output: timeoffapprovalhistory82_1.timeoffid
  • Index Cond: (timeoffapprovalhistory82_1.userid = 448)
  • Filter: (timeoffapprovalhistory82_1.action = ANY ('{2,3,4}'::integer[]))
175. 0.000 1,891.474 ↓ 0.0 0 72,749

Nested Loop (cost=1.54..37.95 rows=1 width=32) (actual time=0.026..0.026 rows=0 loops=72,749)

  • Output: upper(tsapprovalrequestkeyvalue83.uri)
  • Inner Unique: true
  • Buffers: shared hit=3,637,450
176. 72.749 1,891.474 ↓ 0.0 0 72,749

Nested Loop (cost=1.26..34.22 rows=11 width=83) (actual time=0.026..0.026 rows=0 loops=72,749)

  • Output: tsapprovalrequestkeyvalue83.uri, tsapprovalrequestkeyvalue83.parentid
  • Buffers: shared hit=3,637,450
177. 0.000 1,818.725 ↓ 0.0 0 72,749

Nested Loop (cost=0.97..25.12 rows=1 width=4) (actual time=0.025..0.025 rows=0 loops=72,749)

  • Output: tsapprovalrequest86.id
  • Inner Unique: true
  • Buffers: shared hit=3,637,450
178. 290.996 945.737 ↑ 1.0 6 72,749

Nested Loop (cost=0.56..20.74 rows=6 width=20) (actual time=0.003..0.013 rows=6 loops=72,749)

  • Output: timesheetapprovalnodes85.timesheetid, tsapprovalrequest86.id
  • Inner Unique: true
  • Buffers: shared hit=1,891,474
179. 218.247 218.247 ↑ 1.0 6 72,749

Index Scan using uix2tsar_nodeid_userid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequest tsapprovalrequest86 (cost=0.28..6.95 rows=6 width=20) (actual time=0.001..0.003 rows=6 loops=72,749)

  • Output: tsapprovalrequest86.id, tsapprovalrequest86.nodeid, tsapprovalrequest86.effectivedateutc, tsapprovalrequest86.remindersentutc, tsapprovalrequest86.overduesentutc, tsapprovalrequest86.waitingbatchsentutc, tsapprovalrequest86.approvalagenttype, tsapprovalrequest86.userid, tsapprovalrequest86.systemprocessidentifier
  • Index Cond: (tsapprovalrequest86.userid = 448)
  • Buffers: shared hit=581,992
180. 436.494 436.494 ↑ 1.0 1 436,494

Index Scan using timesheetapprovalnodes_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalnodes timesheetapprovalnodes85 (cost=0.28..2.30 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=436,494)

  • Output: timesheetapprovalnodes85.id, timesheetapprovalnodes85.timesheetid, timesheetapprovalnodes85.isapproved, timesheetapprovalnodes85.approverrole, timesheetapprovalnodes85.userid, timesheetapprovalnodes85.systemprocessidentifier, timesheetapprovalnodes85.scriptid, timesheetapprovalnodes85.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes85.id = tsapprovalrequest86.nodeid)
  • Buffers: shared hit=1,309,482
181. 872.988 872.988 ↓ 0.0 0 436,494

Index Scan using timesheet_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet84 (cost=0.41..0.72 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=436,494)

  • Output: timesheet84.id, timesheet84.userid, timesheet84.startdate, timesheet84.enddate, timesheet84.approvalstatus, timesheet84.duedate, timesheet84.autosubmitdatetimeutc, timesheet84.lastautosubmitattemptdatetimeutc, timesheet84.createdonutc
  • Index Cond: (timesheet84.id = timesheetapprovalnodes85.timesheetid)
  • Filter: ((timeoffs78.startdate <= timesheet84.enddate) AND (timeoffs78.enddate >= timesheet84.startdate) AND (timesheet84.userid = timeoffs78.userid))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1,745,976
182. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue83 (cost=0.29..9.00 rows=11 width=87) (never executed)

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

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

  • Output: tsapprovalrequestkeyvalue87.id, tsapprovalrequestkeyvalue87.tsapprovalrequestid, tsapprovalrequestkeyvalue87.parentid, tsapprovalrequestkeyvalue87.index, tsapprovalrequestkeyvalue87.key, tsapprovalrequestkeyvalue87.uri, tsapprovalrequestkeyvalue87.slug, tsapprovalrequestkeyvalue87."boolean", tsapprovalrequestkeyvalue87.date, tsapprovalrequestkeyvalue87.number, tsapprovalrequestkeyvalue87.text, tsapprovalrequestkeyvalue87."time", tsapprovalrequestkeyvalue87.timespan, tsapprovalrequestkeyvalue87.daterange_startdate, tsapprovalrequestkeyvalue87.daterange_enddate, tsapprovalrequestkeyvalue87.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue87.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue87.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue87.workdayduration_workdays, tsapprovalrequestkeyvalue87.workdayduration_hours, tsapprovalrequestkeyvalue87.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue87.id = tsapprovalrequestkeyvalue83.parentid)
  • Filter: (tsapprovalrequestkeyvalue87.parentid IS NULL)
184. 72.617 872.988 ↓ 0.0 0 72,749

Nested Loop (cost=15.53..89.60 rows=1 width=32) (actual time=0.012..0.012 rows=0 loops=72,749)

  • Output: upper(sheetapprovalhistorykeyvalue88.uri)
  • Buffers: shared hit=723,629 read=52
185. 0.000 800.239 ↓ 0.0 0 72,749

Nested Loop (cost=15.10..89.05 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=72,749)

  • Output: sheetapprovalhistorykeyvalue96.id
  • Buffers: shared hit=723,528 read=52
186. 0.000 800.239 ↓ 0.0 0 72,749

Nested Loop (cost=14.67..87.50 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=72,749)

  • Output: sheetapprovalhistorykeyvalue95.id
  • Buffers: shared hit=723,440 read=52
187. 0.000 800.239 ↓ 0.0 0 72,749

Nested Loop (cost=14.24..86.96 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=72,749)

  • Output: sheetapprovalhistorykeyvalue94.id
  • Buffers: shared hit=723,352 read=52
188. 0.000 800.239 ↓ 0.0 0 72,749

Nested Loop (cost=13.81..85.44 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=72,749)

  • Output: sheetapprovalhistorykeyvalue93.id
  • Buffers: shared hit=723,264 read=52
189. 72.573 800.239 ↓ 0.0 0 72,749

Nested Loop (cost=13.38..83.07 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=72,749)

  • Output: sheetapprovalhistorykeyvalue92.parentid
  • Inner Unique: true
  • Buffers: shared hit=723,174 read=52
190. 0.000 727.490 ↓ 0.0 0 72,749

Nested Loop (cost=12.95..80.62 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=72,749)

  • Output: sheetapprovalhistorykeyvalue91.parentid
  • Buffers: shared hit=723,086 read=52
191. 93.573 654.741 ↓ 0.0 0 72,749

Nested Loop (cost=0.83..67.48 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=72,749)

  • Output: timesheetapprovalhistory90.id
  • Buffers: shared hit=721,448
192. 290.996 290.996 ↑ 12.0 1 72,749

Index Scan using ixtsuseridstartdateenddate on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet89 (cost=0.41..13.60 rows=12 width=16) (actual time=0.004..0.004 rows=1 loops=72,749)

  • Output: timesheet89.id, timesheet89.userid, timesheet89.startdate, timesheet89.enddate, timesheet89.approvalstatus, timesheet89.duedate, timesheet89.autosubmitdatetimeutc, timesheet89.lastautosubmitattemptdatetimeutc, timesheet89.createdonutc
  • Index Cond: ((timesheet89.userid = timeoffs78.userid) AND (timeoffs78.enddate >= timesheet89.startdate) AND (timeoffs78.startdate <= timesheet89.enddate))
  • Buffers: shared hit=365,692
193. 270.172 270.172 ↓ 0.0 0 67,543

Index Scan using ixtah2timesheetid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistory timesheetapprovalhistory90 (cost=0.42..4.48 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=67,543)

  • Output: timesheetapprovalhistory90.id, timesheetapprovalhistory90.serialnumber, timesheetapprovalhistory90.timesheetid, timesheetapprovalhistory90.action, timesheetapprovalhistory90.approvalcomments, timesheetapprovalhistory90.timestamputc, timesheetapprovalhistory90.approvalagenttype, timesheetapprovalhistory90.userid, timesheetapprovalhistory90.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory90.timesheetid = timesheet89.id)
  • Filter: (timesheetapprovalhistory90.userid = 448)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=355,756
194. 0.341 83.948 ↑ 1.0 1 31

Bitmap Heap Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue91 (cost=12.11..13.13 rows=1 width=32) (actual time=2.708..2.708 rows=1 loops=31)

  • Output: sheetapprovalhistorykeyvalue91.id, sheetapprovalhistorykeyvalue91.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue91.parentid, sheetapprovalhistorykeyvalue91.index, sheetapprovalhistorykeyvalue91.key, sheetapprovalhistorykeyvalue91.uri, sheetapprovalhistorykeyvalue91.slug, sheetapprovalhistorykeyvalue91."boolean", sheetapprovalhistorykeyvalue91.date, sheetapprovalhistorykeyvalue91.number, sheetapprovalhistorykeyvalue91.text, sheetapprovalhistorykeyvalue91."time", sheetapprovalhistorykeyvalue91.timespan, sheetapprovalhistorykeyvalue91.daterange_startdate, sheetapprovalhistorykeyvalue91.daterange_enddate, sheetapprovalhistorykeyvalue91.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue91.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue91.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue91.workdayduration_workdays, sheetapprovalhistorykeyvalue91.workdayduration_hours, sheetapprovalhistorykeyvalue91.workdayduration_minutes
  • Recheck Cond: ((sheetapprovalhistorykeyvalue91.timesheetapprovalhistoryid = timesheetapprovalhistory90.id) AND (upper(sheetapprovalhistorykeyvalue91.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text))
  • Filter: (upper(sheetapprovalhistorykeyvalue91.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=41
  • Buffers: shared hit=1,638 read=52
195. 0.124 83.607 ↓ 0.0 0 31

BitmapAnd (cost=12.11..12.11 rows=1 width=0) (actual time=2.697..2.697 rows=0 loops=31)

  • Buffers: shared hit=1,597 read=52
196. 3.937 3.937 ↑ 1.2 24 31

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..1.61 rows=28 width=0) (actual time=0.127..0.127 rows=24 loops=31)

  • Index Cond: (sheetapprovalhistorykeyvalue91.timesheetapprovalhistoryid = timesheetapprovalhistory90.id)
  • Buffers: shared hit=96 read=3
197. 79.546 79.546 ↓ 8.6 4,166 31

Bitmap Index Scan on ixtahkvuri (cost=0.00..10.17 rows=482 width=0) (actual time=2.566..2.566 rows=4,166 loops=31)

  • Index Cond: (upper(sheetapprovalhistorykeyvalue91.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text)
  • Buffers: shared hit=1,501 read=49
198. 0.176 0.176 ↑ 1.0 1 22

Index Scan using timesheetapprovalhistorykeyvalue_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue92 (cost=0.43..2.45 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=22)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue93 (cost=0.43..2.36 rows=1 width=32) (actual time=0.010..0.010 rows=1 loops=22)

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue94 (cost=0.43..1.49 rows=3 width=32) (actual time=0.004..0.004 rows=1 loops=22)

  • Output: sheetapprovalhistorykeyvalue94.id, sheetapprovalhistorykeyvalue94.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue94.parentid, sheetapprovalhistorykeyvalue94.index, sheetapprovalhistorykeyvalue94.key, sheetapprovalhistorykeyvalue94.uri, sheetapprovalhistorykeyvalue94.slug, sheetapprovalhistorykeyvalue94."boolean", sheetapprovalhistorykeyvalue94.date, sheetapprovalhistorykeyvalue94.number, sheetapprovalhistorykeyvalue94.text, sheetapprovalhistorykeyvalue94."time", sheetapprovalhistorykeyvalue94.timespan, sheetapprovalhistorykeyvalue94.daterange_startdate, sheetapprovalhistorykeyvalue94.daterange_enddate, sheetapprovalhistorykeyvalue94.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue94.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue94.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue94.workdayduration_workdays, sheetapprovalhistorykeyvalue94.workdayduration_hours, sheetapprovalhistorykeyvalue94.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue94.parentid = sheetapprovalhistorykeyvalue93.id)
  • Buffers: shared hit=88
201. 0.132 0.132 ↑ 1.0 1 22

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue95 (cost=0.43..0.53 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=22)

  • Output: sheetapprovalhistorykeyvalue95.id, sheetapprovalhistorykeyvalue95.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue95.parentid, sheetapprovalhistorykeyvalue95.index, sheetapprovalhistorykeyvalue95.key, sheetapprovalhistorykeyvalue95.uri, sheetapprovalhistorykeyvalue95.slug, sheetapprovalhistorykeyvalue95."boolean", sheetapprovalhistorykeyvalue95.date, sheetapprovalhistorykeyvalue95.number, sheetapprovalhistorykeyvalue95.text, sheetapprovalhistorykeyvalue95."time", sheetapprovalhistorykeyvalue95.timespan, sheetapprovalhistorykeyvalue95.daterange_startdate, sheetapprovalhistorykeyvalue95.daterange_enddate, sheetapprovalhistorykeyvalue95.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue95.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue95.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue95.workdayduration_workdays, sheetapprovalhistorykeyvalue95.workdayduration_hours, sheetapprovalhistorykeyvalue95.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue95.parentid = sheetapprovalhistorykeyvalue94.id)
  • Filter: (upper(sheetapprovalhistorykeyvalue95.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
  • Buffers: shared hit=88
202. 0.088 0.088 ↑ 3.0 1 22

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue96 (cost=0.43..1.53 rows=3 width=32) (actual time=0.004..0.004 rows=1 loops=22)

  • Output: sheetapprovalhistorykeyvalue96.id, sheetapprovalhistorykeyvalue96.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue96.parentid, sheetapprovalhistorykeyvalue96.index, sheetapprovalhistorykeyvalue96.key, sheetapprovalhistorykeyvalue96.uri, sheetapprovalhistorykeyvalue96.slug, sheetapprovalhistorykeyvalue96."boolean", sheetapprovalhistorykeyvalue96.date, sheetapprovalhistorykeyvalue96.number, sheetapprovalhistorykeyvalue96.text, sheetapprovalhistorykeyvalue96."time", sheetapprovalhistorykeyvalue96.timespan, sheetapprovalhistorykeyvalue96.daterange_startdate, sheetapprovalhistorykeyvalue96.daterange_enddate, sheetapprovalhistorykeyvalue96.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue96.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue96.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue96.workdayduration_workdays, sheetapprovalhistorykeyvalue96.workdayduration_hours, sheetapprovalhistorykeyvalue96.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue96.parentid = sheetapprovalhistorykeyvalue95.id)
  • Buffers: shared hit=88
203. 0.132 0.132 ↓ 2.0 6 22

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue88 (cost=0.43..0.52 rows=3 width=87) (actual time=0.004..0.006 rows=6 loops=22)

  • Output: sheetapprovalhistorykeyvalue88.id, sheetapprovalhistorykeyvalue88.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue88.parentid, sheetapprovalhistorykeyvalue88.index, sheetapprovalhistorykeyvalue88.key, sheetapprovalhistorykeyvalue88.uri, sheetapprovalhistorykeyvalue88.slug, sheetapprovalhistorykeyvalue88."boolean", sheetapprovalhistorykeyvalue88.date, sheetapprovalhistorykeyvalue88.number, sheetapprovalhistorykeyvalue88.text, sheetapprovalhistorykeyvalue88."time", sheetapprovalhistorykeyvalue88.timespan, sheetapprovalhistorykeyvalue88.daterange_startdate, sheetapprovalhistorykeyvalue88.daterange_enddate, sheetapprovalhistorykeyvalue88.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue88.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue88.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue88.workdayduration_workdays, sheetapprovalhistorykeyvalue88.workdayduration_hours, sheetapprovalhistorykeyvalue88.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue88.parentid = sheetapprovalhistorykeyvalue96.id)
  • Buffers: shared hit=101
204. 0.000 2,254.537 ↓ 0.0 0 72,727

Nested Loop (cost=1.67..9.68 rows=1 width=32) (actual time=0.031..0.031 rows=0 loops=72,727)

  • Output: upper(tsapprovalrequestkeyvalue97.uri)
  • Inner Unique: true
  • Buffers: shared hit=218,181
205. 0.000 2,254.537 ↓ 0.0 0 72,727

Nested Loop (cost=1.38..7.37 rows=1 width=83) (actual time=0.031..0.031 rows=0 loops=72,727)

  • Output: tsapprovalrequestkeyvalue97.uri, tsapprovalrequestkeyvalue97.parentid
  • Inner Unique: true
  • Buffers: shared hit=218,181
206. 0.000 2,254.537 ↓ 0.0 0 72,727

Nested Loop (cost=0.97..6.60 rows=1 width=99) (actual time=0.031..0.031 rows=0 loops=72,727)

  • Output: timesheetapprovalnodes99.timesheetid, tsapprovalrequestkeyvalue97.uri, tsapprovalrequestkeyvalue97.parentid
  • Inner Unique: true
  • Buffers: shared hit=218,181
207. 72.727 2,254.537 ↓ 0.0 0 72,727

Nested Loop (cost=0.69..4.30 rows=1 width=99) (actual time=0.031..0.031 rows=0 loops=72,727)

  • Output: tsapprovalrequest100.nodeid, tsapprovalrequestkeyvalue97.uri, tsapprovalrequestkeyvalue97.parentid
  • Inner Unique: true
  • Buffers: shared hit=218,181
208. 2,181.810 2,181.810 ↓ 0.0 0 72,727

Index Scan using ixtsarkvkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue97 (cost=0.41..1.43 rows=1 width=87) (actual time=0.030..0.030 rows=0 loops=72,727)

  • 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: (upper(tsapprovalrequestkeyvalue97.key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
  • Buffers: shared hit=218,181
209. 0.000 0.000 ↓ 0.0 0

Index Scan using tsapprovalrequest_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequest tsapprovalrequest100 (cost=0.28..2.30 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest100.id, tsapprovalrequest100.nodeid, tsapprovalrequest100.effectivedateutc, tsapprovalrequest100.remindersentutc, tsapprovalrequest100.overduesentutc, tsapprovalrequest100.waitingbatchsentutc, tsapprovalrequest100.approvalagenttype, tsapprovalrequest100.userid, tsapprovalrequest100.systemprocessidentifier
  • Index Cond: (tsapprovalrequest100.id = tsapprovalrequestkeyvalue97.tsapprovalrequestid)
  • Filter: (tsapprovalrequest100.userid = 448)
210. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalnodes timesheetapprovalnodes99 (cost=0.28..2.30 rows=1 width=32) (never executed)

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

Index Scan using timesheet_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet98 (cost=0.41..0.72 rows=1 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.id = timesheetapprovalnodes99.timesheetid)
  • Filter: ((timeoffs78.startdate <= timesheet98.enddate) AND (timeoffs78.enddate >= timesheet98.startdate) AND (timesheet98.userid = timeoffs78.userid))
212. 0.000 0.000 ↓ 0.0 0

Index Scan using tsapprovalrequestkeyvalue_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue101 (cost=0.29..2.30 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)
213. 72.727 654.543 ↓ 0.0 0 72,727

Nested Loop (cost=15.53..92.52 rows=1 width=32) (actual time=0.009..0.009 rows=0 loops=72,727)

  • Output: upper(heetapprovalhistorykeyvalue102.uri)
  • Buffers: shared hit=721,269
214. 0.000 581.816 ↓ 0.0 0 72,727

Nested Loop (cost=15.10..91.98 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=72,727)

  • Output: heetapprovalhistorykeyvalue110.id
  • Buffers: shared hit=721,269
215. 0.000 581.816 ↓ 0.0 0 72,727

Nested Loop (cost=14.67..87.50 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=72,727)

  • Output: heetapprovalhistorykeyvalue109.id
  • Buffers: shared hit=721,269
216. 0.000 581.816 ↓ 0.0 0 72,727

Nested Loop (cost=14.24..86.96 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=72,727)

  • Output: heetapprovalhistorykeyvalue108.id
  • Buffers: shared hit=721,269
217. 0.000 581.816 ↓ 0.0 0 72,727

Nested Loop (cost=13.81..85.44 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=72,727)

  • Output: heetapprovalhistorykeyvalue107.id
  • Buffers: shared hit=721,269
218. 72.727 581.816 ↓ 0.0 0 72,727

Nested Loop (cost=13.38..83.07 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=72,727)

  • Output: heetapprovalhistorykeyvalue106.parentid
  • Inner Unique: true
  • Buffers: shared hit=721,269
219. 0.000 509.089 ↓ 0.0 0 72,727

Nested Loop (cost=12.95..80.62 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=72,727)

  • Output: heetapprovalhistorykeyvalue105.parentid
  • Buffers: shared hit=721,269
220. 83.139 509.089 ↓ 0.0 0 72,727

Nested Loop (cost=0.83..67.48 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=72,727)

  • Output: timesheetapprovalhistory104.id
  • Buffers: shared hit=721,269
221. 290.908 290.908 ↑ 12.0 1 72,727

Index Scan using ixtsuseridstartdateenddate on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet103 (cost=0.41..13.60 rows=12 width=16) (actual time=0.004..0.004 rows=1 loops=72,727)

  • Output: timesheet103.id, timesheet103.userid, timesheet103.startdate, timesheet103.enddate, timesheet103.approvalstatus, timesheet103.duedate, timesheet103.autosubmitdatetimeutc, timesheet103.lastautosubmitattemptdatetimeutc, timesheet103.createdonutc
  • Index Cond: ((timesheet103.userid = timeoffs78.userid) AND (timeoffs78.enddate >= timesheet103.startdate) AND (timeoffs78.startdate <= timesheet103.enddate))
  • Buffers: shared hit=365,604
222. 135.042 135.042 ↓ 0.0 0 67,521

Index Scan using ixtah2timesheetid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistory timesheetapprovalhistory104 (cost=0.42..4.48 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=67,521)

  • Output: timesheetapprovalhistory104.id, timesheetapprovalhistory104.serialnumber, timesheetapprovalhistory104.timesheetid, timesheetapprovalhistory104.action, timesheetapprovalhistory104.approvalcomments, timesheetapprovalhistory104.timestamputc, timesheetapprovalhistory104.approvalagenttype, timesheetapprovalhistory104.userid, timesheetapprovalhistory104.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory104.timesheetid = timesheet103.id)
  • Filter: (timesheetapprovalhistory104.userid = 448)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=355,665
223. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue105 (cost=12.11..13.13 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
  • Recheck Cond: ((heetapprovalhistorykeyvalue105.timesheetapprovalhistoryid = timesheetapprovalhistory104.id) AND (upper(heetapprovalhistorykeyvalue105.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text))
  • Filter: (upper(heetapprovalhistorykeyvalue105.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
224. 0.000 0.000 ↓ 0.0 0

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

225. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (heetapprovalhistorykeyvalue105.timesheetapprovalhistoryid = timesheetapprovalhistory104.id)
226. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (upper(heetapprovalhistorykeyvalue105.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text)
227. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue106 (cost=0.43..2.45 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)
228. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue107 (cost=0.43..2.36 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)
229. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue108 (cost=0.43..1.49 rows=3 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)
230. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue109 (cost=0.43..0.53 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-ACCESSIBLE-OBJECTS'::text)
231. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue110 (cost=0.43..4.45 rows=3 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)
232. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue102 (cost=0.43..0.52 rows=3 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)
233. 3.054 3.054 ↑ 1.0 1 1,527

Index Scan using ixduuserid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.departmentusers departmentusers76 (cost=0.28..0.29 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,527)

  • Output: departmentusers76.departmentid, departmentusers76.userid, departmentusers76.isprimarydepartment
  • Index Cond: (departmentusers76.userid = timeoffs77.userid)
  • Buffers: shared hit=4,581
Planning time : 247.757 ms
Execution time : 445,955.169 ms