explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0JLR

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=359,045,755.99..359,497,256.83 rows=180,600,336 width=1,909) (actual rows= loops=)

  • 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.code)::character varying(50)) COLLATE "en_US", ((objectextensiontag4.name)::character varying(50)) COLLATE "en_US", ((billingrate5.name)::character varying(50)) COLLATE "en_US", "*SELECT* 1".entrydate, ((objectextensiontag11.name)::character varying(50)) COLLATE "en_US
2.          

Initplan (for Sort)

3. 0.000 0.000 ↓ 0.0

Seq Scan on systeminformation (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=159,171,083.87..163,554,265.43 rows=180,600,336 width=1,909) (actual rows= loops=)

  • Hash Cond: (objectextensionfieldvalue20.tagid = objectextensiontag11.id)
5. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=159,171,069.55..163,074,964.68 rows=180,600,336 width=371) (actual rows= loops=)

  • Merge Cond: (objectextensionfieldvalue20.objectid = "*SELECT* 1".timeentryid)
6. 0.000 0.000 ↓ 0.0

Index Scan using ixoefv_objectid on objectextensionfieldvalue objectextensionfieldvalue20 (cost=0.43..271,739.82 rows=5,950,034 width=32) (actual rows= loops=)

  • Filter: ('b814810f-03d6-4d06-894f-7d8b64bffed5'::uuid = definitionid)
7. 0.000 0.000 ↓ 0.0

Materialize (cost=159,171,069.12..160,394,053.16 rows=125,883,360 width=355) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=159,171,069.12..160,079,344.76 rows=125,883,360 width=355) (actual rows= loops=)

  • Merge Cond: ("*SELECT* 1".timeentryid = objectextensionfieldvalue12.objectid)
9. 0.000 0.000 ↓ 0.0

Sort (cost=158,920,579.32..159,235,287.72 rows=125,883,360 width=351) (actual rows= loops=)

  • Sort Key: "*SELECT* 1".timeentryid
10. 0.000 0.000 ↓ 0.0

Hash Join (cost=18,894,831.03..130,428,839.00 rows=125,883,360 width=351) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".userid = userdepartmentgroup21.userid)
11. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,894,381.78..128,367,049.73 rows=251,766,720 width=363) (actual rows= loops=)

  • Hash Cond: (ts.id = tah.timesheetid)
12. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,495,734.30..117,764,512.90 rows=245,821,575 width=213) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".billingrateid = billingrate5.id)
13. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,495,733.26..117,105,556.40 rows=245,821,575 width=207) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".timeentryid = objectextensionfieldvalue19.objectid)
14. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,294,674.19..85,500,769.43 rows=245,821,575 width=169) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".userid = ts.userid)
  • Join Filter: (("*SELECT* 1".entrydate >= ts.startdate) AND ("*SELECT* 1".entrydate <= ts.enddate))
  • Filter: ((hashed SubPlan 3) OR (hashed SubPlan 5))
15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,263,454.47..22,582,919.20 rows=84,096,267 width=157) (actual rows= loops=)

  • Hash Cond: (tk.estimatedcostcurrencyid = exchangerate.fixedcurrencyid)
16. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,263,453.43..22,267,546.63 rows=84,096,267 width=161) (actual rows= loops=)

  • Hash Cond: (task16.id = tk.id)
17. 0.000 0.000 ↓ 0.0

Hash Join (cost=18,221,794.95..22,005,134.48 rows=84,096,267 width=155) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".userid = login.userid)
18. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,221,545.90..21,783,975.70 rows=84,096,267 width=144) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".timeentryid = timeentrymetadata18.timeentryid)
  • Filter: (((timeentrymetadata18.uri IS NULL) AND ("*SELECT* 1".timeoffentryid IS NULL) AND (("*SELECT* 1".timeallocationtype = 1) OR ("*SELECT* 1".timeallocationtype IS NULL))) OR ("*SELECT* 1".timeoffentryid IS NOT NULL))
19. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=17,858,834.69..21,104,318.58 rows=84,518,849 width=152) (actual rows= loops=)

  • Hash Cond: (COALESCE(project14.id, task16.projectid) = pj.id)
20. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=17,826,051.89..20,849,671.83 rows=84,518,849 width=116) (actual rows= loops=)

  • Hash Cond: (CASE WHEN ("substring"(timeentrymetadata15.uri, '^urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:task:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata15.uri, '^urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:task:(.*)$'::text))::integer ELSE NULL::integer END = task16.id)
21. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=17,784,393.40..20,533,325.61 rows=84,518,849 width=171) (actual rows= loops=)

  • Hash Cond: (CASE WHEN ("substring"(timeentrymetadata13.uri, '^urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:project:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata13.uri, '^urn:replicon-tenant:ec59310f04eb4b13a07d9dd6e7e07b8c:project:(.*)$'::text))::integer ELSE NULL::integer END = project14.id)
22. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=17,751,610.60..20,225,853.59 rows=84,518,849 width=230) (actual rows= loops=)

  • Merge Cond: ("*SELECT* 1".timeentryid = timeentrymetadata15.timeentryid)
23. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=17,751,610.04..18,122,422.31 rows=65,878,251 width=167) (actual rows= loops=)

  • Merge Cond: ("*SELECT* 1".timeentryid = timeentrymetadata13.timeentryid)
24. 0.000 0.000 ↓ 0.0

Sort (cost=17,331,428.03..17,496,123.66 rows=65,878,251 width=104) (actual rows= loops=)

  • Sort Key: "*SELECT* 1".timeentryid
25. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,727.70..6,717,354.50 rows=65,878,251 width=104) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".userid = ui.id)
26. 0.000 0.000 ↓ 0.0

Append (cost=1,001.55..5,690,058.53 rows=98,076,616 width=68) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=1,001.55..5,688,127.42 rows=98,076,550 width=68) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,001.55..4,707,361.92 rows=98,076,550 width=140) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,001.55..293,899.04 rows=150,887 width=156) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Seq Scan on systeminformation si (cost=0.00..1.01 rows=1 width=33) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Gather (cost=1,001.55..292,389.16 rows=150,887 width=123) (actual rows= loops=)

  • Workers Planned: 2
32. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.55..276,300.46 rows=62,870 width=123) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.99..141,204.46 rows=62,870 width=123) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Parallel Index Scan using ixte2entrydate on timeentry te (cost=0.43..6,108.42 rows=62,870 width=60) (actual rows= loops=)

  • Index Cond: ((entrydate >= '2020-07-27'::date) AND (entrydate <= '2020-08-02'::date))
  • Filter: ((timeallocationtype <> 2) OR (timeallocationtype IS NULL))
35. 0.000 0.000 ↓ 0.0

