PostgreSQL 10 Administration Cookbook - Fourth Edition

How to do it… (with OmniDB)

Here's another section that illustrates the OmniDB tool:

After starting OmniDB and opening a database, a tab called Monitoring is automatically displayed, as in the following screenshot:

The Monitoring tab shows a series of charts and diagrams about sessions, locks, activity, database size, and table size.

The display can be customized by adding/removing charts from a list of predefined templates, or by creating a bespoke chart, by modifying the data script and/or the chart script.

The easiest way to add a new type of chart is to take an existing one, understanding first what information it displays, and then using ...