explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GiMQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.120 103,174.208 ↑ 9.3 7 1

Nested Loop Semi Join (cost=1.41..26,176,550.41 rows=65 width=122) (actual time=22,732.336..103,174.208 rows=7 loops=1)

  • Output: departments0.id, departments0.code
  • Buffers: shared hit=74199742
2. 0.038 0.038 ↑ 1.0 70 1

Seq Scan on "1921f143c7c74d9587f3e84e353e664d".departments departments0 (cost=0.00..1.70 rows=70 width=12) (actual time=0.004..0.038 rows=70 loops=1)

  • Output: departments0.id, departments0.parentid, departments0.name, departments0.code, departments0.comments, departments0.disabled, departments0.disabledsetting, departments0.info1, departments0.info2, departments0.info3, departments0.info4, departments0.info5, departments0.info6, departments0.info7, departments0.info8, departments0.info9, departments0.info10, departments0.info11, departments0.info12, departments0.slug
  • Buffers: shared hit=1
3. 771.536 103,174.050 ↓ 0.0 0 70

Nested Loop Semi Join (cost=1.41..4,358,263.56 rows=21,651 width=4) (actual time=1,473.915..1,473.915 rows=0 loops=70)

  • Output: departmentusers1.departmentid
  • Buffers: shared hit=74199741
4. 146.650 585.340 ↑ 1.8 11,922 70

Nested Loop (cost=0.71..1,091.57 rows=21,651 width=8) (actual time=0.013..8.362 rows=11,922 loops=70)

  • Output: timeoffs2.id, departmentusers1.departmentid
  • Buffers: shared hit=267534
5. 1.610 1.610 ↑ 1.8 16 70

Index Only Scan using departmentusers_pkey on "1921f143c7c74d9587f3e84e353e664d".departmentusers departmentusers1 (cost=0.28..1.01 rows=28 width=8) (actual time=0.005..0.023 rows=16 loops=70)

  • Output: departmentusers1.departmentid, departmentusers1.userid
  • Index Cond: (departmentusers1.departmentid = departments0.id)
  • Heap Fetches: 1115
  • Buffers: shared hit=255
6. 437.080 437.080 ↑ 1.1 748 1,115

Index Scan using ixto4userid on "1921f143c7c74d9587f3e84e353e664d".timeoffs timeoffs2 (cost=0.43..30.53 rows=842 width=8) (actual time=0.007..0.392 rows=748 loops=1,115)

  • Output: timeoffs2.id, timeoffs2.guidid, timeoffs2.userid, timeoffs2.createdbyuserid, timeoffs2.timeoffcodeid, timeoffs2.startdate, timeoffs2.enddate, timeoffs2.approvalstatus, timeoffs2.comments, timeoffs2.submittedonutc, timeoffs2.modifiedonutc, timeoffs2.info1, timeoffs2.info2, timeoffs2.info3, timeoffs2.info4, timeoffs2.info5, timeoffs2.startdurationtype, timeoffs2.enddurationtype, timeoffs2.startduration, timeoffs2.endduration, timeoffs2.startdatestarttime, timeoffs2.enddateendtime, timeoffs2.entryconfigurationmethod
  • Index Cond: (timeoffs2.userid = departmentusers1.userid)
  • Buffers: shared hit=267279
7. 4,333.727 101,817.174 ↓ 0.0 0 834,567

Nested Loop Left Join (cost=0.71..311.58 rows=2 width=4) (actual time=0.122..0.122 rows=0 loops=834,567)

  • Output: timeoffs3.id
  • Filter: (((userhierarchy4.supervisorid = 1561) AND ((userhierarchy4.startdate IS NULL) OR (userhierarchy4.startdate <= '2019-06-05'::date)) AND ((userhierarchy4.enddate IS NULL) OR (userhierarchy4.enddate >= '2019-06-05'::date))) OR (timeoffs3.userid = 1561) OR (alternatives: SubPlan 1 or hashed SubPlan 2) OR (alternatives: SubPlan 3 or hashed SubPlan 4) OR (SubPlan 5) OR (SubPlan 6) OR (SubPlan 7) OR (SubPlan 8))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=73932207
8. 1,669.134 1,669.134 ↑ 1.0 1 834,567

