explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UMOS

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.655 6.758 ↑ 310.5 16 1

HashAggregate (cost=4,204.26..4,266.36 rows=4,968 width=550) (actual time=6.724..6.758 rows=16 loops=1)

  • Group Key: (milk_recording."MilkingStopTime")::date, location_group_name."GroupName", location."Id
2. 2.576 5.103 ↑ 1.0 4,793 1

Hash Join (cost=8.97..4,154.58 rows=4,968 width=550) (actual time=0.088..5.103 rows=4,793 loops=1)

  • Hash Cond: (milk_recording."LocationId" = location."Id")
3. 2.490 2.490 ↑ 1.0 4,793 1

Index Scan using "IX_MilkRecordings_MilkingStopTime" on "MilkRecordings" milk_recording (cost=0.42..4,065.30 rows=4,968 width=32) (actual time=0.045..2.490 rows=4,793 loops=1)

  • Index Cond: (('2019-05-14 13:56:24+02'::timestamp with time zone - '72:00:00'::interval) <= "MilkingStopTime")
4. 0.007 0.037 ↑ 1.0 5 1

Hash (cost=8.48..8.48 rows=5 width=538) (actual time=0.037..0.037 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.011 0.030 ↑ 1.0 5 1

Nested Loop (cost=0.14..8.48 rows=5 width=538) (actual time=0.017..0.030 rows=5 loops=1)

6. 0.009 0.009 ↑ 1.0 5 1

Seq Scan on "Locations" location (cost=0.00..1.05 rows=5 width=38) (actual time=0.008..0.009 rows=5 loops=1)

7. 0.010 0.010 ↑ 1.0 1 5

Index Scan using "PK_LocationGroupNames" on "LocationGroupNames" location_group_name (cost=0.14..1.48 rows=1 width=532) (actual time=0.002..0.002 rows=1 loops=5)

  • Index Cond: ("Id" = location."LocationGroupNameId")
Planning time : 0.451 ms
Execution time : 6.869 ms