explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zY3U : tcoc_before

Settings
# exclusive inclusive rows x rows loops node
1. 39.735 1,227,435.337 ↑ 8.7 7 1

Seq Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.departments departments0 (cost=1,965,977,725.26..1,965,977,728.48 rows=61 width=122) (actual time=1,218,963.695..1,227,435.337 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=331,427,126 read=651,798
2.          

SubPlan (for Seq Scan)

3. 24.805 1,218,925.283 ↑ 12.8 133,564 1

Hash Join (cost=1,959,407,458.36..1,959,713,954.30 rows=1,711,004 width=4) (actual time=1,218,112.647..1,218,925.283 rows=133,564 loops=1)

  • Output: departmentusers1.departmentid
  • Hash Cond: (timeentry2.userid = departmentusers1.userid)
  • Buffers: shared hit=325,388,650 read=648,886
4. 446.659 1,218,897.796 ↑ 12.8 133,564 1

Hash Semi Join (cost=1,959,407,441.06..1,959,690,410.69 rows=1,711,004 width=4) (actual time=1,218,109.948..1,218,897.796 rows=133,564 loops=1)

  • Output: timeentry2.userid
  • Hash Cond: (timeentry2.id = timeentryrevision3.timeentryid)
  • Buffers: shared hit=325,388,647 read=648,885
5. 360.487 360.487 ↑ 1.0 2,233,521 1

Seq Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeentry timeentry2 (cost=0.00..44,196.22 rows=2,233,522 width=20) (actual time=1.687..360.487 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=1,226 read=17,727
6. 104.992 1,218,090.650 ↑ 16.3 133,564 1

Hash (cost=1,959,380,221.27..1,959,380,221.27 rows=2,177,583 width=16) (actual time=1,218,090.650..1,218,090.650 rows=133,564 loops=1)

  • Output: timeentryrevision3.timeentryid
  • Buckets: 4,194,304 Batches: 1 Memory Usage: 39,029kB
  • Buffers: shared hit=325,387,421 read=631,158
7. 323.085 1,217,985.658 ↑ 16.3 133,564 1

Merge Join (cost=15,138.43..1,959,380,221.27 rows=2,177,583 width=16) (actual time=53,987.501..1,217,985.658 rows=133,564 loops=1)

  • Output: timeentryrevision3.timeentryid
  • Inner Unique: true
  • Merge Cond: (timeentryrevision3.id = timeentryrevision4.id)
  • Buffers: shared hit=325,387,421 read=631,158
8. 4,227.375 4,227.375 ↓ 1.0 2,233,517 1

Index Scan using timeentryrevision_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeentryrevision timeentryrevision3 (cost=0.43..156,435.66 rows=2,190,906 width=32) (actual time=0.036..4,227.375 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=27,931 read=6,991
9. 23,218.132 1,213,435.198 ↑ 13.2 296,648 1

Index Scan using timeentryrevision_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeentryrevision timeentryrevision4 (cost=15,138.00..1,959,186,738.06 rows=3,917,779 width=16) (actual time=53,867.112..1,213,435.198 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,359,490 read=624,167
10.          

SubPlan (for Index Scan)

11. 53.312 53,186.630 ↑ 1.8 296,674 1

Nested Loop (cost=0.99..13,802.80 rows=533,910 width=16) (actual time=10.358..53,186.630 rows=296,674 loops=1)

  • Output: timeentryrevision5.id
  • Buffers: shared hit=79,654 read=63,029
12. 2.606 212.982 ↓ 19.7 9,226 1

Nested Loop (cost=0.56..241.30 rows=468 width=16) (actual time=6.600..212.982 rows=9,226 loops=1)

  • Output: timesheet6.userid, timesheet6.startdate, timesheet6.enddate, userdivision7.userid
  • Buffers: shared hit=2,144 read=352
13. 0.676 3.448 ↓ 1.7 72 1

Nested Loop Semi Join (cost=0.14..155.34 rows=42 width=12) (actual time=0.055..3.448 rows=72 loops=1)

  • Output: userdivision7.userid, userdivision7.startdate, userdivision7.enddate
  • Buffers: shared hit=1,323 read=1
14. 0.144 0.144 ↓ 1.0 657 1

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

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

Index Scan using ixdivfhchildid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.divisionflathierarchy divisionflathierarchy8 (cost=0.14..0.22 rows=1 width=16) (actual time=0.004..0.004 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,316 read=1
16. 206.928 206.928 ↓ 10.7 128 72

Index Only Scan using ixtsuseridstartdateenddate on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet6 (cost=0.41..1.93 rows=12 width=12) (actual time=0.979..2.874 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=821 read=351
17. 52,920.336 52,920.336 ↑ 26.0 32 9,226

Index Scan using ixter2userid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeentryrevision timeentryrevision5 (cost=0.43..20.65 rows=833 width=24) (actual time=0.432..5.736 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=77,510 read=62,677
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.707 0.707 ↓ 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.702..0.707 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=6 read=1
20. 0.000 100,655.082 ↓ 0.0 0 3,727,966

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

  • Output: upper(tsapprovalrequestkeyvalue10.uri)
  • Inner Unique: true
  • Buffers: shared hit=186,398,283 read=17
21. 0.000 100,655.082 ↓ 0.0 0 3,727,966

Nested Loop (cost=1.26..34.13 rows=10 width=83) (actual time=0.027..0.027 rows=0 loops=3,727,966)

  • Output: tsapprovalrequestkeyvalue10.uri, tsapprovalrequestkeyvalue10.parentid
  • Buffers: shared hit=186,398,283 read=17
22. 3,727.966 100,655.082 ↓ 0.0 0 3,727,966

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

  • Output: tsapprovalrequest13.id
  • Inner Unique: true
  • Buffers: shared hit=186,398,283 read=17
23. 14,911.864 52,191.524 ↑ 1.0 6 3,727,966

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

  • Output: timesheetapprovalnodes12.timesheetid, tsapprovalrequest13.id
  • Inner Unique: true
  • Buffers: shared hit=96,927,099 read=17
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,722 read=6
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,377 read=11
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..8.91 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 55,919.490 ↓ 0.0 0 3,727,966

Nested Loop (cost=3.85..103.08 rows=1 width=32) (actual time=0.015..0.015 rows=0 loops=3,727,966)

  • Output: upper(sheetapprovalhistorykeyvalue15.uri)
  • Buffers: shared hit=39,852,955 read=5,210
30. 0.000 55,919.490 ↓ 0.0 0 3,727,966

Nested Loop (cost=3.42..102.54 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue23.id
  • Buffers: shared hit=39,852,955 read=5,210
31. 0.000 55,919.490 ↓ 0.0 0 3,727,966

Nested Loop (cost=2.99..100.97 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue22.id
  • Buffers: shared hit=39,852,955 read=5,210
32. 0.000 55,919.490 ↓ 0.0 0 3,727,966

Nested Loop (cost=2.56..100.43 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue21.id
  • Buffers: shared hit=39,852,955 read=5,210
33. 0.000 55,919.490 ↓ 0.0 0 3,727,966

Nested Loop (cost=2.12..98.91 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue20.id
  • Buffers: shared hit=39,852,955 read=5,210
34. 3,727.966 55,919.490 ↓ 0.0 0 3,727,966

Nested Loop (cost=1.69..96.53 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue19.parentid
  • Inner Unique: true
  • Buffers: shared hit=39,852,955 read=5,210
35. 0.000 52,191.524 ↓ 0.0 0 3,727,966

Nested Loop (cost=1.26..94.14 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=3,727,966)

  • Output: sheetapprovalhistorykeyvalue18.parentid
  • Buffers: shared hit=39,852,955 read=5,210
36. 3,968.325 52,191.524 ↓ 0.0 0 3,727,966

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

  • Output: timesheetapprovalhistory17.id
  • Buffers: shared hit=39,852,955 read=5,210
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,762,572 read=583
38. 25,855.403 25,855.403 ↓ 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.007..0.007 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,090,383 read=4,627
39. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue18 (cost=0.43..26.65 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
  • Index Cond: (sheetapprovalhistorykeyvalue18.timesheetapprovalhistoryid = timesheetapprovalhistory17.id)
  • Filter: ((upper(sheetapprovalhistorykeyvalue18.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(sheetapprovalhistorykeyvalue18.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text))
40. 0.000 0.000 ↓ 0.0 0

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue20 (cost=0.43..2.38 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)
42. 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)
43. 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)
44. 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)
45. 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)
46. 3,727.966 123,022.878 ↓ 0.0 0 3,727,966

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

  • Output: upper(tsapprovalrequestkeyvalue24.uri)
  • Inner Unique: true
  • Buffers: shared hit=11,183,895 read=3
47. 0.000 119,294.912 ↓ 0.0 0 3,727,966

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

  • Output: tsapprovalrequestkeyvalue24.uri, tsapprovalrequestkeyvalue24.parentid
  • Inner Unique: true
  • Buffers: shared hit=11,183,895 read=3
48. 0.000 119,294.912 ↓ 0.0 0 3,727,966

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

  • Output: timesheetapprovalnodes26.timesheetid, tsapprovalrequestkeyvalue24.uri, tsapprovalrequestkeyvalue24.parentid
  • Inner Unique: true
  • Buffers: shared hit=11,183,895 read=3
49. 0.000 119,294.912 ↓ 0.0 0 3,727,966

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

  • Output: tsapprovalrequest27.nodeid, tsapprovalrequestkeyvalue24.uri, tsapprovalrequestkeyvalue24.parentid
  • Inner Unique: true
  • Buffers: shared hit=11,183,895 read=3
50. 119,294.912 119,294.912 ↓ 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.032..0.032 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,895 read=3
51. 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)
52. 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)
53. 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))
54. 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)
55. 0.000 33,551.694 ↓ 0.0 0 3,727,966

Nested Loop (cost=3.85..106.00 rows=1 width=32) (actual time=0.009..0.009 rows=0 loops=3,727,966)

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

Nested Loop (cost=3.42..105.45 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
57. 0.000 33,551.694 ↓ 0.0 0 3,727,966

Nested Loop (cost=2.99..100.97 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
58. 3,727.966 33,551.694 ↓ 0.0 0 3,727,966

Nested Loop (cost=2.56..100.43 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
59. 0.000 29,823.728 ↓ 0.0 0 3,727,966

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

  • Output: sheetapprovalhistorykeyvalue34.id
  • Buffers: shared hit=39,858,261
60. 0.000 29,823.728 ↓ 0.0 0 3,727,966

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

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

Nested Loop (cost=1.26..94.14 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
62. 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
63. 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
64. 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
65. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue32 (cost=0.43..26.65 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
  • Index Cond: (sheetapprovalhistorykeyvalue32.timesheetapprovalhistoryid = timesheetapprovalhistory31.id)
  • Filter: ((upper(sheetapprovalhistorykeyvalue32.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(sheetapprovalhistorykeyvalue32.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text))
66. 0.000 0.000 ↓ 0.0 0

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue34 (cost=0.43..2.38 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)
68. 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)
69. 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)
70. 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)
71. 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)
72. 786,591.659 786,600.826 ↓ 0.0 0 3,727,966

Index Scan using ixtemrtimeentryid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeentrymetadatarevision timeentrymetadatarevision38 (cost=110.07..125.66 rows=1 width=0) (actual time=0.211..0.211 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=23,726,522 read=527,170
73.          

SubPlan (for Index Scan)

74. 0.078 0.078 ↑ 1.0 21 1

Index Scan using ixprjprojectleaderapproverid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.project project39 (cost=0.29..22.20 rows=21 width=32) (actual time=0.030..0.078 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
75. 0.038 9.089 ↑ 1.3 30 1

Nested Loop (cost=0.57..87.16 rows=38 width=32) (actual time=1.074..9.089 rows=30 loops=1)

  • Output: upper(('urn:replicon-tenant:cf6586b0d9db4b13bf8ea8c0e7ab5b1f:task:'::text || COALESCE((task40.id)::text, ''::text)))
  • Buffers: shared hit=98 read=10
76. 0.063 0.063 ↑ 1.0 21 1

Index Scan using ixprjprojectleaderapproverid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.project project41 (cost=0.29..21.99 rows=21 width=4) (actual time=0.026..0.063 rows=21 loops=1)

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

Index Scan using ixtkprojectid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.task task40 (cost=0.29..3.07 rows=2 width=8) (actual time=0.427..0.428 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=66 read=10
78. 0.000 0.066 ↓ 0.0 0 1

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

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

Nested Loop (cost=1.26..34.13 rows=10 width=83) (actual time=0.066..0.066 rows=0 loops=1)

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

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

  • Output: tsapprovalrequest45.id
  • Inner Unique: true
  • Buffers: shared hit=50
81. 0.004 0.041 ↑ 1.0 6 1

Nested Loop (cost=0.56..20.73 rows=6 width=20) (actual time=0.029..0.041 rows=6 loops=1)

  • Output: timesheetapprovalnodes44.timesheetid, tsapprovalrequest45.id
  • Inner Unique: true
  • Buffers: shared hit=26
82. 0.019 0.019 ↑ 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.017..0.019 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
83. 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
84. 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
85. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue42 (cost=0.29..8.91 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)
86. 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)
87. 0.000 0.033 ↓ 0.0 0 1

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

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

Nested Loop (cost=3.42..102.54 rows=1 width=16) (actual time=0.033..0.033 rows=0 loops=1)

  • Output: sheetapprovalhistorykeyvalue55.id
  • Buffers: shared hit=11
89. 0.002 0.032 ↓ 0.0 0 1

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

  • Output: sheetapprovalhistorykeyvalue54.id
  • Buffers: shared hit=11
90. 0.000 0.030 ↓ 0.0 0 1

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

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

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

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

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

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

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

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

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

  • Output: timesheetapprovalhistory49.id
  • Buffers: shared hit=11
95. 0.014 0.014 ↑ 12.0 1 1

Index Scan using ixtsuseridstartdateenddate on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheet timesheet48 (cost=0.41..13.60 rows=12 width=16) (actual time=0.014..0.014 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
96. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ixtah2timesheetid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistory timesheetapprovalhistory49 (cost=0.42..4.48 rows=1 width=32) (actual time=0.011..0.011 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
97. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue50 (cost=0.43..26.65 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
  • Index Cond: (sheetapprovalhistorykeyvalue50.timesheetapprovalhistoryid = timesheetapprovalhistory49.id)
  • Filter: ((upper(sheetapprovalhistorykeyvalue50.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(sheetapprovalhistorykeyvalue50.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text))
98. 0.000 0.000 ↓ 0.0 0

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue52 (cost=0.43..2.38 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)
100. 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)
101. 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)
102. 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)
103. 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)
104. 37,279.618 37,279.660 ↓ 0.0 0 3,727,966

Index Scan using ixtemrtimeentryid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeentrymetadatarevision timeentrymetadatarevision56 (cost=73.78..89.38 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
105.          

SubPlan (for Index Scan)

106. 0.000 0.029 ↓ 0.0 0 1

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

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

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

  • Output: resentativeprojectassignment58.projectid
  • Group Key: resentativeprojectassignment58.projectid
  • Buffers: shared hit=1
108. 0.000 0.027 ↓ 0.0 0 1

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

  • Output: resentativeprojectassignment58.projectid
  • Buffers: shared hit=1
109. 0.027 0.027 ↓ 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.027..0.027 rows=0 loops=1)

  • Output: clientrepresentative59.id, clientrepresentative59.clientid, clientrepresentative59.userid
  • Index Cond: (clientrepresentative59.userid = 448)
  • Buffers: shared hit=1
110. 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)
111. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

  • Output: resentativeprojectassignment58_1.projectid
  • Buffers: shared hit=1
116. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Output: clientrepresentative59_1.id, clientrepresentative59_1.clientid, clientrepresentative59_1.userid
  • Index Cond: (clientrepresentative59_1.userid = 448)
  • Buffers: shared hit=1
117. 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)
118. 0.000 0.000 ↓ 0.0 0

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

  • Output: project61.id
  • Index Cond: (project61.id = resentativeprojectassignment58_1.projectid)
  • Heap Fetches: 0
119. 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)
120. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop (cost=1.26..34.13 rows=10 width=83) (never executed)

  • Output: tsapprovalrequestkeyvalue62.uri, tsapprovalrequestkeyvalue62.parentid
122. 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
123. 0.000 0.000 ↓ 0.0 0

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

  • Output: timesheetapprovalnodes64.timesheetid, tsapprovalrequest65.id
  • Inner Unique: true
124. 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)
125. 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)
126. 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))
127. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue62 (cost=0.29..8.91 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)
128. 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)
129. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.85..103.08 rows=1 width=32) (never executed)

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

Nested Loop (cost=3.42..102.54 rows=1 width=16) (never executed)

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

Nested Loop (cost=2.99..100.97 rows=1 width=16) (never executed)

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

Nested Loop (cost=2.56..100.43 rows=1 width=16) (never executed)

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

Nested Loop (cost=2.12..98.91 rows=1 width=16) (never executed)

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

Nested Loop (cost=1.69..96.53 rows=1 width=16) (never executed)

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

Nested Loop (cost=1.26..94.14 rows=1 width=16) (never executed)

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

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

  • Output: timesheetapprovalhistory69.id
137. 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))
138. 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)
139. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue70 (cost=0.43..26.65 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
  • Index Cond: (sheetapprovalhistorykeyvalue70.timesheetapprovalhistoryid = timesheetapprovalhistory69.id)
  • Filter: ((upper(sheetapprovalhistorykeyvalue70.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(sheetapprovalhistorykeyvalue70.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text))
140. 0.000 0.000 ↓ 0.0 0

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue72 (cost=0.43..2.38 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)
142. 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)
143. 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)
144. 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)
145. 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)
146. 0.085 2.682 ↓ 1.0 596 1

