12
Troubleshooting PostgreSQL
In Chapter 11, Deciding on Useful Extensions, we learned about some useful extensions that are widely adopted and that can give your deployment a real boost. By way of a follow-up, you will now be introduced to PostgreSQL troubleshooting. The idea is to give you a systematic approach to inspecting and fixing your system to improve its performance and avoid common pitfalls. Having a systematic approach definitely pays off. Many users face similar issues, so it makes sense to take a look at the most common problems haunting people all over the world.
In this chapter, the following topics will be covered:
- Approaching an unknown database
- Inspecting pg_stat_activity
- Checking for slow queries
- Inspecting the log
- Checking ...
Get Mastering PostgreSQL 15 - Fifth Edition 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.
