explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xoLk

Settings
# exclusive inclusive rows x rows loops node
1. 4.187 8.623 ↑ 2.2 281 1

HashAggregate (cost=12,296.67..12,307.48 rows=618 width=44) (actual time=8.502..8.623 rows=281 loops=1)

  • Group Key: date_trunc('day'::text, datehrgmt), siteid
2. 4.436 4.436 ↓ 1.1 6,721 1

Index Scan using cleanedobservation_siteid_datehrlwt_idx on cleanedobservation (cost=0.57..12,173.11 rows=6,178 width=44) (actual time=0.027..4.436 rows=6,721 loops=1)

  • Index Cond: ((siteid = 4) AND (datehrlwt >= '2019-01-01 00:00:00'::timestamp without time zone))
Planning time : 0.120 ms
Execution time : 8.735 ms