Hash (cost=9.91..9.91 rows=591 width=8) (actual time=2.682..2.682 rows=596 loops=1)

  • Output: departmentusers1.departmentid, departmentusers1.userid
  • Buckets: 1,024 Batches: 1 Memory Usage: 32kB
  • Buffers: shared hit=3 read=1
147. 2.597 2.597 ↓ 1.0 596 1

Seq Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.departmentusers departmentusers1 (cost=0.00..9.91 rows=591 width=8) (actual time=0.019..2.597 rows=596 loops=1)

  • Output: departmentusers1.departmentid, departmentusers1.userid
  • Buffers: shared hit=3 read=1
148. 1.130 8,470.319 ↑ 34.1 1,527 1

Nested Loop (cost=0.84..6,259,363.46 rows=51,998 width=4) (actual time=28.453..8,470.319 rows=1,527 loops=1)

  • Output: departmentusers76.departmentid
  • Buffers: shared hit=6,038,474 read=2,912
149. 42.544 8,466.135 ↑ 34.1 1,527 1

Nested Loop Semi Join (cost=0.56..6,243,626.06 rows=51,998 width=4) (actual time=28.408..8,466.135 rows=1,527 loops=1)

  • Output: timeoffs77.userid
  • Buffers: shared hit=6,033,893 read=2,912
