#openGauss #入门 #安装 #数据库 #开源
知识来源：docs-opengauss.osinfra.cn/zh/
示例二：以详细格式在屏幕上显示性能统计结果。
gs_checkperf -i pmk -U omm --detail
Cluster statistics information:
Host CPU usage rate:
Host total CPU time : 42386.667 Jiffies
Host CPU busy time : 1873.333 Jiffies
Host CPU iowait time : 20.000 Jiffies
Host CPU busy time ratio : 4.42 %
Host CPU iowait time ratio : .05 %
MPPDB CPU usage rate:
MPPDB CPU time % in busy time : 19.04 %
MPPDB CPU time % in total time : .84 %
Shared buffer hit rate:
Shared Buffer Reads : 0
Shared Buffer Hits : 24129
Shared Buffer Hit ratio : 100.00 %
In-memory sort ratio : 100.00 %
I/O usage:
Number of files : 537
Physical Reads : 0
Physical Writes : 0
Read Time : 0 ms
Write Time : 0 ms
Disk usage:
DB size : 70 MB
Total Physical writes : 0
Average Physical write : 0
Maximum Physical write : 0
Activity statistics:
Active SQL count : 2
Session count : 3
Node statistics information:
dn_6001_6002:
MPPDB CPU Time : 200 Jiffies
Host CPU Busy Time : 3490 Jiffies
Host CPU Total Time : 42330 Jiffies
MPPDB CPU Time % in Busy Time : 5.73 %
MPPDB CPU Time % in Total Time : .47 %
Physical memory : 8231776256 Bytes
DB Memory usage : 877236224 Bytes
Shared buffer size : 33554432 Bytes
Shared buffer hit ratio : 100.00 %
Sorts in memory : 123
Sorts in disk : 0
In-memory sort ratio : 100.00 %
Number of files : 149
Physical Reads : 0
Physical Writes : 0
Read Time : 0
Write Time : 0
dn_6003_6004:
MPPDB CPU Time : 170
Jiffies Host CPU Busy Time : 1030 Jiffies
Host CPU Total Time : 42470 Jiffies
MPPDB CPU Time % in Busy Time : 16.50 %
MPPDB CPU Time % in Total Time : .40 %
Physical memory : 8231776256 Bytes
DB Memory usage : 881434624 Bytes
Shared buffer size : 33554432 Bytes
Shared buffer hit ratio : 100.00 %
Sorts in memory : 119
Sorts in disk : 0
In-memory sort ratio : 100.00 %
Number of files : 165
Physical Reads : 0
Physical Writes : 0
Read Time : 0
Write Time : 0
dn_6005_6006:
MPPDB CPU Time : 220 Jiffies
Host CPU Busy Time : 1100 Jiffies
Host CPU Total Time : 42360 Jiffies
MPPDB CPU Time % in Busy Time : 20.00 %
MPPDB CPU Time % in Total Time : .52 %
Physical memory : 8231776256 Bytes
DB Memory usage : 881430528 Bytes
Shared buffer size : 33554432 Bytes
Shared buffer hit ratio : 100.00 %
Sorts in memory : 122
Sorts in disk : 0
In-memory sort ratio : 100.00 %
Number of files : 115
Physical Reads : 0
Physical Writes : 0
Read Time : 0
Write Time : 0
Session statistics information(Top 10):
Session CPU statistics:
1 dn_6003_6004-postgres-dbazt:
Session CPU time : 1211
Database CPU time : 37670
Session CPU time % : 3.21 %
2 dn_6005_6006-postgres-dbazt:
Session CPU time : 1204
Database CPU time : 35730
Session CPU time % : 3.37 %
3 dn_6001_6002-postgres-dbazt:
Session CPU time : 1064
Database CPU time : 34120
Session CPU time % : 3.12 %
Session Memory statistics:
1 dn_6005_6006-postgres-dbazt:
Buffer Reads : 8989
Shared Buffer Hit ratio : 96.97
In Memory sorts : 136
In Disk sorts : 0
In Memory sorts ratio : 100.00
Total Memory Size : 21593048
Used Memory Size : 18496600
2 dn_6003_6004-postgres-dbazt:
Buffer Reads : 9030
Shared Buffer Hit ratio : 96.94
In Memory sorts : 133
In Disk sorts : 0
In Memory sorts ratio : 100.00
Total Memory Size : 21576664
Used Memory Size : 18495688
3 dn_6001_6002-postgres-dbazt:
Buffer Reads : 8668
Shared Buffer Hit ratio : 96.97
In Memory sorts : 138
In Disk sorts : 0
In Memory sorts ratio : 100.00
Total Memory Size : 21258856
Used Memory Size : 18159736
Session IO statistics:
1 dn_6003_6004-postgres-dbazt:
Physical Reads : 285
Read Time : 5320
2 dn_6005_6006-postgres-dbazt:
Physical Reads : 281
Read Time : 5811
3 dn_6001_6002-postgres-dbazt:
Physical Reads : 271
Read Time : 4662
#openGauss #入门 #安装 #数据库 #开源
