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 performance and avoid common pitfalls. Having a systematic approach definitely pays off.

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 for missing indexes
  • Checking for memory and I/O
  • Understanding noteworthy error scenarios

Keep in mind that many things can go wrong, ...

Get Mastering PostgreSQL 13 - Fourth 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.