# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 10.064 | 4,157.657 | ↑ 6.4 | 8,634 | 1 |
→
GroupAggregate (cost=802,012.73..803,686.99 rows=55,659 width=26) (actual time=4,145.924..4,157.657 rows=8,634 loops=1)
|
2. | 18.536 | 4,147.593 | ↑ 2.8 | 19,977 | 1 |
→
Sort (cost=802,012.73..802,153.00 rows=56,108 width=18) (actual time=4,145.887..4,147.593 rows=19,977 loops=1)
|
3. | 3,502.055 | 4,129.057 | ↑ 2.8 | 19,977 | 1 |
→
Bitmap Heap Scan on agg_counts_by_minute (cost=151,817.83..797,586.95 rows=56,108 width=18) (actual time=3,689.420..4,129.057 rows=19,977 loops=1)
|
4. | 627.002 | 627.002 | ↓ 1.1 | 7,486,828 | 1 |
→
Bitmap Index Scan on region_id (cost=0.00..151,803.80 rows=6,824,432 width=0) (actual time=627.002..627.002 rows=7,486,828 loops=1)
|