Querying Metric Data

Before You Begin

IAM policies: To query metrics, you must be given the required type of access in a policy  written by an administrator. This requirement applies whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you get a message that you don’t have permission or are unauthorized, check with the administrator. You might not have the required type of access in the current compartment .

Administrators: For an example policy, see Query Metrics.

Example Query and Metric Chart

The query in this example uses the following MQL expression:


This query returns aggregated mean() (statistic) values of emitted metric data for the metric named CpuUtilization every minute (from the 1m interval).

For more information about the CpuUtilization metric, see Compute Instance Metrics.

Following are example metric charts in both graph and table data view.

Graph View Example of Metric Chart

The following image shows several metric streams in the graph view of a metric chart. Each metric stream corresponds to a compute instance.

The 85% value at 1:30 indicates that a compute instance used 85% of its CPU (averaged over the specified interval). Absent values are indicated for a metric stream toward the bottom of the graph, indicating that a compute instance didn't emit metric data until 1:30.

Metric streams and values in a graph.

Very small or large values are indicated by International System of Units (SI units), such as M for mega (10 to the sixth power). Units correspond to the selected metric and don’t change by statistic .

Data Table Example of Metric Chart

The following abbreviated example lists the values of the myinstance metric stream at the 1:30 timestamp and immediately before and after.

Timestamp Percent
Oct 1, 2022, 01:29:00 UTC 81.158842305151567
Oct 1, 2022, 01:30:00 UTC 85.689932345683178
Oct 1, 2022, 01:31:00 UTC 79.925088231917334

For instructions on switching a custom metric chart to a data table or graph view, see Switching Table and Graph Views for a Custom Metric Chart.

For more information about metric charts (graphs and tables) in the Console, see Viewing Default Metric Charts and Viewing a Custom Metric Chart. For more information about queries, see Querying Metric Data.