Database Reference
In-Depth Information
8
Monitoring and
Diagnosis
In this chapter, we will cover the following:
F
Is the user connected?
F
What are they running?
F
Are they active or blocked?
F
Who is blocking them?
F
Killing a specific session
F
Resolving an in-doubt prepared transaction
F
Is anybody using a specific table?
F
When did anybody last use it?
F
How much disk space is used by temporary data?
F
Why are my queries slowing down?
F
Investigating and reporting a bug
F
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.
