How to make a filter to display values ​​above 0 in promtheus with irate wrapper?

Question

Monitoring

Here is the formula:

rate(pg_stat_database_xact_commit{instance="$instance"}[5m])

Here is the chart.

It can be seen that quite a lot of values ​​\u200b\u200bare equal to 0.

Answer 1

rate(pg_stat_database_xact_commit{instance="$instance"}[5m]) > 0