explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jz5O

Settings
# exclusive inclusive rows x rows loops node
1. 7.945 41,382.463 ↑ 138.9 1,398 1

Sort (cost=3,206,817.48..3,207,302.76 rows=194,114 width=1,971) (actual time=41,382.383..41,382.463 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=4,566,306
2.          

Initplan (for Sort)

3. 0.005 0.005 ↑ 1.0 1 1

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

  • Output: systeminformation.basecurrencyid
  • Buffers: shared hit=1
4. 1.266 41,374.513 ↑ 138.9 1,398 1

Hash Join (cost=1,109,564.41..3,094,982.91 rows=194,114 width=1,971) (actual time=683.891..41,374.513 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".userid = userlocation12.userid)
  • Buffers: shared hit=4,566,291
5. 922.838 41,367.838 ↑ 277.7 1,398 1

Hash Left Join (cost=1,109,043.05..3,091,282.93 rows=388,228 width=161) (actual time=678.457..41,367.838 rows=1,398 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, pj.name, pj.id, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id, login.loginname, login.userid, tk.name, tk.id, billingrate5.name
  • Hash Cond: ("*SELECT* 1".userid = ts.userid)
  • Join Filter: (("*SELECT* 1".entrydate >= ts.startdate) AND ("*SELECT* 1".entrydate <= ts.enddate))
  • Rows Removed by Join Filter: 8,232,021
  • Filter: (hashed SubPlan 7)
  • Rows Removed by Filter: 199,907
  • Buffers: shared hit=4,563,076
6. 59.494 40,027.740 ↑ 1.4 201,305 1

Hash Left Join (cost=46,960.35..1,870,701.55 rows=275,862 width=161) (actual time=238.664..40,027.740 rows=201,305 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, pj.name, pj.id, ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id, login.loginname, login.userid, tk.name, tk.id, billingrate5.name
  • Inner Unique: true
  • Hash Cond: ("*SELECT* 1".billingrateid = billingrate5.id)
  • Buffers: shared hit=4,424,993
7. 57.749 39,968.237 ↑ 1.4 201,305 1

Hash Left Join (cost=46,959.26..1,869,960.98 rows=275,862 width=154) (actual time=238.644..39,968.237 rows=201,305 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, login.userid, tk.name, tk.id
  • Hash Cond: (tk.estimatedcostcurrencyid = exchangerate.fixedcurrencyid)
  • Buffers: shared hit=4,424,992
8. 121.573 39,910.436 ↑ 1.4 201,305 1

Hash Left Join (cost=46,956.76..1,863,421.46 rows=275,862 width=158) (actual time=238.575..39,910.436 rows=201,305 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, login.userid, tk.name, tk.id, tk.estimatedcostcurrencyid
  • Inner Unique: true
  • Hash Cond: (task9.id = tk.id)
  • Buffers: shared hit=4,424,989
9. 77.279 39,669.435 ↑ 1.4 201,305 1

Hash Join (cost=25,307.61..1,841,048.17 rows=275,862 width=130) (actual time=118.258..39,669.435 rows=201,305 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, login.userid
  • Inner Unique: true
  • Hash Cond: ("*SELECT* 1".userid = login.userid)
  • Buffers: shared hit=4,409,122
10. 82.674 39,590.074 ↑ 1.4 201,305 1

Hash Join (cost=25,064.22..1,840,075.01 rows=277,852 width=118) (actual time=116.143..39,590.074 rows=201,305 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
  • Hash Cond: ("*SELECT* 1".userid = ui.id)
  • Buffers: shared hit=4,409,047
11. 94.451 39,503.254 ↑ 1.4 201,305 1

Hash Left Join (cost=24,628.62..1,838,909.63 rows=277,852 width=83) (actual time=111.959..39,503.254 rows=201,305 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".billingrateid, task9.id, pj.name, pj.id
  • Inner Unique: true
  • Hash Cond: (COALESCE(project7.id, task9.projectid) = pj.id)
  • Buffers: shared hit=4,408,781
12. 31,320.814 39,402.242 ↑ 1.4 201,305 1

Hash Left Join (cost=23,067.79..1,836,619.18 rows=277,852 width=52) (actual time=105.331..39,402.242 rows=201,305 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".billingrateid, project7.id, task9.id, task9.projectid
  • Inner Unique: true
  • Hash 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=4,407,487
13. 109.384 7,981.984 ↑ 1.4 201,305 1

Nested Loop Left Join (cost=1,418.65..1,814,067.01 rows=277,852 width=102) (actual time=4.509..7,981.984 rows=201,305 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".billingrateid, project7.id, timeentrymetadata8.uri
  • Buffers: shared hit=4,391,620
14. 3,603.133 7,067.380 ↑ 1.1 201,305 1

Hash Left Join (cost=1,418.09..1,334,660.46 rows=212,933 width=60) (actual time=4.492..7,067.380 rows=201,305 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".billingrateid, project7.id
  • Inner Unique: true
  • Hash Cond: (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 = project7.id)
  • Buffers: shared hit=3,394,814
15. 165.051 3,461.065 ↑ 1.1 201,305 1

Nested Loop Left Join (cost=1,002.68..1,333,552.72 rows=212,933 width=114) (actual time=1.242..3,461.065 rows=201,305 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".billingrateid, timeentrymetadata6.uri
  • Buffers: shared hit=3,394,716
16. 50.231 2,490.794 ↑ 1.0 201,305 1

Nested Loop Left Join (cost=1,002.12..877,734.54 rows=202,456 width=56) (actual time=1.230..2,490.794 rows=201,305 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=2,568,997
17. 27.091 830.123 ↑ 1.0 201,305 1

Append (cost=1,001.56..420,222.66 rows=202,758 width=64) (actual time=1.218..830.123 rows=201,305 loops=1)

  • Buffers: shared hit=1,763,777
18. 34.227 803.014 ↑ 1.0 201,305 1

Subquery Scan on *SELECT* 1 (cost=1,001.56..420,204.29 rows=202,754 width=64) (actual time=1.218..803.014 rows=201,305 loops=1)

  • Output: "*SELECT* 1".entrydate, "*SELECT* 1".duration, "*SELECT* 1".userid, "*SELECT* 1".timeentryid, "*SELECT* 1".billingrateid, "*SELECT* 1".timeoffentryid, "*SELECT* 1".timeallocationtype
  • Buffers: shared hit=1,763,776
19. 77.004 768.787 ↑ 1.0 201,305 1

Nested Loop (cost=1,001.56..418,176.75 rows=202,754 width=140) (actual time=1.217..768.787 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
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.002..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. 41.896 691.780 ↑ 1.0 201,305 1

Nested Loop (cost=1,001.56..409,558.69 rows=202,754 width=151) (actual time=1.212..691.780 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
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.003..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 649.880 ↑ 1.0 201,305 1

Gather (cost=1,001.56..407,530.14 rows=202,754 width=118) (actual time=1.208..649.880 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
24. 56.783 876.336 ↑ 1.3 67,102 3 / 3

Nested Loop Left Join (cost=1.56..386,254.74 rows=84,481 width=118) (actual time=0.067..876.336 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
  • Worker 0: actual time=0.064..2615.807 rows=200,234 loops=1
  • Buffers: shared hit=1,754,336
  • Worker 1: actual time=0.070..11.495 rows=944 loops=1
  • Buffers: shared hit=8,302
25. 34.270 551.146 ↑ 1.3 67,102 3 / 3

Nested Loop Left Join (cost=0.99..196,049.90 rows=84,481 width=118) (actual time=0.058..551.146 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
  • Worker 0: actual time=0.059..1645.340 rows=200,234 loops=1
  • Buffers: shared hit=953,400
  • Worker 1: actual time=0.062..7.029 rows=944 loops=1
  • Buffers: shared hit=4,526
26. 47.164 47.164 ↑ 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.032..47.164 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
  • Worker 0: actual time=0.038..140.811 rows=200,234 loops=1
  • Buffers: shared hit=1,104
  • Worker 1: actual time=0.035..0.567 rows=944 loops=1
  • Buffers: shared hit=15
27. 469.712 469.712 ↑ 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.007..0.007 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.007..0.007 rows=1 loops=200,234
  • Buffers: shared hit=952,296
  • Worker 1: actual time=0.006..0.006 rows=1 loops=944
  • Buffers: shared hit=4,511
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=200,234
  • Buffers: shared hit=800,936
  • Worker 1: actual time=0.004..0.004 rows=0 loops=944
  • Buffers: shared hit=3,776
29. 0.001 0.018 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=0.29..18.37 rows=4 width=64) (actual time=0.018..0.018 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
  • Buffers: shared hit=1
30. 0.001 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.29..18.33 rows=4 width=140) (actual time=0.017..0.017 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
31. 0.016 0.016 ↓ 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.016..0.016 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
32. 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)
33. 1,610.440 1,610.440 ↓ 0.0 0 201,305

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

  • 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=805,220
34. 805.220 805.220 ↓ 0.0 0 201,305

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

  • 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=825,719
35. 1.519 3.182 ↑ 1.0 11,859 1

Hash (cost=267.17..267.17 rows=11,859 width=4) (actual time=3.182..3.182 rows=11,859 loops=1)

  • Output: project7.id
  • Buckets: 16,384 Batches: 1 Memory Usage: 545kB
  • Buffers: shared hit=98
36. 1.663 1.663 ↑ 1.0 11,859 1

Index Only Scan using project_pkey on "4248ad1e6040418eb1e147598294e41f".project project7 (cost=0.29..267.17 rows=11,859 width=4) (actual time=0.141..1.663 rows=11,859 loops=1)

  • Output: project7.id
  • Heap Fetches: 0
  • Buffers: shared hit=98
37. 805.220 805.220 ↑ 1.0 1 201,305

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

  • 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=996,806
38. 48.607 99.444 ↑ 1.0 256,984 1

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

  • Output: task9.id, task9.projectid
  • Buckets: 262,144 Batches: 1 Memory Usage: 12,087kB
  • Buffers: shared hit=15,867
39. 50.837 50.837 ↑ 1.0 256,984 1

Seq Scan on "4248ad1e6040418eb1e147598294e41f".task task9 (cost=0.00..18,436.84 rows=256,984 width=8) (actual time=0.068..50.837 rows=256,984 loops=1)

  • Output: task9.id, task9.projectid
  • Buffers: shared hit=15,867
40. 2.305 6.561 ↑ 1.0 11,859 1

Hash (cost=1,412.59..1,412.59 rows=11,859 width=39) (actual time=6.561..6.561 rows=11,859 loops=1)

  • Output: pj.name, pj.id
  • Buckets: 16,384 Batches: 1 Memory Usage: 972kB
  • Buffers: shared hit=1,294
41. 4.256 4.256 ↑ 1.0 11,859 1

Seq Scan on "4248ad1e6040418eb1e147598294e41f".project pj (cost=0.00..1,412.59 rows=11,859 width=39) (actual time=0.022..4.256 rows=11,859 loops=1)

  • Output: pj.name, pj.id
  • Buffers: shared hit=1,294
42. 1.618 4.146 ↑ 1.0 7,418 1

Hash (cost=341.38..341.38 rows=7,538 width=35) (actual time=4.146..4.146 rows=7,418 loops=1)

  • Output: ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 561kB
  • Buffers: shared hit=266
43. 2.528 2.528 ↑ 1.0 7,418 1

Seq Scan on "4248ad1e6040418eb1e147598294e41f".userinfo ui (cost=0.00..341.38 rows=7,538 width=35) (actual time=0.005..2.528 rows=7,418 loops=1)

  • Output: ui.lastname, ui.firstname, ui.duplicatename, ui.displayname, ui.id
  • Buffers: shared hit=266
44. 1.186 2.082 ↑ 1.0 7,418 1

Hash (cost=149.84..149.84 rows=7,484 width=12) (actual time=2.082..2.082 rows=7,418 loops=1)

  • Output: login.loginname, login.userid
  • Buckets: 8,192 Batches: 1 Memory Usage: 397kB
  • Buffers: shared hit=75
45. 0.896 0.896 ↑ 1.0 7,418 1

Seq Scan on "4248ad1e6040418eb1e147598294e41f".login (cost=0.00..149.84 rows=7,484 width=12) (actual time=0.006..0.896 rows=7,418 loops=1)

  • Output: login.loginname, login.userid
  • Buffers: shared hit=75
46. 61.435 119.428 ↑ 1.0 256,984 1

Hash (cost=18,436.84..18,436.84 rows=256,984 width=32) (actual time=119.427..119.428 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
47. 57.993 57.993 ↑ 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.067..57.993 rows=256,984 loops=1)

  • Output: tk.name, tk.id, tk.estimatedcostcurrencyid
  • Buffers: shared hit=15,867
48. 0.003 0.052 ↑ 1.0 9 1

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

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

Index Scan using uix3er_currencyideffectivedate on "4248ad1e6040418eb1e147598294e41f".exchangerate (cost=0.15..2.40 rows=9 width=4) (actual time=0.043..0.049 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
50. 0.006 0.009 ↑ 1.0 4 1

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

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

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

  • Output: billingrate5.name, billingrate5.id
  • Buffers: shared hit=1
52. 36.560 249.550 ↓ 1.0 182,261 1

Hash (cost=12,320.30..12,320.30 rows=180,287 width=28) (actual time=249.549..249.550 rows=182,261 loops=1)

  • Output: ts.id, ts.userid, ts.startdate, ts.enddate
  • Buckets: 262,144 Batches: 1 Memory Usage: 12,728kB
  • Buffers: shared hit=5,307
53. 80.965 212.990 ↓ 1.0 182,261 1

Hash Join (cost=6,071.74..12,320.30 rows=180,287 width=28) (actual time=64.324..212.990 rows=182,261 loops=1)

  • Output: ts.id, ts.userid, ts.startdate, ts.enddate
  • Inner Unique: true
  • Hash Cond: (tslist.timesheetid = ts.id)
  • Buffers: shared hit=5,307
54. 68.675 68.675 ↓ 1.0 182,261 1

Index Only Scan using dm_timesheetlist_facts_pkey on "4248ad1e6040418eb1e147598294e41f".dm_timesheetlist_facts tslist (cost=0.42..5,775.73 rows=180,287 width=16) (actual time=0.074..68.675 rows=182,261 loops=1)

  • Output: tslist.timesheetid
  • Heap Fetches: 69,127
  • Buffers: shared hit=3,313
55. 38.030 63.350 ↓ 1.0 182,261 1

Hash (cost=3,806.14..3,806.14 rows=181,214 width=28) (actual time=63.349..63.350 rows=182,261 loops=1)

  • Output: ts.id, ts.userid, ts.startdate, ts.enddate
  • Buckets: 262,144 Batches: 1 Memory Usage: 12,728kB
  • Buffers: shared hit=1,994
56. 25.320 25.320 ↓ 1.0 182,261 1

Seq Scan on "4248ad1e6040418eb1e147598294e41f".timesheet ts (cost=0.00..3,806.14 rows=181,214 width=28) (actual time=0.005..25.320 rows=182,261 loops=1)

  • Output: ts.id, ts.userid, ts.startdate, ts.enddate
  • Buffers: shared hit=1,994
57.          

SubPlan (for Hash Left Join)

58. 68.639 167.710 ↑ 32.0 4,950 1

Merge Left Join (cost=7.20..1,047,112.41 rows=158,557 width=16) (actual time=8.484..167.710 rows=4,950 loops=1)

  • Output: timesheet13.id
  • Merge Cond: (timesheet13.userid = userlocation14.userid)
  • Join Filter: ((userlocation14.startdate <= timesheet13.enddate) AND (userlocation14.enddate >= timesheet13.startdate))
  • Rows Removed by Join Filter: 1,017
  • Filter: ((hashed SubPlan 2) OR (timesheet13.userid = 4,397) OR (((alternatives: SubPlan 3 or hashed SubPlan 4) OR (alternatives: SubPlan 5 or hashed SubPlan 6)) AND (timesheet13.userid <> 4397)))
  • Rows Removed by Filter: 177,311
  • Buffers: shared hit=132,776
59. 86.479 86.479 ↓ 1.0 182,261 1

Index Scan using uix2tsuseridstartdate on "4248ad1e6040418eb1e147598294e41f".timesheet timesheet13 (cost=0.42..5,226.63 rows=181,214 width=28) (actual time=0.039..86.479 rows=182,261 loops=1)

  • Output: timesheet13.id, timesheet13.userid, timesheet13.startdate, timesheet13.enddate, timesheet13.approvalstatus, timesheet13.duedate, timesheet13.autosubmitdatetimeutc, timesheet13.lastautosubmitattemptdatetimeutc, timesheet13.createdonutc
  • Buffers: shared hit=129,681
60. 10.003 12.481 ↓ 30.3 133,804 1

Materialize (cost=0.28..160.62 rows=4,419 width=28) (actual time=0.065..12.481 rows=133,804 loops=1)

  • Output: userlocation14.userid, userlocation14.locationid, userlocation14.startdate, userlocation14.enddate
  • Buffers: shared hit=3,071
61. 2.478 2.478 ↑ 1.0 4,395 1

Index Only Scan using ix4ul_userlocationstartend on "4248ad1e6040418eb1e147598294e41f".userlocation userlocation14 (cost=0.28..149.57 rows=4,419 width=28) (actual time=0.060..2.478 rows=4,395 loops=1)

  • Output: userlocation14.userid, userlocation14.locationid, userlocation14.startdate, userlocation14.enddate
  • Heap Fetches: 4,407
  • Buffers: shared hit=3,071
62.          

SubPlan (for Merge Left Join)

63. 0.063 0.063 ↑ 1.0 5 1

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

  • Output: locationflathierarchy15.childid
  • Index Cond: (locationflathierarchy15.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=12
64. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2.72..5.76 rows=1 width=0) (never executed)

  • Inner Unique: true
  • Hash Cond: (timesheetapprovalnodes17.id = tsapprovalrequest16.nodeid)
65. 0.000 0.000 ↓ 0.0 0

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

  • Output: timesheetapprovalnodes17.id, timesheetapprovalnodes17.isapproved, timesheetapprovalnodes17.approverrole, timesheetapprovalnodes17.userid, timesheetapprovalnodes17.timesheetid, timesheetapprovalnodes17.systemprocessidentifier, timesheetapprovalnodes17.scriptid, timesheetapprovalnodes17.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes17.timesheetid = timesheet13.id)
66. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.37..2.37 rows=5 width=16) (never executed)

  • Output: tsapprovalrequest16.nodeid
67. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix2tsar_nodeid_userid on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequest tsapprovalrequest16 (cost=0.28..2.37 rows=5 width=16) (never executed)

  • Output: tsapprovalrequest16.nodeid
  • Index Cond: (tsapprovalrequest16.userid = 4,397)
  • Heap Fetches: 0
68. 0.001 0.018 ↓ 0.0 0 1

Nested Loop (cost=0.57..13.88 rows=5 width=16) (actual time=0.017..0.018 rows=0 loops=1)

  • Output: timesheetapprovalnodes17_1.timesheetid
  • Inner Unique: true
  • Buffers: shared hit=2
69. 0.017 0.017 ↓ 0.0 0 1

Index Only Scan using uix2tsar_nodeid_userid on "4248ad1e6040418eb1e147598294e41f".tsapprovalrequest tsapprovalrequest16_1 (cost=0.28..2.37 rows=5 width=16) (actual time=0.017..0.017 rows=0 loops=1)

  • Output: tsapprovalrequest16_1.userid, tsapprovalrequest16_1.nodeid
  • Index Cond: (tsapprovalrequest16_1.userid = 4,397)
  • Heap Fetches: 0
  • Buffers: shared hit=2
70. 0.000 0.000 ↓ 0.0 0

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

  • Output: timesheetapprovalnodes17_1.id, timesheetapprovalnodes17_1.isapproved, timesheetapprovalnodes17_1.approverrole, timesheetapprovalnodes17_1.userid, timesheetapprovalnodes17_1.timesheetid, timesheetapprovalnodes17_1.systemprocessidentifier, timesheetapprovalnodes17_1.scriptid, timesheetapprovalnodes17_1.agentresolutionstate
  • Index Cond: (timesheetapprovalnodes17_1.id = tsapprovalrequest16_1.nodeid)
71. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (timesheetapprovalhistory18.timesheetid = timesheet13.id)
  • Filter: (timesheetapprovalhistory18.userid = 4,397)
72. 0.030 0.030 ↑ 2.0 8 1

Index Scan using ixtahuserid on "4248ad1e6040418eb1e147598294e41f".timesheetapprovalhistory timesheetapprovalhistory18_1 (cost=0.42..14.82 rows=16 width=16) (actual time=0.021..0.030 rows=8 loops=1)

  • Output: timesheetapprovalhistory18_1.timesheetid
  • Index Cond: (timesheetapprovalhistory18_1.userid = 4,397)
  • Buffers: shared hit=10
73. 0.596 5.409 ↓ 1.4 4,401 1

Hash (cost=481.87..481.87 rows=3,159 width=4) (actual time=5.409..5.409 rows=4,401 loops=1)

  • Output: userlocation12.userid
  • Buckets: 8,192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 219kB
  • Buffers: shared hit=3,215
74. 1.558 4.813 ↓ 1.4 4,401 1

HashAggregate (cost=450.28..481.87 rows=3,159 width=4) (actual time=4.257..4.813 rows=4,401 loops=1)

  • Output: userlocation12.userid
  • Group Key: userlocation12.userid
  • Buffers: shared hit=3,215
75. 3.255 3.255 ↓ 1.4 4,401 1

Index Scan using ixullocationid on "4248ad1e6040418eb1e147598294e41f".userlocation userlocation12 (cost=0.28..442.36 rows=3,169 width=4) (actual time=0.222..3.255 rows=4,401 loops=1)

  • Output: userlocation12.userid
  • Index Cond: (userlocation12.locationid = ANY ('{9dffe67c-721a-40ee-8163-a0fba053f2ea,d24578bf-f86f-478e-b3b7-088cca936de3,5f82802d-5e65-4fd6-bfbe-3a7287b01616,81ee98b1-f9ea-423f-8d5b-efc9870e232e,7f8e114f-b2bc-4c9b-bab9-dd25c7c94a83,b4e0e63b-ee61-4286-82cc-58b3ddd506cc,da42657a-57aa-4399-8426-0c7e9cfa4bfa,63243fc7-4216-4c73-a3dd-8543d63a2dfa,0ef53cfb-7123-48d2-9a6b-b36052b19bf9,3887c350-0d2d-4047-ad2b-0d2d41111ec6,f2c804ae-8abb-421b-9fb9-e07d25f8c9aa,b27c7036-a081-40fd-9b55-701cbdd3ca9d,79c2d39a-ca20-4369-8e17-d6b132b174a0,9c481037-5194-4e72-bb72-ff795ad9ab6d,33cef90a-e64e-49fa-8c63-4fa88eb7a853,10525a02-8516-41e1-b71a-b7e36f691111,91aa63e3-83e9-48ed-b0e5-5449d57acf68,df662fb0-f7d5-4db1-82bc-c5e455d89be9,97a9311c-8ff0-44a3-93ff-17b3cdd87598,95f0ff22-6b60-478e-8bd2-72d942767e38,8e47a281-092c-41c7-9a92-96980592a43c,0017c906-ac2b-4d3d-9981-aa5879b226c0,9dd231ea-6039-4a2b-8fbc-2b87f8e86886,3166fa86-50e8-4817-929a-d5e9d1a00bca,3c9111e0-7286-47d3-8023-17f6686870d0,ccc987d0-f9c7-409f-9f21-4c18f1f39890,3ac1b7a7-3935-4f1e-9f6c-1fd4f5f66704,1efca8db-f635-4896-a4ce-a34d7df60bc1,c11b2e52-299a-44f5-9d2f-9c64302fd17a,ca1dc239-18c1-4b1a-92a8-4b08be0739fe,532e83ab-4cce-41d6-8bcd-1f97df73b863,e14af9b2-4f07-4f1e-9b5d-f6c3d752a3a4,b5513ad7-9cfb-4d7e-bd7c-6e1a3c852c0d,bc0cdf8e-2ddd-45d4-82eb-2091587e454a,fef98019-fe19-4c4c-8d11-9be9ca230a73,36dacc9f-0e55-47c0-a6c9-7759d27e6e2e,bbfe7864-977b-4f12-a2f5-f3122a04eeef,b42b6c32-47df-4d86-8dde-9c06dca9ec3b,49bcfb1a-c8f0-4553-9665-eb83928dc7e5,78d72d17-ab7f-46d2-8ae8-9a72d70329d7,8b3b8e5f-ad5a-45e5-a6b5-ac39efad1e9c,ec986c4b-1f22-4cb7-b83d-c7b7b97b2506,705f8758-632f-4e28-84bc-b4c3d9ca0ecf,13aa1ba5-d9e0-4965-bd2d-dbb02c5580ac,3245e563-980d-4489-ba09-e3387cdd5ece,60a5ad45-4505-4c71-85a1-6586beb024ae,f1e0fd72-879b-46b2-8318-21496e653d34,ce8bcf10-645c-4d8f-a526-87e2b40410fa,133130c8-c738-407f-9704-b15a64ad0674,4cfb3002-2f33-4ccc-af25-cb205028b890,51e11012-e198-4410-912a-b51adf9bf548,bb10d895-1075-4e4d-a444-3fe1a8ab0609,5b9387df-b838-46c2-9e19-889707e64a6a,39765908-59e8-4f13-a1b1-4d8612de49ab,71241ce2-14a0-42c1-b092-caed3b2bc251,49f610ad-cc4e-4553-8c30-dee65e59a5fa,2c6eaf8d-483b-4d1a-92ac-ee7aee169daa,ef359bdf-53f6-4ffc-babc-f096d0a8e4dc,e0efea88-9ff6-4ab9-9f6a-ebdd3fe2349f,a9b7af3a-65ab-4551-9024-57ef735f7037,5a3a5391-8e0b-4f17-adc0-286f3cd91f0b,dba8fd30-9c68-4411-bb83-cb44aa2a69a3,a3de93a2-7328-4cf9-9bd0-24e1cd89a95a,277f1f0d-6a10-476c-8f81-7d36554e3ddb,db8a15f8-9e4e-4583-b568-744ad665cf01,837ef20b-f3ef-4c38-b339-154ae27ef1b1,de079906-e0f5-44cd-9954-003698f1eb0a,7dfd68d1-e89d-4308-afcb-791d9b488f29,e2e6bb12-8c5a-4711-aa41-ada0b31e82f9,bfbce9eb-30c3-4b94-bfa3-4f57aa7d2ec4,a4a1a3f8-ce25-492f-810e-d9862d1eeb38,126c7360-c505-4520-8c7a-ce3761e26f24,de59e9d2-494e-4014-b0c6-fa5cfa1df63f,6f575bf5-9a22-44e0-8e4c-7c253e034e2d,78aef5da-27b9-4de5-b4a9-51bada18b9f9,a1a99d47-666f-483b-a531-f1b44279c9ef,c4876b03-e70f-47c0-8eb4-ffd883f268d4,0dd2dccd-cf83-43fe-ae3b-e08a3438520c,26e3a95c-1d44-4912-989b-2e570ad9bd25,0240eae6-cafd-405f-9ad3-36744cba0e03,7c96cbc7-b2ab-4edd-b2c9-772511328ed2,285acfdf-0ed3-4fc9-9120-18d05b7f2386,45f97f82-efd7-4d8f-bcc0-8c5a1abfac2e,594a609a-0411-468f-bd83-749aeab2399d,9948125d-42df-46d5-ba45-f4aa04f28ff9,bdf09535-8f74-4be5-bed0-a6c9a09c8bde,b5547261-65ec-4124-bb3e-584ea5f47571,44014df9-2fcb-41aa-9bec-821734abe8d3,9e846e74-2537-4709-97fe-54a3347a6008,3f623f24-7af1-4ce6-a04f-ffdd01e2d9a6,10b02543-75d4-45f5-804b-7e133ced34d0,eba1ae04-5298-4a79-b0cf-3136118361c6,5a8444f4-5d84-479f-b825-9bff25c0cb03,9aa9b44c-23a4-4d14-b4f8-b2c34affbd85,98ece4f5-d416-4311-92ba-a6aead6f1e2e,27fb082a-f3dc-4d34-bed2-c74bcdc68ec1,695bed21-d4cb-4ea1-92e2-f44812c2940f,ed08d08d-c60d-41df-a172-a132005851fa,278e8a76-41d1-475f-90ca-f6d994ee4873,43d3f1ae-2aa3-496f-979d-0557b0a5779b,bd4d6875-87c4-4b7c-946a-1afdfd78a606,f33cedaa-dc76-488e-b80d-aa23a25ea6e9,b077c79b-f683-4d26-978f-e5fc4eca0089,e6545883-b4cd-4806-8cd1-a4b8f0aa6a80,847d6aab-fcbb-456d-acc7-a0ca0c0de45f,a5511bb1-1f59-478c-b6d9-40944d463002,d79f1cde-de22-4dde-b553-4b47f2f5f8b7,d39ebcb7-1268-4e6a-a971-97a23de23a2e,b5c6cae1-5843-400f-af32-07c627641a2d,844b0b40-15da-4345-b622-08f132e49e1c,30dc9a00-efb7-4e81-a845-9a8b83ce24d4,66e86455-a69d-4681-a2b1-ba93ab313f09,e9ccda8d-6a56-401d-9e4f-bb29b8362d33,5680bd74-cdeb-4c1b-8609-1e937493c838,af532eb2-e21f-4b8c-b78b-2e0ad3667743,67838ed7-4f6d-4b14-a0da-4bd5b1be9dbc,3a71c07c-ee37-4b4a-965e-12af7a3b4d3a,b50f3c6f-0e5b-48f4-9335-ca901aba3852,d801c371-ab66-4b18-afb4-9b5ff6d3ea4a,ca764a21-03d0-42bb-842b-8f2b080179d2,52ce4e58-e69d-4483-a4af-023523be0cae,1eb82287-1cbe-49d5-84fc-9cb26f744814,f9d85ca0-923b-42b2-85ec-45c468a8e18a,580a2b1a-73c2-44d5-85aa-f8b6cef28221,7c5b9339-b401-4e42-bf20-b926ed078ac7,6baf1d98-782c-435c-ba21-3650e14a7072,6122bb40-feee-4fca-9265-ed9961577a81,163c8fd2-6472-4954-bedf-387b5a12e311,35740f08-7398-45f6-9767-5c87204dda74,a2824d85-97fe-48ce-80e4-5575ef3c5c2d,461c2bad-bfb4-4529-99ce-5573c4c77941,9b7ccc75-eb61-4daa-83fb-386f070e6584,2b2ca653-1030-49cc-a8dd-7efb8b23af76,99a3d2c4-cb5b-46ac-b43b-65ddc9da4b0d,54908110-3745-47a0-8ca7-a023bbe54798,247d844b-645d-4d4e-a226-345d462da384,60fe8ec0-7f53-4e26-a180-3d062859670d,1e3c90b0-c4e0-41d7-8d1b-1d11a2dcb935,136e458b-9e60-4f9b-a022-65651000d1c3,0d8a43e0-90ed-4ab4-a88c-37274436deb8,9f8c272e-6e4e-4d9d-b317-6fe8fa636c49,80932ce9-647f-4faf-9398-38ec71204ede,edb61146-5157-476d-ba69-d045f65b39de,1d11955d-8ec3-4352-b734-8a1c9459955c,61381f7d-6542-4838-af06-58b28ccbddf7,eed1612a-61e5-43d3-8589-7ff8a7c42b0f,3950bc6f-7aca-41d4-83b6-8eae11e6516f,03f480a9-be2b-4670-ae7e-5d6046d4970c,eea5244f-cc6a-4c9c-85c5-f361c3d22b88,bdf2107f-80a2-4a0d-8251-ee69e48e21ab,8d5577eb-5e32-40c6-b994-e472a8a5a4b5,a9d7eb7b-8912-48b9-86bb-68f39db62934,fd77b7a4-e7f1-4fac-ab9f-f793183fc780,81bf2973-0a64-4cf7-8689-4db7c1cd6637,5ec86859-64ba-454a-ad5c-f75a9832e51f,1fdf3e52-55ca-4582-923c-dae74f30aba6,4f733306-2e06-4a1b-86b9-76114f7a7f82,382445cb-b664-49c6-9637-2eaeac27b678,5dd55798-9557-4a60-a7f2-24b1c45901fe,5e4331f6-781d-415f-ab20-6e6d0b8528be,1c8c69a4-d63b-4a9b-92b8-364a03657fd8,b596d8ab-d4cc-491a-a3b7-638fa4765228,d3568a41-a822-4e88-9c43-500078bb06ac,785a5f4f-7b4b-4fba-b6d0-5bef6acb97dc,592bf3b6-9341-4e41-8e47-28b7930f8704,5f40f66c-4850-443b-8188-440feb782384,f82903c1-1bc0-4364-a6ec-2e08e189be10,bf4822eb-5cc8-4c56-915d-e1bb04f45c7f,de6a9c56-9bdf-4470-84b7-f59edb303532,0669ba8e-f4fd-4122-b066-eabeea0d877b,02443579-0f35-4449-870b-9b66f2c350a1,84aa4cec-2e8a-4d82-bcce-27a75a27d212,68535154-1a8c-4cb4-80bb-4084489217f2,b4f79635-c634-4acc-b9c8-5137e218daad,68d060bd-ffd9-4c8d-b995-ccb6bb122a10,c33ac8bc-13ea-4638-8337-eb114719d46f,dc70a08d-254c-42f8-803c-8c598ce4efad,647d65a0-fc86-4987-ac95-420a748b0360,9c1ae9c4-aa7f-43b1-ac82-101e2d5741fc,fc5089b7-dc9f-44c4-9d48-cfa3aa3ef14c,c29c9fdd-4c9b-41fe-aea2-501f410d536e,45edc7df-5ce7-46bc-b3f3-4c13fe3ab07c,458b0ab6-a320-4f2b-998d-2decd18bac2c,66a48a80-e9d6-4bed-973a-b54300559117,22897757-a369-4f34-946c-6561b96c7e84,5af524b5-c620-47b5-a23a-dccd9f701041,231893a6-e5c6-45d0-8a49-ce487f2deccb,fbd49c6c-681e-4590-85e9-a4bfdae9cac2,cbfcbb6c-79e7-495a-844c-9761f26aed27,03885829-a090-4bd2-86c0-2f25463727bb,96dfc617-a967-45f9-96d0-c419b9b1806e,02a97bf4-ac3e-479e-9d43-5d8b7bdb4ee7,5d3931b8-671a-498b-b398-b2e65cb4b210,354f9a65-baf7-4c3b-96c3-926fa6c1a646,281d8862-74fe-49aa-8837-4dc9ec89cb4c,44410c44-c24e-4cf3-a7ec-da5b8affd9db,71d04cdb-4d10-4480-a178-03c99182c5a7,862fe838-a3df-4795-b51f-9ac32742f1d5,ad3506d9-6735-44d8-aa5d-89f4e76d9fdb,1553a3d4-eb60-49a1-b67d-1324ecce80e3,48cfa3d6-872c-440c-9c90-65fd7d4ff99e,5e82e07d-e775-4f61-8037-5cee1ffad9a6,e97d7c29-eece-4305-8daa-4df2f83546af,d8b0ff7c-0c41-4175-a8cc-c90870639541,d6450b3a-7778-41a5-aea3-4a4c93caba17,a85c0307-e143-4ab0-a356-472148a7b566,fe322b30-e039-4bf6-8f66-68e94809033b,58f6baff-ae6b-4dc8-961d-a9bfa85b98cc,266edf50-7553-423c-8da8-58e249d83970,a8b0ee50-5eb6-4f4d-b0ec-4c0a84bf7452,8d49c987-8cfd-4a67-b2d5-a7953f876b66,59b8b920-d29d-4590-891a-d73371db2160,36af1d52-98ee-421f-b023-8ba91a193f08,903de0c2-ef8b-4193-8917-d2a3bc924287,09b76610-944b-49d4-83d8-1010c9400ec1,728ecd85-50fa-4e02-88d7-45d642c51a28,7c851244-7df1-4d07-a3de-c60abdfc5cf4,b2aca3b6-fd31-4107-80d7-00715131a7fc,8a16a682-9857-406e-98b0-bfea382415e0,07aa3441-bbb9-434d-9ad1-8adc57ea8f38,064db91b-6900-4563-8b27-c8e56a88f67b,24f35a5d-feb4-4fab-8e9f-80e607f2c4ea,ede4eb92-56ac-4ce9-9732-da3266dbf8c5,940ab147-f203-450d-8b1e-c920b4d97b39,87fbe189-3815-49a0-941e-5b7ea12ea535,d75a1940-3496-43c9-b44d-022d77fdf531,74aa4c2f-858d-48b0-9791-3baf4549132d,ea4d1e58-4a56-400b-b458-37127f740781,b913aee1-e0c3-4a83-b192-601f0a223dc3,132ed9f0-671d-4f44-b6cc-409835910e6c,f0377c1d-fed9-438a-b8ec-b1c18e3086c3,1948a536-774a-4286-a153-c5ef2c466b34,04f0ff8c-b3cf-4ebe-b8f6-303adca738b8,d350cd13-422f-406e-828d-dad205fef8d0,68d31cf0-5e1d-47fb-b309-ae4b3b4a45a2,54b8738c-a6df-4b14-b1cd-d18a0a6ceee6,dcb09655-14c5-4334-a0f6-ff1067099fb2,c644f9c5-6500-42a3-82b5-88130c1cde34,5dc264ef-38d3-4170-afd9-bdaaf726ac8a,2e8d506f-30af-41e0-9d77-2be9be2bd0cd,4970ed1f-c920-4ee5-bf4d-e40c099b71d6,e2ab2128-a419-43ca-9be3-12eed28cf673,e9f34455-d440-4448-b0c3-695a6bd19942,1ae7dcc8-9ae5-48e6-8c60-e7173c632faf,7c8b766f-c4cd-4364-a5f2-c0410975fd5e,83a7d5c0-9ade-4d6d-a269-ec1ea6888766,d60c68e7-8894-42b0-9c17-2ab2daaa6370,4f809467-c4ef-499f-9dd2-3b3b00a86060,24e3d02a-00bf-439b-b526-8f7446de7bf1,c36fb084-b28a-402f-9e72-d27f7d4571bf,867000e1-9605-4ea6-8a49-4b558ff39bf5,944a1c6d-0800-4a0c-baca-99b3d7191722,54f2e232-c447-4d13-8e73-8b18505dddcf,fc37b9d0-9744-429c-9f4e-124aa9ae7d65,bb063e54-33f7-49f5-89c1-94d23117c642,a5449920-37d1-4397-b93f-ef4892bbeb57,9fac441c-152d-47a6-b2b2-327b618eea37,a3af2e72-d63f-4545-a96a-0d290b16eba6,023126d2-81e5-45b2-8e0a-d39859efe9ee,d90e88eb-dae4-46bd-96d6-1735a00cd02e,773cc12e-3dca-44e1-aef3-bbe652286c8f,1b6f43d7-c505-4371-864b-f6cc0d247e46,e2fec0a6-3aa3-4377-bed0-0a0479a512b9,ec7f302c-413e-4b16-8588-85ae5dbc576a,c50c8446-6b85-43f6-b0c7-91ada5a1ba20,c846d5fb-f831-4ca0-8591-4b9913c39fe6,32526998-540c-49ce-96ae-601cf0e0940a,c7314c41-fb74-432d-935c-6b41a32bd54d,e910ffca-d3e7-4851-894e-b00fdff84b00,88f05f62-2ddc-4240-837e-b5ffa919af88,d01ab91d-d96e-4d35-a0b0-26e701219985,361f96b5-e9c9-444e-b890-970700ff7089,b6037f60-74fd-4beb-9923-84208cf21b4e,f1c94487-f26d-49d8-9258-512a940eb9cd,6986fc69-e375-44dc-a349-2ea0ffb09984,f2b2f3b9-59db-4e74-9560-79e3b198be16,e411c539-66c6-44f1-b798-7b7b56d8481f,cb6d55fa-ea9d-4d9c-8ec8-8c1487925c40,99f366f3-d80b-4ce8-8007-09e426d30c79,8d16a70f-c7bd-4251-a0b0-7ccc0d4ebc0a,b5508275-25bf-42bf-8904-0ebdb08ca362,4190bd9f-819a-446a-9286-ad020d477c95,7df73342-fc12-4336-934d-b88adad4dc2f,4707e262-d4bb-4578-93c5-3d8e1869ffad,3d686038-f332-4b99-ae98-78e6b603cf55,aaa5781f-56ae-4ebf-bb11-d2e47dcb1775,16a717bd-5ae1-469e-a58a-9c388a6dde81,a1cdbc1f-4c5b-4b99-bf4e-b44e27d2e20c,d4d2be03-7fa7-4e3a-a10a-986648ca2d0a,ee41f4ef-8b2c-4ed3-b27d-04c788c08702,ec4a1a72-85d8-4467-80cd-6d5014ce3dd0,8ddba870-7482-44b6-8d4a-c428e9a514db,376196be-2e30-4752-acea-cb6fb95b7cd7,a0eed2a8-3407-4ae4-99f7-693cb72cf98d,0689fd74-718d-4244-b041-5358d61422d4,1bbe23c0-cae9-4fb5-816c-e88c02775340,7903a751-9ca0-4446-8f6d-fad15de58f69,9864b1b7-1fd5-4ecd-983e-c70b802639d8,b675f03f-b8ba-48cd-b36c-9e02ecb64100,97c50ac5-c1e6-4239-8095-38798c4d739c,11b74ffc-2c4d-41eb-ab0c-afa7c5ab6b96,6e72da3d-6a1f-44d7-a2aa-dfbcfbf67a29,96f2ecc2-3a3d-405e-a4cd-425bd55a9706,7c5bee45-de8d-4b31-94bf-978891a43b2b,46fbdd55-ffa5-450d-a56e-a1e296a00fe7,c8172e95-cb71-47d5-bf14-e20a8f05eb53,496b3d8e-a911-423e-8880-5ea2d9acf856,35ce94c4-b91b-4c60-837e-d382b300afbb,8ed0745f-f5f7-4668-be14-e4b730fbbe7b,8ca4ab41-d60e-40f8-82e6-932a5f7dbe15,b36ffaba-d343-47d1-a1c7-0618caff1ab6,fae7f24e-3a7e-4910-a731-36d5ce0de9d5,b9e3a792-3b71-4dac-97a0-4fd70a0f7c26,7de2c532-851e-4715-b0cf-8c71fd175bc5,09075f49-6b9d-4ed0-b847-7e95e0844ce8,330d4922-ceb1-4f78-ba91-3c165c96d303,c6f9989b-e314-428b-858f-7170c96ee3a9,87a02400-0c13-49ae-a123-5e13b256c14b,5cc4be3f-f477-4ed0-ad42-75ea4e030425,767f4ac7-f018-486d-92df-8e193de336c5,d776c767-a38d-4cf4-a555-c1f40153e4ab,48a02e72-2833-4380-b4f7-899c4e759e6a,1590202c-ce87-4822-979f-93f84ead50bf,c6529b4a-5805-4ae2-b86c-c65e6d767b6c,997d7d36-c31c-44b2-a633-11a2745e36da,ae116130-a5fb-47ad-864a-9b8c24247bd8,acf07ae2-5fc6-464f-ada2-f9f44ca624ca,b59ae634-307c-48db-8baa-1d084891d95c,ed90f31f-3e93-4de0-b565-f13bb7923273,037221e6-1dc3-4df2-80fb-51cd60ff0207,df9a905e-de13-488e-b63c-9511191f16f2,f2856a20-0e33-4a8b-8422-27dabdd4dbfd,7d825136-43d3-48da-82f2-3ffb6cbfee4b,266d0be9-76c7-4a61-bfd6-edeea670892b,7da150f9-e72d-4ee0-a582-95669144d897,d579eeb4-53c0-4698-9159-f80edd44ea56,3cb4cc81-0a28-4b95-b9de-51f263836b7c,26998887-5571-4bd1-8a83-5165d87ea0b7,70795e81-2e47-4afe-8c60-a7f2d4203882,1de6f5e4-9df1-4605-9bea-977c7528ddbc,6183f675-abc8-4391-9b79-97d43172a008,547c0e17-ba9b-49ce-ba92-4721b112fbb2,33bdd2c2-14ea-4a76-a188-a31862619c03,ffbd7c37-f568-4c3c-a054-1a7104733385,86f8a24d-0ea1-4450-9cb7-71af3b811a95,099c35bb-4ff2-4051-ab4b-2213bd8e0747,4dd86de1-f065-4e3a-8dee-ddfeef9ad7bb,78605db9-6e31-4319-a871-96b27fc76f86,14fa24b0-68fa-474e-9c55-27b6faa39717,de4c8aa0-0100-464d-91ef-59268bd46bc7,37f074e8-732f-48e5-ad86-5da9cd3ad476,5dc3de0f-bc23-4167-9ade-e8f7d6ab8ae5,da45ce2d-3b45-4cb0-9e9b-85bf3d43528d,e89a99a7-0c5b-456e-9e29-51e9b2b6dd9e,55cc2275-9cb1-49f2-8986-7d96808ded06,4c7074be-5b42-4392-8bec-1aacc9422a53,92b29ecf-e212-46b4-a929-6e90062dc857,123beae2-290f-4f43-bf98-60d257643ab5,dd83a50c-03a3-40ff-bac3-31b18489a4bc,073f4bd6-d537-49ae-bb41-28965d98a7f4,e1268ff2-29fd-413a-8566-a4cd2b01b7fa,1c9d3eed-0049-467d-b0ed-d75889e80c09,6ec61a74-fff3-4f78-8432-838a313ef8c2,bea35520-11a9-4393-b49f-3a86c987ba04,e1eeb2ab-cd3c-4c4e-b515-f7f66493a75d,387310a9-12bf-435b-9764-fc5fb9a2a449,d231c9a3-f005-4439-b656-7cbaa16c6b8a,1492f36d-a02d-43c8-8db5-972d670b1a4f,95ca902c-6103-4f50-a35f-99f3d16963eb,86c119eb-b7ec-4629-a83d-0ee03bf0362f,9293d00a-9945-4fff-bcf0-2446886c8a32,2b14888f-a50b-43f6-8306-c731b8244814,9f0fe06e-79c7-4af3-a590-52e4eee1ea4e,c71e8e7d-2a67-463f-97cb-986a54061d48,e4b79b71-0905-418e-96ba-6b318aa9278e,6fa45a0f-9e4e-422a-9895-e6106e179d1f,9d93976a-20c3-4251-8a8c-7e158c81e03f,8572b79d-4bf9-4f2f-95fe-abf87801c71c,61f83090-b0e7-4468-b52a-e90a6065e539,0ed18cf6-47a7-4315-b516-4362ff183b42,369e205b-bb1c-4a6f-9634-a8fa26b1b368,340cc19f-5527-4498-b232-d91692953cab,46f7a46c-8de3-435d-8c94-5d2d74bee732,575d36b7-4706-464e-a7f5-5f1caaa2b2ae,adcb6e9d-5980-41fc-838a-2bc3f867d6e2,c6c175f2-54a7-4f1d-a672-62cb75bd2dbd,b43565f9-6c4e-4f6b-aab5-fc82435185ab,8ce218b2-f59a-4e09-a1a1-148022474c80,7f727528-3ef1-43c5-b66d-b2e8f22aa52f,f3be7df2-1b44-48ff-aa83-b857529134b5,a91a7d4e-8d14-43fa-9f38-b72ce86f1395,ed634db5-b028-4021-8a4b-f07a6f30e4a8,443b7e40-5f74-4f4a-ae69-dd8b0dc5ca54,aab3cda8-797c-45ad-ae4a-2c3f4fe49bba,cbd40546-8952-4c6e-95ff-3cf87ea7b7e2,8f85ee5b-8aff-4858-840b-41f15919d0e5,607ce896-719b-4967-9ec6-32ad4261ba96,9cb4eaff-4697-4935-ae6c-a69d911cdb73,cc84220f-2fa8-4fc2-8219-51c95653107f,238bf91e-dd73-46e9-a052-1d83b7072ba4,7eded4b5-3678-45a9-9c11-8dc8709d1e19,2139175b-4201-4ec9-b1c3-a3020a859a51,e08e460f-3301-454b-8395-d8592ba0892a,3043a720-d39f-4087-92b2-31a7b89314a2,d63b87cb-3bf4-4144-bef8-373da9f98fed,2a946a5b-4ff5-4b4c-9dd4-453491c5c2fe,59ed19a0-c049-4e7a-a73a-d43ce2c2fed2,4b4fe21b-df3f-46da-8fda-7a460615ca0f,b051f37b-8cf8-406b-967d-df7db3c97508,b0b5a7aa-51e8-4e42-b7bf-84a884e93ac4,70f99699-63b8-4cdc-b3a6-f84ee1be077c,d11213c9-a7f2-4f32-9213-3146513f1b14,d84e2436-bf33-4ccf-ae8e-871d34f2cca7,f99e35b4-da3a-4649-8ae6-ef5278c63109,b2c76362-0381-4947-a40e-0b259557ecad,9e2e273a-4367-472a-a288-07d93ebb13ae,c469398e-6d64-4744-8adf-c05997407b9f,a4b6979a-10b6-4aed-aead-05672f8b6256,351c2a8d-e049-4c3f-8abc-eb1751295228,7d3bae93-e0bd-46ce-98d2-ab2f735fb463,2cf20c3d-eb97-4148-9d53-e5e71ea1c520,b3f55bb5-2ec3-4e19-8225-dad7b64d1119,489031cb-a3c0-4efd-b92f-e5a318161cb3,e4c6a752-38e8-4d20-b8e1-0b703757e45c,bb659bd8-f17b-4ff2-9495-2cd7254b2085,ffc2729f-49be-4f99-9b3c-6a25e7c22da3,5687fa8d-0a9e-4995-aa7d-66d64561f39a,7c198708-8622-4856-a41c-0cc2dbb482eb,19c07a8d-5225-4004-b786-fa7e2984616e,351dafcd-bf0f-4ae8-8b31-eaac47e004e0,8e2ef5b3-c1c5-46ab-9798-992d26cbbd51,1df0b5ec-dd0f-4865-8f43-b73369a6f9cc,7c0aa7a4-fb3c-4e7a-8678-2fe7c922b0e4,70c4643e-a727-417e-8db6-91140328d12c,69128881-b6b2-436e-806d-0df60c1aedfb,7b57cfa5-3800-42ce-974b-9557c65555a4,019cb61d-e389-4c46-b1bf-c724811175a3,fb979f81-deb0-4a74-9627-1ec74b8fa5a3,02be4eb5-f571-42ac-ac3d-a43e3b78427e,648a42fe-ca57-4a70-b45b-19dc0154f69e,6fd1e63e-eaaf-410b-ae3b-6ccd4a4bbae3,fff19aff-3c06-4979-9748-693fe05277bc,5baaaafa-1f26-454e-b747-05de9c246621,291aebf6-5233-46a9-bd77-c02b591cf387,9894f3f5-8d49-4b01-8ebc-1e3d4e8a08d4,e5c01c58-11cf-47d5-a6cb-711e7443e43d,38f3edbb-ba7e-4fc4-ab0d-ae414b952ae1,eeb36e0d-e017-4ec2-8449-1d4da71aa1a1,763be33f-c0b3-48de-bca0-593877b1f615,16ebb435-051e-4a76-8a62-7a46a7d4482f,d23ff17f-6a07-452e-beaf-30f50aac632d,1881f616-1a06-4678-903f-83664e308939,272ba593-5088-4345-9f06-c4b67f2d2e70,b626fe3f-5a1e-4146-ae29-8dc51ea6bc24,4e226241-8651-4d76-8637-7ba88cc202c5,1306f6e0-2489-47f8-b741-ed4362b82469,c2902fee-1896-46ac-a388-41d42dae04df,d703ec69-312e-477e-8107-5103b906995c,007e974b-dfce-4ced-a3b0-6ec90ec1bd7e,a4054a71-08a3-4af5-b2b7-02649f9b60a0,b07d2042-9e8f-493a-824d-ac2155aac922,6d09c0d5-b46e-4979-b545-bd2a413e2041,89968688-fbee-4330-b8cc-c3e49f40f8d6,e69541bd-a51d-45f0-af81-0aa898925757,22e7de88-61d0-4ccd-a712-e4529cff85b6,48ce882a-92f8-4b08-811c-d5be46188b0b,efaa5e51-c1d2-4a2c-a62e-095769854520,c8ec565e-a299-4491-aa60-411202dd3485,8a079e5f-ff7c-4491-9ecb-4e76a684605a,1bc49f7d-099c-45d6-b2b5-5fa320b5abef,2a46ca17-ac59-46fd-b4b5-4c8762b507ec,fc55149c-3b4b-4e1c-875c-ba24e1638adc,c767d0f2-832f-42e4-a6da-956b4b6fe88e,263c2bf5-ca6b-485f-8b0a-30d1458408d7,4b06cafa-25c2-4abd-9e4e-4afffb1764e3,1540104d-783c-40be-90fa-b2b833adc63b,12f62b3d-c1de-4ad4-9f06-7b8f380a12c9,c8bb750b-354a-468f-89be-748d2328cb42,1a80d31f-265f-463f-951c-1eb8d51e2df1,e44279a8-eb94-4f81-b1b7-766bd72012b0,00361fe9-d51e-4cd2-9c96-77f524193a7f,64b66906-0d94-4947-891f-36e26e9e3542,12314b8a-a5c8-4a18-b2f0-a550c6181ff6,3cb884c2-15bb-426e-8608-b37f4ceb23e9,008fea8a-d26f-4f9f-876e-65376fd49fd8,d5781c8c-b4fa-4a70-a6c6-3b8cbfd22f5a,fe68b42c-15b2-4b77-8cf8-7ac123e3acca,4981c020-d4a8-429d-a76f-27787d526e60,da5282c3-062f-4e7e-8318-44f54b5e6f10,9b5fc79d-34c0-49c3-847e-3d6dc15c84af,49f7084f-27da-4918-82f7-e70f5ec888ba,fb0a0169-7100-42e5-b34f-fa739cc20a42,8a818f0b-80d9-4304-bab4-3d55dacdcaad,2b9d6560-daf6-40c6-89ee-3010814846c4,8e1c7541-a27a-40bd-a1c4-31da77d518e9,7647d82a-e1db-4c96-add0-70bc07faba83,ef4684d4-439f-4de7-90bd-60d5a59abbd2,f384b1e3-d573-491d-b20f-743e98814bed,3c326170-f357-4009-ad24-af03711ab818,5a071d36-9df9-4f9c-85d6-43878c124814,43b47767-592e-48c9-9356-7ba3f3a41056,bbe0ee09-8a8e-4582-be81-2ae4ec392051,e1cc847d-859c-47a9-b787-570ee712d848,44b760bd-e74f-4e06-a988-21001b011c83,814848bc-8951-4d56-9a27-a0407edec4af,da85cea8-72ec-422b-a170-623696450b02,017dc726-d141-4d1d-8b5b-1680e4a6db2d,b8cadee5-68b8-4e6c-a7aa-abc8e5a148e4,727989b5-741b-449d-8420-93308296d612,c096779b-e11b-44eb-b8be-2f4ec0f2cf75,504df573-3274-4362-aab5-e9eb1a010d9b,a1e5f3e2-40b3-49c2-b5a2-665cac40b9fe,80b95060-fd2d-4ff7-afc5-47bb702fa6b3,322d5d02-1bba-4e34-8d55-f562edbd5ae0,5ad2d6a0-8a43-459c-be38-04bf2cd3a421,fe76da78-44ef-4a07-9843-34d8ebd851f4,d7d92482-c54d-4555-965e-3945cc3a76e2,5539391f-beaa-487c-8ac8-0fb3a3d7d707,57b665ee-bbbf-4558-8fe5-ea0516826985,1c678fb1-13f3-41d2-af38-f4598a4f9c9c,7fb59368-c504-41e8-81b9-998be886e8d1,58088438-f1ed-4645-a3d1-6b73efc5f1bc,db310de1-cb2d-4122-aff3-22311806edd1,6a2f7793-a4f8-4fc1-a128-5464278f8a49,420fba62-bbb7-419b-a43c-064395f32979,6ac64dd2-fb88-4627-a29e-057bba91bfbd,b360ce94-13d5-4309-92ce-5fb6eee6764f,e0b2b478-e640-49ef-a415-33aebf709c4d,880f724b-ccf5-4452-acb2-d8e1c1f082dd,41393c8b-fc91-468f-93bd-b38acdfa3a44,357dec6a-2557-48a9-a8cc-23d4fa511db4,a19dc0b1-ee53-4dd5-a331-a628be10fe7e,e9e1664f-b648-4317-8f95-6feaa5ec05d0,d2204358-8d99-4922-8fc4-3dd84caf57d1,464047a6-c769-461e-b1ec-e9b7c26a765f,201fbcef-9b84-4523-a8bb-4dbac599c8e0,2c854757-ac10-4ab4-a4d9-e3cc2e732a42,4a96b4c0-1740-403d-a5b1-e97368a218bf,9cbcdd97-711a-4c5b-bfff-954f36d97cd8,145b4686-a223-4ebb-9847-9cc75ce6ae58,72873a98-488f-4f97-9b6d-684a7335255a,11a808b4-282e-4af0-ae1c-946323125453,03686a2b-5f61-41ad-acdd-6b130d64bad0,c78c785b-c514-4165-878e-6f7bef71d408,3478f7a3-bcd7-43bf-95eb-86086b669cf3,632638de-fba9-48ce-83a6-c71e636ee518,c139c06c-80ed-463c-a19b-3aac462c5577,a2b10b9a-516e-4043-a7d2-55f486f4d1b2,cadeca30-fa4e-4929-b036-821cb3861bd5,241c818e-dac8-42ca-ad70-91053e89940c,979a3c0c-80fe-45cb-8a23-0e3a6879f345,d1e86add-b5d8-4cce-8f1a-6db5d6763425,59310481-f015-4f0c-ae84-a01f0ef7d022,0b284204-c7c9-4a10-9c16-c3d229250651,f1b0d54f-d052-47ba-a7da-747d33d3bedd,926992c0-6f7b-4616-831f-1674a9ac463b,fe43699d-f5a7-4b6d-a677-6b2c2a9d77cf,c6366cfb-3c45-4bdd-ac06-7d478dba7cec,cd71926e-bc57-4da5-b259-664bae10fce5,15c43ac9-c10d-4685-a7de-caf6221ca356,08f9f281-e01f-4656-aeb7-371b6dc12770,f08cc26e-3f36-4fd7-804e-5b46e7173b8f,f857e1f2-6587-4907-993b-58dfcc99b3a4,3a617e62-4f25-4512-bb27-7a6c5d73d67d,3263c881-44bc-49be-8d47-3e41ee58514e,5afffb8a-ba5d-48e1-9778-eb9a27d8f58a,0ed279e5-8980-4bf4-a307-c1d772b73b94,1292dd49-d964-4269-99ec-cb00fc0d68d7,b88d05df-a9c9-4148-bcf5-4a4389052946,ec2aa03b-c747-4b46-9af1-08cdf46685cd,3625bfb9-96e1-43dd-81e1-5bd5effdacbe,9c7009e0-5290-4631-97b8-f853746051f0,9cd329dc-6675-443e-9f78-6c0bdc78fd2b,60e245d3-aeca-430c-a054-373822578bac,203f8faf-9126-4d81-9ae2-6cb1facc112c,4dea1e3b-7ad5-429c-8c5b-8025234106ad,df5893c6-775f-4b94-8396-ae66bf631e05,c1dc70ac-422f-457c-93f6-10c87e688ff6,860e7f25-75c0-462c-976d-bd54f4203011,73ff0133-dc02-405b-9ace-84797ebfa0aa,94882bb7-d6c4-4562-9d4e-30bc2526f10d,2211cf65-54c1-4920-a3df-9968b16a8301,0b81b80d-7e3b-401a-a54b-07a6246c99f0,7e554991-d0d9-4be4-9e28-d080ad805824,70b34d5d-8935-49b8-aae3-03964fcc4add,9c5e090b-30b0-4156-b40e-70710479960a,e15e3069-ec3c-470b-89ec-3282cf28a27b,c0d17b13-cddc-4f46-adbd-a18a1598138a,9a7241ef-8c43-47b5-bc83-63dd42f2e5af,46dcc8c3-f1a1-49a9-901b-9980950217bc,8c521b74-550b-4691-8bfb-a69e52329a77,1b1bbf52-f5d0-4507-ba21-72d71b27f026,7ad00a6c-1997-4f6c-810a-c591bc1ade4c,4d389cfe-2ac0-48ca-9185-09360e2dfc87,62e53b49-28bb-4444-b33e-457afd4fc1a4,3b87a463-07ab-49b6-a704-75df91bbc2a7,8b18899e-09d0-4c92-b299-a4439304a35b,43569db1-ee07-4de5-b69a-ab3b848d55bc,1687c522-3ad4-4107-8c23-9db22a7c0752,f1588e6c-4b93-4215-b631-2d2f9eb44f71,4522c10c-fabe-4d90-b935-2ff2ddc2caa8,0d0ba343-ee56-4249-96c4-f310f3707376,c5cc94cb-ac0c-48fc-8a97-d57017619fc1,f93c0891-2b06-4c9b-a7de-7a18a6a6a88a,c2a78bdb-d065-4ef1-9784-d5963b48c065,adeb6ec7-e1b8-435f-b585-3c676302246b,c8b2e2e8-dffd-4f65-9ab5-49859707e218,255cc0ce-b5aa-4eea-b880-cc6d9bfec578,492a081b-2a45-4fe3-83f2-4976208ff720,e41f3581-78d1-495c-b02e-f472e732d622,608cd299-b2ea-4d7f-8995-409b10355e8b,e58a7d3e-9335-46b6-a104-b87bba2b2ff0,44f160b5-5d03-42c8-8bf0-0d30b9e35b95,82d9ca4d-d36c-4142-a1a3-5b501e8b2e24,3ce4ee80-3c38-4b52-8a0a-53ba1b72ab9e,3a0e59c3-507f-4d79-98ba-687dff3edac8,d483e094-2804-416b-a083-88257cff60c6,1e2449d2-0fb7-4839-b9cc-747184450e7e,f82bf434-a4f0-41f3-a714-ee4283fa6c1a,fd0a23c0-8dc4-4504-8ab6-f554950859df,bbe4cdb6-82c9-4425-b3f4-d6ab38e8fc28,f80baa7d-2311-4e02-9bca-aa3217c43a59,abc7fef2-c61a-44c0-b7f9-aea2a528f688,35303e06-ad40-46eb-8e94-9aea23c5f4e6,c01b2c95-6fd9-4627-b27d-ae0dfad097e3,ff8f6180-f1b5-493a-a498-3b02518952d1,d3157405-89bb-43f6-89f5-f42cf48b3545,6d8140cb-939f-4f3e-a4d4-951151e03199,7ae382cc-5587-46bb-b660-c67e51d735ce,45a3a2a3-6014-40fb-804a-37058130d7cd,027aefc5-e6d4-4b72-b163-ce1f39d1f589,06992757-4235-454b-8339-0cd785a2c88d,4b7043ad-92c6-4b87-8523-7c59dc8bce98,83f660fa-bcba-4e61-9a24-0288d6a4ba19,54642f23-0bb9-4e6c-a9c0-aa1f1ed0fe0b,42d9318b-b313-4243-8a55-e0a10429301a,959aed98-2a86-4adf-8dba-08026129c995,4380e057-2553-47e6-afbf-585473378ccf,af6acd28-e952-464a-b142-4acb23129480,4e105259-d057-404f-9968-6ae0094412e2,41e10610-d3c4-4e39-9ab9-00ac4ad6fcdd,fb058a83-8766-4ab9-9660-18e543fae55c,cf52c9a8-7e03-41c5-a19e-094e27bfddf2,2a67ceda-39ce-4ea0-831f-3895583ffa48,ac9e3086-70fa-4c87-96e8-e7ebcd778843,6d786ad3-0a70-4983-94c5-38ad7e700f75,b1c2e2fd-03f6-440c-84bd-21c2c9138be2,707da501-2243-46dd-bc8c-e5675df981a2,84c624d7-bb76-4c21-af6d-5ebc238e4def,10302d87-5bc4-4f4d-95bc-593cf3376d55,bf516c97-56d8-4f41-93ae-b2cbcba27656,0559380e-3e7e-43c9-9d6d-0916af87f021,cbe8dd4b-12dd-419a-9862-fe34ff184a58,a05fe014-9aad-4ee7-8b19-248980ce3d1a,395d8009-49bc-46b8-8234-044201fc497b,7fd6b8a0-ff90-4b1f-b1cd-1e72f102c1de,caa10001-2805-476b-b4e1-aa80c0b45d07,8601129b-e5b6-43a1-bb4c-48788c25b0ff,f91abb7c-aca5-4aeb-95da-8a70871f35e5,33bdfc09-258d-442f-bf4e-29e3cd5e6d31,ac0b4ece-5017-4e67-842b-e93909e9845e,8745dc70-3867-41c5-b7e3-29a996dd0fa9,1191180b-8c39-4553-8451-35bad7a729cd,eb4ab3a7-b7c2-4e81-9240-e4fb00e58214,7dc2775c-e8a8-496f-a73a-bcf50d1014ad,11e3d379-26ec-45d1-a832-ef8a849ee6f6,3d1c0775-bd37-4710-bf46-24539f040bd6,aeaa30e7-d31a-49c0-801a-ebd75616d502,af92ed07-97e7-4e63-9697-4fc754d45a64,c73ccd57-6893-4a01-a827-e540af5c3e7e,9c560fcf-c9b3-4d7b-be4e-540d94ce45ed,267984d2-f849-436c-843c-b6b59622230a,f0adb083-74d5-458f-a18b-8a70f2b0a94c,cf45b4c8-b6a5-4bad-b30e-917a1a1c2a8c,30dd2b5c-a985-4107-b505-59a3815bc52b,397bf3d3-a309-4938-8205-36e9efadcbfc,88d055d3-2359-4eaa-b595-1e823598df4a,8f1698d6-b828-4694-9fc7-10194890e437,3d7daf34-8033-4baf-8357-083890b8217d,d04a6e86-58fb-4240-950d-98c117bcb604,9e7f1d2e-5a3f-4a90-900a-3dd8abf72469,58f98c78-59ca-4702-b880-03eedb2b12fe,f7edcadc-8fe3-4a42-a73a-877d5a51c2cc,4cc0973f-9146-40f4-8038-b3cdfd1c7657,6ed0ceb3-530a-40ce-9e23-24b50699c8cc,ae25d826-a8ff-4a40-8e9d-ef2d6779cb69,c974c470-bfd3-4edd-9a92-54a7b4112fe9,4cf727f3-0e8b-41b8-869f-b613683d34cc,e468c582-2188-4d9e-ab01-75566a0b90fe,5cc8b37c-fb4e-43ca-a4c4-a4ffeebba48a,1b054724-55dc-4a85-a75b-26fb6fcf7a45,44b9f8a8-3a72-4f06-be0e-70bba954e48d,07dc51bf-5191-443f-aec3-0500c5da9dce,3aeab557-113c-45b5-a75a-336972881f32,8cb5254d-6010-4b61-b81f-d1439cce590d,884e1cab-aed1-423d-8153-2ca5524dd239,72d85f8a-abe1-4ba0-b340-c75454cffab7,a0f0def0-8706-4947-a6b1-b394268d3bc3,48e2a69f-a65c-4738-93c8-328be3f601e2,8006a00e-6e5c-4361-99ce-e759a1fb4892,f7e02df6-e5b7-48d7-8efa-46f439100042,e89ec409-1ce9-4fae-a3c7-c158b973f91d,3817064a-725b-440c-a21b-c67584dbdbbc,5a377ee1-5495-4e83-bb3d-baa8a16f0dda,88c9a0cc-6f42-4c7a-8f81-d7312273e96a,ff142f40-cab2-444c-acc4-06e7a12800f9,424173ef-e9d1-4490-9b89-3cd6eca6e45c,f36f94ae-0394-4e4e-9d94-1fc21c1a2db9,ccce370d-7e1e-4af1-9115-33bc25e1a877,f0b0eaad-7203-4503-b407-95588b975929,0d48381a-a144-48f4-8b25-f089fbeb0298,97975c79-2215-4b6c-8730-8810cd083988,b0da6619-0013-4150-bcd2-8d3773037347,1c9d18a2-34a4-4b85-a8ee-9b6baa3150b8,1ecc44fc-d541-4331-a21a-2bb0761a86d9,3a13e49a-da4c-4e83-a28f-eca59c1e77fb,01ecbe77-a6c7-4955-9a5a-e9f40c70300b,5934b8c7-e48e-4ee2-aa12-f03e904296b5,d1e49d53-add1-4b99-894e-a2056deb2097,ce81539a-5717-4908-9474-b2b190be735f,4ba3ce55-061c-4fbb-bb13-b1ca4d64872e,b7f49dc5-2e26-4eb8-af5a-6e6ecb398ff9,aad9f821-09e6-4125-bbba-43e4f53336b9,11d90ab2-972f-41ce-8db2-d807c319dd32,632dafdf-6b11-425c-9df6-c903366ad0af,9f1e1101-f74a-4f63-a574-1637912da162,a09995d0-d625-467f-ae9f-251b89626832,40290024-2672-4058-abdc-a2c3560e1788,16c093de-a039-451a-aebf-8a8a8eacae8b,68b60292-2fa8-42f5-a8d2-99258fbea6ff,c6c418b0-a9b0-4167-9968-ce503c363ce1,ab5fb97c-9fe4-4210-98a1-0223a3ebc9a2,a94bf7fb-6ccd-46bd-955f-a2cdbe72e783,c061effd-a1d6-42a4-bbb3-0082123e3547,922a01a2-9443-47b0-b1d8-66df1f232f8b,a9aef3ba-408c-4369-aeaf-2ca81373dd21,76a36dc8-6a01-4ef4-9a4a-daa2f6f49c1f,839e9314-8a4e-4d97-a0ce-e6bbb5e13343,b2f81fa7-ccc7-4078-ad13-0f88b538182f,ced234d9-ac27-4be5-b4f8-ef3d2917cddc,03982dab-7bb3-474e-820a-6d0ebe5e8073,8fac9ba0-d8eb-45c7-83b2-74f1d32fdbc4,3250bf81-dec1-4ada-874e-1613a156dd41,af3b3631-f27a-4f95-8fab-2d39b98dba73,4e54193e-467a-4f69-8857-57103658b220,40c9fd92-d09c-4473-9ed0-4dc851975feb,fdcd15ec-4404-4e99-8c6f-bc2ded5f0fb2,397262d0-54ca-442c-beac-9d162bafa5f9,90db8921-06b8-411f-bc68-c299fcb205b2,6a9ab6a1-4dfd-4bb8-9cf1-de9e97ad75f1,a67ecce7-5723-4cd7-bf2d-51d4dcaf7b92,24c45eb3-2194-44f7-9c0f-d95d681eae30,5f3e8fab-2db8-4f8a-beb2-2545b4ed1434,127bd4b1-71fa-46cd-997f-6135e49ed525,33a92262-af6e-4812-9bca-010fbb39daa5,ccb9b9ac-33ac-4129-bca1-01fc236ad976,78162f5a-812a-4774-82ba-5539541e622e,33d8fa3d-c15c-4e4e-b19c-d342ed76ff6e,815e936a-0ad6-4dc7-971d-3668cba77627,7d27b5a7-77a7-4ea8-b811-50c4edfb5ee0,9b4d11e8-93f8-4e27-b77b-57ebe88f2455,955cead2-90dd-4775-be93-29f3c32af565,1ff98ad0-6a36-4b43-9fe9-63e220464cfd,1715a2fa-00b4-4911-bb87-49b4a3a92f39,274a66ae-9514-4f14-9165-9fbf33db0e3d,f23ef646-c0f7-4833-b502-896aa383087c,37b66412-2277-4a1d-9475-33fc52606a00,be754ddb-b709-44f5-b208-2b481812b10f,0470a780-16d4-4ab6-921e-c2ab56044ad2,c11475eb-e65a-42db-9874-9deb83ebb540,ec819dc3-b95a-4bcb-8046-3524838a288b,ebe81148-7239-45ca-8284-087ade311990,da2462b0-13c7-4ac9-bd49-96a6308f7b8b,d65701f9-c982-4cf7-9b7d-432c33a71f08,32679b48-0196-415a-a8b0-b6242ec80449,6391e4ba-8e50-406a-a68c-ad585da646d9,a82f5c82-9d4d-49fe-be94-67a4ecbeef66,e1263813-fa54-45cb-a75a-86215fd21c7a,e12cdb44-217f-4cca-8efb-cfed4344f133,75999b35-6cc5-4827-aebe-ced5c749db4d,be9f211a-d0d6-44fd-8ec0-c262035318f2,27443def-fb12-42d1-81ea-8223a0f56fb4,ccc2d100-de3f-462b-8a2c-175335897e5e,bbcb0464-50ae-4d73-892d-a5ba44334310,16d81819-e9e7-4ce7-a634-011f0619113c,eb60a711-7c96-40da-ac68-b46264a86365,0ed9c741-b138-469b-b13e-870baad14fb7,052f5f9c-29aa-4a6f-b6c3-0e0219746038,72a8ada0-e7bd-422b-8789-0087834b590a,15671b38-8371-4185-b7d0-e0ead0ee4627,a7035e5a-2668-408f-a937-dffc854a01a9,5dce715a-353c-4654-a43d-986ef1b797d4,62e81934-3338-404e-95f8-a1bb560fac4e,b349e0f7-8e27-45d6-aba7-9e86002afb90,b075ccba-8795-4a94-b5d3-fd0328989ffd,b792f4c0-d401-42c6-86f7-c7f847cfa646,d6b7d2da-6d75-49c8-81cb-69a295427162,1ece62ea-7aef-4efc-b506-80013d13339c,ce61d95f-c25c-4aea-bee6-728e48130aaf,e7d65a86-a2e8-48b0-8595-9ca3ec5e0edd,808bda48-4262-4377-8973-06e775a9b0bd,b864bd7f-b2f6-4fcb-8d8a-fed2b5ea4a3a,1df5925b-1cda-467d-9a6f-a80452e5feb1,fe60545a-0366-46eb-b1a1-0bb0ada18959,56492621-e688-4410-b2bf-7f63bc27964f,eafb1401-edbf-4296-9aab-d4e6e2e143ed,bf733ab4-69b3-41c8-8e82-3fe478b805dd,f56706bb-4ec0-416d-b294-c36d962ce981,220effcb-36e0-4056-91d9-0bdcc731a2f0,8ae75beb-1a9c-4f7e-ae2b-62a87f1d95a5,73a1e466-f7e9-41fc-a477-0d918fc73f3f,06a98798-a174-4e38-920c-267283757eb7,e1eb8ef3-e4da-4cf9-ae70-4c8ee5cc0543,8e77f73c-ca00-4fd0-a873-1839e73edb17,8fc9f5f0-5db4-4609-b27f-d6e67b638d54,27b9ecf1-20b4-4af1-801e-6c6ee04a488a,1b66b28d-5c7a-469f-8b87-3429e0f4c546,6a7de2c5-385c-480b-87db-9ccc679a2067,6c30350f-4c3a-4fc0-8bb8-074a54e6111c,b4934be9-44fa-4845-952a-7c3abaad810d,576b0e1c-1332-4207-bcf1-87559527d555,565552f1-2988-46a8-93da-dffe3c951fee,62f8d939-0d71-4691-9645-79831d58381d,06438fc0-a597-45c4-ad71-335098dca33d,0c2cb33d-74e5-4516-a617-4e5c5d85cfb3,03aa24c9-c4e1-41d9-92f3-c33d82bcd2d5,8ed5f69d-3b71-421f-a3eb-3d2641db004e,a70b7089-ac43-471d-b9c3-805153c172b1,e33bbc43-cdb2-4280-a7b9-d65f3d49d45e,88951320-44e6-4606-9350-e9527fe4cdb5,8761e0cb-3188-44b7-8299-4e632619d745,c5a54665-6196-4f0e-ad0a-e91f6e84e8de,cfbaa8e5-0f1e-4836-87a9-c9335c75330c,5ee3fa1c-7d3a-48d2-945f-8f9c8bbbac49,7ffc90af-a28e-4b55-9d5a-bd4bcc4a1b1c,84bb74ce-08f9-49a1-bb90-30a12dc4f69f,93789186-b8d2-46f0-a915-805c843a6c9b,1c3bc139-9c63-47e4-9e9b-fa23277b9605,370ad789-96d8-4556-b8d7-90ce2f37dc18,f5ca5ff0-71a7-45dc-b169-dd2101235b92,a82ebbfd-7e19-4510-b94b-70687155cd50,ce4e5a7d-85cb-4ecf-9b7a-d71f8df8d6ca,0a3b2f11-3892-4e9d-83ae-e30e102f1554,a1529c66-6b10-48ce-a71c-05e5b091d57b,0a5ab919-6054-4236-acc9-bcfa5bb402c1,ff3052d2-9406-4f40-a792-789ca71f09cd,313283a9-5009-426d-aedc-9d5eba336d33,6dd53f10-aca0-4a23-827a-6bcc6eb0330a,e8dc7195-6962-49a8-ae53-20fca5a7dedd,88309bd0-f34d-4b37-ad85-4422a391fda8,7ba54686-48c3-4b78-b0b1-66da3fe51780,3df826f7-ea92-4a5a-954f-e6fe18d59d5b,708a92de-947b-460d-ab36-e0e701ae0a1f,c82f1f73-84df-4655-9703-5d270e11ef80,5bfebe7a-aa97-4b07-ae03-5921befe8ff7,9d05c044-894a-4fc4-82fa-b0664cca2414,d7372636-f7bd-4410-a05b-0f2ecfc00a3f,8262ea49-e0e9-43e3-8683-9115e84f9083,fcbe171a-85e7-4afc-86e3-b5eb376a4313,23902be7-0b11-481d-b6dd-969ac83cc552,f7d13c5c-91b9-433d-855c-cbd78ae2311f,7fb46316-f7e1-4f79-82e7-fe529026365c,30c3eec3-a0ad-4298-8c96-4fe94b36fd1a,c2d5ca0a-b625-4dad-94e0-1427884bebf0,eabe319a-144c-4f77-b267-7aac68cc624f,5188f231-56fd-40e5-bb95-884707a65801,f4f88c49-9393-463c-9fce-6e65b49b3ecb,3a9c4ae7-09c2-47e2-b7af-f307655a557b,3af4df4d-161e-47ce-98c1-544607af052b,8383c78a-f840-4574-a8ea-c912a1da7ea7,047e0778-08a7-45db-a5bc-7d71fabdde66,733e1f1a-6a5d-422e-bad2-78f4299d1454,1269dc80-6ddc-4d9f-b7c8-962384260442,000dc620-6d64-4fbf-abe7-a5c8302084b7,482ce71a-cbd7-473e-a1e6-fae4b185f056,bf64d4fe-f079-4d74-b1ae-3ea4eef579a5,2198cbca-3ca5-4eb5-a6df-e07a87ca8ac9,ed315f50-90fa-4149-8873-35d626114175,0b4248ca-b79c-4560-8543-443559fa9aa9,16c735f6-cfa6-4e69-b227-30d61fcf1c87,385fdaeb-b64f-4e71-90cc-1ea3c9f7524b,1a3a828f-cd08-461c-8f6a-e1b0f218bd8d,6531d29c-5754-4f0c-8e49-86ada633a58f,ab521bd6-744d-41d9-a6c5-d137b30af985,8d958835-593e-47c4-8b6a-4c1c53a52b69,e2113a56-519a-4acd-8a70-9cbf5e11e001,dd6cf7b6-4fed-43c7-ae81-c28c919369df,9f8cec92-474d-40a0-baff-bc34140865fa,c32cbefb-d871-44b6-821f-90071581b181,c84abeba-edb6-46b9-8fb6-eff5d0126b77,4faccfe3-bd45-4c72-b549-d719a64b69cc,bbbe2971-6d1d-4915-9654-6b04f7c05529,a90d0737-1075-4e55-8664-a7c16df2a61a,3df2d077-8834-4899-b158-8b255cf8c54b,178d1f5a-64a2-46d3-9e26-26a24ac27933,6afa2672-d46f-4e6b-8dfc-7097e7e747a8,ded42c0a-63df-4b26-b8bf-530787f71e15,ded7084f-a8bd-42d5-942f-8454798ec2c8,98786a50-e06a-4711-b032-32f40804c916,911128e9-0b53-4994-a2df-141464ae1d5f,2bac58d5-8a69-4741-92dc-e1c91047c59f,fc94501a-39c3-47fb-b45b-968ecf758e19,a234194c-d9fc-451f-b609-a836d7663bab,116c5b1b-2954-4ceb-bc98-976e9451d074,b828eb91-78d4-46b6-ac07-939ff53ea10e,a0482f3d-baf9-4efe-81b2-1e5bc3bb2bb3,fc791b43-ef7b-49fc-868a-df64d17e186b,afb505d2-1921-488d-bc2f-53f14cec1850,e130b4ac-9932-41fe-b76c-38f451c64a7b,42b0d6df-6e30-40fc-bc11-de55d2c06e07,bdecf1b7-674f-49cb-be35-84d077da96ee,e5258669-0125-4e10-8d7a-e423d26fd660,612e89a1-4628-4981-8e7d-9e7b21308ca8,1f39a6ed-6ddc-4a9e-b41d-1f1b574efca8,dfa50397-9993-426a-acaa-668122095ce2,4f627922-04c1-4005-af71-9234b5667abf,4e9e1235-e6ce-44d5-93bc-0be54b44d9e0,14ddbb00-400d-4b11-93fc-52bc252e34c5,4c4727b0-10d3-406b-8adb-e34893b00aec,a6314c32-eae8-4533-89f2-2f0df5d2db5f,1ed86bdf-9bfa-4d34-8596-8a8c60b332f8,dff3c55b-2135-4c69-a9dc-61e459233f40,cb4d5139-d1a5-4a8f-bd1f-274e1fcaa678,24b8c353-8a16-4b95-b1d7-2742de850ccd,2fa600f1-2fef-4673-a8dd-3339b8a31811,84c86994-0219-46b4-a6a8-dde3f64aae7a,a6fc5a84-899f-4ed7-b038-d4c7d697b1c7,09250a6e-6f96-40d1-bd44-040f4b00b74e,5b671594-33bb-4937-b031-77520c29b6d0,e7890471-0825-4b55-9afa-0549d63c6353,9194920b-9e75-4980-aa43-928f93d29e56,09f029b3-a2d1-4474-a815-0570ca7d5b23,42704c41-95ec-4601-a3e4-21f6e8ffa61b,405c9239-d1af-4739-86f2-91b3df5cbfe4,b0ff9fcd-a63c-49ea-9996-adb2148d7f2b,b3b1dc0d-886c-4692-9c3d-0767806af50c,2eb04e49-c12e-4e80-afd9-99fcdd85b3cf,c2ba16cd-8f65-4685-8c11-ea239202a5e7,e7d8ca24-15d5-4d86-a3d0-3c41ea242ed5,d4be0530-9666-4f2b-986d-bf2b79d46f37,4642cbc7-6e3c-4385-9725-615a28785f00,1d245e88-3ba3-4bea-96f1-c56bbc576695,161dcba8-35c8-4cb0-a7b6-7c6f248cc51d,8cde5168-5bc8-407c-b431-b3dbd3eeb351,9392029e-f7f9-4b95-860b-20d42b12fa87,173e92f0-d2a3-4a02-a918-f8911cf1b27a,ff41f40f-b9cb-4576-897d-0d07cc2eaeaf,b6e432e7-367d-49b4-8b09-bfede7ff864c,ebca303e-4fd5-45eb-920b-85b9881368df,07929192-8c4d-4c5f-b521-d1e4bdb004f5,25ce88c6-52f2-428a-91db-95c8809933ca,b6158070-0bb6-4f80-af29-3e3ebe0295c5,fa2171d6-4027-41e7-81a1-c8f1fc58ba8b,5ee208bb-8aef-41ac-b888-c5a5a62aa643,3cbfd996-200c-4a7b-96c0-8f146480e188,fb94c4f0-5339-448b-8009-f15d3a8b110c,2c71e19b-3e98-46d6-9700-635897c0dd1f,5640bb10-3c87-46b8-ac40-f1fbc51dc9c9,f3ad0da5-fc36-42aa-81e1-f6ee22f0bcd1,c9bb1eef-a45f-443f-9188-77950f6e1ee7,b7e5e262-933d-47c1-9c87-23e536cb70fe,6bd31d71-0aed-496c-871f-9fee6b2809de,5ac613ec-6072-4d44-96be-102c56be6723,a099c0eb-d9fa-4794-b3dc-fc7b0807dde7,1337e0e2-140b-427d-bd3c-c4efce169ffb,29211caf-7b8d-406d-8a98-1ed20d3f5263,54b368e5-9464-41be-8a98-c06ff286a28e,6860ce99-46ca-44df-a1c3-4f3301241b25,85338e2e-1358-4c82-948f-0718281b2d3c,fed32534-c33b-4bd2-a20d-d76b7fd640b7,fa58687b-93ce-410a-8062-e56e2771665c,94953579-3c0d-4777-a52a-fa6500663939,f6ffa99a-5bc9-4694-9ec1-e636acc0738c,06f0608c-6726-4f95-8b08-63dfc9e59c03,213e353a-b930-40da-8d04-054f6073c828,2c6ab7e1-2799-4ca5-85d4-467518d50193,a53bd27f-e4c2-4ed4-8fa9-7528b8af5a26,17f5afa3-74c8-4fe0-b9f3-e93f05e95628,07846722-5632-4bb8-83f3-f1cfb96e67d6,62d2bd9c-f3b3-4a11-be46-254dd43545e5,d98afaae-a0cb-4802-aad0-3095e91a9b99,895957be-9abf-4f7b-ac7b-aa479a015341,fc9d4a95-3ae6-4da2-a247-a3a4e1b0b5a9,ad561d6d-0102-437e-8811-cc0e3d231828,7c3302d5-40e8-4aee-87d8-0c282b9d4ee5,ebf998cc-00d0-4115-807e-87207add5226,6a99270f-a82a-481e-8759-34f349574386,b0d36cb9-26ae-417f-bc8b-d55c23feea10,e62fbaee-06e9-4359-ad07-fa7c8bac116f,23a7f598-15ca-44c0-a2ec-ca877a8c16be,4f68f288-75fc-4012-b74e-c6f58fec2957,83418d9f-49fb-4f64-a261-6c1a60a32412,d3884ffc-60ae-4d5e-a889-78af7628d0b2,65bd8851-402c-4256-a2d4-e7d2d156d694,452cb44e-14c5-476c-9ab8-1e59ea146b43,51d71c62-9af1-422d-8f39-9d081272bc97,a35e68c3-8c9e-4493-add6-4401448fc130,83e28745-531d-4a80-ba52-8a49d56ff600,b2750593-d618-4fae-a8a6-2607d8ea82e4,edc594b1-4533-4c93-9c2c-6da21571e940,62cba00b-4e79-4525-8f42-dae59fcdceb9,62fdb6f1-ae03-41da-907f-c20478818302,7ad20882-545c-4a39-bc32-15b93ab8fc16,788aa206-7960-4070-b030-30853c99848a,ae9c433f-db28-4306-90ae-c98b360833c0,483eaf71-142d-4f8c-ba79-2d49f7c3bbef,c14b6f86-8691-4d48-aad4-aadeec2e2721,54f4aeea-907d-4c39-b154-a27883faedfd,47370a74-ab2d-4d6b-8a49-004a543f7735,6aa4e2fa-bf50-43f7-8315-30f06b6c6384,e47f3746-cd99-44b0-b904-cdb54d9236cf,e30aca92-fc56-44b9-8848-466be1111187,6b3ebfaa-7c3b-42ad-ac58-0d3c4cade1c3,8728d497-c42c-43c6-95c1-6dc9c57a85e7,29065889-1200-46f4-b025-d4fcb7130182,a0f2e641-8de3-448a-a1f2-d72d25628471,178a4dd8-e80a-421b-a432-89dc9df9575a,f73dd8b3-6507-46e9-aabd-cd533c48d671,2f9e5d90-46fb-484a-95a6-b0c231d87204,e1b7c093-db01-4469-b780-eff015121c2d,5ba654ae-0602-4532-ae76-bb586377fd36,ce648e86-c155-4f77-8ca1-aafc9f96ea25,27a99201-6ef1-4541-82e3-81a309465fb4,e4a7f3e0-d4e5-482c-b720-0601f745119d,4b1c8132-a663-47e5-99ee-46d2b140ba55,63f6f654-44ac-414f-9084-5efc15c8932d,4b9422f3-ddce-4037-80c3-3e225484bfc2,dbb8425e-c3b5-406a-bf22-1d898902fe7f}'::uuid[]))
  • Filter: ((userlocation12.startdate <= '2020-10-14'::date) AND (userlocation12.enddate >= '2020-10-14'::date))
  • Rows Removed by Filter: 27
  • Buffers: shared hit=3,215
Planning time : 16.859 ms
Execution time : 41,388.285 ms