Index Scan using timeoffs_pkey on "1921f143c7c74d9587f3e84e353e664d".timeoffs timeoffs3 (cost=0.43..0.47 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=834,567)

  • Output: timeoffs3.id, timeoffs3.guidid, timeoffs3.userid, timeoffs3.createdbyuserid, timeoffs3.timeoffcodeid, timeoffs3.startdate, timeoffs3.enddate, timeoffs3.approvalstatus, timeoffs3.comments, timeoffs3.submittedonutc, timeoffs3.modifiedonutc, timeoffs3.info1, timeoffs3.info2, timeoffs3.info3, timeoffs3.info4, timeoffs3.info5, timeoffs3.startdurationtype, timeoffs3.enddurationtype, timeoffs3.startduration, timeoffs3.endduration, timeoffs3.startdatestarttime, timeoffs3.enddateendtime, timeoffs3.entryconfigurationmethod
  • Index Cond: (timeoffs3.id = timeoffs2.id)
  • Buffers: shared hit=3346874
9. 1,669.134 1,669.134 ↓ 1.5 3 834,567

Index Scan using ix3uh_usersuperstart on "1921f143c7c74d9587f3e84e353e664d".userhierarchy userhierarchy4 (cost=0.28..0.32 rows=2 width=24) (actual time=0.001..0.002 rows=3 loops=834,567)

  • Output: userhierarchy4.id, userhierarchy4.userid, userhierarchy4.supervisorid, userhierarchy4.startdate, userhierarchy4.enddate
  • Index Cond: (userhierarchy4.userid = timeoffs3.userid)
  • Buffers: shared hit=2529788
10.          

SubPlan (forNested Loop Left Join)

11. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..4.34 rows=1 width=0) (never executed)

  • Join Filter: (timeoffapprovalnodes5.id = timeoffapprovalrequest6.nodeid)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoantimeoffid on "1921f143c7c74d9587f3e84e353e664d".timeoffapprovalnodes timeoffapprovalnodes5 (cost=0.14..2.16 rows=1 width=16) (never executed)

  • Output: timeoffapprovalnodes5.id, timeoffapprovalnodes5.timeoffid, timeoffapprovalnodes5.isapproved, timeoffapprovalnodes5.approverrole, timeoffapprovalnodes5.userid, timeoffapprovalnodes5.agentresolutionstate, timeoffapprovalnodes5.scriptid
  • Index Cond: (timeoffapprovalnodes5.timeoffid = timeoffs3.id)
13. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix2toaraidnid on "1921f143c7c74d9587f3e84e353e664d".timeoffapprovalrequest timeoffapprovalrequest6 (cost=0.14..2.16 rows=1 width=16) (never executed)

  • Output: timeoffapprovalrequest6.approverid, timeoffapprovalrequest6.nodeid
  • Index Cond: (timeoffapprovalrequest6.approverid = 1561)
  • Heap Fetches: 0
14. 0.002 0.012 ↑ 1.0 1 1

Nested Loop (cost=0.29..4.33 rows=1 width=4) (actual time=0.011..0.012 rows=1 loops=1)

  • Output: timeoffapprovalnodes5_1.timeoffid
  • Buffers: shared hit=4
15. 0.007 0.007 ↑ 1.0 1 1

Index Only Scan using uix2toaraidnid on "1921f143c7c74d9587f3e84e353e664d".timeoffapprovalrequest timeoffapprovalrequest6_1 (cost=0.14..2.16 rows=1 width=16) (actual time=0.006..0.007 rows=1 loops=1)

  • Output: timeoffapprovalrequest6_1.approverid, timeoffapprovalrequest6_1.nodeid
  • Index Cond: (timeoffapprovalrequest6_1.approverid = 1561)
  • Heap Fetches: 1
  • Buffers: shared hit=2
16. 0.003 0.003 ↑ 1.0 1 1

Index Scan using timeoffapprovalnodes_pkey on "1921f143c7c74d9587f3e84e353e664d".timeoffapprovalnodes timeoffapprovalnodes5_1 (cost=0.14..2.16 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=1)

  • Output: timeoffapprovalnodes5_1.id, timeoffapprovalnodes5_1.timeoffid, timeoffapprovalnodes5_1.isapproved, timeoffapprovalnodes5_1.approverrole, timeoffapprovalnodes5_1.userid, timeoffapprovalnodes5_1.agentresolutionstate, timeoffapprovalnodes5_1.scriptid
  • Index Cond: (timeoffapprovalnodes5_1.id = timeoffapprovalrequest6_1.nodeid)
  • Buffers: shared hit=2
