View and query your Prometheus data

To query and visualize the metrics collected for your Prometheus OpenMetrics or remote write integration with New Relic, you can use NRQL. You can also translate your PromQL-style queries to NRQL using either Grafana or the query builder.

All metrics for Docker and Kubernetes are stored in the Metric type.

Default attributes for the OpenMetrics integration

By default, the following attributes will be added to all metrics for Docker and Kubernetes integrations:

Kubernetes: If the scraper is running in Kubernetes, New Relic also adds the following attributes to all the metrics:

Default attributes for the remote write integration

By default, the following attributes will be added to Prometheus remote write metrics:

NRQL query examples

When you build queries, be aware that there is no linking between the metrics, entities, and attributes. Use the following NRQL queries to find out which metrics are available and which attributes are present on these metrics:

FROM Metric SELECT uniques(metricName)

FROM Metric SELECT uniques(metricName) WHERE instrumentation.provider='prometheus' 
AND instrumentation.name='remote-write'

FROM Metric SELECT uniques(metricName) WHERE instrumentation.provider='prometheus' 
AND instrumentation.name='remote-write' AND instrumentation.source='<ds>'

FROM Metric SELECT uniques(metricName) WHERE scrapedEndpoint='<ep>'

FROM Metric SELECT uniques(metricName) WHERE clusterName='<cn>'

FROM Metric SELECT uniques(metricName) WHERE namespaceName='<ns>'

FROM Metric SELECT uniques(metricName) WHERE podName='<pod>'

FROM Metric SELECT keyset() WHERE metricName='<mn>'

FROM Metric SELECT uniques(<attribute>) WHERE metricName='<mn>' AND podName='<pod>'

For more information about facets, time series, and time selection, see the NRQL documentation.

Build the query

To build PromQL-style queries, see our documentation about supported PromQL features.

FROM Metric SELECT <metricName> WHERE <attribute>='<value>'

FROM Metric SELECT <aggregator>(<metricname>) WHERE <attribute>='<value>' TIMESERIES

FROM Metric SELECT latest(redis_connected_clients) WHERE clusterName='my-cluster' 
FACET scrapedEndpoint TIMESERIES

FROM Metric SELECT latest(redis_connected_clients) WHERE namespaceName='default' FACET podName TIMESERIES

FROM Metric SELECT average(node_memory_MemFree_bytes) WHERE clusterName='my-cluster'

FROM Metric SELECT average(container_memory_usage_bytes) 
WHERE deploymentName='my-app-deployment' AND namespaceName='default'

View data in New Relic

When you query the data, you can view the results in the New Relic UI. You can also visualize the data as charts, histograms, etc.

To view the NRQL query results for your Prometheus integration's data:

1. In New Relic, expand the query builder by clicking the bar at the bottom.
2. Open the query builder menu by clicking the three dots next to the Copy your query link action, and then select PromQL.
3. In the translator, enter your PromQL query. It's auto-translated into an NRQL query.
4. Click Submit.

For more information, see our query builder documentation.

Generate histograms and calculate percentiles

Using Prometheus remote write or version 2.0.0 and higher of the Prometheus OpenMetrics Integration (POMI), you can generate histograms and calculate percentiles from your data. For Prometheus histograms, a bucket <basename>_bucket{le="42"} will be sent as the metric <basename>_bucket, and the dimension will be {histogram.bucket.le="42"}.

NRQL has two functions that work on Prometheus histograms ingested via remote write or the Prometheus OpenMetrics Integration (starting with version 2.0.0): bucketPercentile(), and histogram(). The links include query examples.