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.
More information about those system tables ...