Index Scan using ixtem2timeentryid on timeentrymetadata tembillingrate (cost=0.56..2.14 rows=1 width=79) (actual rows= loops=)

  • Index Cond: ((timeentryid = te.id) AND (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BILLING-RATE'::text))
36. 0.000 0.000 ↓ 0.0

Index Scan using ixtem2timeentryid on timeentrymetadata temdbreaktype (cost=0.56..2.14 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((timeentryid = te.id) AND (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BREAK-TYPE'::text))
37. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..19.75 rows=650 width=32) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Seq Scan on projectsysteminformation psi (cost=0.00..16.50 rows=650 width=32) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=0.83..1,931.12 rows=66 width=68) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..1,930.46 rows=66 width=140) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Index Scan using uix2toe_timeoffidentrydate on timeoffentries toe (cost=0.42..1,772.75 rows=66 width=28) (actual rows= loops=)

  • Index Cond: ((entrydate >= '2020-07-27'::date) AND (entrydate <= '2020-08-02'::date))
42. 0.000 0.000 ↓ 0.0

Index Scan using timeoffs_pkey on timeoffs toff (cost=0.42..2.39 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = toe.timeoffid)
43. 0.000 0.000 ↓ 0.0

Hash (cost=676.12..676.12 rows=4,002 width=36) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Hash Join (cost=327.34..676.12 rows=4,002 width=36) (actual rows= loops=)

  • Hash Cond: (userdepartmentgroup17.userid = ui.id)
45. 0.000 0.000 ↓ 0.0

Index Scan using ixudgdepartmentgroupid on userdepartmentgroup userdepartmentgroup17 (cost=0.28..338.55 rows=4,002 width=4) (actual rows= loops=)

  • Index Cond: (departmentgroupid = ANY ('{63748a86-7004-41a9-9534-09acd5a744ea,8e621d29-67cf-4952-89db-ad7dd8f791d1,15c9d6e1-0857-459b-9760-e451379f64d6,1372b5d3-6510-4b3f-932e-6a71fe046162,eecfd2f5-f2cf-4793-b52c-8df4bf912ccf,dd9238b8-1f09-47c5-8f28-3b83754396cc,d54c0ed6-da63-42a7-a36c-1434e31b7ed3,a6593f86-8113-4043-8c6e-0ccd4c1f2330,d31e8f6b-d902-4e3b-a092-39c533350c4b,6ec13843-cea4-4378-8e45-5816bd94df0e,28390661-3560-4f82-876a-0a861316da58,d619eb68-0109-4484-94aa-64daad7e45e2,6ded36b4-926f-42e8-bb76-b4841dc84daa,1431adc5-d248-4036-8f4c-3b4c92a351e1,9f7eebd8-658e-4156-a41c-b4217516249d,3210bf30-d4a5-4340-a686-8724ff5ba042,76e8b759-b850-4743-af4a-229c62bc24d4,635df3af-c5fc-4de1-9ac3-ad159fe7d2e8,8347f4dd-7ceb-4a9b-a63c-db15f97885fe,66e2609c-d09a-4d81-851f-3022ec9f86b9,3603b72b-d563-4e6e-a903-b77dc28bc77e,59d6c73e-7d73-4c7e-9aeb-cfc07fecb4dc,0dc1ed32-bbbf-43c3-9ba5-358cc8810d4c,5fbf141f-e062-471a-acfe-504f26354a7e,a34ba05e-ea27-4dd6-83a3-580bbbd88e46,35743079-9554-46cf-9027-55a8525a267f,49040497-c304-4b25-be1d-a7fe9992f02b,35839b20-cf03-45eb-9347-571c33544434,5c47eb12-b3b5-4040-b269-a1a7f784d42e,63a8aa57-d028-4fd7-8f0e-d7370a0f8ca3,0dfb0bfe-e84b-4170-821e-dd230248457d,433c099c-2399-46b6-9b36-6cdb6eb56323,3a5a38f9-948d-4e3d-a1bb-b25942d34d9d,6ee697f7-c4b1-4352-87c4-058e08e1e2d3,24639159-a17c-4ebc-bcd2-808cdf40816c,165e80b8-9a69-48b9-822e-f3e99285b07d,40058f31-2cd8-4d5b-b8b7-97c1f8d0d5f1,12216a4f-c309-4bbc-8dc4-1ffeb2d6b35e,1603bc1d-6d09-487f-8e27-9340e3d41723,b50b3576-8348-4518-8f71-ee3a68cda3f3,66055b98-0f33-4fbf-8955-ee3253f85da8,1d9c9304-dd95-4b98-bb18-fad11e486c26,e5872134-b8c9-4e04-9cc8-5a7e4304b822,daa20114-beea-47f2-a865-0b2714455bfb,ab86cd16-180e-47af-a669-3631d6dc4306,ef973d1f-8f5e-4e1f-bf15-cc8c18493c17,abce2340-6dcd-4bc3-b51d-82dbe87c466e,288c8df4-d193-4187-a206-f70eab8d05c7,070ce7fb-9fa1-416d-828c-b79e1ac46ef7,4e761b7f-f088-4090-9dc5-eee086203626,a4232b93-e61f-4745-ac13-403f03f0604e,e2da09cc-73c5-4a8c-9ba1-35bc78052255,b12f4d54-aa4c-42c9-a4e4-86ade4b45a13,7579e1e6-b1e3-43e3-b461-b12f28d1d5ad,c41786ab-9e89-4854-84f1-2971e1a08744,f85c882a-3e1d-4119-ab91-8ed3e2a02e8c,346c6801-7eb9-4dd5-b661-517e26643327,d3b88ecd-8dd8-494c-9348-5fd04a39eebf,6011c3d1-e9b2-44f6-bdaa-85aa8a397045,2ff09dc5-90a3-46d7-82a0-f49e50e7b21a,a200cd7a-9fbe-42d6-b74d-95f634d03179,353ad7d3-7565-47a9-88d5-888af2e2e905,5446549c-ab9d-449b-8daa-b2a70e2595be,ca90dbb0-aacb-4a7a-8d54-1853aaa6dba4,56558278-2404-4ee2-af44-1d0312d75848,7d11c14d-11a6-45f8-bde0-291262d1d0f9,320381f9-56ab-44a4-8080-181b59f2d89c,431b8fff-153d-457b-ac31-a980580cc5c2,6f6a3add-50a5-4910-84c2-52e658cdb7ee,e5e53f15-00ce-444b-94ed-596b03f5cff9,8b2fce9e-da3d-4ce5-b1a5-f2969ff57745,babdd4d8-bc7a-4b69-b699-4ab2e05040a7,525e1ae6-d02d-442d-bfa3-73193bb3cbb1,96eaf8c5-49d0-4935-925e-969f7a390c82,dc18f638-832e-4e0c-a997-9ef2c38dd58d,4774ec08-5a2b-4f76-b40f-ce45618b42d2,6e84c9be-ded8-43c5-8fb2-c8a27969774d,b143401d-ce1f-458f-ae0d-9280e644d113,4e0ce556-2b97-4cb5-9b3f-493c14e17016,e3e44e22-694f-4f16-9c37-bd0740a12683,551e27c1-4aa0-40b3-b5fb-06e84dc529cd,74bb6af0-73cb-405d-9e83-fc0a8d15c9ce,2af7803c-af5c-49bc-9801-34247c6a567d,36d486ee-dd1d-433c-a7b4-878559fc8312,016a0b90-7fad-4190-bf9b-36e21c2a5a48,758d8018-7878-47bf-8857-c8fae66bc144,3eb7d2a6-f0d0-482a-ac61-1730f4a3be75,f5764a3d-1f52-4bd4-baff-6d54b46dc348,a13e37ed-5e75-46e3-a494-153828a35d33,cead2f3d-a852-47d8-ad5b-c900a3f944f4,bd41a941-5037-4656-b2ca-1e329784f3d7,5e5cd89a-089c-4219-b475-da0951a73eaa,fb4b63a5-6a9d-4306-b204-09da34906638,9dfc4070-af27-42f9-be68-24cf4242f960,0951edf9-d5c9-414e-ae62-c6fb7162fae6,85dcd1cb-dc11-4d3a-ae36-910f66198ff9,099b1f93-e1de-42e9-9b4b-0b0d6499bd8e,bf89d697-d059-4aa7-9dac-deb860af3ad7,f02fb3c9-c396-45e4-906f-07474de6f333,e617a439-21f6-4882-b2ab-f2a3512b9b38,c2ce1967-2335-4e8c-8f04-597283cd904c,bb6d6520-5038-41f7-91a3-456314480981,d9dadd7f-c334-4d0b-af42-df1191c5a1d8,e031d76e-f195-43e7-93e4-13e36b2146fc,240aef54-144b-4e24-9ff7-63fa7c110963,772ae0c9-d1bd-42b7-9b6c-635718c92db5,85080ec1-4f49-466b-a3f9-8fcc6e258b7a,682a92de-7249-45be-b69f-af4b45b3cf7b,b1b44e1c-4377-404e-8066-3fb0cee73f41,53af70ff-0cb8-4c7c-aff9-6d030ca858fd,12a0d4bb-6d4f-45ac-aaa7-8854f9bf91c0,b4f3ce8f-bf07-435e-95f0-465ce4f3872e,473cb95d-f86e-4341-b2c1-1359d36d1500,e6aadcab-97bb-459d-a35d-e4c5e547448d,18abf21f-fb18-419c-9bf0-04141b13a4d4,a1e912d1-b8e8-402b-9103-3dd9f25793dd,3046bbbd-0689-4213-afea-45f5eb78a0e7,2dc92cc5-1b22-4e93-96b9-f6832ab573e0,dd3bc6cf-a3df-4ce1-b89c-f49f192fdb40,ee33169a-f927-4b03-87ec-3098806aa407,1c4271dc-3f71-4913-87d3-fbb7cd730a55,e0d74777-7428-45c6-bc06-2b70318a1c78,b80ee300-1e0a-4fbc-a68e-8afc168bd2bc,b7b9a235-bb99-4801-8d9c-1a0fb1e33469,be8b6a21-bdea-4d8d-8f7c-4f74bd265ece,a9e8fb08-2ba5-4984-a182-33820287896c,b9604c84-9930-4421-b3f1-2bcab0b5e1eb,f7bca334-7745-4ac0-87b3-1af99a58d0ba,c9179b87-ab2c-4e9d-84a7-20b69acdfacc,c0bd98f8-142c-4ecd-a8ea-bc6f46b84416,e09886a1-6cc1-476d-9469-59401d82f973,4691360e-fd4c-483a-9f20-04830d9c802c,f1229825-72f0-4231-a94a-a305c3cbdbbb,bcd545cd-fdd6-4e9a-851e-6c2ac7136c64,eb4bcec0-3231-46f8-a4f4-1c81374d8884,5c7ed232-ab3c-4f5d-a726-08813a901e77,6c056885-c32f-49d2-878b-74182cbe350b,545c071c-75bc-4010-b966-d5a48bcf2d54,f42f4cbe-0eed-41db-989e-4e78b94db334,c2744556-146d-4fc7-9bb1-3f66dd034aa4,1481d777-5425-4535-b4af-07cf1344045e,415b5343-cc7f-46d6-9221-e91f3d9cbf20,06b80d19-5833-4879-acb9-b497a6c00569,d70d1a8f-a138-4579-8f37-eddc419b9058,ec76edcc-7198-45b3-8189-91c82f4ef489,5cdf39b4-5515-4872-90b6-5394d682d89a,88fcb8eb-1de6-4e3a-9c1b-e67ee8799700,b88b0ff4-8756-4f62-8c21-9249a9697ba1,5f49cf45-0593-47ed-b4f2-4fdd31c9877c,42e53d7b-8fc6-4e7c-84a5-00d4f6e02eef,5a86cbea-a72e-47f0-ad80-471178c33f18,79202f69-4224-4aa9-9aa7-ea2d2e7960c4,cbe0ca9c-cab8-498a-9b5e-5ef8967ae895,5f99637f-8336-47fb-adc5-0ea40e840398,53bf4d0b-caee-420f-aff8-2ca5be8e3ed3,aef54f59-856a-4bc4-b4ca-5f25cf542e85,e028afbd-5edb-45fb-aaba-00646c450714,a386b17f-c3d7-4c41-a2fb-935433c8c48d,17868ed3-a073-4006-82fe-18508c4523a8,c2ec7d62-79bb-40b6-89fa-01ba79056484,c0f89a7e-8969-4cbb-ab4b-1609e834248c,90eaf634-7b13-49a4-8691-1673677aa3f3,c450eebf-eb1f-40ce-836e-568af98a3d90,4422316b-93cf-485b-87a1-bcc62c4134dd,bc6a2111-45e9-4bd1-a66d-2d240cbb069e,1afffdfe-f207-4ea8-a423-093ef8436930,3b6ccdd2-bafb-4847-81be-baf62e100d96,bc9a8812-163f-4bac-b0e0-c6ca036498e8,88b9e729-b80d-4a54-981d-a8b3d4dbfecd,fa646ec5-d008-4825-8098-a60409286438,32fc5827-965f-4e3c-828e-082417b8178b,fb2e658b-de2a-4d20-8120-0f081767b458,a7a62289-d3f2-4f07-9f06-a09df743466c,f9872977-a176-4458-8c20-ab7693186b53,05302366-b851-42ff-99a9-709edd35a3d3,23cb296c-1360-4ef6-bcfe-5cd7b14b5fde,8646a47f-cb63-4206-bea4-71a1590944ba,ab3f502f-f0b7-4a13-aa29-b971afea879a,f900118d-2183-4369-bae9-e5605d074d8b,7454aea5-30a5-4236-b90a-6741223476e5,d08cce01-60e2-43b4-9b8e-e2e13e9e9c02,48343c20-dcda-45fd-b935-5e0db0622e4d,5a040c5b-61ab-4f10-8664-391ade1a44a1,a16cfce7-6510-4806-9f2b-5c5839807ea7,0bcbaff6-0882-4165-b036-390281dbf546,a69e008a-2690-4d67-9294-eb9cce64daf2,f6552eec-9de3-4970-a9a2-bb00453805cf,82607295-d547-4027-94c1-74de4d8d74ab,908fe188-f39e-4e40-b5d7-a080c734d3c6,5b1a9f95-e64f-414c-9bcc-72e34fbc457a,38c17637-138d-4964-a34f-edcd4d1366f8,e72a2d81-ff50-4d55-b078-171a00a2b09b,00b9c56a-6837-4ea7-8f43-93692c91d82b,995ff036-c64e-4117-b049-596bfeea5e11,a4434aac-a520-46bd-a358-43d30db0b5e9,cb80978a-0f1a-4c50-900e-8aac938775e8,70a4561b-dcfa-4290-a699-ffc4fb207120,df8dc109-6b8e-48c3-9edd-2ffc7ee4714f,63feb72d-c1e7-4459-a5fc-fd7cb5a90d72,7a0866d5-4326-4773-97fa-30869ae160b9,22aaa2cc-b51f-4bab-a21d-1a67a067a025,a912fbde-810f-4562-ab4b-33d691b73834,d3f3f024-5032-42cf-a423-4e1475d6593f,04a0a1d3-3885-4c36-80bf-64b04f90fd24,89455064-6f90-471d-80a2-e4fa65986326,ac88b9ec-8cac-44e8-baa5-a62345f7f934,5d23cbec-af2c-417f-b207-04e5c50dbf9b,f86b5bc7-4a4a-4b29-b188-6d9d19f2fcb6,8fe6723b-5109-47cb-a60f-d25dc0f9fef4,36e14ea5-32a2-426d-a8a5-2fe0b08cb7db,d7f2a899-6113-4414-b448-b7a61b1eaa65,f0272dc0-f05c-495b-bd35-034435d4b56d,087cc6ef-c884-4215-bbcc-0f788694ece9,8ef49263-070e-4987-bbdf-966019effb3a,1fada185-6c37-40ca-8f79-1cb51ed7eb85,73a5f40a-ed9e-445b-8ccd-effd0523fe14,b4e83f5e-9ff7-4f20-9007-8605dffce375,3e7d7822-a861-44bd-bf96-93d5f662fbfc,49e85b23-8de0-400a-8393-783109c2fe25,678dc0ad-ebef-4897-9d13-d6a3c802ffc0,c891a653-0d04-430d-94d0-f698c958a733,b3df14ec-5a97-4b70-8794-dd5642833fb7,77d81db5-f470-435d-ac11-42a37055471b,bc708552-8f6e-4378-9eac-45352a94cbcc,04000bf2-3602-4b83-b6c4-735987b21381,0b035355-7de6-4dc4-8028-d344138407a0,8b20b960-1c49-41d4-8cbc-52fe7ee00b2d,d96a74f4-bedb-4cb8-8ec8-fd96a93a9e8a,8b95c741-4ac4-47c9-961f-f22b6a3c2859,1f89a938-9dcb-4917-884e-eada1007a002,8434347c-b200-4296-89e6-56062713511d,e1fa2be4-b5fd-4533-96be-a0965c6e40b4,23096542-b97b-4bb2-8d1e-1631471d1ffc,79a13552-0060-4bfc-a927-c7687a9551c5,b304480c-5e8a-4bf1-83e9-be0aa55e318d,20f14bac-5990-4151-8825-daf6378a4201,9b87345e-3f39-4945-aede-2791b91b3267,09e06f0b-e478-4769-a9b5-15b343d0a9e6,2b6d5154-7bd6-4a13-bff2-31c11b892862,ac7f7845-e6fe-42f9-b0e6-0514e4f0d2c8,b945a978-7d84-47e6-984f-3a43c00d7901,6d6f291a-b667-4693-bc39-f434ae3e7056,3ad5ef4b-e132-4fee-a95a-1ed9ab257101,79f761bb-4184-4d18-94c3-1e978c99d9da,586b9046-693f-4f36-93c4-77c6a79823f9,7c598816-d5c6-4322-b9a9-3d229844090a,35a035fc-fba9-4a6f-91cb-dea7d4db8b5f,e7e0a591-5435-42f2-adfa-1572a9678c1f,de47bc19-82e7-4cf0-8c84-94168b9c1f93,3bd2be6b-40fc-48f6-a3e4-90a935399fbe,0289e414-3dd5-47aa-b38f-da78b9c68427,0ceb5449-3a98-4e5a-be54-03b3bc6d55c2,e7130fb7-fcbf-4a82-ad4b-d6c446bbc873,73c4bdf9-f9ef-4acb-a671-6543d7bfb473,c82fd458-8f54-4806-b3e5-73f0654d1cdc,654da51d-a471-4a88-b5c5-c7d65b1f1a73,af827711-fdd7-48e2-b6d0-f92d971524e8,19c74da4-514c-4dbd-afb4-244cc43c631b,897170ab-d87f-4615-8c68-77e4d0852e76,6e4f7031-fb3c-41cd-b29d-949902f6e89a,1d40d09b-0fa9-4049-b726-335cb105f7a7,e3b09223-957f-40f3-92b2-fb1ad84f0ec9,112f7dc7-9f03-46c9-9613-ad96755c72ba,d85dd5ae-2d64-459d-908d-7cdab312129e,90c75e56-96b6-449c-85c5-21826c609a9d,dcf60d5e-75e7-4986-8a34-a7d2c6caf969,081f9383-8ebb-4e2d-b32f-fb908b22c05d,a17174e1-70af-413e-95d1-b618564b7724,4d65d1ab-dd8d-4277-bf86-5b36ab3dd754,ae326f30-871b-4c35-9564-21031e6a8478,cfe0d7ac-a127-4b59-a85a-b33fd1c3df02,f96f9791-62a1-431a-9e26-8ff8e67c2b11,c75490bf-d799-4bf3-b271-9ccc715fa6aa,6cededac-c0d6-48be-a975-d2c883e7b6b0,ab4e9860-ffb3-4f9b-8c79-f2a1215585c6,0488f85e-3f8f-4977-a73b-46321d77f68d,8181206e-496f-49c2-b6df-625d64148438,064507a5-40aa-4d00-be7d-ec1ed9b8af85,3d1fa0ae-a9f1-4471-ae97-ceaafb22541b,0a888b84-0d0e-4bf9-8e16-61db76fb2e19,a4160bc7-f1f2-4a51-a3e2-cfb9abc964dd,f075ebce-6cbc-41a4-9fcb-f7999be58454,5070fb96-43e7-4c6e-9868-d008d4d509fe,a4f23018-8f47-4379-ad48-5a7cac0ca1f0,5103585c-802e-4a3f-b304-f281559f8c4c,7a88d1f8-e63a-4f7f-9583-33a883b6249f,fd641c08-5fca-4565-a9ca-f9c032096bf3,0feb22cf-e4fb-49dc-b469-4d219cef9048,1d642af9-62af-4ef5-a3c7-6dc790d16267,bd416342-6960-4433-a14d-e20e88390ec1,e98bd248-704e-4d12-9a1a-f45def57d218,8bebaaab-15d8-4c65-8a1f-c163fffbaa9f,596b351a-033b-4a1d-9a4d-45b55a28dce4,9add729c-2677-47b1-81a8-b86a9e2b66be,4505933f-0c7b-4868-8914-33ed01193d77,5a48c2dc-0436-4d7a-81af-ace6cf18b851,bf6d8c85-bc2d-40b0-944f-000ba7484c07,00b7844c-4603-45c0-8525-9b6e2cfcdf31,90c41a83-32f2-4285-8e9c-f66742ddafdb,9c7b3048-d6d8-4cf7-9011-b8b67f50f67b,895aba65-d492-4b16-966c-e4a8f90a6115,56853e42-273e-4bb8-868c-84bf3be5817b,e14d6eda-315c-4775-8ce8-d1ff242be0d5,bef0bba3-ecff-4de6-a366-df0eb0952704,5c847892-c1d8-4b73-8ac1-f1fae741f62c,9400befe-cd77-4684-841c-a82340b91a90,880cb58d-9388-4389-8ea7-01b7db93af29,5008dd18-5dbf-4489-a8da-26fe5f1b1aec,e9304ba6-1e0f-48b1-b205-dc4ddcb882ff,bf101ede-c665-4abc-aefc-3cac06c056d4,b341e12b-26d1-4b71-9f7f-1ce68ce312cf,09d7166a-1fce-4ecc-92d9-7a8b1a9e240f,fe91b354-5733-4492-a08a-822683bff927,f1995d29-f88f-4dde-a790-414addbebbb3,98210347-8075-4eab-a6dc-cd2fbc0dc8f9,39dc3c65-d01a-4e5d-b9bf-e6805c46fe88,51719d56-1569-485b-b2a6-60ff4852aad7,a22303a3-1bb7-423e-9529-e192104dd820,23e891b2-c089-4454-8292-e680ae9f06c0,d31b6240-12a3-4b08-816f-42b2b9d2f794,66a74107-df57-4600-aa14-f1d942fa801b,ce157f37-c738-4384-a793-dcf1e11735c6,75e16233-2e78-4364-8801-5a5afdaceb5b,67e67836-54e3-4b56-bc23-54caf470f0a8,75e4ee7f-e174-4f2a-bff9-d77769a53996,206719e6-520b-4b60-a403-5ca28f6ff7b3,55ab98f2-a9a9-4158-aacc-19041283e64c,8a7b33ea-94a2-409a-8265-77070d08b804,6e47c766-449e-41a7-9095-8d1186bdfe68}'::uuid[]))
46. 0.000 0.000 ↓ 0.0

Hash (cost=252.58..252.58 rows=5,958 width=32) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Seq Scan on userinfo ui (cost=0.00..252.58 rows=5,958 width=32) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Sort (cost=420,182.01..420,668.11 rows=194,438 width=79) (actual rows= loops=)

  • Sort Key: timeentrymetadata13.timeentryid
49. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..403,101.66 rows=194,438 width=79) (actual rows= loops=)

  • Workers Planned: 2
50. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on timeentrymetadata timeentrymetadata13 (cost=0.00..382,657.86 rows=81,016 width=79) (actual rows= loops=)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text)
51. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..685,830.93 rows=5,951,210 width=79) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Index Scan using ixtemtimeentryid on timeentrymetadata timeentrymetadata15 (cost=0.56..670,952.90 rows=5,951,210 width=79) (actual rows= loops=)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text)
53. 0.000 0.000 ↓ 0.0

