PostgreSQL 12 High Availability Cookbook - Third Edition

How it works...

Assuming we've applied the previous recipes, much of this is the same procedure as they outlined. Log in to the interface, choose our favorite PostgreSQL Cluster dashboard, and select Add panel.

What's new here is how we write the query. Unlike previous recipes, after we use Select measurement to pick postgresql.slot_lag as our measurement and set the field to restart_lsn_lag, we skip the step of adding a column alias. As it turns out, we won't be needing it.

Instead, we move to the GROUP BY line and make sure to group by the tag we created when initially configuring Telegraf: slot_name. We also want to leave FORMAT AS alone because, this time around, we want to view the data as a time series.

So, how do we make the graph ...