3.1.2

Prometheus metrics mapping

This page describes the mapping between metrics provided by Prometheus to Akamas metrics for each supported component type

Component TypeNotes

Linux

JVM

Docker Container

Kubernetes Container

The default metrics in this table are based on the cadvisor and kube-state-metrics

Kubernetes Pod

The default metrics in this table are based on the cadvisor and kube-state-metrics

EC2

The default metrics in this table are based on the CloudWatch Exporter, configured with the attached custom configuration file

Oracle Database

The default metrics in this table are based on the OracleDB Exporter, extending the default queries with the attached custom configuration file

Web Application

The default metrics in this table are based on the Prometheus Listener for Jmeter

Linux

Component metricPrometheus query

cpu_load_avg

node_load1{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}

cpu_num

count(node_cpu_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$", mode="system" %FILTERS%})

cpu_used

sum by (job) (sum by (cpu, job) (rate(node_cpu_seconds_total{instance=~"$INSTANCE$", mode=~"user|system|softirq|irq|nice", job=~"$JOB$" %FILTERS%}[$DURATION$])))

cpu_util

avg by (job) (sum by (cpu, job) (rate(node_cpu_seconds_total{instance=~"$INSTANCE$", mode=~"user|system|softirq|irq|nice", job=~"$JOB$" %FILTERS%}[$DURATION$])))

cpu_util_details

avg by (instance, cpu, mode, job) (sum by (instance, cpu, mode, job) (rate(node_cpu_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])))

disk_io_inflight_details

node_disk_io_now{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}

disk_iops

sum by (instance, job) (rate(node_disk_writes_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])) + sum by (instance, job) (rate(node_disk_reads_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

disk_iops_details

sum by (instance, device, job) (rate(node_disk_writes_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

disk_iops_details

sum by (instance, device, job) (rate(node_disk_reads_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

disk_iops_details

sum by (instance, device, job) (rate(node_disk_writes_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])) + sum by (instance, device, job) (rate(node_disk_reads_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

disk_iops_reads

sum by (instance, job) (rate(node_disk_reads_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

disk_iops_writes

sum by (instance, job) (rate(node_disk_writes_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

disk_read_bytes

sum by (instance, device, job) (rate(node_disk_read_bytes_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

disk_read_bytes_details

sum by (instance, device, job) (rate(node_disk_read_bytes_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

disk_read_write_bytes

sum by (instance, device, job) (rate(node_disk_written_bytes_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]) + rate(node_disk_read_bytes_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

disk_response_time

avg by (instance, job) ((rate(node_disk_read_time_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]) + rate(node_disk_write_time_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])) / (rate(node_disk_reads_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]) + rate(node_disk_writes_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]) > 0 ))

disk_response_time_details

avg by (instance, device, job) ((rate(node_disk_read_time_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]) + rate(node_disk_write_time_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])) / ((rate(node_disk_reads_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]) + rate(node_disk_writes_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])) > 0))

disk_response_time_read

rate(node_disk_read_time_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])/ rate(node_disk_reads_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])

disk_response_time_worst

max by (instance, job) ((rate(node_disk_read_time_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]) + rate(node_disk_write_time_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])) / (rate(node_disk_reads_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]) + rate(node_disk_writes_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]) > 0 ))

disk_response_time_write

rate(node_disk_write_time_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])/ rate(node_disk_writes_completed_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])

disk_swap_used

node_memory_SwapTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} - node_memory_SwapFree_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}

disk_swap_util

((node_memory_SwapTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} - node_memory_SwapFree_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}) / (node_memory_SwapTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} > 0)) or ((node_memory_SwapTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} - node_memory_SwapFree_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}))

disk_util_details

rate(node_disk_io_time_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])

disk_write_bytes

sum by (instance, device, job) (rate(node_disk_written_bytes_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

disk_write_bytes_details

sum by (instance, device, job) (rate(node_disk_written_bytes_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

filesystem_size

node_filesystem_size_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}

filesystem_used

node_filesystem_size_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} - node_filesystem_free_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}

filesystem_util

((node_filesystem_size_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} - node_filesystem_free_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}) / node_filesystem_size_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%})