150. 22.933 22.933 ↓ 1.0 52,178 1

Seq Scan on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeoffs timeoffs77 (cost=0.00..1,619.98 rows=51,998 width=8) (actual time=0.005..22.933 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=21 read=1,096
151. 124.603 8,400.658 ↓ 0.0 0 52,178

Nested Loop Left Join (cost=0.56..142.94 rows=1 width=4) (actual time=0.161..0.161 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,033,872 read=1,816
152. 313.068 313.068 ↑ 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.006..0.006 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=156,957 read=161
153. 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,276 read=4
154.          

SubPlan (for Nested Loop Left Join)

155. 68.622 145.692 ↓ 0.0 0 72,846

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

  • Inner Unique: true
  • Join Filter: (timeoffapprovalnodes80.id = timeoffapprovalrequest81.nodeid)
  • Rows Removed by Join Filter: 0
  • Buffers: shared hit=151,549 read=10
156. 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,327 read=8
157. 4.224 4.224 ↑ 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.002..0.003 rows=2 loops=1,408)

  • Output: timeoffapprovalrequest81.id, timeoffapprovalrequest81.effectivedateutc, timeoffapprovalrequest81.approverid, timeoffapprovalrequest81.nodeid
  • Index Cond: (timeoffapprovalrequest81.approverid = 448)
  • Buffers: shared hit=4,222 read=2
158. 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
159. 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)
160. 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)
161. 1,821.150 1,821.150 ↓ 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.025..0.025 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=265,300 read=1,402
162. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahuserid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timeoffapprovalhistory timeoffapprovalhistory82_1 (cost=0.29..699.72 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[]))
163. 0.000 1,891.474 ↓ 0.0 0 72,749

