# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.030 | 2.947 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=3,755.82..3,755.83 rows=1 width=32) (actual time=2.947..2.947 rows=1 loops=1) |
2. | 0.153 | 2.917 | ↑ 1.5 | 15 | 1 |
→
GroupAggregate (cost=3,754.00..3,755.41 rows=23 width=48) (actual time=2.742..2.917 rows=15 loops=1)
|
3. | 0.079 | 2.764 | ↓ 7.8 | 180 | 1 |
→
Merge Semi Join (cost=3,754.00..3,754.95 rows=23 width=393) (actual time=2.707..2.764 rows=180 loops=1)
|
4. | 0.217 | 0.361 | ↓ 1.6 | 217 | 1 |
→
Sort (cost=977.12..977.45 rows=132 width=393) (actual time=0.353..0.361 rows=217 loops=1)
|
5. | 0.010 | 0.144 | ↓ 1.7 | 228 | 1 |
→
Custom Scan (ConstraintAwareAppend) (cost=0.00..972.47 rows=132 width=393) (actual time=0.020..0.144 rows=228 loops=1)
|
6. | 0.009 | 0.134 | ↓ 1.7 | 228 | 1 |
→
Append (cost=0.00..972.47 rows=132 width=393) (actual time=0.018..0.134 rows=228 loops=1) |
7. | 0.125 | 0.125 | ↓ 228.0 | 228 | 1 |
→
Index Scan using _hyper_1_428_chunk_measurements_time_idx on _hyper_1_428_chunk m_1 (cost=0.29..12.52 rows=1 width=344) (actual time=0.017..0.125 rows=228 loops=1)
|
8. | 0.030 | 2.324 | ↑ 1.0 | 15 | 1 |
→
Sort (cost=2,776.88..2,776.92 rows=15 width=9) (actual time=2.322..2.324 rows=15 loops=1)
|
9. | 2.294 | 2.294 | ↑ 1.0 | 15 | 1 |
→
Seq Scan on devices (cost=0.00..2,776.59 rows=15 width=9) (actual time=0.025..2.294 rows=15 loops=1)
|
Planning time | : | 9,672.516 ms |
---|---|---|
Execution time | : | 6.239 ms |