explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d1Qs

Settings
# exclusive inclusive rows x rows loops node
1. 0.318 3.257 ↑ 1.0 357 1

Hash Join (cost=159.21..475.78 rows=365 width=1,919) (actual time=1.896..3.257 rows=357 loops=1)

  • Hash Cond: ("Building".uuid = "otaBuildings"."buildingUUID")
2. 1.312 1.312 ↓ 1.1 843 1

Index Scan using building_pkey on building "Building" (cost=0.28..310.58 rows=756 width=45) (actual time=0.263..1.312 rows=843 loops=1)

  • Index Cond: (uuid = ANY ('{454c4685-b291-4d17-bdf5-10e26a1a1251,0994bca1-3b67-441a-a4be-4a0286775d6c,a3ceccf4-273f-489b-8de3-9ef2371d3ed7,faca16c6-ca2a-435e-b856-ec004e0eab77,55600abe-15e3-4c3f-9ba6-48c427a8e413,8b2685f0-4cca-4f00-9980-8ed189191b5b,eea46146-a171-4e34-9b60-6139d577218f,3588e4b2-b4c6-4be1-bde5-b52988ce05f4,6cae689a-00fb-4257-a37e-032245c2087b,00dc5c91-b3a3-4a65-a751-3c687c55aba6,8601b152-2de7-4c58-9558-4d63a891b560,1d140c0f-78d7-4f4d-b807-0c87d2822e59,167fec76-84fd-40e0-83de-09dcaec1d9a5,f5b3489c-0d28-4502-8f8d-b09c5388c3c6,6494ca1b-c872-42e0-af9f-6ea9415ef233,2fb13486-d92b-43e4-bcdf-9ba2bf4dfc71,9433b3d6-b7c9-4dc3-9e99-3177c715ccf6,14d3f0c8-8936-45ae-b8d6-7e4483bdf1af,8b8c22e6-fd74-416b-859a-be1de143fb57,38b70f36-6ffe-44e4-975c-b81c410b63f5,bfe11b9a-a67a-41a7-91a1-edadeeb67408,d554feaf-af27-405f-b6b4-bb5057d2e9d4,3e3847ec-418e-4e5e-a991-9dd552c26123,bbe3cfcf-1ac3-418a-b992-a9e6deab2a0a,c8b63854-1b2b-4c65-ac7d-2a783aa4477e,08e1cc28-84e0-4d60-9d47-986764082f61,de1a8d13-098e-47a9-aa55-cbb5a37bec00,c3c644f8-8137-4086-bd56-47f0f756754d,cb6c7f4c-2683-4aaa-9d46-a4a4289e2767,e7c97ab3-5088-4fa8-8ca7-6a00bc21aac8,e1b95066-f3e6-455a-8fe4-bcb03b66bbc1,c1f5739f-d6cb-4cd2-9d24-37e9e798529b,86742baf-4d03-4842-ad8e-922a7855770b,8d23e717-1d8f-49e5-9979-e91559942a86,e34364fe-8367-4c6b-8c48-e3c6854baeb2,cdfee317-f151-4eb9-941d-d691122be29d,4772d64d-448f-47cd-9362-0dde609cd094,106dcf6d-8a1c-498f-ac39-56460e14aa8a,6d8db287-911e-42d3-b817-e74680be0ece,3decb11e-bea3-436a-936f-ba5fa633390f,403ae902-7e76-4fc9-823c-8ab2e6bb555d,b3b109fa-bec1-473c-96a1-44ab1e5e5d35,933954ea-5a4d-44a8-9364-4004753fab8d,0102df63-f393-4af7-80c8-7bc868d38cab,9be76ca8-fea2-41b3-b0cd-35b989ad4445,334d7bea-12af-40c3-b99e-cdcdddb12ae8,aeb318a3-33c1-445d-8859-9312a8bb06b7,8659fa71-f703-4695-82b2-2903d21e3eca,0b4498dc-773a-463c-a0ad-0979cb85a88a,338acfd8-da5c-4003-bcee-7914986e713f,4c46c035-5af0-4a41-8a8b-7d98cb75d464,d552b075-6387-4237-b8cd-9f9b8140dfc7,bc42eef8-2fed-4a3a-ae79-affddf79c933,4a624733-0153-4759-b8e5-0cb3e5752a8e,2bcdf68e-0ac6-48a7-8972-78e0be11d73b,74983a17-4c99-4408-88d9-06654b4236aa,5a642f63-5d4b-4e10-95c0-69d7d0f9cb02,bc6cf211-5e43-4f41-86a0-9e2520261686,dee41fc5-649c-4a89-aa40-19d88790ac23,b5660592-8af5-476c-8c36-bf5c360dfcd4,605d69aa-156b-4f66-9bfe-638dfc97481f,9fd3a408-b45f-4239-b007-558c89f397e5,ede7a6fb-78ed-4dcb-80d9-21d44c280bdf,50c4a650-3771-471f-967f-7f172b11ccbc,9a47a4d4-c98b-4096-bfcd-3c02c789165e,7933eed2-aa6c-4078-877b-56ea4a16a85b,cc4fe9f9-e35f-46ed-820c-db886ada1fd7,4949cdac-3c86-4df2-a487-b3cd3bb03ebc,e4b097d5-2a53-4c25-8a63-51eaf0eccd8c,05f0f681-1f60-432f-bdcc-09fada453b91,0100f6fe-716c-4f21-9055-aba55aee654f,4586439e-8b8b-46cd-96de-7d547eda33eb,64d43de9-2b4a-487e-9f80-605aa7ad7e39,7cd32cd5-bb3c-441c-83c8-28264c9d7eb7,722c352d-f83b-40e4-acc4-02ec7b2be02d,4e6bc85f-6622-4b0b-b2ea-9fd64d2aa566,a17b83ae-bb62-40a8-ad30-0e0564178474,cc1a7b9c-7eb6-4b79-8147-689a5526ee60,4ecbe6c5-1b4f-40bd-bb20-11bcd59188ab,e1fc383b-a0fb-4f3c-b2dd-5650a546a862,10cd8c6b-a074-4eee-a32f-6079e112640e,ea7b5784-369c-4a04-a37a-a8fe352ed223,2320fff3-f268-4d78-8c03-f3caef85337b,b9ac3f44-3d0a-46c8-976b-9cdead249c0d,22ff60e7-5a52-4a89-8a91-2d9208da8e81,7e4d1d4c-ca9c-4b11-a563-06435fcf5c69,fad24cf7-2554-4ee4-888b-24c414d090c8,fec1f317-cd83-47a8-a713-4997e295e5d7,964ff85a-3b09-4fac-8c6a-fb6bfbe7baa4,b043c181-5e39-417b-af16-4176a37e50dd,2580d6ea-a924-413c-9bd0-9ac69a0b9432,d6462633-94e5-490e-a964-03eebc23585e,e72254da-3d01-47aa-87f3-7a8cc611e406,033543ce-876f-476c-99ca-1abd8a575f05,d9d2968f-7e1e-4299-b9ab-24ab1c62f865,ad28b93b-8e56-4afa-8556-adee6ed7d415,82d0fa75-7ac7-4c7d-837a-36c4d9206e4c,15105b3c-cd4d-4bbd-bb9b-55ab3cff6aee,6d9e5767-312e-442e-9b27-7d59e9518c52,c748e0d8-8b6b-4266-819d-ae0ce399ffab,cbcb0d13-711c-4ae7-9bd3-d49a091d7a88,533cc65d-2b1f-4f0c-bc18-c0a32f8c4a3a,96c1fc22-6d7e-4ddb-bfd9-f9af8ed60d4d,7df914fa-79e2-4e14-bd48-b2253a188aa5,3b435c37-fc63-40b0-b90f-c2a57036471e,78e04bbd-3736-4ae0-be83-807739786dd3,4c3a07b5-d3f9-4b96-b690-c52ed996612c,fa5818f8-1cbd-4915-9285-e387b71ef206,9822f9ce-ec16-4b67-a2a4-bf0627f1c45c,ef9dfb8a-2da5-46c3-ba54-2ecd7860cdac,0b1fd182-59da-4250-a35b-11bc179399d0,8e64e359-50a2-4430-a3bc-c351c70730da,be82f24c-79ae-4dfb-8de1-d47579c8457f,d7c293f0-afea-4a3b-a0a7-50f71d8074f8,eebd4a0d-1f9d-40a1-9576-8b79b5b93336,1dc8061b-f974-4363-873a-7429c98af208,9ca1bdd7-d65c-4ec0-a7b1-6acbeedb7585,e437ea68-4b93-4754-b570-03c29e164cf7,d5b5d94e-fe53-46fd-8c29-af89ec1afed5,cec56f63-461b-44a9-aa74-ee2476a2115a,b2bbfaa9-9250-410f-b60a-be26e383d64c,0ce40e93-220b-45e6-8254-403b88a40824,1857fb69-0d3e-4ec1-b194-d958ec782557,074e6a43-5076-4d21-972e-a82ea9059956,7bdb3d8d-e1ac-4b28-b8f4-7866eb4f95ff,85f9bb10-18a1-449e-a92e-f222f5b33621,dc087800-1a85-457e-9f13-857622cb7d9c,d0f8ab6e-c710-4917-99ab-09d70ccec0f0,5b8ddd5e-2542-47a6-9b9f-4bc1a3703fc2,89ad0def-5920-4ac7-bca8-bf9ba30d79b7,86d91c37-9859-4931-913e-f3ef9aedad30,ebce496f-02e0-4aae-8010-3fec957be2dc,9a7f6e9f-0c69-4de0-bf66-b7e5187a0faf,589fc95c-f9bf-45a9-afe8-da0341b54a66,4a8a850e-733b-4219-9881-ff8ba4232434,9b492941-9cab-4e98-bb45-f3c2a78960aa,9f27c038-0ac1-4d03-b1b8-8fea078cf4ca,39e7c729-5d1c-4cb5-8d22-b7c6bf3c1736,6fbb88c1-4683-42a1-ad8a-78b7d6910631,ebd6dc2e-a458-49f2-82bc-5ab2f6b1af46,beda86a6-2952-4611-a2c7-e82d463280ce,ed1f8df7-3385-4f71-910b-40e727cfcdae,69883fc0-e17e-4ff5-bc10-cc0ba81b7c7e,c04c0f1a-9031-4dc3-a19a-3e15c858af1d,7d0c9b9b-e2b4-470d-9a2f-e5b836b9e04c,1966bc71-1d49-4a00-9156-eb29f833b6a0,64851aff-858b-49c8-871d-a5b0df0fb631,3d7ec8e8-c6cc-4385-a0c8-b1273932017d,affddaf7-275f-41bf-87d3-a0d20712ef73,5f7147dd-8abc-4478-827c-6daf8d7df76c,dfa0ccc9-99c2-4e7b-8aab-4f8cf886d022,18843349-c59f-44f4-826e-e1d6b1d6f566,0de57934-d0e7-4f10-8a9c-ddc92d4f360e,1f9056e8-8013-4af2-87a5-7394b73c7d8b,9c26b62e-9127-4606-8a63-7269db4eacf9,dacdc4d7-e515-4d98-9244-cf9978d007cd,b2228e14-325b-4db8-a2ce-0fb9171928e4,f7bd9759-4d66-4f65-9f80-9f28cde114bf,d381ad7f-aee5-473b-b763-65c8acc20659,9bb35cf1-a915-4768-b225-8b0427db2a4e,c7a5e213-cb75-49ca-ae9b-121057454ef3,c4ba808f-2f87-4b1f-98dd-91ca355224ff,6f390368-16e4-4f3f-8ee6-ceca53acdaff,b92a3910-39b5-4968-8ce4-c2a14a0a36f9,967e276d-d662-4cbd-b3fc-078cfd9cb410,36e6c625-e982-4cd0-ab3d-96ae11f47e42,a9ac7901-d091-4ea5-a817-63f6daf64b4e,ad8c3378-b4e0-432f-b635-f66db47d0e66,bbd8b83e-5b84-49d6-b0ad-feb43efe885c,26c7f4a4-e6d9-4185-aaf7-cde84903eec6,b0e24f57-d9f0-4fa2-aa33-50f1824ab41f,dd0d8df8-9753-4a71-bb47-126758cc0d1e,22e9af46-a867-484b-a04d-ed7a2afad760,fe672132-63b2-409a-9c0f-1a6d1c38c741,9d931380-172b-4a22-afd0-ec41f354fe51,a29adf57-08f5-4d2a-81cb-14651bfa29ee,7b6e7279-f5dd-4ff6-9987-d1e78b132e90,aaab6eb5-2e74-4986-ac7f-cd090922e505,4e9ebbee-1a59-4037-afeb-930ff353acf1,109a1197-81e8-4208-885d-9e92c17c6854,394795a6-5edc-4485-8727-5acdd6415f59,d2c5a528-763d-48b5-82c5-98a6f4fc5880,a74a39c4-5f35-41e8-a7b6-d148e20af008,4ea703a8-0921-4ba6-af0f-917b75c7d6c8,7aa25c27-a907-4d67-827e-fd092fe0df8e,e381a1d9-5c27-409a-a352-db2b08a23bcf,269b2ed0-96a9-4f04-b9c6-bfe46a58afc2,9dd4ea50-da0d-442a-964d-71bdc3159ed0,66b8b704-f994-4c10-90b0-76448e1f7f78,607664f3-ffbe-4bbe-af42-db3c52625a2a,53a8e935-aeea-46f5-9512-7c0bfccc8b02,9367d835-38eb-4ea6-a06b-7012273a0a5b,6151873a-077f-4411-a647-273a07f7f6d6,040d97ea-b632-43b8-8fd5-91699afa9d97,ecea1e82-c62f-4f29-a49c-f8e5f9776d90,2278920d-5ce9-4b30-acfa-6c652724c064,15eae160-5a34-4826-87b5-fe0257cba4dc,b1b3a967-f0d6-4a24-ac79-0b0506487499,f3d4dcc9-9ec8-492c-ba1d-c18a79933db1,f3e17df2-db0a-40c1-b2e8-4b90f8f47fc1,bc5ac2c7-9ed5-4e0e-9ab4-acbf9655f993,1bea0ca6-ad7d-4560-9357-6b4ed5546953,0d5ec6a0-ff4d-4780-88e0-41988f115b72,a77f3b55-97ed-4eab-91b6-de7718803826,dc98c41d-2011-4f44-a365-3b4e4592d719,7f732da3-cbbb-442d-bd8c-da34343d1b02,45af7334-45db-4d56-829d-da391d8622ff,c828d050-c92b-41c8-9434-9c339e3ab35f,2bfe39c4-6e23-432d-993d-e9c3f7139e8f,05d81d82-e16d-4dbf-8de1-aa5bfd2b4e49,6e566474-64bf-4eca-9285-f9d10b01463e,2a3655a4-cddd-4b6a-bf9a-75c2c2b4f2ee,a44c74ca-78ba-4353-ac93-5410a27b8539,a86c51ca-8180-461b-b90a-a73b35e302e7,27072901-591f-40ec-aa6f-e3184a808422,535706b9-1481-4e8b-afea-97459e28e4aa,8849f6d0-c926-42cc-823a-20a8eefc4d29,3bd5b849-aa18-4f92-b173-35df415b31a7,f0007051-ac64-4071-b813-f0d7b1bd9521,ec585057-47af-4f6d-845a-5d735a677eb3,0a10c04d-3355-4a33-9f33-238d9079ec84,5795a30e-2bab-4c4c-a131-93b61c144146,205d363e-2048-47a1-91cc-a5553ab0b7f1,c4f4d2f6-2a27-4a77-9e08-a9481c531622,2e5027a6-08d1-4839-bfd9-bcbfd49eac13,98b3713d-0901-4943-b30b-37fed83b280e,a3ab1d9b-99fc-4937-a241-36ce8f2b9de1,5293ba8b-c7c4-4829-8c00-7879928d640c,ff3957f9-8c17-4401-84c9-afaa9e55e2f3,f07cb4cc-f07e-4177-b8b9-937e3188ef58,014c94f9-62b5-4480-98a9-db9faeef1dc3,3ebf84df-0f1c-4405-bd8f-92ca92be0afa,e648992e-b5c3-4a40-b903-affa489a859b,5b636490-b2a4-445d-bc36-d94fee9af9e1,a3cc763c-c40a-4155-8116-5634d8b09103,407847bc-6bf0-4eda-b5b9-010496b02102,f1937b15-e42d-4d52-bbc1-16562f11edd8,9aa860df-1acd-4c88-9532-b1201a9f6c16,74107f72-1376-4927-9c5f-cb13d33f3f6f,9f48a64a-498b-4916-ad75-22fa728d022a,9861f92e-77f0-4e2c-a668-b8bcab73e539,58a6e20c-9c3b-4e48-b205-2cacb0cab201,2fcafafc-9c4f-40e7-84e4-bfe91d068002,c1a72d16-ac75-46ab-8781-9311a791dad2,b75b2e8b-916b-4f58-ab1e-dd03c6216c21,9a86ded7-b5c4-431a-a8e4-95f53b80de8a,ca0d1a92-b979-43ac-8360-2e1f5dcad4cf,41df8c99-0a53-4f40-9afd-f46056144c99,ec3b3401-0012-4c96-96fa-9c26e99fc207,1a688708-0a62-4ddd-8a99-6c43c3404dca,ff872011-306b-4f32-b22e-4c021efc7129,c2ebb8c9-da2b-49c9-bcc5-b9678ec020c5,04bdb8ae-c959-40b5-8284-c1171b811f31,fd7a2799-a09f-4a2d-ba8b-98561d77a589,c93abf34-f74e-4e59-aafa-0b0876e05b75,708f1fb1-1211-448e-93dc-6373f748681b,13aca6bd-6eab-4e19-bac8-6c856bc282e2,b2292b38-8707-451b-a276-10ce4c1acadd,0dc6220d-81db-4829-8d85-e9a22ae424f2,7e970a48-1c32-4aab-b277-aca415a6fcc5,ece981ad-25be-4c8a-8e2d-078aa7c8d5da,e265a999-61da-4d3f-8142-f7872362f1a9,c024a48a-cbe5-4f7f-833d-23f1a59cf6cf,143accc2-5e97-4aa9-ac39-a9bfee6f6fe7,0ef1f826-fe59-4ed4-817a-214148c9f7ff,748dc98f-5a87-4f4c-a3ca-35b2476ac599,9c4971af-e321-4e53-89b8-29f3042597e7,1397c402-9ac5-47ff-b483-5122a7dc9770,552db1d2-85f3-47d2-8dff-20c6c8bcad8f,c53af25e-dafb-4af2-bd63-ba5f104e6eb5,fd8fcf53-1d15-46d9-baca-cc8f4d49ec24,89015793-b807-4843-bc1f-70090eeed0cc,10b4686b-d72c-4d1d-9a90-b39493c2d390,6b98af69-de9f-4406-ab18-956c16ed1e2e,9f34315e-5814-4ba6-910e-4fbfc887dda1,4fe1dbaf-83fb-4f9e-b42d-050ba474c5f3,a1908509-ed8d-407a-a67d-9713d66ec5e2,290b9607-e79d-42b3-945e-d09b6718877e,58c97639-07e5-47d8-bab7-1b4c10b037ba,f7834f91-8fc7-4641-aed9-33bc8428b072,25e4b8af-edc5-48cb-8377-870efcf98a92,250aea2e-b24c-49f7-a7e0-7efbff5a0b7b,1df03d35-68d7-4ae5-9670-a05ee0810e35,020d401a-1166-4ccf-9f4a-7131e365a25a,5d84cf5d-72f8-409f-b76d-ef096c341c4b,3c5e4d8f-2261-491d-add2-e2456d476443,57a0396d-f3c5-4ebd-9827-a21988ed4a3f,9143bbac-c7ff-4b9c-869e-54a34870ef12,8bb99267-f35c-4a2e-955a-6bce27c019c9,9dcfa59f-67f2-4da6-be1f-c1b111939a34,05c12594-8a33-49d2-9f87-b8aab869d37f,1fd2e486-ee89-4009-8cbe-f1770564bd1d,540404a8-a011-4f5f-ade7-51ce927a745c,c3f38e2d-a2ac-4b18-b8d0-210868509813,c6769ced-d9a9-41c6-b76b-f3bda046c72f,4c28c951-36de-461b-abe7-116c712e29ab,edfb0229-87b8-43aa-9b34-6ca2eabb7cba,cf16f584-a582-4515-9d30-ae5bd4d705cb,d9c74039-3730-45d3-b9de-75e6d9f35f10,08c3f9e3-12fb-4d68-8aa8-a281acb2b263,a8f6eb06-b58c-48c1-950b-0fad4447ec38,fad7a7ea-8c1d-4320-a8eb-dd5a11973947,b15e1aa1-742b-4da1-96c8-32805d082fe4,9be2b548-d431-40a7-aeb7-494671c11ef3,4441bc5f-8d65-4ba6-9203-83e0d71e8395,b4a3b42a-2b72-468a-a799-e360097442a7,ce4076e8-9153-4547-8df5-f070d7c50d27,897ee298-44bd-4007-87d7-bb147a5e9aba,3d0ee152-ba66-44a0-8a1e-39f4a0775a71,2af537bf-6ae6-48cf-8bbe-3d36a18d3abe,560ef10b-f2a7-4b33-938b-28e9048f69a7,10601a65-5de5-4e85-b790-1b1ddd1d24e1,2cb4f5ed-e43b-4fa4-a7c1-029f041a17b3,b7b3e300-c35d-45ca-b527-825549f9e492,b9c0c157-ccbb-4f19-b915-c44a37764063,904ed11f-7314-47ce-8286-f0d7c3435995,2487ad33-df27-4985-8de1-39097da089d1,86ed373e-37c1-447c-b06d-4bb59be12eb2,4840b2d1-6f14-4603-8fbd-cf286cc782ed,abef4580-dcd2-45a6-b641-bf1f5965b695,bb7ccf16-3067-4bb1-95c5-834bbabe8b53,35d8b96a-8904-47dc-b4c3-3c3ec2f95e1f,8cc9552b-e0bc-4171-81a6-307f10ad8f05,4d94ff11-1b4a-4484-b46d-6929f5402512,7e54c040-3885-4222-8f5c-57d6ed500226,ddbb4b1e-d68b-4c4c-ac7c-8862b82cd3e7,cc8e67e0-7cf3-476d-bd77-0def3f41770c,fbd54a52-d807-4ce0-be5e-91514ef3150a,8ef0378a-6b32-47db-85d3-4db3c1d2aa57,021a7585-55ab-4a5c-bc92-b14a2eb923c0,be466850-ed0d-4c12-ae51-73bc66592326,6f07415c-029f-4bac-9743-d8884f4aea84,47129816-0bdc-4ac0-a242-bfd06716900b,8ba23d3e-ed00-4956-a26a-08e5fc9096a5,b09d644f-ee3c-4735-b98d-1a7c51cc961c,a47009e9-2b85-4f79-b336-50ebf230d9e8,f0c68f90-fd97-465d-9bc6-dc84f85e1158,d24fda21-0a71-4b6c-b3ca-3b51b82c871c,9d807817-00b1-4c6f-bdb1-17adfc0ed194,8eb30bc4-264f-46db-9145-b66cc51b3e8c,bfc60177-97ac-44f5-aaa4-57deb6147199,e39151ab-f6d5-4d2a-91d4-c629b9e20f0d,cb151f6c-980b-431c-9e3a-7d2abbd37d7f,63dd54be-5148-4bc6-8310-ddd01f4d973c,3a8049fa-4524-4993-8c81-e346993fa4cc,66aca2ec-6b3e-470e-a1d1-ec01cc0ce17c,49038a7b-61fb-45a8-9764-24d0d525f887,3567d24d-d716-441a-a519-241799be7347,14ba6096-bd3e-4790-9f5e-7aea427083ba,ec0792aa-c741-4181-b2b1-c139baf1b9fc,f08cd415-e24d-41e4-ba15-59d5ce1b362e,572c0e29-08f6-4495-9562-979f35eaefb8,4214c8f1-d168-4178-b9fd-ebb6aafa569b,4e5edba7-2565-466d-aad2-95c425351336,a20283cb-e7a6-4aa3-954a-9893e58c02fe,af700ba9-1f2b-428b-993b-340a4823e88c,42e4b8ec-ae5d-4bcb-b5ea-068dcc71421e,43292b8a-7a3c-4f1c-af17-4d497f6711a0,2eff0366-f17b-4c1b-b457-74b8f9efbaa2,c6faf750-395f-476d-8599-22e5963d474c,c932f1b9-05a1-44bb-a9d8-986913ade642,ba64c199-8d3a-4309-8968-64424943d3e3,4ee28c97-c0b4-49ae-91cb-b6a01da92a7e,cff68a17-9aba-4e3e-aec1-7edd517959ce,6a2b2f94-b44b-404a-a5de-5f26b8819ac3,850b7f85-c06d-4f92-9c14-e244c7020052,184c5b4d-f1bb-410e-bef8-ab748971d551,78008570-3138-422f-b682-396574ae1d09,b9b7cf5f-4bd0-4be6-b9bd-f2a85b76db96,2ac2ecbf-0ff4-40a3-8ce9-306958bea1f8,8c2518e2-fbaf-48f2-aff6-cbed454ff8c2,84bf7ce6-e673-43da-9511-bbca840e7c35,5669e8c2-04fc-4b1c-935f-53e2cdf9dd54,09669ed8-d598-4db0-b297-a4d98c927578,22e0d99f-47fb-4fde-8e3b-b46f9ea04cc7,1fbc8afd-59c6-41e0-ac04-ca2c132a41de,0f967eba-38c2-4f32-8c21-811dc5a01f2f,8b1bfc5e-81f3-4805-8873-ffa0977c5ea2,195835c5-b12e-4331-863d-48633d05436c,f23409f8-fe82-4592-8b07-fc0a90c703e6,39a48004-000b-4744-a128-4361f6362417,e4d6853b-e62a-4c6c-9555-c1de2e4f79e2,c3756791-77df-4eae-8a27-6a1a8557ca30,31e37184-b5b6-4483-9866-54d64f856fa3,08f412b3-079c-413b-b1b3-f3373f0ee527,0fea2681-2964-4268-b07d-ef64606b901a,7b6f329a-cee9-4752-b105-e5b53f3b9055,8e06393e-1a53-4bdb-abae-5d45f9d40344,8e52f5c5-77d9-4aa4-a81e-686e22123d02,10a03607-2ae5-4eb6-b9fd-3b21fe2d9506,60120012-5c31-4d5a-a211-59dd1f3c21dd,f23412fa-8d85-4292-837f-3762cd6c3691,8045058f-2933-43bc-924c-a7969232d441,e4ebe67a-5838-4dc6-9f5f-53f24f8ae290,9951b6e9-6223-4bdc-897d-e090697cc139,9ec1e425-9a4d-49dc-b79e-b9199b3a72f8,8837737c-88df-40d4-b099-31dbf751ac6d,7fbe295d-0fb8-4ebb-b8e7-80c0cf76ec88,c26c0432-7829-41ed-a9ea-dd49d5692879,a797c0ab-4785-4af5-bdf3-3e48992cb338,24bcd3ef-ea43-4b41-99f0-0810ad45b4fc,190a5102-ac67-46b3-95b8-1aa32d9bca90,112dc90c-7f81-4005-a11f-54ad0872df28,27aa3fd5-cf56-47c8-918c-3c1ef8c61080,2a21afca-b719-4029-9bb2-4476eef7adaf,551d9405-b5d4-4067-8172-a684d778da20,c489521e-87d1-4e93-97d1-4299a7ca5206,1438cdae-e98e-4207-8e9d-760ef8a61fbd,13c3eaff-3922-4463-ae49-701e1ec8c8a1,7cd16367-10cc-4c1a-9d24-e5611a36c575,b094d35a-584c-4127-acd5-ed8075630b50,ca8cf7c9-f330-4fc7-8498-b4a9cb897bc4,f08bdfa7-6e32-44e9-95d6-21d6bdf4bf85,be07fdc2-4bcc-4760-9690-7934806e5ee1,cfa4a9ae-e062-4b92-b82d-9417dc48ce32,38b491f8-8631-4bc9-aef8-a4afde055539,9a9a4d7b-6394-44f0-9c9e-bc409d72ab7c,005fc1a3-f151-47e0-9561-5831167effda,41381813-ad09-45eb-beb7-781f5f588966,134463d3-5b02-4697-8548-149bd9bcde5c,8b835e05-769f-4ad5-be64-bf25abfe56c7,caff8a4c-3a81-41f3-8cda-c495eb308767,a5d458db-89f7-4d8d-855c-ccdcf9d94dd6,cb5b11ae-ed2f-4b23-a6d6-d6b2c9f1a8c6,77771d3a-f941-4ef2-a0e4-557d85f21c1b,74cc6341-d210-4c04-9a28-662871733a19,8226ddad-651c-46cd-b6f2-0da8cd300b56,dd5b6892-6fb8-49e0-91bb-778f5fcc7778,09135700-9f7d-4247-8b47-d68d41ff5b66,320dcb54-7c1d-495d-8b0a-be5740fbb77c,4a9b3d8c-3b20-4a91-8bed-80911ec15958,9fcc7d3d-4a8f-4010-8252-1aee95a15329,89e21416-8b6c-444a-8aa6-5c8fdd864c31,90323d2b-2da8-482a-94a3-2251c05139e6,70ea40ff-d1de-463f-b42f-ad40ac485933,d76c6997-07c8-40ff-8ea6-70854ed2e29c,17a483f8-3ca6-40bf-9ac0-6f7dc4bff18c,10302b40-4d33-4a15-9b0a-0e049890a8bf,305add69-13fa-420c-82a1-47542a042a88,47233d80-7111-4696-bef7-f4d619eb7103,26927fc1-8c3b-42dd-8edd-bce04d92079e,8dbabec3-64f8-4f28-b201-45e45af3db42,cf9a63d8-7c5e-42ec-9592-4da1217a17af,77f9d899-9581-457a-a19f-31e0873aea4a,ea0d6a9e-10c5-454d-b296-97e20a16dc37,14a5e860-4ded-4326-bf18-fc4d2c7c4561,6ce61603-ddef-4ecd-bde0-0762aeb2a198,74cbff71-60e7-464d-885a-e9a22c3cf30f,e01107cd-61c5-48ec-b011-1f6173cb07ad,5ad12489-cc97-45d3-a143-416716588c3f,1385bbed-3af7-495b-8987-b3475e606e44,3fad69c4-7600-4ec0-b5d2-d5fcc3efb627,69699a33-44f9-42f6-9570-c1cd371dd99b,61fc0ef8-97bf-4861-8922-9e08152537c3,0649e17e-0625-47ab-8371-d74b7c3babf4,e28615fa-7bd6-4602-9446-ff332a7db651,8bb5a823-c72c-407a-9ee3-b463e5a6bb62,db38eaa5-a94b-4fe8-b015-0d6fdfd7f4a9,c3ad4408-5823-4118-89f9-00e54dc9e49e,d374cabe-a7e4-4bbb-ac56-bef67661b383,42631cee-aa0b-419a-9c2e-a698f8d62b1e,0d4d909c-67c1-4c27-969f-bf83e73447a8,968157f0-f647-4e3e-afc8-528cbd23ab54,8ec9003e-5909-42fc-9f4e-d2c2521bca94,c716c1c0-8ed2-426c-81fd-cbb99ce60c1e,9c35a791-8377-4dfc-8402-ae049060851d,47a80a51-94b5-479d-9e04-ca40735fa03a,a614c56c-445e-48d9-9872-75f0ab18d8c0,69582f7f-a535-4038-aada-1075a3afdf09,0a3fe121-b244-45d1-8c8d-176627882a13,983c670a-a1a8-4344-bca7-f2b8443324db,59b449e6-61f3-487d-84ee-3b60b48a41ea,e2f64e75-e7c0-4e91-a708-c48b26f02491,6eefb824-0635-4521-8b09-e42db45b91f6,8f0ef225-e359-421c-9e58-bfd0f26cd5a0,826fa991-6eb0-4b28-878d-f75f026492db,41e00e9a-53fa-459f-8348-05edc722375c,830e8fe5-f289-49d2-9622-5b70de2171ea,19403497-4878-4584-bec4-05fde37b7d86,2c283eb4-c3a5-4111-93f5-d4e0b98dcb90,7151d975-075c-4760-8fb1-4068e4749119,29a9d362-9e35-46a8-bf7c-a60b86f8fa86,8fadce20-c7a1-40bf-b960-23da0e6fb554,7a71caae-69e5-496a-a63a-743ca0f58794,4fb17fce-b087-4278-8211-9ba58b962e89,cfe42da8-81f2-4d33-9cf9-7c31c95c28d3,af1e2369-05ea-487a-8adc-636dd7692700,c5cc0036-8809-4bf9-9592-ee708c0320d0,d8ff04bd-fc54-4ef4-a885-ec06b6caa3e2,f86b10ca-c607-4f4d-bc20-0f04661c157f,5bc0ef26-dc81-470a-956c-dfcf0e0c2194,db3d9a86-f158-453f-8cf4-8004431c81de,d0050975-85cd-4d38-90b8-a604aa0adb84,a1d84153-18aa-4585-b128-fdca2a94cdc6,cca5784a-1f60-4474-82b1-34fe8dcbc33a,3b21cfd4-c722-405f-9a87-665cf4b86751,833a3db2-5587-442e-b4b0-680919d60bd8,0b665183-5ffc-41f1-a0ee-da15515ad849,72e98806-5145-4e75-ab86-f813fd88f503,60b6a56c-21ad-4370-a63c-e71e86574d7d,ddc87465-6efd-459b-8a32-317a016a7fce,db6c5886-900e-46c5-8aa3-d84ec6e99747,2ad33fa2-996c-4671-b98d-74da50cbc219,7fc3c3ba-744f-49f8-8ebb-8066c8e489d8,7edd5b8d-cd32-4bac-abdb-0377288c1621,4a6ec127-dbbe-43cd-ba3a-20ac1952c97b,29b51ac5-ea3e-477e-a13f-34a4a9f78421,e97caaa6-d6b9-44e7-bb91-31ac635396e9,88eb714f-0d0b-4427-9290-3546422911b3,dfb76703-82de-4052-aaf8-5cd965daa2a0,fad9982b-8fc5-4634-841a-125778b3283a,7c61318a-3768-4a12-a86a-ed1ae056d65d,8f618478-7962-45fd-a4c0-553f0efd649d,595cdd89-19cf-49ae-b042-0e80f53d6784,092b9e77-7c2e-40a1-8a7e-b2bbc6fc5bf9,0f8dcd47-fc73-4f9e-a2f5-ec9f31f2d18a,a904b45c-5ecf-426f-9f3f-ba6b4229e4a0,c6c5e9fa-d0db-4cbd-84ac-6af3f349eda4,ccf0408e-1ca0-4749-9294-24875c96d0aa,9e0538a4-2e2d-4a95-8648-3520b4c44b74,4233c59e-6d25-43cc-b1ba-afd7e331ea45,8dbb8860-456e-40d2-bae3-c7be202561d3,f666e9ab-9ae1-4b77-a657-94ac0dd98d1d,bccf0c6e-45a6-4004-9e0e-8960bdeea339,b466a1e2-d697-4f49-b50d-e7f55273dcc6,daa92b7f-5bac-4c71-aa35-fa9c30b8cd98,ea92aeeb-245c-4887-a02e-bce0793f3a0d,ecb92714-09ad-4d16-a1e6-b5996cfaf485,99807e8f-2683-4cf4-95f9-e590ba074133,86bdfd1c-40ad-488e-b491-6cd53f10bec5,6cfd7153-bb3f-492c-a95f-69204b3398e4,9b9a9001-fc86-41bc-bff3-0e39751b3525,e6a5d77e-e416-4399-98dc-4ffde35f4013,8f6cfb9c-d492-48ff-bbc6-6f94c4ac1c56,86ce73f7-ca6f-4a76-b846-185bbcbe9adc,c2055734-f0e7-4d47-9106-42744af1a181,14fd0a2d-30cb-46ea-988c-042810b34aef,69c5e6c6-65d8-4a76-b85b-a8d5493916cc,387e065b-86fd-430a-8004-59d68a0bb8ec,83a3ef6b-9626-4e35-b7b9-8415798c95cd,19192c4e-adf8-4225-bd82-5977e7cb43ff,c4097b7f-9ddb-437f-b742-26a6ed0983a2,d7ed073c-f19c-451a-9263-bb103096fe2e,a1ac9016-8bb0-48a1-a8e6-5ce84e0b267c,6427109e-be2b-4ebf-b395-783fcf9697d1,ccb72dc2-104f-4936-a1a3-f4f750742b01,57c58990-9f40-4d08-a3d7-1f7c169e9f5a,ee7a8a26-87ab-499a-8ac2-7f8091180238,efb9ff30-a2dc-449b-a144-24f570a46456,c005dadd-da25-4a3a-9c3a-f762777a3fbd,a9e5509f-e972-49b3-b7bf-f0a2e384611e,f4c1faf3-5584-4d79-8de9-73059cc6ed8e,344b1ed6-36e3-4e69-aabe-aff4c91368b7,0c666604-ef7f-49e1-9d69-b63293664b7d,d654d293-9ad2-461e-8347-e0e590c04a31,00a5f3ad-e284-4678-ab4e-4a475bbd2d04,3e226aac-d841-4d63-be95-5aca8a79ac8b,ce33e8a5-05f2-4867-bdb8-89a87cf07d06,f98987a8-2348-4b7b-b82d-3d4befcd067d,4f1bd5e7-3ebf-40cf-b0a4-baabbb854c7d,1ab28465-4755-494c-b422-defcc10adfe9,751570bb-94cb-4951-8407-1b776effbb3a,c40efba4-774a-43df-b84f-77668ff0c956,41c6a148-a4b5-444e-aade-d882d4d5313e,72994b91-7d80-4be2-9904-2ae76a79fc18,62e720c5-6be6-4a92-89c0-8a75f13f2877,a0558f72-34f9-4292-9fba-764fb4ec0482,bb9921af-02fe-4c84-a409-9b41eb53cc25,286b40e7-f49a-4b9f-b393-e4ea99c50b7b,54a29aae-c7da-495e-97f2-a4366abc6ea3,374e424b-5461-43a8-a053-881686eb308c,aa51a5e5-df3a-4ce4-9701-01ac37d5def0,68f497bf-b27d-42ba-aecb-28eed01d3f61,c15a87eb-12a8-4956-91f5-5cd2091577b6,a2bc175d-448b-4300-85ff-3f05d9caaadb,dae6d8c8-6a70-4af1-8645-00fd5fa41c0f,7e46ac50-1ff0-4c42-83bc-2bca219d1fbd,abfee6d9-0e6d-44f2-9a71-98a567390e42,70c5cb97-a652-43fb-a4fe-d12a03b1f76d,7b0df1c2-e612-44d6-8de6-81cfb8d50977,9b537d7e-2486-4d42-9005-1b3de34191c9,a8a4a4c7-b82c-4219-9b3e-2b03d63be75b,87f06891-90e4-4bb7-9e4f-dd6a39c7f908,861c5441-6405-48fb-8ce3-79fc0a54d4cd,f595d893-2629-4e2c-9c7a-61916daf1a4b,5b0754bb-4019-402a-b050-cf3ddf32fa1a,b56ecca7-c7ea-454a-ad82-12e57759606a,0b5e41f7-2238-4757-bdc2-9d46cd43adce,124a2fc8-a034-440e-80d7-94fc1079024d,88daf4ee-f656-40c9-aa05-c99560259027,b40c59bf-c544-4b86-9959-c86ab461eabe,2db20d75-63b0-4746-a204-d57c28017c1c,f57cc567-9fc5-439c-9c51-44c923ecfde5,3177ffaf-c7ea-44dc-aaeb-0ce2cc47df2d,20451a25-1ae7-4271-b4cb-0126cebd4efa,719a2881-b108-4e05-9b89-18bea6f1aabd,c8addeb5-05ff-4a23-ae30-6e5522cfe080,306df27b-318e-43de-a5d9-1303dea1eadc,f8b6d77e-5354-4fbe-9512-79f4d3913ada,960d5027-79d5-415b-a188-6aa33af2ca6e,17552bd4-e429-4f29-afae-9185131e2b22,365d7553-99b6-4bb0-be32-82b655daada8,f5c7b029-cf1e-435e-ba23-f06a77016a7b,e98cdfcf-cbb8-4dc1-aab1-e7a771a2cd58,32d60d24-9042-4624-9a6f-c42db735ae57,32d8ebce-29b1-422b-9e4a-f90fb2ec4361,794d2686-3c15-4320-93a9-6de89a6af486,37dd2e5a-e5f6-49ad-93c6-4be954cb4023,a4183690-eb7c-419c-991b-eb1a63b0ec70,323f38d4-4798-4598-91c5-2364251529fe,d3d78330-821c-445a-ac74-b90a38401c13,b88a3e58-235e-4678-bd06-c3a61c40d88b,dd2ff704-191c-4500-9cae-37140887ac83,51646d85-1d54-4978-b20d-22abf8326a3d,be9f9b50-410c-4b25-818c-bb699e89ddb2,2892a447-fbcd-42d6-a24e-e852521326a8,34ba9a8d-261a-4875-84b2-a166f02de1a5,d131be48-a00f-43df-b103-7eb04922f550,41dd85ec-0dca-4f66-88bd-60176ed46d86,7c28872b-e12e-4d50-8adb-5082b1e83a4c,bea973fa-52a1-48df-ba3d-9e4f0738e938,0fea723e-27fe-4acf-916a-0743b6c297d4,2d55bc9a-512c-4f59-bcbd-69df0baa47ba,9e3d272d-9521-41d3-859c-f1db9f3e92e1,8a5600e5-73cf-4220-8a6f-73444c9b0193,8c27888b-bcc6-401d-9bd4-7bfff6e275fc,36ca060b-2e7e-41ad-9f1d-043f6ed3d07b,234702ae-bb39-41cc-b871-37d9da1147bc,cfc19f0a-01a0-407f-b603-31853debef66,aa862865-009e-4ee4-87c6-923c28bf8a5b,0b1b5829-75c4-48d8-8262-6e5d6fd0f416,e0a07e25-9a0e-49c0-b987-942950bd17d7,375597bc-9a3a-4d44-80c6-0253a980c717,b1581a91-fb47-49f7-a293-c3c1838ab4e3,a5bcb8e6-ef84-4eb0-b660-6feb712efda9,6da99bbb-839b-478d-8c00-fe1b67c0050d,05eb3c1f-5b7c-481f-a362-126e6e000ed3,e84ee3e0-b0b3-4681-b6f9-3df8eedc2bec,8ad23e16-0dae-4f6a-9edd-c416cf643278,93c068df-100a-4359-a028-150cc431c1b1,372d2aab-1cc2-4325-bcdb-3b5c8655af73,7aeeb4b3-d8ba-4895-8826-af91db1bbf2c,e43a7f32-dc78-48e0-a6aa-30730a1ba5f7,4c36928c-273c-472f-9fa9-7849171604b5,93a3e0ce-c22f-4f57-ac28-6789d8a87c72,5e8a8675-89f8-4820-96eb-8170cc463808,ff177014-edad-4ffa-b904-ed99dd59f280,6845dc60-ebcd-41ff-96ef-6b9412c1694f,99391c18-e19a-47e8-948f-079209d857ba,c18ca8c1-2ba1-44d5-8682-6a6234aa2f67,7e451ba7-a86a-472a-8a61-600857c2a5f5,93d9695a-4be2-485b-9a18-8e46c50de8b0,e6b94771-e0ac-4f69-bc1c-2f90c0e08bef,8053ecc5-a9ee-4d80-a01b-1afe60dcfc32,7cbf91dc-38d0-47ac-a476-2e6bbc06bc47,ecc61e63-78f7-4e4b-a3c0-59d3e6c778cc,318b0520-9c89-4748-86bb-d64afdb7b8de,51b6984b-96e7-4fdf-93c9-86d59971b326,561d5dec-b7f0-4b4a-ae91-82e78153a05a,bb281be9-e15d-4bbf-9b56-b50788150a43,e8a8cb12-445c-4858-afad-98f7c3ea3902,ce6e7e5a-787a-4d4b-bd38-fc4b83fdcc73,dc15f2ce-f9ba-44f9-a785-9eed6eca9e09,1ed071ac-fb18-48f7-ab09-364f508e9527,ac2b8766-4ce3-4ad3-95d7-20442c9e01cd,ba440fbb-cce6-4662-a615-bec619d0607f,9058375c-3143-4ed7-afaa-9c4df84c11b8,3ea2c494-8611-4c0f-889c-1c2cbae2aeec,f3463ca9-d085-4eb9-bcf3-736170258bad,2d77a73e-5ba8-4022-8cdc-aa24ddd87a9d,9f4d3feb-37de-44ed-829e-a00fc259b850,a8fc926c-8fc6-4d58-8e32-4e214365dfa3,073d83e4-d8ed-4c96-9c1c-8e84dd762f78,5ea28ff4-689c-455e-82b4-4d7201689028,ab090666-576e-43d2-8710-2dbd85277995,d2c8e415-9f3c-43c6-8ad4-fb2169d31015,b08fec09-9b16-4eb8-93c7-9d62b736d3fc,4cef30f0-9af1-4c47-8886-0ebf19df22a9,c4a5959a-607a-43ae-a561-daf934375bca,b31f0c3d-1a06-4b44-ad4d-d80e0ffe45a5,7c974c10-a595-44fa-af1b-85c4de414d08,0003fa64-61a7-46d9-9547-8bf7df4ebd21,4dd0be55-4374-4edf-95ca-218a49d29eef,2b773adf-4afe-472e-a150-da1b994e5ba1,42e891a1-a742-4916-98ca-8747cc01a33b,ddc873f8-1353-4bb9-9c03-d379cb3d33b6,8ff4b67f-b10a-4e37-8546-f820586e084a,ce14f911-0bae-4611-9288-1b366379adb4,e7b05b48-6d89-4479-97ad-7927f957ae56,82788a24-7d25-48a9-be84-2d632a667e15,5dfcfc74-33c8-439b-8b26-857e96e3d862,e93c747a-2268-4bdf-9cb9-4946946b18db,74fe2da8-837a-4c5e-87fc-63bcd2374e03,e9c0dcc0-62e7-4aea-90ff-e8bfa8ed3923,f0a9b588-0fd4-4baf-ad35-5abe38f647b5,09493c19-44fe-4c50-be96-c5f878fa719e,0bca5ac2-9cd0-4efd-8b9c-cbc7edbf4c22,4ef55a4f-be19-4e0e-bde6-5dab174c7827,9f3c37c9-bc16-475a-9958-ade9dea23813,432012c7-4a9e-41df-93d6-f4476f38c2d1,ff374a90-fe9c-49d1-8941-4451e1836de1,b9620ff8-06e0-47ef-befe-9869faf8c662,ffdac870-86ec-4ac7-a4ae-4bdc782b694b,92ba3581-85c2-4ee6-9daa-c630517a045f,e0d1596d-ac1d-4cb0-aada-d9059245ea00,ea397ee7-1358-403a-a44d-709de864a74f,71ab6a70-9df5-4d82-bf6d-315c5add34b2,91f4a48b-7ece-43a0-b2f2-4a2b3d226b53,e68386d3-1e13-4ca2-9b1f-8c4d8e4cd466,009da032-a259-4875-8237-21fe98fcc29f,b5f0a270-ae05-4e46-844b-86887c1d4faa,53f4e7eb-dc90-4130-aacb-ad000eb82ba9,8b9d0549-c87d-4e48-af80-d9023de29b56,08704a35-78c6-4323-9d07-e8b0ed8c5231,aba36e69-1ede-499a-b022-a70332f30ed2,7931c138-405b-44bc-bf27-0fe4cdf49cf0,a8c4e891-21ae-4bf6-a994-988549e47e1a,7c8bb550-aedb-46be-a608-7cef9aeafa26,816dc3df-727f-4e30-b50d-77423dd942d1,8d630288-b698-446b-9197-a002e9ae9925,042b07fe-1243-41fd-9e0d-1b4a68c33666,a3c5f04f-7f19-46d5-ae3f-e68b2e4a9eb9,c0fcea73-f797-4696-820c-a283597f669d,9becbdab-5d36-4ccd-be46-789ff8f176f1,11c4d073-7460-4e40-a42e-a908bb3bbb95,b83db448-52c6-42ee-b401-ed35b301fcce,f9a12d18-51dc-4fe4-8a22-c0725f6b969b,ef93369d-17b2-419e-8bfe-75871faa4f9b,14515b24-00cb-485c-9fa5-a798eb9891e5,764d1364-87c1-49b0-b583-e47eb825a0cd,bf12e8b4-7129-4734-adf9-fb77741cf167,9648a20f-fc9e-49eb-97d9-53b1f151e1ac,4e533512-21a8-4968-b023-db3f2be02a1c,2d5017df-fb7e-4b17-bbc0-5d6b121a7bb5,15153e84-bfb0-475b-9c6c-cb51dc8a6a80,4a4c6d08-b4ea-4bc1-9961-b99d476ab664,8a98526e-93d2-44ba-b131-994fcc54c5fe,78bbf36b-6342-48a2-829a-f8b462aab935,9da95b86-5f9f-41b4-a979-fa77c1f84660,5c4421b4-852a-40d9-9758-018e75aa338e,afd94ee7-3036-47a2-b31e-cd4b340b431e,4a9e45bd-d5b6-4141-9802-669b99b04fc9,718980c5-41fb-4b8f-bb15-88b66270155e,c06f0081-b60b-4f08-8b3a-94e94595d6cf,6b9449f0-3cb8-4010-b086-9144e29c2a40,68a4bd9c-328c-49b6-a3a7-cdb5c847bbb6,61814668-7b4f-49f5-8ee3-0a074c259f14,edc382a4-12c5-41f3-a327-35d8dab6c5fc,a19dfc60-5685-43f3-a7d4-d94bf60e0f94,9dcf6dcc-a252-4463-8465-c2ee9b215b37,646ca3f2-8370-46d5-a5ac-f9c4dfe3677b,c9a7777b-cceb-4a69-97e9-430acbb0c162,a09a82e3-1e1c-4337-9423-1f9f7811f7f6,18380ef2-ce1d-47d2-b5c5-56437802c7b5,5c59784b-5dca-4fcb-b1b8-b412b9ca2ebc,3337a9a9-a2c8-474d-8810-58b941296f6d,957b001e-ef3d-4f11-a6eb-efcba7287567,70881b52-3b47-46f3-a354-4ba9c84aceec,8c496064-bdf1-4f7a-9739-46096fa96cb6,646cbb7f-7151-4dd4-8888-cc384fcd2fd6,ff7dfe3c-4de5-4b9a-bd4a-d08296c1f19b,933a32e6-3bd5-41fb-852f-78d83915a001,7f83ee82-d43a-4526-a0f6-491e872094a6,421aae45-23ee-4deb-8ed3-0d990b109e0e,1e0bbfb6-9125-43a1-8b7b-d4ea3b77a680,23fe64dd-c9b2-410a-a52c-000353698a2c,bc41d9b6-f4e6-4b91-9096-d986d5d3397b,3cdda2d2-644d-47ad-9c47-974756151388,8b793d78-f814-405c-80d6-4c26c8339ba9,c50d50d6-9ed0-4647-a009-db3ab3cb9b73,1fffe20c-4859-4e57-8d23-4ca089593ca4,ae109e0b-8212-4e32-99e7-a605d5c6c483,7f14235b-2cb2-4bd7-9946-c757338522a8,51e56890-40f1-48de-b827-0ed23f484284,5032aef7-253a-4fa5-a35c-b02af78bd3a5,38b66115-b5bc-4954-91d3-b96c630bdf38,6693ed36-8029-402c-b9ea-6df23f35595f,25a01ef0-1a46-4c67-9d2e-f3487b3e3b64,78a56213-2671-4c3c-b798-ecbf86d15328,6e3a6457-ced9-4242-b10d-ae177cbba469,659ae40b-0c77-4de2-a9cb-6c6724c721b5,d5a2eaf4-9426-4124-8444-e399c1bad0ff,1b50aaaa-0815-4f46-a3bc-6c9a84a14ee4,bbc7d1e6-6131-43fc-b8ad-715245972718,c3fb045b-d323-49c2-966c-fcb3adc6a235,d654a766-312e-4e1b-b20c-0d03972d4cc2,95483314-a336-4a27-9368-ad3c46fae8d1,611e70f2-c871-4228-b5b7-7c7e98ab7515,cf6278c3-0089-4969-9b5f-ab987e90d510,48046c1f-5c91-4f65-b83a-b6748243c8fd,da565b8f-cd9e-4834-80fe-e8162dbad283,761bfaea-ce57-47de-8e52-d05911a6d6da,35ee73f2-aa17-4ab1-81e1-a2ee435273ec,a94a4f1e-b793-4fd1-9e61-85e8e350963a,7a2d7214-20bc-4bdd-84e9-5f7cbde42127,e5acf39f-fe5b-46b7-9e6c-817a6f6d4812,98631c85-d4af-445f-ac90-f166342b40b3,27b11403-ef51-4a10-8251-2cd06c42e3c6,a90d6347-7f17-4f9d-a4ac-d45c70ac5d4c,04453890-0a88-4b4c-9f78-d443d420294c,5859e4a4-429d-4f75-bcc9-334926c28d40,3ade21ba-56d1-4194-bebd-dd4e28796b3b,e47d7454-057b-4d37-90d5-b81231d31bb4,37a3a8b6-7aeb-4b24-b030-2a5a4b796264,ed9b1eb2-490f-49d7-b485-098d47ee2590,7e078ac3-2ebd-46f9-baa3-ca2b04f29755,97d3404f-4e45-44f9-986b-0297116a641f,125ac1ec-ff26-4866-bb95-efe0a9d1d863,7a270b47-b88f-4b5a-8d6a-6d52e6c17007,81d1d116-ee57-4764-8e31-0142992e1c0a,ce1a0f96-059e-4423-a90a-4fe15156d8c7,bd8b5583-608a-491d-9ba1-f51ebc9970e7,4e9e886a-ccad-47c6-aa05-b7c77c5dc4b0,00e36a6b-3878-4b9f-84fd-33414e78a338,18656686-f2d9-40f8-9060-caeed1848a0e,ab8cc22a-5c9a-4802-97ac-fc8a03249f4c,6e543924-2923-4bb8-b658-514381c38acf,accab24e-e650-42af-bde3-e9cc45d802e3,db54da75-075a-4156-8dcb-341edbfeb00b,3d527419-9f5a-4577-bd5f-e31359936b5a,0c7c281d-39d1-4daa-a961-9122f2334609,2a00a3be-68ab-4438-89e5-915365972ff3,aaf1fe91-0ace-4c6b-91d9-7599c2a5bbe0,c8884e71-c42f-4439-942e-fec45fe37448,2a264dca-001d-4432-98d7-05bdd12caa13,34631dd1-f0a9-40f3-981c-f462ae1e3c2f,90e64b62-dd19-4999-936c-32c92c8dd26d,fa4b168b-98b2-4823-be55-cb20e553cb8f,64ba4d92-14f6-4798-9a11-4d98cd0d2dfc,1147cced-51ec-4c9a-96b1-ba17a87ba18a,9433935c-42ab-42fa-8b62-dc6c2de854c2,6e28deab-0dd3-478c-86e7-b5fb1ae63cde,470cf08a-8cda-4e31-a3f0-7844ce3e7e31,fc5d50dc-f5b3-427d-be6d-75c51e4d8466,c167f37c-1447-4a07-a6b4-73ff2d022371,d0625529-2fef-42f9-b885-6a1529928f00,88d9eed6-a31e-4f10-a020-aa3aebff9eaf,96c912f2-ed72-4c14-9d61-2b62a6e6f0eb,91fb25af-f7bd-4280-ac2a-2e715f0a460b,824af244-5169-440e-b035-b86ab537f0ae,41ea9d58-7518-4865-9aa5-9a473016481d,54441aa2-f3dc-4695-81fb-1036ea60b1bd,7d9149bd-ac71-4890-be3e-b96d94e7d2cc}'::uuid[]))
  • Filter: ("deletionDate" IS NULL)
