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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
