explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QUxR

Settings
# 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