#	exclusive	inclusive	rows x	rows	loops	node
1.	948.589	1,424.832	↑ 50,000.0	36	1	→ HashAggregate (cost=75,969.00..102,969.00 rows=1,800,000 width=76) (actual time=1,415.774..1,424.832 rows=36 loops=1) Group Key: date, (doc ->> 'health'::text)
2.	476.243	476.243	↑ 1.0	1,800,000	1	→ Seq Scan on snapshot (cost=0.00..44,469.00 rows=1,800,000 width=89) (actual time=0.036..476.243 rows=1,800,000 loops=1)

Planning time	:	0.104 ms
Execution time	:	1,459.441 ms

HashAggregate  (cost=75969.00..102969.00 rows=1800000 width=76) (actual time=1415.774..1424.832 rows=36 loops=1)
  Group Key: date, (doc ->> 'health'::text)
  ->  Seq Scan on snapshot  (cost=0.00..44469.00 rows=1800000 width=89) (actual time=0.036..476.243 rows=1800000 loops=1)
Planning Time: 0.104 ms
Execution Time: 1459.441 ms

Per node type stats

node type	count	sum of times	% of query
HashAggregate	1	948.589 ms	66.6 %
Seq Scan	1	476.243 ms	33.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
snapshot	1	476.243 ms	33.4 %
Seq Scan	1	476.243 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bZGl : Optimization for: plan #2kcb

Color mode:

Visible columns:

Optimization path:

Per node type stats

Per table stats