How it works...

To explain how to customize a graph within Grafana, we should probably start by creating a new panel to contain it. Once we've logged into the interface, we must first navigate to the PostgreSQL Cluster dashboard we want to modify, and then add a new panel using the context menu at the top of the screen. As in the last recipe, this will create a New Panel where we can start the process by using Add Query.

The fun starts after we change Select measurement to postgresql and change the field to xact_commit as now we can start adding transformations. The first thing we do is add a derivative transformation. Why must we do this? We do so because many PostgreSQL catalog statistics consist of monotonically increasing values. The ...

Get PostgreSQL 12 High Availability Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.