mem_fault_major

rate(node_vmstat_pgmajfault{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])

mem_fault_minor

rate(node_vmstat_pgfault{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])

mem_swapins

rate(node_vmstat_pswpin{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])

mem_swapouts

rate(node_vmstat_pswpout{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])

mem_total

node_memory_MemTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}

mem_used

(node_memory_MemTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} - node_memory_MemFree_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%})

mem_util

(node_memory_MemTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} - node_memory_MemFree_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}) / node_memory_MemTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}

mem_util_details

(node_memory_Active_file_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} / node_memory_MemTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%})

mem_util_details

(node_memory_Active_anon_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} / node_memory_MemTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%})

mem_util_details

(node_memory_Inactive_file_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} / node_memory_MemTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%})

mem_util_details

(node_memory_Inactive_anon_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} / node_memory_MemTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%})

mem_util_nocache

(node_memory_MemTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} - node_memory_Buffers_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} - node_memory_Cached_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%} - node_memory_MemFree_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}) / node_memory_MemTotal_bytes{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}

network_in_bytes_details

rate(node_network_receive_bytes_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])

network_out_bytes_details

rate(node_network_transmit_bytes_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])

network_tcp_retrans

rate(node_netstat_Tcp_RetransSegs{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])

os_context_switch

rate(node_context_switches_total{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}[$DURATION$])

proc_blocked

node_procs_blocked{instance=~"$INSTANCE$", job=~"$JOB$" %FILTERS%}

JVM

Component metricPrometheus query

transactions_response_time

avg(rate(ResponseTime_sum{code="200", job=~"$JOB$" %FILTERS%}[$DURATION$])/rate(ResponseTime_count{code="200", job=~"$JOB$" %FILTERS%}[$DURATION$])>0)

transactions_response_time_max

max(rate(ResponseTime_sum{code="200", job=~"$JOB$" %FILTERS%}[$DURATION$])/rate(ResponseTime_count{code="200", job=~"$JOB$" %FILTERS%}[$DURATION$])>0)

transactions_response_time_min

min(rate(ResponseTime_sum{code="200", job=~"$JOB$" %FILTERS%}[$DURATION$])/rate(ResponseTime_count{code="200", job=~"$JOB$" %FILTERS%}[$DURATION$])>0)

transactions_response_time_p50

ResponseTime{quantile="0.5", code="200", job=~"$JOB$" %FILTERS%}

transactions_response_time_p85

ResponseTime{quantile="0.85", code="200", job=~"$JOB$" %FILTERS%}

transactions_response_time_p90

ResponseTime{quantile="0.9", code="200", job=~"$JOB$" %FILTERS%}

transactions_response_time_p99

ResponseTime{quantile="0.99", code="200", job=~"$JOB$" %FILTERS%}

transactions_throughput

sum(rate(Ratio_success{job=~"$JOB$" %FILTERS%}[$DURATION$]))

transactions_error_throughput

sum(rate(Ratio_failure{job=~"$JOB$" %FILTERS%}[$DURATION$]))

transactions_error_rate

(avg(rate(Ratio_failure{job=~"$JOB$" %FILTERS%}[$DURATION$]))/avg(rate(Ratio_total{job=~"$JOB$" %FILTERS%}[$DURATION$])))*100

users

sum(jmeter_threads{state="active", job=~"$JOB$" %FILTERS%})

Docker Container

Component metricPrometheus query

container_cpu_used

sum(rate(container_cpu_usage_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}[$DURATION$]))

container_cpu_throttle_time

sum(rate(container_cpu_cfs_throttled_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}[$DURATION$]))

container_cpu_limit

sum(container_spec_cpu_quota{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}/container_spec_cpu_period{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%})

container_cpu_util

sum(rate(container_cpu_usage_seconds_total{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}[$DURATION$])) /sum(container_spec_cpu_quota{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}/container_spec_cpu_period{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%})

container_mem_used

container_memory_usage_bytes{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}

container_mem_limit

container_spec_memory_limit_bytes{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}

container_mem_util_nocache

container_memory_working_set_bytes{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}/container_spec_memory_limit_bytes{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}

