explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sMHV

Settings
# exclusive inclusive rows x rows loops node
1. 3,796.186 32,793.606 ↑ 3.7 282,435 1

"GroupAggregate (cost=1,694,890.33..1,744,313.54 rows=1,053,436 width=28) (actual time=25,069.940..32,793.606 rows=282,435 loops=1)

  • Group Key: ""EVVE_K_VE_ID"", (date_trunc('hour'::text, (""EVVE_DATE_EVENT"" - '00:01:00'::interval)))
2. 16,329.399 28,997.420 ↓ 1.7 2,484,930 1

Sort (cost=1,694,890.33..1,698,564.74 rows=1,469,766 width=743) (actual time=25,069.874..28,997.420 rows=2,484,930 loops=1)

  • Sort Key: ""EVVE_K_VE_ID"", (date_trunc('hour'::text, (""EVVE_DATE_EVENT"" - '00:01:00'::interval)))
  • Sort Method: external merge Disk: 1851048kB
3. 12,668.021 12,668.021 ↓ 1.7 2,484,930 1

Seq Scan on ""T_EVENT_VE"" evve (cost=0.00..1,062,065.21 rows=1,469,766 width=743) (actual time=1,492.845..12,668.021 rows=2,484,930 loops=1)

  • Filter: (""EVVE_DATE_EVENT"" > (now() - '14 days'::interval))
  • Rows Removed by Filter: 6240154
Planning time : 1.042 ms
Execution time : 33,501.567 ms