17. 6,568.287 6,568.287 ↓ 0.0 0 2,189,429

Index Scan using ixtoahtimeoffid on "1921f143c7c74d9587f3e84e353e664d".timeoffapprovalhistory timeoffapprovalhistory7 (cost=0.43..2.57 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=2,189,429)

  • Index Cond: (timeoffapprovalhistory7.timeoffid = timeoffs3.id)
  • Filter: ((timeoffapprovalhistory7.userid = 1561) AND (timeoffapprovalhistory7.action = ANY ('{2,3,4}'::integer[])))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=10791565
18. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtoahuserid on "1921f143c7c74d9587f3e84e353e664d".timeoffapprovalhistory timeoffapprovalhistory7_1 (cost=0.43..9,634.21 rows=8,217 width=4) (never executed)

  • Output: timeoffapprovalhistory7_1.timeoffid
  • Index Cond: (timeoffapprovalhistory7_1.userid = 1561)
  • Filter: (timeoffapprovalhistory7_1.action = ANY ('{2,3,4}'::integer[]))
19. 2,189.422 8,757.688 ↓ 0.0 0 2,189,422

Nested Loop (cost=0.84..10.43 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=2,189,422)

  • Output: upper(tsapprovalrequestkeyvalue8.uri)
  • Buffers: shared hit=2189422
20. 0.000 6,568.266 ↓ 0.0 0 2,189,422

Nested Loop (cost=0.69..8.25 rows=1 width=79) (actual time=0.003..0.003 rows=0 loops=2,189,422)

  • Output: tsapprovalrequestkeyvalue8.uri, tsapprovalrequestkeyvalue8.parentid
  • Join Filter: (tsapprovalrequest11.id = tsapprovalrequestkeyvalue8.tsapprovalrequestid)
  • Buffers: shared hit=2189422
21. 0.000 6,568.266 ↓ 0.0 0 2,189,422

Nested Loop (cost=0.42..5.95 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=2,189,422)

  • Output: tsapprovalrequest11.id
  • Buffers: shared hit=2189422
22. 0.000 6,568.266 ↓ 0.0 0 2,189,422

Nested Loop (cost=0.00..3.49 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=2,189,422)

  • Output: timesheetapprovalnodes10.timesheetid, tsapprovalrequest11.id
  • Join Filter: (timesheetapprovalnodes10.id = tsapprovalrequest11.nodeid)
  • Buffers: shared hit=2189422
23. 6,568.266 6,568.266 ↓ 0.0 0 2,189,422

Seq Scan on "1921f143c7c74d9587f3e84e353e664d".tsapprovalrequest tsapprovalrequest11 (cost=0.00..1.32 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=2,189,422)

  • Output: tsapprovalrequest11.id, tsapprovalrequest11.effectivedateutc, tsapprovalrequest11.userid, tsapprovalrequest11.nodeid, tsapprovalrequest11.remindersentutc, tsapprovalrequest11.overduesentutc, tsapprovalrequest11.waitingbatchsentutc, tsapprovalrequest11.approvalagenttype, tsapprovalrequest11.systemprocessidentifier
  • Filter: (tsapprovalrequest11.userid = 1561)
  • Rows Removed by Filter: 26
  • Buffers: shared hit=2189422
24. 0.000 0.000 ↓ 0.0 0

Seq Scan on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalnodes timesheetapprovalnodes10 (cost=0.00..1.52 rows=52 width=32) (never executed)

  • Output: timesheetapprovalnodes10.id, timesheetapprovalnodes10.isapproved, timesheetapprovalnodes10.approverrole, timesheetapprovalnodes10.userid, timesheetapprovalnodes10.timesheetid, timesheetapprovalnodes10.systemprocessidentifier, timesheetapprovalnodes10.scriptid, timesheetapprovalnodes10.agentresolutionstate
25. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on "1921f143c7c74d9587f3e84e353e664d".timesheet timesheet9 (cost=0.42..2.45 rows=1 width=16) (never executed)

  • Output: timesheet9.id, timesheet9.userid, timesheet9.startdate, timesheet9.enddate, timesheet9.approvalstatus, timesheet9.duedate, timesheet9.autosubmitdatetimeutc, timesheet9.lastautosubmitattemptdatetimeutc, timesheet9.createdonutc
  • Index Cond: (timesheet9.id = timesheetapprovalnodes10.timesheetid)
  • Filter: ((timeoffs3.startdate <= timesheet9.enddate) AND (timeoffs3.enddate >= timesheet9.startdate) AND (timesheet9.userid = timeoffs3.userid))
26. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvkey on "1921f143c7c74d9587f3e84e353e664d".tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue8 (cost=0.27..2.29 rows=1 width=83) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on "1921f143c7c74d9587f3e84e353e664d".tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue12 (cost=0.14..2.16 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue12.id, tsapprovalrequestkeyvalue12.tsapprovalrequestid, tsapprovalrequestkeyvalue12.parentid, tsapprovalrequestkeyvalue12.index, tsapprovalrequestkeyvalue12.key, tsapprovalrequestkeyvalue12.uri, tsapprovalrequestkeyvalue12.slug, tsapprovalrequestkeyvalue12."boolean", tsapprovalrequestkeyvalue12.date, tsapprovalrequestkeyvalue12.number, tsapprovalrequestkeyvalue12.text, tsapprovalrequestkeyvalue12."time", tsapprovalrequestkeyvalue12.timespan, tsapprovalrequestkeyvalue12.daterange_startdate, tsapprovalrequestkeyvalue12.daterange_enddate, tsapprovalrequestkeyvalue12.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue12.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue12.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue12.workdayduration_workdays, tsapprovalrequestkeyvalue12.workdayduration_hours, tsapprovalrequestkeyvalue12.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue12.id = tsapprovalrequestkeyvalue8.parentid)
  • Filter: (tsapprovalrequestkeyvalue12.parentid IS NULL)
28. 0.000 37,220.174 ↓ 0.0 0 2,189,422

Nested Loop (cost=3.88..133.30 rows=1 width=32) (actual time=0.017..0.017 rows=0 loops=2,189,422)

  • Output: upper(sheetapprovalhistorykeyvalue13.uri)
  • Buffers: shared hit=26442566
29. 2,189.422 37,220.174 ↓ 0.0 0 2,189,422

Nested Loop (cost=3.44..132.77 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=2,189,422)

  • Output: sheetapprovalhistorykeyvalue21.id
  • Buffers: shared hit=26442566
30. 0.000 35,030.752 ↓ 0.0 0 2,189,422

Nested Loop (cost=3.01..129.30 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=2,189,422)

  • Output: sheetapprovalhistorykeyvalue20.id
  • Buffers: shared hit=26442566
31. 0.000 35,030.752 ↓ 0.0 0 2,189,422

Nested Loop (cost=2.58..128.77 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=2,189,422)

  • Output: sheetapprovalhistorykeyvalue19.id
  • Buffers: shared hit=26442566
32. 0.000 35,030.752 ↓ 0.0 0 2,189,422

Nested Loop (cost=2.15..127.62 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=2,189,422)

  • Output: sheetapprovalhistorykeyvalue18.id
  • Buffers: shared hit=26442566
33. 0.000 35,030.752 ↓ 0.0 0 2,189,422

Nested Loop (cost=1.71..126.33 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=2,189,422)

  • Output: sheetapprovalhistorykeyvalue17.parentid
  • Buffers: shared hit=26442566
34. 2,189.422 35,030.752 ↓ 0.0 0 2,189,422

Nested Loop (cost=1.28..123.98 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=2,189,422)

  • Output: sheetapprovalhistorykeyvalue16.parentid
  • Buffers: shared hit=26442566
35. 1.452 32,841.330 ↓ 0.0 0 2,189,422

Nested Loop (cost=0.85..109.17 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=2,189,422)

  • Output: timesheetapprovalhistory15.id
  • Buffers: shared hit=26442566
36. 26,273.064 26,273.064 ↑ 25.0 1 2,189,422

