Gathering runtime statistics

The first thing you really have to learn about is understanding what PostgreSQL's on-board statistics have got to offer and using them. In my personal opinion, there is no way to improve performance and reliability without first collecting the necessary data to make prudent decisions.

This section will guide you through PostgreSQL's runtime statistics and explain in detail how you can extract more runtime information from your database setups.

Working with PostgreSQL system views

PostgreSQL offers a large set of system views that allow administrators and developers alike to take a deep look into what is really going on in their system. The trouble is that many people actually collect...