Packt+ | Advance your knowledge in tech

You're reading from PostgreSQL High Performance Cookbook Mastering query optimization, database monitoring, and performance-tuning for PostgreSQL

Product type Paperback

Published in Mar 2017

Publisher Packt

ISBN-13 9781785284335

Length 360 pages

Edition 1st Edition

Languages

SQL

Tools

PostgreSQL

Concepts

High Performance Programming

Authors (2):

Chauhan

Dinesh Kumar

View More author details

Table of Contents (13) Chapters

Preface

1. Database Benchmarking FREE CHAPTER

2. Server Configuration and Control

3. Device Optimization

4. Monitoring Server Performance

5. Connection Pooling and Database Partitioning

6. High Availability and Replication

7. Working with Third-Party Replication Management Utilities

8. Database Monitoring and Performance

9. Vacuum Internals

10. Data Migration from Other Databases to PostgreSQL and Upgrading the PostgreSQL Cluster

11. Query Optimization

12. Database Indexing

Monitoring CPU load

In this recipe, we are going to use the uptime command to monitor overall CPU load.

How to do it...

The uptime command tells us the following information:

Current system time
How long the system has been running
Number of currently logged on users in the system
System load average for the past 1, 5, and 15 minutes

The uptime command can be used as follows:

 bash-3.2$ uptime 
 11:44pm  up 20 day(s), 20 hr(s),  10 users,  load average: 27.80, 30.46, 33.77

Here in the preceding output we can see the current system time, 11.44pm GMT, and the system has been up and running for the last 20 days and 20 hrs without requiring a reboot. The output also tells us there are around 10 concurrently logged on users in the system. Finally, we also get the load average during the past 1, 5, and 15 minutes as 27.80, 30.46, and 33.77 respectively.