Hash (cost=26,806.80..26,806.80 rows=478,080 width=4) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Seq Scan on project project14 (cost=0.00..26,806.80 rows=478,080 width=4) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Hash (cost=29,623.77..29,623.77 rows=962,777 width=8) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Seq Scan on task task16 (cost=0.00..29,623.77 rows=962,777 width=8) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Hash (cost=26,806.80..26,806.80 rows=478,080 width=44) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Seq Scan on project pj (cost=0.00..26,806.80 rows=478,080 width=44) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Hash (cost=362,711.20..362,711.20 rows=1 width=79) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Index Scan using ixtem2timeentryid on timeentrymetadata timeentrymetadata18 (cost=0.56..362,711.20 rows=1 width=79) (actual rows= loops=)

  • Index Cond: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BREAK-TYPE'::text)
61. 0.000 0.000 ↓ 0.0

Hash (cost=174.58..174.58 rows=5,958 width=11) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Seq Scan on login (cost=0.00..174.58 rows=5,958 width=11) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Hash (cost=29,623.77..29,623.77 rows=962,777 width=10) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Seq Scan on task tk (cost=0.00..29,623.77 rows=962,777 width=10) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Hash (cost=1.03..1.03 rows=1 width=4) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Seq Scan on exchangerate (cost=0.00..1.03 rows=1 width=4) (actual rows= loops=)

  • Filter: ((variablecurrencyid = $0) AND (('now'::cstring)::date >= effectivedate) AND (('now'::cstring)::date <= enddate))
