Chapter 7. PostgreSQL Monitoring
Troubleshooting is virtually impossible if you don't have the information you need to actually track down a problem. For carrying out troubleshooting, data is everything. Without data and without the ability to see what is going on, the situation is practically hopeless.
In this chapter, you will be guided through the following topics:
- Checking the overall database behavior
- Checking for conflicts
- Finding I/O bottlenecks
- Inspecting system internals
- Chasing down slow queries
- External tools
Those topics will help you keep an eye on your system.