# | 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)
|
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)
|
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)
|
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)
|
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)
|
Planning time | : | 8.225 ms |
---|---|---|
Execution time | : | 116,884.506 ms |