| # | exclusive | inclusive | rows x | rows | loops | node |
|---|---|---|---|---|---|---|
| 1. | 0.000 | 0.000 | ↓ 0.0 |
→
Subquery Scan on rank_filter (cost=10,051,037.25..11,211,585.06 rows=165,793 width=58) (actual rows= loops=) |
||
| 2. | 0.000 | 0.000 | ↓ 0.0 |
→
WindowAgg (cost=10,051,037.25..10,797,103.70 rows=33,158,509 width=66) (actual rows= loops=) |
||
| 3. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=10,051,037.25..10,133,933.52 rows=33,158,509 width=50) (actual rows= loops=) |
||
| 4. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using iot_data_nov_install_ts_37ad54a7 on iot_data_nov (cost=0.57..2,509,015.69 rows=33,158,509 width=50) (actual rows= loops=) |