explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OXMC

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 2,511.995 ↑ 1.0 10 1

Limit (cost=67,207.04..67,207.39 rows=10 width=30) (actual time=2,511.989..2,511.995 rows=10 loops=1)

2. 158.416 2,511.992 ↑ 1,574.0 10 1

HashAggregate (cost=67,207.04..67,757.94 rows=15,740 width=30) (actual time=2,511.987..2,511.992 rows=10 loops=1)

  • Group Key: (((((((supplier)::text || ';'::text) || (gridoperator)::text) || ';'::text) || (market)::text) || ';'::text) || ((date_trunc('month'::text, fromdate))::date)::text)
3. 2,353.576 2,353.576 ↓ 1.0 333,123 1

Seq Scan on informativevolume (cost=0.00..66,377.83 rows=331,681 width=30) (actual time=0.021..2,353.576 rows=333,123 loops=1)

Planning time : 0.208 ms
Execution time : 2,512.197 ms