explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZLkl

Settings
# exclusive inclusive rows x rows loops node
1. 6.723 729,327.564 ↑ 49.3 1,398 1

Sort (cost=6,028,984,740.04..6,028,984,912.46 rows=68,966 width=1,971) (actual time=729,327.485..729,327.564 rows=1,398 loops=1)

  • Output: ((ui.lastname)::character varying(50)), ((ui.firstname)::character varying(50)), ui.duplicatename, ((login.loginname)::character varying(255)), ((ui.displayname)::text), ui.id, ((pj.name)::character varying(255)), pj.id, ((tk.name)::character varying(255)), tk.id, "*SELECT* 1".entrydate, "*SELECT* 1".duration, ((billingrate5.name)::character varying(50)), "*SELECT* 1".userid
  • Sort Key: ((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", ((pj.name)::character varying(255)) COLLATE "en_US", ((tk.name)::character varying(255)) COLLATE "en_US", "*SELECT* 1".entrydate, ((billingrate5.name)::character varying(50)) COLLATE "en_US
  • Sort Method: quicksort Memory: 365kB
  • Buffers: shared hit=366,678,645 read=1
2.          

Initplan (for Sort)

3. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on "4248ad1e6040418eb1e147598294e41f".systeminformation (cost=0.00..1.01 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=1)

  • Output: systeminformation.basecurrencyid
  • Buffers: shared hit=1
4. 0.505 729,320.833 ↑ 49.3 1,398 1

Hash Left Join (cost=3,008,117,524.68..6,028,979,196.38 rows=68,966 width=1,971) (actual time=727,939.235..729,320.833 rows=1,398 loops=1)

  • Output: ui.lastname, ui.firstname, ui.duplicatename, login.loginname, ui.displayname, ui.id, pj.name, pj.id, tk.name, tk.id, "*SELECT* 1".entrydate, "*SELECT* 1".duration, billingrate5.name, "*SELECT* 1".userid
  • Inner Unique: true
  • Hash Cond: ("*SELECT* 1".billingrateid = billingrate5.id)
  • Buffers: shared hit=366,678,630 read=1
5. 0.412 729,320.321 ↑ 49.3 1,398 1

Hash Left Join (cost=3,008,117,523.59..6,028,979,010.41 rows=68,966 width=150) (actual time=727,939.213..729,320.321 rows=1,398 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".billingrateid, pj.name, pj.id, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id, login.loginname, tk.name, tk.id
  • Hash Cond: (tk.estimatedcostcurrencyid = exchangerate.fixedcurrencyid)
  • Buffers: shared hit=366,678,629 read=1
6. 1.447 729,319.838 ↑ 49.3 1,398 1

Hash Left Join (cost=3,008,117,521.09..6,028,977,373.64 rows=68,966 width=154) (actual time=727,939.121..729,319.838 rows=1,398 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".billingrateid, pj.name, pj.id, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id, login.loginname, tk.name, tk.id, tk.estimatedcostcurrencyid
  • Inner Unique: true
  • Hash Cond: (task9.id = tk.id)
  • Buffers: shared hit=366,678,626 read=1
7. 0.570 729,189.987 ↑ 49.3 1,398 1

Merge Join (cost=3,008,095,871.95..6,028,955,543.47 rows=68,966 width=126) (actual time=727,809.785..729,189.987 rows=1,398 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".billingrateid, task9.id, pj.name, pj.id, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id, login.loginname
  • Merge Cond: ("*SELECT* 1".userid = login.userid)
  • Buffers: shared hit=366,662,759 read=1
8. 1.405 729,188.319 ↑ 99.4 1,398 1

Nested Loop Left Join (cost=3,008,095,612.73..6,028,954,860.36 rows=138,926 width=118) (actual time=727,808.827..729,188.319 rows=1,398 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".billingrateid, task9.id, pj.name, pj.id, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id
  • Inner Unique: true
  • Buffers: shared hit=366,661,899 read=1
9. 108.656 729,185.516 ↑ 99.4 1,398 1

Nested Loop Left Join (cost=3,008,095,612.45..6,028,896,635.27 rows=138,926 width=87) (actual time=727,808.812..729,185.516 rows=1,398 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".billingrateid, project7.id, task9.id, task9.projectid, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id
  • Inner Unique: true
  • Buffers: shared hit=366,657,705 read=1
10. 0.542 729,074.064 ↑ 99.4 1,398 1

Nested Loop Left Join (cost=3,008,095,612.01..6,028,833,733.59 rows=138,926 width=137) (actual time=727,808.420..729,074.064 rows=1,398 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".billingrateid, project7.id, timeentrymetadata8.uri, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id
  • Buffers: shared hit=366,652,413 read=1
11. 15.150 729,067.930 ↑ 76.2 1,398 1

Nested Loop Left Join (cost=3,008,095,611.45..6,028,577,711.68 rows=106,466 width=95) (actual time=727,808.408..729,067.930 rows=1,398 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".billingrateid, project7.id, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id
  • Inner Unique: true
  • Buffers: shared hit=366,645,498 read=1
12. 0.417 729,052.780 ↑ 76.2 1,398 1

Nested Loop Left Join (cost=3,008,095,611.15..6,028,544,173.20 rows=106,466 width=149) (actual time=727,808.401..729,052.780 rows=1,398 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".billingrateid, timeentrymetadata6.uri, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id
  • Buffers: shared hit=366,645,187 read=1
13. 767.463 729,041.179 ↑ 72.4 1,398 1

Nested Loop (cost=3,008,095,610.59..6,028,300,747.25 rows=101,228 width=91) (actual time=727,808.370..729,041.179 rows=1,398 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".billingrateid, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id
  • Join Filter: ("*SELECT* 1".userid = ui.id)
  • Rows Removed by Join Filter: 10,368,966
  • Buffers: shared hit=366,639,440 read=1
14. 4.148 4.148 ↑ 1.0 7,418 1

Index Scan using userinfo_pkey on "4248ad1e6040418eb1e147598294e41f".userinfo ui (cost=0.28..402.35 rows=7,538 width=35) (actual time=0.026..4.148 rows=7,418 loops=1)

  • Output: ui.id, ui.firstname, ui.lastname, ui.email, ui.startdate, ui.enddate, ui.externalid, ui.disabled, ui.info1, ui.info2, ui.info3, ui.info4, ui.info5, ui.info6, ui.info7, ui.info8, ui.info9, ui.info10, ui.info11, ui.info12, ui.info13, ui.info14, ui.info15, ui.info16, ui.info17, ui.info18, ui.info19, ui.info20, ui.info21, ui.info22, ui.info23, ui.info24, ui.info25, ui.info26, ui.info27, ui.info28, ui.info29, ui.info30, ui.info31, ui.info32, ui.info33, ui.info34, ui.info35, ui.info36, ui.info37, ui.info38, ui.info39, ui.info40, ui.info41, ui.info42, ui.info43, ui.info44, ui.info45, ui.info46, ui.info47, ui.info48, ui.info49, ui.info50, ui.languageid, ui.employeetypeid, ui.timezoneid, ui.duplicatename, ui.issampleuser, ui.slug, ui.defaultactivityid, ui.displayname, ui.guidid, ui.customdisplayname
  • Buffers: shared hit=2,618
15. 568.701 728,269.568 ↑ 72.4 1,398 7,418

Materialize (cost=3,008,095,610.31..6,016,854,748.01 rows=101,228 width=56) (actual time=97.979..98.176 rows=1,398 loops=7,418)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".billingrateid
  • Buffers: shared hit=366,636,822 read=1
16. 1.083 727,700.867 ↑ 72.4 1,398 1

Nested Loop Left Join (cost=3,008,095,610.31..6,016,854,241.87 rows=101,228 width=56) (actual time=726,804.896..727,700.867 rows=1,398 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".billingrateid
  • 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=366,636,822 read=1
17. 0.208 727,691.396 ↑ 72.5 1,398 1

Append (cost=3,008,095,609.75..6,016,609,945.93 rows=101,379 width=64) (actual time=726,804.868..727,691.396 rows=1,398 loops=1)

  • Buffers: shared hit=366,631,230 read=1
18. 236.342 727,691.179 ↑ 72.5 1,398 1

Subquery Scan on *SELECT* 1 (cost=3,008,095,609.75..3,008,515,319.36 rows=101,377 width=64) (actual time=726,804.867..727,691.179 rows=1,398 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".billingrateid, "*SELECT* 1".timeoffentryid, "*SELECT* 1".timeallocationtype
  • Filter: (hashed SubPlan 20)
  • Rows Removed by Filter: 199,907
  • Buffers: shared hit=366,631,229 read=1
19. 46.675 820.953 ↑ 1.0 201,305 1

Nested Loop (cost=1,001.56..418,176.75 rows=202,754 width=140) (actual time=2.659..820.953 rows=201,305 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, CASE WHEN (tembillingrate.uri IS NULL) THEN NULL::uuid WHEN (tembillingrate.uri = 'urn:replicon:project-specific-billing-rate'::text) THEN psi.projectcustombillingrateid WHEN (tembillingrate.uri = 'urn:replicon:user-specific-billing-rate'::text) THEN psi.usercustombillingrateid ELSE ("substring"(tembillingrate.uri, concat('^urn:replicon-tenant:', si.tenantslug, ':company-billing-rate:(.*)$')))::uuid END, NULL::integer, NULL::interval, NULL::integer, NULL::interval, NULL::interval, te.timeallocationtype, NULL::integer
  • Buffers: shared hit=1,763,776 read=1
20. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on "4248ad1e6040418eb1e147598294e41f".projectsysteminformation psi (cost=0.00..1.01 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1)

  • Output: psi.usercustombillingrateid, psi.projectcustombillingrateid, psi.defaultprojectstatuslabelid, psi.defaultinvoicecompanyaddressid, psi.defaultbillingratesfornewclients, psi.billingprocesstype, psi.projectworkflowmode, psi.defaultinvoicetemplateid, psi.resourcingdatasource, psi.projectnameunique, psi.projectcoderequiredandunique, psi.clientnameunique, psi.clientcoderequiredandunique
  • Buffers: shared hit=1
21. 31.373 774.275 ↑ 1.0 201,305 1

Nested Loop (cost=1,001.56..409,558.69 rows=202,754 width=151) (actual time=2.655..774.275 rows=201,305 loops=1)

  • Output: te.id, te.userid, te.entrydate, te.hours, te.intime, te.outtime, te.timeallocationtype, tembillingrate.uri, si.tenantslug
  • Buffers: shared hit=1,763,775 read=1
22. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on "4248ad1e6040418eb1e147598294e41f".systeminformation si (cost=0.00..1.01 rows=1 width=33) (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.buildnumber, si.isreleaseversion, si.systemguid, si.systemtimezoneid, si.databaseguid, si.uncategorizedskillcategoryid, si.newuserdefaulttimezoneid, si.defaultholidaycalendarid, si.defaultofficescheduleid, si.customlogouri, si.tenantslug, si.databaseupdatescriptstage, si.defaulttimesheetperiodid, si.defaulttimeentryapprovalpathid
  • Buffers: shared hit=1
23. 0.000 742.898 ↑ 1.0 201,305 1

Gather (cost=1,001.56..407,530.14 rows=202,754 width=118) (actual time=2.651..742.898 rows=201,305 loops=1)

  • Output: te.id, te.userid, te.entrydate, te.hours, te.intime, te.outtime, te.timeallocationtype, tembillingrate.uri
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1,763,774 read=1
24. 53.057 805.721 ↑ 1.3 67,102 3 / 3

Nested Loop Left Join (cost=1.56..386,254.74 rows=84,481 width=118) (actual time=0.078..805.721 rows=67,102 loops=3)

  • Output: te.id, te.userid, te.entrydate, te.hours, te.intime, te.outtime, te.timeallocationtype, tembillingrate.uri
  • Buffers: shared hit=1,763,774 read=1
  • Worker 0: actual time=0.084..873.513 rows=73,501 loops=1
  • Buffers: shared hit=643,867
  • Worker 1: actual time=0.090..872.312 rows=73,216 loops=1
  • Buffers: shared hit=641,533 read=1
25. 42.882 484.257 ↑ 1.3 67,102 3 / 3

Nested Loop Left Join (cost=0.99..196,049.90 rows=84,481 width=118) (actual time=0.066..484.257 rows=67,102 loops=3)

  • Output: te.id, te.userid, te.entrydate, te.hours, te.intime, te.outtime, te.timeallocationtype, tembillingrate.uri
  • Buffers: shared hit=958,554 read=1
  • Worker 0: actual time=0.072..523.711 rows=73,501 loops=1
  • Buffers: shared hit=349,863
  • Worker 1: actual time=0.075..524.023 rows=73,216 loops=1
  • Buffers: shared hit=348,669 read=1
26. 38.765 38.765 ↑ 1.3 67,102 3 / 3

Parallel Index Scan using ixte2entrydate on "4248ad1e6040418eb1e147598294e41f".timeentry te (cost=0.43..5,845.05 rows=84,481 width=60) (actual time=0.035..38.765 rows=67,102 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-24'::date) AND (te.entrydate <= '2020-10-23'::date))
  • Filter: ((te.timeallocationtype <> 2) OR (te.timeallocationtype IS NULL))
  • Buffers: shared hit=1,131 read=1
  • Worker 0: actual time=0.042..42.356 rows=73,501 loops=1
  • Buffers: shared hit=415
  • Worker 1: actual time=0.042..43.007 rows=73,216 loops=1
  • Buffers: shared hit=431 read=1
27. 402.610 402.610 ↑ 1.0 1 201,305 / 3

Index Scan using ixtem2timeentryid on "4248ad1e6040418eb1e147598294e41f".timeentrymetadata tembillingrate (cost=0.56..2.24 rows=1 width=74) (actual time=0.006..0.006 rows=1 loops=201,305)

  • 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=957,423
  • Worker 0: actual time=0.006..0.006 rows=1 loops=73,501
  • Buffers: shared hit=349,448
  • Worker 1: actual time=0.006..0.006 rows=1 loops=73,216
  • Buffers: shared hit=348,238
28. 268.407 268.407 ↓ 0.0 0 201,305 / 3

Index Scan using ixtem2timeentryid on "4248ad1e6040418eb1e147598294e41f".timeentrymetadata temdbreaktype (cost=0.56..2.24 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=201,305)

  • 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=805,220
  • Worker 0: actual time=0.004..0.004 rows=0 loops=73,501
  • Buffers: shared hit=294,004
  • Worker 1: actual time=0.004..0.004 rows=0 loops=73,216
  • Buffers: shared hit=292,864
29.          

SubPlan (for Subquery Scan)

30. 599.924 726,633.884 ↑ 77.6 85,325 1

Merge Join (cost=1,322.14..3,008,078,063.74 rows=6,617,778 width=16) (actual time=121.022..726,633.884 rows=85,325 loops=1)

  • Output: timeentryrevision12.timeentryid
  • Inner Unique: true
  • Merge Cond: (timeentryrevision12.id = timeentryrevision13.id)
  • Buffers: shared hit=364,867,453
31. 6,074.057 6,074.057 ↑ 1.0 6,657,114 1

Index Scan using timeentryrevision_pkey on "4248ad1e6040418eb1e147598294e41f".timeentryrevision timeentryrevision12 (cost=0.43..266,301.13 rows=6,658,414 width=32) (actual time=0.046..6,074.057 rows=6,657,114 loops=1)

  • Output: timeentryrevision12.id, timeentryrevision12.txid, timeentryrevision12.previousrevisionid, timeentryrevision12.timeentryid, timeentryrevision12.fromtimestamputc, timeentryrevision12.totimestamputc, timeentryrevision12.openingauditid, timeentryrevision12.closingauditid, timeentryrevision12.userid, timeentryrevision12.entrydate, timeentryrevision12.timeallocationtype, timeentryrevision12.hours, timeentryrevision12.intime, timeentryrevision12.outtime, timeentryrevision12.approvalstatus
  • Filter: (timeentryrevision12.totimestamputc IS NULL)
  • Rows Removed by Filter: 661,259
  • Buffers: shared hit=48,712
32. 33,334.384 719,959.903 ↑ 79.3 91,774 1

Index Scan using timeentryrevision_pkey on "4248ad1e6040418eb1e147598294e41f".timeentryrevision timeentryrevision13 (cost=1,321.70..3,007,710,754.68 rows=7,273,650 width=16) (actual time=120.939..719,959.903 rows=91,774 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: ((hashed SubPlan 2) OR (timeentryrevision13.userid = 4,397) OR (SubPlan 3) OR (SubPlan 4) OR (SubPlan 5) OR (SubPlan 6) OR (SubPlan 9) OR ((SubPlan 12) AND ((SubPlan 13) OR (SubPlan 14))) OR ((SubPlan 17) AND ((SubPlan 18) OR (SubPlan 19))))
  • Rows Removed by Filter: 7,226,633
  • Buffers: shared hit=364,818,741
33.          

SubPlan (for Index Scan)

34. 12.360 95.384 ↓ 2.8 91,774 1

Nested Loop (cost=7.63..1,239.82 rows=32,580 width=16) (actual time=0.213..95.384 rows=91,774 loops=1)

  • Output: timeentryrevision14.id
  • Buffers: shared hit=35,644
35. 0.976 3.824 ↓ 27.2 4,950 1

Nested Loop (cost=7.20..97.22 rows=182 width=16) (actual time=0.143..3.824 rows=4,950 loops=1)

  • Output: timesheet15.userid, timesheet15.startdate, timesheet15.enddate, userlocation16.userid
  • Buffers: shared hit=2,467
36. 0.074 0.382 ↓ 4.3 274 1

Nested Loop (cost=6.78..44.06 rows=64 width=12) (actual time=0.112..0.382 rows=274 loops=1)

  • Output: userlocation16.userid, userlocation16.startdate, userlocation16.enddate
  • Buffers: shared hit=65
37. 0.011 0.108 ↑ 1.0 5 1

HashAggregate (cost=6.50..6.55 rows=5 width=16) (actual time=0.102..0.108 rows=5 loops=1)

  • Output: locationflathierarchy17.childid
  • Group Key: locationflathierarchy17.childid
  • Buffers: shared hit=15
38. 0.097 0.097 ↑ 1.0 5 1

Index Only Scan using locationflathierarchy_pkey on "4248ad1e6040418eb1e147598294e41f".locationflathierarchy locationflathierarchy17 (cost=0.28..6.49 rows=5 width=16) (actual time=0.086..0.097 rows=5 loops=1)

  • Output: locationflathierarchy17.parentid, locationflathierarchy17.childid
  • Index Cond: (locationflathierarchy17.parentid = ANY ('{8e2ef5b3-c1c5-46ab-9798-992d26cbbd51,1df0b5ec-dd0f-4865-8f43-b73369a6f9cc,fc55149c-3b4b-4e1c-875c-ba24e1638adc,c767d0f2-832f-42e4-a6da-956b4b6fe88e,46dcc8c3-f1a1-49a9-901b-9980950217bc}'::uuid[]))
  • Heap Fetches: 1
  • Buffers: shared hit=15
39. 0.200 0.200 ↓ 6.9 55 5

Index Scan using ixullocationid on "4248ad1e6040418eb1e147598294e41f".userlocation userlocation16 (cost=0.28..7.42 rows=8 width=28) (actual time=0.007..0.040 rows=55 loops=5)

  • Output: userlocation16.id, userlocation16.userid, userlocation16.locationid, userlocation16.startdate, userlocation16.enddate
  • Index Cond: (userlocation16.locationid = locationflathierarchy17.childid)
  • Buffers: shared hit=50
40. 2.466 2.466 ↓ 6.0 18 274

Index Only Scan using ixtsuseridstartdateenddate on "4248ad1e6040418eb1e147598294e41f".timesheet timesheet15 (cost=0.42..0.80 rows=3 width=12) (actual time=0.004..0.009 rows=18 loops=274)

  • Output: timesheet15.userid, timesheet15.startdate, timesheet15.enddate
  • Index Cond: ((timesheet15.userid = userlocation16.userid) AND (timesheet15.startdate <= userlocation16.enddate) AND (timesheet15.enddate >= userlocation16.startdate))
  • Heap Fetches: 1,356
  • Buffers: shared hit=2,402
41. 79.200 79.200 ↑ 8.2 19 4,950

Index Scan using ixter2userid on "4248ad1e6040418eb1e147598294e41f".timeentryrevision timeentryrevision14 (cost=0.43..4.72 rows=156 width=24) (actual time=0.003..0.016 rows=19 loops=4,950)

  • 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
  • Index Cond: ((timeentryrevision14.userid = timesheet15.userid) AND (timesheet15.startdate <= timeentryrevision14.entrydate) AND (timesheet15.enddate >= timeentryrevision14.entrydate))
  • Buffers: shared hit=33,177
42. 0.000 57,813.064 ↓ 0.0 0 7,226,633

Nested Loop (cost=1.70..22.86 rows=1 width=32) (actual time=0.008..0.008 rows=0 loops=7,226,633)

  • Output: upper(tsapprovalrequestkeyvalue18.uri)
  • Inner Unique: true
  • Buffers: shared hit=49,774,617
43. 0.000 57,813.064 ↓ 0.0 0 7,226,633

Nested Loop (cost=1.28..18.15 rows=10 width=84) (actual time=0.008..0.008 rows=0 loops=7,226,633)

  • Output: tsapprovalrequestkeyvalue18.uri, tsapprovalrequestkeyvalue18.parentid
  • Buffers: shared hit=49,774,617
44. 4,204.809 57,813.064 ↓ 0.0 0 7,226,633

Nested Loop (cost=0.99..14.47 rows=1 width=4) (actual time=0.008..0.008 rows=0 loops=7,226,633)

  • Output: tsapprovalrequest21.id
  • Inner Unique: true
  • Buffers: shared hit=49,774,617
45. 7,226.861 50,586.431 ↓ 0.0 0 7,226,633

Nested Loop (cost=0.71..14.13 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=7,226,633)

  • Output: timesheetapprovalnodes20.id
  • Buffers: shared hit=45,967,738
46. 28,906.532 28,906.532 ↑ 3.0 1 7,226,633

Index Scan using ixtsuseridstartdateenddate on "4248ad1e6040418eb1e147598294e41f".timesheet timesheet19 (cost=0.42..4.11 rows=3 width=16) (actual time=0.004..0.004 rows=1 loops=7,226,633)

  • Output: timesheet19.id, timesheet19.userid, timesheet19.startdate, timesheet19.enddate, timesheet19.approvalstatus, timesheet19.duedate, timesheet19.autosubmitdatetimeutc, timesheet19.lastautosubmitattemptdatetimeutc, timesheet19.createdonutc
  • Index Cond: ((timesheet19.userid = timeentryrevision13.userid) AND (timesheet19.startdate <= timeentryrevision13.entrydate) AND (timesheet19.enddate >= timeentryrevision13.entrydate))
  • Buffers: shared hit=30,443,080
47. 14,453.038 14,453.038 ↓ 0.0 0 7,226,519

Index Scan using ixtantimesheetid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalnodes timesheetapprovalnodes20 (cost=0.29..3.32 rows=2 width=32) (actual time=0.002..0.002 rows=0 loops=7,226,519)

  • Output: timesheetapprovalnodes20.id, timesheetapprovalnodes20.isapproved, timesheetapprovalnodes20.approverrole, timesheetapprovalnodes20.userid, timesheetapprovalnodes20.timesheetid, timesheetapprovalnodes20.systemprocessidentifier, timesheetapprovalnodes20.scriptid, timesheetapprovalnodes20.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes20.timesheetid = timesheet19.id)
  • Buffers: shared hit=15,524,658
48. 3,021.824 3,021.824 ↓ 0.0 0 1,510,912

Index Scan using ixtarnodeid on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequest tsapprovalrequest21 (cost=0.28..0.32 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=1,510,912)

  • Output: tsapprovalrequest21.id, tsapprovalrequest21.effectivedateutc, tsapprovalrequest21.userid, tsapprovalrequest21.nodeid, tsapprovalrequest21.remindersentutc, tsapprovalrequest21.overduesentutc, tsapprovalrequest21.waitingbatchsentutc, tsapprovalrequest21.approvalagenttype, tsapprovalrequest21.systemprocessidentifier
  • Index Cond: (tsapprovalrequest21.nodeid = timesheetapprovalnodes20.id)
  • Filter: (tsapprovalrequest21.userid = 4,397)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=3,806,879
49. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue18 (cost=0.29..3.56 rows=12 width=88) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue22 (cost=0.42..0.47 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue22.id, tsapprovalrequestkeyvalue22.tsapprovalrequestid, tsapprovalrequestkeyvalue22.parentid, tsapprovalrequestkeyvalue22.index, tsapprovalrequestkeyvalue22.key, tsapprovalrequestkeyvalue22.uri, tsapprovalrequestkeyvalue22.slug, tsapprovalrequestkeyvalue22."boolean", tsapprovalrequestkeyvalue22.date, tsapprovalrequestkeyvalue22.number, tsapprovalrequestkeyvalue22.text, tsapprovalrequestkeyvalue22."time", tsapprovalrequestkeyvalue22.timespan, tsapprovalrequestkeyvalue22.daterange_startdate, tsapprovalrequestkeyvalue22.daterange_enddate, tsapprovalrequestkeyvalue22.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue22.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue22.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue22.workdayduration_workdays, tsapprovalrequestkeyvalue22.workdayduration_hours, tsapprovalrequestkeyvalue22.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue22.id = tsapprovalrequestkeyvalue18.parentid)
  • Filter: (tsapprovalrequestkeyvalue22.parentid IS NULL)
51. 7,226.633 72,266.330 ↓ 0.0 0 7,226,633

Nested Loop (cost=7.25..29.15 rows=1 width=32) (actual time=0.010..0.010 rows=0 loops=7,226,633)

  • Output: upper(sheetapprovalhistorykeyvalue23.uri)
  • Buffers: shared hit=65,231,935
52. 0.000 65,039.697 ↓ 0.0 0 7,226,633

Nested Loop (cost=6.82..28.63 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=7,226,633)

  • Output: sheetapprovalhistorykeyvalue31.id
  • Buffers: shared hit=65,231,935
53. 0.000 65,039.697 ↓ 0.0 0 7,226,633

Nested Loop (cost=6.39..25.46 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=7,226,633)

  • Output: sheetapprovalhistorykeyvalue30.id
  • Buffers: shared hit=65,231,935
54. 0.000 65,039.697 ↓ 0.0 0 7,226,633

Nested Loop (cost=5.96..24.94 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=7,226,633)

  • Output: sheetapprovalhistorykeyvalue29.id
  • Buffers: shared hit=65,231,935
55. 0.000 65,039.697 ↓ 0.0 0 7,226,633

Nested Loop (cost=5.53..23.84 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=7,226,633)

  • Output: sheetapprovalhistorykeyvalue28.id
  • Buffers: shared hit=65,231,935
56. 0.000 65,039.697 ↓ 0.0 0 7,226,633

Nested Loop (cost=5.10..21.84 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=7,226,633)

  • Output: sheetapprovalhistorykeyvalue27.parentid
  • Inner Unique: true
  • Buffers: shared hit=65,231,935
57. 7,226.633 65,039.697 ↓ 0.0 0 7,226,633

Nested Loop (cost=4.67..19.39 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=7,226,633)

  • Output: sheetapprovalhistorykeyvalue26.parentid
  • Buffers: shared hit=65,231,935
58. 0.570 57,813.064 ↓ 0.0 0 7,226,633

Nested Loop (cost=0.84..14.53 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=7,226,633)

  • Output: timesheetapprovalhistory25.id
  • Buffers: shared hit=65,231,935
59. 21,679.899 21,679.899 ↑ 3.0 1 7,226,633

Index Scan using ixtsuseridstartdateenddate on "4248ad1e6040418eb1e147598294e41f".timesheet timesheet24 (cost=0.42..4.11 rows=3 width=16) (actual time=0.002..0.003 rows=1 loops=7,226,633)

  • Output: timesheet24.id, timesheet24.userid, timesheet24.startdate, timesheet24.enddate, timesheet24.approvalstatus, timesheet24.duedate, timesheet24.autosubmitdatetimeutc, timesheet24.lastautosubmitattemptdatetimeutc, timesheet24.createdonutc
  • Index Cond: ((timesheet24.userid = timeentryrevision13.userid) AND (timesheet24.startdate <= timeentryrevision13.entrydate) AND (timesheet24.enddate >= timeentryrevision13.entrydate))
  • Buffers: shared hit=30,443,080
60. 36,132.595 36,132.595 ↓ 0.0 0 7,226,519

Index Scan using ixtah2timesheetid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistory timesheetapprovalhistory25 (cost=0.42..3.46 rows=1 width=32) (actual time=0.005..0.005 rows=0 loops=7,226,519)

  • Output: timesheetapprovalhistory25.id, timesheetapprovalhistory25.action, timesheetapprovalhistory25.approvalcomments, timesheetapprovalhistory25.timestamputc, timesheetapprovalhistory25.serialnumber, timesheetapprovalhistory25.timesheetid, timesheetapprovalhistory25.approvalagenttype, timesheetapprovalhistory25.userid, timesheetapprovalhistory25.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory25.timesheetid = timesheet24.id)
  • Filter: (timesheetapprovalhistory25.userid = 4,397)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=34,788,855
61. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue26 (cost=3.82..4.85 rows=1 width=32) (never executed)

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

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

63. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (sheetapprovalhistorykeyvalue26.timesheetapprovalhistoryid = timesheetapprovalhistory25.id)
64. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (upper(sheetapprovalhistorykeyvalue26.uri) = 'URN:REPLICON-TENANT:4,248AD1E6040418EB1E147598294E41F:USER:4,397'::text)
65. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue27 (cost=0.43..2.45 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
  • Index Cond: (sheetapprovalhistorykeyvalue27.id = sheetapprovalhistorykeyvalue26.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue27.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
66. 0.000 0.000 ↓ 0.0 0

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

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue29 (cost=0.43..1.09 rows=2 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.id)
68. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue30 (cost=0.43..0.51 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue31 (cost=0.43..3.15 rows=2 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)
70. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue23 (cost=0.43..0.50 rows=2 width=94) (never executed)

  • Output: sheetapprovalhistorykeyvalue23.id, sheetapprovalhistorykeyvalue23.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue23.parentid, sheetapprovalhistorykeyvalue23.index, sheetapprovalhistorykeyvalue23.key, sheetapprovalhistorykeyvalue23.uri, sheetapprovalhistorykeyvalue23.slug, sheetapprovalhistorykeyvalue23."boolean", sheetapprovalhistorykeyvalue23.date, sheetapprovalhistorykeyvalue23.number, sheetapprovalhistorykeyvalue23.text, sheetapprovalhistorykeyvalue23."time", sheetapprovalhistorykeyvalue23.timespan, sheetapprovalhistorykeyvalue23.daterange_startdate, sheetapprovalhistorykeyvalue23.daterange_enddate, sheetapprovalhistorykeyvalue23.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue23.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue23.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue23.workdayduration_workdays, sheetapprovalhistorykeyvalue23.workdayduration_hours, sheetapprovalhistorykeyvalue23.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue23.parentid = sheetapprovalhistorykeyvalue31.id)
71. 7,226.633 281,838.687 ↓ 0.0 0 7,226,633

Nested Loop (cost=1.82..10.08 rows=1 width=32) (actual time=0.039..0.039 rows=0 loops=7,226,633)

  • Output: upper(tsapprovalrequestkeyvalue32.uri)
  • Inner Unique: true
  • Buffers: shared hit=21,679,899
72. 0.000 274,612.054 ↓ 0.0 0 7,226,633

Nested Loop (cost=1.41..7.64 rows=1 width=84) (actual time=0.038..0.038 rows=0 loops=7,226,633)

  • Output: tsapprovalrequestkeyvalue32.uri, tsapprovalrequestkeyvalue32.parentid
  • Inner Unique: true
  • Buffers: shared hit=21,679,899
73. 0.000 274,612.054 ↓ 0.0 0 7,226,633

Nested Loop (cost=0.98..6.71 rows=1 width=100) (actual time=0.038..0.038 rows=0 loops=7,226,633)

  • Output: timesheetapprovalnodes34.timesheetid, tsapprovalrequestkeyvalue32.uri, tsapprovalrequestkeyvalue32.parentid
  • Inner Unique: true
  • Buffers: shared hit=21,679,899
74. 0.000 274,612.054 ↓ 0.0 0 7,226,633

Nested Loop (cost=0.70..4.41 rows=1 width=100) (actual time=0.038..0.038 rows=0 loops=7,226,633)

  • Output: tsapprovalrequest35.nodeid, tsapprovalrequestkeyvalue32.uri, tsapprovalrequestkeyvalue32.parentid
  • Inner Unique: true
  • Buffers: shared hit=21,679,899
75. 274,612.054 274,612.054 ↓ 0.0 0 7,226,633

Index Scan using ixtsarkvkey on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue32 (cost=0.42..1.44 rows=1 width=88) (actual time=0.038..0.038 rows=0 loops=7,226,633)

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

Index Scan using tsapprovalrequest_pkey on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequest tsapprovalrequest35 (cost=0.28..2.30 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest35.id, tsapprovalrequest35.effectivedateutc, tsapprovalrequest35.userid, tsapprovalrequest35.nodeid, tsapprovalrequest35.remindersentutc, tsapprovalrequest35.overduesentutc, tsapprovalrequest35.waitingbatchsentutc, tsapprovalrequest35.approvalagenttype, tsapprovalrequest35.systemprocessidentifier
  • Index Cond: (tsapprovalrequest35.id = tsapprovalrequestkeyvalue32.tsapprovalrequestid)
  • Filter: (tsapprovalrequest35.userid = 4,397)
77. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalnodes_pkey on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalnodes timesheetapprovalnodes34 (cost=0.29..2.30 rows=1 width=32) (never executed)

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

Index Scan using timesheet_pkey on "4248ad1e6040418eb1e147598294e41f".timesheet timesheet33 (cost=0.42..0.76 rows=1 width=16) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue36 (cost=0.42..2.44 rows=1 width=16) (never executed)

  • Output: tsapprovalrequestkeyvalue36.id, tsapprovalrequestkeyvalue36.tsapprovalrequestid, tsapprovalrequestkeyvalue36.parentid, tsapprovalrequestkeyvalue36.index, tsapprovalrequestkeyvalue36.key, tsapprovalrequestkeyvalue36.uri, tsapprovalrequestkeyvalue36.slug, tsapprovalrequestkeyvalue36."boolean", tsapprovalrequestkeyvalue36.date, tsapprovalrequestkeyvalue36.number, tsapprovalrequestkeyvalue36.text, tsapprovalrequestkeyvalue36."time", tsapprovalrequestkeyvalue36.timespan, tsapprovalrequestkeyvalue36.daterange_startdate, tsapprovalrequestkeyvalue36.daterange_enddate, tsapprovalrequestkeyvalue36.daterange_relativedaterangeuri, tsapprovalrequestkeyvalue36.daterange_relativedaterangeasofdate, tsapprovalrequestkeyvalue36.workdayduration_decimalworkdays, tsapprovalrequestkeyvalue36.workdayduration_workdays, tsapprovalrequestkeyvalue36.workdayduration_hours, tsapprovalrequestkeyvalue36.workdayduration_minutes
  • Index Cond: (tsapprovalrequestkeyvalue36.id = tsapprovalrequestkeyvalue32.parentid)
  • Filter: (tsapprovalrequestkeyvalue36.parentid IS NULL)
80. 0.000 50,586.431 ↓ 0.0 0 7,226,633

Nested Loop (cost=7.25..29.47 rows=1 width=32) (actual time=0.007..0.007 rows=0 loops=7,226,633)

  • Output: upper(sheetapprovalhistorykeyvalue37.uri)
  • Buffers: shared hit=65,231,935
81. 0.000 50,586.431 ↓ 0.0 0 7,226,633

Nested Loop (cost=6.82..28.94 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=7,226,633)

  • Output: sheetapprovalhistorykeyvalue45.id
  • Buffers: shared hit=65,231,935
82. 0.000 50,586.431 ↓ 0.0 0 7,226,633

Nested Loop (cost=6.39..25.46 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=7,226,633)

  • Output: sheetapprovalhistorykeyvalue44.id
  • Buffers: shared hit=65,231,935
83. 0.000 50,586.431 ↓ 0.0 0 7,226,633

Nested Loop (cost=5.96..24.94 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=7,226,633)

  • Output: sheetapprovalhistorykeyvalue43.id
  • Buffers: shared hit=65,231,935
84. 7,226.633 50,586.431 ↓ 0.0 0 7,226,633

Nested Loop (cost=5.53..23.84 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=7,226,633)

  • Output: sheetapprovalhistorykeyvalue42.id
  • Buffers: shared hit=65,231,935
85. 0.000 43,359.798 ↓ 0.0 0 7,226,633

Nested Loop (cost=5.10..21.84 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=7,226,633)

  • Output: sheetapprovalhistorykeyvalue41.parentid
  • Inner Unique: true
  • Buffers: shared hit=65,231,935
86. 0.000 43,359.798 ↓ 0.0 0 7,226,633

Nested Loop (cost=4.67..19.39 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=7,226,633)

  • Output: sheetapprovalhistorykeyvalue40.parentid
  • Buffers: shared hit=65,231,935
87. 7,226.861 43,359.798 ↓ 0.0 0 7,226,633

Nested Loop (cost=0.84..14.53 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=7,226,633)

  • Output: timesheetapprovalhistory39.id
  • Buffers: shared hit=65,231,935
88. 21,679.899 21,679.899 ↑ 3.0 1 7,226,633

Index Scan using ixtsuseridstartdateenddate on "4248ad1e6040418eb1e147598294e41f".timesheet timesheet38 (cost=0.42..4.11 rows=3 width=16) (actual time=0.002..0.003 rows=1 loops=7,226,633)

  • Output: timesheet38.id, timesheet38.userid, timesheet38.startdate, timesheet38.enddate, timesheet38.approvalstatus, timesheet38.duedate, timesheet38.autosubmitdatetimeutc, timesheet38.lastautosubmitattemptdatetimeutc, timesheet38.createdonutc
  • Index Cond: ((timesheet38.userid = timeentryrevision13.userid) AND (timesheet38.startdate <= timeentryrevision13.entrydate) AND (timesheet38.enddate >= timeentryrevision13.entrydate))
  • Buffers: shared hit=30,443,080
89. 14,453.038 14,453.038 ↓ 0.0 0 7,226,519

Index Scan using ixtah2timesheetid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistory timesheetapprovalhistory39 (cost=0.42..3.46 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=7,226,519)

  • Output: timesheetapprovalhistory39.id, timesheetapprovalhistory39.action, timesheetapprovalhistory39.approvalcomments, timesheetapprovalhistory39.timestamputc, timesheetapprovalhistory39.serialnumber, timesheetapprovalhistory39.timesheetid, timesheetapprovalhistory39.approvalagenttype, timesheetapprovalhistory39.userid, timesheetapprovalhistory39.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory39.timesheetid = timesheet38.id)
  • Filter: (timesheetapprovalhistory39.userid = 4,397)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=34,788,855
90. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue40 (cost=3.82..4.85 rows=1 width=32) (never executed)

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

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

92. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (sheetapprovalhistorykeyvalue40.timesheetapprovalhistoryid = timesheetapprovalhistory39.id)
93. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (upper(sheetapprovalhistorykeyvalue40.uri) = 'URN:REPLICON-TENANT:4,248AD1E6040418EB1E147598294E41F:USER:4,397'::text)
94. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue41 (cost=0.43..2.45 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
  • Index Cond: (sheetapprovalhistorykeyvalue41.id = sheetapprovalhistorykeyvalue40.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue41.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
95. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue42 (cost=0.43..1.98 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.parentid = sheetapprovalhistorykeyvalue41.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue42.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
96. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue43 (cost=0.43..1.09 rows=2 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.id)
97. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue44 (cost=0.43..0.51 rows=1 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)
  • Filter: (upper(sheetapprovalhistorykeyvalue44.uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
98. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue45 (cost=0.43..3.46 rows=2 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)
99. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue37 (cost=0.43..0.50 rows=2 width=94) (never executed)

  • Output: sheetapprovalhistorykeyvalue37.id, sheetapprovalhistorykeyvalue37.timesheetapprovalhistoryid, sheetapprovalhistorykeyvalue37.parentid, sheetapprovalhistorykeyvalue37.index, sheetapprovalhistorykeyvalue37.key, sheetapprovalhistorykeyvalue37.uri, sheetapprovalhistorykeyvalue37.slug, sheetapprovalhistorykeyvalue37."boolean", sheetapprovalhistorykeyvalue37.date, sheetapprovalhistorykeyvalue37.number, sheetapprovalhistorykeyvalue37.text, sheetapprovalhistorykeyvalue37."time", sheetapprovalhistorykeyvalue37.timespan, sheetapprovalhistorykeyvalue37.daterange_startdate, sheetapprovalhistorykeyvalue37.daterange_enddate, sheetapprovalhistorykeyvalue37.daterange_relativedaterangeuri, sheetapprovalhistorykeyvalue37.daterange_relativedaterangeasofdate, sheetapprovalhistorykeyvalue37.workdayduration_decimalworkdays, sheetapprovalhistorykeyvalue37.workdayduration_workdays, sheetapprovalhistorykeyvalue37.workdayduration_hours, sheetapprovalhistorykeyvalue37.workdayduration_minutes
  • Index Cond: (sheetapprovalhistorykeyvalue37.parentid = sheetapprovalhistorykeyvalue45.id)
100. 101,172.844 101,172.862 ↓ 0.0 0 7,226,633

Index Scan using ixtemrtimeentryid on "4248ad1e6040418eb1e147598294e41f".timeentrymetadatarevision timeentrymetadatarevision46 (cost=94.27..100.48 rows=1 width=0) (actual time=0.014..0.014 rows=0 loops=7,226,633)

  • Index Cond: (timeentrymetadatarevision46.timeentryid = timeentryrevision13.timeentryid)
  • Filter: ((timeentrymetadatarevision46.fromtimestamputc <= timeentryrevision13.fromtimestamputc) AND ((timeentrymetadatarevision46.totimestamputc > timeentryrevision13.fromtimestamputc) OR (timeentrymetadatarevision46.totimestamputc IS NULL)) AND (((upper(timeentrymetadatarevision46.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 7)) OR ((upper(timeentrymetadatarevision46.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 8))))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=54,272,000
101.          

SubPlan (for Index Scan)

102. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ixprjprojectleaderapproverid on "4248ad1e6040418eb1e147598294e41f".project project47 (cost=0.29..4.31 rows=3 width=32) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: upper(('urn:replicon-tenant:4,248ad1e6040418eb1e147598294e41f:project:'::text || COALESCE((project47.id)::text, ''::text)))
  • Index Cond: (project47.projectleaderapproverid = 4,397)
  • Buffers: shared hit=2
103. 0.000 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.71..89.23 rows=65 width=32) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: upper(('urn:replicon-tenant:4,248ad1e6040418eb1e147598294e41f:task:'::text || COALESCE((task48.id)::text, ''::text)))
  • Buffers: shared hit=2
104. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ixprjprojectleaderapproverid on "4248ad1e6040418eb1e147598294e41f".project project49 (cost=0.29..4.28 rows=3 width=4) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: project49.id, project49.clientbillingallocationmethod, project49.timeentrycappercent, project49.info1, project49.info2, project49.info3, project49.info4, project49.info5, project49.info6, project49.info7, project49.info8, project49.info9, project49.info10, project49.info11, project49.info12, project49.info13, project49.info14, project49.info15, project49.info16, project49.info17, project49.info18, project49.info19, project49.info20, project49.name, project49.slug, project49.code, project49.clientid, project49.projectleaderapproverid, project49.isprojectleaderapprovalrequired, project49.startdate, project49.enddate, project49.programid, project49.billingtype, project49.fixedbidamount, project49.fixedbidcurrencyid, project49.fixedbidfrequency, project49.costtype, project49.description, project49.percentcomplete, project49.istimeentryallowed, project49.estimatedhours, project49.estimatedexpenses, project49.estimatedexpensescurrencyid, project49.estimatedcost, project49.estimatedcostcurrencyid, project49.timeandexpenseentrytype, project49.estimationmode, project49.projectstatuslabelid, project49.billingratefrequencyid, project49.billingratefrequencyduration, project49.defaultbillingcurrencyid, project49.billingcontractid, project49.guidid, project49.totalestimatedcontractamount, project49.totalestimatedcontractcurrencyid, project49.budgetedhours, project49.budgetedcost, project49.budgetedcostcurrencyid, project49.uniquename, project49.uniquecode, project49.uri
  • Index Cond: (project49.projectleaderapproverid = 4,397)
  • Buffers: shared hit=2
105. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtkprojectid on "4248ad1e6040418eb1e147598294e41f".task task48 (cost=0.42..27.84 rows=26 width=8) (never executed)

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

Index Scan using ixtemrtimeentryid on "4248ad1e6040418eb1e147598294e41f".timeentrymetadatarevision timeentrymetadatarevision50 (cost=94.27..100.48 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=7,226,633)

  • Index Cond: (timeentrymetadatarevision50.timeentryid = timeentryrevision13.timeentryid)
  • Filter: ((timeentrymetadatarevision50.fromtimestamputc <= timeentryrevision13.fromtimestamputc) AND ((timeentrymetadatarevision50.totimestamputc > timeentryrevision13.fromtimestamputc) OR (timeentrymetadatarevision50.totimestamputc IS NULL)) AND (((upper(timeentrymetadatarevision50.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 10)) OR ((upper(timeentrymetadatarevision50.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 11))))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=54,272,000
107.          

SubPlan (for Index Scan)

108. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ixprjprojectleaderapproverid on "4248ad1e6040418eb1e147598294e41f".project project51 (cost=0.29..4.31 rows=3 width=32) (actual time=0.007..0.008 rows=0 loops=1)

  • Output: upper(('urn:replicon-tenant:4,248ad1e6040418eb1e147598294e41f:project:'::text || COALESCE((project51.id)::text, ''::text)))
  • Index Cond: (project51.projectleaderapproverid = 4,397)
  • Buffers: shared hit=2
109. 0.000 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.71..89.23 rows=65 width=32) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: upper(('urn:replicon-tenant:4,248ad1e6040418eb1e147598294e41f:task:'::text || COALESCE((task52.id)::text, ''::text)))
  • Buffers: shared hit=2
110. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ixprjprojectleaderapproverid on "4248ad1e6040418eb1e147598294e41f".project project53 (cost=0.29..4.28 rows=3 width=4) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: project53.id, project53.clientbillingallocationmethod, project53.timeentrycappercent, project53.info1, project53.info2, project53.info3, project53.info4, project53.info5, project53.info6, project53.info7, project53.info8, project53.info9, project53.info10, project53.info11, project53.info12, project53.info13, project53.info14, project53.info15, project53.info16, project53.info17, project53.info18, project53.info19, project53.info20, project53.name, project53.slug, project53.code, project53.clientid, project53.projectleaderapproverid, project53.isprojectleaderapprovalrequired, project53.startdate, project53.enddate, project53.programid, project53.billingtype, project53.fixedbidamount, project53.fixedbidcurrencyid, project53.fixedbidfrequency, project53.costtype, project53.description, project53.percentcomplete, project53.istimeentryallowed, project53.estimatedhours, project53.estimatedexpenses, project53.estimatedexpensescurrencyid, project53.estimatedcost, project53.estimatedcostcurrencyid, project53.timeandexpenseentrytype, project53.estimationmode, project53.projectstatuslabelid, project53.billingratefrequencyid, project53.billingratefrequencyduration, project53.defaultbillingcurrencyid, project53.billingcontractid, project53.guidid, project53.totalestimatedcontractamount, project53.totalestimatedcontractcurrencyid, project53.budgetedhours, project53.budgetedcost, project53.budgetedcostcurrencyid, project53.uniquename, project53.uniquecode, project53.uri
  • Index Cond: (project53.projectleaderapproverid = 4,397)
  • Buffers: shared hit=2
111. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtkprojectid on "4248ad1e6040418eb1e147598294e41f".task task52 (cost=0.42..27.84 rows=26 width=8) (never executed)

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

Nested Loop (cost=1.70..22.86 rows=1 width=32) (never executed)

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

Nested Loop (cost=1.28..18.15 rows=10 width=84) (never executed)

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

Nested Loop (cost=0.99..14.47 rows=1 width=4) (never executed)

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

Nested Loop (cost=0.71..14.13 rows=1 width=16) (never executed)

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

Index Scan using ixtsuseridstartdateenddate on "4248ad1e6040418eb1e147598294e41f".timesheet timesheet55 (cost=0.42..4.11 rows=3 width=16) (never executed)

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

Index Scan using ixtantimesheetid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalnodes timesheetapprovalnodes56 (cost=0.29..3.32 rows=2 width=32) (never executed)

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

Index Scan using ixtarnodeid on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequest tsapprovalrequest57 (cost=0.28..0.32 rows=1 width=20) (never executed)

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

Index Scan using ixtsarkvtsapprovalrequestid on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue54 (cost=0.29..3.56 rows=12 width=88) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue58 (cost=0.42..0.47 rows=1 width=16) (never executed)

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

Nested Loop (cost=7.25..29.15 rows=1 width=32) (never executed)

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

Nested Loop (cost=6.82..28.63 rows=1 width=16) (never executed)

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

Nested Loop (cost=6.39..25.46 rows=1 width=16) (never executed)

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

Nested Loop (cost=5.96..24.94 rows=1 width=16) (never executed)

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

Nested Loop (cost=5.53..23.84 rows=1 width=16) (never executed)

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

Nested Loop (cost=5.10..21.84 rows=1 width=16) (never executed)

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

Nested Loop (cost=4.67..19.39 rows=1 width=16) (never executed)

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

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

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

Index Scan using ixtsuseridstartdateenddate on "4248ad1e6040418eb1e147598294e41f".timesheet timesheet60 (cost=0.42..4.11 rows=3 width=16) (never executed)

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

Index Scan using ixtah2timesheetid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistory timesheetapprovalhistory61 (cost=0.42..3.46 rows=1 width=32) (never executed)

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

Bitmap Heap Scan on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue62 (cost=3.82..4.85 rows=1 width=32) (never executed)

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

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

133. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (sheetapprovalhistorykeyvalue62.timesheetapprovalhistoryid = timesheetapprovalhistory61.id)
134. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (upper(sheetapprovalhistorykeyvalue62.uri) = 'URN:REPLICON-TENANT:4,248AD1E6040418EB1E147598294E41F:USER:4,397'::text)
135. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue63 (cost=0.43..2.45 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue64 (cost=0.43..1.98 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue65 (cost=0.43..1.09 rows=2 width=32) (never executed)

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

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue66 (cost=0.43..0.51 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue67 (cost=0.43..3.15 rows=2 width=32) (never executed)

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

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue59 (cost=0.43..0.50 rows=2 width=94) (never executed)

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

Index Scan using ixtemrtimeentryid on "4248ad1e6040418eb1e147598294e41f".timeentrymetadatarevision timeentrymetadatarevision68 (cost=87.98..94.19 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=7,226,633)

  • Index Cond: (timeentrymetadatarevision68.timeentryid = timeentryrevision13.timeentryid)
  • Filter: ((timeentrymetadatarevision68.fromtimestamputc <= timeentryrevision13.fromtimestamputc) AND ((timeentrymetadatarevision68.totimestamputc > timeentryrevision13.fromtimestamputc) OR (timeentrymetadatarevision68.totimestamputc IS NULL)) AND (((upper(timeentrymetadatarevision68.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 15)) OR ((upper(timeentrymetadatarevision68.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 16))))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=54,271,998
142.          

SubPlan (for Index Scan)

143. 0.000 0.011 ↓ 0.0 0 1

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

  • Output: upper(('urn:replicon-tenant:4,248ad1e6040418eb1e147598294e41f:project:'::text || COALESCE((project69.id)::text, ''::text)))
  • Inner Unique: true
  • Buffers: shared hit=1
144. 0.001 0.011 ↓ 0.0 0 1

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

  • Output: resentativeprojectassignment70.projectid
  • Group Key: resentativeprojectassignment70.projectid
  • Buffers: shared hit=1
145. 0.000 0.010 ↓ 0.0 0 1

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

  • Output: resentativeprojectassignment70.projectid
  • Buffers: shared hit=1
146. 0.010 0.010 ↓ 0.0 0 1

Index Scan using uix2cr_clientuser on "4248ad1e6040418eb1e147598294e41f".clientrepresentative clientrepresentative71 (cost=0.15..19.01 rows=8 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: clientrepresentative71.id, clientrepresentative71.clientid, clientrepresentative71.userid
  • Index Cond: (clientrepresentative71.userid = 4,397)
  • Buffers: shared hit=1
147. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcrpaclientrepresentativeid on "4248ad1e6040418eb1e147598294e41f".clientrepresentativeprojectassignment resentativeprojectassignment70 (cost=0.15..1.63 rows=6 width=20) (never executed)

  • Output: resentativeprojectassignment70.id, resentativeprojectassignment70.clientrepresentativeid, resentativeprojectassignment70.projectid
  • Index Cond: (resentativeprojectassignment70.clientrepresentativeid = clientrepresentative71.id)
148. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "4248ad1e6040418eb1e147598294e41f".project project69 (cost=0.29..0.37 rows=1 width=4) (never executed)

  • Output: project69.id
  • Index Cond: (project69.id = resentativeprojectassignment70.projectid)
  • Heap Fetches: 0
149. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=33.27..52.09 rows=157 width=32) (actual time=0.012..0.012 rows=0 loops=1)

  • Output: upper(('urn:replicon-tenant:4,248ad1e6040418eb1e147598294e41f:task:'::text || COALESCE((task72.id)::text, ''::text)))
  • Buffers: shared hit=1
150. 0.000 0.011 ↓ 0.0 0 1

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

  • Output: project73.id, resentativeprojectassignment70_1.projectid
  • Inner Unique: true
  • Buffers: shared hit=1
151. 0.001 0.011 ↓ 0.0 0 1

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

  • Output: resentativeprojectassignment70_1.projectid
  • Group Key: resentativeprojectassignment70_1.projectid
  • Buffers: shared hit=1
152. 0.000 0.010 ↓ 0.0 0 1

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

  • Output: resentativeprojectassignment70_1.projectid
  • Buffers: shared hit=1
153. 0.010 0.010 ↓ 0.0 0 1

Index Scan using uix2cr_clientuser on "4248ad1e6040418eb1e147598294e41f".clientrepresentative clientrepresentative71_1 (cost=0.15..19.01 rows=8 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: clientrepresentative71_1.id, clientrepresentative71_1.clientid, clientrepresentative71_1.userid
  • Index Cond: (clientrepresentative71_1.userid = 4,397)
  • Buffers: shared hit=1
154. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcrpaclientrepresentativeid on "4248ad1e6040418eb1e147598294e41f".clientrepresentativeprojectassignment resentativeprojectassignment70_1 (cost=0.15..1.63 rows=6 width=20) (never executed)

  • Output: resentativeprojectassignment70_1.id, resentativeprojectassignment70_1.clientrepresentativeid, resentativeprojectassignment70_1.projectid
  • Index Cond: (resentativeprojectassignment70_1.clientrepresentativeid = clientrepresentative71_1.id)
155. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "4248ad1e6040418eb1e147598294e41f".project project73 (cost=0.29..0.37 rows=1 width=4) (never executed)

  • Output: project73.id
  • Index Cond: (project73.id = resentativeprojectassignment70_1.projectid)
  • Heap Fetches: 0
156. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtkprojectid on "4248ad1e6040418eb1e147598294e41f".task task72 (cost=0.42..2.35 rows=26 width=8) (never executed)

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

Nested Loop (cost=1.70..22.86 rows=1 width=32) (never executed)

  • Output: upper(tsapprovalrequestkeyvalue74.uri)
  • Inner Unique: true
158. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.28..18.15 rows=10 width=84) (never executed)

  • Output: tsapprovalrequestkeyvalue74.uri, tsapprovalrequestkeyvalue74.parentid
159. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.99..14.47 rows=1 width=4) (never executed)

  • Output: tsapprovalrequest77.id
  • Inner Unique: true
160. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..14.13 rows=1 width=16) (never executed)

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

Index Scan using ixtsuseridstartdateenddate on "4248ad1e6040418eb1e147598294e41f".timesheet timesheet75 (cost=0.42..4.11 rows=3 width=16) (never executed)

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

Index Scan using ixtantimesheetid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalnodes timesheetapprovalnodes76 (cost=0.29..3.32 rows=2 width=32) (never executed)

  • Output: timesheetapprovalnodes76.id, timesheetapprovalnodes76.isapproved, timesheetapprovalnodes76.approverrole, timesheetapprovalnodes76.userid, timesheetapprovalnodes76.timesheetid, timesheetapprovalnodes76.systemprocessidentifier, timesheetapprovalnodes76.scriptid, timesheetapprovalnodes76.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes76.timesheetid = timesheet75.id)
163. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtarnodeid on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequest tsapprovalrequest77 (cost=0.28..0.32 rows=1 width=20) (never executed)

  • Output: tsapprovalrequest77.id, tsapprovalrequest77.effectivedateutc, tsapprovalrequest77.userid, tsapprovalrequest77.nodeid, tsapprovalrequest77.remindersentutc, tsapprovalrequest77.overduesentutc, tsapprovalrequest77.waitingbatchsentutc, tsapprovalrequest77.approvalagenttype, tsapprovalrequest77.systemprocessidentifier
  • Index Cond: (tsapprovalrequest77.nodeid = timesheetapprovalnodes76.id)
  • Filter: (tsapprovalrequest77.userid = 4,397)
164. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvtsapprovalrequestid on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue74 (cost=0.29..3.56 rows=12 width=88) (never executed)

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

Index Scan using tsapprovalrequestkeyvalue_pkey on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue78 (cost=0.42..0.47 rows=1 width=16) (never executed)

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

Nested Loop (cost=7.25..29.15 rows=1 width=32) (never executed)

  • Output: upper(sheetapprovalhistorykeyvalue79.uri)
167. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=6.82..28.63 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue87.id
168. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=6.39..25.46 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue86.id
169. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.96..24.94 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue85.id
170. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.53..23.84 rows=1 width=16) (never executed)

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

Nested Loop (cost=5.10..21.84 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue83.parentid
  • Inner Unique: true
172. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.67..19.39 rows=1 width=16) (never executed)

  • Output: sheetapprovalhistorykeyvalue82.parentid
173. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using ixtsuseridstartdateenddate on "4248ad1e6040418eb1e147598294e41f".timesheet timesheet80 (cost=0.42..4.11 rows=3 width=16) (never executed)

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

Index Scan using ixtah2timesheetid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistory timesheetapprovalhistory81 (cost=0.42..3.46 rows=1 width=32) (never executed)

  • Output: timesheetapprovalhistory81.id, timesheetapprovalhistory81.action, timesheetapprovalhistory81.approvalcomments, timesheetapprovalhistory81.timestamputc, timesheetapprovalhistory81.serialnumber, timesheetapprovalhistory81.timesheetid, timesheetapprovalhistory81.approvalagenttype, timesheetapprovalhistory81.userid, timesheetapprovalhistory81.systemprocessidentifier
  • Index Cond: (timesheetapprovalhistory81.timesheetid = timesheet80.id)
  • Filter: (timesheetapprovalhistory81.userid = 4,397)
176. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue82 (cost=3.82..4.85 rows=1 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
  • Recheck Cond: ((sheetapprovalhistorykeyvalue82.timesheetapprovalhistoryid = timesheetapprovalhistory81.id) AND (upper(sheetapprovalhistorykeyvalue82.uri) = 'URN:REPLICON-TENANT:4,248AD1E6040418EB1E147598294E41F:USER:4,397'::text))
  • Filter: (upper(sheetapprovalhistorykeyvalue82.key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
177. 0.000 0.000 ↓ 0.0 0

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

178. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (sheetapprovalhistorykeyvalue82.timesheetapprovalhistoryid = timesheetapprovalhistory81.id)
179. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (upper(sheetapprovalhistorykeyvalue82.uri) = 'URN:REPLICON-TENANT:4,248AD1E6040418EB1E147598294E41F:USER:4,397'::text)
180. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue83 (cost=0.43..2.45 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.id = sheetapprovalhistorykeyvalue82.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue83.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
181. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue84 (cost=0.43..1.98 rows=1 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.parentid)
  • Filter: (upper(sheetapprovalhistorykeyvalue84.uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
182. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue85 (cost=0.43..1.09 rows=2 width=32) (never executed)

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

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue86 (cost=0.43..0.51 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue87 (cost=0.43..3.15 rows=2 width=32) (never executed)

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

Index Scan using ixtahkvparentid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue79 (cost=0.43..0.50 rows=2 width=94) (never executed)

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

Subquery Scan on *SELECT* 2 (cost=3,008,094,608.48..3,008,094,626.57 rows=2 width=64) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: "*SELECT* 2".entrydate, "*SELECT* 2".duration, "*SELECT* 2".userid, "*SELECT* 2".timeentryid, "*SELECT* 2".billingrateid, "*SELECT* 2".timeoffentryid, "*SELECT* 2".timeallocationtype
  • Filter: (hashed SubPlan 20)
  • Buffers: shared hit=1
187. 0.001 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.29..18.33 rows=4 width=140) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: NULL::uuid, NULL::integer, 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=1
188. 0.007 0.007 ↓ 0.0 0 1

Index Scan using uix2toe_timeoffidentrydate on "4248ad1e6040418eb1e147598294e41f".timeoffentries toe (cost=0.15..12.59 rows=4 width=28) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: toe.id, toe.timeoffid, toe.entrydate, toe.duration, toe.timein, toe.timeout, toe.isreportable, toe.workdayduration, toe.entryid
  • Index Cond: ((toe.entrydate >= '2020-09-24'::date) AND (toe.entrydate <= '2020-10-23'::date))
  • Buffers: shared hit=1
189. 0.000 0.000 ↓ 0.0 0

Index Scan using timeoffs_pkey on "4248ad1e6040418eb1e147598294e41f".timeoffs toff (cost=0.14..1.41 rows=1 width=8) (never executed)

  • Output: toff.id, toff.guidid, toff.userid, toff.createdbyuserid, toff.timeoffcodeid, toff.startdate, toff.enddate, toff.approvalstatus, toff.comments, toff.submittedonutc, toff.modifiedonutc, toff.info1, toff.info2, toff.info3, toff.info4, toff.info5, toff.startdurationtype, toff.enddurationtype, toff.startduration, toff.endduration, toff.startdatestarttime, toff.enddateendtime, toff.entryconfigurationmethod
  • Index Cond: (toff.id = toe.timeoffid)
190. 8.388 8.388 ↓ 0.0 0 1,398

Index Scan using ixtem2timeentryid on "4248ad1e6040418eb1e147598294e41f".timeentrymetadata timeentrymetadata10 (cost=0.56..2.39 rows=1 width=74) (actual time=0.006..0.006 rows=0 loops=1,398)

  • 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=5,592
191. 11.184 11.184 ↓ 0.0 0 1,398

Index Scan using ixtem2timeentryid on "4248ad1e6040418eb1e147598294e41f".timeentrymetadata timeentrymetadata6 (cost=0.56..2.39 rows=1 width=74) (actual time=0.008..0.008 rows=0 loops=1,398)

  • 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:PROJECT'::text))
  • Buffers: shared hit=5,747
192. 0.000 0.000 ↓ 0.0 0 1,398

Index Only Scan using project_pkey on "4248ad1e6040418eb1e147598294e41f".project project7 (cost=0.30..0.32 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1,398)

  • Output: project7.id
  • Index Cond: (project7.id = CASE WHEN ("substring"(timeentrymetadata6.uri, '^urn:replicon-tenant:4,248ad1e6040418eb1e147598294e41f:project:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata6.uri, '^urn:replicon-tenant:4,248ad1e6040418eb1e147598294e41f:project:(.*)$'::text))::integer ELSE NULL::integer END)
  • Heap Fetches: 0
  • Buffers: shared hit=311
193. 5.592 5.592 ↑ 1.0 1 1,398

Index Scan using ixtem2timeentryid on "4248ad1e6040418eb1e147598294e41f".timeentrymetadata timeentrymetadata8 (cost=0.56..2.39 rows=1 width=74) (actual time=0.004..0.004 rows=1 loops=1,398)

  • Output: timeentrymetadata8.id, timeentrymetadata8.timeentryid, timeentrymetadata8.parentid, timeentrymetadata8.index, timeentrymetadata8.key, timeentrymetadata8.uri, timeentrymetadata8.slug, timeentrymetadata8."boolean", timeentrymetadata8.date, timeentrymetadata8.number, timeentrymetadata8.text, timeentrymetadata8."time", timeentrymetadata8.timespan, timeentrymetadata8.daterange_startdate, timeentrymetadata8.daterange_enddate, timeentrymetadata8.daterange_relativedaterangeuri, timeentrymetadata8.daterange_relativedaterangeasofdate, timeentrymetadata8.workdayduration_decimalworkdays, timeentrymetadata8.workdayduration_workdays, timeentrymetadata8.workdayduration_hours, timeentrymetadata8.workdayduration_minutes
  • Index Cond: (("*SELECT* 1".timeentryid = timeentrymetadata8.timeentryid) AND (upper(timeentrymetadata8.key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text))
  • Buffers: shared hit=6,915
194. 2.796 2.796 ↑ 1.0 1 1,398

Index Scan using task_pkey on "4248ad1e6040418eb1e147598294e41f".task task9 (cost=0.43..0.45 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,398)

  • Output: task9.id, task9.projectid, task9.parentid, task9.name, task9.description, task9.estimatedcost, task9.estimatedcostcurrencyid, task9.estimatedhours, task9.estimatedexpenses, task9.estimatedexpensescurrencyid, task9.expenseentrystartdate, task9.expenseentryenddate, task9.info1, task9.info2, task9.info3, task9.info4, task9.info5, task9.info6, task9.info7, task9.info8, task9.info9, task9.info10, task9.info11, task9.info12, task9.info13, task9.info14, task9.info15, task9.info16, task9.info17, task9.info18, task9.info19, task9.info20, task9.code, task9.isclosed, task9.percentcomplete, task9.istimeentryallowed, task9.timeentrystartdate, task9.timeentryenddate, task9.orderindex, task9.timeandexpenseentrytype, task9.costtype, task9.closeddate, task9.guidid, task9.uri
  • Index Cond: (CASE WHEN ("substring"(timeentrymetadata8.uri, '^urn:replicon-tenant:4,248ad1e6040418eb1e147598294e41f:task:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata8.uri, '^urn:replicon-tenant:4,248ad1e6040418eb1e147598294e41f:task:(.*)$'::text))::integer ELSE NULL::integer END = task9.id)
  • Buffers: shared hit=5,292
195. 1.398 1.398 ↑ 1.0 1 1,398

Index Scan using project_pkey on "4248ad1e6040418eb1e147598294e41f".project pj (cost=0.29..0.42 rows=1 width=39) (actual time=0.001..0.001 rows=1 loops=1,398)

  • Output: pj.id, pj.clientbillingallocationmethod, pj.timeentrycappercent, pj.info1, pj.info2, pj.info3, pj.info4, pj.info5, pj.info6, pj.info7, pj.info8, pj.info9, pj.info10, pj.info11, pj.info12, pj.info13, pj.info14, pj.info15, pj.info16, pj.info17, pj.info18, pj.info19, pj.info20, pj.name, pj.slug, pj.code, pj.clientid, pj.projectleaderapproverid, pj.isprojectleaderapprovalrequired, pj.startdate, pj.enddate, pj.programid, pj.billingtype, pj.fixedbidamount, pj.fixedbidcurrencyid, pj.fixedbidfrequency, pj.costtype, pj.description, pj.percentcomplete, pj.istimeentryallowed, pj.estimatedhours, pj.estimatedexpenses, pj.estimatedexpensescurrencyid, pj.estimatedcost, pj.estimatedcostcurrencyid, pj.timeandexpenseentrytype, pj.estimationmode, pj.projectstatuslabelid, pj.billingratefrequencyid, pj.billingratefrequencyduration, pj.defaultbillingcurrencyid, pj.billingcontractid, pj.guidid, pj.totalestimatedcontractamount, pj.totalestimatedcontractcurrencyid, pj.budgetedhours, pj.budgetedcost, pj.budgetedcostcurrencyid, pj.uniquename, pj.uniquecode, pj.uri
  • Index Cond: (pj.id = COALESCE(project7.id, task9.projectid))
  • Buffers: shared hit=4,194
196. 0.295 1.098 ↓ 5.8 1,584 1

Sort (cost=259.21..259.90 rows=275 width=16) (actual time=0.952..1.098 rows=1,584 loops=1)

  • Output: login.loginname, login.userid, userlocation11.userid
  • Sort Key: login.userid
  • Sort Method: quicksort Memory: 41kB
  • Buffers: shared hit=860
197. 0.237 0.803 ↑ 1.0 274 1

Nested Loop (cost=68.57..248.07 rows=275 width=16) (actual time=0.272..0.803 rows=274 loops=1)

  • Output: login.loginname, login.userid, userlocation11.userid
  • Inner Unique: true
  • Buffers: shared hit=856
198. 0.095 0.292 ↑ 1.0 274 1

HashAggregate (cost=68.29..71.04 rows=275 width=4) (actual time=0.257..0.292 rows=274 loops=1)

  • Output: userlocation11.userid
  • Group Key: userlocation11.userid
  • Buffers: shared hit=34
199. 0.197 0.197 ↑ 1.0 274 1

Index Scan using ixullocationid on "4248ad1e6040418eb1e147598294e41f".userlocation userlocation11 (cost=0.28..67.60 rows=275 width=4) (actual time=0.019..0.197 rows=274 loops=1)

  • Output: userlocation11.id, userlocation11.userid, userlocation11.locationid, userlocation11.startdate, userlocation11.enddate
  • Index Cond: (userlocation11.locationid = ANY ('{8e2ef5b3-c1c5-46ab-9798-992d26cbbd51,1df0b5ec-dd0f-4865-8f43-b73369a6f9cc,fc55149c-3b4b-4e1c-875c-ba24e1638adc,c767d0f2-832f-42e4-a6da-956b4b6fe88e,46dcc8c3-f1a1-49a9-901b-9980950217bc}'::uuid[]))
  • Filter: ((userlocation11.startdate <= '2020-10-14'::date) AND (userlocation11.enddate >= '2020-10-14'::date))
  • Buffers: shared hit=34
200. 0.274 0.274 ↑ 1.0 1 274

Index Scan using login_pkey on "4248ad1e6040418eb1e147598294e41f".login (cost=0.28..0.66 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=274)

  • Output: login.userid, login.loginname, login.password, login.accountexpiry, login.passwordlastchanged, login.forcepasswordchange, login.disablepasswordchange, login.info1, login.info2, login.info3, login.info4, login.info5, login.passwordentropybits, login.ssoname, login.invalidloginattempts, login.lastinvalidloginattemptutc
  • Index Cond: (login.userid = userlocation11.userid)
  • Buffers: shared hit=822
201. 67.469 128.404 ↑ 1.0 256,984 1

Hash (cost=18,436.84..18,436.84 rows=256,984 width=32) (actual time=128.404..128.404 rows=256,984 loops=1)

  • Output: tk.name, tk.id, tk.estimatedcostcurrencyid
  • Buckets: 262,144 Batches: 1 Memory Usage: 18,575kB
  • Buffers: shared hit=15,867
202. 60.935 60.935 ↑ 1.0 256,984 1

Seq Scan on "4248ad1e6040418eb1e147598294e41f".task tk (cost=0.00..18,436.84 rows=256,984 width=32) (actual time=0.077..60.935 rows=256,984 loops=1)

  • Output: tk.name, tk.id, tk.estimatedcostcurrencyid
  • Buffers: shared hit=15,867
203. 0.010 0.071 ↑ 1.0 9 1

Hash (cost=2.40..2.40 rows=9 width=4) (actual time=0.071..0.071 rows=9 loops=1)

  • Output: exchangerate.fixedcurrencyid
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
204. 0.061 0.061 ↑ 1.0 9 1

Index Scan using uix3er_currencyideffectivedate on "4248ad1e6040418eb1e147598294e41f".exchangerate (cost=0.15..2.40 rows=9 width=4) (actual time=0.055..0.061 rows=9 loops=1)

  • Output: exchangerate.fixedcurrencyid
  • Index Cond: ((exchangerate.variablecurrencyid = $0) AND (('now'::cstring)::date >= exchangerate.effectivedate))
  • Filter: (('now'::cstring)::date <= exchangerate.enddate)
  • Buffers: shared hit=3
205. 0.003 0.007 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=39) (actual time=0.007..0.007 rows=4 loops=1)

  • Output: billingrate5.name, billingrate5.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
206. 0.004 0.004 ↑ 1.0 4 1

Seq Scan on "4248ad1e6040418eb1e147598294e41f".billingrate billingrate5 (cost=0.00..1.04 rows=4 width=39) (actual time=0.003..0.004 rows=4 loops=1)

  • Output: billingrate5.name, billingrate5.id
  • Buffers: shared hit=1
Planning time : 46.389 ms
Execution time : 729,344.003 ms