title

text

Алексей Лесовский
Алексей Лесовский PostgreSQL Consulting LLC
15:45 06 February
45 min

Troubleshooting in Postgres with pgCenter

Sometimes problems arise during Postgres operation, and the faster they are identified and resolved, the happier users eventually will be. pgCenter is a set of CLI powerful utilities for troubleshooting in the "here and now" mode. In the talk I will show how to use pgCenter for efficient troubleshooting, the directions in which to search, and how to respond to certain problems, in particular how to:

  • check if Postgres is in the normal state;
  • identify promptly the faulty clients and stop them;
  • reveal too heavy queries;
  • and other tips and tricks of pgCenter.

Slides

Video

Other talks