#	exclusive	inclusive	rows x	rows	loops	node
1.	0.016	116,860.360	↑ 1.0	1	1	→ Finalize Aggregate (cost=1,426,010.41..1,426,010.42 rows=1 width=8) (actual time=116,860.359..116,860.360 rows=1 loops=1) Output: count(*)
2.	1.159	116,860.344	↑ 1.0	1	1	→ Gather (cost=1,426,010.30..1,426,010.41 rows=1 width=8) (actual time=116,860.341..116,860.344 rows=1 loops=1) Output: (PARTIAL count(*)) Workers Planned: 1 Workers Launched: 0
3.	5,738.662	116,859.185	↑ 1.0	1	1	→ Partial Aggregate (cost=1,425,010.30..1,425,010.31 rows=1 width=8) (actual time=116,859.184..116,859.185 rows=1 loops=1) Output: PARTIAL count(*)
4.	10,693.510	111,120.523	↓ 1.5	4,497,665	1	→ Append (cost=104,448.49..1,417,747.18 rows=2,905,246 width=0) (actual time=2,633.188..111,120.523 rows=4,497,665 loops=1)
5.	97,832.486	100,427.013	↓ 1.5	4,497,665	1	→ Parallel Bitmap Heap Scan on public.registers_2019_09 (cost=104,448.49..1,417,747.18 rows=2,905,246 width=0) (actual time=2,633.186..100,427.013 rows=4,497,665 loops=1) Recheck Cond: ((registers_2019_09.datetime > '2019-09-02 00:00:00+02'::timestamp with time zone) AND (registers_2019_09.datetime < '2019-09-03 00:00:00+02'::timestamp with time zone)) Heap Blocks: exact=73133
6.	2,594.527	2,594.527	↑ 1.1	4,497,665	1	→ Bitmap Index Scan on registers_2019_09_datetime_idx (cost=0.00..103,213.76 rows=4,938,919 width=0) (actual time=2,594.527..2,594.527 rows=4,497,665 loops=1) Index Cond: ((registers_2019_09.datetime > '2019-09-02 00:00:00+02'::timestamp with time zone) AND (registers_2019_09.datetime < '2019-09-03 00:00:00+02'::timestamp with time zone))

Planning time	:	8.225 ms
Execution time	:	116,884.506 ms

 Finalize Aggregate  (cost=1426010.41..1426010.42 rows=1 width=8) (actual time=116860.359..116860.360 rows=1 loops=1)
   Output: count(*)
   ->  Gather  (cost=1426010.30..1426010.41 rows=1 width=8) (actual time=116860.341..116860.344 rows=1 loops=1)
         Output: (PARTIAL count(*))
         Workers Planned: 1
         Workers Launched: 0
         ->  Partial Aggregate  (cost=1425010.30..1425010.31 rows=1 width=8) (actual time=116859.184..116859.185 rows=1 loops=1)
               Output: PARTIAL count(*)
               ->  Append  (cost=104448.49..1417747.18 rows=2905246 width=0) (actual time=2633.188..111120.523 rows=4497665 loops=1)
                     ->  Parallel Bitmap Heap Scan on public.registers_2019_09  (cost=104448.49..1417747.18 rows=2905246 width=0) (actual time=2633.186..100427.013 rows=4497665 loops=1)
                           Recheck Cond: ((registers_2019_09.datetime > '2019-09-02 00:00:00+02'::timestamp with time zone) AND (registers_2019_09.datetime < '2019-09-03 00:00:00+02'::timestamp with time zone))
                           Heap Blocks: exact=73133
                           ->  Bitmap Index Scan on registers_2019_09_datetime_idx  (cost=0.00..103213.76 rows=4938919 width=0) (actual time=2594.527..2594.527 rows=4497665 loops=1)
                                 Index Cond: ((registers_2019_09.datetime > '2019-09-02 00:00:00+02'::timestamp with time zone) AND (registers_2019_09.datetime < '2019-09-03 00:00:00+02'::timestamp with time zone))
 Planning time: 8.225 ms
 Execution time: 116884.506 ms

Per node type stats

node type	count	sum of times	% of query
Append	1	10,693.510 ms	9.2 %
Bitmap Index Scan	1	2,594.527 ms	2.2 %
Finalize Aggregate	1	0.016 ms	0.0 %
Gather	1	1.159 ms	0.0 %
Parallel Bitmap Heap Scan	1	97,832.486 ms	83.7 %
Partial Aggregate	1	5,738.662 ms	4.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
public.registers_2019_09	1	97,832.486 ms	83.7 %
Parallel Bitmap Heap Scan	1	97,832.486 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QUxR

Color mode:

Visible columns:

Per node type stats

Per table stats