3. 0.210 1.627 ↑ 1.0 454 1

Hash (cost=153.26..153.26 rows=454 width=1,874) (actual time=1.627..1.627 rows=454 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 143kB
4. 0.576 1.417 ↑ 1.0 454 1

Hash Join (cost=28.48..153.26 rows=454 width=1,874) (actual time=0.315..1.417 rows=454 loops=1)

  • Hash Cond: ("otaBuildings".uuid = "otaBuildings->otaBuildingsBAR"."otaBuildingUUID")
5. 0.643 0.643 ↑ 1.0 2,781 1

Seq Scan on ota_building "otaBuildings" (cost=0.00..109.81 rows=2,781 width=1,192) (actual time=0.004..0.643 rows=2,781 loops=1)

  • Filter: ("deletionDate" IS NULL)
6. 0.069 0.198 ↑ 1.0 454 1

Hash (cost=22.81..22.81 rows=454 width=682) (actual time=0.198..0.198 rows=454 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 98kB
7. 0.129 0.129 ↑ 1.0 454 1

Seq Scan on ota_building_bar "otaBuildings->otaBuildingsBAR" (cost=0.00..22.81 rows=454 width=682) (actual time=0.003..0.129 rows=454 loops=1)

  • Filter: (("deletionDate" IS NULL) AND (date >= '2020-08-17'::date) AND (date <= '2020-08-20'::date))
Planning time : 0.852 ms
Execution time : 3.314 ms