要获得与亚马逊 Timestream 类似的功能 LiveAnalytics，可以考虑适用于 InfluxDB 的亚马逊 Timestream。适用于 InfluxDB 的 Amazon Timestream 提供简化的数据摄取和个位数毫秒级的查询响应时间，以实现实时分析。点击[此处](https://docs.aws.amazon.com//timestream/latest/developerguide/timestream-for-influxdb.html)了解更多信息。
本文属于机器翻译版本。若本译文内容与英语原文存在差异，则一律以英文原文为准。
# 计划查询示例架构
在此示例中，我们将使用一个示例应用程序，该应用程序模仿来自大量服务器的 DevOps 场景监控指标。用户希望对异常资源使用情况发出警报，创建汇总实例集行为和利用率的控制面板，并对近期和历史数据进行复杂分析以发现相关性。下图说明了一组受监控实例向 Timestream 发送指标的设置。 LiveAnalytics另一组并发用户会针对警报、控制面板或临时分析发起查询，此时查询与数据摄取将并行运行。
![\[Diagram showing data flow from servers to Timestream database, with users querying for analytics.\]](http://docs.aws.amazon.com/zh_cn/timestream/latest/developerguide/images/schedquery_common_schema_example.png)
所监控的应用程序被建模为高度可扩展的服务，部署在全球多个区域。每个区域进一步细分为多个缩放单元，其称为单元格，这些单元格在区域内部具有一定程度的基础设施隔离性。每个单元格再进一步细分为筒仓，这代表软件隔离的程度。每个筒仓包含五个微服务，这些微服务共同构成该服务的独立实例。每个微服务都包含多个服务器，这些服务器采用不同的实例类型和操作系统版本，并部署在三个可用区中。这些标识发出指标的服务器的属性在 Timestream 中建模为的[维度](https://docs.aws.amazon.com/timestream/latest/developerguide/concepts.html)。 LiveAnalytics在此架构中，我们具备维度层次结构（例如 region、cell、silo 和 microservice\$1name）和其他跨层次结构的维度（例如 instance\$1type 和 availability\$1zone）。
该应用程序会输出多种指标（例如 cpu\$1user 和 memory\$1free）和事件（例如 task\$1completed 和 gc\$1reclevied）。每个指标或事件都与八个维度（例如区域或单元格）相关联，这些维度唯一标识输出该指标或事件的服务器。数据以多度量记录的形式写入，其中包含 20 个指标，指标名称为 metrics；同时，5 个事件存储在另一个多度量记录中，指标名称为 events。数据模型、架构和数据生成可在[开源数据生成器](https://github.com/awslabs/amazon-timestream-tools/tree/mainline/tools/python/perf-scale-workload)中找到。除了架构和数据分布外，数据生成器还提供了一个使用多个写入器并行摄取数据的示例，使用 Timestream 的摄取缩放每秒采集数百万个测量值。 LiveAnalytics 以下显示架构（表和度量架构）以及数据集中的一些示例数据。
**Topics**
+ [多度量记录](#scheduledqueries-common-schema-example-mmr)
+ [单度量记录](#scheduledqueries-common-schema-example-smr)
## 多度量记录
**表架构**
以下是使用多度量记录摄取数据后的表架构。这是 DESCRIBE 查询的输出。假设数据已摄取到数据库 raw\$1data 和表 devops 中，则查询如下。
```
DESCRIBE "raw_data"."devops"
```
| 列 | Type | LiveAnalytics 属性类型的时间流 |
| --- | --- | --- |
| availability\$1zone | varchar | 维度 |
| microservice\$1name | varchar | 维度 |
| instance\$1name | varchar | 维度 |
| process\$1name | varchar | 维度 |
| os\$1version | varchar | 维度 |
| jdk\$1version | varchar | 维度 |
| 单元格 | varchar | 维度 |
| region | varchar | 维度 |
| 筒仓 | varchar | 维度 |
| instance\$1type | varchar | 维度 |
| measure\$1name | varchar | MEASURE\$1NAME |
| 时间 | timestamp | TIMESTAMP |
| memory\$1free | double | MULTI |
| cpu\$1steal | double | MULTI |
| cpu\$1iowait | double | MULTI |
| cpu\$1user | double | MULTI |
| memory\$1cached | double | MULTI |
| disk\$1io\$1reads | double | MULTI |
| cpu\$1hi | double | MULTI |
| latency\$1per\$1read | double | MULTI |
| network\$1bytes\$1out | double | MULTI |
| cpu\$1idle | double | MULTI |
| disk\$1free | double | MULTI |
| memory\$1used | double | MULTI |
| cpu\$1system | double | MULTI |
| file\$1descriptors\$1in\$1use | double | MULTI |
| disk\$1used | double | MULTI |
| cpu\$1nice | double | MULTI |
| disk\$1io\$1writes | double | MULTI |
| cpu\$1si | double | MULTI |
| latency\$1per\$1write | double | MULTI |
| network\$1bytes\$1in | double | MULTI |
| task\$1end\$1state | varchar | MULTI |
| gc\$1pause | double | MULTI |
| task\$1completed | bigint | MULTI |
| gc\$1recleved | double | MULTI |
**度量架构**
以下是 SHOW MEASURES 查询返回的度量架构。
```
SHOW MEASURES FROM "raw_data"."devops"
```
| measure\$1name | data\$1type | Dimensions |
| --- | --- | --- |
| events | multi | [\$1"data\$1type":"varchar","dimension\$1name":"availability\$1zone"\$1,\$1"data\$1type":"varchar","dimension\$1name":"microservice\$1name"\$1,\$1"data\$1type":"varchar","dimension\$1name":"instance\$1name"\$1,\$1"data\$1type":"varchar","dimension\$1name":"process\$1name"\$1,\$1"data\$1type":"varchar","dimension\$1name":"jdk\$1version"\$1,\$1"data\$1type":"varchar","dimension\$1name":"cell"\$1,\$1"data\$1type":"varchar","dimension\$1name":"region"\$1,\$1"data\$1type":"varchar","dimension\$1name":"silo"\$1] |
| metrics | multi | [\$1"data\$1type":"varchar","dimension\$1name":"availability\$1zone"\$1,\$1"data\$1type":"varchar","dimension\$1name":"microservice\$1name"\$1,\$1"data\$1type":"varchar","dimension\$1name":"instance\$1name"\$1,\$1"data\$1type":"varchar","dimension\$1name":"os\$1version"\$1,\$1"data\$1type":"varchar","dimension\$1name":"cell"\$1,\$1"data\$1type":"varchar","dimension\$1name":"region"\$1,\$1"data\$1type":"varchar","dimension\$1name":"silo"\$1,\$1"data\$1type":"varchar","dimension\$1name":"instance\$1type"\$1] |
**示例数据**
| region | 单元格 | 筒仓 | availability\$1zone | microservice\$1name | instance\$1name | instance\$1type | os\$1version | process\$1name | jdk\$1version | measure\$1name | 时间 | cpu\$1user | cpu\$1system | cpu\$1idle | cpu\$1steal | cpu\$1iowait | cpu\$1nice | cpu\$1hi | cpu\$1si | memory\$1used | memory\$1cached | disk\$1io\$1reads | latency\$1per\$1read | disk\$1io\$1writes | latency\$1per\$1write | disk\$1used | disk\$1free | network\$1bytes\$1in | network\$1bytes\$1out | file\$1descriptors\$1in\$1use | memory\$1free | task\$1end\$1state | gc\$1pause | task\$1completed | gc\$1recleved |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | 雅典娜 | i--2-cell-1-silo zaZswmJk-athena-us-east 2-00000216.amazonaws.com | m5.8xlarge | AL2012 | | | metrics | 11/12/2021 12:43 | 62.8 | 0.408 | 34.2 | 0.972 | 0.0877 | 0.103 | 0.567 | 0.844 | 57.6 | 88.9 | 52.6 | 91.9 | 31.7 | 2.25 | 63.5 | 29.2 | 85.3 | 49.8 | 32.3 | 57.6 | | | | |
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | 雅典娜 | i--2-cell-1-silo zaZswmJk-athena-us-east 2-00000216.amazonaws.com | m5.8xlarge | AL2012 | | | metrics | 11/12/2021 12:41 | 56 | 0.923 | 39.9 | 0.799 | 0.532 | 0.655 | 0.851 | 0.317 | 90.5 | 31.9 | 56.6 | 37.1 | 25 | 93.3 | 52.2 | 33.1 | 7.14 | 53.7 | 65.9 | 20.4 | | | | |
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | 雅典娜 | i--2-cell-1-silo zaZswmJk-athena-us-east 2-00000216.amazonaws.com | m5.8xlarge | AL2012 | | | metrics | 11/12/2021 12:39 | 48.5 | 0.801 | 48.2 | 0.18 | 0.943 | 0.0316 | 0.844 | 0.54 | 97.4 | 41.4 | 55.1 | 32.7 | 86.2 | 33.7 | 72.7 | 61.5 | 80.8 | 5.15 | 44.3 | 8.5 | | | | |
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | 雅典娜 | i--2-cell-1-silo zaZswmJk-athena-us-east 2-00000216.amazonaws.com | m5.8xlarge | AL2012 | | | metrics | 11/12/2021 12:38 | 37.5 | 0.723 | 58.8 | 0.317 | 0.608 | 0.859 | 0.791 | 0.393 | 4.84 | 78.9 | 20.3 | 41.4 | 46.8 | 3.87 | 84.6 | 60.6 | 21.1 | 11.8 | 2.76 | 10 | | | | |
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | 雅典娜 | i--2-cell-1-silo zaZswmJk-athena-us-east 2-00000216.amazonaws.com | m5.8xlarge | AL2012 | | | metrics | 11/12/2021 12:36 | 58 | 0.786 | 38.7 | 0.219 | 0.436 | 0.829 | 0.331 | 0.734 | 51 | 36.8 | 81.8 | 50.5 | 77.9 | 17.8 | 82.3 | 64 | 7.69 | 66.5 | 56.2 | 31.3 | | | | |
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | 雅典娜 | i--2-cell-1-silo zaZswmJk-athena-us-east 2-00000216.amazonaws.com | | | host\$1manager | JDK\$18 | events | 11/12/2021 12:43 | | | | | | | | | | | | | | | | | | | | 75.8 | SUCCESS\$1WITH\$1NO\$1RESULT | 85.5 | 348 | 64.8 |
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | 雅典娜 | i--2-cell-1-silo zaZswmJk-athena-us-east 2-00000216.amazonaws.com | | | host\$1manager | JDK\$18 | events | 11/12/2021 12:41 | | | | | | | | | | | | | | | | | | | | 7.47 | SUCCESS\$1WITH\$1RESULT | 22.8 | 42 | 7.45 |
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | 雅典娜 | i--2-cell-1-silo zaZswmJk-athena-us-east 2-00000216.amazonaws.com | | | host\$1manager | JDK\$18 | events | 11/12/2021 12:39 | | | | | | | | | | | | | | | | | | | | 64.1 | SUCCESS\$1WITH\$1RESULT | 6.77 | 249 | 72.3 |
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | 雅典娜 | i--2-cell-1-silo zaZswmJk-athena-us-east 2-00000216.amazonaws.com | | | host\$1manager | JDK\$18 | events | 11/12/2021 12:38 | | | | | | | | | | | | | | | | | | | | 23 | SUCCESS\$1WITH\$1RESULT | 53.3 | 138 | 99 |
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | 雅典娜 | i--2-cell-1-silo zaZswmJk-athena-us-east 2-00000216.amazonaws.com | | | host\$1manager | JDK\$18 | events | 11/12/2021 12:36 | | | | | | | | | | | | | | | | | | | | 39.4 | SUCCESS\$1WITH\$1NO\$1RESULT | 79.6 | 254 | 82.9 |
## 单度量记录
Timestream for LiveAnalytics 还允许您使用每个时间序列记录中的一个度量来摄取数据。以下是使用单度量记录进行摄取时的架构详细信息。
**表架构**
以下是使用多度量记录摄取数据后的表架构。这是 DESCRIBE 查询的输出。假设数据已摄取到数据库 raw\$1data 和表 devops 中，则查询如下。
```
DESCRIBE "raw_data"."devops_single"
```
| 列 | Type | LiveAnalytics 属性类型的时间流 |
| --- | --- | --- |
| availability\$1zone | varchar | 维度 |
| microservice\$1name | varchar | 维度 |
| instance\$1name | varchar | 维度 |
| process\$1name | varchar | 维度 |
| os\$1version | varchar | 维度 |
| jdk\$1version | varchar | 维度 |
| 单元格 | varchar | 维度 |
| region | varchar | 维度 |
| 筒仓 | varchar | 维度 |
| instance\$1type | varchar | 维度 |
| measure\$1name | varchar | MEASURE\$1NAME |
| 时间 | timestamp | TIMESTAMP |
| measure\$1value::double | double | MEASURE\$1VALUE |
| measure\$1value::bigint | bigint | MEASURE\$1VALUE |
| measure\$1value::varchar | varchar | MEASURE\$1VALUE |
**度量架构**
以下是 SHOW MEASURES 查询返回的度量架构。
```
SHOW MEASURES FROM "raw_data"."devops_single"
```
| measure\$1name | data\$1type | Dimensions |
| --- | --- | --- |
| cpu\$1hi | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| cpu\$1idle | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| cpu\$1iowait | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| cpu\$1nice | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| cpu\$1si | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| cpu\$1steal | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| cpu\$1system | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| cpu\$1user | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| disk\$1free | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| disk\$1io\$1reads | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| disk\$1io\$1writes | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| disk\$1used | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| file\$1descriptors\$1in\$1use | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| gc\$1pause | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'process\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'jdk\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1] |
| gc\$1recleved | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'process\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'jdk\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1] |
| latency\$1per\$1read | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| latency\$1per\$1write | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| memory\$1cached | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| memory\$1free | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'process\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'jdk\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| memory\$1used | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| network\$1bytes\$1in | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| network\$1bytes\$1out | double | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'os\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1type', 'data\$1type': 'varchar'\$1] |
| task\$1completed | bigint | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'process\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'jdk\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1] |
| task\$1end\$1state | varchar | [\$1'dimension\$1name': 'availability\$1zone', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'microservice\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'instance\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'process\$1name', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'jdk\$1version', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'cell', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'region', 'data\$1type': 'varchar'\$1, \$1'dimension\$1name': 'silo', 'data\$1type': 'varchar'\$1] |
**示例数据**
| availability\$1zone | microservice\$1name | instance\$1name | process\$1name | os\$1version | jdk\$1version | 单元格 | region | 筒仓 | instance\$1type | measure\$1name | 时间 | measure\$1value::double | measure\$1value::bigint | measure\$1value::varchar |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\$1hi | 34:57.2 | 0.87169 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\$1idle | 34:57.2 | 3.46266 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\$1iowait | 34:57.2 | 0.10226 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\$1nice | 34:57.2 | 0.63013 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\$1si | 34:57.2 | 0.16441 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\$1steal | 34:57.2 | 0.10729 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\$1system | 34:57.2 | 0.45709 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\$1user | 34:57.2 | 94.20448 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | disk\$1free | 34:57.2 | 72.51895 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | disk\$1io\$1reads | 34:57.2 | 81.73383 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | disk\$1io\$1writes | 34:57.2 | 77.11665 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | disk\$1used | 34:57.2 | 89.42235 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | file\$1descriptors\$1in\$1use | 34:57.2 | 30.08254 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | server | | JDK\$18 | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | | gc\$1pause | 34:57.2 | 60.28679 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | server | | JDK\$18 | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | | gc\$1recleved | 34:57.2 | 75.28839 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | latency\$1per\$1read | 34:57.2 | 8.07605 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | latency\$1per\$1write | 34:57.2 | 58.11223 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | memory\$1cached | 34:57.2 | 87.56481 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | server | | JDK\$18 | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | | memory\$1free | 34:57.2 | 18.95768 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | memory\$1free | 34:57.2 | 97.20523 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | memory\$1used | 34:57.2 | 12.37723 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | network\$1bytes\$1in | 34:57.2 | 31.02065 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | | AL2012 | | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | network\$1bytes\$1out | 34:57.2 | 0.51424 | | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | server | | JDK\$18 | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | | task\$1completed | 34:57.2 | | 69 | |
| eu-west-1-1 | hercules | i-zaZswmJk--1-cell-9-silo-2-00000027.am hercules-eu-west azonaws.com | server | | JDK\$18 | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | | task\$1end\$1state | 34:57.2 | | | SUCCESS\$1WITH\$1RESULT |