Index Scan using ixtsuseridstartdateenddate on "1921f143c7c74d9587f3e84e353e664d".timesheet timesheet14 (cost=0.42..22.29 rows=25 width=16) (actual time=0.012..0.012 rows=1 loops=2,189,422)

  • Output: timesheet14.id, timesheet14.userid, timesheet14.startdate, timesheet14.enddate, timesheet14.approvalstatus, timesheet14.duedate, timesheet14.autosubmitdatetimeutc, timesheet14.lastautosubmitattemptdatetimeutc, timesheet14.createdonutc
  • Index Cond: ((timesheet14.userid = timeoffs3.userid) AND (timeoffs3.enddate >= timesheet14.startdate) AND (timeoffs3.startdate <= timesheet14.enddate))
  • Buffers: shared hit=15798668
37. 6,566.814 6,566.814 ↓ 0.0 0 2,188,938

Index Scan using ixtah2timesheetid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistory timesheetapprovalhistory15 (cost=0.42..3.46 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=2,188,938)

  • Output: timesheetapprovalhistory15.id, timesheetapprovalhistory15.action, timesheetapprovalhistory15.approvalcomments, timesheetapprovalhistory15.timestamputc, timesheetapprovalhistory15.serialnumber, timesheetapprovalhistory15.timesheetid, timesheetapprovalhistory15.approvalagenttype, timesheetapprovalhistory15.userid, timesheetapprovalhistory15.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory15.timesheetid = timesheet14.id)
  • Filter: (timesheetapprovalhistory15.userid = 1561)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=10643898
38. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue16 (cost=0.43..14.80 rows=1 width=32) (never executed)

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

