explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NeKC

Settings
# exclusive inclusive rows x rows loops node
1. 0.085 0.250 ↓ 1.1 100 1

Hash Left Join (cost=72.88..95.73 rows=90 width=1,919) (actual time=0.163..0.250 rows=100 loops=1)

  • Hash Cond: ("Building".uuid = "otaBuildings"."buildingUUID")
2. 0.030 0.158 ↓ 1.1 100 1

Bitmap Heap Scan on building "Building" (cost=56.27..78.77 rows=90 width=45) (actual time=0.137..0.158 rows=100 loops=1)

  • Recheck 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}'::uuid[]))
  • Filter: ("deletionDate" IS NULL)
  • Heap Blocks: exact=1
3. 0.128 0.128 ↑ 1.0 100 1

Bitmap Index Scan on building_pkey (cost=0.00..56.25 rows=100 width=0) (actual time=0.128..0.128 rows=100 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}'::uuid[]))
4. 0.000 0.007 ↓ 0.0 0 1

Hash (cost=16.60..16.60 rows=1 width=1,874) (actual time=0.007..0.007 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
5. 0.001 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.55..16.60 rows=1 width=1,874) (actual time=0.007..0.007 rows=0 loops=1)

6. 0.006 0.006 ↓ 0.0 0 1

Index Scan using date_deletion_date_ota_building_uuid on ota_building_bar "otaBuildings->otaBuildingsBAR" (cost=0.27..8.29 rows=1 width=682) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((date >= '202020-08-17'::date) AND (date <= '202020-08-20'::date) AND ("deletionDate" IS NULL))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using ota_building_uuid on ota_building "otaBuildings" (cost=0.28..8.30 rows=1 width=1,192) (never executed)

  • Index Cond: (uuid = "otaBuildings->otaBuildingsBAR"."otaBuildingUUID")
  • Filter: ("deletionDate" IS NULL)
Planning time : 0.524 ms
Execution time : 0.341 ms