explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rn69

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2.266 ↓ 0.0 0 1

Nested Loop (cost=30.54..156.50 rows=4 width=1,919) (actual time=2.265..2.266 rows=0 loops=1)

2. 0.633 2.265 ↓ 0.0 0 1

Hash Join (cost=30.26..147.41 rows=27 width=1,237) (actual time=2.265..2.265 rows=0 loops=1)

  • Hash Cond: ("otaBuildings"."buildingUUID" = "Building".uuid)
3. 1.241 1.241 ↑ 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.010..1.241 rows=2,781 loops=1)

  • Filter: ("deletionDate" IS NULL)
4. 0.006 0.391 ↓ 1.1 10 1

Hash (cost=30.15..30.15 rows=9 width=45) (actual time=0.391..0.391 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.385 0.385 ↓ 1.1 10 1

Seq Scan on building "Building" (cost=0.00..30.15 rows=9 width=45) (actual time=0.008..0.385 rows=10 loops=1)

  • Filter: (("deletionDate" IS NULL) AND (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}'::uuid[])))
  • Rows Removed by Filter: 930
6. 0.000 0.000 ↓ 0.0 0

Index Scan using ota_building_bar_pkey on ota_building_bar "otaBuildings->otaBuildingsBAR" (cost=0.27..0.33 rows=1 width=682) (never executed)

  • Index Cond: (("otaBuildingUUID" = "otaBuildings".uuid) AND (date >= '2020-08-17'::date) AND (date <= '2020-08-20'::date))
  • Filter: ("deletionDate" IS NULL)
Planning time : 0.788 ms
Execution time : 2.328 ms