Deep dive into PostgreSQL statistics.
Slides from Highload++ 2015 (Moscow, Russia).
PostgreSQL is a huge system which consists of many subsystems, whose work determines the performance of PostgreSQL. During lifetime, postgres ensures the statistics tracking of the components, which allows to evaluate the effectiveness of PostgreSQL and to take action to improve performance. However, most of this information is presented in a rather simplified way. Processing this information and its interpretation is often quite trivial task, and the numerous tools and utilities easily confound even the advanced DBA.
The report will discuss the statistics collector and which information is available to assess the effectiveness of PostgreSQL, how to get it without resorting the numerous tools. How to interpret and use the information, how to find bottlenecks, eliminate them and improve the performance of PostgreSQL.