opengauss基础 gs_checkperf 数据库性能监控

Server：CentOS Linux release 7.6.1810 (Core) （3.10.0-957.el7.x86_64）
openGauss：2.0.0 企业版 centos_x86_64
DataStudio：2.0.0 windows_x86_64

查看数据库的性能

[omm@node1 ~]$ gs_checkperf
Cluster statistics information:
    Host CPU busy time ratio                     :    .31        %
    MPPDB CPU time % in busy time                :    100.00     %
    Shared Buffer Hit ratio                      :    98.48      %
    In-memory sort ratio                         :    0
    Physical Reads                               :    382
    Physical Writes                              :    84
    DB size                                      :    42         MB
    Total Physical writes                        :    84
    Active SQL count                             :    4
    Session count                                :    6

[omm@node1 ~]$ gs_checkperf --help

gs_checkperf is a utility to check the cluster performance and SSD performance.

Usage:
  gs_checkperf -? | --help
  gs_checkperf -V | --version
  gs_checkperf [-U USER] [-o OUTPUT] [-i ITEM] [--detail] [-l LOGFILE]

General options:
  -U                                Cluster user.
  -o                                Save the result to the specified file.
  -i                                PMK or SSD performance check items.
                                    Example: -i PMK -i SSD.
  --detail                          Show detailed information about the PMK check.
  -l                                Path of log files.
  -?, --help                        Show help information for this utility,
                                    and exit the command line mode.
  -V, --version                     Show version information. 
        

相关链接

• openGauss
• openGauss-Gitee
• CentOS
• 墨天轮社区

欢迎各位同学一起来交流学习心得！