explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L3LK

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.029 ↓ 0.0 0 1

"GroupAggregate (cost=8.10..8.14 rows=1 width=28) (actual time=0.029..0.029 rows=0 loops=1)

  • Group Key: ""EVVE_K_VE_ID"", (date_trunc('hour'::text, (""EVVE_DATE_EVENT"" - '00:01:00'::interval)))
2. 0.022 0.027 ↓ 0.0 0 1

Sort (cost=8.10..8.11 rows=1 width=743) (actual time=0.027..0.027 rows=0 loops=1)

  • Sort Key: ""EVVE_K_VE_ID"", (date_trunc('hour'::text, (""EVVE_DATE_EVENT"" - '00:01:00'::interval)))
  • Sort Method: quicksort Memory: 25kB
3. 0.005 0.005 ↓ 0.0 0 1

Index Scan using ""T_EVENT_VE_EVVE_DATE_EVENT"" on ""T_EVENT_VE"" evve (cost=0.44..8.09 rows=1 width=743) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (""EVVE_DATE_EVENT"" > (now() - '14 days'::interval))
Planning time : 0.172 ms
Execution time : 0.059 ms