explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jZm5

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 27,160.172 ↓ 0.0 0 1

"GroupAggregate (cost=1,428,629.30..1,428,676.78 rows=1,187 width=28) (actual time=27,160.172..27,160.172 rows=0 loops=1)

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

Sort (cost=1,428,629.30..1,428,632.26 rows=1,187 width=743) (actual time=27,160.169..27,160.169 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. 27,160.145 27,160.145 ↓ 0.0 0 1

Seq Scan on ""T_EVENT_VE"" evve (cost=0.00..1,428,568.68 rows=1,187 width=743) (actual time=27,160.145..27,160.145 rows=0 loops=1)

  • Filter: (""EVVE_DATE_EVENT"" > (now() - '14 days'::interval))
  • Rows Removed by Filter: 11,950,157
Planning time : 1.223 ms
Execution time : 27,160.246 ms