Test results with the existing indexes
- Last UpdatedApr 24, 2025
- 1 minute read
CPU Time and Query Duration for the queries were extracted from the profiler results. The CPU was monitored using the Windows Performance Monitor.
|
Test Action |
Max CPU % |
Average CPU Time (milliseconds) |
Average Duration (milliseconds) |
|---|---|---|---|
|
readTimeSeriesCollect |
10% |
106 |
228 |
|
TimeSeries Collect row insertion |
7% |
1539 |
1587 |
|
TimeSeries Collect row deletion |
6% |
1561 |
1786 |
Disk Space Requirements
The total index size, the number of rows, the disk space reserved, and the disk space used and unused by the collect table are described in the table below.
|
Name |
Index Size |
Rows |
Reserved |
Data |
Unused |
|---|---|---|---|---|---|
|
collect |
38 GB |
>725 million |
76 GB |
38 GB |
1920 KB |
The sizes of each index in the collect table are described in the table below.
|
Index Name |
Index ID |
Type |
Type Description |
Index Size |
|---|---|---|---|---|
|
CollectTimeTagIdx |
1 |
1 |
CLUSTERED |
119 MB |
|
CollectTagTimeIdx |
2 |
2 |
NONCLUSTERED |
16 GB |
|
CollectTagFieldTimeIdx |
3 |
2 |
NONCLUSTERED |
22 GB |