O'Reilly logo

Troubleshooting PostgreSQL by Hans-Jürgen Schönig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Checking the overall database behavior

The first thing to do when approaching a system is to check the overall health and see what is currently going on in the system. Is the system ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required