Chapter 7. Monitoring PostgreSQL

In the final chapter of this book, you will learn about monitoring PostgreSQL. The goal is to give you all the tools and means to check your databases in an efficient, reliable, and easy way.

The following topics will be covered in this chapter:

  • Understanding the system statistics of PostgreSQL
  • Producing monitoring data for Nagios
  • Using Linux cgroups

Understanding the system statistics of PostgreSQL

There are several system tables and system views to check out PostgreSQL statistics. In this chapter, the most important system views will be covered and discussed. Unfortunately, there is not enough room to cover all those views in detail. However, the most important ones are here.

Tip

More information about those system tables ...

Get PostgreSQL Administration Essentials now with O’Reilly online learning.

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