O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

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 8. Monitoring and Diagnosis

In this chapter, we will cover the following:

  • Is the user connected?
  • What are they running?
  • Are they active or blocked?
  • Who is blocking them?
  • Killing a specific session
  • Resolving an in-doubt prepared transaction
  • Is anybody using a specific table?
  • When did anybody last use it?
  • How much disk space is used by temporary data?
  • Why are my queries slowing down?
  • Investigating and reporting a bug
  • Producing a daily summary of logfile errors

Introduction

In this chapter, you find recipes for some common monitoring and diagnosis actions you want to do inside your database. They are meant to answer specific questions that you often face when using PostgreSQL.

Monitoring is important

Databases are not isolated entities. They live on computer ...

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