explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A0Us

Settings
# exclusive inclusive rows x rows loops node
1. 1.630 4,124,276.784 ↓ 1.5 711 1

Sort (cost=801,253,606,789,601.75..801,253,606,789,603.00 rows=480 width=845) (actual time=4,124,276.744..4,124,276.784 rows=711 loops=1)

  • Output: ((userinfo0.displayname)::text), ((ui.lastname)::character varying(50)), ((ui.firstname)::character varying(50)), ui.duplicatename, ((login.loginname)::character varying(255)), ((ui.displayname)::text), ui.id, "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid
  • Sort Key: ((userinfo0.displayname)::text) COLLATE "en_US", ((ui.lastname)::character varying(50)) COLLATE "en_US", ((ui.firstname)::character varying(50)) COLLATE "en_US", ui.duplicatename, ((login.loginname)::character varying(255)) COLLATE "en_US", ((ui.displayname)::text) COLLATE "en_US", "*SELECT* 1".entrydate
  • Sort Method: quicksort Memory: 124kB
  • Buffers: shared hit=887,338,750 read=2,332,072
2. 246.576 4,124,275.154 ↓ 1.5 711 1

Nested Loop (cost=9,107.11..801,253,606,789,580.38 rows=480 width=845) (actual time=3,162,556.327..4,124,275.154 rows=711 loops=1)

  • Output: userinfo0.displayname, ui.lastname, ui.firstname, ui.duplicatename, login.loginname, ui.displayname, ui.id, "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid
  • Inner Unique: true
  • Join Filter: ("*SELECT* 1".userid = login.userid)
  • Rows Removed by Join Filter: 3,510,533
  • Buffers: shared hit=887,338,735 read=2,332,072
3. 0.664 4,123,833.764 ↓ 1.5 711 1

