Table: newrelic_apm_application_metric_data - Query New Relic APM Application Metric Data using SQL

New Relic APM (Application Performance Monitoring) is a service that provides real-time monitoring and detailed performance analytics for your applications. It allows you to track transactions, errors, and other key metrics, enabling you to identify and diagnose performance issues quickly. With New Relic APM, you can gain a deep understanding of how your applications are performing in production, and where they can be optimized.

Table Usage Guide

The newrelic_apm_application_metric_data table provides insights into application performance metrics within New Relic's Application Performance Monitoring (APM). As a DevOps engineer or application developer, explore application-specific details through this table, including transaction times, error rates, and other key performance indicators. Utilize it to uncover information about application performance, such as slow transactions, high error rates, and other potential areas of improvement.

Important Notes

You must specify the app_id in the where clause to query this table.
Columns From and To must be double-quoted when used explicitly in the select or where clauses.

Examples

List metrics for an application after a certain date

Explore the performance metrics of a specific application for the past year. This is useful in identifying trends or issues that have arisen over time, helping to inform future development and troubleshooting efforts.

select
  name,
values
from
  newrelic_apm_application_metric_data
where
  app_id = 45
  and "from" >= (now() - interval '1 YEAR') :: date;

select
  name,
values
from
  newrelic_apm_application_metric_data
where
  app_id = 45
  and "from" >= date('now', '-1 year');

Schema for newrelic_apm_application_metric_data

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
app_id	bigint	=	Unique identifier of the application the metrics belong to.
from	timestamp with time zone	=	Timestamp of beginning of the metrics.
name	text	=	Name of the metric.
profile_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier of the current user.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
to	timestamp with time zone	=	Timestamp of ending of the metrics.
values	jsonb		The actual metric data.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- newrelic

You can pass the configuration to the command with the --config argument:

steampipe_export_newrelic --config '<your_config>' newrelic_apm_application_metric_data