Amazon Timestream for LiveAnalytics に類似した機能をご希望の場合は Amazon Timestream for InfluxDB をご検討ください。リアルタイム分析に適した、シンプルなデータインジェストと 1 桁ミリ秒のクエリ応答時間を特徴としています。詳細については、[こちら](https://docs.aws.amazon.com//timestream/latest/developerguide/timestream-for-influxdb.html)を参照してください。

翻訳は機械翻訳により提供されています。提供された翻訳内容と英語版の間で齟齬、不一致または矛盾がある場合、英語版が優先します。

# スケジュールされたクエリのサンプルスキーマ
<a name="scheduledqueries-common-schema-example"></a>

この例では、大規模なサーバーフリートからのメトリクスをモニタリングする DevOps シナリオを模倣したサンプルアプリケーションを使用します。ユーザーが望むのは、異常なリソース使用状況に関するアラートの受信、フリートの動作と使用状況の集計を表示するダッシュボードの作成、最新データと履歴データの高度な分析による相関関係の特定です。次の図は、一連のモニタリング対象インスタンスがメトリクスを Timestream for LiveAnalytics に発行する設定を示しています。別の同時ユーザーグループがアラート、ダッシュボード、またはアドホック分析のクエリを発行し、クエリと取り込みが並行して行われます。

![](http://docs.aws.amazon.com/ja_jp/timestream/latest/developerguide/images/schedquery_common_schema_example.png)


モニタリング対象のアプリケーションは、世界中のいくつかのリージョンにデプロイされる高度にスケールアウトされたサービスとしてモデリングされています。各リージョンは、リージョン内のインフラストラクチャに関して一定の分離レベルを持つ、セルと呼ばれる複数のスケーリングユニットにさらに分割されます。各セルは、さらにサイロに分割されます。これは、ソフトウェアの分離レベルを表します。各サイロには、サービスの単一の独立したインスタンスを構成する 5 つのマイクロサービスがあります。各マイクロサービスには、インスタンスタイプと OS バージョンが異なる複数のサーバーがあり、3 つのアベイラビリティーゾーンにデプロイされます。メトリクスを発行するサーバーを識別するこれらの属性は、Timestream for LiveAnalytics で[ディメンション](https://docs.aws.amazon.com/timestream/latest/developerguide/concepts.html)としてモデリングされます。このアーキテクチャには、ディメンションの階層 (region、cell、silo、microservice\_name など) と、階層を横断するその他のディメンション (instance\_type や availability\_zone など) があります。

アプリケーションは、さまざまなメトリクス (cpu\_user や memory\_free など) とイベント (task\_completed や gc\_reclaimed など) を発行します。各メトリクスまたはイベントは、発行するサーバーを一意に識別する 8 つのディメンション (リージョンやセルなど) に関連付けられます。データは、メジャー名メトリクスを含むマルチメジャーレコードにまとめて保存される 20 個のメトリクスを使用して書き込まれます。5 つのイベントはすべて、メジャー名イベントを含む別のマルチメジャーレコードにまとめて保存されます。データモデル、スキーマ、およびデータ生成は、[オープンソースのデータジェネレーター](https://github.com/awslabs/amazon-timestream-tools/tree/mainline/tools/python/perf-scale-workload)で確認できます。データジェネレーターは、スキーマとデータ分布に加えて、複数のライターを使用してデータを並行して取り込み、Timestream for LiveAnalytics の取り込みスケーリングを使用して 1 秒あたり数百万の測定値を取り込む例を提供します。以下に、スキーマ (テーブルスキーマおよびメジャースキーマ) と、データセットのサンプルデータを示します。

**Topics**
+ [マルチメジャーレコード](#scheduledqueries-common-schema-example-mmr)
+ [単一メジャーレコード](#scheduledqueries-common-schema-example-smr)

## マルチメジャーレコード
<a name="scheduledqueries-common-schema-example-mmr"></a>

**テーブルスキーマ**

以下は、マルチメジャーレコードを使用してデータが取り込まれた後のテーブルスキーマです。これは DESCRIBE クエリの出力です。データがデータベース raw\_data とテーブル devops に取り込まれる場合、クエリは以下のようになります。

```
DESCRIBE "raw_data"."devops"
```


| 列 | タイプ | Timestream for LiveAnalytics の属性タイプ | 
| --- | --- | --- | 
| availability\_zone | varchar | ディメンション | 
| microservice\_name | varchar | ディメンション | 
| instance\_name | varchar | ディメンション | 
| process\_name | varchar | ディメンション | 
| os\_version | varchar | ディメンション | 
| jdk\_version | varchar | ディメンション | 
| cell | varchar | ディメンション | 
| リージョン | varchar | ディメンション | 
| silo | varchar | ディメンション | 
| instance\_type | varchar | ディメンション | 
| measure\_name | varchar | MEASURE\_NAME | 
| 時間 | timestamp | TIMESTAMP | 
| memory\_free | double | MULTI | 
| cpu\_steal | double | MULTI | 
| cpu\_iowait | double | MULTI | 
| cpu\_user | double | MULTI | 
| memory\_cached | double | MULTI | 
| disk\_io\_reads | double | MULTI | 
| cpu\_hi | double | MULTI | 
| latency\_per\_read | double | MULTI | 
| network\_bytes\_out | double | MULTI | 
| cpu\_idle | double | MULTI | 
| disk\_free | double | MULTI | 
| memory\_used | double | MULTI | 
| cpu\_system | double | MULTI | 
| file\_descriptors\_in\_use | double | MULTI | 
| disk\_used | double | MULTI | 
| cpu\_nice | double | MULTI | 
| disk\_io\_writes | double | MULTI | 
| cpu\_si | double | MULTI | 
| latency\_per\_write | double | MULTI | 
| network\_bytes\_in | double | MULTI | 
| task\_end\_state | varchar | MULTI | 
| gc\_pause | double | MULTI | 
| task\_completed | bigint | MULTI | 
| gc\_reclaimed | double | MULTI | 

**メジャースキーマ**

以下は、SHOW MEASURES クエリによって返されるメジャースキーマです。

```
SHOW MEASURES FROM "raw_data"."devops"
```


| measure\_name | data\_type | ディメンション | 
| --- | --- | --- | 
| イベント | multi | [{"data\_type":"varchar","dimension\_name":"availability\_zone"},{"data\_type":"varchar","dimension\_name":"microservice\_name"},{"data\_type":"varchar","dimension\_name":"instance\_name"},{"data\_type":"varchar","dimension\_name":"process\_name"},{"data\_type":"varchar","dimension\_name":"jdk\_version"},{"data\_type":"varchar","dimension\_name":"cell"},{"data\_type":"varchar","dimension\_name":"region"},{"data\_type":"varchar","dimension\_name":"silo"}] | 
| metrics | multi | [{"data\_type":"varchar","dimension\_name":"availability\_zone"},{"data\_type":"varchar","dimension\_name":"microservice\_name"},{"data\_type":"varchar","dimension\_name":"instance\_name"},{"data\_type":"varchar","dimension\_name":"os\_version"},{"data\_type":"varchar","dimension\_name":"cell"},{"data\_type":"varchar","dimension\_name":"region"},{"data\_type":"varchar","dimension\_name":"silo"},{"data\_type":"varchar","dimension\_name":"instance\_type"}] | 

**サンプルデータ**


| リージョン | セル | サイロ | availability\_zone | microservice\_name | instance\_name | instance\_type | os\_version | process\_name | jdk\_version | measure\_name | Time | cpu\_user | cpu\_system | cpu\_idle | cpu\_steal | cpu\_iowait | cpu\_nice | cpu\_hi | cpu\_si | memory\_used | memory\_cached | disk\_io\_reads | latency\_per\_read | disk\_io\_writes | latency\_per\_write | disk\_used | disk\_free | network\_bytes\_in | network\_bytes\_out | file\_descriptors\_in\_use | memory\_free | task\_end\_state | gc\_pause | task\_completed | gc\_reclaimed | 
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | 
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | athena | i-zaZswmJk-athena-us-east-2-cell-1-silo-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 | athena | i-zaZswmJk-athena-us-east-2-cell-1-silo-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 | athena | i-zaZswmJk-athena-us-east-2-cell-1-silo-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 | athena | i-zaZswmJk-athena-us-east-2-cell-1-silo-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 | athena | i-zaZswmJk-athena-us-east-2-cell-1-silo-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 | athena | i-zaZswmJk-athena-us-east-2-cell-1-silo-2-00000216.amazonaws.com |  |  | host\_manager | JDK\_8 | events | 11/12/2021 12:43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75.8 | SUCCESS\_WITH\_NO\_RESULT | 85.5 | 348 | 64.8 | 
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | athena | i-zaZswmJk-athena-us-east-2-cell-1-silo-2-00000216.amazonaws.com |  |  | host\_manager | JDK\_8 | events | 11/12/2021 12:41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.47 | SUCCESS\_WITH\_RESULT | 22.8 | 42 | 7.45 | 
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | athena | i-zaZswmJk-athena-us-east-2-cell-1-silo-2-00000216.amazonaws.com |  |  | host\_manager | JDK\_8 | events | 11/12/2021 12:39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64.1 | SUCCESS\_WITH\_RESULT | 6.77 | 249 | 72.3 | 
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | athena | i-zaZswmJk-athena-us-east-2-cell-1-silo-2-00000216.amazonaws.com |  |  | host\_manager | JDK\_8 | events | 11/12/2021 12:38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | SUCCESS\_WITH\_RESULT | 53.3 | 138 | 99 | 
| us-east-2 | us-east-2-cell-1 | us-east-2-cell-1-silo-2 | us-east-2-1 | athena | i-zaZswmJk-athena-us-east-2-cell-1-silo-2-00000216.amazonaws.com |  |  | host\_manager | JDK\_8 | events | 11/12/2021 12:36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39.4 | SUCCESS\_WITH\_NO\_RESULT | 79.6 | 254 | 82.9 | 

## 単一メジャーレコード
<a name="scheduledqueries-common-schema-example-smr"></a>

Timestream for LiveAnalytics では、時系列レコードごとに単一のメジャーでデータを取り込むこともできます。以下は、単一メジャーレコードを使用した取り込みのスキーマの詳細です。

**テーブルスキーマ**

以下は、マルチメジャーレコードを使用してデータが取り込まれた後のテーブルスキーマです。これは DESCRIBE クエリの出力です。データがデータベース raw\_data とテーブル devops に取り込まれる場合、クエリは以下のようになります。

```
DESCRIBE "raw_data"."devops_single"
```


| 列 | タイプ | Timestream for LiveAnalytics の属性タイプ | 
| --- | --- | --- | 
| availability\_zone | varchar | ディメンション | 
| microservice\_name | varchar | ディメンション | 
| instance\_name | varchar | ディメンション | 
| process\_name | varchar | ディメンション | 
| os\_version | varchar | ディメンション | 
| jdk\_version | varchar | ディメンション | 
| cell | varchar | ディメンション | 
| リージョン | varchar | ディメンション | 
| silo | varchar | ディメンション | 
| instance\_type | varchar | ディメンション | 
| measure\_name | varchar | MEASURE\_NAME | 
| 時間 | timestamp | TIMESTAMP | 
| measure\_value::double | double | MEASURE\_VALUE | 
| measure\_value::bigint | bigint | MEASURE\_VALUE | 
| measure\_value::varchar | varchar | MEASURE\_VALUE | 

**メジャースキーマ**

以下は、SHOW MEASURES クエリによって返されるメジャースキーマです。

```
SHOW MEASURES FROM "raw_data"."devops_single"
```


| measure\_name | data\_type | ディメンション | 
| --- | --- | --- | 
| cpu\_hi | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| cpu\_idle | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| cpu\_iowait | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| cpu\_nice | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| cpu\_si | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| cpu\_steal | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| cpu\_system | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| cpu\_user | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| disk\_free | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| disk\_io\_reads | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| disk\_io\_writes | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| disk\_used | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| file\_descriptors\_in\_use | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| gc\_pause | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'process\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'jdk\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}] | 
| gc\_reclaimed | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'process\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'jdk\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}] | 
| latency\_per\_read | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| latency\_per\_write | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| memory\_cached | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| memory\_free | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'process\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'jdk\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| memory\_used | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| network\_bytes\_in | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| network\_bytes\_out | double | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'os\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_type', 'data\_type': 'varchar'}] | 
| task\_completed | bigint | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'process\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'jdk\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}] | 
| task\_end\_state | varchar | [{'dimension\_name': 'availability\_zone', 'data\_type': 'varchar'}, {'dimension\_name': 'microservice\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'instance\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'process\_name', 'data\_type': 'varchar'}, {'dimension\_name': 'jdk\_version', 'data\_type': 'varchar'}, {'dimension\_name': 'cell', 'data\_type': 'varchar'}, {'dimension\_name': 'region', 'data\_type': 'varchar'}, {'dimension\_name': 'silo', 'data\_type': 'varchar'}] | 

