O'Reilly logo

PostgreSQL High Performance Cookbook by Dinesh Kumar, Chitij Chauhan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8. Database Monitoring and Performance

In this chapter, we will cover the following recipes:

  • Checking active sessions
  • Finding out what the users are currently running
  • Finding blocked sessions
  • Dealing with deadlocks
  • Studying table access statistics
  • Routine reindexing
  • Logging slow statements
  • Determining disk usage
  • Preventing page corruption
  • Generating planner statistics
  • Tuning with background writer statistics

Introduction

Monitoring plays a crucial role in defining the server capacity or defining the health of a database server. Monitoring a database server with a certain interval will give us some useful trend information about the server functionality as per the running business. As business grow continuously, the collected trend information will ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required