# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 1,097.668 | 2,919.249 | ↑ 33.3 | 6 | 1 |
→
GroupAggregate (cost=368,696.620..368,796.800 rows=200 width=19) (actual time=1,854.918..2,919.249 rows=6 loops=1)
|
2. | 734.815 | 1,821.581 | ↓ 32.3 | 317,493 | 1 |
→
Sort (cost=368,696.620..368,721.160 rows=9,818 width=901) (actual time=1,667.914..1,821.581 rows=317,493 loops=1)
|
3. | 21.149 | 1,086.766 | ↓ 32.3 | 317,493 | 1 |
→
Append (cost=0.300..368,045.630 rows=9,818 width=901) (actual time=0.015..1,086.766 rows=317,493 loops=1)
|
4. | 253.842 | 253.842 | ↓ 32.7 | 66,713 | 1 |
→
Index Scan using xray on charlie (cost=0.430..78,667.160 rows=2,040 width=911) (actual time=0.015..253.842 rows=66,713 loops=1)
|
5. | 811.766 | 811.766 | ↓ 32.5 | 250,780 | 1 |
→
Seq Scan on six_delta (cost=0.000..289,231.290 rows=7,720 width=899) (actual time=0.025..811.766 rows=250,780 loops=1)
|
6. | 0.002 | 0.009 | ↓ 0.0 | 0 | 1 |
→
Bitmap Heap Scan on two_tango (cost=4.800..9.090 rows=1 width=64) (actual time=0.009..0.009 rows=0 loops=1)
|
7. | 0.001 | 0.007 | ↓ 0.0 | 0 | 1 |
→
BitmapAnd (cost=4.800..4.800 rows=5 width=0) (actual time=0.007..0.007 rows=0 loops=1) |
8. | 0.006 | 0.006 | ↓ 0.0 | 0 | 1 |
→
Bitmap Index Scan on zulu_juliet (cost=0.000..2.080 rows=15 width=0) (actual time=0.006..0.006 rows=0 loops=1)
|
9. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Bitmap Index Scan on india_two (cost=0.000..2.470 rows=163 width=0) (never executed)
|
Planning time | : | 3.648 ms |
---|---|---|
Execution time | : | 2,957.596 ms |