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 4. Monitoring Server Performance

In this chapter, we will cover the following:

  • Monitoring CPU usage
  • Monitoring paging and swapping
  • Tracking CPU consuming processes
  • Monitoring CPU load
  • Identifying CPU bottlenecks
  • Identifying disk I/O bottlenecks
  • Monitoring system load
  • Tracking historical CPU usage
  • Tracking historical memory usage
  • Monitoring disk space
  • Monitoring network status

Introduction

In order to be able to solve performance problems we should be able to effectively use operating system utilities. We should be able to use the right operating system tools and commands in order to identify performance problems that may be due to CPU, memory, or disk I/O issues. Many times a DBA's duties often overlap with certain system administration-related functions ...

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