explain.depesz.com

PostgreSQL's explain analyze made readable

Result: otB3 : Optimization for: plan #cq6L

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 481.228 1,079.942 ↑ 600,000.0 3 1

HashAggregate (cost=53,469.00..75,969.00 rows=1,800,000 width=40) (actual time=1,070.897..1,079.942 rows=3 loops=1)

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

Seq Scan on snapshot (cost=0.00..44,469.00 rows=1,800,000 width=32) (actual time=0.022..598.714 rows=1,800,000 loops=1)

Planning time : 0.072 ms
Execution time : 1,138.949 ms