explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jqiL

Settings
# exclusive inclusive rows x rows loops node
1. 19,260.749 19,260.749 ↓ 1,224.0 1,224 1

CTE Scan on indices_val (cost=470,239.79..470,239.81 rows=1 width=156) (actual time=18,950.929..19,260.749 rows=1,224 loops=1)

2.          

CTE dashboard_setting

3. 0.140 0.140 ↑ 3.4 29 1

Function Scan on json_to_recordset y (cost=0.00..1.50 rows=100 width=80) (actual time=0.113..0.140 rows=29 loops=1)

4.          

CTE topics

5. 0.029 0.327 ↑ 3.6 28 1

Hash Join (cost=8.77..11.03 rows=100 width=80) (actual time=0.243..0.327 rows=28 loops=1)

  • Hash Cond: (ds.topic_id = ts.topic_id)
6. 0.177 0.177 ↑ 3.4 29 1

CTE Scan on dashboard_setting ds (cost=0.00..2.00 rows=100 width=80) (actual time=0.115..0.177 rows=29 loops=1)

7. 0.062 0.121 ↑ 1.0 212 1

Hash (cost=6.12..6.12 rows=212 width=16) (actual time=0.121..0.121 rows=212 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
8. 0.059 0.059 ↑ 1.0 212 1

Seq Scan on topic_spec ts (cost=0.00..6.12 rows=212 width=16) (actual time=0.004..0.059 rows=212 loops=1)

9.          

CTE workgroups

10. 0.706 0.706 ↑ 1.0 1 1

Index Only Scan using "PK_WORKGROUP" on workgroup w (cost=0.27..4.29 rows=1 width=16) (actual time=0.703..0.706 rows=1 loops=1)

  • Index Cond: (workgroup_id = '1ceea263-9e29-4c9b-b41f-de49ffa83789'::uuid)
  • Heap Fetches: 0
11.          

CTE campaign_start

12. 0.009 0.329 ↑ 1.0 1 1

Aggregate (cost=1.23..1.24 rows=1 width=4) (actual time=0.328..0.329 rows=1 loops=1)

13. 0.320 0.320 ↑ 1.0 13 1

Seq Scan on campaign_step (cost=0.00..1.16 rows=13 width=8) (actual time=0.316..0.320 rows=13 loops=1)

  • Filter: (campaign_id = 'ae4f98f5-fd13-b722-2c2c-50d5928391bd'::uuid)
14.          

CTE raw_data

15. 98.798 11,063.188 ↑ 3.0 138,202 1

Hash Left Join (cost=1,043.21..459,021.79 rows=412,713 width=72) (actual time=29.920..11,063.188 rows=138,202 loops=1)

  • Hash Cond: (rm.topic_id = ts_1.topic_id)
16. 0.000 10,961.612 ↑ 1.1 138,202 1

Gather (cost=1,000.55..452,833.90 rows=148,297 width=40) (actual time=27.128..10,961.612 rows=138,202 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
17. 14,661.761 14,661.761 ↑ 1.3 46,067 3 / 3

Parallel Index Scan using response_metrics_idx_2 on response_metrics rm (cost=0.55..437,004.20 rows=61,790 width=40) (actual time=7.034..14,661.761 rows=46,067 loops=3)

  • Index Cond: ((campaign_id = 'ae4f98f5-fd13-b722-2c2c-50d5928391bd'::uuid) AND (workgroup_id = '1ceea263-9e29-4c9b-b41f-de49ffa83789'::uuid))
  • Filter: (party_id = ANY ('{ae0fdef6-ed20-4e32-af90-643165345cc4,e839c0bd-a305-4f9d-b19f-789ea2f26446,6309be1a-9cfd-4208-8ef5-c1741e503389,fa4dacc1-ba11-46ce-9f30-f9f20217fffd,f75efe1c-6cea-4659-87cc-ddb11997e255,04f9650e-8ee3-4e7c-8e57-faffedc3312f,a45a5c4c-532c-4ef4-bb9c-d3f8228f3fa2,5b18b40c-c639-4fc9-bbc9-eada0f6a782b,3cb5c959-e07f-4e37-a18f-01a9415ebb16,dd2cffa0-502e-44de-8012-9f11df42951c,83753b9b-ad36-4799-90d1-e79ab21e21de,dbc120f2-c258-4cce-baf1-88757f9fa405,6530e5c9-23cd-4291-a624-c0f736330d9e,77a22e1a-e4f6-4b8e-b246-db62615b2c33,98720c09-2df9-4760-b28e-62af8bf4b0b4,887d54df-d906-404b-b634-ddc494ec78c2,cc513050-a667-403c-8975-f993a7476eec,83498593-61bf-4bb9-a0d8-02d14f64b3a6,6e71dbae-dca8-47d3-9f0f-ffdd797393d4,5007a8a0-0cac-47b1-8f02-24cb8c042003,4b265c6b-b4e0-4126-aa3b-03ed634eefa1,596fbbdd-53d0-494f-8d92-1624f47ec666,f51f208c-bb68-4a91-8585-f6d8daa70a47,081badba-3487-40c1-ae6a-1c2f526d0438,2b57cbe3-27df-4d83-b7dd-5a367fd0aebe,30071419-60c5-4ebb-9e19-d7b263994f6b,44e3b98b-0ac8-41c1-ade6-cc601ec9a934,ea5adf32-ff2d-4b85-b9fb-8bd49a52ca0a,51c25d81-6041-4ada-a801-3706eddb0e41,73d4de00-dc99-4800-8c9d-e171861900ed,f90c605d-8648-47a4-9a34-310423323561,17f093d5-e041-4a67-ad85-ff2f630a2573,1224644a-9412-4ad1-aeee-67b697b47deb,68628f69-026d-4cbc-947e-4f90e4432089,60305e7c-f4bf-4dd9-b102-832d0c1a75b9,bac93b0b-5bd4-48ba-834a-10c23642273e,b92b07c0-ee1a-460d-8090-606ffe4fc70c,1b876920-74c3-460c-9ed9-d016c54d5e09,3e447bef-6d3c-40d9-9aca-8a2f4be4348a,1363dd32-2d04-4316-bd56-a2db30cfc930,2f1dee93-c6d1-4e00-b5bb-20a8bd227a34,6a17b866-8c8e-4f42-a350-bd7f19660c6c,7247e46d-09d2-4215-88bf-b746615515ee,38d1fcc6-23c6-48fa-8a99-b48aa2aea1f5,871213e1-622b-4c55-8cda-f20d4065c847,55d9ff5e-dc41-4b14-baba-1b5150751076,704b2595-da94-4cfe-8b87-0c5e03c089bf,110afebb-e2b3-4d32-be6d-83a414e981c9,9b58b787-0a9f-40d1-9765-efb2f256156b,061fb89a-f19a-44cf-8a61-3af4e5e6ef10,4f8658e9-4fca-4fbb-ae05-82fe8ec3e35b,1544544a-794d-4b7f-a5d4-4264ac3e9e4b,ceefd07f-751d-43d2-be36-692a5fb306ac,28c2ab54-768e-40cf-b84b-e7ff687a27e5,c9fe2c53-64a3-47cb-b795-3c4df40c0afa,43190311-c7f4-42ba-aa8c-cab99afbb9f8,1aceb294-cebe-453e-87df-201340f8d2db,cbf958fc-34e6-4320-9650-97a6dc0056f1,e9d87c51-b7b4-4a6d-ac3d-078efd72fbf6,6a2764b6-e084-44a3-9d1d-e3ee8fbe188d,d10ce49c-c92d-4402-ae37-db6d9790e0d9,f2d777ac-821d-4401-810d-8a771edcd84e,45d5a660-b547-4d80-aa7b-a09eddf83dc1,d5742937-de01-4ed2-945e-2bfc2c6e97c5,deda5fbb-d4f7-45ef-a557-7104e72832f6,792ac725-63c2-498d-af98-cd4194fc95ee,8b8c155f-eb25-4ce4-8d97-cb9500921090,c76b63f7-fc42-43a7-ba94-9275f09f8191,e5946b58-26ce-4f6e-a5c4-1699ad74e789,e9377aae-31ba-459f-99b8-7691a8dbc979,e6fc6947-10f0-407e-a1c4-583500817c10,aa3a0cc0-b528-4bbf-b9d5-953fd16a4a5a,9d29b714-c37b-4171-adf7-06e1f980fa56,29b1d991-969e-4a7f-99a0-8f32c703cfa9,e16b9e3d-bade-4fda-a135-3ce0dbdfcf30,eb467d26-e3cd-46a8-9f69-fb75b4dd3f53,ac4d029c-a647-47d5-84c0-2350665d3131,3379d661-2bb5-4e76-91db-e3fff1308c66,294d5042-41ea-4089-8815-b86b26a041e4,715bad31-77ba-442c-914d-f67eb5c02216,6bc17f6d-4a46-49c4-997b-cba4a3d1ba13,eb376040-2f95-4e96-8f0f-a869e9995bc1,1da3ee5d-c57e-44f6-ac99-b1b31466965f,14f4f392-f986-4272-96f2-258b6491ea58,e29ef91c-0161-4b74-b965-e65bf486116b,8fe5ec8e-e6c8-47b2-9867-e53bb8766ea6,6a1a6762-fde1-47cd-85a3-e84eaf642366,9338d44b-b952-450b-93ba-6224e440c72e,c1af9e0e-d4db-429d-89b1-8e35210e365b,99fb9f9d-9041-4e1c-9a5c-4dfad9ba6a5f,9bd6ad08-31d9-4b5e-abf6-d8e69e5bf87e,51c56aa8-c4a4-40e9-8dad-056efb5bfbda,d63322ea-5197-40f4-a214-730454de0932,434ac9de-b217-4ba5-a8c8-ce326eda2267,b772ca97-9c4b-4567-b719-b70c58dda976,aa799943-98ae-4f14-86df-83fdc06c943e,8a5c71fe-e233-41d4-a9d3-c50c8b81b888,c2a4f360-17c1-4f93-b2bc-e1d4e35ccfb1,5bd1b795-f133-4dd1-9b71-0b1d7c0e8713,eb7a89e1-3371-4e20-94da-6453d5012bf4,678320a2-2d3b-46f2-ba87-15f07299fa51,d39c2854-345e-4c32-9faa-53929545e7fd,a587479e-64b1-4f0b-82f2-9a84924a332f,653d9cf7-c5f8-49cf-addb-d0ade875b60d,6acf4099-5f28-4ba7-adbf-d31cc17ff48f,8f304980-3f91-4762-aa77-877fbc58afc4,e25c6b7f-de24-4bb9-928d-ef53a7735131,56ab03f3-89db-46a1-a63c-b7c6d5b9777c,2bde572b-230d-48cc-aa73-df64c1d34297,2b9a409f-1c57-449d-aef4-6e88debc8f88,fcda6002-9ac9-46e0-a86d-1e591c4742b1,001d31e1-bd42-4d6c-965a-8f97fd8830ed,482d3b4b-2366-4e5f-bae8-52851070849f,8a71ab02-cb5d-4878-81e5-eb53e346a45d,b67c04a2-bfba-46e2-a60a-b71a592d5c3c,6d24ec58-01f1-4baf-9ac4-deac57935f83,29f730af-835d-4b0f-8ce8-6666ced2bb33,9bf8ffae-939f-4d86-a49f-c29ff1be715a,1db00e08-5671-445a-bffd-6768ae76b921,cf0b1e8f-1ce0-4948-880a-73400a3f43d7,88b57bd7-e352-49d5-ab4a-8085c34917bc,ec2129a5-dcba-4535-b031-196fe518d7ac,28e58da4-0283-4d21-b1dd-ec48be56cd00,8100c1cb-d083-42f0-9adf-78f0b07d778d,1468feea-211e-49aa-b0eb-9e9d0cafef8b,9baf2c3c-de8d-4ed4-9a9e-2cc671157edd,efbc4681-a6ca-4119-8c3b-01f40fa06539,f124589e-8e7b-499f-8265-764e0a792906,0141634f-8abe-4f9d-8670-4f03a90ac201,ab2ea1d3-0d76-4b18-b1f8-01132e82d900,48187067-0131-4676-a279-60988e398473,8b63bcd0-76d8-404f-be05-64495ec30dc4,7cc970da-5a6c-4ef5-b720-a382719b78ca,817e501f-0bd5-4ada-ae4b-d19ddea6c171,8bcbce71-a97d-48a4-ad29-3160e9789365,c40ca8c8-cfce-4b8c-8bdf-00f49fc6fc18,96b263ca-c23b-4ad7-97e9-1173df57a23d,9d84e86f-1076-40ad-8ba5-e742aabf6a2e,b63c7bf5-41c4-4851-818c-a5c11a77ae34,de8f49d9-a3fd-4fc6-84a5-a89554bcf501,9d7429da-931e-4702-8bbc-e138bd8a7f23,d1c3cb73-28e3-4cd4-bf45-ed5a415b5210,860d6e19-fd13-4504-a2a8-fc53c8b93135,c7308676-2333-4b87-af28-bd72474e0e98,2270e067-e3e9-43dd-9c53-34e4dfc5bfdb,db1b97cd-1170-4e40-8f48-8487b6c3df4b,d702778e-65c4-4923-8429-83bf7ae9344d,4295bcde-8d99-414a-8489-02aaa40936a4,10bbb77a-5641-40e7-a976-39dfccb24923,cc3ac248-25d7-4391-8776-97bb000a097b,a4619a98-7274-4a21-9359-3250561e9e3c,b0fec709-5e4f-4849-8819-3d50350c275e,f9dd8da5-2263-4bd7-89d9-10fc7fd840a6,435f88f3-46ba-43fd-82cb-9b34c6b04a0a,4fde891d-0e04-401b-84da-598b184f2c01,6b72f03c-8861-463e-bb85-27cc1eb40a0d,259e4c18-71c4-4b32-bd57-2fba4dbe8704,793d574f-3dba-41cc-8d41-52afe14400e2,79505ae0-819a-4c00-a319-5bda43e1f4bb,0faf00e5-18e6-4efc-aded-65e4fe211203,797e5e21-90cf-4800-8aae-8d072120584d,4fa16103-5e1c-4e2f-81a5-8410a8b831ab,449965d5-a4f2-473f-9347-79c4efb26aef,ed6c4c6e-04b8-4cc2-9867-54cf5c42998b,5c0ad0b5-dced-4db0-a216-ee3c01f58d18,7bc63c9d-c463-4e39-9e62-68030cbc2334,786ddfb6-129d-42ff-b417-3a2b44b9e3d5,5e5d89ab-8124-443f-8038-bf908e989b94,4fa64d08-c525-4a80-bed8-7ab88a444794,b982afcd-8084-45cd-b82e-abf3e8d858e5,eda5940b-ae15-47f8-9876-3f7c2726ad8f,bcbeaacd-1c07-4dcf-96ec-a5ec08f04da2,8be79353-91c7-418d-a7cc-3ec9eb37bd32,cf60ad7b-451e-47ee-a00d-83b33fe691c1,d1b43a83-4e48-4b1e-8feb-8cfca965ca5f,ab0f60a1-f6e3-45f0-b0bf-66c39a90267e,f11d6c49-dcfe-42d1-8ed0-2883eceaa49b,e9e04cd1-20a3-44f2-a7f3-44c1a0702c47,cbd73b94-67dc-4199-a7aa-32311f52cb03,cb8218a8-f26b-4730-9163-59465a1e3a00,ee2ccbfa-1cd2-40e0-bd1c-326f068b6912,67256d74-d9bc-4afd-b026-bab216fb3f17,e119bce2-3291-40f1-86cc-77c79aa3614f,f046c0e4-03c9-4b4b-bc83-49ac2c66ff26,5a07fa55-c545-44c3-883e-e75de06e8ff0,9bd5d66d-6bc9-4f9f-a01f-cfb505c9e5cf,3d40503f-cbb2-4f98-820f-94a18a39d985,1277984a-fc44-410b-bd2e-1fdeaed4da4c,2156352d-f7d7-4d35-89a5-96904187edd1,e843cb58-0a05-4638-be35-4e8df3f1bb7d,ba0144c2-4ab6-4392-bafc-1630ea3497e9,bf43ba81-61f6-40fb-8558-c6a40afcb27f,84f64531-399e-4715-98d3-240d07e2397e,1af17329-ce80-4d75-b42f-b9993c81f559,a687a8b9-530a-4eeb-b24c-3c673fdf7789,3b49f2f6-22de-41b9-8fcf-a6cb6c707e24,386b12f1-b30d-43f7-9500-e7fd4c7536b9,1509a55a-f235-4625-af1f-c5ea3c3b9ef2,b1b7ef69-f025-4e1e-8085-598dbacd7f51,7b8b6c8b-3725-41d2-aa04-577cc5a5e2a1,52a71610-39ee-4b91-9e9d-75e1ed417150,b8bc7d32-3a8c-485e-ae70-d0f62fd33bd3,8c4c6148-e99b-4868-ab87-610d7a747552,7f57a76d-0368-49b8-82d3-b19a1269ffb9,0144ee85-94ed-415b-8d0a-0f213afaf9da,507ed812-76ea-4337-84ac-be8b09a0fa20,65a2301a-d036-4ae3-96a5-50f2f3514ca1,5cbad350-3d08-4ec1-9c57-05dc2ce5cdb7,fc0b5765-076d-4d24-a5c0-77ffa647ba2b,3199698f-cea1-4c9a-b841-82aec79ade9b,677a5234-f659-4a0b-96e8-769f0a4c2ab0,83f27e9b-527a-4a22-85a9-91f2ebbb9ccf,2e158cb8-9385-4e1a-a64d-8767d2bdc859,d3abc19f-25f1-4336-a145-1aaa51056c0d,4a292025-c795-4a2a-9fed-62a140921406,3f8467eb-0dc8-49af-9efa-1718ef022d59,846b3e43-4c2d-4c11-b328-70a9a7ca5335,a3a53750-16a5-4a95-9f40-e4bf77b414a7,68e88cbb-32ad-4efd-962f-c390e8132d57,705fc169-b975-4d51-ad4a-1e97bb4c0b41,5d36a697-027b-4d5a-9a4b-3ea325ed9550,309d3c04-d674-4d80-b94c-a6f5fbad3fe3,f8b3b8d7-af2d-492a-9ee3-d40e121e805a,775b3771-90b3-487d-9845-0f200c5ed61e,08c8360e-4320-416a-a775-023e16cce7bf,7968a44d-8129-4eb0-95cc-1608023828e4,9f630d64-49f5-4c14-8257-017a19289d8c,6d1aa36f-925f-4c70-a0b5-399706fcf822,51f47f84-9a18-4864-8ff0-e961a5e2e13b,310bf77d-2c26-48d1-bd2e-6032385a0a37,4e0ee0d6-8710-44d0-8c0b-e74b894ff7bc,825d693b-ecf9-4057-b9ba-f0b3af94f084,22b1da09-4364-4c30-9ecd-30171040ed40,876107ba-338d-4e1e-851c-42f6c1427d1b,2ddd0665-b065-4a2b-a1ed-e9484200962e,848db71e-10c9-4e76-a15e-d6036034f9df,3aa1a9ca-e83b-4d32-9a3f-125d2042db4a,b2e9f35a-c7ff-4503-ac6e-b96e0d33521a,7066abe3-6af7-4c8e-b434-a29f5bd4e300,1ed87682-8236-46f1-92d1-ca6a6ecdabda,de0c7939-2551-49e5-9940-63bd323ed2d8,a65b40ef-f694-467d-8748-04fdce00df37,a74c4589-b671-4938-bf13-83a1d6741ed1,c589f92d-6952-488a-a1b0-4492668e5b0a,5cc0bcdd-de7c-4aad-94ec-f9e2cb7be839,c18dc67d-d08d-412d-a4f5-ea4b35ca839a,046d00b0-e1a4-41f9-b3be-9e900069cfea,42e1c8ba-129c-4560-8541-b6ec72a162a2,7900b0bf-209a-4724-9f23-13a996a97d41,8ba5197a-2adc-49b1-97c7-cb0d3e3ea04b,0155111e-6a84-4214-8a22-96759eca74e8,1798f66a-e0fe-474e-8d01-64a5418b68c8,0a56bed5-c9a2-4bb7-b52e-6132fc61fd96,575d6140-b6bc-4a6e-88c8-26dc662de83f,0904fdc7-6da2-46f1-af57-66b8e9e6dfac,5644d6fe-4848-4a2b-8a61-68d103cd5cbf,9fb0ad3f-5d6e-4243-9fcf-e048076316b3,1369a579-d9c3-4862-bb80-351d774d7bb8,c390a8ec-1da2-4c9a-8313-d29d50aec2de,7baba984-86dc-43f2-801c-b402b8751747,15432774-3810-4e00-ade5-e16623a728c1,638a7955-7c1c-4175-943f-62241fe72595,4c69268c-f62f-4fcb-a8a0-8201dcc3378b,bca5baba-f729-46aa-9bb5-8b788bd97b89,d3e8988f-d2fd-47f1-a793-ef54631e0946,15c2482c-cea6-498d-8c24-da36d68d6098,9420d25d-e19e-4304-a839-3c27c3bc4456,1413731e-eeba-460f-a50a-7373c9381ca9,99b336e3-9550-46c7-a9b3-f926d75cd931,5bc7ca57-1109-4357-987a-341016d35a3c,c80c0ef6-d2b0-4902-8ea6-55d44ede0c34,a01364b4-e4bd-41ef-a235-dc8d55111c03,35fe4f04-a52e-4e39-8cbd-c621981a8906,c232d28d-f1e7-4d12-9607-fdd748bc1254,d01c6e3c-7a95-4647-b311-0102767e8c02,57c3de79-7a94-46c7-a6ab-0152b853698d,b213907e-ab0f-4f1c-a506-99a72ff0e003,34001308-be0d-4df0-9258-a3f539758cb4,dedda873-283f-4f1a-aa4b-307174eb96e0,e7aa9cd2-e752-4ab2-8387-0655bb3e32bc,e4fbf58a-e68f-4eb3-a93d-ac345ade907a,5fc6c5f2-503f-44a8-8824-877a29e6978a,7e90b836-a61e-4be3-82ea-243ae23795a4,dd87591b-836d-4a41-baae-b6caddbf63c2,29deed9a-3a5d-470a-a8af-0b2a552fd80d,97a0b96e-ecd8-42c6-bad2-09bd3feb4d04,66ded87c-a353-41c0-8781-2c4b61c4f325,6bbccafb-7d1d-4c0b-8da4-bb0e82bb2273,d33c8bfe-076a-4524-9511-34efe71ab8d6,80e1014e-1720-4b44-9ef8-5ceac92647b6,97efa80a-4ecd-43fb-a289-289abc60ca94,65fa2242-46ba-4c46-b44e-acddb5b6db98,67717835-15a8-47f8-adcc-9ff040a1e7a0,b5045bc0-6a2b-437d-885a-5eff6029a8f2,0f886b1b-980e-40fb-a83b-4233ead3724b,c0a2bd4d-78da-4def-8adf-87a49219245d,51bbfddf-b858-4f2e-b6a3-517bb1b1b8d8,7f33162d-c506-4f5b-beaa-cefe330cf2ec,bebf6f65-4ae6-438e-9d6a-2b9aabc873c2,db2b92ea-3496-4315-8f41-6320d3558264,ec68b5a6-52b6-4082-a582-476e58bf90e0,d2bc61dd-94f2-4492-9675-d54bc026f05f,6a3db355-4499-4d04-8c99-d10bc4ce2d18,e9e8adc9-b54e-4976-b297-e23aa2df6832,7d5ae676-e253-4d77-a05f-dee0a4a39c3f,3b96b3dc-94b0-4542-8f49-98606452ccab,b93612d1-2bc0-44dd-94b4-cc4676e5073e,e62059ab-ff46-4e0c-9eff-2decdb207982,09c205f5-78ea-4663-8890-831607f4cf62,dfa99abe-f5d4-40e5-ba3a-c5ef9c550fea,ced0f46b-c063-493f-b8e0-5b42253d4c36,73670df6-edc6-4a67-ae1d-4f9d37e3cb27,f5a120af-6c69-48ce-a182-a8b742962901,303d28dc-a3dd-483a-9a29-502bdcc26c69,8b96868d-1a4d-4514-a9dd-89f49180c4e7,656976e3-e853-4cee-a124-2e7e712ff493,f886bb8d-d47a-4a33-bb39-b12aa8ccf50f,8b6d199f-6a93-40ea-9e24-c6dc145dbb28,1ba63638-389b-4a8b-ac39-7e5a40338a82,01d4ef02-07b6-473a-a179-ec319584908d,f536c2b3-a0e7-4d05-91d7-536a00ae29ee,665809e0-1fef-415c-8905-eea6c3678f51,5da21f29-63d5-4536-b76c-ac121b250329,c47cb593-25a4-40c5-ae5d-440289817f19,81e47ace-360e-4a35-86c3-6f65a5c7687c,227418f6-c4c6-4a89-b4cf-81cadf28e5ee,afe982c7-0453-4e72-833f-f2789d50dfee,cc9e6490-0597-4607-95f9-8ac1d6f6c455,e8e154ae-b54c-42e7-a404-c2262acdb5a9,f23010a1-6155-4010-a1d2-e28e45e76ab1,cdaaccca-99f1-431c-bae7-4f1780207e61,6ee0995c-12d3-4e15-b460-f70f7af1e182,2c249938-59fc-4d01-9e16-cc1709309217,497ad9f5-eef4-40fb-840d-5b2810d6b9bf,70543812-7abc-43bc-b608-379a0592cde6,f3526130-6c3b-4284-873f-cd75442e027e,fb3bc2f0-7e72-4c9d-8492-4aeffec41801,ab4e120d-7ad6-438a-b118-1bd253093d79,f6b77287-9198-4f8d-acac-70ca6c652f2d,15b6869e-10f6-4f41-8aec-692aba57ba30,639a04fd-b801-4fef-a27c-6fe053f4a0f6,b63af298-5585-4287-917a-da9272d385a1,d2cb1940-3153-48cc-8c8d-d2cf70332948,bf58a8fa-ec84-4fb0-b00e-c8333ef93925,3a281947-62ab-40a7-9d03-5dc3b7eacfb6,e64122c8-ce06-475b-9805-6961ea650cb2,d5c44e0a-8737-4def-a995-e4ec221cef1a,fb6360c7-9b5e-411b-8f03-02e135d107ed,88281f35-c34f-45dc-a730-772751ff6df5,871006f6-f868-454c-afc9-466e96bfdbea,7d7d82f3-8f3d-471c-99ba-077bc5dc82e8,6eefd974-8d12-4759-88f2-cb42c573158b,e62f7bb7-c14a-46e4-8c23-e46015aaba85,d29b3d9c-fad8-42bb-877b-307f03820d29,df8f9be1-92ec-4400-8775-53a9cb2e7eb8,e695857a-44a8-4c93-9d11-4a7d248d55ae,43d6600b-aa14-436f-a56e-fed99477980e,dc4dced3-d2eb-4f6f-9166-3b5acaeaaaeb,cb4a7506-1886-475d-9469-bd9589f499f3,cbba0bb7-55f8-4c13-9442-8d5a2b2b2e43,19856d02-e43e-4bb8-91bf-2df91aed0875,f62ad370-be99-4a5c-90ff-e1bb072fd47c,00cb11e6-017e-45a7-8f55-390d5d761c4d,1e78508d-deb7-4638-b31d-34603618b2ee,b4a036e6-711c-4fe0-a468-e5e475499ef9,78168794-e178-4118-9a7a-3302979f321e,38178ee3-9f61-47e4-bd2e-8547cda92661,88490675-7b4f-401a-8938-b57e63702441,4669545a-abf3-4afe-85bb-328a075315e9,d1b282fd-5223-4335-a779-be4ab3ec5b55,21e3e306-4d52-47be-bf73-6e78878b3004,b6cb8ede-f8dc-4f2b-bff6-6b805b601e36,ea1d0039-a4fc-477f-8b2e-d3bd756fbbe1,e780c540-de36-476c-99f6-806eacd8bf9a,553622ab-6559-4b4f-b929-296da145bf8d,da261097-4bc8-4f1e-a1ed-1eaed03dfd70,e395d78a-9468-4f00-8ee3-373a82a1d419,b7376c8e-4ec1-46a6-af1a-227582bcda9b,46e7465c-8f5a-4b90-acde-22f912157adf,fc7fbbe1-41c2-4ec1-b73a-d769c22b46cd,4d50b8ef-a835-4aed-93ec-9dfd484541c2,83da4946-b7b4-4df5-9ac4-6f93b213f89e,2cabf862-f6b4-4d6b-bec1-da53b6679d4b,c45a4a28-e8ef-4dae-8019-9087d46d4d9c,6bfd4d7d-9e94-4e38-8fef-7e4728549722,b87eb429-516f-4423-8616-70260d67c389,63f6dd8e-1843-4d8b-886e-c477e1b4ad5e,3be886b3-c3a5-41a2-99f2-93308c31a4b3,15a4c271-306e-47df-a5b5-451c654cf9ea,013e1dd1-f6f2-4ae9-afa2-00d17a8fdffa,432cf3af-983c-4aee-8d13-80099b85bf6b,86ae43b1-6427-4885-8545-e713def909ef,7543cbe6-c592-45d8-9671-ef528d6a8003,cd338df8-5fbc-4160-bd64-6bc90607484f,d6ffa014-4c9a-44a9-862d-0bffea1b66de,c794678b-60bd-4002-9732-09d352b2f996,ba3dad38-4732-42cd-84c2-bd74fb4cbbcf,33c04251-2274-4fff-a5ee-dc4fcd287efd,80eaf06e-ad54-4c66-969d-6964260c2eb7,74e5ba1c-e4c9-42b9-aaed-5d9a46e14bc0,6c4863e8-7cee-4ba7-aef3-0dd3489bdde6,8b696b7b-e355-44d7-b71a-16e429f3d1e2,1b1a5401-02f4-4890-8b69-98cc33888669,68d97f56-2278-4168-890c-8f4986a92be5,157859f0-1b8f-4b06-84a0-3a81bcfa6d81,5c2541ae-4eb5-4d07-8980-f4ab9c66097a,93889874-baf2-4a05-bf2e-22026499ea7b,e6f6a557-1117-4ee2-9b6d-df6c37d3aa00,fba99679-d079-4565-b291-288a6bab5fda,d4f8cb6f-f27e-4c1d-8971-86abc401b167,9390dad9-def8-4b05-9b29-0e2f7f14f637,03843b82-8343-42c9-ae24-cdd69548087b,d1374cff-0003-41e6-b1a4-b5ca193077da,ce158cd9-b6d6-4262-864c-b3fcb63554e7,bf829b80-c928-42e2-beab-11d4439e8fbd,be817d42-33ab-4225-a0c1-e468ca772653,763c0723-0424-4d7b-b834-275288e8f147,133b9c6c-df6e-49c8-87c3-d92d414522b2,20da99c1-ee7a-49c2-a924-901e6be646ea,6deb88f4-94f0-4bc0-987f-220f3218ad20,98ed178c-9b73-44bd-88db-3c643a4c853d,684c445e-43f1-4143-8ca9-83533ea91d5f,9c092359-bebc-4f0a-bdc2-5c27002651df,3579f30f-180d-4ede-b898-a1de1797b256,3cd9a0c3-d426-47a5-8df6-ed69f983b5ea,a1e8dcfb-60ca-4574-8fad-ba23ef9263d8,f1ded1dc-4b2a-4394-9b94-27fbabc1e2fa,626eb98d-fc73-4d83-bbb9-586897135aba,e45b752a-e72f-449c-af2e-f85bd73417f1,4a615d41-3def-41f2-8938-7ac56d1923fa,07e74e7c-ef5e-44e7-b0c6-9d46eaa47712,356848b4-dc62-4834-951b-5c6b4f2d4cac,dc4f6d1b-0785-4c16-8667-26e172c748fb,2e05df90-1d4d-4f09-b462-9187982b48ee,a981f8fc-5792-4b26-999b-db6c0090b628,615b5f45-0faa-47cc-8a21-a918498ef999,109ac58a-97bb-4db0-8663-7cc55706e170,1f628aea-6ec6-4b41-a788-0d76718acd1c,5b1a9f31-58cf-40c5-8a01-0f97b28096b0,f3d2b4ff-a283-4012-bd96-8790d4f00a8b,fc194e24-013a-464c-9b73-896dc1abff20,5993014c-4841-4aac-afa4-265a160f5cad,b4577bde-0169-4650-84d3-792d8b5f2761,a53d50d5-3c5f-45bc-be05-2bec229aaf0c,aea8ea69-9420-4923-82d4-aa56bb6f16fa,5020f127-0b73-4753-80a8-be18298c9214,b020f0ce-a7e1-44ad-831b-7b8988446bd6,58afe001-347d-4541-a534-0f8a66fae14b,c5944d11-4e63-438c-a719-6f2be2ac64a3,5f5508fa-ba17-48fe-a396-d5764dcf6670,356e60fc-2116-48ed-b4ea-076c8b86e8ed,0e28b447-b1a9-42d4-a63b-c43d574096e7,a52779af-dc4f-414a-907b-2c096404a514,0ed4433f-5399-4454-b55c-41850837efb5,63abe02a-3c1d-4838-ab81-8fd2bde802d9,3b70f68a-22a3-46fe-8505-1115a78c6b5e,cd2d6d10-5858-4a26-b1da-bbf4397667ad,1ef56e1b-d964-48e7-b482-05c098bceb27,c1e24855-b742-490b-ab5d-81b299172cdd,fe76737f-134f-483a-ad68-2bc33326c36e,bb147b1c-821f-46c7-a89b-479f19735ef9,e3c5ee79-cc64-4e49-9179-5ec61d37e33e,75216d4b-1da0-42b5-b04e-f02be98de35a,d3a47f9e-6a51-4c25-9a5c-c23523171536,b526e15a-5cc8-4137-b09a-fd3c94b7971e,fb994a30-b2dc-4670-b774-8dc67b442fc6,4442e475-1aee-480a-bc8d-43666bfbf257,80c4f5b9-3c3c-4597-8169-5fbb04951824,7c871afa-b604-43a1-a0c8-ad8d1e959364,c3d7c273-74e1-4a93-8f13-5e23926754fe,af24c950-86d5-4f6e-b450-1c2e29e7573f,ada228b6-b7d7-4386-b855-3efe955587cd,7396af47-9ac0-4ce4-9c4b-d101a5f9ae97,0afa2884-85a4-4937-a3d0-e3323c143933,c77b1652-3be9-4f68-a20d-825912a21fa4,ea5c58d5-a021-41ab-b78f-23dd76ddf54d,72a4f523-5994-4b89-8707-b1fa168bae30,427ca547-21e4-4170-a9e9-3e02236e34dd,16915a5a-390e-46ae-a496-b51afc5d05a0,959fd6cd-e07e-4e87-b675-f3c494ee49ae,8c81c0a0-5331-4779-afe3-bd1984deaf1c,f6530b84-60cb-4f8d-b122-754854c6b264,dd0f77eb-5dba-4148-a6c7-d7abf1a48a46,d03dd1b8-ef33-491c-9405-c0ba7edaf19e,2ef2c2c7-d21d-4a27-a9a8-dce593322fe3,cf093184-aa58-4213-b372-ef300b6d5911,db79ffe4-5ea2-4523-90d9-99b5ccc82856,6fd585e8-753c-412c-86d9-1464249ed0fe,016f4e9e-c6fc-4f70-9394-27904ce27202,64b93c29-ffa3-4839-8325-2f0449a500e7,3877a160-916c-432c-9b6e-b4db98f39a8e,375eedd0-a5ef-4734-a5ef-7d4d99171850,38ce4256-f528-4557-9886-0550ccf9bca6,2dd5c5d2-abd1-4c5a-8dc5-75bfdffbdc63,183a574f-a47a-4c86-b1de-7e8fb92c8bbb,8f33c236-e797-450d-adae-fb2d1e49b172,a3d3ff1c-e448-4d84-a441-d618ddfd9e9b,1baf06dd-bae0-4559-93e1-7d1e1df44583,dc97de7e-681b-440b-b4bf-04b9fb083ecb,0adb21fc-963e-4402-b453-1da3362d2080,08a55cba-455c-42de-b037-3cfaa96e405e,2730691f-04c4-40d7-a0c1-79e583575898,84a31c83-944e-47c4-800a-e8ac841331f5,8a24e19d-eed1-4e26-ab2c-e85408574000,4b7ab5c2-72e9-4ab0-9fa8-726bb8cf5868,6e1a85c8-3d34-4c51-ab8c-9fca294dadcc,c05e8a87-0f48-4d53-89d4-8cef63b4e620,bff4c71d-34c3-4bc8-b1fd-bc3df892827d,a3a31aa7-ebff-4279-a633-0b3c9f95d8f3,cd07e116-7ea0-4487-ba90-df9933842369,a7e4096b-6569-4817-bee1-4d949e1c1498,be6bb8e2-af95-418a-8d3c-5591865a970c,63edc332-4b96-4e42-94a1-883aef4fc9d5,b7601b81-11dd-4979-bc52-c728e0d50ae6,7f442259-c698-4f7f-b7b4-229b7550b876,b3ff5779-1acb-4a5c-90cf-cae20f6ac7d2,c3e39841-a329-47b8-a96e-357faeafd029,9bee69e2-8065-43d3-94d6-fcbeefb28628,3a571ba3-4e51-40b9-bd2a-11696f148d93,a44b07d9-1212-473c-b52c-29f2efc8d402,263e2641-162c-4c7f-b94d-ee839757f5a3,6c494769-4441-4f29-86b9-2da79b15c2a2,c1ecf831-a931-4640-a32f-e21ecdafc07c,74b9f30a-457f-43c7-bff7-678fcaa248bd,0d9437e3-7fb0-4106-ab62-53cbbabbb4e1,84e12a3a-fde6-4076-b1f1-f29bccb25efa,f711d9df-4f1a-4334-9f54-b0ed9c2472b3,771e0b5d-d4cc-438c-a43d-0de73eb2e463,ecb6eae4-50a0-4d63-9923-fe551f863d8e,998160a1-5ac4-445c-aee2-ed2934d3ec9b,727005c5-2b62-44ca-b42e-9ea4c80fc451,c6768be8-b4b2-4664-87cb-4b4d6ec90177,424a01c1-fe0d-4fa5-9d22-2918ed78ff5d,927e8551-b168-4088-b947-ca355ba3ac02,aac63934-41ba-4fee-aded-6f36ee5eeb8d,461d7b57-57e5-4c27-9eaf-fff640766a07,ea37e911-6ceb-4381-968e-4fa3c40a4bee,34f670c9-7d74-4199-a9d6-95e05a190170,b4d87e16-9cd4-4117-b1a4-8b4c6efeae51,3fb01d15-58d6-4ddb-9775-a53578677c80,b4eb7209-050b-47e4-b44b-8a70e0dc4427,b1cf9d03-5aaa-4ab5-b472-9664ede03ef3,a90eeda4-974a-4e6e-9452-4f06032eea32,404373c1-7908-4c7f-8060-03e4a0ba359a,9e2ab3ff-96b0-4102-8991-52873f3e8494,f6665415-fdb1-4e37-942f-01b80321df40,24001c28-f6cb-48cf-90a5-4e9276a508fb,8288ccde-7a98-4612-9eba-8d07ac14aa47,80818356-6635-40dc-8e6c-926a85c87589,5ec67b28-06c9-4560-9a35-0138fc1dc90e,7ada70d2-bec1-417b-9c9f-d9dbd45a7882,e34d8e7e-19bf-41f7-aa9f-64c5c6d76a18,d1019eac-ee65-4ca5-aa4a-80132ce63a1e,9ab3b2ab-2447-4ae1-990d-0105a37f847f,51afee57-e426-4cf6-a1c2-86000652eb74,4a296a9f-06c3-435f-afbe-750eb7f8df6d,42c3e23a-a60a-48d7-ab74-75985ba6497b,f4416707-3f81-4aab-805c-3dd55f3c2d7d,cc7f1d53-139d-4142-bcc5-c60187907c78,59b39f03-bd84-4205-b651-5eea4a4dc49f,cfb67d23-a12e-4c2e-aaf9-25666bec9e0d,d4fae18a-a7f3-4eed-af93-144968c69096,dc81c12a-d04b-435d-9359-6b6cabb1931d,59289e30-b13a-44ec-953b-66fdc474bf31,02741107-c814-4b3f-a283-297d146001b3,3813fb2a-e5a3-4adf-a056-e6f1dcb228ba,9715b6b0-2374-4bde-8e0a-5a41cd80d4e2,3b11c2b7-ad6f-45d3-8eb1-b2b232450c9f,2863d9bc-2f4b-4991-a81b-1d5a670be714,3c7b73dd-8ff7-4483-b369-802f13fc04ae,f7fdb531-1908-4a92-8cfb-9f8a86f07d76,f10c93a8-e198-4b23-8a34-1104819686da,484ad75c-2a55-42eb-b4e0-485a8704a607,73173143-649c-403c-b8da-cc7400964d1d,eac81f3c-298f-41ca-88cb-907152b512e9,3ab06b8f-4519-49a0-8587-e834a31ee25f,6e3bee8d-b5f7-4981-a682-5df3505916eb,cf1fdd16-6dc1-4802-96c1-91a7280ab3d6,4b9d231e-867b-4105-9912-380d1273c19b,6acf49ea-2322-4c5c-89ec-71e6643d4b75,fa6ee6cf-0759-413d-84c7-6dcf827c45b4,881d337f-18f7-4965-979c-c2453ddde13b,77248888-fdb0-40c1-b62d-d04a5a51b28f,7a4944eb-cb1b-4eb4-8064-97054f7f5525,cfc717ea-234f-4c00-b8f0-56bc23b58804,afdcd642-28d9-4932-b237-39221e3793aa,e37d7efa-4e95-46b3-ac78-e720dec3884a,a8e96fbb-b309-4770-b0eb-f3d9aa3758d1,de135083-dcf7-440a-be44-d94780523ccc,2a86d9ce-b2c7-4eb6-a068-be5b4bbfb0b2,3d0079ea-1dd2-4d22-83c1-fe1ed17b2911,78243e5e-74fb-4220-9082-975ff31635ec,14d6731f-c3f8-4818-a9f5-bff5ccc436c3,2c81b229-6fab-4090-bcd7-d365b2c89bd8,80c8cb0d-2a58-4c6a-b85a-1871556f3bd5,e227e0a7-7e27-404f-95bf-0ba514d2fd71,816e28cd-bb59-43eb-8279-2438dcbe96e5,6711f5e1-5b8d-4163-9887-80309739ac81,a1c75acd-918d-4cf3-a8cb-e325bec348d8,376033e5-f369-42f1-9faf-92823297ae02,37c4fceb-abce-45c3-a7dd-80ffda180b13,973fe5ca-799e-44a6-9b57-170162a79cf9,64e49706-55ba-469d-98fd-ff91daa6e45f,13a620e9-0db8-497a-bf9b-b43984aa5c58,53167556-5379-4657-8ab9-69a564517742,648e8ed5-99b4-4e0a-b232-7855b7941397,398ed1cc-8dac-496b-8fb7-fd148cf702ff,8f806fad-d315-4e17-8e6a-3cacc7370295,8befdf50-e422-4395-916e-7a09c484e9b5,1783006d-3b0c-4f33-8be8-1354e24b9637,0c0dedc8-d4e1-4cea-bb96-3f9b0d8697e2,ee21eb5f-6804-4ce3-b1bd-c893e9443997,7ae92868-d322-4215-b313-21062c3cfb95,e832b1c5-bb0c-4022-b8cc-5f90f6c9f3da,6dfc5d47-09f5-4269-9baf-2c3cf9a56b2c,75956e79-335f-4ead-b662-5e8b2721e9c9,04638928-c3ee-466d-9f88-96b0ac32c913,045639ea-4964-404d-bd4b-712b5dc396b0,4f0620c6-3800-485a-8230-b1df4b15506f,5c7e5a48-923e-4b44-8a27-725fc9b8adc9,eb77cb86-bb14-452d-9a6a-2e55fa801604,2eb1619f-42dd-4aaf-80e8-799e9496a176,469592f9-1b62-42e3-8043-15dfd6299b06,3ca34256-c4cd-4077-b70b-e983755e47ee,9fcf7260-9a21-4847-be9d-93405bb2cf7c,8d748877-91b4-4ed3-99e3-fbae382744d0,414c671b-bc43-45cd-a1ad-073afa046db8,7a639265-cb39-47bb-88b9-29ed4e1e6624,5e0f187a-4835-48c8-bca3-14fd8652f9b7,c9ebcafd-6509-458e-9805-95c04290ce03,24badc72-3097-49b1-ae9e-f9fb6c118110,590e3962-1fef-44b9-8eab-f61facd6eef7,99cf3b67-a301-45f4-9702-3650f29d75fd,a78bbd33-9f46-40c7-8b01-6a00b4840aa8,1ee263a9-7599-4f03-b98a-655e155359e1,22d0c717-2151-4730-9e95-6dae21fa9670,20245ec7-3b88-4c81-845f-430c3ddd39e5,be67bb36-be36-47fe-9474-ba4054d9e2cc,67b581d4-6816-4905-9d5b-9fe3e5213fd2,6d9befa9-657a-4ab0-a34d-190f0a824152,8d70d14b-31e1-4d12-8aa1-8ee7a2dcf4e9,937c7061-3593-4526-970e-28e40395f388,9a226370-955f-4ad5-ae44-48ec8995978e,0e6a64e7-ecca-4bf0-98ae-f679aeaf11cf,bca16d0c-5b71-4ab5-97c8-2d3f79ec62ca,e0167121-d70f-4a67-9f29-7b7096184061,2ec653e0-95b0-4043-94e0-99f5d63f307e,b3e38600-8817-4d65-b938-3b4ae9a41e01,ced1f300-1d5b-4599-9b23-af55e854b5bc,99b169ba-d3cb-4f71-af34-2afeeac777ab,c88bebf7-94df-4c75-bdf0-220147ea2ca8,911fa308-19ac-457f-88ea-71af8ecdf95d,862608d9-197d-4a2a-83aa-fa0c2d5a3708,2762bf1e-baca-43b8-bd6f-b7182370b401,07bc6093-5129-4819-b72a-0a9454259854,32a16d66-924e-4d7c-9501-1d69763f151f,1d7ecb72-a3cd-494d-8cd6-b6206b705a5d,53aef26e-7f59-44c6-874e-d4351a141039,53720dee-53b4-4e8d-b0aa-ad21e8ce9d3d,30061231-fc86-4ecf-9de8-6e6d9f9b4b9a,465101c5-3dc4-420f-9bd0-b6302966c8c3,951f6c27-4445-4af0-b147-b03a123cf6b5,c70a111b-65bb-4330-9901-8227eb924b43,bbc379a9-6b56-4ae0-96fd-3a284980ff24,c83c479b-14a8-48d5-a671-c5fd11ba2afb,211ff1e7-a67e-409c-8c89-fa537285866b,a3d60675-0768-4f24-a297-cce3f825ebbd,8919598e-7fdc-4729-a248-567de6efffed,591c51ac-c5db-4629-ac89-5ad3ac5f162b,54a19ce7-f7ae-44ff-b641-3ef4761a3659,1d2834d5-f706-41c4-b683-128d3cc552f7,b4e60d99-1c15-46b7-ae5d-97b7173e5dc4,aff9ca1f-2ed8-48f8-bc71-1d799c62173e,90a0fb83-bf54-47f2-972d-db0fe7400747,d4192ffb-f152-4847-86ac-7764c566b12c,244da432-cc55-427f-89ea-233448503372,aa023bc9-fe57-405a-9efd-31e47ea574a1,49bcf8fa-45c9-4fc9-8902-0dc1ec008859,fb6a9000-4c74-409f-849b-d0d24b13105c,23abffea-c898-484e-a4f7-afbf7137ac4c,8e77ef03-966c-4fca-b51b-139b2ee7a272,ac296d98-d5f5-4735-bca4-12c27ec244d7,8cd2d594-6f54-4ef9-9888-dea93e843dfc,2aa4110e-1acb-419d-8451-8cb41b065eae,28182f25-b45e-4bbc-8237-855c1b1b2707,8fcc8b85-0af8-4f8e-b71c-38f005b954bf,798e70f4-67fa-4b49-98b2-92c052e43687,b7e51bfe-1245-415d-bf09-6034ec35cc4d,082db034-c7f5-46a2-89fb-ff1f7ff0e457,8343edfa-e7d9-43e0-aaaa-dc67ff9dd119,ee5035c4-35bf-47d5-841e-6e12aca5cfee,8252ddd9-6599-49ee-a4e9-fd27746fb5a9,e1cc3859-c54f-4bc3-a2a1-f2aad15d84bb,bd901546-8150-40a8-aa0f-51a82b3a2d59,dad1ffcd-0fcb-4f11-aa3f-091d099aa142,0632bfd7-db4d-4ac5-bab5-b7ab904c3e46,02a9fcb3-da0d-4aa8-9474-635c183169c9,747d3ccf-b5c5-4980-bb64-6ae8ddcee5b1,0a982709-e637-4f7d-a2e1-73b5f32b7a1d,03715e4f-f97b-425b-b614-c376c2c16e84,bb9bbe14-e64d-49d2-8e4b-8f31e4c983bc,eebe099e-d160-4057-856c-f55fab3c4adb,cf73bd0c-86c0-4d54-ba7c-087441360b6d,2b29c12d-8e27-4990-9440-2786b88301a3,8803e0bb-45c0-4639-af94-137fc29f3f40,4fec8417-bffb-4e89-be4c-b1281669b36f,9831f573-3540-4697-9306-340c8111b6c5,252418fb-95b6-49f4-a528-13e8ca61983e,3986eded-5b31-4789-9a52-f431dae94f76,54c07f80-f2d5-41df-9bd7-e97430d02ad2,123b21ef-398f-47d1-9be6-f0750dead0bb,5a55eb40-f149-4c51-9237-a963c4a26d11,01c4933a-8945-499c-9992-2ef47362bf07,8eedc63d-20b4-48ed-899f-b8143762bd95,66315173-e245-4b06-8c26-e77059cc3426,c8225f4f-802a-4d46-a5fa-98d7efcb187d,8037df86-1093-45cb-9732-b7b8f489c23b,eb9c7466-10ea-4b97-8343-e49757cacb95,767d55ac-9b2f-4b3a-8822-6462436131f5,77597dd5-1b65-4d37-bd7e-e1d5be1ff87f,6327c5a0-abe1-4345-805d-1c260c4ecaec,6cbfc6ab-eac4-4003-8f53-8783f2a1221d,82646c82-b692-49e0-a252-9ff012506c37,61c435bc-66de-47a7-b9a3-bf35c4bf24fd,a078e9a3-49b1-4f49-b866-e99f70594938,fe49567b-18de-4bfe-833f-6e397a25de40,aed200b4-ac22-44b1-83e5-2657b17b4dd5,04b3b7e5-3835-4c1b-91d6-509272fddc6c,09024897-5e89-4211-9dbc-bbfe756ceb83,a3e20be3-dc05-496b-944a-097a68e7dd83,6559c270-605e-4f45-8028-6f11fd4b3599,8b73a855-21ec-4dd0-966a-696c5392fbf3,29e1fed7-1a4c-40e5-b7f6-81ac62fab3cd,1e9ca4ab-040b-4e87-b474-0032c05b19dc,5ea92cc0-566e-4e54-b0f5-4b264aea22c5,cd35a3b2-9ff7-458b-9359-8cbc9513391d,7d238c08-3d59-48ba-a4c8-b1227e646aa6,788870a1-d78a-4442-af00-2e87cd1ce1db,8b92b529-3df8-4c53-a67a-2d0e7dd4b42b,b2b02b08-6b5c-4d0a-a496-383028adc5c0,6cd6b63b-94dc-42b1-8f4e-cb17142fbd25,47df19f7-2e51-48e4-9eb2-b7564543001e,714de7f8-a8e8-4482-a4bf-f5d0f3723020,aa408b8a-ab0b-454f-a75a-6f5cd05d53b3,44e66c85-adc2-48e6-b79a-f4dd6c6b1b1a,01885b4b-ce57-4b25-ba0f-e25d3a770370,d460cc8c-a653-4837-9f25-50babc8d5bbe,89a049cb-74b1-4137-a785-82df86f5572c,ade8a3d0-42f4-4d2e-a6aa-81f2d15a30f8,01e5b659-c60c-421e-ae58-9f08a5b46714,dabf1559-a24d-4cd7-8046-d96b6ce54c9a,f5ce4b57-6068-4412-9217-8ab3a191a072,f6dec6ec-a133-4346-92d3-3b56e10d324e,db20dbc4-5675-47a7-bf0e-f44a52eeaf0a,7896a1ee-5d58-4b81-9b7a-e62f3e37f518,ef2c8cc9-a923-48a2-8c7e-c96f5200e476,d232f616-b100-4888-8136-d0069b78dc78,bb2614eb-f267-4941-8f37-5b6c4e7c5e2b,08ffd8d5-58a9-49d3-9e2f-2842c00849b4,21672c0a-8ae4-4a50-ab81-be4ae07a70c8,72f6a137-db35-454d-908f-2b9e5f3a12dc,a2d4f566-a64b-4ca3-8d48-16d2f940af37,88d23859-766a-4c47-85f3-fa5cdf737ed5,fdc148b6-377b-4f08-a55b-bcf6e05d71a5,5bc8101d-a2c5-4d87-be82-49995f435fd3,94cf738d-9a8e-48fa-bd00-75a4c64758ef,dd080806-4521-4794-a6a0-9c924143d7ab,8253ad67-30bf-4d8b-9e78-fe813bc8a3e6,a33f52ca-5b32-4dd5-ae18-a0f52751f23a,636c6670-f160-47ac-b3bd-012e29973e74,bcdf135d-0a44-47b8-ab17-63c5309d7b0e,ee85e191-9acb-4403-a43a-5bf13ca26b7e,342b95a6-6acf-4c68-8dd7-34603f09d2ff,d658396e-1ee6-401e-88cf-b6e407d2c031,996ab3eb-d1c3-451b-aaa1-7387038001f2,ee12ed12-6930-430e-8903-2f23c403f60e,7d6ec746-8a8e-48f3-b982-703c3f053ed6,524cfdb9-82e9-43f9-9b96-233bce9749d7,fe91b00a-321d-49a3-a214-eeacd9da9768,f7cf635f-e9eb-4d10-a531-648dd490481b,e0704f67-1d00-4f4a-a3dc-499d83cb50d6,e045ed3f-4c49-45ce-a6e1-62d6417efb77,1bcf0c74-c330-4d0c-b889-267fc8742386,4321a161-5808-4721-b68a-ab267753d043,1e4de2de-39df-4a8f-8d26-62f14e258932,5c21cab1-3c88-4f55-8ae5-01761be2790a,68dc365b-d3fe-4cca-9991-08fbba6e50c6,35c1b4ef-ad67-4dac-8ec9-3e0ead825e99,c04ae923-28a2-48ef-8a25-15c5405a5a47,13bd0298-20bb-4638-b8ab-c0c8d5edd5d6,053df0b3-cbca-4681-a386-396b1bb23d9b,51e509ea-47f0-4f50-918f-79f5835ec0bf,0168eaf7-d9ae-4de8-8274-6e58f78267bc,cab229c5-0edb-4309-a0fa-86efcd4b61d9,29d95690-c763-4253-9675-9a007ead6a3b,961dbacb-6fa9-499b-a267-53b1874ccf01,8038cd63-24ab-4b88-9b22-1fc8f92e755b,c7b928ca-97c0-4a12-9129-3daeab47a250,a2841d25-d5eb-43bf-a206-9f1db39d718e,72059f31-7b71-4de8-854b-71670c2eab6c,53d38583-d935-4adb-a8e5-5faf9409bb99,6c6496bf-2924-4ff6-a40e-57aa51703d09}'::uuid[]))
  • Rows Removed by Filter: 57,237
18. 0.063 2.778 ↑ 2.8 162 1

Hash (cost=37.02..37.02 rows=451 width=20) (actual time=2.778..2.778 rows=162 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 17kB
19. 0.113 2.715 ↑ 2.8 162 1

Hash Left Join (cost=15.32..37.02 rows=451 width=20) (actual time=1.806..2.715 rows=162 loops=1)

  • Hash Cond: (tqs.question_spec_id = qs.question_spec_id)
20. 0.230 2.149 ↑ 2.8 162 1

Hash Right Join (cost=8.68..29.16 rows=451 width=32) (actual time=1.341..2.149 rows=162 loops=1)

  • Hash Cond: (tqs.topic_id = ts_1.topic_id)
21. 1.383 1.383 ↑ 1.0 590 1

Seq Scan on topic_question_spec tqs (cost=0.00..18.90 rows=590 width=32) (actual time=0.794..1.383 rows=590 loops=1)

22. 0.052 0.536 ↑ 1.0 162 1

Hash (cost=6.65..6.65 rows=162 width=16) (actual time=0.536..0.536 rows=162 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
23. 0.484 0.484 ↑ 1.0 162 1

Seq Scan on topic_spec ts_1 (cost=0.00..6.65 rows=162 width=16) (actual time=0.013..0.484 rows=162 loops=1)

  • Filter: ((type)::text = 'Question'::text)
  • Rows Removed by Filter: 50
24. 0.056 0.453 ↑ 1.0 162 1

Hash (cost=4.62..4.62 rows=162 width=20) (actual time=0.453..0.453 rows=162 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 17kB
25. 0.397 0.397 ↑ 1.0 162 1

Seq Scan on question_spec qs (cost=0.00..4.62 rows=162 width=20) (actual time=0.009..0.397 rows=162 loops=1)

26.          

CTE weeks

27. 0.000 4.618 ↑ 27.2 12 1

Unique (cost=62.51..65.02 rows=326 width=12) (actual time=4.580..4.618 rows=12 loops=1)

28.          

Initplan (for Unique)

29. 0.333 0.333 ↑ 1.0 1 1

CTE Scan on campaign_start (cost=0.00..0.03 rows=1 width=4) (actual time=0.332..0.333 rows=1 loops=1)

30. 0.050 4.594 ↑ 4.1 81 1

Sort (cost=62.48..63.32 rows=335 width=12) (actual time=4.579..4.594 rows=81 loops=1)

  • Sort Key: dd.year_week_iso DESC, (dense_rank() OVER (?))
  • Sort Method: quicksort Memory: 28kB
31. 0.087 4.544 ↑ 4.1 81 1

WindowAgg (cost=0.29..48.44 rows=335 width=12) (actual time=1.381..4.544 rows=81 loops=1)

32. 4.457 4.457 ↑ 4.1 81 1

Index Scan Backward using date_dim_new_year_week_iso on date_dim_new dd (cost=0.29..43.41 rows=335 width=4) (actual time=1.368..4.457 rows=81 loops=1)

  • Index Cond: (year_week_iso <= 202,026)
  • Filter: (date_actual >= $6)
  • Rows Removed by Filter: 829
33.          

CTE weeks_limited

34. 0.007 0.007 ↑ 9.1 12 1

CTE Scan on weeks (cost=0.00..7.33 rows=109 width=12) (actual time=0.002..0.007 rows=12 loops=1)

  • Filter: (dr <= 12)
35.          

CTE date_survey

36. 0.012 4.270 ↓ 12.0 12 1

GroupAggregate (cost=11.94..11.96 rows=1 width=12) (actual time=4.261..4.270 rows=12 loops=1)

  • Group Key: dd_1.year_week_iso
37. 0.813 4.258 ↓ 13.0 13 1

Sort (cost=11.94..11.94 rows=1 width=4) (actual time=4.255..4.258 rows=13 loops=1)

  • Sort Key: dd_1.year_week_iso
  • Sort Method: quicksort Memory: 25kB
38. 2.281 3.445 ↓ 13.0 13 1

Hash Join (cost=9.33..11.93 rows=1 width=4) (actual time=3.428..3.445 rows=13 loops=1)

  • Hash Cond: (wl.year_week_iso = dd_1.year_week_iso)
39. 0.012 0.012 ↑ 9.1 12 1

CTE Scan on weeks_limited wl (cost=0.00..2.18 rows=109 width=4) (actual time=0.001..0.012 rows=12 loops=1)

40. 0.007 1.152 ↓ 13.0 13 1

Hash (cost=9.32..9.32 rows=1 width=4) (actual time=1.152..1.152 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
41. 0.020 1.145 ↓ 13.0 13 1

Nested Loop (cost=0.29..9.32 rows=1 width=4) (actual time=1.115..1.145 rows=13 loops=1)

42. 0.371 0.371 ↓ 13.0 13 1

Seq Scan on survey s (cost=0.00..1.01 rows=1 width=4) (actual time=0.368..0.371 rows=13 loops=1)

43. 0.754 0.754 ↑ 1.0 1 13

Index Scan using date_dim_new_pk on date_dim_new dd_1 (cost=0.29..8.31 rows=1 width=8) (actual time=0.058..0.058 rows=1 loops=13)

  • Index Cond: (date_dim_id = s.date_dim_id)
44.          

CTE date_responses

45. 3.046 378.239 ↓ 1.3 12 1

GroupAggregate (cost=651.75..651.93 rows=9 width=28) (actual time=374.423..378.239 rows=12 loops=1)

  • Group Key: dd_2.year_week_iso, wg.workgroup_id
46. 11.699 375.193 ↓ 682.0 6,138 1

Sort (cost=651.75..651.78 rows=9 width=36) (actual time=373.997..375.193 rows=6,138 loops=1)

  • Sort Key: dd_2.year_week_iso, wg.workgroup_id
  • Sort Method: quicksort Memory: 672kB
47. 3.513 363.494 ↓ 682.0 6,138 1

Hash Join (cost=238.79..651.61 rows=9 width=36) (actual time=246.635..363.494 rows=6,138 loops=1)

  • Hash Cond: (dd_2.year_week_iso = wl_1.year_week_iso)
48. 10.774 359.970 ↓ 682.0 6,138 1

Nested Loop (cost=235.25..648.03 rows=9 width=36) (actual time=246.612..359.970 rows=6,138 loops=1)

49. 10.395 306.772 ↓ 662.9 10,606 1

Hash Join (cost=234.97..642.35 rows=16 width=36) (actual time=245.550..306.772 rows=10,606 loops=1)

  • Hash Cond: (q.party_id = pgr.party_id)
50. 10.673 53.730 ↓ 13.0 24,324 1

Nested Loop (cost=55.10..455.30 rows=1,874 width=36) (actual time=2.884..53.730 rows=24,324 loops=1)

51. 0.032 0.092 ↓ 13.0 13 1

Nested Loop (cost=0.29..9.32 rows=1 width=20) (actual time=0.012..0.092 rows=13 loops=1)

52. 0.021 0.021 ↓ 13.0 13 1

Seq Scan on survey s_1 (cost=0.00..1.01 rows=1 width=20) (actual time=0.005..0.021 rows=13 loops=1)

  • Filter: (campaign_id = 'ae4f98f5-fd13-b722-2c2c-50d5928391bd'::uuid)
53. 0.039 0.039 ↑ 1.0 1 13

Index Scan using date_dim_new_pk on date_dim_new dd_2 (cost=0.29..8.31 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=13)

  • Index Cond: (date_dim_id = s_1.date_dim_id)
54. 36.309 42.965 ↑ 1.0 1,871 13

Bitmap Heap Scan on questionnaire q (cost=54.81..427.24 rows=1,874 width=48) (actual time=0.555..3.305 rows=1,871 loops=13)

  • Recheck Cond: (survey_id = s_1.survey_id)
  • Heap Blocks: exact=386
55. 6.656 6.656 ↑ 1.0 1,871 13

Bitmap Index Scan on ix_l1_questionnaire_survey_id (cost=0.00..54.34 rows=1,874 width=0) (actual time=0.512..0.512 rows=1,871 loops=13)

  • Index Cond: (survey_id = s_1.survey_id)
56. 0.621 242.647 ↓ 51.0 816 1

Hash (cost=179.66..179.66 rows=16 width=32) (actual time=242.647..242.647 rows=816 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 59kB
57. 0.611 242.026 ↓ 51.0 816 1

Nested Loop (cost=4.59..179.66 rows=16 width=32) (actual time=6.276..242.026 rows=816 loops=1)

58. 0.006 0.006 ↑ 1.0 1 1

CTE Scan on workgroups wg (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.006 rows=1 loops=1)

59. 235.839 241.409 ↓ 51.0 816 1

Bitmap Heap Scan on party_group_rel pgr (cost=4.59..179.48 rows=16 width=32) (actual time=6.271..241.409 rows=816 loops=1)

  • Recheck Cond: (workgroup_id = wg.workgroup_id)
  • Filter: (((party_role_group_rel_type)::text <> 'HeadPartyRoleGroupRelation'::text) AND (party_id = ANY ('{ae0fdef6-ed20-4e32-af90-643165345cc4,e839c0bd-a305-4f9d-b19f-789ea2f26446,6309be1a-9cfd-4208-8ef5-c1741e503389,fa4dacc1-ba11-46ce-9f30-f9f20217fffd,f75efe1c-6cea-4659-87cc-ddb11997e255,04f9650e-8ee3-4e7c-8e57-faffedc3312f,a45a5c4c-532c-4ef4-bb9c-d3f8228f3fa2,5b18b40c-c639-4fc9-bbc9-eada0f6a782b,3cb5c959-e07f-4e37-a18f-01a9415ebb16,dd2cffa0-502e-44de-8012-9f11df42951c,83753b9b-ad36-4799-90d1-e79ab21e21de,dbc120f2-c258-4cce-baf1-88757f9fa405,6530e5c9-23cd-4291-a624-c0f736330d9e,77a22e1a-e4f6-4b8e-b246-db62615b2c33,98720c09-2df9-4760-b28e-62af8bf4b0b4,887d54df-d906-404b-b634-ddc494ec78c2,cc513050-a667-403c-8975-f993a7476eec,83498593-61bf-4bb9-a0d8-02d14f64b3a6,6e71dbae-dca8-47d3-9f0f-ffdd797393d4,5007a8a0-0cac-47b1-8f02-24cb8c042003,4b265c6b-b4e0-4126-aa3b-03ed634eefa1,596fbbdd-53d0-494f-8d92-1624f47ec666,f51f208c-bb68-4a91-8585-f6d8daa70a47,081badba-3487-40c1-ae6a-1c2f526d0438,2b57cbe3-27df-4d83-b7dd-5a367fd0aebe,30071419-60c5-4ebb-9e19-d7b263994f6b,44e3b98b-0ac8-41c1-ade6-cc601ec9a934,ea5adf32-ff2d-4b85-b9fb-8bd49a52ca0a,51c25d81-6041-4ada-a801-3706eddb0e41,73d4de00-dc99-4800-8c9d-e171861900ed,f90c605d-8648-47a4-9a34-310423323561,17f093d5-e041-4a67-ad85-ff2f630a2573,1224644a-9412-4ad1-aeee-67b697b47deb,68628f69-026d-4cbc-947e-4f90e4432089,60305e7c-f4bf-4dd9-b102-832d0c1a75b9,bac93b0b-5bd4-48ba-834a-10c23642273e,b92b07c0-ee1a-460d-8090-606ffe4fc70c,1b876920-74c3-460c-9ed9-d016c54d5e09,3e447bef-6d3c-40d9-9aca-8a2f4be4348a,1363dd32-2d04-4316-bd56-a2db30cfc930,2f1dee93-c6d1-4e00-b5bb-20a8bd227a34,6a17b866-8c8e-4f42-a350-bd7f19660c6c,7247e46d-09d2-4215-88bf-b746615515ee,38d1fcc6-23c6-48fa-8a99-b48aa2aea1f5,871213e1-622b-4c55-8cda-f20d4065c847,55d9ff5e-dc41-4b14-baba-1b5150751076,704b2595-da94-4cfe-8b87-0c5e03c089bf,110afebb-e2b3-4d32-be6d-83a414e981c9,9b58b787-0a9f-40d1-9765-efb2f256156b,061fb89a-f19a-44cf-8a61-3af4e5e6ef10,4f8658e9-4fca-4fbb-ae05-82fe8ec3e35b,1544544a-794d-4b7f-a5d4-4264ac3e9e4b,ceefd07f-751d-43d2-be36-692a5fb306ac,28c2ab54-768e-40cf-b84b-e7ff687a27e5,c9fe2c53-64a3-47cb-b795-3c4df40c0afa,43190311-c7f4-42ba-aa8c-cab99afbb9f8,1aceb294-cebe-453e-87df-201340f8d2db,cbf958fc-34e6-4320-9650-97a6dc0056f1,e9d87c51-b7b4-4a6d-ac3d-078efd72fbf6,6a2764b6-e084-44a3-9d1d-e3ee8fbe188d,d10ce49c-c92d-4402-ae37-db6d9790e0d9,f2d777ac-821d-4401-810d-8a771edcd84e,45d5a660-b547-4d80-aa7b-a09eddf83dc1,d5742937-de01-4ed2-945e-2bfc2c6e97c5,deda5fbb-d4f7-45ef-a557-7104e72832f6,792ac725-63c2-498d-af98-cd4194fc95ee,8b8c155f-eb25-4ce4-8d97-cb9500921090,c76b63f7-fc42-43a7-ba94-9275f09f8191,e5946b58-26ce-4f6e-a5c4-1699ad74e789,e9377aae-31ba-459f-99b8-7691a8dbc979,e6fc6947-10f0-407e-a1c4-583500817c10,aa3a0cc0-b528-4bbf-b9d5-953fd16a4a5a,9d29b714-c37b-4171-adf7-06e1f980fa56,29b1d991-969e-4a7f-99a0-8f32c703cfa9,e16b9e3d-bade-4fda-a135-3ce0dbdfcf30,eb467d26-e3cd-46a8-9f69-fb75b4dd3f53,ac4d029c-a647-47d5-84c0-2350665d3131,3379d661-2bb5-4e76-91db-e3fff1308c66,294d5042-41ea-4089-8815-b86b26a041e4,715bad31-77ba-442c-914d-f67eb5c02216,6bc17f6d-4a46-49c4-997b-cba4a3d1ba13,eb376040-2f95-4e96-8f0f-a869e9995bc1,1da3ee5d-c57e-44f6-ac99-b1b31466965f,14f4f392-f986-4272-96f2-258b6491ea58,e29ef91c-0161-4b74-b965-e65bf486116b,8fe5ec8e-e6c8-47b2-9867-e53bb8766ea6,6a1a6762-fde1-47cd-85a3-e84eaf642366,9338d44b-b952-450b-93ba-6224e440c72e,c1af9e0e-d4db-429d-89b1-8e35210e365b,99fb9f9d-9041-4e1c-9a5c-4dfad9ba6a5f,9bd6ad08-31d9-4b5e-abf6-d8e69e5bf87e,51c56aa8-c4a4-40e9-8dad-056efb5bfbda,d63322ea-5197-40f4-a214-730454de0932,434ac9de-b217-4ba5-a8c8-ce326eda2267,b772ca97-9c4b-4567-b719-b70c58dda976,aa799943-98ae-4f14-86df-83fdc06c943e,8a5c71fe-e233-41d4-a9d3-c50c8b81b888,c2a4f360-17c1-4f93-b2bc-e1d4e35ccfb1,5bd1b795-f133-4dd1-9b71-0b1d7c0e8713,eb7a89e1-3371-4e20-94da-6453d5012bf4,678320a2-2d3b-46f2-ba87-15f07299fa51,d39c2854-345e-4c32-9faa-53929545e7fd,a587479e-64b1-4f0b-82f2-9a84924a332f,653d9cf7-c5f8-49cf-addb-d0ade875b60d,6acf4099-5f28-4ba7-adbf-d31cc17ff48f,8f304980-3f91-4762-aa77-877fbc58afc4,e25c6b7f-de24-4bb9-928d-ef53a7735131,56ab03f3-89db-46a1-a63c-b7c6d5b9777c,2bde572b-230d-48cc-aa73-df64c1d34297,2b9a409f-1c57-449d-aef4-6e88debc8f88,fcda6002-9ac9-46e0-a86d-1e591c4742b1,001d31e1-bd42-4d6c-965a-8f97fd8830ed,482d3b4b-2366-4e5f-bae8-52851070849f,8a71ab02-cb5d-4878-81e5-eb53e346a45d,b67c04a2-bfba-46e2-a60a-b71a592d5c3c,6d24ec58-01f1-4baf-9ac4-deac57935f83,29f730af-835d-4b0f-8ce8-6666ced2bb33,9bf8ffae-939f-4d86-a49f-c29ff1be715a,1db00e08-5671-445a-bffd-6768ae76b921,cf0b1e8f-1ce0-4948-880a-73400a3f43d7,88b57bd7-e352-49d5-ab4a-8085c34917bc,ec2129a5-dcba-4535-b031-196fe518d7ac,28e58da4-0283-4d21-b1dd-ec48be56cd00,8100c1cb-d083-42f0-9adf-78f0b07d778d,1468feea-211e-49aa-b0eb-9e9d0cafef8b,9baf2c3c-de8d-4ed4-9a9e-2cc671157edd,efbc4681-a6ca-4119-8c3b-01f40fa06539,f124589e-8e7b-499f-8265-764e0a792906,0141634f-8abe-4f9d-8670-4f03a90ac201,ab2ea1d3-0d76-4b18-b1f8-01132e82d900,48187067-0131-4676-a279-60988e398473,8b63bcd0-76d8-404f-be05-64495ec30dc4,7cc970da-5a6c-4ef5-b720-a382719b78ca,817e501f-0bd5-4ada-ae4b-d19ddea6c171,8bcbce71-a97d-48a4-ad29-3160e9789365,c40ca8c8-cfce-4b8c-8bdf-00f49fc6fc18,96b263ca-c23b-4ad7-97e9-1173df57a23d,9d84e86f-1076-40ad-8ba5-e742aabf6a2e,b63c7bf5-41c4-4851-818c-a5c11a77ae34,de8f49d9-a3fd-4fc6-84a5-a89554bcf501,9d7429da-931e-4702-8bbc-e138bd8a7f23,d1c3cb73-28e3-4cd4-bf45-ed5a415b5210,860d6e19-fd13-4504-a2a8-fc53c8b93135,c7308676-2333-4b87-af28-bd72474e0e98,2270e067-e3e9-43dd-9c53-34e4dfc5bfdb,db1b97cd-1170-4e40-8f48-8487b6c3df4b,d702778e-65c4-4923-8429-83bf7ae9344d,4295bcde-8d99-414a-8489-02aaa40936a4,10bbb77a-5641-40e7-a976-39dfccb24923,cc3ac248-25d7-4391-8776-97bb000a097b,a4619a98-7274-4a21-9359-3250561e9e3c,b0fec709-5e4f-4849-8819-3d50350c275e,f9dd8da5-2263-4bd7-89d9-10fc7fd840a6,435f88f3-46ba-43fd-82cb-9b34c6b04a0a,4fde891d-0e04-401b-84da-598b184f2c01,6b72f03c-8861-463e-bb85-27cc1eb40a0d,259e4c18-71c4-4b32-bd57-2fba4dbe8704,793d574f-3dba-41cc-8d41-52afe14400e2,79505ae0-819a-4c00-a319-5bda43e1f4bb,0faf00e5-18e6-4efc-aded-65e4fe211203,797e5e21-90cf-4800-8aae-8d072120584d,4fa16103-5e1c-4e2f-81a5-8410a8b831ab,449965d5-a4f2-473f-9347-79c4efb26aef,ed6c4c6e-04b8-4cc2-9867-54cf5c42998b,5c0ad0b5-dced-4db0-a216-ee3c01f58d18,7bc63c9d-c463-4e39-9e62-68030cbc2334,786ddfb6-129d-42ff-b417-3a2b44b9e3d5,5e5d89ab-8124-443f-8038-bf908e989b94,4fa64d08-c525-4a80-bed8-7ab88a444794,b982afcd-8084-45cd-b82e-abf3e8d858e5,eda5940b-ae15-47f8-9876-3f7c2726ad8f,bcbeaacd-1c07-4dcf-96ec-a5ec08f04da2,8be79353-91c7-418d-a7cc-3ec9eb37bd32,cf60ad7b-451e-47ee-a00d-83b33fe691c1,d1b43a83-4e48-4b1e-8feb-8cfca965ca5f,ab0f60a1-f6e3-45f0-b0bf-66c39a90267e,f11d6c49-dcfe-42d1-8ed0-2883eceaa49b,e9e04cd1-20a3-44f2-a7f3-44c1a0702c47,cbd73b94-67dc-4199-a7aa-32311f52cb03,cb8218a8-f26b-4730-9163-59465a1e3a00,ee2ccbfa-1cd2-40e0-bd1c-326f068b6912,67256d74-d9bc-4afd-b026-bab216fb3f17,e119bce2-3291-40f1-86cc-77c79aa3614f,f046c0e4-03c9-4b4b-bc83-49ac2c66ff26,5a07fa55-c545-44c3-883e-e75de06e8ff0,9bd5d66d-6bc9-4f9f-a01f-cfb505c9e5cf,3d40503f-cbb2-4f98-820f-94a18a39d985,1277984a-fc44-410b-bd2e-1fdeaed4da4c,2156352d-f7d7-4d35-89a5-96904187edd1,e843cb58-0a05-4638-be35-4e8df3f1bb7d,ba0144c2-4ab6-4392-bafc-1630ea3497e9,bf43ba81-61f6-40fb-8558-c6a40afcb27f,84f64531-399e-4715-98d3-240d07e2397e,1af17329-ce80-4d75-b42f-b9993c81f559,a687a8b9-530a-4eeb-b24c-3c673fdf7789,3b49f2f6-22de-41b9-8fcf-a6cb6c707e24,386b12f1-b30d-43f7-9500-e7fd4c7536b9,1509a55a-f235-4625-af1f-c5ea3c3b9ef2,b1b7ef69-f025-4e1e-8085-598dbacd7f51,7b8b6c8b-3725-41d2-aa04-577cc5a5e2a1,52a71610-39ee-4b91-9e9d-75e1ed417150,b8bc7d32-3a8c-485e-ae70-d0f62fd33bd3,8c4c6148-e99b-4868-ab87-610d7a747552,7f57a76d-0368-49b8-82d3-b19a1269ffb9,0144ee85-94ed-415b-8d0a-0f213afaf9da,507ed812-76ea-4337-84ac-be8b09a0fa20,65a2301a-d036-4ae3-96a5-50f2f3514ca1,5cbad350-3d08-4ec1-9c57-05dc2ce5cdb7,fc0b5765-076d-4d24-a5c0-77ffa647ba2b,3199698f-cea1-4c9a-b841-82aec79ade9b,677a5234-f659-4a0b-96e8-769f0a4c2ab0,83f27e9b-527a-4a22-85a9-91f2ebbb9ccf,2e158cb8-9385-4e1a-a64d-8767d2bdc859,d3abc19f-25f1-4336-a145-1aaa51056c0d,4a292025-c795-4a2a-9fed-62a140921406,3f8467eb-0dc8-49af-9efa-1718ef022d59,846b3e43-4c2d-4c11-b328-70a9a7ca5335,a3a53750-16a5-4a95-9f40-e4bf77b414a7,68e88cbb-32ad-4efd-962f-c390e8132d57,705fc169-b975-4d51-ad4a-1e97bb4c0b41,5d36a697-027b-4d5a-9a4b-3ea325ed9550,309d3c04-d674-4d80-b94c-a6f5fbad3fe3,f8b3b8d7-af2d-492a-9ee3-d40e121e805a,775b3771-90b3-487d-9845-0f200c5ed61e,08c8360e-4320-416a-a775-023e16cce7bf,7968a44d-8129-4eb0-95cc-1608023828e4,9f630d64-49f5-4c14-8257-017a19289d8c,6d1aa36f-925f-4c70-a0b5-399706fcf822,51f47f84-9a18-4864-8ff0-e961a5e2e13b,310bf77d-2c26-48d1-bd2e-6032385a0a37,4e0ee0d6-8710-44d0-8c0b-e74b894ff7bc,825d693b-ecf9-4057-b9ba-f0b3af94f084,22b1da09-4364-4c30-9ecd-30171040ed40,876107ba-338d-4e1e-851c-42f6c1427d1b,2ddd0665-b065-4a2b-a1ed-e9484200962e,848db71e-10c9-4e76-a15e-d6036034f9df,3aa1a9ca-e83b-4d32-9a3f-125d2042db4a,b2e9f35a-c7ff-4503-ac6e-b96e0d33521a,7066abe3-6af7-4c8e-b434-a29f5bd4e300,1ed87682-8236-46f1-92d1-ca6a6ecdabda,de0c7939-2551-49e5-9940-63bd323ed2d8,a65b40ef-f694-467d-8748-04fdce00df37,a74c4589-b671-4938-bf13-83a1d6741ed1,c589f92d-6952-488a-a1b0-4492668e5b0a,5cc0bcdd-de7c-4aad-94ec-f9e2cb7be839,c18dc67d-d08d-412d-a4f5-ea4b35ca839a,046d00b0-e1a4-41f9-b3be-9e900069cfea,42e1c8ba-129c-4560-8541-b6ec72a162a2,7900b0bf-209a-4724-9f23-13a996a97d41,8ba5197a-2adc-49b1-97c7-cb0d3e3ea04b,0155111e-6a84-4214-8a22-96759eca74e8,1798f66a-e0fe-474e-8d01-64a5418b68c8,0a56bed5-c9a2-4bb7-b52e-6132fc61fd96,575d6140-b6bc-4a6e-88c8-26dc662de83f,0904fdc7-6da2-46f1-af57-66b8e9e6dfac,5644d6fe-4848-4a2b-8a61-68d103cd5cbf,9fb0ad3f-5d6e-4243-9fcf-e048076316b3,1369a579-d9c3-4862-bb80-351d774d7bb8,c390a8ec-1da2-4c9a-8313-d29d50aec2de,7baba984-86dc-43f2-801c-b402b8751747,15432774-3810-4e00-ade5-e16623a728c1,638a7955-7c1c-4175-943f-62241fe72595,4c69268c-f62f-4fcb-a8a0-8201dcc3378b,bca5baba-f729-46aa-9bb5-8b788bd97b89,d3e8988f-d2fd-47f1-a793-ef54631e0946,15c2482c-cea6-498d-8c24-da36d68d6098,9420d25d-e19e-4304-a839-3c27c3bc4456,1413731e-eeba-460f-a50a-7373c9381ca9,99b336e3-9550-46c7-a9b3-f926d75cd931,5bc7ca57-1109-4357-987a-341016d35a3c,c80c0ef6-d2b0-4902-8ea6-55d44ede0c34,a01364b4-e4bd-41ef-a235-dc8d55111c03,35fe4f04-a52e-4e39-8cbd-c621981a8906,c232d28d-f1e7-4d12-9607-fdd748bc1254,d01c6e3c-7a95-4647-b311-0102767e8c02,57c3de79-7a94-46c7-a6ab-0152b853698d,b213907e-ab0f-4f1c-a506-99a72ff0e003,34001308-be0d-4df0-9258-a3f539758cb4,dedda873-283f-4f1a-aa4b-307174eb96e0,e7aa9cd2-e752-4ab2-8387-0655bb3e32bc,e4fbf58a-e68f-4eb3-a93d-ac345ade907a,5fc6c5f2-503f-44a8-8824-877a29e6978a,7e90b836-a61e-4be3-82ea-243ae23795a4,dd87591b-836d-4a41-baae-b6caddbf63c2,29deed9a-3a5d-470a-a8af-0b2a552fd80d,97a0b96e-ecd8-42c6-bad2-09bd3feb4d04,66ded87c-a353-41c0-8781-2c4b61c4f325,6bbccafb-7d1d-4c0b-8da4-bb0e82bb2273,d33c8bfe-076a-4524-9511-34efe71ab8d6,80e1014e-1720-4b44-9ef8-5ceac92647b6,97efa80a-4ecd-43fb-a289-289abc60ca94,65fa2242-46ba-4c46-b44e-acddb5b6db98,67717835-15a8-47f8-adcc-9ff040a1e7a0,b5045bc0-6a2b-437d-885a-5eff6029a8f2,0f886b1b-980e-40fb-a83b-4233ead3724b,c0a2bd4d-78da-4def-8adf-87a49219245d,51bbfddf-b858-4f2e-b6a3-517bb1b1b8d8,7f33162d-c506-4f5b-beaa-cefe330cf2ec,bebf6f65-4ae6-438e-9d6a-2b9aabc873c2,db2b92ea-3496-4315-8f41-6320d3558264,ec68b5a6-52b6-4082-a582-476e58bf90e0,d2bc61dd-94f2-4492-9675-d54bc026f05f,6a3db355-4499-4d04-8c99-d10bc4ce2d18,e9e8adc9-b54e-4976-b297-e23aa2df6832,7d5ae676-e253-4d77-a05f-dee0a4a39c3f,3b96b3dc-94b0-4542-8f49-98606452ccab,b93612d1-2bc0-44dd-94b4-cc4676e5073e,e62059ab-ff46-4e0c-9eff-2decdb207982,09c205f5-78ea-4663-8890-831607f4cf62,dfa99abe-f5d4-40e5-ba3a-c5ef9c550fea,ced0f46b-c063-493f-b8e0-5b42253d4c36,73670df6-edc6-4a67-ae1d-4f9d37e3cb27,f5a120af-6c69-48ce-a182-a8b742962901,303d28dc-a3dd-483a-9a29-502bdcc26c69,8b96868d-1a4d-4514-a9dd-89f49180c4e7,656976e3-e853-4cee-a124-2e7e712ff493,f886bb8d-d47a-4a33-bb39-b12aa8ccf50f,8b6d199f-6a93-40ea-9e24-c6dc145dbb28,1ba63638-389b-4a8b-ac39-7e5a40338a82,01d4ef02-07b6-473a-a179-ec319584908d,f536c2b3-a0e7-4d05-91d7-536a00ae29ee,665809e0-1fef-415c-8905-eea6c3678f51,5da21f29-63d5-4536-b76c-ac121b250329,c47cb593-25a4-40c5-ae5d-440289817f19,81e47ace-360e-4a35-86c3-6f65a5c7687c,227418f6-c4c6-4a89-b4cf-81cadf28e5ee,afe982c7-0453-4e72-833f-f2789d50dfee,cc9e6490-0597-4607-95f9-8ac1d6f6c455,e8e154ae-b54c-42e7-a404-c2262acdb5a9,f23010a1-6155-4010-a1d2-e28e45e76ab1,cdaaccca-99f1-431c-bae7-4f1780207e61,6ee0995c-12d3-4e15-b460-f70f7af1e182,2c249938-59fc-4d01-9e16-cc1709309217,497ad9f5-eef4-40fb-840d-5b2810d6b9bf,70543812-7abc-43bc-b608-379a0592cde6,f3526130-6c3b-4284-873f-cd75442e027e,fb3bc2f0-7e72-4c9d-8492-4aeffec41801,ab4e120d-7ad6-438a-b118-1bd253093d79,f6b77287-9198-4f8d-acac-70ca6c652f2d,15b6869e-10f6-4f41-8aec-692aba57ba30,639a04fd-b801-4fef-a27c-6fe053f4a0f6,b63af298-5585-4287-917a-da9272d385a1,d2cb1940-3153-48cc-8c8d-d2cf70332948,bf58a8fa-ec84-4fb0-b00e-c8333ef93925,3a281947-62ab-40a7-9d03-5dc3b7eacfb6,e64122c8-ce06-475b-9805-6961ea650cb2,d5c44e0a-8737-4def-a995-e4ec221cef1a,fb6360c7-9b5e-411b-8f03-02e135d107ed,88281f35-c34f-45dc-a730-772751ff6df5,871006f6-f868-454c-afc9-466e96bfdbea,7d7d82f3-8f3d-471c-99ba-077bc5dc82e8,6eefd974-8d12-4759-88f2-cb42c573158b,e62f7bb7-c14a-46e4-8c23-e46015aaba85,d29b3d9c-fad8-42bb-877b-307f03820d29,df8f9be1-92ec-4400-8775-53a9cb2e7eb8,e695857a-44a8-4c93-9d11-4a7d248d55ae,43d6600b-aa14-436f-a56e-fed99477980e,dc4dced3-d2eb-4f6f-9166-3b5acaeaaaeb,cb4a7506-1886-475d-9469-bd9589f499f3,cbba0bb7-55f8-4c13-9442-8d5a2b2b2e43,19856d02-e43e-4bb8-91bf-2df91aed0875,f62ad370-be99-4a5c-90ff-e1bb072fd47c,00cb11e6-017e-45a7-8f55-390d5d761c4d,1e78508d-deb7-4638-b31d-34603618b2ee,b4a036e6-711c-4fe0-a468-e5e475499ef9,78168794-e178-4118-9a7a-3302979f321e,38178ee3-9f61-47e4-bd2e-8547cda92661,88490675-7b4f-401a-8938-b57e63702441,4669545a-abf3-4afe-85bb-328a075315e9,d1b282fd-5223-4335-a779-be4ab3ec5b55,21e3e306-4d52-47be-bf73-6e78878b3004,b6cb8ede-f8dc-4f2b-bff6-6b805b601e36,ea1d0039-a4fc-477f-8b2e-d3bd756fbbe1,e780c540-de36-476c-99f6-806eacd8bf9a,553622ab-6559-4b4f-b929-296da145bf8d,da261097-4bc8-4f1e-a1ed-1eaed03dfd70,e395d78a-9468-4f00-8ee3-373a82a1d419,b7376c8e-4ec1-46a6-af1a-227582bcda9b,46e7465c-8f5a-4b90-acde-22f912157adf,fc7fbbe1-41c2-4ec1-b73a-d769c22b46cd,4d50b8ef-a835-4aed-93ec-9dfd484541c2,83da4946-b7b4-4df5-9ac4-6f93b213f89e,2cabf862-f6b4-4d6b-bec1-da53b6679d4b,c45a4a28-e8ef-4dae-8019-9087d46d4d9c,6bfd4d7d-9e94-4e38-8fef-7e4728549722,b87eb429-516f-4423-8616-70260d67c389,63f6dd8e-1843-4d8b-886e-c477e1b4ad5e,3be886b3-c3a5-41a2-99f2-93308c31a4b3,15a4c271-306e-47df-a5b5-451c654cf9ea,013e1dd1-f6f2-4ae9-afa2-00d17a8fdffa,432cf3af-983c-4aee-8d13-80099b85bf6b,86ae43b1-6427-4885-8545-e713def909ef,7543cbe6-c592-45d8-9671-ef528d6a8003,cd338df8-5fbc-4160-bd64-6bc90607484f,d6ffa014-4c9a-44a9-862d-0bffea1b66de,c794678b-60bd-4002-9732-09d352b2f996,ba3dad38-4732-42cd-84c2-bd74fb4cbbcf,33c04251-2274-4fff-a5ee-dc4fcd287efd,80eaf06e-ad54-4c66-969d-6964260c2eb7,74e5ba1c-e4c9-42b9-aaed-5d9a46e14bc0,6c4863e8-7cee-4ba7-aef3-0dd3489bdde6,8b696b7b-e355-44d7-b71a-16e429f3d1e2,1b1a5401-02f4-4890-8b69-98cc33888669,68d97f56-2278-4168-890c-8f4986a92be5,157859f0-1b8f-4b06-84a0-3a81bcfa6d81,5c2541ae-4eb5-4d07-8980-f4ab9c66097a,93889874-baf2-4a05-bf2e-22026499ea7b,e6f6a557-1117-4ee2-9b6d-df6c37d3aa00,fba99679-d079-4565-b291-288a6bab5fda,d4f8cb6f-f27e-4c1d-8971-86abc401b167,9390dad9-def8-4b05-9b29-0e2f7f14f637,03843b82-8343-42c9-ae24-cdd69548087b,d1374cff-0003-41e6-b1a4-b5ca193077da,ce158cd9-b6d6-4262-864c-b3fcb63554e7,bf829b80-c928-42e2-beab-11d4439e8fbd,be817d42-33ab-4225-a0c1-e468ca772653,763c0723-0424-4d7b-b834-275288e8f147,133b9c6c-df6e-49c8-87c3-d92d414522b2,20da99c1-ee7a-49c2-a924-901e6be646ea,6deb88f4-94f0-4bc0-987f-220f3218ad20,98ed178c-9b73-44bd-88db-3c643a4c853d,684c445e-43f1-4143-8ca9-83533ea91d5f,9c092359-bebc-4f0a-bdc2-5c27002651df,3579f30f-180d-4ede-b898-a1de1797b256,3cd9a0c3-d426-47a5-8df6-ed69f983b5ea,a1e8dcfb-60ca-4574-8fad-ba23ef9263d8,f1ded1dc-4b2a-4394-9b94-27fbabc1e2fa,626eb98d-fc73-4d83-bbb9-586897135aba,e45b752a-e72f-449c-af2e-f85bd73417f1,4a615d41-3def-41f2-8938-7ac56d1923fa,07e74e7c-ef5e-44e7-b0c6-9d46eaa47712,356848b4-dc62-4834-951b-5c6b4f2d4cac,dc4f6d1b-0785-4c16-8667-26e172c748fb,2e05df90-1d4d-4f09-b462-9187982b48ee,a981f8fc-5792-4b26-999b-db6c0090b628,615b5f45-0faa-47cc-8a21-a918498ef999,109ac58a-97bb-4db0-8663-7cc55706e170,1f628aea-6ec6-4b41-a788-0d76718acd1c,5b1a9f31-58cf-40c5-8a01-0f97b28096b0,f3d2b4ff-a283-4012-bd96-8790d4f00a8b,fc194e24-013a-464c-9b73-896dc1abff20,5993014c-4841-4aac-afa4-265a160f5cad,b4577bde-0169-4650-84d3-792d8b5f2761,a53d50d5-3c5f-45bc-be05-2bec229aaf0c,aea8ea69-9420-4923-82d4-aa56bb6f16fa,5020f127-0b73-4753-80a8-be18298c9214,b020f0ce-a7e1-44ad-831b-7b8988446bd6,58afe001-347d-4541-a534-0f8a66fae14b,c5944d11-4e63-438c-a719-6f2be2ac64a3,5f5508fa-ba17-48fe-a396-d5764dcf6670,356e60fc-2116-48ed-b4ea-076c8b86e8ed,0e28b447-b1a9-42d4-a63b-c43d574096e7,a52779af-dc4f-414a-907b-2c096404a514,0ed4433f-5399-4454-b55c-41850837efb5,63abe02a-3c1d-4838-ab81-8fd2bde802d9,3b70f68a-22a3-46fe-8505-1115a78c6b5e,cd2d6d10-5858-4a26-b1da-bbf4397667ad,1ef56e1b-d964-48e7-b482-05c098bceb27,c1e24855-b742-490b-ab5d-81b299172cdd,fe76737f-134f-483a-ad68-2bc33326c36e,bb147b1c-821f-46c7-a89b-479f19735ef9,e3c5ee79-cc64-4e49-9179-5ec61d37e33e,75216d4b-1da0-42b5-b04e-f02be98de35a,d3a47f9e-6a51-4c25-9a5c-c23523171536,b526e15a-5cc8-4137-b09a-fd3c94b7971e,fb994a30-b2dc-4670-b774-8dc67b442fc6,4442e475-1aee-480a-bc8d-43666bfbf257,80c4f5b9-3c3c-4597-8169-5fbb04951824,7c871afa-b604-43a1-a0c8-ad8d1e959364,c3d7c273-74e1-4a93-8f13-5e23926754fe,af24c950-86d5-4f6e-b450-1c2e29e7573f,ada228b6-b7d7-4386-b855-3efe955587cd,7396af47-9ac0-4ce4-9c4b-d101a5f9ae97,0afa2884-85a4-4937-a3d0-e3323c143933,c77b1652-3be9-4f68-a20d-825912a21fa4,ea5c58d5-a021-41ab-b78f-23dd76ddf54d,72a4f523-5994-4b89-8707-b1fa168bae30,427ca547-21e4-4170-a9e9-3e02236e34dd,16915a5a-390e-46ae-a496-b51afc5d05a0,959fd6cd-e07e-4e87-b675-f3c494ee49ae,8c81c0a0-5331-4779-afe3-bd1984deaf1c,f6530b84-60cb-4f8d-b122-754854c6b264,dd0f77eb-5dba-4148-a6c7-d7abf1a48a46,d03dd1b8-ef33-491c-9405-c0ba7edaf19e,2ef2c2c7-d21d-4a27-a9a8-dce593322fe3,cf093184-aa58-4213-b372-ef300b6d5911,db79ffe4-5ea2-4523-90d9-99b5ccc82856,6fd585e8-753c-412c-86d9-1464249ed0fe,016f4e9e-c6fc-4f70-9394-27904ce27202,64b93c29-ffa3-4839-8325-2f0449a500e7,3877a160-916c-432c-9b6e-b4db98f39a8e,375eedd0-a5ef-4734-a5ef-7d4d99171850,38ce4256-f528-4557-9886-0550ccf9bca6,2dd5c5d2-abd1-4c5a-8dc5-75bfdffbdc63,183a574f-a47a-4c86-b1de-7e8fb92c8bbb,8f33c236-e797-450d-adae-fb2d1e49b172,a3d3ff1c-e448-4d84-a441-d618ddfd9e9b,1baf06dd-bae0-4559-93e1-7d1e1df44583,dc97de7e-681b-440b-b4bf-04b9fb083ecb,0adb21fc-963e-4402-b453-1da3362d2080,08a55cba-455c-42de-b037-3cfaa96e405e,2730691f-04c4-40d7-a0c1-79e583575898,84a31c83-944e-47c4-800a-e8ac841331f5,8a24e19d-eed1-4e26-ab2c-e85408574000,4b7ab5c2-72e9-4ab0-9fa8-726bb8cf5868,6e1a85c8-3d34-4c51-ab8c-9fca294dadcc,c05e8a87-0f48-4d53-89d4-8cef63b4e620,bff4c71d-34c3-4bc8-b1fd-bc3df892827d,a3a31aa7-ebff-4279-a633-0b3c9f95d8f3,cd07e116-7ea0-4487-ba90-df9933842369,a7e4096b-6569-4817-bee1-4d949e1c1498,be6bb8e2-af95-418a-8d3c-5591865a970c,63edc332-4b96-4e42-94a1-883aef4fc9d5,b7601b81-11dd-4979-bc52-c728e0d50ae6,7f442259-c698-4f7f-b7b4-229b7550b876,b3ff5779-1acb-4a5c-90cf-cae20f6ac7d2,c3e39841-a329-47b8-a96e-357faeafd029,9bee69e2-8065-43d3-94d6-fcbeefb28628,3a571ba3-4e51-40b9-bd2a-11696f148d93,a44b07d9-1212-473c-b52c-29f2efc8d402,263e2641-162c-4c7f-b94d-ee839757f5a3,6c494769-4441-4f29-86b9-2da79b15c2a2,c1ecf831-a931-4640-a32f-e21ecdafc07c,74b9f30a-457f-43c7-bff7-678fcaa248bd,0d9437e3-7fb0-4106-ab62-53cbbabbb4e1,84e12a3a-fde6-4076-b1f1-f29bccb25efa,f711d9df-4f1a-4334-9f54-b0ed9c2472b3,771e0b5d-d4cc-438c-a43d-0de73eb2e463,ecb6eae4-50a0-4d63-9923-fe551f863d8e,998160a1-5ac4-445c-aee2-ed2934d3ec9b,727005c5-2b62-44ca-b42e-9ea4c80fc451,c6768be8-b4b2-4664-87cb-4b4d6ec90177,424a01c1-fe0d-4fa5-9d22-2918ed78ff5d,927e8551-b168-4088-b947-ca355ba3ac02,aac63934-41ba-4fee-aded-6f36ee5eeb8d,461d7b57-57e5-4c27-9eaf-fff640766a07,ea37e911-6ceb-4381-968e-4fa3c40a4bee,34f670c9-7d74-4199-a9d6-95e05a190170,b4d87e16-9cd4-4117-b1a4-8b4c6efeae51,3fb01d15-58d6-4ddb-9775-a53578677c80,b4eb7209-050b-47e4-b44b-8a70e0dc4427,b1cf9d03-5aaa-4ab5-b472-9664ede03ef3,a90eeda4-974a-4e6e-9452-4f06032eea32,404373c1-7908-4c7f-8060-03e4a0ba359a,9e2ab3ff-96b0-4102-8991-52873f3e8494,f6665415-fdb1-4e37-942f-01b80321df40,24001c28-f6cb-48cf-90a5-4e9276a508fb,8288ccde-7a98-4612-9eba-8d07ac14aa47,80818356-6635-40dc-8e6c-926a85c87589,5ec67b28-06c9-4560-9a35-0138fc1dc90e,7ada70d2-bec1-417b-9c9f-d9dbd45a7882,e34d8e7e-19bf-41f7-aa9f-64c5c6d76a18,d1019eac-ee65-4ca5-aa4a-80132ce63a1e,9ab3b2ab-2447-4ae1-990d-0105a37f847f,51afee57-e426-4cf6-a1c2-86000652eb74,4a296a9f-06c3-435f-afbe-750eb7f8df6d,42c3e23a-a60a-48d7-ab74-75985ba6497b,f4416707-3f81-4aab-805c-3dd55f3c2d7d,cc7f1d53-139d-4142-bcc5-c60187907c78,59b39f03-bd84-4205-b651-5eea4a4dc49f,cfb67d23-a12e-4c2e-aaf9-25666bec9e0d,d4fae18a-a7f3-4eed-af93-144968c69096,dc81c12a-d04b-435d-9359-6b6cabb1931d,59289e30-b13a-44ec-953b-66fdc474bf31,02741107-c814-4b3f-a283-297d146001b3,3813fb2a-e5a3-4adf-a056-e6f1dcb228ba,9715b6b0-2374-4bde-8e0a-5a41cd80d4e2,3b11c2b7-ad6f-45d3-8eb1-b2b232450c9f,2863d9bc-2f4b-4991-a81b-1d5a670be714,3c7b73dd-8ff7-4483-b369-802f13fc04ae,f7fdb531-1908-4a92-8cfb-9f8a86f07d76,f10c93a8-e198-4b23-8a34-1104819686da,484ad75c-2a55-42eb-b4e0-485a8704a607,73173143-649c-403c-b8da-cc7400964d1d,eac81f3c-298f-41ca-88cb-907152b512e9,3ab06b8f-4519-49a0-8587-e834a31ee25f,6e3bee8d-b5f7-4981-a682-5df3505916eb,cf1fdd16-6dc1-4802-96c1-91a7280ab3d6,4b9d231e-867b-4105-9912-380d1273c19b,6acf49ea-2322-4c5c-89ec-71e6643d4b75,fa6ee6cf-0759-413d-84c7-6dcf827c45b4,881d337f-18f7-4965-979c-c2453ddde13b,77248888-fdb0-40c1-b62d-d04a5a51b28f,7a4944eb-cb1b-4eb4-8064-97054f7f5525,cfc717ea-234f-4c00-b8f0-56bc23b58804,afdcd642-28d9-4932-b237-39221e3793aa,e37d7efa-4e95-46b3-ac78-e720dec3884a,a8e96fbb-b309-4770-b0eb-f3d9aa3758d1,de135083-dcf7-440a-be44-d94780523ccc,2a86d9ce-b2c7-4eb6-a068-be5b4bbfb0b2,3d0079ea-1dd2-4d22-83c1-fe1ed17b2911,78243e5e-74fb-4220-9082-975ff31635ec,14d6731f-c3f8-4818-a9f5-bff5ccc436c3,2c81b229-6fab-4090-bcd7-d365b2c89bd8,80c8cb0d-2a58-4c6a-b85a-1871556f3bd5,e227e0a7-7e27-404f-95bf-0ba514d2fd71,816e28cd-bb59-43eb-8279-2438dcbe96e5,6711f5e1-5b8d-4163-9887-80309739ac81,a1c75acd-918d-4cf3-a8cb-e325bec348d8,376033e5-f369-42f1-9faf-92823297ae02,37c4fceb-abce-45c3-a7dd-80ffda180b13,973fe5ca-799e-44a6-9b57-170162a79cf9,64e49706-55ba-469d-98fd-ff91daa6e45f,13a620e9-0db8-497a-bf9b-b43984aa5c58,53167556-5379-4657-8ab9-69a564517742,648e8ed5-99b4-4e0a-b232-7855b7941397,398ed1cc-8dac-496b-8fb7-fd148cf702ff,8f806fad-d315-4e17-8e6a-3cacc7370295,8befdf50-e422-4395-916e-7a09c484e9b5,1783006d-3b0c-4f33-8be8-1354e24b9637,0c0dedc8-d4e1-4cea-bb96-3f9b0d8697e2,ee21eb5f-6804-4ce3-b1bd-c893e9443997,7ae92868-d322-4215-b313-21062c3cfb95,e832b1c5-bb0c-4022-b8cc-5f90f6c9f3da,6dfc5d47-09f5-4269-9baf-2c3cf9a56b2c,75956e79-335f-4ead-b662-5e8b2721e9c9,04638928-c3ee-466d-9f88-96b0ac32c913,045639ea-4964-404d-bd4b-712b5dc396b0,4f0620c6-3800-485a-8230-b1df4b15506f,5c7e5a48-923e-4b44-8a27-725fc9b8adc9,eb77cb86-bb14-452d-9a6a-2e55fa801604,2eb1619f-42dd-4aaf-80e8-799e9496a176,469592f9-1b62-42e3-8043-15dfd6299b06,3ca34256-c4cd-4077-b70b-e983755e47ee,9fcf7260-9a21-4847-be9d-93405bb2cf7c,8d748877-91b4-4ed3-99e3-fbae382744d0,414c671b-bc43-45cd-a1ad-073afa046db8,7a639265-cb39-47bb-88b9-29ed4e1e6624,5e0f187a-4835-48c8-bca3-14fd8652f9b7,c9ebcafd-6509-458e-9805-95c04290ce03,24badc72-3097-49b1-ae9e-f9fb6c118110,590e3962-1fef-44b9-8eab-f61facd6eef7,99cf3b67-a301-45f4-9702-3650f29d75fd,a78bbd33-9f46-40c7-8b01-6a00b4840aa8,1ee263a9-7599-4f03-b98a-655e155359e1,22d0c717-2151-4730-9e95-6dae21fa9670,20245ec7-3b88-4c81-845f-430c3ddd39e5,be67bb36-be36-47fe-9474-ba4054d9e2cc,67b581d4-6816-4905-9d5b-9fe3e5213fd2,6d9befa9-657a-4ab0-a34d-190f0a824152,8d70d14b-31e1-4d12-8aa1-8ee7a2dcf4e9,937c7061-3593-4526-970e-28e40395f388,9a226370-955f-4ad5-ae44-48ec8995978e,0e6a64e7-ecca-4bf0-98ae-f679aeaf11cf,bca16d0c-5b71-4ab5-97c8-2d3f79ec62ca,e0167121-d70f-4a67-9f29-7b7096184061,2ec653e0-95b0-4043-94e0-99f5d63f307e,b3e38600-8817-4d65-b938-3b4ae9a41e01,ced1f300-1d5b-4599-9b23-af55e854b5bc,99b169ba-d3cb-4f71-af34-2afeeac777ab,c88bebf7-94df-4c75-bdf0-220147ea2ca8,911fa308-19ac-457f-88ea-71af8ecdf95d,862608d9-197d-4a2a-83aa-fa0c2d5a3708,2762bf1e-baca-43b8-bd6f-b7182370b401,07bc6093-5129-4819-b72a-0a9454259854,32a16d66-924e-4d7c-9501-1d69763f151f,1d7ecb72-a3cd-494d-8cd6-b6206b705a5d,53aef26e-7f59-44c6-874e-d4351a141039,53720dee-53b4-4e8d-b0aa-ad21e8ce9d3d,30061231-fc86-4ecf-9de8-6e6d9f9b4b9a,465101c5-3dc4-420f-9bd0-b6302966c8c3,951f6c27-4445-4af0-b147-b03a123cf6b5,c70a111b-65bb-4330-9901-8227eb924b43,bbc379a9-6b56-4ae0-96fd-3a284980ff24,c83c479b-14a8-48d5-a671-c5fd11ba2afb,211ff1e7-a67e-409c-8c89-fa537285866b,a3d60675-0768-4f24-a297-cce3f825ebbd,8919598e-7fdc-4729-a248-567de6efffed,591c51ac-c5db-4629-ac89-5ad3ac5f162b,54a19ce7-f7ae-44ff-b641-3ef4761a3659,1d2834d5-f706-41c4-b683-128d3cc552f7,b4e60d99-1c15-46b7-ae5d-97b7173e5dc4,aff9ca1f-2ed8-48f8-bc71-1d799c62173e,90a0fb83-bf54-47f2-972d-db0fe7400747,d4192ffb-f152-4847-86ac-7764c566b12c,244da432-cc55-427f-89ea-233448503372,aa023bc9-fe57-405a-9efd-31e47ea574a1,49bcf8fa-45c9-4fc9-8902-0dc1ec008859,fb6a9000-4c74-409f-849b-d0d24b13105c,23abffea-c898-484e-a4f7-afbf7137ac4c,8e77ef03-966c-4fca-b51b-139b2ee7a272,ac296d98-d5f5-4735-bca4-12c27ec244d7,8cd2d594-6f54-4ef9-9888-dea93e843dfc,2aa4110e-1acb-419d-8451-8cb41b065eae,28182f25-b45e-4bbc-8237-855c1b1b2707,8fcc8b85-0af8-4f8e-b71c-38f005b954bf,798e70f4-67fa-4b49-98b2-92c052e43687,b7e51bfe-1245-415d-bf09-6034ec35cc4d,082db034-c7f5-46a2-89fb-ff1f7ff0e457,8343edfa-e7d9-43e0-aaaa-dc67ff9dd119,ee5035c4-35bf-47d5-841e-6e12aca5cfee,8252ddd9-6599-49ee-a4e9-fd27746fb5a9,e1cc3859-c54f-4bc3-a2a1-f2aad15d84bb,bd901546-8150-40a8-aa0f-51a82b3a2d59,dad1ffcd-0fcb-4f11-aa3f-091d099aa142,0632bfd7-db4d-4ac5-bab5-b7ab904c3e46,02a9fcb3-da0d-4aa8-9474-635c183169c9,747d3ccf-b5c5-4980-bb64-6ae8ddcee5b1,0a982709-e637-4f7d-a2e1-73b5f32b7a1d,03715e4f-f97b-425b-b614-c376c2c16e84,bb9bbe14-e64d-49d2-8e4b-8f31e4c983bc,eebe099e-d160-4057-856c-f55fab3c4adb,cf73bd0c-86c0-4d54-ba7c-087441360b6d,2b29c12d-8e27-4990-9440-2786b88301a3,8803e0bb-45c0-4639-af94-137fc29f3f40,4fec8417-bffb-4e89-be4c-b1281669b36f,9831f573-3540-4697-9306-340c8111b6c5,252418fb-95b6-49f4-a528-13e8ca61983e,3986eded-5b31-4789-9a52-f431dae94f76,54c07f80-f2d5-41df-9bd7-e97430d02ad2,123b21ef-398f-47d1-9be6-f0750dead0bb,5a55eb40-f149-4c51-9237-a963c4a26d11,01c4933a-8945-499c-9992-2ef47362bf07,8eedc63d-20b4-48ed-899f-b8143762bd95,66315173-e245-4b06-8c26-e77059cc3426,c8225f4f-802a-4d46-a5fa-98d7efcb187d,8037df86-1093-45cb-9732-b7b8f489c23b,eb9c7466-10ea-4b97-8343-e49757cacb95,767d55ac-9b2f-4b3a-8822-6462436131f5,77597dd5-1b65-4d37-bd7e-e1d5be1ff87f,6327c5a0-abe1-4345-805d-1c260c4ecaec,6cbfc6ab-eac4-4003-8f53-8783f2a1221d,82646c82-b692-49e0-a252-9ff012506c37,61c435bc-66de-47a7-b9a3-bf35c4bf24fd,a078e9a3-49b1-4f49-b866-e99f70594938,fe49567b-18de-4bfe-833f-6e397a25de40,aed200b4-ac22-44b1-83e5-2657b17b4dd5,04b3b7e5-3835-4c1b-91d6-509272fddc6c,09024897-5e89-4211-9dbc-bbfe756ceb83,a3e20be3-dc05-496b-944a-097a68e7dd83,6559c270-605e-4f45-8028-6f11fd4b3599,8b73a855-21ec-4dd0-966a-696c5392fbf3,29e1fed7-1a4c-40e5-b7f6-81ac62fab3cd,1e9ca4ab-040b-4e87-b474-0032c05b19dc,5ea92cc0-566e-4e54-b0f5-4b264aea22c5,cd35a3b2-9ff7-458b-9359-8cbc9513391d,7d238c08-3d59-48ba-a4c8-b1227e646aa6,788870a1-d78a-4442-af00-2e87cd1ce1db,8b92b529-3df8-4c53-a67a-2d0e7dd4b42b,b2b02b08-6b5c-4d0a-a496-383028adc5c0,6cd6b63b-94dc-42b1-8f4e-cb17142fbd25,47df19f7-2e51-48e4-9eb2-b7564543001e,714de7f8-a8e8-4482-a4bf-f5d0f3723020,aa408b8a-ab0b-454f-a75a-6f5cd05d53b3,44e66c85-adc2-48e6-b79a-f4dd6c6b1b1a,01885b4b-ce57-4b25-ba0f-e25d3a770370,d460cc8c-a653-4837-9f25-50babc8d5bbe,89a049cb-74b1-4137-a785-82df86f5572c,ade8a3d0-42f4-4d2e-a6aa-81f2d15a30f8,01e5b659-c60c-421e-ae58-9f08a5b46714,dabf1559-a24d-4cd7-8046-d96b6ce54c9a,f5ce4b57-6068-4412-9217-8ab3a191a072,f6dec6ec-a133-4346-92d3-3b56e10d324e,db20dbc4-5675-47a7-bf0e-f44a52eeaf0a,7896a1ee-5d58-4b81-9b7a-e62f3e37f518,ef2c8cc9-a923-48a2-8c7e-c96f5200e476,d232f616-b100-4888-8136-d0069b78dc78,bb2614eb-f267-4941-8f37-5b6c4e7c5e2b,08ffd8d5-58a9-49d3-9e2f-2842c00849b4,21672c0a-8ae4-4a50-ab81-be4ae07a70c8,72f6a137-db35-454d-908f-2b9e5f3a12dc,a2d4f566-a64b-4ca3-8d48-16d2f940af37,88d23859-766a-4c47-85f3-fa5cdf737ed5,fdc148b6-377b-4f08-a55b-bcf6e05d71a5,5bc8101d-a2c5-4d87-be82-49995f435fd3,94cf738d-9a8e-48fa-bd00-75a4c64758ef,dd080806-4521-4794-a6a0-9c924143d7ab,8253ad67-30bf-4d8b-9e78-fe813bc8a3e6,a33f52ca-5b32-4dd5-ae18-a0f52751f23a,636c6670-f160-47ac-b3bd-012e29973e74,bcdf135d-0a44-47b8-ab17-63c5309d7b0e,ee85e191-9acb-4403-a43a-5bf13ca26b7e,342b95a6-6acf-4c68-8dd7-34603f09d2ff,d658396e-1ee6-401e-88cf-b6e407d2c031,996ab3eb-d1c3-451b-aaa1-7387038001f2,ee12ed12-6930-430e-8903-2f23c403f60e,7d6ec746-8a8e-48f3-b982-703c3f053ed6,524cfdb9-82e9-43f9-9b96-233bce9749d7,fe91b00a-321d-49a3-a214-eeacd9da9768,f7cf635f-e9eb-4d10-a531-648dd490481b,e0704f67-1d00-4f4a-a3dc-499d83cb50d6,e045ed3f-4c49-45ce-a6e1-62d6417efb77,1bcf0c74-c330-4d0c-b889-267fc8742386,4321a161-5808-4721-b68a-ab267753d043,1e4de2de-39df-4a8f-8d26-62f14e258932,5c21cab1-3c88-4f55-8ae5-01761be2790a,68dc365b-d3fe-4cca-9991-08fbba6e50c6,35c1b4ef-ad67-4dac-8ec9-3e0ead825e99,c04ae923-28a2-48ef-8a25-15c5405a5a47,13bd0298-20bb-4638-b8ab-c0c8d5edd5d6,053df0b3-cbca-4681-a386-396b1bb23d9b,51e509ea-47f0-4f50-918f-79f5835ec0bf,0168eaf7-d9ae-4de8-8274-6e58f78267bc,cab229c5-0edb-4309-a0fa-86efcd4b61d9,29d95690-c763-4253-9675-9a007ead6a3b,961dbacb-6fa9-499b-a267-53b1874ccf01,8038cd63-24ab-4b88-9b22-1fc8f92e755b,c7b928ca-97c0-4a12-9129-3daeab47a250,a2841d25-d5eb-43bf-a206-9f1db39d718e,72059f31-7b71-4de8-854b-71670c2eab6c,53d38583-d935-4adb-a8e5-5faf9409bb99,6c6496bf-2924-4ff6-a40e-57aa51703d09}'::uuid[])))
  • Rows Removed by Filter: 1,133
  • Heap Blocks: exact=692
60. 5.570 5.570 ↓ 48.7 1,949 1

Bitmap Index Scan on ix_l2_party_group_rel_idx3 (cost=0.00..4.58 rows=40 width=0) (actual time=5.569..5.570 rows=1,949 loops=1)

  • Index Cond: (workgroup_id = wg.workgroup_id)
61. 42.424 42.424 ↑ 1.0 1 10,606

Index Scan using ix_l1_questionnaire_response_questionnaire on questionnaire_response qr (cost=0.29..0.34 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=10,606)

  • Index Cond: (questionnaire_id = q.questionnaire_id)
62. 0.006 0.011 ↑ 9.1 12 1

Hash (cost=2.18..2.18 rows=109 width=4) (actual time=0.011..0.011 rows=12 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
63. 0.005 0.005 ↑ 9.1 12 1

CTE Scan on weeks_limited wl_1 (cost=0.00..2.18 rows=109 width=4) (actual time=0.001..0.005 rows=12 loops=1)

64.          

CTE dim_hist

65. 0.021 383.956 ↑ 9.1 12 1

Hash Left Join (cost=0.35..4.88 rows=109 width=44) (actual time=383.928..383.956 rows=12 loops=1)

  • Hash Cond: ((w_1.year_week_iso = dr.year_week_iso) AND (wg_1.workgroup_id = dr.workgroup_id))
66. 0.008 5.672 ↑ 9.1 12 1

Nested Loop (cost=0.03..3.74 rows=109 width=36) (actual time=5.652..5.672 rows=12 loops=1)

67. 0.707 0.707 ↑ 1.0 1 1

CTE Scan on workgroups wg_1 (cost=0.00..0.02 rows=1 width=16) (actual time=0.706..0.707 rows=1 loops=1)

68. 0.657 4.957 ↑ 9.1 12 1

Hash Left Join (cost=0.03..2.63 rows=109 width=20) (actual time=4.943..4.957 rows=12 loops=1)

  • Hash Cond: (w_1.year_week_iso = ds_1.year_week_iso)
69. 0.014 0.014 ↑ 9.1 12 1

CTE Scan on weeks_limited w_1 (cost=0.00..2.18 rows=109 width=12) (actual time=0.009..0.014 rows=12 loops=1)

70. 0.006 4.286 ↓ 12.0 12 1

Hash (cost=0.02..0.02 rows=1 width=12) (actual time=4.286..4.286 rows=12 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
71. 4.280 4.280 ↓ 12.0 12 1

CTE Scan on date_survey ds_1 (cost=0.00..0.02 rows=1 width=12) (actual time=4.263..4.280 rows=12 loops=1)

72. 0.010 378.263 ↓ 1.3 12 1

Hash (cost=0.18..0.18 rows=9 width=28) (actual time=378.263..378.263 rows=12 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
73. 378.253 378.253 ↓ 1.3 12 1

CTE Scan on date_responses dr (cost=0.00..0.18 rows=9 width=28) (actual time=374.426..378.253 rows=12 loops=1)

74.          

CTE date_topics

75. 0.152 384.554 ↑ 35.6 300 1

Nested Loop (cost=0.00..270.39 rows=10,682 width=172) (actual time=384.181..384.554 rows=300 loops=1)

76. 0.352 0.352 ↑ 3.9 25 1

CTE Scan on topics t (cost=0.00..2.25 rows=98 width=80) (actual time=0.247..0.352 rows=25 loops=1)

  • Filter: (topic_type <> ALL ('{Participation,RiskIndicator}'::text[]))
  • Rows Removed by Filter: 3
77. 384.050 384.050 ↑ 9.1 12 25

CTE Scan on dim_hist dh (cost=0.00..2.18 rows=109 width=44) (actual time=15.357..15.362 rows=12 loops=25)

78.          

CTE indices_mw

79. 0.140 386.223 ↓ 48.0 48 1

Unique (cost=287.50..287.52 rows=1 width=144) (actual time=386.019..386.223 rows=48 loops=1)

80. 0.382 386.083 ↓ 336.0 336 1

Sort (cost=287.50..287.50 rows=1 width=144) (actual time=386.017..386.083 rows=336 loops=1)

  • Sort Key: dt.year_week_iso, dt.dr, dt.workgroup_id, dt.topic_id, dt.topic_type, dt.topic_name, dt.status, ts_2.average_period
  • Sort Method: quicksort Memory: 72kB
81. 0.175 385.701 ↓ 336.0 336 1

Hash Join (cost=269.45..287.49 rows=1 width=144) (actual time=385.231..385.701 rows=336 loops=1)

  • Hash Cond: (((ts_2.topic_name)::text = dt.topic_name) AND ((ts_2.topic_type)::text = dt.topic_type))
82. 0.728 0.728 ↑ 1.4 182 1

Seq Scan on topic_settings ts_2 (cost=0.00..6.55 rows=255 width=25) (actual time=0.406..0.728 rows=182 loops=1)

83. 0.022 384.798 ↑ 3.3 48 1

Hash (cost=267.05..267.05 rows=160 width=140) (actual time=384.798..384.798 rows=48 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
84. 384.776 384.776 ↑ 3.3 48 1

CTE Scan on date_topics dt (cost=0.00..267.05 rows=160 width=140) (actual time=384.349..384.776 rows=48 loops=1)

  • Filter: ((topic_type = ANY ('{MainIndex,Index}'::text[])) OR (topic_name = 'managerIndex'::text))
  • Rows Removed by Filter: 252
85.          

CTE indices_val

86. 117.326 19,259.440 ↓ 1,224.0 1,224 1

GroupAggregate (cost=9,900.85..9,900.89 rows=1 width=156) (actual time=18,950.925..19,259.440 rows=1,224 loops=1)

  • Group Key: im.year_week_iso, im.workgroup_id, im.topic_id, im.topic_type, im.topic_name, ttr.child_topic_id
87. 590.519 19,142.114 ↓ 270,631.0 270,631 1

Sort (cost=9,900.85..9,900.86 rows=1 width=148) (actual time=18,950.898..19,142.114 rows=270,631 loops=1)

  • Sort Key: im.year_week_iso, im.workgroup_id, im.topic_id, im.topic_type, im.topic_name, ttr.child_topic_id
  • Sort Method: external merge Disk: 23,296kB
88. 343.780 18,551.595 ↓ 270,631.0 270,631 1

Hash Join (cost=34.62..9,900.84 rows=1 width=148) (actual time=422.155..18,551.595 rows=270,631 loops=1)

  • Hash Cond: (dd_3.year_week_iso = w_2.year_week_iso)
  • Join Filter: ((im.dr <= w_2.dr) AND ((w_2.dr - im.moving_window) < im.dr))
  • Rows Removed by Join Filter: 260,489
89. 737.277 18,203.184 ↓ 5,711.0 531,120 1

Nested Loop (cost=24.02..9,886.07 rows=93 width=164) (actual time=417.492..18,203.184 rows=531,120 loops=1)

90. 2,501.842 16,934.787 ↓ 5,711.0 531,120 1

Hash Join (cost=23.73..9,857.14 rows=93 width=164) (actual time=417.471..16,934.787 rows=531,120 loops=1)

  • Hash Cond: ((im.topic_id = ttr.parent_topic_id) AND (rda.topic_id = ttr.child_topic_id))
91. 2,818.913 14,431.740 ↓ 3,214.0 6,633,696 1

Hash Join (cost=0.03..9,822.61 rows=2,064 width=164) (actual time=416.218..14,431.740 rows=6,633,696 loops=1)

  • Hash Cond: (rda.workgroup_id = im.workgroup_id)
92. 11,226.543 11,226.543 ↑ 3.0 138,202 1

CTE Scan on raw_data rda (cost=0.00..8,254.26 rows=412,713 width=68) (actual time=29.923..11,226.543 rows=138,202 loops=1)

93. 0.027 386.284 ↓ 48.0 48 1

Hash (cost=0.02..0.02 rows=1 width=112) (actual time=386.284..386.284 rows=48 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
94. 386.257 386.257 ↓ 48.0 48 1

CTE Scan on indices_mw im (cost=0.00..0.02 rows=1 width=112) (actual time=386.023..386.257 rows=48 loops=1)

  • Filter: (status IS NULL)
95. 0.164 1.205 ↑ 1.0 428 1

Hash (cost=17.28..17.28 rows=428 width=32) (actual time=1.205..1.205 rows=428 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 35kB
96. 1.041 1.041 ↑ 1.0 428 1

Seq Scan on topic_topic_rel ttr (cost=0.00..17.28 rows=428 width=32) (actual time=0.396..1.041 rows=428 loops=1)

97. 531.120 531.120 ↑ 1.0 1 531,120

Index Scan using date_dim_new_pk on date_dim_new dd_3 (cost=0.29..0.31 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=531,120)

  • Index Cond: (date_dim_id = rda.date_dim_id)
98. 0.007 4.631 ↑ 27.2 12 1

Hash (cost=6.52..6.52 rows=326 width=12) (actual time=4.631..4.631 rows=12 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
99. 4.624 4.624 ↑ 27.2 12 1

CTE Scan on weeks w_2 (cost=0.00..6.52 rows=326 width=12) (actual time=4.581..4.624 rows=12 loops=1)

Planning time : 49.963 ms
Execution time : 19,268.560 ms