Index Scan using timesheetapprovalhistorykeyvalue_pkey on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue17 (cost=0.43..2.34 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue18 (cost=0.43..1.28 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.parentid = sheetapprovalhistorykeyvalue17.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue18.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
41. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue19 (cost=0.43..1.13 rows=2 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.parentid = sheetapprovalhistorykeyvalue18.id)
42. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue20 (cost=0.43..0.51 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.id)
  • Filter: (upper(sheetapprovalhistorykeyvalue20.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
43. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue21 (cost=0.43..3.46 rows=2 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)
44. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue13 (cost=0.43..0.50 rows=2 width=93) (never executed)

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

Nested Loop (cost=0.84..10.43 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=2,189,422)

  • Output: upper(tsapprovalrequestkeyvalue22.uri)
  • Buffers: shared hit=2189422
46. 0.000 6,568.266 ↓ 0.0 0 2,189,422

Nested Loop (cost=0.69..8.25 rows=1 width=79) (actual time=0.003..0.003 rows=0 loops=2,189,422)

  • Output: tsapprovalrequestkeyvalue22.uri, tsapprovalrequestkeyvalue22.parentid
  • Join Filter: (tsapprovalrequest25.id = tsapprovalrequestkeyvalue22.tsapprovalrequestid)
  • Buffers: shared hit=2189422
47. 0.000 6,568.266 ↓ 0.0 0 2,189,422

Nested Loop (cost=0.42..5.95 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=2,189,422)

  • Output: tsapprovalrequest25.id
  • Buffers: shared hit=2189422
48. 0.000 6,568.266 ↓ 0.0 0 2,189,422

Nested Loop (cost=0.00..3.49 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=2,189,422)

  • Output: timesheetapprovalnodes24.timesheetid, tsapprovalrequest25.id
  • Join Filter: (timesheetapprovalnodes24.id = tsapprovalrequest25.nodeid)
  • Buffers: shared hit=2189422
49. 6,568.266 6,568.266 ↓ 0.0 0 2,189,422

Seq Scan on "1921f143c7c74d9587f3e84e353e664d".tsapprovalrequest tsapprovalrequest25 (cost=0.00..1.32 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=2,189,422)

  • Output: tsapprovalrequest25.id, tsapprovalrequest25.effectivedateutc, tsapprovalrequest25.userid, tsapprovalrequest25.nodeid, tsapprovalrequest25.remindersentutc, tsapprovalrequest25.overduesentutc, tsapprovalrequest25.waitingbatchsentutc, tsapprovalrequest25.approvalagenttype, tsapprovalrequest25.systemprocessidentifier
  • Filter: (tsapprovalrequest25.userid = 1561)
  • Rows Removed by Filter: 26
  • Buffers: shared hit=2189422
50. 0.000 0.000 ↓ 0.0 0

Seq Scan on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalnodes timesheetapprovalnodes24 (cost=0.00..1.52 rows=52 width=32) (never executed)

  • Output: timesheetapprovalnodes24.id, timesheetapprovalnodes24.isapproved, timesheetapprovalnodes24.approverrole, timesheetapprovalnodes24.userid, timesheetapprovalnodes24.timesheetid, timesheetapprovalnodes24.systemprocessidentifier, timesheetapprovalnodes24.scriptid, timesheetapprovalnodes24.agentresolutionstate
51. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on "1921f143c7c74d9587f3e84e353e664d".timesheet timesheet23 (cost=0.42..2.45 rows=1 width=16) (never executed)

  • Output: timesheet23.id, timesheet23.userid, timesheet23.startdate, timesheet23.enddate, timesheet23.approvalstatus, timesheet23.duedate, timesheet23.autosubmitdatetimeutc, timesheet23.lastautosubmitattemptdatetimeutc, timesheet23.createdonutc
  • Index Cond: (timesheet23.id = timesheetapprovalnodes24.timesheetid)
  • Filter: ((timeoffs3.startdate <= timesheet23.enddate) AND (timeoffs3.enddate >= timesheet23.startdate) AND (timesheet23.userid = timeoffs3.userid))
52. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvkey on "1921f143c7c74d9587f3e84e353e664d".tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue22 (cost=0.27..2.29 rows=1 width=83) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on "1921f143c7c74d9587f3e84e353e664d".tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue26 (cost=0.14..2.16 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue26.id, tsapprovalrequestkeyvalue26.tsapprovalrequestid, tsapprovalrequestkeyvalue26.parentid, tsapprovalrequestkeyvalue26.index, tsapprovalrequestkeyvalue26.key, tsapprovalrequestkeyvalue26.uri, tsapprovalrequestkeyvalue26.slug, tsapprovalrequestkeyvalue26."boolean", tsapprovalrequestkeyvalue26.date, tsapprovalrequestkeyvalue26.number, tsapprovalrequestkeyvalue26.text, tsapprovalrequestkeyvalue26."time", tsapprovalrequestkeyvalue26.timespan, tsapprovalrequestkeyvalue26.daterange_startdate, tsapprovalrequestkeyvalue26.daterange_enddate, tsapprovalrequestkeyvalue26.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue26.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue26.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue26.workdayduration_workdays, tsapprovalrequestkeyvalue26.workdayduration_hours, tsapprovalrequestkeyvalue26.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue26.id = tsapprovalrequestkeyvalue22.parentid)
  • Filter: (tsapprovalrequestkeyvalue26.parentid IS NULL)
54. 0.000 35,030.752 ↓ 0.0 0 2,189,422

Nested Loop (cost=3.88..133.30 rows=1 width=32) (actual time=0.016..0.016 rows=0 loops=2,189,422)

  • Output: upper(sheetapprovalhistorykeyvalue27.uri)
  • Buffers: shared hit=26442566
55. 0.000 35,030.752 ↓ 0.0 0 2,189,422

Nested Loop (cost=3.44..132.77 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=2,189,422)

  • Output: sheetapprovalhistorykeyvalue35.id
  • Buffers: shared hit=26442566
56. 0.000 35,030.752 ↓ 0.0 0 2,189,422

Nested Loop (cost=3.01..129.30 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=2,189,422)

  • Output: sheetapprovalhistorykeyvalue34.id
  • Buffers: shared hit=26442566
57. 2,189.422 35,030.752 ↓ 0.0 0 2,189,422

Nested Loop (cost=2.58..128.77 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=2,189,422)

  • Output: sheetapprovalhistorykeyvalue33.id
  • Buffers: shared hit=26442566
58. 0.000 32,841.330 ↓ 0.0 0 2,189,422

Nested Loop (cost=2.15..127.62 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=2,189,422)

  • Output: sheetapprovalhistorykeyvalue32.id
  • Buffers: shared hit=26442566
59. 0.000 32,841.330 ↓ 0.0 0 2,189,422

Nested Loop (cost=1.71..126.33 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=2,189,422)

  • Output: sheetapprovalhistorykeyvalue31.parentid
  • Buffers: shared hit=26442566
60. 0.000 32,841.330 ↓ 0.0 0 2,189,422

Nested Loop (cost=1.28..123.98 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=2,189,422)

  • Output: sheetapprovalhistorykeyvalue30.parentid
  • Buffers: shared hit=26442566
61. 1.452 32,841.330 ↓ 0.0 0 2,189,422

Nested Loop (cost=0.85..109.17 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=2,189,422)

  • Output: timesheetapprovalhistory29.id
  • Buffers: shared hit=26442566
62. 26,273.064 26,273.064 ↑ 25.0 1 2,189,422

Index Scan using ixtsuseridstartdateenddate on "1921f143c7c74d9587f3e84e353e664d".timesheet timesheet28 (cost=0.42..22.29 rows=25 width=16) (actual time=0.012..0.012 rows=1 loops=2,189,422)

  • Output: timesheet28.id, timesheet28.userid, timesheet28.startdate, timesheet28.enddate, timesheet28.approvalstatus, timesheet28.duedate, timesheet28.autosubmitdatetimeutc, timesheet28.lastautosubmitattemptdatetimeutc, timesheet28.createdonutc
  • Index Cond: ((timesheet28.userid = timeoffs3.userid) AND (timeoffs3.enddate >= timesheet28.startdate) AND (timeoffs3.startdate <= timesheet28.enddate))
  • Buffers: shared hit=15798668
63. 6,566.814 6,566.814 ↓ 0.0 0 2,188,938

Index Scan using ixtah2timesheetid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistory timesheetapprovalhistory29 (cost=0.42..3.46 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=2,188,938)

  • Output: timesheetapprovalhistory29.id, timesheetapprovalhistory29.action, timesheetapprovalhistory29.approvalcomments, timesheetapprovalhistory29.timestamputc, timesheetapprovalhistory29.serialnumber, timesheetapprovalhistory29.timesheetid, timesheetapprovalhistory29.approvalagenttype, timesheetapprovalhistory29.userid, timesheetapprovalhistory29.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory29.timesheetid = timesheet28.id)
  • Filter: (timesheetapprovalhistory29.userid = 1561)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=10643898
64. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue30 (cost=0.43..14.80 rows=1 width=32) (never executed)

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

Index Scan using timesheetapprovalhistorykeyvalue_pkey on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue31 (cost=0.43..2.34 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue32 (cost=0.43..1.28 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.parentid = sheetapprovalhistorykeyvalue31.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue32.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
67. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue33 (cost=0.43..1.13 rows=2 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.parentid = sheetapprovalhistorykeyvalue32.id)
68. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue34 (cost=0.43..0.51 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.id)
  • Filter: (upper(sheetapprovalhistorykeyvalue34.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
69. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue35 (cost=0.43..3.46 rows=2 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)
70. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "1921f143c7c74d9587f3e84e353e664d".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue27 (cost=0.43..0.50 rows=2 width=93) (never executed)

  • Output: sheetapprovalhistorykeyvalue27.id, sheetapprovalhistorykeyvalue27.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue27.parentid, sheetapprovalhistorykeyvalue27.index, sheetapprovalhistorykeyvalue27.key, sheetapprovalhistorykeyvalue27.uri, sheetapprovalhistorykeyvalue27.slug, sheetapprovalhistorykeyvalue27."boolean", sheetapprovalhistorykeyvalue27.date, sheetapprovalhistorykeyvalue27.number, sheetapprovalhistorykeyvalue27.text, sheetapprovalhistorykeyvalue27."time", sheetapprovalhistorykeyvalue27.timespan, sheetapprovalhistorykeyvalue27.daterange_startdate, sheetapprovalhistorykeyvalue27.daterange_enddate, sheetapprovalhistorykeyvalue27.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue27.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue27.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue27.workdayduration_workdays, sheetapprovalhistorykeyvalue27.workdayduration_hours, sheetapprovalhistorykeyvalue27.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue27.parentid = sheetapprovalhistorykeyvalue35.id)
Planning time : 21.277 ms
Execution time : 103,175.010 ms