PGCon2017 - 20180510

PGCon 2017
The PostgreSQL Conference

Alexey Lesovsky
Day Talks - Day 2 - 2017-05-26
Room DMS 1160
Start time 14:00
Duration 00:45
ID 1102
Event type Lecture
Track DBA
Language used for presentation English

Troubleshooting PostgreSQL with pgCenter

Finding and eliminating performance issues with pgCenter

Talk about pgcenter utility - what is it, how to use it, how to find problems related with postgresql performance.

It's well known that PostgreSQL has rich activity statistics that allow better understanding of its internal processes. In particular, they help tracking changes and detecting and predicting problems. At the same time, statistics also have weaknesses, such as lack of built-in tools for working with statistics. PostgreSQL community, however, offers variety of tools that have multitude of features that help to address this. In my talk I will present pgCenter – a tool that I developed to address exactly that. It provides convenient interface for working with PostgreSQL statistics and an easy way for standard admin tasks, such as, dealing with configuration and logs. I will also talk through PostgreSQL troubleshooting with help of pgCenter and will consider different cases, such as current activity, replication issues, problematic queries and many others. My talk would primarily be of benefit to DBAs, system administrators and developers who actively work with postgreSQL.