**サンプルデータ**


| availability\_zone | microservice\_name | instance\_name | process\_name | os\_version | jdk\_version | セル | リージョン | サイロ | instance\_type | measure\_name | Time | measure\_value::double | measure\_value::bigint | measure\_value::varchar | 
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\_hi | 34:57.2 | 0.87169 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\_idle | 34:57.2 | 3.46266 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\_iowait | 34:57.2 | 0.10226 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\_nice | 34:57.2 | 0.63013 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\_si | 34:57.2 | 0.16441 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\_steal | 34:57.2 | 0.10729 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\_system | 34:57.2 | 0.45709 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | cpu\_user | 34:57.2 | 94.20448 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | disk\_free | 34:57.2 | 72.51895 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | disk\_io\_reads | 34:57.2 | 81.73383 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | disk\_io\_writes | 34:57.2 | 77.11665 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | disk\_used | 34:57.2 | 89.42235 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | file\_descriptors\_in\_use | 34:57.2 | 30.08254 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com | server |  | JDK\_8 | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 |  | gc\_pause | 34:57.2 | 60.28679 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com | server |  | JDK\_8 | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 |  | gc\_reclaimed | 34:57.2 | 75.28839 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | latency\_per\_read | 34:57.2 | 8.07605 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | latency\_per\_write | 34:57.2 | 58.11223 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | memory\_cached | 34:57.2 | 87.56481 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com | server |  | JDK\_8 | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 |  | memory\_free | 34:57.2 | 18.95768 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | memory\_free | 34:57.2 | 97.20523 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | memory\_used | 34:57.2 | 12.37723 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | network\_bytes\_in | 34:57.2 | 31.02065 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com |  | AL2012 |  | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 | r5.4xlarge | network\_bytes\_out | 34:57.2 | 0.51424 |  |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com | server |  | JDK\_8 | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 |  | task\_completed | 34:57.2 |  | 69 |  | 
| eu-west-1-1 | hercules | i-zaZswmJk-hercules-eu-west-1-cell-9-silo-2-00000027.amazonaws.com | server |  | JDK\_8 | eu-west-1-cell-9 | eu-west-1 | eu-west-1-cell-9-silo-2 |  | task\_end\_state | 34:57.2 |  |  | SUCCESS\_WITH\_RESULT |