67. 0.000 0.000 ↓ 0.0

Hash (cost=13,199.66..13,199.66 rows=209,095 width=28) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Hash Join (cost=7,142.06..13,199.66 rows=209,095 width=28) (actual rows= loops=)

  • Hash Cond: (tslist.timesheetid = ts.id)
69. 0.000 0.000 ↓ 0.0

Index Only Scan using dm_timesheetlist_facts_pkey on dm_timesheetlist_facts tslist (cost=0.42..5,477.66 rows=221,083 width=16) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Hash (cost=4,527.95..4,527.95 rows=209,095 width=28) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Seq Scan on timesheet ts (cost=0.00..4,527.95 rows=209,095 width=28) (actual rows= loops=)

72.          

SubPlan (for Hash Left Join)

73. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=229.23..10,653.21 rows=104,565 width=16) (actual rows= loops=)

  • Hash Cond: (timesheet22.userid = userdepartmentgroup23.userid)
  • Join Filter: ((userdepartmentgroup23.startdate <= timesheet22.enddate) AND (userdepartmentgroup23.enddate >= timesheet22.startdate))
  • Filter: ((hashed SubPlan 2) OR (timesheet22.userid = 3,497))
74. 0.000 0.000 ↓ 0.0

Seq Scan on timesheet timesheet22 (cost=0.00..4,527.95 rows=209,095 width=28) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Hash (cost=150.82..150.82 rows=6,169 width=28) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Index Only Scan using ix4ucc_userdepartmentgroupstartend on userdepartmentgroup userdepartmentgroup23 (cost=0.28..150.82 rows=6,169 width=28) (actual rows= loops=)

