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 ...

Get PostgreSQL High Performance Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.