Different results from Prometheus and New Relic
I’m having some trouble translating a simple promql query into nrql. I am using the postgres-exporter to pull data out my postgres instance running in RDS, and I write to New Relic via the prometheus remote write integration.
Anyway, when I try to query the data via NRQL I get way different results from when I try to run queries in prometheus. For example, something simple as
rate(pg_stat_database_tup_fetched{datname="buzz"}[1m])
which gets translated in NRQL as
SELECT rate(sum(pg_stat_database_tup_fetched), 1 SECONDS) FROM Metric WHERE (datname = 'buzz') SINCE 60 MINUTES AGO UNTIL NOW FACET dimensions() LIMIT 100 TIMESERIES 60000 SLIDE BY 30000
I’ve attached some screenshots to show you why I am a bit confused.