Some graphs should be rates?

[larsks]

It looks like some queries in your dashboard should be using rate(). For example, the "Fetch data (SELECT)" chart uses:

pg_stat_database_tup_fetched{datname=~"$datname", instance=~"$instance"}

But pg_state_database_tup_fetched is a counter, and is generally charted via rate():

rate(pg_stat_database_tup_fetched{datname=~"$datname", instance=~"$instance"}[5m])

It looks like the "Insert data", "Update data", and "Return data" charts (at least) have the same issue.

[DaveOHenry]

The "Cache Hit Rate" panel has the same issue:

pg_stat_database_blks_hit{instance="$instance", datname=~"$datname"} / (pg_stat_database_blks_read{instance="$instance", datname=~"$datname"} + pg_stat_database_blks_hit{instance="$instance", datname=~"$datname"})

[spuyet]

Yeah definitely, multiple graph do not use the right queries/units.