system_stats
概述
system_stats 提供了数据库服务器 CPU、内存、磁盘和网络相关的统计指标，可以用于替代操作系统级别的监控。
验证安装
testdb=# create extension system_stats;
CREATE EXTENSION
函数及用法示例
ud_sys_os_info() 函数
ud_sys_os_info() 函数可以用于获取操作系统相关的信息。例如：
testdb=# \x
Expanded display is on.
testdb=# select * from ud_sys_os_info();
-[ RECORD 1 ]-------+--------------------------
name | "Ubuntu 20.04.6 LTS" +
|
version | Linux 5.15.0-79-generic
host_name | virtual-machine
domain_name | (none)
handle_count | 7520
process_count | 301
thread_count | 521
architecture | x86_64
last_bootup_time |
os_up_since_seconds | 4963
ud_sys_cpu_info() 函数
ud_sys_cpu_info() 函数用于获取 CPU 相关的信息。例如：
testdb=# select * from ud_sys_cpu_info();
-[ RECORD 1 ]------+--------------------------------------
vendor | GenuineIntel
description | GenuineIntel model 183 family 6
model_name | 13th Gen Intel(R) Core(TM) i9-13900HX
processor_type |
logical_processor | 0
physical_processor | 4
no_of_cores | 2
architecture | x86_64
clock_speed_hz | 2419107840
cpu_type |
cpu_family |
byte_order |
l1dcache_size | 48
l1icache_size | 32
l2cache_size | 2048
l3cache_size | 36864
ud_sys_cpu_usage_info() 函数
ud_sys_cpu_usage_info() 函数用于获取 CPU 使用信息，按照 CPU 占用时间百分比显示。例如：
testdb=# select * from ud_sys_cpu_usage_info();
-[ RECORD 1 ]-------------------+-----
usermode_normal_process_percent | 6.67
usermode_niced_process_percent | 0
kernelmode_process_percent | 1.67
idle_mode_percent | 90
io_completion_percent | 0
servicing_irq_percent | 0
servicing_softirq_percent | 1.67
user_time_percent |
processor_time_percent |
privileged_time_percent |
interrupt_time_percent |
ud_sys_memory_info() 函数
ud_sys_memory_info() 函数用于获取内存使用信息，单位为字节。例如：
testdb=# select * from ud_sys_memory_info();
-[ RECORD 1 ]----+-----------
total_memory | 4064788480
used_memory | 2357620736
free_memory | 1707167744
swap_total | 968105984
swap_used | 0
swap_free | 968105984
cache_total | 1122975744
kernel_total |
kernel_paged |
kernel_non_paged |
total_page_file |
avail_page_file |
ud_sys_io_analysis_info() 函数
ud_sys_io_analysis_info() 函数用于获取块设备的 I/O 性能分析。例如：
testdb=# select * from ud_sys_io_analysis_info();
-[ RECORD 1 ]-+----------
device_name | sdb
total_reads | 4673
total_writes | 11215
read_bytes | 593527808
write_bytes | 258909184
read_time_ms | 110966
write_time_ms | 368935
-[ RECORD 2 ]-+-----------
device_name | sdb1
total_reads | 4642
total_writes | 5556
read_bytes | 591815680
write_bytes | 258909184
read_time_ms | 110804
write_time_ms | 314021
-[ RECORD 3 ]-+-----------
device_name | sda
total_reads | 18147
total_writes | 21426
read_bytes | 1220719104
write_bytes | 712343040
read_time_ms | 378269
write_time_ms | 1152711
ud_sys_disk_info() 函数
ud_sys_disk_info() 函数用于获取磁盘信息。例如：
testdb=# select * from ud_sys_disk_info();
LOCATION: ReadDiskInformation, disk_info.c:146
-[ RECORD 1 ]----+------------
mount_point | /
file_system | /dev/sda5
drive_letter |
drive_type |
file_system_type | ext4
total_space | 20425850880
used_space | 12119777280
free_space | 7242555392
total_inodes | 1277952
used_inodes | 247978
free_inodes | 1029974
-[ RECORD 2 ]----+------------
mount_point | /boot/efi
file_system | /dev/sda1
drive_letter |
drive_type |
file_system_type | vfat
total_space | 535805952
used_space | 4096
free_space | 535801856
total_inodes | 0
used_inodes | 0
free_inodes | 0
ud_sys_load_avg_info() 函数
ud_sys_load_avg_info() 函数用于获取系统在 1、5、10 和 15 分钟内的平均负载。例如：
testdb=# select * from ud_sys_load_avg_info();
-[ RECORD 1 ]------------+-----
load_avg_one_minute | 0.16
load_avg_five_minutes | 0.08
load_avg_ten_minutes | 0.06
load_avg_fifteen_minutes |
ud_sys_process_info() 函数
ud_sys_process_info() 函数用于获取进程数量信息。例如：
testdb=# select * from ud_sys_process_info();
-[ RECORD 1 ]------+----
total_processes | 301
running_processes | 4
sleeping_processes | 216
stopped_processes | 0
zombie_processes | 0
ud_sys_network_info() 函数
ud_sys_network_info() 函数用于获取网络接口信息。例如：
testdb=# select * from ud_sys_network_info();
-[ RECORD 1 ]---+----------------
interface_name | lo
ip_address | 127.0.0.1
tx_bytes | 843402
tx_packets | 4565
tx_errors | 0
tx_dropped | 0
rx_bytes | 843402
rx_packets | 4565
rx_errors | 0
rx_dropped | 0
link_speed_mbps | 0
-[ RECORD 2 ]---+----------------
interface_name | ens33
ip_address | 192.168.109.128
tx_bytes | 51167
tx_packets | 555
tx_errors | 0
tx_dropped | 0
rx_bytes | 494722
rx_packets | 1698
rx_errors | 0
rx_dropped | 0
link_speed_mbps | 1000
ud_sys_cpu_memory_by_process() 函数
ud_sys_cpu_memory_by_process() 函数用于获取每个进程的 CPU 和内存使用信息，例如：
testdb=# select * from ud_sys_cpu_memory_by_process();
-[ RECORD 1 ]---------+--------------------------------
pid | 1
name | (systemd)
running_since_seconds | 6011
cpu_usage | 0
memory_usage | 0.29
memory_bytes | 11624448
-[ RECORD 2 ]---------+--------------------------------
pid | 2
name | (kthreadd)
running_since_seconds | 6011
cpu_usage | 0
memory_usage | 0
memory_bytes | 0
-[ RECORD 3 ]---------+--------------------------------
pid | 3
name | (rcu_gp)
running_since_seconds | 6011
cpu_usage | 0
memory_usage | 0
memory_bytes | 0
...