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

Identifying CPU bottlenecks

In this recipe, we are going to use the mpstat command to identify CPU bottlenecks.

How to do it...

The mpstat command is used to report per processor statistics in a tabular format.

We are now going to show the usage of the mpstat command:

bash-3.2$ mpstat 1 1 
 
CPU minf mjf xcal  intr ithr  csw icsw migr smtx  srw syscl  usr sys  wt idl 
  0  672   0 2457   681   12  539   17   57  119    0  4303   18  10   0  73 
  1   90   0 1551   368   22  344    6   37  104    0  3775   17   4   0  79 
  2   68   0 1026   274   14  217    4   24   83    0  2393   11   3   0  86 
  3   50   0  568   218    9  128    3   17   56    0  1319    7   2   0  92 
  4   27   0  907   340   12  233    3   22   72    0  2034    9   2   0  88 
  5   75   0 1777   426   25  370    5   33  111    0  4820   22   4   0  74   

How it works...

In the preceding output of the mpstat command, each row of the table represents the activity ...

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