explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.054 496.886 ↑ 75,000.0 24 1
→

Finalize GroupAggregate (cost=140,181.08..419,828.43 rows=1,800,000 width=76) (actual time=274.777..496.886 rows=24 loops=1)

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

Gather Merge (cost=140,181.08..370,328.43 rows=1,800,000 width=76) (actual time=267.811..496.832 rows=120 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 811.065 2,309.905 ↑ 18,750.0 24 5
→

Partial GroupAggregate (cost=139,181.02..154,931.02 rows=450,000 width=76) (actual time=253.951..461.981 rows=24 loops=5)

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

Sort (cost=139,181.02..140,306.02 rows=450,000 width=90) (actual time=241.263..299.768 rows=360,000 loops=5)

  • Sort Key: date, ((doc ->> 'health'::text))
  • Sort Method: external merge Disk: 28248kB
  • Worker 0: Sort Method: external merge Disk: 26720kB
  • Worker 1: Sort Method: external merge Disk: 25864kB
  • Worker 2: Sort Method: external merge Disk: 26432kB
  • Worker 3: Sort Method: external merge Disk: 26528kB
5. 397.590 397.590 ↑ 1.2 360,000 5
→

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

Planning time : 0.134 ms
Execution time : 500.241 ms