Chapter 8. Database Monitoring and Performance
In this chapter, we will cover the following recipes:
- Checking active sessions
- Finding out what the users are currently running
- Finding blocked sessions
- Dealing with deadlocks
- Studying table access statistics
- Routine reindexing
- Logging slow statements
- Determining disk usage
- Preventing page corruption
- Generating planner statistics
- Tuning with background writer statistics
Introduction
Monitoring plays a crucial role in defining the server capacity or defining the health of a database server. Monitoring a database server with a certain interval will give us some useful trend information about the server functionality as per the running business. As business grow continuously, the collected trend information will ...
Get PostgreSQL High Performance Cookbook 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.