container_mem_util

container_memory_usage_bytes{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}/container_spec_memory_limit_bytes{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}

container_mem_working_set

container_memory_working_set_bytes{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}

container_mem_limit_hits

sum(rate(container_memory_failcnt{instance=~"$INSTANCE$", job=~"$JOB$", name=~"$NAME$" %FILTERS%}[$DURATION$]))

Kubernetes Pod

Component metricPrometheus metric

k8s_pod_cpu_used

1e3 * sum by(namespace, pod) (rate(container_cpu_usage_seconds_total{pod=~"$POD$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

k8s_pod_cpu_util

sum by(namespace, pod) (rate(container_cpu_usage_seconds_total{pod=~"$POD$", job=~"$JOB$" %FILTERS%}[$DURATION$])) / sum by(namespace, pod) (kube_pod_container_resource_limits{resource="cpu", pod=~"$POD$", job=~"$JOB$" %FILTERS%})

k8s_pod_cpu_request

1e3 * sum by(namespace, pod) (kube_pod_container_resource_requests{resource="cpu", pod=~"$POD$", job=~"$JOB$" %FILTERS%})

k8s_pod_cpu_limit

1e3 * sum by(namespace, pod) (kube_pod_container_resource_limits{resource="cpu", pod=~"$POD$", job=~"$JOB$" %FILTERS%})

k8s_pod_memory_used

sum by(namespace, pod) (container_memory_usage_bytes{pod=~"$POD$", job=~"$JOB$" %FILTERS%})

k8s_pod_memory_util

sum by(namespace, pod) (container_memory_usage_bytes{pod=~"$POD$", job=~"$JOB$" %FILTERS%}) / sum by(namespace, pod) (container_spec_memory_limit_bytes{pod=~"$POD$", job=~"$JOB$" %FILTERS%})

k8s_pod_memory_util_nocache

sum by(namespace, pod) (container_memory_working_set_bytes{pod=~"$POD$", job=~"$JOB$" %FILTERS%}) / sum by(namespace, pod) (container_spec_memory_limit_bytes{pod=~"$POD$", job=~"$JOB$" %FILTERS%})

k8s_pod_memory_working_set

sum by(namespace, pod) (container_memory_working_set_bytes{pod=~"$POD$", job=~"$JOB$" %FILTERS%})

k8s_pod_memory_request

sum by(namespace, pod) (kube_pod_container_resource_requests{resource="memory", pod=~"$POD$", job=~"$JOB$" %FILTERS%})

k8s_pod_memory_limit

sum by(namespace, pod) (container_spec_memory_limit_bytes{pod=~"$POD$", job=~"$JOB$" %FILTERS%})

k8s_pod_container_restarts

sum by(namespace, pod) (kube_pod_container_status_restarts_total{pod=~"$POD$", job=~"$JOB$" %FILTERS%})

k8s_pod_desired_containers

count(sum by(namespace, pod) (kube_pod_container_info{pod=~"$POD$", job=~"$JOB$" %FILTERS%}))

k8s_workload_desired_pods

sum by(namespace, deployment) (kube_deployment_spec_replicas{deployment=~"$DEPLOYMENT$", job=~"$JOB$" %FILTERS%})

k8s_workload_running_pods

sum by(namespace, deployment) (kube_deployment_status_replicas_available{deployment=~"$DEPLOYMENT$", job=~"$JOB$" %FILTERS%})

k8s_cluster_cpu

1e3 * sum(kube_node_status_capacity{resource="cpu", job=~"$JOB$" %FILTERS%})

Kubernetes Container

Component metricPrometheus query

container_cpu_used

1e3 * avg by(namespace, container) (rate(container_cpu_usage_seconds_total{container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%}[$DURATION$]))

container_cpu_util

sum by(namespace, container) (rate(container_cpu_usage_seconds_total{container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%}[$DURATION$])) / sum by(namespace, container) (container_spec_cpu_quota{container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%} / container_spec_cpu_period{container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%})

container_cpu_throttle_time

sum by(namespace, container) (rate(container_cpu_cfs_throttled_seconds_total{container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%}[$DURATION$])) * 1e-9

container_memory_used

avg by(namespace, container) (container_memory_usage_bytes{container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%})

container_memory_working_set

sum by(namespace, container) (container_memory_working_set_bytes{container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%})

container_memory_util_nocache

sum by(namespace, container) (container_memory_working_set_bytes{container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%}) / sum by(namespace, container) (container_spec_memory_limit_bytes{container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%})

container_memory_limit_util

sum by(namespace, container) (container_memory_usage_bytes{container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%}) / sum by(namespace, container) (container_spec_memory_limit_bytes{container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%})

container_cpu_request

1e3 * sum by (namespace, container) (kube_pod_container_resource_requests{resource="cpu", container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%})

container_cpu_limit

1e3 * kube_pod_container_resource_limits{resource="cpu", job=~"$JOB$", pod=~"$POD$", container=~"$CONTAINER$" %FILTERS%}

container_memory_request

sum by (namespace, container) (kube_pod_container_resource_requests{resource="memory", container=~"$CONTAINER$", job=~"$JOB$" %FILTERS%})

container_memory_limit

kube_pod_container_resource_limits{resource="memory", job=~"$JOB$", pod=~"$POD$", container=~"$CONTAINER$" %FILTERS%}

cost

sum(kube_pod_container_resource_requests{resource="cpu", pod=~"$POD$", container=~"$CONTAINER$" %FILTERS%})*29 + sum(kube_pod_container_resource_requests{resource="memory", pod=~"$POD$", container=~"$CONTAINER$" %FILTERS%})/1024/1024/1024*8

EC2

Component metricPrometheus query

cpu_util

aws_resource_info{instance='$INSTANCE$', job='$JOB$' %FILTERS%} * on(instance_id) group_left() aws_ec2_cpuutilization_average{job='$JOB$'}/100

network_in_bytes_details

aws_resource_info{instance='$INSTANCE$', job='$JOB$' %FILTERS%} * on(instance_id) group_left() (aws_ec2_network_in_sum{job='$JOB$'} * count_over_time(aws_ec2_network_in_sum{job='$JOB$'}[300s]) / 300)

network_out_bytes_details

aws_resource_info{instance='$INSTANCE$', job='$JOB$' %FILTERS%} * on(instance_id) group_left() (aws_ec2_network_out_sum{job='$JOB$'} * count_over_time(aws_ec2_network_out_sum{job='$JOB$'}[300s]) / 300)

aws_ec2_credits_cpu_available

aws_resource_info{instance='$INSTANCE$', job='$JOB$' %FILTERS%} * on(instance_id) group_left() aws_ec2_cpucredit_balance_average{job='$JOB$'}

aws_ec2_credits_cpu_used

aws_resource_info{instance='$INSTANCE$', job='$JOB$' %FILTERS%} * on(instance_id) group_left() aws_ec2_cpucredit_usage_sum{job='$JOB$'}

disk_read_bytes

aws_resource_info{instance='$INSTANCE$', job='$JOB$' %FILTERS%} * on(instance_id) group_left() (aws_ec2_ebsread_bytes_sum{job='$JOB$'} * count_over_time(aws_ec2_ebsread_bytes_sum{job='$JOB$'}[300s]) / 300)

disk_write_bytes

aws_resource_info{instance='$INSTANCE$', job='$JOB$' %FILTERS%} * on(instance_id) group_left() (aws_ec2_ebswrite_bytes_sum{job='$JOB$'} * count_over_time(aws_ec2_ebswrite_bytes_sum{job='$JOB$'}[300s]) / 300)

aws_ec2_disk_iops

aws_resource_info{instance='$INSTANCE$', job='$JOB$' %FILTERS%} * on(instance_id) group_left() ((aws_ec2_ebsread_ops_sum{job='$JOB$'} + aws_ec2_ebswrite_ops_sum{job='$JOB$'}) * count_over_time(aws_ec2_ebsread_ops_sum{job='$JOB$'}[300s])/300)

aws_ec2_disk_iops_reads

aws_resource_info{instance='$INSTANCE$', job='$JOB$' %FILTERS%} * on(instance_id) group_left() (aws_ec2_ebsread_ops_sum{job='$JOB$'} * count_over_time(aws_ec2_ebsread_ops_sum{job='$JOB$'}[300s]) / 300)

aws_ec2_disk_iops_writes

aws_resource_info{instance='$INSTANCE$', job='$JOB$' %FILTERS%} * on(instance_id) group_left() (aws_ec2_ebswrite_ops_sum{job='$JOB$'} * count_over_time(aws_ec2_ebswrite_ops_sum{job='$JOB$'}[300s]) / 300)

aws_ec2_ebs_credits_io_util

aws_resource_info{instance='$INSTANCE$', job='$JOB$' %FILTERS%} * on(instance_id) group_left() aws_ec2_ebsiobalance__average{job='$JOB$'} / 100

aws_ec2_ebs_credits_bytes_util

aws_resource_info{instance='$INSTANCE$', job='$JOB$' %FILTERS%} * on(instance_id) group_left() aws_ec2_ebsbyte_balance__average{job='$JOB$'} / 100

Oracle Database

Component metricPrometheus query

oracle_sga_total_size

oracledb_memory_size{component='SGA Target', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_sga_free_size

oracledb_memory_size{component='Free SGA Memory Available', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_sga_max_size

oracledb_memory_size{component='Maximum SGA Size', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_pga_target_size

oracledb_memory_size{component='PGA Target', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_redo_buffers_size

oracledb_memory_size{component='Redo Buffers', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_default_buffer_cache_size

oracledb_memory_size{component='DEFAULT buffer cache', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_default_2k_buffer_cache_size

oracledb_memory_size{component='DEFAULT 2K buffer cache', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_default_4k_buffer_cache_size

oracledb_memory_size{component='DEFAULT 4K buffer cache', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_default_8k_buffer_cache_size

oracledb_memory_size{component='DEFULT 8K buffer cache', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_default_16k_buffer_cache_size

oracledb_memory_size{component='DEFAULT 16K buffer cache', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_default_32k_buffer_cache_size

oracledb_memory_size{component='DEFAULT 32K buffer cache', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_keep_buffer_cache_size

oracledb_memory_size{component='KEEP buffer cache', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_recycle_buffer_cache_size

oracledb_memory_size{component='RECYCLE buffer cache', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_asm_buffer_cache_size

oracledb_memory_size{component='ASM Buffer Cache', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_shared_io_pool_size

oracledb_memory_size{component='Shared IO Pool', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_java_pool_size

oracledb_memory_size{component='java pool', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_large_pool_size

oracledb_memory_size{component='large pool', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_shared_pool_size

oracledb_memory_size{component='shared pool', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_streams_pool_size

oracledb_memory_size{component='streams pool', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_sessions_active_user

oracledb_sessions_value{type='USER', status='ACTIVE', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_sessions_inactive_user

oracledb_sessions_value{type='USER', status='INACTIVE', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_sessions_active_background

oracledb_sessions_value{type='BACKGROUND', status='ACTIVE', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_sessions_inactive_background

oracledb_sessions_value{type='BACKGROUND', status='INACTIVE', instance='$INSTANCE$', job='$JOB$' %FILTERS%}

oracle_buffer_cache_hit_ratio

ttps://docs.oracle.com/database/121/TGDBA/tune_buffer_cache.htm#TGDBA533

oracle_redo_log_space_requests

rate(oracledb_activity_redo_log_space_requests{instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])

oracle_wait_event_log_file_sync

rate(oracledb_system_event_time_waited{event='log file sync', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_log_file_parallel_write

rate(oracledb_system_event_time_waited{event='log file sequential read', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_log_file_sequential_read

rate(oracledb_system_event_time_waited{event='log file parallel write', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_enq_tx_contention

rate(oracledb_system_event_time_waited{event='enq: TX - contention', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_enq_tx_row_lock_contention

rate(oracledb_system_event_time_waited{event='enq: TX - row lock contention', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_latch_row_cache_objects

rate(oracledb_system_event_time_waited{event='latch: row cache objects', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_latch_shared_pool

rate(oracledb_system_event_time_waited{event='latch: shared pool', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_resmgr_cpu_quantum

rate(oracledb_system_event_time_waited{event='resmgr:cpu quantum', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_sql_net_message_from_client

rate(oracledb_system_event_time_waited{event='SQL*Net message from client', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_rdbms_ipc_message

rate(oracledb_system_event_time_waited{event='rdbms ipc message', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_db_file_sequential_read

rate(oracledb_system_event_time_waited{event='db file sequential read', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_log_file_switch_checkpoint_incomplete

rate(oracledb_system_event_time_waited{event='log file switch (checkpoint incomplete)', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_row_cache_lock

rate(oracledb_system_event_time_waited{event='row cache lock', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_buffer_busy_waits

rate(oracledb_system_event_time_waited{event='buffer busy waits', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_event_db_file_async_io_submit

rate(oracledb_system_event_time_waited{event='db file async I/O submit', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$])/100

oracle_wait_class_commit

sum without(event) (rate(oracledb_system_event_time_waited{wait_class='Commit', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$]))/100

oracle_wait_class_concurrency

sum without(event) (rate(oracledb_system_event_time_waited{wait_class='Concurrency', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$]))/100

oracle_wait_class_system_io

sum without(event) (rate(oracledb_system_event_time_waited{wait_class='System I/O', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$]))/100

oracle_wait_class_user_io

sum without(event) (rate(oracledb_system_event_time_waited{wait_class='User I/O', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$]))/100

oracle_wait_class_other

sum without(event) (rate(oracledb_system_event_time_waited{wait_class='Other', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$]))/100

oracle_wait_class_scheduler

sum without(event) (rate(oracledb_system_event_time_waited{wait_class='Scheduler', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$]))/100

oracle_wait_class_idle

sum without(event) (rate(oracledb_system_event_time_waited{wait_class='Idle', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$]))/100

oracle_wait_class_application

sum without(event) (rate(oracledb_system_event_time_waited{wait_class='Application', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$]))/100

oracle_wait_class_network

sum without(event) (rate(oracledb_system_event_time_waited{wait_class='Network', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$]))/100

oracle_wait_class_configuration

sum without(event) (rate(oracledb_system_event_time_waited{wait_class='Configuration', instance='$INSTANCE$', job='$JOB$' %FILTERS%}[$DURATION$]))/100

Web Application

Component metricPrometheus query

transactions_response_time

avg(rate(ResponseTime_sum{code="200", job=~"$JOB$" %FILTERS%}[$DURATION$])/rate(ResponseTime_count{code="200", job=~"$JOB$" %FILTERS%}[$DURATION$])>0)

transactions_response_time_max

max(rate(ResponseTime_sum{code="200", job=~"$JOB$" %FILTERS%}[$DURATION$])/rate(ResponseTime_count{code="200", job=~"$JOB$" %FILTERS%}[$DURATION$])>0)

transactions_response_time_min

min(rate(ResponseTime_sum{code="200", job=~"$JOB$" %FILTERS%}[$DURATION$])/rate(ResponseTime_count{code="200", job=~"$JOB$" %FILTERS%}[$DURATION$])>0)

transactions_response_time_p50

ResponseTime{quantile="0.5", code="200", job=~"$JOB$" %FILTERS%}

transactions_response_time_p85

ResponseTime{quantile="0.85", code="200", job=~"$JOB$" %FILTERS%}

transactions_response_time_p90

ResponseTime{quantile="0.9", code="200", job=~"$JOB$" %FILTERS%}

transactions_response_time_p99

ResponseTime{quantile="0.99", code="200", job=~"$JOB$" %FILTERS%}

transactions_throughput

sum(rate(Ratio_success{job=~"$JOB$" %FILTERS%}[$DURATION$]))

transactions_error_throughput

sum(rate(Ratio_failure{job=~"$JOB$" %FILTERS%}[$DURATION$]))

transactions_error_rate

(avg(rate(Ratio_failure{job=~"$JOB$" %FILTERS%}[$DURATION$]))/avg(rate(Ratio_total{job=~"$JOB$" %FILTERS%}[$DURATION$])))*100

users

sum(jmeter_threads{state="active", job=~"$JOB$" %FILTERS%})

Last updated