Para obtener capacidades similares a las de Amazon Timestream, considere Amazon Timestream LiveAnalytics para InfluxDB. Ofrece una ingesta de datos simplificada y tiempos de respuesta a las consultas en milisegundos de un solo dígito para realizar análisis en tiempo real. Obtenga más información aquí.
Las traducciones son generadas a través de traducción automática. En caso de conflicto entre la traducción y la version original de inglés, prevalecerá la version en inglés.
Ejemplo de esquema de consultas programadas
En este ejemplo, utilizaremos una aplicación de muestra que simula las métricas de monitoreo de una situación de DevOps de una gran flota de servidores. Los usuarios quieren alertar sobre el uso anómalo de los recursos, crear paneles sobre el comportamiento y la utilización agregados de la flota y realizar análisis sofisticados de los datos recientes e históricos para encontrar correlaciones. En el siguiente diagrama, se ofrece un ejemplo de la configuración en la que un conjunto de instancias supervisadas emiten métricas a Timestream para LiveAnalytics. Otro grupo de usuarios simultáneos emite consultas para alertas, paneles o análisis ad hoc, en las que las consultas y la ingesta se ejecutan en paralelo.
La aplicación que se monitorea está modelada como un servicio altamente escalable horizontalmente que se implementa en varias regiones del mundo. Además, cada región se subdivide en varias unidades de escalado llamadas celdas que tienen un nivel de aislamiento en términos de infraestructura dentro de la región. Además, cada celda se subdivide en silos, lo que representa un nivel de aislamiento del software. Cada silo tiene cinco microservicios que comprenden una instancia aislada del servicio. Cada microservicio tiene varios servidores con distintos tipos de instancias y versiones del sistema operativo, que se implementan en tres zonas de disponibilidad. Estos atributos que identifican a los servidores que emiten las métricas se modelan como dimensiones en Timestream para LiveAnalytics. En esta arquitectura, tenemos una jerarquía de dimensiones (como región, celda, silo y microservice_name) y otras dimensiones transversales a la jerarquía (como instance_type y availability_zone).
La aplicación emite una variedad de métricas (como cpu_user y memory_free) y eventos (como task_completed y gc_reclaimed). Cada métrica o evento está asociado a ocho dimensiones (como una región o una celda) que identifican de forma exclusiva al servidor que lo emite. Los datos se escriben con las 20 métricas almacenadas juntas en un registro de varias medidas con métricas de nombres de medidas y los 5 eventos se almacenan juntos en otro registro de varias medidas con eventos de nombres de medidas. El modelo de datos, el esquema y la generación de datos se encuentran en el generador de datos de código abierto
Registros de varias medidas
Esquema de tabla
A continuación, se muestra el esquema de tabla una vez que se ingieren los datos mediante registros de varias medidas. Es el resultado de la consulta DESCRIBE. Suponiendo que los datos se ingieren en una base de datos raw_data y en la tabla DevOps, a continuación se muestra la consulta.
DESCRIBE "raw_data"."devops"
| Columna | Tipo | Tipo de atributo de Timestream para LiveAnalytics |
|---|---|---|
| availability_zone | varchar | DIMENSION |
| microservice_name | varchar | DIMENSION |
| instance_name | varchar | DIMENSION |
| process_name | varchar | DIMENSION |
| os_version | varchar | DIMENSION |
| jdk_version | varchar | DIMENSION |
| celda | varchar | DIMENSION |
| región | varchar | DIMENSION |
| silo | varchar | DIMENSION |
| instance_type | varchar | DIMENSION |
| measure_name | varchar | MEASURE_NAME |
| tiempo | marca de tiempo | 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 |
Esquema de medidas
A continuación, se muestra el esquema de medidas que muestra la consulta SHOW MEASURES.
SHOW MEASURES FROM "raw_data"."devops"
| measure_name | data_type | Dimensiones |
|---|---|---|
| eventos | 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"}] |
| métricas | 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"}] |
Datos de ejemplo
| region | Celda | Silo | 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 | métricas | 12/11/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 | métricas | 12/11/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 | métricas | 12/11/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 | métricas | 12/11/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 | métricas | 12/11/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 | eventos | 12/11/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 | eventos | 12/11/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 | eventos | 12/11/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 | eventos | 12/11/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 | eventos | 12/11/2021 12:36 | 39,4 | SUCCESS_WITH_NO_RESULT | 79,6 | 254 | 82,9 |
Registros de una sola medida
Timestream para LiveAnalytics también permite ingerir los datos con una medida por registro de serie temporal. A continuación, encontrará los detalles del esquema cuando se ingieren mediante registros de una sola medida.
Esquema de tabla
A continuación, se muestra el esquema de tabla una vez que se ingieren los datos mediante registros de varias medidas. Es el resultado de la consulta DESCRIBE. Suponiendo que los datos se ingieren en una base de datos raw_data y en la tabla DevOps, a continuación se muestra la consulta.
DESCRIBE "raw_data"."devops_single"
| Columna | Tipo | Tipo de atributo de Timestream para LiveAnalytics |
|---|---|---|
| availability_zone | varchar | DIMENSION |
| microservice_name | varchar | DIMENSION |
| instance_name | varchar | DIMENSION |
| process_name | varchar | DIMENSION |
| os_version | varchar | DIMENSION |
| jdk_version | varchar | DIMENSION |
| celda | varchar | DIMENSION |
| región | varchar | DIMENSION |
| silo | varchar | DIMENSION |
| instance_type | varchar | DIMENSION |
| measure_name | varchar | MEASURE_NAME |
| tiempo | marca de tiempo | TIMESTAMP |
| measure_value::double | double | MEASURE_VALUE |
| measure_value::bigint | bigint | MEASURE_VALUE |
| measure_value::varchar | varchar | MEASURE_VALUE |
Esquema de medidas
A continuación, se muestra el esquema de medidas que muestra la consulta SHOW MEASURES.
SHOW MEASURES FROM "raw_data"."devops_single"
| measure_name | data_type | Dimensiones |
|---|---|---|
| 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'}] |
Datos de ejemplo
| availability_zone | microservice_name | instance_name | process_name | os_version | jdk_version | Celda | region | Silo | 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 |
