explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 862.577 1,311.817 ↑ 75,000.0 24 1

HashAggregate (cost=76,086.00..103,086.00 rows=1,800,000 width=76) (actual time=1,305.405..1,311.817 rows=24 loops=1)

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

Seq Scan on snapshot (cost=0.00..44,586.00 rows=1,800,000 width=90) (actual time=0.020..449.240 rows=1,800,000 loops=1)

Planning time : 0.110 ms
Execution time : 1,330.903 ms