Nested Loop (cost=1.54..37.53 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
164. 0.000 1,891.474 ↓ 0.0 0 72,749

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

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

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

  • Output: tsapprovalrequest86.id
  • Inner Unique: true
  • Buffers: shared hit=3,637,450
166. 363.745 1,018.486 ↑ 1.0 6 72,749

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

  • Output: timesheetapprovalnodes85.timesheetid, tsapprovalrequest86.id
  • Inner Unique: true
  • Buffers: shared hit=1,891,474
167. 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
168. 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
169. 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
170. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue83 (cost=0.29..8.91 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)
171. 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)
172. 37.175 1,091.235 ↓ 0.0 0 72,749

Nested Loop (cost=3.85..103.08 rows=1 width=32) (actual time=0.015..0.015 rows=0 loops=72,749)

  • Output: upper(sheetapprovalhistorykeyvalue88.uri)
  • Buffers: shared hit=721,890 read=239
173. 0.000 1,018.486 ↓ 0.0 0 72,749

Nested Loop (cost=3.42..102.54 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=72,749)

  • Output: sheetapprovalhistorykeyvalue96.id
  • Buffers: shared hit=721,818 read=210
174. 39.705 1,018.486 ↓ 0.0 0 72,749

Nested Loop (cost=2.99..100.97 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=72,749)

  • Output: sheetapprovalhistorykeyvalue95.id
  • Buffers: shared hit=721,756 read=184
