# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 55.056 | 345.288 | ↑ 14.3 | 14 | 1 |
→
GroupAggregate (cost=132,205.52..132,225.82 rows=200 width=100) (actual time=283.216..345.288 rows=14 loops=1)
|
2. |
CTE t |
|||||
3. | 45.494 | 218.549 | ↓ 77.9 | 49,239 | 1 |
→
GroupAggregate (cost=132,122.40..132,163.48 rows=632 width=48) (actual time=158.946..218.549 rows=49,239 loops=1)
|
4. | 93.028 | 173.055 | ↓ 77.9 | 49,239 | 1 |
→
Sort (cost=132,122.40..132,123.98 rows=632 width=20) (actual time=158.921..173.055 rows=49,239 loops=1)
|
5. | 80.027 | 80.027 | ↓ 77.9 | 49,239 | 1 |
→
Index Scan using cm_cityid_date on calendar_metric_properties cm (cost=0.57..132,093.00 rows=632 width=20) (actual time=36.341..80.027 rows=49,239 loops=1)
|
6. | 31.186 | 290.232 | ↓ 77.9 | 49,239 | 1 |
→
Sort (cost=42.04..43.62 rows=632 width=48) (actual time=279.049..290.232 rows=49,239 loops=1)
|
7. | 259.046 | 259.046 | ↓ 77.9 | 49,239 | 1 |
→
CTE Scan on t (cost=0.00..12.64 rows=632 width=48) (actual time=158.951..259.046 rows=49,239 loops=1) |
Planning time | : | 0.199 ms |
---|---|---|
Execution time | : | 346.762 ms |