Troubleshooting PostgreSQL with pgCenter

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.