77.          

SubPlan (for Hash Left Join)

78. 0.000 0.000 ↓ 0.0

Index Only Scan using departmentgroupflathierarchy_pkey on departmentgroupflathierarchy departmentgroupflathierarchy24 (cost=0.28..1.30 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (parentid = '1fada185-6c37-40ca-8f79-1cb51ed7eb85'::uuid)
79. 0.000 0.000 ↓ 0.0

Seq Scan on timeoffs timeoffs25 (cost=46.46..4,352.09 rows=55,863 width=4) (actual rows= loops=)

  • Filter: ((userid = 3,497) OR (hashed SubPlan 4))
80.          

SubPlan (for Seq Scan)

81. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.98..46.37 rows=36 width=4) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..25.20 rows=17 width=12) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Index Only Scan using departmentgroupflathierarchy_pkey on departmentgroupflathierarchy departmentgroupflathierarchy28 (cost=0.28..1.30 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (parentid = '1fada185-6c37-40ca-8f79-1cb51ed7eb85'::uuid)
84. 0.000 0.000 ↓ 0.0

Index Scan using ixudgdepartmentgroupid on userdepartmentgroup userdepartmentgroup27 (cost=0.28..23.68 rows=23 width=28) (actual rows= loops=)

  • Index Cond: (departmentgroupid = departmentgroupflathierarchy28.childid)
85. 0.000 0.000 ↓ 0.0

Index Scan using ixto4userid on timeoffs timeoffs26 (cost=0.42..1.23 rows=2 width=16) (actual rows= loops=)

  • Index Cond: ((userid = userdepartmentgroup27.userid) AND (userdepartmentgroup27.enddate >= startdate) AND (userdepartmentgroup27.startdate <= enddate))
86. 0.000 0.000 ↓ 0.0

Hash (cost=193,282.35..193,282.35 rows=622,137 width=54) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=14.31..193,282.35 rows=622,137 width=54) (actual rows= loops=)

  • Hash Cond: (objectextensionfieldvalue19.tagid = objectextensiontag4.id)
88. 0.000 0.000 ↓ 0.0

Seq Scan on objectextensionfieldvalue objectextensionfieldvalue19 (cost=0.00..191,616.99 rows=622,137 width=32) (actual rows= loops=)

  • Filter: ('4fd4e56a-a51a-4bbf-b826-fb7575748787'::uuid = definitionid)
89. 0.000 0.000 ↓ 0.0

Hash (cost=10.25..10.25 rows=325 width=54) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Seq Scan on objectextensiontag objectextensiontag4 (cost=0.00..10.25 rows=325 width=54) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash (cost=1.02..1.02 rows=2 width=38) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Seq Scan on billingrate billingrate5 (cost=0.00..1.02 rows=2 width=38) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Hash (cost=397,272.86..397,272.86 rows=109,970 width=166) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Gather (cost=7,016.68..397,272.86 rows=109,970 width=166) (actual rows= loops=)

  • Workers Planned: 2
95. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=6,016.68..385,275.86 rows=45,821 width=166) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=6,016.11..205,492.66 rows=44,739 width=109) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,015.55..26,156.84 rows=44,739 width=36) (actual rows= loops=)

  • Hash Cond: (tah.timesheetid = tahls.timesheetid)
  • Filter: ((tahls.timesheetid IS NULL) OR (tah.serialnumber > tahls.lastsubmitserialnumber))
98. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on timesheetapprovalhistory tah (cost=0.00..19,788.96 rows=134,216 width=40) (actual rows= loops=)

  • Filter: (((systemprocessidentifier IS NULL) OR (systemprocessidentifier <> 'urn:replicon:approval-system-process:timesheet-submit-script-data-and-validation'::text)) AND (action = ANY ('{2,3,6}'::integer[])))
99. 0.000 0.000 ↓ 0.0

