#	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.	34.851	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.	162.213	461.981	↑ 18,750.0	24	5 / 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.	220.250	299.768	↑ 1.2	360,000	5 / 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: 28,248kB Worker 0: Sort Method: external merge Disk: 26,720kB Worker 1: Sort Method: external merge Disk: 25,864kB Worker 2: Sort Method: external merge Disk: 26,432kB Worker 3: Sort Method: external merge Disk: 26,528kB
5.	79.518	79.518	↑ 1.2	360,000	5 / 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

Finalize GroupAggregate  (cost=140181.08..419828.43 rows=1800000 width=76) (actual time=274.777..496.886 rows=24 loops=1)
  Group Key: date, ((doc ->> 'health'::text))
  ->  Gather Merge  (cost=140181.08..370328.43 rows=1800000 width=76) (actual time=267.811..496.832 rows=120 loops=1)
        Workers Planned: 4
        Workers Launched: 4
        ->  Partial GroupAggregate  (cost=139181.02..154931.02 rows=450000 width=76) (actual time=253.951..461.981 rows=24 loops=5)
              Group Key: date, ((doc ->> 'health'::text))
              ->  Sort  (cost=139181.02..140306.02 rows=450000 width=90) (actual time=241.263..299.768 rows=360000 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
                    ->  Parallel Seq Scan on snapshot  (cost=0.00..27711.00 rows=450000 width=90) (actual time=0.017..79.518 rows=360000 loops=5)
Planning Time: 0.134 ms
Execution Time: 500.241 ms

Per node type stats

node type	count	sum of times	% of query
Finalize GroupAggregate	1	0.054 ms	0.0 %
Gather Merge	1	34.851 ms	7.0 %
Parallel Seq Scan	1	79.518 ms	16.0 %
Partial GroupAggregate	1	162.213 ms	32.6 %
Sort	1	220.250 ms	44.3 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
snapshot	1	79.518 ms	16.0 %
Parallel Seq Scan	1	79.518 ms	100.0 %

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

Color mode:

Visible columns:

Optimization path:

Optimization(s) for this plan:

Per node type stats

Per table stats