explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VZQ8 : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #pme6; plan #kU7kn; plan #dVY2; plan #13Ge; plan #hdnb; plan #QjtL; plan #VtYO

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 6.037 289.377 ↑ 75,000.0 24 1

Finalize HashAggregate (cost=245,836.00..272,836.00 rows=1,800,000 width=76) (actual time=282.412..289.377 rows=24 loops=1)

  • Group Key: date, ((doc ->> 'health'::text))
2. 14.332 283.340 ↑ 15,000.0 120 1

Gather (cost=36,586.00..223,336.00 rows=1,800,000 width=76) (actual time=279.214..283.340 rows=120 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 179.691 269.008 ↑ 18,750.0 24 5

Partial HashAggregate (cost=35,586.00..42,336.00 rows=450,000 width=76) (actual time=266.868..269.008 rows=24 loops=5)

  • Group Key: date, (doc ->> 'health'::text)
4. 89.317 89.317 ↑ 1.2 360,000 5

Parallel Seq Scan on snapshot (cost=0.00..27,711.00 rows=450,000 width=90) (actual time=0.019..89.317 rows=360,000 loops=5)

Planning time : 0.132 ms
Execution time : 314.623 ms