175. 39.881 945.737 ↓ 0.0 0 72,749

Nested Loop (cost=2.56..100.43 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=72,749)

  • Output: sheetapprovalhistorykeyvalue94.id
  • Buffers: shared hit=721,696 read=156
176. 0.000 872.988 ↓ 0.0 0 72,749

Nested Loop (cost=2.12..98.91 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=72,749)

  • Output: sheetapprovalhistorykeyvalue93.id
  • Buffers: shared hit=721,635 read=129
177. 37.483 872.988 ↓ 0.0 0 72,749

Nested Loop (cost=1.69..96.53 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=72,749)

  • Output: sheetapprovalhistorykeyvalue92.parentid
  • Inner Unique: true
  • Buffers: shared hit=721,570 read=104
178. 0.000 800.239 ↓ 0.0 0 72,749

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

  • Output: sheetapprovalhistorykeyvalue91.parentid
  • Buffers: shared hit=721,514 read=72
179. 93.573 727.490 ↓ 0.0 0 72,749

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

  • Output: timesheetapprovalhistory90.id
  • Buffers: shared hit=721,446 read=2
180. 363.745 363.745 ↑ 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.005..0.005 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
181. 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,754 read=2
182. 88.505 88.505 ↑ 1.0 1 31

Index Scan using ixtahkvtimesheetapprovalhistoryid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue91 (cost=0.43..26.65 rows=1 width=32) (actual time=2.855..2.855 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
  • Index Cond: (sheetapprovalhistorykeyvalue91.timesheetapprovalhistoryid = timesheetapprovalhistory90.id)
  • Filter: ((upper(sheetapprovalhistorykeyvalue91.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(sheetapprovalhistorykeyvalue91.uri) = 'URN:REPLICON-TENANT:CF6586B0D9DB4B13BF8EA8C0E7AB5B1F:USER:448'::text))
  • Rows Removed by Filter: 16
  • Buffers: shared hit=68 read=70
183. 35.266 35.266 ↑ 1.0 1 22

Index Scan using timesheetapprovalhistorykeyvalue_pkey on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue92 (cost=0.43..2.38 rows=1 width=32) (actual time=1.603..1.603 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=56 read=32
184. 38.258 38.258 ↑ 1.0 1 22

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue93 (cost=0.43..2.38 rows=1 width=32) (actual time=1.739..1.739 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=65 read=25
185. 32.868 32.868 ↑ 3.0 1 22

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue94 (cost=0.43..1.49 rows=3 width=32) (actual time=1.494..1.494 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=61 read=27
186. 33.044 33.044 ↑ 1.0 1 22

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue95 (cost=0.43..0.53 rows=1 width=32) (actual time=1.502..1.502 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=60 read=28
187. 27.302 27.302 ↑ 3.0 1 22

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue96 (cost=0.43..1.53 rows=3 width=32) (actual time=1.241..1.241 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=62 read=26
188. 35.574 35.574 ↓ 2.0 6 22

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue88 (cost=0.43..0.52 rows=3 width=87) (actual time=1.382..1.617 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=72 read=29
189. 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
190. 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
191. 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
192. 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
193. 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
194. 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)
195. 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)
196. 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))
197. 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)
198. 0.000 654.543 ↓ 0.0 0 72,727

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

  • Output: upper(heetapprovalhistorykeyvalue102.uri)
  • Buffers: shared hit=721,269
199. 72.727 654.543 ↓ 0.0 0 72,727

Nested Loop (cost=3.42..105.45 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=72,727)

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

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

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

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

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

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

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

Nested Loop (cost=1.69..96.53 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
204. 72.727 581.816 ↓ 0.0 0 72,727

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

  • Output: heetapprovalhistorykeyvalue105.parentid
  • Buffers: shared hit=721,269
205. 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
206. 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
207. 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
208. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue105 (cost=0.43..26.65 rows=1 width=32) (never executed)

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

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

Index Scan using ixtahkvparentid on cf6586b0d9db4b13bf8ea8c0e7ab5b1f.timesheetapprovalhistorykeyvalue heetapprovalhistorykeyvalue107 (cost=0.43..2.38 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)
211. 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)
212. 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)
213. 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)
214. 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)
215. 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 : 490.681 ms
Execution time : 1,227,445.103 ms