explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q76u

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.155 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.83..27.57 rows=1 width=1,919) (actual time=0.152..0.155 rows=1 loops=1)

  • Join Filter: ("Building".uuid = "otaBuildings"."buildingUUID")
2. 0.051 0.051 ↑ 1.0 1 1

Index Scan using building_pkey on building "Building" (cost=0.28..8.29 rows=1 width=45) (actual time=0.049..0.051 rows=1 loops=1)

  • Index Cond: (uuid = '7e970a48-1c32-4aab-b277-aca415a6fcc5'::uuid)
3. 0.001 0.092 ↓ 0.0 0 1

Nested Loop (cost=0.55..19.27 rows=1 width=1,874) (actual time=0.091..0.092 rows=0 loops=1)

4. 0.091 0.091 ↓ 0.0 0 1

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

  • Index Cond: ((date >= '202020-08-17'::date) AND (date <= '202020-08-20'::date))
5. 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: ("buildingUUID" = '7e970a48-1c32-4aab-b277-aca415a6fcc5'::uuid)
Planning time : 1.672 ms
Execution time : 0.298 ms