# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 1,373.486 | ↓ 16.2 | 261,942 | 1 |
→
Gather Merge (cost=82,554.94..84,437.37 rows=16,134 width=1,159) (actual time=1,148.177..1,373.486 rows=261,942 loops=1)
|
2. | 1,363.137 | 3,302.022 | ↓ 10.8 | 87,314 | 3 |
→
Sort (cost=81,554.91..81,575.08 rows=8,067 width=1,159) (actual time=1,060.065..1,100.674 rows=87,314 loops=3)
|
3. | 1,869.051 | 1,938.885 | ↓ 10.8 | 87,314 | 3 |
→
Parallel Bitmap Heap Scan on events (cost=1,672.67..76,950.45 rows=8,067 width=1,159) (actual time=73.674..646.295 rows=87,314 loops=3)
|
4. | 0.002 | 69.834 | ↓ 0.0 | 0 | 1 |
→
BitmapOr (cost=1,672.67..1,672.67 rows=19,610 width=0) (actual time=69.834..69.834 rows=0 loops=1) |
5. | 41.706 | 41.706 | ↓ 13.6 | 130,971 | 1 |
→
Bitmap Index Scan on events_producer_type_type_index (cost=0.00..813.00 rows=9,632 width=0) (actual time=41.706..41.706 rows=130,971 loops=1)
|
6. | 0.068 | 0.068 | ↓ 0.0 | 0 | 1 |
→
Bitmap Index Scan on events_producer_type_type_index (cost=0.00..36.61 rows=393 width=0) (actual time=0.068..0.068 rows=0 loops=1)
|
7. | 28.058 | 28.058 | ↓ 13.7 | 130,971 | 1 |
→
Bitmap Index Scan on events_producer_type_type_index (cost=0.00..808.53 rows=9,585 width=0) (actual time=28.058..28.058 rows=130,971 loops=1)
|
Planning time | : | 0.164 ms |
---|---|---|
Execution time | : | 1,397.658 ms |