Nested Loop Left Join (cost=9,107.11..801,253,606,744,445.00 rows=480 width=78) (actual time=3,162,546.409..4,123,833.764 rows=711 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id, userdepartmentgroup9.userid, userinfo0.displayname, userdepartmentgroup12.userid
  • Filter: (((timeentrymetadata10.uri IS NULL) AND ("*SELECT* 1".timeoffentryid IS NULL) AND (("*SELECT* 1".timeallocationtype = 1) OR ("*SELECT* 1".timeallocationtype IS NULL))) OR (timeentrymetadata10.uri IS NOT NULL) OR ("*SELECT* 1".timeoffentryid IS NOT NULL) OR ((timeentrymetadata10.uri IS NULL) AND ("*SELECT* 1".timeoffentryid IS NULL) AND ("*SELECT* 1".timeallocationtype = 0)))
  • Buffers: shared hit=887,338,673 read=2,332,028
4. 0.710 4,123,830.256 ↓ 1.5 711 1

Nested Loop Left Join (cost=9,106.55..801,253,606,743,338.38 rows=481 width=102) (actual time=3,162,546.394..4,123,830.256 rows=711 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".timeoffentryid, "*SELECT* 1".timeallocationtype, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id, userdepartmentgroup9.userid, userinfo0.displayname, userdepartmentgroup12.userid
  • Buffers: shared hit=887,335,928 read=2,332,028
5. 2.772 4,123,820.303 ↓ 1.5 711 1

Nested Loop Semi Join (cost=9,105.99..801,253,606,743,013.50 rows=481 width=88) (actual time=3,162,546.369..4,123,820.303 rows=711 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".timeoffentryid, "*SELECT* 1".timeallocationtype, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id, userdepartmentgroup9.userid, userdepartmentgroup12.userid
  • Join Filter: ("*SELECT* 1".userid = userdepartmentgroup12.userid)
  • Rows Removed by Join Filter: 14,185
  • Buffers: shared hit=887,331,550 read=2,332,023
6. 0.603 4,123,807.577 ↑ 1.4 711 1

Nested Loop Left Join (cost=9,105.70..801,253,606,708,572.25 rows=962 width=84) (actual time=3,162,544.665..4,123,807.577 rows=711 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".timeoffentryid, "*SELECT* 1".timeallocationtype, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id, userdepartmentgroup9.userid
  • Buffers: shared hit=887,321,622 read=2,332,023
7. 226.821 4,123,419.479 ↓ 1.1 711 1

Nested Loop (cost=9,105.14..801,253,606,706,664.00 rows=640 width=88) (actual time=3,162,543.835..4,123,419.479 rows=711 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".timeoffentryid, "*SELECT* 1".timeallocationtype, project5.id, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id, userdepartmentgroup9.userid
  • Inner Unique: true
  • Join Filter: ("*SELECT* 1".userid = ui.id)
  • Rows Removed by Join Filter: 2,743,266
  • Buffers: shared hit=887,318,459 read=2,331,743
8. 3.563 4,122,995.711 ↓ 1.1 711 1

Nested Loop Left Join (cost=9,105.14..801,253,606,646,282.62 rows=642 width=56) (actual time=3,162,516.297..4,122,995.711 rows=711 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".timeoffentryid, "*SELECT* 1".timeallocationtype, project5.id, userdepartmentgroup9.userid
  • Inner Unique: true
  • Buffers: shared hit=887,318,315 read=2,331,705
9. 0.577 4,122,978.639 ↓ 1.1 711 1

Nested Loop Left Join (cost=9,104.71..801,253,606,645,962.75 rows=642 width=115) (actual time=3,162,516.293..4,122,978.639 rows=711 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".timeoffentryid, "*SELECT* 1".timeallocationtype, timeentrymetadata4.uri, userdepartmentgroup9.userid
  • Buffers: shared hit=887,318,226 read=2,331,695
10. 2.584 4,122,960.287 ↓ 1.1 711 1

Nested Loop (cost=9,104.14..801,253,606,644,489.12 rows=642 width=52) (actual time=3,162,516.262..4,122,960.287 rows=711 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".timeoffentryid, "*SELECT* 1".timeallocationtype, userdepartmentgroup9.userid
  • Join Filter: ("*SELECT* 1".userid = userdepartmentgroup9.userid)
  • Rows Removed by Join Filter: 24,885
  • Buffers: shared hit=887,315,468 read=2,331,684
11. 32.683 32.683 ↓ 1.0 36 1

Index Only Scan using ix4ucc_userdepartmentgroupstartend on ec59310f04eb4b13a07d9dd6e7e07b8c.userdepartmentgroup userdepartmentgroup9 (cost=0.28..201.82 rows=35 width=4) (actual time=32.178..32.683 rows=36 loops=1)

  • Output: userdepartmentgroup9.userid, userdepartmentgroup9.departmentgroupid, userdepartmentgroup9.startdate, userdepartmentgroup9.enddate
  • Index Cond: ((userdepartmentgroup9.startdate <= '2020-09-16'::date) AND (userdepartmentgroup9.enddate >= '2020-09-16'::date))
  • Filter: (userdepartmentgroup9.departmentgroupid = ANY ('{5b1a9f95-e64f-414c-9bcc-72e34fbc457a,38c17637-138d-4964-a34f-edcd4d1366f8}'::uuid[]))
  • Rows Removed by Filter: 6,246
  • Heap Fetches: 1,377
  • Buffers: shared hit=507 read=64
12. 2.751 4,122,925.020 ↑ 160.5 711 36

Materialize (cost=9,103.86..801,253,606,584,646.12 rows=114,146 width=48) (actual time=86,132.146..114,525.695 rows=711 loops=36)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".timeoffentryid, "*SELECT* 1".timeallocationtype
  • Buffers: shared hit=887,314,961 read=2,331,620
13. 0.310 4,122,922.269 ↑ 160.5 711 1

Append (cost=9,103.86..801,253,606,584,075.38 rows=114,146 width=48) (actual time=3,100,757.248..4,122,922.269 rows=711 loops=1)

  • Buffers: shared hit=887,314,961 read=2,331,620
14. 507,767.525 4,112,772.304 ↑ 164.8 685 1

Subquery Scan on *SELECT* 1 (cost=9,103.86..792,540,608,650,812.62 rows=112,905 width=48) (actual time=3,100,757.247..4,112,772.304 rows=685 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".timeoffentryid, "*SELECT* 1".timeallocationtype
  • Filter: ((SubPlan 16) OR (hashed SubPlan 18))
  • Rows Removed by Filter: 168,267
  • Buffers: shared hit=887,305,324 read=2,330,266
15. 97.963 1,534.487 ↓ 1.1 168,952 1

Nested Loop (cost=1,001.56..306,304.22 rows=150,540 width=140) (actual time=12.167..1,534.487 rows=168,952 loops=1)

  • Output: te.id, NULL::integer, te.userid, te.entrydate, NULL::time without time zone, NULL::time without time zone, CASE WHEN (te.hours IS NOT NULL) THEN te.hours WHEN ((te.intime IS NULL) OR (te.outtime IS NULL)) THEN NULL::interval WHEN ((te.outtime - te.intime) >= '00:00:00'::interval) THEN (te.outtime - te.intime) ELSE (('24:00:00'::interval + (te.outtime)::interval) - (te.intime)::interval) END, NULL::uuid, NULL::integer, NULL::interval, NULL::integer, NULL::interval, NULL::interval, te.timeallocationtype, NULL::integer
  • Buffers: shared hit=1,237,580 read=156,811
16. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on ec59310f04eb4b13a07d9dd6e7e07b8c.projectsysteminformation psi (cost=0.00..1.01 rows=1 width=0) (actual time=0.003..0.004 rows=1 loops=1)

  • Output: psi.usercustombillingrateid, psi.projectcustombillingrateid, psi.defaultprojectstatuslabelid, psi.defaultinvoicecompanyaddressid, psi.defaultinvoicetemplateid, psi.defaultbillingratesfornewclients, psi.billingprocesstype, psi.projectworkflowmode, psi.resourcingdatasource, psi.projectnameunique, psi.projectcoderequiredandunique, psi.clientnameunique, psi.clientcoderequiredandunique
  • Buffers: shared hit=1
17. 61.660 1,436.520 ↓ 1.1 168,952 1

Nested Loop (cost=1,001.56..302,163.36 rows=150,540 width=60) (actual time=12.162..1,436.520 rows=168,952 loops=1)

  • Output: te.id, te.userid, te.entrydate, te.hours, te.intime, te.outtime, te.timeallocationtype
  • Buffers: shared hit=1,237,579 read=156,811
18. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on ec59310f04eb4b13a07d9dd6e7e07b8c.systeminformation si (cost=0.00..1.01 rows=1 width=0) (actual time=0.002..0.004 rows=1 loops=1)

  • Output: si.rootuserid, si.basecurrencyid, si.basecurrencysymbol, si.defaulttimesheetapprovalpathid, si.defaultexpenseapprovalpathid, si.defaulttimeoffapprovalpathid, si.defaultlanguageid, si.defaultholidaycalendarid, si.buildnumber, si.isreleaseversion, si.systemguid, si.systemtimezoneid, si.newuserdefaulttimezoneid, si.databaseguid, si.uncategorizedskillcategoryid, si.defaultofficescheduleid, si.customlogouri, si.databaseupdatescriptstage, si.tenantslug, si.defaulttimesheetperiodid, si.defaulttimeentryapprovalpathid
  • Buffers: shared hit=1
19. 0.000 1,374.856 ↓ 1.1 168,952 1

Gather (cost=1,001.56..300,656.95 rows=150,540 width=60) (actual time=12.158..1,374.856 rows=168,952 loops=1)

  • Output: te.id, te.userid, te.entrydate, te.hours, te.intime, te.outtime, te.timeallocationtype
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1,237,578 read=156,811
20. 52.845 65,009.613 ↑ 1.1 56,317 3 / 3

Nested Loop Left Join (cost=1.56..284,602.95 rows=62,725 width=60) (actual time=9.745..65,009.613 rows=56,317 loops=3)

  • Output: te.id, te.userid, te.entrydate, te.hours, te.intime, te.outtime, te.timeallocationtype
  • Buffers: shared hit=1,237,578 read=156,811
  • Worker 0: actual time=11.785..191570.914 rows=167,510 loops=1
  • Buffers: shared hit=1,228,092 read=153,966
  • Worker 1: actual time=7.638..3282.347 rows=1,205 loops=1
  • Buffers: shared hit=7,719 read=2,678
21. 59.919 64,675.181 ↑ 1.1 56,317 3 / 3

Nested Loop Left Join (cost=0.99..145,452.98 rows=62,725 width=60) (actual time=9.732..64,675.181 rows=56,317 loops=3)

  • Output: te.id, te.userid, te.entrydate, te.hours, te.intime, te.outtime, te.timeallocationtype
  • Buffers: shared hit=560,466 read=156,685
  • Worker 0: actual time=11.777..190577.131 rows=167,510 loops=1
  • Buffers: shared hit=556,760 read=153,841
  • Worker 1: actual time=7.626..3274.060 rows=1,205 loops=1
  • Buffers: shared hit=2,888 read=2,677
22. 4,749.937 4,749.937 ↑ 1.1 56,317 3 / 3

Parallel Index Scan using ixte2entrydate on ec59310f04eb4b13a07d9dd6e7e07b8c.timeentry te (cost=0.43..6,303.00 rows=62,725 width=60) (actual time=5.935..4,749.937 rows=56,317 loops=3)

  • Output: te.id, te.userid, te.entrydate, te.timeallocationtype, te.hours, te.intime, te.outtime, te.approvalstatus
  • Index Cond: ((te.entrydate >= '2020-09-13'::date) AND (te.entrydate <= '2020-09-19'::date))
  • Filter: ((te.timeallocationtype <> 2) OR (te.timeallocationtype IS NULL))
  • Rows Removed by Filter: 12
  • Buffers: shared hit=14,048 read=14,965
  • Worker 0: actual time=7.104..13536.221 rows=167,510 loops=1
  • Buffers: shared hit=13,985 read=14,282
  • Worker 1: actual time=4.507..702.935 rows=1,205 loops=1
  • Buffers: shared hit=53 read=658
23. 59,865.325 59,865.325 ↓ 0.0 0 168,952 / 3

Index Scan using ixtem2timeentryid on ec59310f04eb4b13a07d9dd6e7e07b8c.timeentrymetadata tembillingrate (cost=0.56..2.21 rows=1 width=16) (actual time=1.063..1.063 rows=0 loops=168,952)

  • Output: tembillingrate.id, tembillingrate.timeentryid, tembillingrate.parentid, tembillingrate.index, tembillingrate.key, tembillingrate.uri, tembillingrate.slug, tembillingrate."boolean", tembillingrate.date, tembillingrate.number, tembillingrate.text, tembillingrate."time", tembillingrate.timespan, tembillingrate.daterange_startdate, tembillingrate.daterange_enddate, tembillingrate.daterange_relativedaterangeuri, tembillingrate.daterange_relativedaterangeasofdate, tembillingrate.workdayduration_decimalworkdays, tembillingrate.workdayduration_workdays, tembillingrate.workdayduration_hours, tembillingrate.workdayduration_minutes
  • Index Cond: ((tembillingrate.timeentryid = te.id) AND (upper(tembillingrate.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BILLING-RATE'::text))
  • Buffers: shared hit=546,418 read=141,720
  • Worker 0: actual time=1.056..1.056 rows=0 loops=167,510
  • Buffers: shared hit=542,775 read=139,559
  • Worker 1: actual time=2.132..2.132 rows=0 loops=1,205
  • Buffers: shared hit=2,835 read=2,019
24. 281.587 281.587 ↓ 0.0 0 168,952 / 3

Index Scan using ixtem2timeentryid on ec59310f04eb4b13a07d9dd6e7e07b8c.timeentrymetadata temdbreaktype (cost=0.56..2.21 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=168,952)

  • Output: temdbreaktype.id, temdbreaktype.timeentryid, temdbreaktype.parentid, temdbreaktype.index, temdbreaktype.key, temdbreaktype.uri, temdbreaktype.slug, temdbreaktype."boolean", temdbreaktype.date, temdbreaktype.number, temdbreaktype.text, temdbreaktype."time", temdbreaktype.timespan, temdbreaktype.daterange_startdate, temdbreaktype.daterange_enddate, temdbreaktype.daterange_relativedaterangeuri, temdbreaktype.daterange_relativedaterangeasofdate, temdbreaktype.workdayduration_decimalworkdays, temdbreaktype.workdayduration_workdays, temdbreaktype.workdayduration_hours, temdbreaktype.workdayduration_minutes
  • Index Cond: ((temdbreaktype.timeentryid = te.id) AND (upper(temdbreaktype.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BREAK-TYPE'::text))
  • Buffers: shared hit=677,112 read=126
  • Worker 0: actual time=0.005..0.005 rows=0 loops=167,510
  • Buffers: shared hit=671,332 read=125
  • Worker 1: actual time=0.005..0.005 rows=0 loops=1,205
  • Buffers: shared hit=4,831 read=1
25.          

SubPlan (for Subquery Scan)

26. 504,264.119 3,602,984.216 ↑ 186.9 41,094 170,612

Materialize (cost=2,950.12..10,529,286,366.43 rows=7,682,149 width=16) (actual time=0.190..21.118 rows=41,094 loops=170,612)

  • Output: timeentryrevision13.timeentryid
  • Buffers: shared hit=886,067,239 read=2,170,676
27. 648.930 3,098,720.097 ↑ 186.6 41,179 1

Merge Join (cost=2,950.12..10,529,210,444.68 rows=7,682,149 width=16) (actual time=32,442.429..3,098,720.097 rows=41,179 loops=1)

  • Output: timeentryrevision13.timeentryid
  • Inner Unique: true
  • Merge Cond: (timeentryrevision13.id = timeentryrevision14.id)
  • Buffers: shared hit=886,067,239 read=2,170,676
28. 23,718.804 23,718.804 ↑ 1.0 7,756,532 1

Index Scan using timeentryrevision_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timeentryrevision timeentryrevision13 (cost=0.56..880,073.99 rows=7,776,877 width=32) (actual time=0.023..23,718.804 rows=7,756,532 loops=1)

  • Output: timeentryrevision13.id, timeentryrevision13.txid, timeentryrevision13.previousrevisionid, timeentryrevision13.timeentryid, timeentryrevision13.fromtimestamputc, timeentryrevision13.totimestamputc, timeentryrevision13.openingauditid, timeentryrevision13.closingauditid, timeentryrevision13.userid, timeentryrevision13.entrydate, timeentryrevision13.timeallocationtype, timeentryrevision13.hours, timeentryrevision13.intime, timeentryrevision13.outtime, timeentryrevision13.approvalstatus
  • Filter: (timeentryrevision13.totimestamputc IS NULL)
  • Rows Removed by Filter: 13,959,445
  • Buffers: shared hit=125,427 read=34,872
29. 156,907.043 3,074,352.363 ↑ 180.2 118,730 1

Index Scan using timeentryrevision_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timeentryrevision timeentryrevision14 (cost=2,949.55..10,528,180,632.49 rows=21,389,806 width=16) (actual time=30,032.299..3,074,352.363 rows=118,730 loops=1)

  • Output: timeentryrevision14.id, timeentryrevision14.txid, timeentryrevision14.previousrevisionid, timeentryrevision14.timeentryid, timeentryrevision14.fromtimestamputc, timeentryrevision14.totimestamputc, timeentryrevision14.openingauditid, timeentryrevision14.closingauditid, timeentryrevision14.userid, timeentryrevision14.entrydate, timeentryrevision14.timeallocationtype, timeentryrevision14.hours, timeentryrevision14.intime, timeentryrevision14.outtime, timeentryrevision14.approvalstatus
  • Filter: ((hashed SubPlan 1) OR (timeentryrevision14.userid = 4,522) OR (SubPlan 2) OR (SubPlan 3) OR (SubPlan 4) OR (SubPlan 5) OR ((SubPlan 8) AND ((SubPlan 9) OR (SubPlan 10))) OR ((SubPlan 13) AND ((SubPlan 14) OR (SubPlan 15))))
  • Rows Removed by Filter: 21,597,490
  • Buffers: shared hit=885,941,812 read=2,135,804
30.          

SubPlan (for Index Scan)

31. 20.722 23,381.660 ↓ 1.8 118,799 1

Nested Loop (cost=1.54..2,782.78 rows=66,486 width=16) (actual time=20.859..23,381.660 rows=118,799 loops=1)

  • Output: timeentryrevision15.id
  • Buffers: shared hit=11,898 read=71,074
32. 0.823 251.126 ↓ 9.4 1,594 1

Nested Loop (cost=0.98..88.34 rows=170 width=16) (actual time=17.437..251.126 rows=1,594 loops=1)

  • Output: timesheet16.userid, timesheet16.startdate, timesheet16.enddate, userdepartmentgroup17.userid
  • Buffers: shared hit=297 read=299
33. 0.048 12.043 ↓ 1.1 38 1

Nested Loop (cost=0.56..47.18 rows=36 width=12) (actual time=4.155..12.043 rows=38 loops=1)

  • Output: userdepartmentgroup17.userid, userdepartmentgroup17.startdate, userdepartmentgroup17.enddate
  • Buffers: shared hit=8 read=10
34. 2.937 2.937 ↑ 1.0 2 1

Index Only Scan using departmentgroupflathierarchy_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.departmentgroupflathierarchy departmentgroupflathierarchy18 (cost=0.28..1.31 rows=2 width=16) (actual time=2.936..2.937 rows=2 loops=1)

  • Output: departmentgroupflathierarchy18.parentid, departmentgroupflathierarchy18.childid
  • Index Cond: (departmentgroupflathierarchy18.parentid = '5b1a9f95-e64f-414c-9bcc-72e34fbc457a'::uuid)
  • Heap Fetches: 0
  • Buffers: shared read=3
35. 9.058 9.058 ↑ 1.3 19 2

Index Scan using ixudgdepartmentgroupid on ec59310f04eb4b13a07d9dd6e7e07b8c.userdepartmentgroup userdepartmentgroup17 (cost=0.28..22.70 rows=24 width=28) (actual time=1.396..4.529 rows=19 loops=2)

  • Output: userdepartmentgroup17.id, userdepartmentgroup17.userid, userdepartmentgroup17.departmentgroupid, userdepartmentgroup17.startdate, userdepartmentgroup17.enddate
  • Index Cond: (userdepartmentgroup17.departmentgroupid = departmentgroupflathierarchy18.childid)
  • Buffers: shared hit=8 read=7
36. 238.260 238.260 ↓ 8.4 42 38

Index Only Scan using ixtsuseridstartdateenddate on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheet timesheet16 (cost=0.42..1.09 rows=5 width=12) (actual time=0.949..6.270 rows=42 loops=38)

  • Output: timesheet16.userid, timesheet16.startdate, timesheet16.enddate
  • Index Cond: ((timesheet16.userid = userdepartmentgroup17.userid) AND (timesheet16.startdate <= userdepartmentgroup17.enddate) AND (timesheet16.enddate >= userdepartmentgroup17.startdate))
  • Heap Fetches: 728
  • Buffers: shared hit=289 read=289
37. 23,109.812 23,109.812 ↑ 5.4 75 1,594

Index Scan using ixter2userid on ec59310f04eb4b13a07d9dd6e7e07b8c.timeentryrevision timeentryrevision15 (cost=0.56..11.80 rows=405 width=24) (actual time=1.072..14.498 rows=75 loops=1,594)

  • Output: timeentryrevision15.id, timeentryrevision15.txid, timeentryrevision15.previousrevisionid, timeentryrevision15.timeentryid, timeentryrevision15.fromtimestamputc, timeentryrevision15.totimestamputc, timeentryrevision15.openingauditid, timeentryrevision15.closingauditid, timeentryrevision15.userid, timeentryrevision15.entrydate, timeentryrevision15.timeallocationtype, timeentryrevision15.hours, timeentryrevision15.intime, timeentryrevision15.outtime, timeentryrevision15.approvalstatus
  • Index Cond: ((timeentryrevision15.userid = timesheet16.userid) AND (timesheet16.startdate <= timeentryrevision15.entrydate) AND (timesheet16.enddate >= timeentryrevision15.entrydate))
  • Buffers: shared hit=11,601 read=70,775
38. 0.000 43,194.980 ↓ 0.0 0 21,597,490

Nested Loop (cost=1.54..25.23 rows=3 width=32) (actual time=0.002..0.002 rows=0 loops=21,597,490)

  • Output: upper(tsapprovalrequestkeyvalue19.uri)
  • Inner Unique: true
  • Buffers: shared hit=43,194,978 read=2
39. 21,597.490 43,194.980 ↓ 0.0 0 21,597,490

Nested Loop (cost=1.25..18.99 rows=13 width=84) (actual time=0.002..0.002 rows=0 loops=21,597,490)

  • Output: tsapprovalrequestkeyvalue19.uri, tsapprovalrequestkeyvalue19.parentid
  • Buffers: shared hit=43,194,978 read=2
40. 0.000 21,597.490 ↓ 0.0 0 21,597,490

Nested Loop (cost=0.97..7.07 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=21,597,490)

  • Output: tsapprovalrequest22.id
  • Inner Unique: true
  • Buffers: shared hit=43,194,978 read=2
41. 0.000 21,597.490 ↓ 0.0 0 21,597,490

Nested Loop (cost=0.55..4.59 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=21,597,490)

  • Output: timesheetapprovalnodes21.timesheetid, tsapprovalrequest22.id
  • Inner Unique: true
  • Buffers: shared hit=43,194,978 read=2
42. 21,597.490 21,597.490 ↓ 0.0 0 21,597,490

Index Scan using uix2tsar_nodeid_userid on ec59310f04eb4b13a07d9dd6e7e07b8c.tsapprovalrequest tsapprovalrequest22 (cost=0.27..2.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=21,597,490)

  • Output: tsapprovalrequest22.id, tsapprovalrequest22.nodeid, tsapprovalrequest22.effectivedateutc, tsapprovalrequest22.remindersentutc, tsapprovalrequest22.overduesentutc, tsapprovalrequest22.waitingbatchsentutc, tsapprovalrequest22.approvalagenttype, tsapprovalrequest22.userid, tsapprovalrequest22.systemprocessidentifier
  • Index Cond: (tsapprovalrequest22.userid = 4,522)
  • Buffers: shared hit=43,194,978 read=2
43. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalnodes timesheetapprovalnodes21 (cost=0.28..2.29 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes21.id, timesheetapprovalnodes21.timesheetid, timesheetapprovalnodes21.isapproved, timesheetapprovalnodes21.agentresolutionstate, timesheetapprovalnodes21.approverrole, timesheetapprovalnodes21.userid, timesheetapprovalnodes21.scriptid, timesheetapprovalnodes21.systemprocessidentifier
  • Index Cond: (timesheetapprovalnodes21.id = tsapprovalrequest22.nodeid)
44. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheet timesheet20 (cost=0.42..1.97 rows=1 width=16) (never executed)

  • Output: timesheet20.id, timesheet20.userid, timesheet20.startdate, timesheet20.enddate, timesheet20.approvalstatus, timesheet20.duedate, timesheet20.autosubmitdatetimeutc, timesheet20.lastautosubmitattemptdatetimeutc, timesheet20.createdonutc
  • Index Cond: (timesheet20.id = timesheetapprovalnodes21.timesheetid)
  • Filter: ((timesheet20.startdate <= timeentryrevision14.entrydate) AND (timesheet20.enddate >= timeentryrevision14.entrydate) AND (timesheet20.userid = timeentryrevision14.userid))
45. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on ec59310f04eb4b13a07d9dd6e7e07b8c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue19 (cost=0.28..11.79 rows=13 width=88) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue23 (cost=0.28..0.48 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue23.id, tsapprovalrequestkeyvalue23.tsapprovalrequestid, tsapprovalrequestkeyvalue23.parentid, tsapprovalrequestkeyvalue23.index, tsapprovalrequestkeyvalue23.key, tsapprovalrequestkeyvalue23.uri, tsapprovalrequestkeyvalue23.slug, tsapprovalrequestkeyvalue23."boolean", tsapprovalrequestkeyvalue23.date, tsapprovalrequestkeyvalue23.number, tsapprovalrequestkeyvalue23.text, tsapprovalrequestkeyvalue23."time", tsapprovalrequestkeyvalue23.timespan, tsapprovalrequestkeyvalue23.daterange_startdate, tsapprovalrequestkeyvalue23.daterange_enddate, tsapprovalrequestkeyvalue23.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue23.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue23.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue23.workdayduration_workdays, tsapprovalrequestkeyvalue23.workdayduration_hours, tsapprovalrequestkeyvalue23.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue23.id = tsapprovalrequestkeyvalue19.parentid)
  • Filter: (tsapprovalrequestkeyvalue23.parentid IS NULL)
47. 0.000 302,364.860 ↓ 0.0 0 21,597,490

Nested Loop (cost=16.75..59.69 rows=1 width=32) (actual time=0.014..0.014 rows=0 loops=21,597,490)

  • Output: upper(sheetapprovalhistorykeyvalue24.uri)
  • Buffers: shared hit=227,021,599 read=28,083
48. 0.000 302,364.860 ↓ 0.0 0 21,597,490

Nested Loop (cost=16.19..58.81 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=21,597,490)

  • Output: sheetapprovalhistorykeyvalue32.id
  • Buffers: shared hit=227,021,599 read=28,083
49. 21,597.490 302,364.860 ↓ 0.0 0 21,597,490

Nested Loop (cost=15.63..56.66 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=21,597,490)

  • Output: sheetapprovalhistorykeyvalue31.id
  • Buffers: shared hit=227,021,599 read=28,083
50. 0.000 280,767.370 ↓ 0.0 0 21,597,490

Nested Loop (cost=15.06..55.83 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=21,597,490)

  • Output: sheetapprovalhistorykeyvalue30.id
  • Buffers: shared hit=227,021,599 read=28,083
51. 0.000 280,767.370 ↓ 0.0 0 21,597,490

Nested Loop (cost=14.50..53.73 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=21,597,490)

  • Output: sheetapprovalhistorykeyvalue29.id
  • Buffers: shared hit=227,021,599 read=28,083
52. 0.000 280,767.370 ↓ 0.0 0 21,597,490

Nested Loop (cost=13.94..50.34 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=21,597,490)

  • Output: sheetapprovalhistorykeyvalue28.parentid
  • Inner Unique: true
  • Buffers: shared hit=227,021,599 read=28,083
53. 0.000 280,767.370 ↓ 0.0 0 21,597,490

Nested Loop (cost=13.38..47.75 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=21,597,490)

  • Output: sheetapprovalhistorykeyvalue27.parentid
  • Buffers: shared hit=227,021,599 read=28,083
54. 43,197.248 280,767.370 ↓ 0.0 0 21,597,490

Nested Loop (cost=0.85..34.19 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=21,597,490)

  • Output: timesheetapprovalhistory26.id
  • Buffers: shared hit=227,021,599 read=28,083
55. 86,389.960 86,389.960 ↑ 5.0 1 21,597,490

Index Scan using ixtsuseridstartdateenddate on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheet timesheet25 (cost=0.42..6.62 rows=5 width=16) (actual time=0.004..0.004 rows=1 loops=21,597,490)

  • Output: timesheet25.id, timesheet25.userid, timesheet25.startdate, timesheet25.enddate, timesheet25.approvalstatus, timesheet25.duedate, timesheet25.autosubmitdatetimeutc, timesheet25.lastautosubmitattemptdatetimeutc, timesheet25.createdonutc
  • Index Cond: ((timesheet25.userid = timeentryrevision14.userid) AND (timesheet25.startdate <= timeentryrevision14.entrydate) AND (timesheet25.enddate >= timeentryrevision14.entrydate))
  • Buffers: shared hit=95,361,553 read=4,023
56. 151,180.162 151,180.162 ↓ 0.0 0 21,597,166

Index Scan using ixtah2timesheetid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistory timesheetapprovalhistory26 (cost=0.42..5.50 rows=1 width=32) (actual time=0.007..0.007 rows=0 loops=21,597,166)

  • Output: timesheetapprovalhistory26.id, timesheetapprovalhistory26.serialnumber, timesheetapprovalhistory26.timesheetid, timesheetapprovalhistory26.action, timesheetapprovalhistory26.approvalcomments, timesheetapprovalhistory26.timestamputc, timesheetapprovalhistory26.approvalagenttype, timesheetapprovalhistory26.userid, timesheetapprovalhistory26.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory26.timesheetid = timesheet25.id)
  • Filter: (timesheetapprovalhistory26.userid = 4,522)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=131,660,046 read=24,060
57. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue27 (cost=12.53..13.55 rows=1 width=32) (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
  • Recheck Cond: ((sheetapprovalhistorykeyvalue27.timesheetapprovalhistoryid = timesheetapprovalhistory26.id) AND (upper(sheetapprovalhistorykeyvalue27.uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:4,522'::text))
  • Filter: (upper(sheetapprovalhistorykeyvalue27.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
58. 0.000 0.000 ↓ 0.0 0

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

59. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (sheetapprovalhistorykeyvalue27.timesheetapprovalhistoryid = timesheetapprovalhistory26.id)
60. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (upper(sheetapprovalhistorykeyvalue27.uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:4,522'::text)
61. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue28 (cost=0.56..2.59 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue29 (cost=0.56..3.38 rows=1 width=32) (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 = sheetapprovalhistorykeyvalue28.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue29.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
63. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue30 (cost=0.56..2.00 rows=10 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.parentid = sheetapprovalhistorykeyvalue29.id)
64. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue31 (cost=0.56..0.82 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.parentid = sheetapprovalhistorykeyvalue30.id)
  • Filter: (upper(sheetapprovalhistorykeyvalue31.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
65. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue32 (cost=0.56..2.06 rows=10 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.id)
66. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue24 (cost=0.56..0.77 rows=10 width=89) (never executed)

  • Output: sheetapprovalhistorykeyvalue24.id, sheetapprovalhistorykeyvalue24.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue24.parentid, sheetapprovalhistorykeyvalue24.index, sheetapprovalhistorykeyvalue24.key, sheetapprovalhistorykeyvalue24.uri, sheetapprovalhistorykeyvalue24.slug, sheetapprovalhistorykeyvalue24."boolean", sheetapprovalhistorykeyvalue24.date, sheetapprovalhistorykeyvalue24.number, sheetapprovalhistorykeyvalue24.text, sheetapprovalhistorykeyvalue24."time", sheetapprovalhistorykeyvalue24.timespan, sheetapprovalhistorykeyvalue24.daterange_startdate, sheetapprovalhistorykeyvalue24.daterange_enddate, sheetapprovalhistorykeyvalue24.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue24.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue24.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue24.workdayduration_workdays, sheetapprovalhistorykeyvalue24.workdayduration_hours, sheetapprovalhistorykeyvalue24.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue24.parentid = sheetapprovalhistorykeyvalue32.id)
67. 0.000 43,194.980 ↓ 0.0 0 21,597,490

Nested Loop (cost=1.54..20.41 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=21,597,490)

  • Output: upper(tsapprovalrequestkeyvalue33.uri)
  • Inner Unique: true
  • Buffers: shared hit=43,194,980
68. 21,597.490 43,194.980 ↓ 0.0 0 21,597,490

Nested Loop (cost=1.25..18.87 rows=1 width=84) (actual time=0.002..0.002 rows=0 loops=21,597,490)

  • Output: tsapprovalrequestkeyvalue33.uri, tsapprovalrequestkeyvalue33.parentid
  • Buffers: shared hit=43,194,980
69. 0.000 21,597.490 ↓ 0.0 0 21,597,490

Nested Loop (cost=0.97..7.07 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=21,597,490)

  • Output: tsapprovalrequest36.id
  • Inner Unique: true
  • Buffers: shared hit=43,194,980
70. 0.000 21,597.490 ↓ 0.0 0 21,597,490

Nested Loop (cost=0.55..4.59 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=21,597,490)

  • Output: timesheetapprovalnodes35.timesheetid, tsapprovalrequest36.id
  • Inner Unique: true
  • Buffers: shared hit=43,194,980
71. 21,597.490 21,597.490 ↓ 0.0 0 21,597,490

Index Scan using uix2tsar_nodeid_userid on ec59310f04eb4b13a07d9dd6e7e07b8c.tsapprovalrequest tsapprovalrequest36 (cost=0.27..2.29 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=21,597,490)

  • Output: tsapprovalrequest36.id, tsapprovalrequest36.nodeid, tsapprovalrequest36.effectivedateutc, tsapprovalrequest36.remindersentutc, tsapprovalrequest36.overduesentutc, tsapprovalrequest36.waitingbatchsentutc, tsapprovalrequest36.approvalagenttype, tsapprovalrequest36.userid, tsapprovalrequest36.systemprocessidentifier
  • Index Cond: (tsapprovalrequest36.userid = 4,522)
  • Buffers: shared hit=43,194,980
72. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalnodes timesheetapprovalnodes35 (cost=0.28..2.29 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes35.id, timesheetapprovalnodes35.timesheetid, timesheetapprovalnodes35.isapproved, timesheetapprovalnodes35.agentresolutionstate, timesheetapprovalnodes35.approverrole, timesheetapprovalnodes35.userid, timesheetapprovalnodes35.scriptid, timesheetapprovalnodes35.systemprocessidentifier
  • Index Cond: (timesheetapprovalnodes35.id = tsapprovalrequest36.nodeid)
73. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheet timesheet34 (cost=0.42..1.97 rows=1 width=16) (never executed)

  • Output: timesheet34.id, timesheet34.userid, timesheet34.startdate, timesheet34.enddate, timesheet34.approvalstatus, timesheet34.duedate, timesheet34.autosubmitdatetimeutc, timesheet34.lastautosubmitattemptdatetimeutc, timesheet34.createdonutc
  • Index Cond: (timesheet34.id = timesheetapprovalnodes35.timesheetid)
  • Filter: ((timesheet34.startdate <= timeentryrevision14.entrydate) AND (timesheet34.enddate >= timeentryrevision14.entrydate) AND (timesheet34.userid = timeentryrevision14.userid))
74. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on ec59310f04eb4b13a07d9dd6e7e07b8c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue33 (cost=0.28..11.79 rows=1 width=88) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue37 (cost=0.28..1.54 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue37.id, tsapprovalrequestkeyvalue37.tsapprovalrequestid, tsapprovalrequestkeyvalue37.parentid, tsapprovalrequestkeyvalue37.index, tsapprovalrequestkeyvalue37.key, tsapprovalrequestkeyvalue37.uri, tsapprovalrequestkeyvalue37.slug, tsapprovalrequestkeyvalue37."boolean", tsapprovalrequestkeyvalue37.date, tsapprovalrequestkeyvalue37.number, tsapprovalrequestkeyvalue37.text, tsapprovalrequestkeyvalue37."time", tsapprovalrequestkeyvalue37.timespan, tsapprovalrequestkeyvalue37.daterange_startdate, tsapprovalrequestkeyvalue37.daterange_enddate, tsapprovalrequestkeyvalue37.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue37.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue37.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue37.workdayduration_workdays, tsapprovalrequestkeyvalue37.workdayduration_hours, tsapprovalrequestkeyvalue37.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue37.id = tsapprovalrequestkeyvalue33.parentid)
  • Filter: (tsapprovalrequestkeyvalue37.parentid IS NULL)
76. 0.000 172,779.920 ↓ 0.0 0 21,597,490

Nested Loop (cost=16.75..59.68 rows=1 width=32) (actual time=0.008..0.008 rows=0 loops=21,597,490)

  • Output: upper(sheetapprovalhistorykeyvalue38.uri)
  • Buffers: shared hit=227,049,805
77. 21,597.490 172,779.920 ↓ 0.0 0 21,597,490

Nested Loop (cost=16.19..58.81 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=21,597,490)

  • Output: sheetapprovalhistorykeyvalue46.id
  • Buffers: shared hit=227,049,805
78. 0.000 151,182.430 ↓ 0.0 0 21,597,490

Nested Loop (cost=15.63..56.66 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=21,597,490)

  • Output: sheetapprovalhistorykeyvalue45.id
  • Buffers: shared hit=227,049,805
79. 0.000 151,182.430 ↓ 0.0 0 21,597,490

Nested Loop (cost=15.06..55.83 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=21,597,490)

  • Output: sheetapprovalhistorykeyvalue44.id
  • Buffers: shared hit=227,049,805
80. 0.000 151,182.430 ↓ 0.0 0 21,597,490

Nested Loop (cost=14.50..53.73 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=21,597,490)

  • Output: sheetapprovalhistorykeyvalue43.id
  • Buffers: shared hit=227,049,805
81. 0.000 151,182.430 ↓ 0.0 0 21,597,490

Nested Loop (cost=13.94..50.34 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=21,597,490)

  • Output: sheetapprovalhistorykeyvalue42.parentid
  • Inner Unique: true
  • Buffers: shared hit=227,049,805
82. 21,597.490 151,182.430 ↓ 0.0 0 21,597,490

Nested Loop (cost=13.38..47.75 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=21,597,490)

  • Output: sheetapprovalhistorykeyvalue41.parentid
  • Buffers: shared hit=227,049,805
83. 21,598.462 129,584.940 ↓ 0.0 0 21,597,490

Nested Loop (cost=0.85..34.19 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=21,597,490)

  • Output: timesheetapprovalhistory40.id
  • Buffers: shared hit=227,049,805
84. 43,194.980 43,194.980 ↑ 5.0 1 21,597,490

Index Scan using ixtsuseridstartdateenddate on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheet timesheet39 (cost=0.42..6.62 rows=5 width=16) (actual time=0.002..0.002 rows=1 loops=21,597,490)

  • Output: timesheet39.id, timesheet39.userid, timesheet39.startdate, timesheet39.enddate, timesheet39.approvalstatus, timesheet39.duedate, timesheet39.autosubmitdatetimeutc, timesheet39.lastautosubmitattemptdatetimeutc, timesheet39.createdonutc
  • Index Cond: ((timesheet39.userid = timeentryrevision14.userid) AND (timesheet39.startdate <= timeentryrevision14.entrydate) AND (timesheet39.enddate >= timeentryrevision14.entrydate))
  • Buffers: shared hit=95,365,699
85. 64,791.498 64,791.498 ↓ 0.0 0 21,597,166

Index Scan using ixtah2timesheetid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistory timesheetapprovalhistory40 (cost=0.42..5.50 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=21,597,166)

  • Output: timesheetapprovalhistory40.id, timesheetapprovalhistory40.serialnumber, timesheetapprovalhistory40.timesheetid, timesheetapprovalhistory40.action, timesheetapprovalhistory40.approvalcomments, timesheetapprovalhistory40.timestamputc, timesheetapprovalhistory40.approvalagenttype, timesheetapprovalhistory40.userid, timesheetapprovalhistory40.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory40.timesheetid = timesheet39.id)
  • Filter: (timesheetapprovalhistory40.userid = 4,522)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=131,684,106
86. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue41 (cost=12.53..13.55 rows=1 width=32) (never executed)

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

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

88. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (sheetapprovalhistorykeyvalue41.timesheetapprovalhistoryid = timesheetapprovalhistory40.id)
89. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (upper(sheetapprovalhistorykeyvalue41.uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:4,522'::text)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue42 (cost=0.56..2.59 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue43 (cost=0.56..3.38 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue44 (cost=0.56..2.00 rows=10 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue45 (cost=0.56..0.82 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue46 (cost=0.56..2.05 rows=10 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue38 (cost=0.56..0.77 rows=10 width=89) (never executed)

  • Output: sheetapprovalhistorykeyvalue38.id, sheetapprovalhistorykeyvalue38.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue38.parentid, sheetapprovalhistorykeyvalue38.index, sheetapprovalhistorykeyvalue38.key, sheetapprovalhistorykeyvalue38.uri, sheetapprovalhistorykeyvalue38.slug, sheetapprovalhistorykeyvalue38."boolean", sheetapprovalhistorykeyvalue38.date, sheetapprovalhistorykeyvalue38.number, sheetapprovalhistorykeyvalue38.text, sheetapprovalhistorykeyvalue38."time", sheetapprovalhistorykeyvalue38.timespan, sheetapprovalhistorykeyvalue38.daterange_startdate, sheetapprovalhistorykeyvalue38.daterange_enddate, sheetapprovalhistorykeyvalue38.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue38.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue38.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue38.workdayduration_workdays, sheetapprovalhistorykeyvalue38.workdayduration_hours, sheetapprovalhistorykeyvalue38.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue38.parentid = sheetapprovalhistorykeyvalue46.id)
96. 2,138,150.008 2,138,151.510 ↓ 0.0 0 21,597,490

Index Scan using ixtemrtimeentryid on ec59310f04eb4b13a07d9dd6e7e07b8c.timeentrymetadatarevision timeentrymetadatarevision47 (cost=144.62..169.60 rows=1 width=0) (actual time=0.099..0.099 rows=0 loops=21,597,490)

  • Index Cond: (timeentrymetadatarevision47.timeentryid = timeentryrevision14.timeentryid)
  • Filter: ((timeentrymetadatarevision47.fromtimestamputc <= timeentryrevision14.fromtimestamputc) AND ((timeentrymetadatarevision47.totimestamputc > timeentryrevision14.fromtimestamputc) OR (timeentrymetadatarevision47.totimestamputc IS NULL)) AND (((upper(timeentrymetadatarevision47.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 6)) OR ((upper(timeentrymetadatarevision47.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 7))))
  • Rows Removed by Filter: 12
  • Buffers: shared hit=171,939,578 read=1,586,348
97.          

SubPlan (for Index Scan)

98. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ixprjprojectleaderapproverid on ec59310f04eb4b13a07d9dd6e7e07b8c.project project48 (cost=0.42..23.00 rows=21 width=32) (actual time=0.017..0.017 rows=0 loops=1)

  • Output: upper(('urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:project:'::text || COALESCE((project48.id)::text, ''::text)))
  • Index Cond: (project48.projectleaderapproverid = 4,522)
  • Buffers: shared hit=3
99. 0.001 1.485 ↓ 0.0 0 1

Nested Loop (cost=0.85..120.90 rows=42 width=32) (actual time=1.485..1.485 rows=0 loops=1)

  • Output: upper(('urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:task:'::text || COALESCE((task49.id)::text, ''::text)))
  • Buffers: shared hit=2 read=1
100. 1.484 1.484 ↓ 0.0 0 1

Index Scan using ixprjprojectleaderapproverid on ec59310f04eb4b13a07d9dd6e7e07b8c.project project50 (cost=0.42..22.79 rows=21 width=4) (actual time=1.484..1.484 rows=0 loops=1)

  • Output: project50.id
  • Index Cond: (project50.projectleaderapproverid = 4,522)
  • Buffers: shared hit=2 read=1
101. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtkprojectid on ec59310f04eb4b13a07d9dd6e7e07b8c.task task49 (cost=0.42..4.61 rows=4 width=8) (never executed)

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

Nested Loop (cost=1.54..25.23 rows=3 width=32) (never executed)

  • Output: upper(tsapprovalrequestkeyvalue51.uri)
  • Inner Unique: true
103. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.25..18.99 rows=13 width=84) (never executed)

  • Output: tsapprovalrequestkeyvalue51.uri, tsapprovalrequestkeyvalue51.parentid
104. 0.000 0.000 ↓ 0.0 0

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

  • Output: tsapprovalrequest54.id
  • Inner Unique: true
105. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..4.59 rows=1 width=20) (never executed)

  • Output: timesheetapprovalnodes53.timesheetid, tsapprovalrequest54.id
  • Inner Unique: true
106. 0.000 0.000 ↓ 0.0 0

Index Scan using uix2tsar_nodeid_userid on ec59310f04eb4b13a07d9dd6e7e07b8c.tsapprovalrequest tsapprovalrequest54 (cost=0.27..2.29 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest54.id, tsapprovalrequest54.nodeid, tsapprovalrequest54.effectivedateutc, tsapprovalrequest54.remindersentutc, tsapprovalrequest54.overduesentutc, tsapprovalrequest54.waitingbatchsentutc, tsapprovalrequest54.approvalagenttype, tsapprovalrequest54.userid, tsapprovalrequest54.systemprocessidentifier
  • Index Cond: (tsapprovalrequest54.userid = 4,522)
107. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalnodes timesheetapprovalnodes53 (cost=0.28..2.29 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes53.id, timesheetapprovalnodes53.timesheetid, timesheetapprovalnodes53.isapproved, timesheetapprovalnodes53.agentresolutionstate, timesheetapprovalnodes53.approverrole, timesheetapprovalnodes53.userid, timesheetapprovalnodes53.scriptid, timesheetapprovalnodes53.systemprocessidentifier
  • Index Cond: (timesheetapprovalnodes53.id = tsapprovalrequest54.nodeid)
108. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheet timesheet52 (cost=0.42..1.97 rows=1 width=16) (never executed)

  • Output: timesheet52.id, timesheet52.userid, timesheet52.startdate, timesheet52.enddate, timesheet52.approvalstatus, timesheet52.duedate, timesheet52.autosubmitdatetimeutc, timesheet52.lastautosubmitattemptdatetimeutc, timesheet52.createdonutc
  • Index Cond: (timesheet52.id = timesheetapprovalnodes53.timesheetid)
  • Filter: ((timesheet52.startdate <= timeentryrevision14.entrydate) AND (timesheet52.enddate >= timeentryrevision14.entrydate) AND (timesheet52.userid = timeentryrevision14.userid))
109. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on ec59310f04eb4b13a07d9dd6e7e07b8c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue51 (cost=0.28..11.79 rows=13 width=88) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue55 (cost=0.28..0.48 rows=1 width=16) (never executed)

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

Nested Loop (cost=16.75..59.69 rows=1 width=32) (never executed)

  • Output: upper(sheetapprovalhistorykeyvalue56.uri)
112. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=16.19..58.81 rows=1 width=16) (never executed)

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

Nested Loop (cost=15.63..56.66 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue63.id
114. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=15.06..55.83 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue62.id
115. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=14.50..53.73 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue61.id
116. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=13.94..50.34 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue60.parentid
  • Inner Unique: true
117. 0.000 0.000 ↓ 0.0 0

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

  • Output: sheetapprovalhistorykeyvalue59.parentid
118. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..34.19 rows=1 width=16) (never executed)

  • Output: timesheetapprovalhistory58.id
119. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheet timesheet57 (cost=0.42..6.62 rows=5 width=16) (never executed)

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

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

  • Output: timesheetapprovalhistory58.id, timesheetapprovalhistory58.serialnumber, timesheetapprovalhistory58.timesheetid, timesheetapprovalhistory58.action, timesheetapprovalhistory58.approvalcomments, timesheetapprovalhistory58.timestamputc, timesheetapprovalhistory58.approvalagenttype, timesheetapprovalhistory58.userid, timesheetapprovalhistory58.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory58.timesheetid = timesheet57.id)
  • Filter: (timesheetapprovalhistory58.userid = 4,522)
121. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue59 (cost=12.53..13.55 rows=1 width=32) (never executed)

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

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

123. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (sheetapprovalhistorykeyvalue59.timesheetapprovalhistoryid = timesheetapprovalhistory58.id)
124. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (upper(sheetapprovalhistorykeyvalue59.uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:4,522'::text)
125. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue60 (cost=0.56..2.59 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue61 (cost=0.56..3.38 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue62 (cost=0.56..2.00 rows=10 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue63 (cost=0.56..0.82 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue64 (cost=0.56..2.06 rows=10 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue56 (cost=0.56..0.77 rows=10 width=89) (never executed)

  • Output: sheetapprovalhistorykeyvalue56.id, sheetapprovalhistorykeyvalue56.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue56.parentid, sheetapprovalhistorykeyvalue56.index, sheetapprovalhistorykeyvalue56.key, sheetapprovalhistorykeyvalue56.uri, sheetapprovalhistorykeyvalue56.slug, sheetapprovalhistorykeyvalue56."boolean", sheetapprovalhistorykeyvalue56.date, sheetapprovalhistorykeyvalue56.number, sheetapprovalhistorykeyvalue56.text, sheetapprovalhistorykeyvalue56."time", sheetapprovalhistorykeyvalue56.timespan, sheetapprovalhistorykeyvalue56.daterange_startdate, sheetapprovalhistorykeyvalue56.daterange_enddate, sheetapprovalhistorykeyvalue56.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue56.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue56.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue56.workdayduration_workdays, sheetapprovalhistorykeyvalue56.workdayduration_hours, sheetapprovalhistorykeyvalue56.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue56.parentid = sheetapprovalhistorykeyvalue64.id)
131. 194,377.390 194,377.410 ↓ 0.0 0 21,597,490

Index Scan using ixtemrtimeentryid on ec59310f04eb4b13a07d9dd6e7e07b8c.timeentrymetadatarevision timeentrymetadatarevision65 (cost=87.52..112.50 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=21,597,490)

  • Index Cond: (timeentrymetadatarevision65.timeentryid = timeentryrevision14.timeentryid)
  • Filter: ((timeentrymetadatarevision65.fromtimestamputc <= timeentryrevision14.fromtimestamputc) AND ((timeentrymetadatarevision65.totimestamputc > timeentryrevision14.fromtimestamputc) OR (timeentrymetadatarevision65.totimestamputc IS NULL)) AND (((upper(timeentrymetadatarevision65.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 11)) OR ((upper(timeentrymetadatarevision65.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 12))))
  • Rows Removed by Filter: 12
  • Buffers: shared hit=173,525,738
132.          

SubPlan (for Index Scan)

133. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=32.98..41.44 rows=6 width=32) (actual time=0.010..0.010 rows=0 loops=1)

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

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

  • Output: resentativeprojectassignment67.projectid
  • Group Key: resentativeprojectassignment67.projectid
  • Buffers: shared hit=1
135. 0.000 0.008 ↓ 0.0 0 1

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

  • Output: resentativeprojectassignment67.projectid
  • Buffers: shared hit=1
136. 0.008 0.008 ↓ 0.0 0 1

Index Scan using uix2cr_clientuser on ec59310f04eb4b13a07d9dd6e7e07b8c.clientrepresentative clientrepresentative68 (cost=0.15..19.01 rows=8 width=16) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: clientrepresentative68.id, clientrepresentative68.clientid, clientrepresentative68.userid
  • Index Cond: (clientrepresentative68.userid = 4,522)
  • Buffers: shared hit=1
137. 0.000 0.000 ↓ 0.0 0

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

  • Output: resentativeprojectassignment67.id, resentativeprojectassignment67.clientrepresentativeid, resentativeprojectassignment67.projectid
  • Index Cond: (resentativeprojectassignment67.clientrepresentativeid = clientrepresentative68.id)
138. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.project project66 (cost=0.42..1.46 rows=1 width=4) (never executed)

  • Output: project66.id
  • Index Cond: (project66.id = resentativeprojectassignment67.projectid)
  • Heap Fetches: 0
139. 0.000 0.010 ↓ 0.0 0 1

Nested Loop (cost=33.41..45.44 rows=23 width=32) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: upper(('urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:task:'::text || COALESCE((task69.id)::text, ''::text)))
  • Buffers: shared hit=1
140. 0.000 0.010 ↓ 0.0 0 1

Nested Loop (cost=32.98..41.38 rows=6 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: project70.id, resentativeprojectassignment67_1.projectid
  • Inner Unique: true
  • Buffers: shared hit=1
141. 0.002 0.010 ↓ 0.0 0 1

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

  • Output: resentativeprojectassignment67_1.projectid
  • Group Key: resentativeprojectassignment67_1.projectid
  • Buffers: shared hit=1
142. 0.000 0.008 ↓ 0.0 0 1

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

  • Output: resentativeprojectassignment67_1.projectid
  • Buffers: shared hit=1
143. 0.008 0.008 ↓ 0.0 0 1

Index Scan using uix2cr_clientuser on ec59310f04eb4b13a07d9dd6e7e07b8c.clientrepresentative clientrepresentative68_1 (cost=0.15..19.01 rows=8 width=16) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: clientrepresentative68_1.id, clientrepresentative68_1.clientid, clientrepresentative68_1.userid
  • Index Cond: (clientrepresentative68_1.userid = 4,522)
  • Buffers: shared hit=1
144. 0.000 0.000 ↓ 0.0 0

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

  • Output: resentativeprojectassignment67_1.id, resentativeprojectassignment67_1.clientrepresentativeid, resentativeprojectassignment67_1.projectid
  • Index Cond: (resentativeprojectassignment67_1.clientrepresentativeid = clientrepresentative68_1.id)
145. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.project project70 (cost=0.42..1.46 rows=1 width=4) (never executed)

  • Output: project70.id
  • Index Cond: (project70.id = resentativeprojectassignment67_1.projectid)
  • Heap Fetches: 0
146. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtkprojectid on ec59310f04eb4b13a07d9dd6e7e07b8c.task task69 (cost=0.42..0.60 rows=4 width=8) (never executed)

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

Nested Loop (cost=1.54..25.23 rows=3 width=32) (never executed)

  • Output: upper(tsapprovalrequestkeyvalue71.uri)
  • Inner Unique: true
148. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.25..18.99 rows=13 width=84) (never executed)

  • Output: tsapprovalrequestkeyvalue71.uri, tsapprovalrequestkeyvalue71.parentid
149. 0.000 0.000 ↓ 0.0 0

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

  • Output: tsapprovalrequest74.id
  • Inner Unique: true
150. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..4.59 rows=1 width=20) (never executed)

  • Output: timesheetapprovalnodes73.timesheetid, tsapprovalrequest74.id
  • Inner Unique: true
151. 0.000 0.000 ↓ 0.0 0

Index Scan using uix2tsar_nodeid_userid on ec59310f04eb4b13a07d9dd6e7e07b8c.tsapprovalrequest tsapprovalrequest74 (cost=0.27..2.29 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest74.id, tsapprovalrequest74.nodeid, tsapprovalrequest74.effectivedateutc, tsapprovalrequest74.remindersentutc, tsapprovalrequest74.overduesentutc, tsapprovalrequest74.waitingbatchsentutc, tsapprovalrequest74.approvalagenttype, tsapprovalrequest74.userid, tsapprovalrequest74.systemprocessidentifier
  • Index Cond: (tsapprovalrequest74.userid = 4,522)
152. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalnodes timesheetapprovalnodes73 (cost=0.28..2.29 rows=1 width=32) (never executed)

  • Output: timesheetapprovalnodes73.id, timesheetapprovalnodes73.timesheetid, timesheetapprovalnodes73.isapproved, timesheetapprovalnodes73.agentresolutionstate, timesheetapprovalnodes73.approverrole, timesheetapprovalnodes73.userid, timesheetapprovalnodes73.scriptid, timesheetapprovalnodes73.systemprocessidentifier
  • Index Cond: (timesheetapprovalnodes73.id = tsapprovalrequest74.nodeid)
153. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheet timesheet72 (cost=0.42..1.97 rows=1 width=16) (never executed)

  • Output: timesheet72.id, timesheet72.userid, timesheet72.startdate, timesheet72.enddate, timesheet72.approvalstatus, timesheet72.duedate, timesheet72.autosubmitdatetimeutc, timesheet72.lastautosubmitattemptdatetimeutc, timesheet72.createdonutc
  • Index Cond: (timesheet72.id = timesheetapprovalnodes73.timesheetid)
  • Filter: ((timesheet72.startdate <= timeentryrevision14.entrydate) AND (timesheet72.enddate >= timeentryrevision14.entrydate) AND (timesheet72.userid = timeentryrevision14.userid))
154. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on ec59310f04eb4b13a07d9dd6e7e07b8c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue71 (cost=0.28..11.79 rows=13 width=88) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue75 (cost=0.28..0.48 rows=1 width=16) (never executed)

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

Nested Loop (cost=16.75..59.69 rows=1 width=32) (never executed)

  • Output: upper(sheetapprovalhistorykeyvalue76.uri)
157. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=16.19..58.81 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue84.id
158. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=15.63..56.66 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue83.id
159. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=15.06..55.83 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue82.id
160. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=14.50..53.73 rows=1 width=16) (never executed)

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

Nested Loop (cost=13.94..50.34 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue80.parentid
  • Inner Unique: true
162. 0.000 0.000 ↓ 0.0 0

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

  • Output: sheetapprovalhistorykeyvalue79.parentid
163. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..34.19 rows=1 width=16) (never executed)

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

Index Scan using ixtsuseridstartdateenddate on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheet timesheet77 (cost=0.42..6.62 rows=5 width=16) (never executed)

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

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

  • Output: timesheetapprovalhistory78.id, timesheetapprovalhistory78.serialnumber, timesheetapprovalhistory78.timesheetid, timesheetapprovalhistory78.action, timesheetapprovalhistory78.approvalcomments, timesheetapprovalhistory78.timestamputc, timesheetapprovalhistory78.approvalagenttype, timesheetapprovalhistory78.userid, timesheetapprovalhistory78.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory78.timesheetid = timesheet77.id)
  • Filter: (timesheetapprovalhistory78.userid = 4,522)
166. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue79 (cost=12.53..13.55 rows=1 width=32) (never executed)

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

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

168. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (sheetapprovalhistorykeyvalue79.timesheetapprovalhistoryid = timesheetapprovalhistory78.id)
169. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (upper(sheetapprovalhistorykeyvalue79.uri) = 'URN:REPLICON-TENANT:EC59310F04EB4B13A07D9DD6E7E07B8C:USER:4,522'::text)
170. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue80 (cost=0.56..2.59 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue81 (cost=0.56..3.38 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue82 (cost=0.56..2.00 rows=10 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue83 (cost=0.56..0.82 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue84 (cost=0.56..2.06 rows=10 width=32) (never executed)

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

Index Scan using ixtahkvparentid on ec59310f04eb4b13a07d9dd6e7e07b8c.timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue76 (cost=0.56..0.77 rows=10 width=89) (never executed)

  • Output: sheetapprovalhistorykeyvalue76.id, sheetapprovalhistorykeyvalue76.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue76.parentid, sheetapprovalhistorykeyvalue76.index, sheetapprovalhistorykeyvalue76.key, sheetapprovalhistorykeyvalue76.uri, sheetapprovalhistorykeyvalue76.slug, sheetapprovalhistorykeyvalue76."boolean", sheetapprovalhistorykeyvalue76.date, sheetapprovalhistorykeyvalue76.number, sheetapprovalhistorykeyvalue76.text, sheetapprovalhistorykeyvalue76."time", sheetapprovalhistorykeyvalue76.timespan, sheetapprovalhistorykeyvalue76.daterange_startdate, sheetapprovalhistorykeyvalue76.daterange_enddate, sheetapprovalhistorykeyvalue76.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue76.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue76.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue76.workdayduration_workdays, sheetapprovalhistorykeyvalue76.workdayduration_hours, sheetapprovalhistorykeyvalue76.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue76.parentid = sheetapprovalhistorykeyvalue84.id)
176. 97.333 486.076 ↑ 79.7 819 2

Seq Scan on ec59310f04eb4b13a07d9dd6e7e07b8c.timeoffs timeoffs85 (cost=94.86..4,989.06 rows=65,250 width=4) (actual time=195.175..243.038 rows=819 loops=2)

  • Output: timeoffs85.id
  • Filter: ((timeoffs85.userid = 4,522) OR (hashed SubPlan 17))
  • Rows Removed by Filter: 127,667
  • Buffers: shared hit=3,442 read=2,779
177.          

SubPlan (for Seq Scan)

178. 0.222 388.743 ↓ 9.9 819 1

Nested Loop (cost=0.98..94.66 rows=83 width=4) (actual time=0.036..388.743 rows=819 loops=1)

  • Output: timeoffs86.id
  • Buffers: shared hit=205 read=546
179. 0.019 0.085 ↓ 1.1 38 1

Nested Loop (cost=0.56..47.18 rows=36 width=12) (actual time=0.024..0.085 rows=38 loops=1)

  • Output: userdepartmentgroup87.userid, userdepartmentgroup87.startdate, userdepartmentgroup87.enddate
  • Buffers: shared hit=18
180. 0.014 0.014 ↑ 1.0 2 1

Index Only Scan using departmentgroupflathierarchy_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.departmentgroupflathierarchy departmentgroupflathierarchy88 (cost=0.28..1.31 rows=2 width=16) (actual time=0.012..0.014 rows=2 loops=1)

  • Output: departmentgroupflathierarchy88.parentid, departmentgroupflathierarchy88.childid
  • Index Cond: (departmentgroupflathierarchy88.parentid = '5b1a9f95-e64f-414c-9bcc-72e34fbc457a'::uuid)
  • Heap Fetches: 0
  • Buffers: shared hit=3
181. 0.052 0.052 ↑ 1.3 19 2

Index Scan using ixudgdepartmentgroupid on ec59310f04eb4b13a07d9dd6e7e07b8c.userdepartmentgroup userdepartmentgroup87 (cost=0.28..22.70 rows=24 width=28) (actual time=0.013..0.026 rows=19 loops=2)

  • Output: userdepartmentgroup87.id, userdepartmentgroup87.userid, userdepartmentgroup87.departmentgroupid, userdepartmentgroup87.startdate, userdepartmentgroup87.enddate
  • Index Cond: (userdepartmentgroup87.departmentgroupid = departmentgroupflathierarchy88.childid)
  • Buffers: shared hit=15
182. 388.436 388.436 ↓ 7.3 22 38

Index Scan using ixto4userid on ec59310f04eb4b13a07d9dd6e7e07b8c.timeoffs timeoffs86 (cost=0.42..1.29 rows=3 width=16) (actual time=2.056..10.222 rows=22 loops=38)

  • Output: timeoffs86.id, timeoffs86.guidid, timeoffs86.userid, timeoffs86.createdbyuserid, timeoffs86.timeoffcodeid, timeoffs86.startdate, timeoffs86.enddate, timeoffs86.startdurationtype, timeoffs86.enddurationtype, timeoffs86.startduration, timeoffs86.endduration, timeoffs86.startdatestarttime, timeoffs86.enddateendtime, timeoffs86.approvalstatus, timeoffs86.comments, timeoffs86.submittedonutc, timeoffs86.modifiedonutc, timeoffs86.entryconfigurationmethod, timeoffs86.info1, timeoffs86.info2, timeoffs86.info3, timeoffs86.info4, timeoffs86.info5
  • Index Cond: ((timeoffs86.userid = userdepartmentgroup87.userid) AND (userdepartmentgroup87.enddate >= timeoffs86.startdate) AND (userdepartmentgroup87.startdate <= timeoffs86.enddate))
  • Buffers: shared hit=187 read=546
183. 9,548.801 10,149.655 ↑ 47.7 26 1

Subquery Scan on *SELECT* 2 (cost=8,103.14..8,712,997,933,262.78 rows=1,241 width=48) (actual time=671.873..10,149.655 rows=26 loops=1)

  • Output: "*SELECT* 2".entrydate, "*SELECT* 2".duration, "*SELECT* 2".userid, "*SELECT* 2".timeentryid, "*SELECT* 2".timeoffentryid, "*SELECT* 2".timeallocationtype
  • Filter: ((SubPlan 16) OR (hashed SubPlan 18))
  • Rows Removed by Filter: 1,634
  • Buffers: shared hit=9,637 read=1,354
184. 4.147 600.854 ↓ 1.0 1,660 1

Nested Loop (cost=0.84..5,692.21 rows=1,655 width=140) (actual time=17.805..600.854 rows=1,660 loops=1)

  • Output: NULL::uuid, toff.id, toff.userid, toe.entrydate, NULL::time without time zone, NULL::time without time zone, toe.duration, NULL::uuid, NULL::integer, NULL::interval, toe.id, NULL::interval, NULL::interval, NULL::integer, NULL::integer
  • Inner Unique: true
  • Buffers: shared hit=6,700 read=1,354
185. 498.767 498.767 ↓ 1.0 1,660 1

Index Scan using uix2toe_timeoffidentrydate on ec59310f04eb4b13a07d9dd6e7e07b8c.timeoffentries toe (cost=0.42..3,064.28 rows=1,655 width=28) (actual time=16.146..498.767 rows=1,660 loops=1)

  • Output: toe.id, toe.timeoffid, toe.entrydate, toe.duration, toe.workdayduration, toe.timein, toe.timeout, toe.isreportable, toe.entryid
  • Index Cond: ((toe.entrydate >= '2020-09-13'::date) AND (toe.entrydate <= '2020-09-19'::date))
  • Buffers: shared hit=139 read=1,272
186. 97.940 97.940 ↑ 1.0 1 1,660

Index Scan using timeoffs_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.timeoffs toff (cost=0.42..1.59 rows=1 width=8) (actual time=0.059..0.059 rows=1 loops=1,660)

  • Output: toff.id, toff.guidid, toff.userid, toff.createdbyuserid, toff.timeoffcodeid, toff.startdate, toff.enddate, toff.startdurationtype, toff.enddurationtype, toff.startduration, toff.endduration, toff.startdatestarttime, toff.enddateendtime, toff.approvalstatus, toff.comments, toff.submittedonutc, toff.modifiedonutc, toff.entryconfigurationmethod, toff.info1, toff.info2, toff.info3, toff.info4, toff.info5
  • Index Cond: (toff.id = toe.timeoffid)
  • Buffers: shared hit=6,561 read=82
187. 17.775 17.775 ↓ 0.0 0 711

Index Scan using ixtem2timeentryid on ec59310f04eb4b13a07d9dd6e7e07b8c.timeentrymetadata timeentrymetadata4 (cost=0.56..2.29 rows=1 width=79) (actual time=0.025..0.025 rows=0 loops=711)

  • Output: timeentrymetadata4.id, timeentrymetadata4.timeentryid, timeentrymetadata4.parentid, timeentrymetadata4.index, timeentrymetadata4.key, timeentrymetadata4.uri, timeentrymetadata4.slug, timeentrymetadata4."boolean", timeentrymetadata4.date, timeentrymetadata4.number, timeentrymetadata4.text, timeentrymetadata4."time", timeentrymetadata4.timespan, timeentrymetadata4.daterange_startdate, timeentrymetadata4.daterange_enddate, timeentrymetadata4.daterange_relativedaterangeuri, timeentrymetadata4.daterange_relativedaterangeasofdate, timeentrymetadata4.workdayduration_decimalworkdays, timeentrymetadata4.workdayduration_workdays, timeentrymetadata4.workdayduration_hours, timeentrymetadata4.workdayduration_minutes
  • Index Cond: (("*SELECT* 1".timeentryid = timeentrymetadata4.timeentryid) AND (upper(timeentrymetadata4.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text))
  • Buffers: shared hit=2,758 read=11
188. 13.509 13.509 ↓ 0.0 0 711

Index Only Scan using project_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.project project5 (cost=0.43..0.50 rows=1 width=4) (actual time=0.019..0.019 rows=0 loops=711)

  • Output: project5.id
  • Index Cond: (project5.id = CASE WHEN ("substring"(timeentrymetadata4.uri, '^urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:project:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata4.uri, '^urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:project:(.*)$'::text))::integer ELSE NULL::integer END)
  • Heap Fetches: 19
  • Buffers: shared hit=89 read=10
189. 155.965 196.947 ↑ 1.6 3,859 711

Materialize (cost=0.00..286.63 rows=6,242 width=32) (actual time=0.000..0.277 rows=3,859 loops=711)

  • Output: ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id
  • Buffers: shared hit=144 read=38
190. 40.982 40.982 ↑ 1.0 5,950 1

Seq Scan on ec59310f04eb4b13a07d9dd6e7e07b8c.userinfo ui (cost=0.00..255.42 rows=6,242 width=32) (actual time=0.009..40.982 rows=5,950 loops=1)

  • Output: ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id
  • Buffers: shared hit=144 read=38
191. 387.495 387.495 ↑ 2.0 1 711

Index Scan using ixtem2timeentryid on ec59310f04eb4b13a07d9dd6e7e07b8c.timeentrymetadata timeentrymetadata6 (cost=0.56..2.96 rows=2 width=79) (actual time=0.534..0.545 rows=1 loops=711)

  • Output: timeentrymetadata6.id, timeentrymetadata6.timeentryid, timeentrymetadata6.parentid, timeentrymetadata6.index, timeentrymetadata6.key, timeentrymetadata6.uri, timeentrymetadata6.slug, timeentrymetadata6."boolean", timeentrymetadata6.date, timeentrymetadata6.number, timeentrymetadata6.text, timeentrymetadata6."time", timeentrymetadata6.timespan, timeentrymetadata6.daterange_startdate, timeentrymetadata6.daterange_enddate, timeentrymetadata6.daterange_relativedaterangeuri, timeentrymetadata6.daterange_relativedaterangeasofdate, timeentrymetadata6.workdayduration_decimalworkdays, timeentrymetadata6.workdayduration_workdays, timeentrymetadata6.workdayduration_hours, timeentrymetadata6.workdayduration_minutes
  • Index Cond: (("*SELECT* 1".timeentryid = timeentrymetadata6.timeentryid) AND (upper(timeentrymetadata6.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text))
  • Buffers: shared hit=3,163 read=280
192. 9.954 9.954 ↑ 1.7 21 711

Index Scan using ixudgdepartmentgroupid on ec59310f04eb4b13a07d9dd6e7e07b8c.userdepartmentgroup userdepartmentgroup12 (cost=0.28..35.36 rows=35 width=4) (actual time=0.005..0.014 rows=21 loops=711)

  • Output: userdepartmentgroup12.id, userdepartmentgroup12.userid, userdepartmentgroup12.departmentgroupid, userdepartmentgroup12.startdate, userdepartmentgroup12.enddate
  • Index Cond: (userdepartmentgroup12.departmentgroupid = ANY ('{5b1a9f95-e64f-414c-9bcc-72e34fbc457a,38c17637-138d-4964-a34f-edcd4d1366f8}'::uuid[]))
  • Filter: ((userdepartmentgroup12.startdate <= '2020-09-16'::date) AND (userdepartmentgroup12.enddate >= '2020-09-16'::date))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=9,907
193. 0.711 9.243 ↑ 1.0 1 711

Nested Loop Left Join (cost=0.56..0.67 rows=1 width=18) (actual time=0.009..0.013 rows=1 loops=711)

  • Output: userhierarchy11.userid, userinfo0.displayname
  • Inner Unique: true
  • Buffers: shared hit=4,378 read=5
194. 7.110 7.110 ↑ 1.0 1 711

Index Scan using ix3uh_usersuperstart on ec59310f04eb4b13a07d9dd6e7e07b8c.userhierarchy userhierarchy11 (cost=0.28..0.33 rows=1 width=8) (actual time=0.005..0.010 rows=1 loops=711)

  • Output: userhierarchy11.id, userhierarchy11.userid, userhierarchy11.supervisorid, userhierarchy11.startdate, userhierarchy11.enddate
  • Index Cond: ((ui.id = userhierarchy11.userid) AND ('2020-09-16'::date >= userhierarchy11.startdate))
  • Filter: ('2020-09-16'::date <= userhierarchy11.enddate)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=2,244 read=5
195. 1.422 1.422 ↑ 1.0 1 711

Index Scan using userinfo_pkey on ec59310f04eb4b13a07d9dd6e7e07b8c.userinfo userinfo0 (cost=0.28..0.33 rows=1 width=18) (actual time=0.002..0.002 rows=1 loops=711)

  • Output: userinfo0.id, userinfo0.firstname, userinfo0.lastname, userinfo0.slug, userinfo0.email, userinfo0.startdate, userinfo0.enddate, userinfo0.externalid, userinfo0.disabled, userinfo0.info1, userinfo0.info2, userinfo0.info3, userinfo0.info4, userinfo0.info5, userinfo0.info6, userinfo0.info7, userinfo0.info8, userinfo0.info9, userinfo0.info10, userinfo0.info11, userinfo0.info12, userinfo0.info13, userinfo0.info14, userinfo0.info15, userinfo0.info16, userinfo0.info17, userinfo0.info18, userinfo0.info19, userinfo0.info20, userinfo0.info21, userinfo0.info22, userinfo0.info23, userinfo0.info24, userinfo0.info25, userinfo0.info26, userinfo0.info27, userinfo0.info28, userinfo0.info29, userinfo0.info30, userinfo0.info31, userinfo0.info32, userinfo0.info33, userinfo0.info34, userinfo0.info35, userinfo0.info36, userinfo0.info37, userinfo0.info38, userinfo0.info39, userinfo0.info40, userinfo0.info41, userinfo0.info42, userinfo0.info43, userinfo0.info44, userinfo0.info45, userinfo0.info46, userinfo0.info47, userinfo0.info48, userinfo0.info49, userinfo0.info50, userinfo0.languageid, userinfo0.employeetypeid, userinfo0.timezoneid, userinfo0.duplicatename, userinfo0.displayname, userinfo0.issampleuser, userinfo0.defaultactivityid, userinfo0.guidid, userinfo0.customdisplayname
  • Index Cond: (userhierarchy11.supervisorid = userinfo0.id)
  • Buffers: shared hit=2,134
196. 2.844 2.844 ↓ 0.0 0 711

Index Scan using ixtem2timeentryid on ec59310f04eb4b13a07d9dd6e7e07b8c.timeentrymetadata timeentrymetadata10 (cost=0.56..2.29 rows=1 width=79) (actual time=0.004..0.004 rows=0 loops=711)

  • Output: timeentrymetadata10.id, timeentrymetadata10.timeentryid, timeentrymetadata10.parentid, timeentrymetadata10.index, timeentrymetadata10.key, timeentrymetadata10.uri, timeentrymetadata10.slug, timeentrymetadata10."boolean", timeentrymetadata10.date, timeentrymetadata10.number, timeentrymetadata10.text, timeentrymetadata10."time", timeentrymetadata10.timespan, timeentrymetadata10.daterange_startdate, timeentrymetadata10.daterange_enddate, timeentrymetadata10.daterange_relativedaterangeuri, timeentrymetadata10.daterange_relativedaterangeasofdate, timeentrymetadata10.workdayduration_decimalworkdays, timeentrymetadata10.workdayduration_workdays, timeentrymetadata10.workdayduration_hours, timeentrymetadata10.workdayduration_minutes
  • Index Cond: (("*SELECT* 1".timeentryid = timeentrymetadata10.timeentryid) AND (upper(timeentrymetadata10.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BREAK-TYPE'::text))
  • Buffers: shared hit=2,745
197. 186.075 194.814 ↑ 1.3 4,938 711

Materialize (cost=0.00..208.63 rows=6,242 width=11) (actual time=0.000..0.274 rows=4,938 loops=711)

  • Output: login.loginname, login.userid
  • Buffers: shared hit=62 read=44
198. 8.739 8.739 ↑ 1.1 5,597 1

Seq Scan on ec59310f04eb4b13a07d9dd6e7e07b8c.login (cost=0.00..177.42 rows=6,242 width=11) (actual time=0.009..8.739 rows=5,597 loops=1)

  • Output: login.loginname, login.userid
  • Buffers: shared hit=62 read=44
Planning time : 444.535 ms
Execution time : 4,124,284.358 ms