explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cq6L

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 1,884.457 ↑ 50,000.0 3 1

Limit (cost=66,969.00..69,219.00 rows=150,000 width=64) (actual time=1,876.316..1,884.457 rows=3 loops=1)

2. 1,249.367 1,884.453 ↑ 600,000.0 3 1

HashAggregate (cost=66,969.00..93,969.00 rows=1,800,000 width=64) (actual time=1,876.314..1,884.453 rows=3 loops=1)

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

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

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