Hash (cost=3,430.80..3,430.80 rows=206,780 width=20) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Seq Scan on timesheetapprovalhistorylastsubmit tahls (cost=0.00..3,430.80 rows=206,780 width=20) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvtimesheetapprovalhistoryid on timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue7 (cost=0.56..3.99 rows=2 width=89) (actual rows= loops=)

  • Index Cond: (tah.id = timesheetapprovalhistoryid)
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:ACTING-ACTUAL-USER'::text)
102. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvtimesheetapprovalhistoryid on timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue8 (cost=0.56..3.99 rows=3 width=89) (actual rows= loops=)

  • Index Cond: (tah.id = timesheetapprovalhistoryid)
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:ACTING-EFFECTIVE-USER'::text)
103. 0.000 0.000 ↓ 0.0

Hash (cost=401.92..401.92 rows=3,786 width=4) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

HashAggregate (cost=364.06..401.92 rows=3,786 width=4) (actual rows= loops=)

  • Group Key: userdepartmentgroup21.userid
105. 0.000 0.000 ↓ 0.0

Index Scan using ixudgdepartmentgroupid on userdepartmentgroup userdepartmentgroup21 (cost=0.28..354.46 rows=3,841 width=4) (actual rows= loops=)

  • Index Cond: (departmentgroupid = ANY ('{63748a86-7004-41a9-9534-09acd5a744ea,8e621d29-67cf-4952-89db-ad7dd8f791d1,15c9d6e1-0857-459b-9760-e451379f64d6,1372b5d3-6510-4b3f-932e-6a71fe046162,eecfd2f5-f2cf-4793-b52c-8df4bf912ccf,dd9238b8-1f09-47c5-8f28-3b83754396cc,d54c0ed6-da63-42a7-a36c-1434e31b7ed3,a6593f86-8113-4043-8c6e-0ccd4c1f2330,d31e8f6b-d902-4e3b-a092-39c533350c4b,6ec13843-cea4-4378-8e45-5816bd94df0e,28390661-3560-4f82-876a-0a861316da58,d619eb68-0109-4484-94aa-64daad7e45e2,6ded36b4-926f-42e8-bb76-b4841dc84daa,1431adc5-d248-4036-8f4c-3b4c92a351e1,9f7eebd8-658e-4156-a41c-b4217516249d,3210bf30-d4a5-4340-a686-8724ff5ba042,76e8b759-b850-4743-af4a-229c62bc24d4,635df3af-c5fc-4de1-9ac3-ad159fe7d2e8,8347f4dd-7ceb-4a9b-a63c-db15f97885fe,66e2609c-d09a-4d81-851f-3022ec9f86b9,3603b72b-d563-4e6e-a903-b77dc28bc77e,59d6c73e-7d73-4c7e-9aeb-cfc07fecb4dc,0dc1ed32-bbbf-43c3-9ba5-358cc8810d4c,5fbf141f-e062-471a-acfe-504f26354a7e,a34ba05e-ea27-4dd6-83a3-580bbbd88e46,35743079-9554-46cf-9027-55a8525a267f,49040497-c304-4b25-be1d-a7fe9992f02b,35839b20-cf03-45eb-9347-571c33544434,5c47eb12-b3b5-4040-b269-a1a7f784d42e,63a8aa57-d028-4fd7-8f0e-d7370a0f8ca3,0dfb0bfe-e84b-4170-821e-dd230248457d,433c099c-2399-46b6-9b36-6cdb6eb56323,3a5a38f9-948d-4e3d-a1bb-b25942d34d9d,6ee697f7-c4b1-4352-87c4-058e08e1e2d3,24639159-a17c-4ebc-bcd2-808cdf40816c,165e80b8-9a69-48b9-822e-f3e99285b07d,40058f31-2cd8-4d5b-b8b7-97c1f8d0d5f1,12216a4f-c309-4bbc-8dc4-1ffeb2d6b35e,1603bc1d-6d09-487f-8e27-9340e3d41723,b50b3576-8348-4518-8f71-ee3a68cda3f3,66055b98-0f33-4fbf-8955-ee3253f85da8,1d9c9304-dd95-4b98-bb18-fad11e486c26,e5872134-b8c9-4e04-9cc8-5a7e4304b822,daa20114-beea-47f2-a865-0b2714455bfb,ab86cd16-180e-47af-a669-3631d6dc4306,ef973d1f-8f5e-4e1f-bf15-cc8c18493c17,abce2340-6dcd-4bc3-b51d-82dbe87c466e,288c8df4-d193-4187-a206-f70eab8d05c7,070ce7fb-9fa1-416d-828c-b79e1ac46ef7,4e761b7f-f088-4090-9dc5-eee086203626,a4232b93-e61f-4745-ac13-403f03f0604e,e2da09cc-73c5-4a8c-9ba1-35bc78052255,b12f4d54-aa4c-42c9-a4e4-86ade4b45a13,7579e1e6-b1e3-43e3-b461-b12f28d1d5ad,c41786ab-9e89-4854-84f1-2971e1a08744,f85c882a-3e1d-4119-ab91-8ed3e2a02e8c,346c6801-7eb9-4dd5-b661-517e26643327,d3b88ecd-8dd8-494c-9348-5fd04a39eebf,6011c3d1-e9b2-44f6-bdaa-85aa8a397045,2ff09dc5-90a3-46d7-82a0-f49e50e7b21a,a200cd7a-9fbe-42d6-b74d-95f634d03179,353ad7d3-7565-47a9-88d5-888af2e2e905,5446549c-ab9d-449b-8daa-b2a70e2595be,ca90dbb0-aacb-4a7a-8d54-1853aaa6dba4,56558278-2404-4ee2-af44-1d0312d75848,7d11c14d-11a6-45f8-bde0-291262d1d0f9,320381f9-56ab-44a4-8080-181b59f2d89c,431b8fff-153d-457b-ac31-a980580cc5c2,6f6a3add-50a5-4910-84c2-52e658cdb7ee,e5e53f15-00ce-444b-94ed-596b03f5cff9,8b2fce9e-da3d-4ce5-b1a5-f2969ff57745,babdd4d8-bc7a-4b69-b699-4ab2e05040a7,525e1ae6-d02d-442d-bfa3-73193bb3cbb1,96eaf8c5-49d0-4935-925e-969f7a390c82,dc18f638-832e-4e0c-a997-9ef2c38dd58d,4774ec08-5a2b-4f76-b40f-ce45618b42d2,6e84c9be-ded8-43c5-8fb2-c8a27969774d,b143401d-ce1f-458f-ae0d-9280e644d113,4e0ce556-2b97-4cb5-9b3f-493c14e17016,e3e44e22-694f-4f16-9c37-bd0740a12683,551e27c1-4aa0-40b3-b5fb-06e84dc529cd,74bb6af0-73cb-405d-9e83-fc0a8d15c9ce,2af7803c-af5c-49bc-9801-34247c6a567d,36d486ee-dd1d-433c-a7b4-878559fc8312,016a0b90-7fad-4190-bf9b-36e21c2a5a48,758d8018-7878-47bf-8857-c8fae66bc144,3eb7d2a6-f0d0-482a-ac61-1730f4a3be75,f5764a3d-1f52-4bd4-baff-6d54b46dc348,a13e37ed-5e75-46e3-a494-153828a35d33,cead2f3d-a852-47d8-ad5b-c900a3f944f4,bd41a941-5037-4656-b2ca-1e329784f3d7,5e5cd89a-089c-4219-b475-da0951a73eaa,fb4b63a5-6a9d-4306-b204-09da34906638,9dfc4070-af27-42f9-be68-24cf4242f960,0951edf9-d5c9-414e-ae62-c6fb7162fae6,85dcd1cb-dc11-4d3a-ae36-910f66198ff9,099b1f93-e1de-42e9-9b4b-0b0d6499bd8e,bf89d697-d059-4aa7-9dac-deb860af3ad7,f02fb3c9-c396-45e4-906f-07474de6f333,e617a439-21f6-4882-b2ab-f2a3512b9b38,c2ce1967-2335-4e8c-8f04-597283cd904c,bb6d6520-5038-41f7-91a3-456314480981,d9dadd7f-c334-4d0b-af42-df1191c5a1d8,240aef54-144b-4e24-9ff7-63fa7c110963,772ae0c9-d1bd-42b7-9b6c-635718c92db5,85080ec1-4f49-466b-a3f9-8fcc6e258b7a,682a92de-7249-45be-b69f-af4b45b3cf7b,b1b44e1c-4377-404e-8066-3fb0cee73f41,53af70ff-0cb8-4c7c-aff9-6d030ca858fd,12a0d4bb-6d4f-45ac-aaa7-8854f9bf91c0,b4f3ce8f-bf07-435e-95f0-465ce4f3872e,473cb95d-f86e-4341-b2c1-1359d36d1500,e6aadcab-97bb-459d-a35d-e4c5e547448d,18abf21f-fb18-419c-9bf0-04141b13a4d4,a1e912d1-b8e8-402b-9103-3dd9f25793dd,3046bbbd-0689-4213-afea-45f5eb78a0e7,2dc92cc5-1b22-4e93-96b9-f6832ab573e0,dd3bc6cf-a3df-4ce1-b89c-f49f192fdb40,ee33169a-f927-4b03-87ec-3098806aa407,1c4271dc-3f71-4913-87d3-fbb7cd730a55,e0d74777-7428-45c6-bc06-2b70318a1c78,b80ee300-1e0a-4fbc-a68e-8afc168bd2bc,b7b9a235-bb99-4801-8d9c-1a0fb1e33469,be8b6a21-bdea-4d8d-8f7c-4f74bd265ece,a9e8fb08-2ba5-4984-a182-33820287896c,b9604c84-9930-4421-b3f1-2bcab0b5e1eb,f7bca334-7745-4ac0-87b3-1af99a58d0ba,c9179b87-ab2c-4e9d-84a7-20b69acdfacc,c0bd98f8-142c-4ecd-a8ea-bc6f46b84416,e09886a1-6cc1-476d-9469-59401d82f973,4691360e-fd4c-483a-9f20-04830d9c802c,f1229825-72f0-4231-a94a-a305c3cbdbbb,bcd545cd-fdd6-4e9a-851e-6c2ac7136c64,eb4bcec0-3231-46f8-a4f4-1c81374d8884,5c7ed232-ab3c-4f5d-a726-08813a901e77,6c056885-c32f-49d2-878b-74182cbe350b,545c071c-75bc-4010-b966-d5a48bcf2d54,f42f4cbe-0eed-41db-989e-4e78b94db334,c2744556-146d-4fc7-9bb1-3f66dd034aa4,1481d777-5425-4535-b4af-07cf1344045e,415b5343-cc7f-46d6-9221-e91f3d9cbf20,06b80d19-5833-4879-acb9-b497a6c00569,d70d1a8f-a138-4579-8f37-eddc419b9058,ec76edcc-7198-45b3-8189-91c82f4ef489,5cdf39b4-5515-4872-90b6-5394d682d89a,88fcb8eb-1de6-4e3a-9c1b-e67ee8799700,b88b0ff4-8756-4f62-8c21-9249a9697ba1,5f49cf45-0593-47ed-b4f2-4fdd31c9877c,42e53d7b-8fc6-4e7c-84a5-00d4f6e02eef,5a86cbea-a72e-47f0-ad80-471178c33f18,79202f69-4224-4aa9-9aa7-ea2d2e7960c4,cbe0ca9c-cab8-498a-9b5e-5ef8967ae895,5f99637f-8336-47fb-adc5-0ea40e840398,53bf4d0b-caee-420f-aff8-2ca5be8e3ed3,aef54f59-856a-4bc4-b4ca-5f25cf542e85,e028afbd-5edb-45fb-aaba-00646c450714,a386b17f-c3d7-4c41-a2fb-935433c8c48d,17868ed3-a073-4006-82fe-18508c4523a8,c2ec7d62-79bb-40b6-89fa-01ba79056484,c0f89a7e-8969-4cbb-ab4b-1609e834248c,90eaf634-7b13-49a4-8691-1673677aa3f3,c450eebf-eb1f-40ce-836e-568af98a3d90,4422316b-93cf-485b-87a1-bcc62c4134dd,bc6a2111-45e9-4bd1-a66d-2d240cbb069e,1afffdfe-f207-4ea8-a423-093ef8436930,3b6ccdd2-bafb-4847-81be-baf62e100d96,bc9a8812-163f-4bac-b0e0-c6ca036498e8,88b9e729-b80d-4a54-981d-a8b3d4dbfecd,fa646ec5-d008-4825-8098-a60409286438,32fc5827-965f-4e3c-828e-082417b8178b,fb2e658b-de2a-4d20-8120-0f081767b458,a7a62289-d3f2-4f07-9f06-a09df743466c,f9872977-a176-4458-8c20-ab7693186b53,05302366-b851-42ff-99a9-709edd35a3d3,23cb296c-1360-4ef6-bcfe-5cd7b14b5fde,8646a47f-cb63-4206-bea4-71a1590944ba,ab3f502f-f0b7-4a13-aa29-b971afea879a,f900118d-2183-4369-bae9-e5605d074d8b,7454aea5-30a5-4236-b90a-6741223476e5,d08cce01-60e2-43b4-9b8e-e2e13e9e9c02,48343c20-dcda-45fd-b935-5e0db0622e4d,5a040c5b-61ab-4f10-8664-391ade1a44a1,a16cfce7-6510-4806-9f2b-5c5839807ea7,0bcbaff6-0882-4165-b036-390281dbf546,a69e008a-2690-4d67-9294-eb9cce64daf2,f6552eec-9de3-4970-a9a2-bb00453805cf,82607295-d547-4027-94c1-74de4d8d74ab,908fe188-f39e-4e40-b5d7-a080c734d3c6,5b1a9f95-e64f-414c-9bcc-72e34fbc457a,38c17637-138d-4964-a34f-edcd4d1366f8,e72a2d81-ff50-4d55-b078-171a00a2b09b,00b9c56a-6837-4ea7-8f43-93692c91d82b,995ff036-c64e-4117-b049-596bfeea5e11,a4434aac-a520-46bd-a358-43d30db0b5e9,cb80978a-0f1a-4c50-900e-8aac938775e8,70a4561b-dcfa-4290-a699-ffc4fb207120,df8dc109-6b8e-48c3-9edd-2ffc7ee4714f,63feb72d-c1e7-4459-a5fc-fd7cb5a90d72,7a0866d5-4326-4773-97fa-30869ae160b9,22aaa2cc-b51f-4bab-a21d-1a67a067a025,a912fbde-810f-4562-ab4b-33d691b73834,d3f3f024-5032-42cf-a423-4e1475d6593f,04a0a1d3-3885-4c36-80bf-64b04f90fd24,89455064-6f90-471d-80a2-e4fa65986326,ac88b9ec-8cac-44e8-baa5-a62345f7f934,5d23cbec-af2c-417f-b207-04e5c50dbf9b,f86b5bc7-4a4a-4b29-b188-6d9d19f2fcb6,8fe6723b-5109-47cb-a60f-d25dc0f9fef4,36e14ea5-32a2-426d-a8a5-2fe0b08cb7db,d7f2a899-6113-4414-b448-b7a61b1eaa65,f0272dc0-f05c-495b-bd35-034435d4b56d,087cc6ef-c884-4215-bbcc-0f788694ece9,8ef49263-070e-4987-bbdf-966019effb3a,1fada185-6c37-40ca-8f79-1cb51ed7eb85,73a5f40a-ed9e-445b-8ccd-effd0523fe14,b4e83f5e-9ff7-4f20-9007-8605dffce375,3e7d7822-a861-44bd-bf96-93d5f662fbfc,49e85b23-8de0-400a-8393-783109c2fe25,678dc0ad-ebef-4897-9d13-d6a3c802ffc0,c891a653-0d04-430d-94d0-f698c958a733,b3df14ec-5a97-4b70-8794-dd5642833fb7,77d81db5-f470-435d-ac11-42a37055471b,bc708552-8f6e-4378-9eac-45352a94cbcc,04000bf2-3602-4b83-b6c4-735987b21381,0b035355-7de6-4dc4-8028-d344138407a0,8b20b960-1c49-41d4-8cbc-52fe7ee00b2d,d96a74f4-bedb-4cb8-8ec8-fd96a93a9e8a,8b95c741-4ac4-47c9-961f-f22b6a3c2859,1f89a938-9dcb-4917-884e-eada1007a002,8434347c-b200-4296-89e6-56062713511d,e1fa2be4-b5fd-4533-96be-a0965c6e40b4,23096542-b97b-4bb2-8d1e-1631471d1ffc,79a13552-0060-4bfc-a927-c7687a9551c5,b304480c-5e8a-4bf1-83e9-be0aa55e318d,9b87345e-3f39-4945-aede-2791b91b3267,ac7f7845-e6fe-42f9-b0e6-0514e4f0d2c8,b945a978-7d84-47e6-984f-3a43c00d7901,6d6f291a-b667-4693-bc39-f434ae3e7056,586b9046-693f-4f36-93c4-77c6a79823f9,35a035fc-fba9-4a6f-91cb-dea7d4db8b5f,e7e0a591-5435-42f2-adfa-1572a9678c1f,0289e414-3dd5-47aa-b38f-da78b9c68427,0ceb5449-3a98-4e5a-be54-03b3bc6d55c2,e7130fb7-fcbf-4a82-ad4b-d6c446bbc873,73c4bdf9-f9ef-4acb-a671-6543d7bfb473,c82fd458-8f54-4806-b3e5-73f0654d1cdc,654da51d-a471-4a88-b5c5-c7d65b1f1a73,af827711-fdd7-48e2-b6d0-f92d971524e8,19c74da4-514c-4dbd-afb4-244cc43c631b,897170ab-d87f-4615-8c68-77e4d0852e76,6e4f7031-fb3c-41cd-b29d-949902f6e89a,1d40d09b-0fa9-4049-b726-335cb105f7a7,e3b09223-957f-40f3-92b2-fb1ad84f0ec9,112f7dc7-9f03-46c9-9613-ad96755c72ba,d85dd5ae-2d64-459d-908d-7cdab312129e,90c75e56-96b6-449c-85c5-21826c609a9d,dcf60d5e-75e7-4986-8a34-a7d2c6caf969,081f9383-8ebb-4e2d-b32f-fb908b22c05d,a17174e1-70af-413e-95d1-b618564b7724,4d65d1ab-dd8d-4277-bf86-5b36ab3dd754,ae326f30-871b-4c35-9564-21031e6a8478,cfe0d7ac-a127-4b59-a85a-b33fd1c3df02,f96f9791-62a1-431a-9e26-8ff8e67c2b11,c75490bf-d799-4bf3-b271-9ccc715fa6aa,6cededac-c0d6-48be-a975-d2c883e7b6b0,ab4e9860-ffb3-4f9b-8c79-f2a1215585c6,0488f85e-3f8f-4977-a73b-46321d77f68d,8181206e-496f-49c2-b6df-625d64148438,064507a5-40aa-4d00-be7d-ec1ed9b8af85,3d1fa0ae-a9f1-4471-ae97-ceaafb22541b,0a888b84-0d0e-4bf9-8e16-61db76fb2e19,a4160bc7-f1f2-4a51-a3e2-cfb9abc964dd,f075ebce-6cbc-41a4-9fcb-f7999be58454,5070fb96-43e7-4c6e-9868-d008d4d509fe,a4f23018-8f47-4379-ad48-5a7cac0ca1f0,5103585c-802e-4a3f-b304-f281559f8c4c,7a88d1f8-e63a-4f7f-9583-33a883b6249f,fd641c08-5fca-4565-a9ca-f9c032096bf3,0feb22cf-e4fb-49dc-b469-4d219cef9048,1d642af9-62af-4ef5-a3c7-6dc790d16267,bd416342-6960-4433-a14d-e20e88390ec1,e98bd248-704e-4d12-9a1a-f45def57d218,8bebaaab-15d8-4c65-8a1f-c163fffbaa9f,596b351a-033b-4a1d-9a4d-45b55a28dce4,9add729c-2677-47b1-81a8-b86a9e2b66be,4505933f-0c7b-4868-8914-33ed01193d77,5a48c2dc-0436-4d7a-81af-ace6cf18b851,bf6d8c85-bc2d-40b0-944f-000ba7484c07,00b7844c-4603-45c0-8525-9b6e2cfcdf31,90c41a83-32f2-4285-8e9c-f66742ddafdb,9c7b3048-d6d8-4cf7-9011-b8b67f50f67b,895aba65-d492-4b16-966c-e4a8f90a6115,56853e42-273e-4bb8-868c-84bf3be5817b,e14d6eda-315c-4775-8ce8-d1ff242be0d5,bef0bba3-ecff-4de6-a366-df0eb0952704,5c847892-c1d8-4b73-8ac1-f1fae741f62c,9400befe-cd77-4684-841c-a82340b91a90,880cb58d-9388-4389-8ea7-01b7db93af29,5008dd18-5dbf-4489-a8da-26fe5f1b1aec,e9304ba6-1e0f-48b1-b205-dc4ddcb882ff,bf101ede-c665-4abc-aefc-3cac06c056d4,b341e12b-26d1-4b71-9f7f-1ce68ce312cf,09d7166a-1fce-4ecc-92d9-7a8b1a9e240f,fe91b354-5733-4492-a08a-822683bff927,f1995d29-f88f-4dde-a790-414addbebbb3,98210347-8075-4eab-a6dc-cd2fbc0dc8f9,39dc3c65-d01a-4e5d-b9bf-e6805c46fe88,51719d56-1569-485b-b2a6-60ff4852aad7,a22303a3-1bb7-423e-9529-e192104dd820,23e891b2-c089-4454-8292-e680ae9f06c0,66a74107-df57-4600-aa14-f1d942fa801b,ce157f37-c738-4384-a793-dcf1e11735c6,75e16233-2e78-4364-8801-5a5afdaceb5b,67e67836-54e3-4b56-bc23-54caf470f0a8,75e4ee7f-e174-4f2a-bff9-d77769a53996,206719e6-520b-4b60-a403-5ca28f6ff7b3,55ab98f2-a9a9-4158-aacc-19041283e64c,8a7b33ea-94a2-409a-8265-77070d08b804,6e47c766-449e-41a7-9095-8d1186bdfe68}'::uuid[]))
  • Filter: ((startdate <= '2020-08-03'::date) AND (enddate >= '2020-08-03'::date))
106. 0.000 0.000 ↓ 0.0

Sort (cost=250,489.80..252,021.01 rows=612,483 width=20) (actual rows= loops=)

  • Sort Key: objectextensionfieldvalue12.objectid
107. 0.000 0.000 ↓ 0.0

Seq Scan on objectextensionfieldvalue objectextensionfieldvalue12 (cost=0.00..191,616.99 rows=612,483 width=20) (actual rows= loops=)

  • Filter: ('d11e18bc-d5d2-4205-8af0-cc8993994362'::uuid = definitionid)
108. 0.000 0.000 ↓ 0.0

Hash (cost=10.25..10.25 rows=325 width=54) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Seq Scan on objectextensiontag objectextensiontag11 (cost=0.00..10.25 rows=325 width=54) (actual rows= loops=)