# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 1.631 | 1.631 | ↓ 2.0 | 2 | 1 |
→
CTE Scan on priceframes (cost=32.97..33.10 rows=1 width=392) (actual time=1.436..1.631 rows=2 loops=1)
|
2. |
CTE priceframes |
|||||
3. | 0.191 | 1.575 | ↓ 1.8 | 11 | 1 |
→
WindowAgg (cost=32.70..32.97 rows=6 width=704) (actual time=1.425..1.575 rows=11 loops=1) |
4. | 0.066 | 1.384 | ↓ 1.8 | 11 | 1 |
→
Sort (cost=32.70..32.71 rows=6 width=514) (actual time=1.381..1.384 rows=11 loops=1)
|
5. | 1.318 | 1.318 | ↓ 1.8 | 11 | 1 |
→
Seq Scan on price_frame pf (cost=0.00..32.62 rows=6 width=514) (actual time=0.024..1.318 rows=11 loops=1)
|
Planning time | : | 0.911 ms |
---|---|---|
Execution time | : | 1.752 ms |