explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bZGl : Optimization for: plan #2kcb

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 948.589 1,424.832 ↑ 50,000.0 36 1

HashAggregate (cost=75,969.00..102,969.00 rows=1,800,000 width=76) (actual time=1,415.774..1,424.832 rows=36 loops=1)

  • Group Key: date, (doc ->> 'health'::text)
2. 476.243 476.243 ↑ 1.0 1,800,000 1

Seq Scan on snapshot (cost=0.00..44,469.00 rows=1,800,000 width=89) (actual time=0.036..476.243 rows=1,800,000 loops=1)

Planning time : 0.104 ms
Execution time : 1,459.441 ms