system_stats

主页:https://github.com/EnterpriseDB/system_stats

简介:一个PostgreSQL扩展,提供一系列函数用于查询操作系统统计信息:

pg_sys_os_info:
This interface allows the user to get operating system statistics.

pg_sys_cpu_info:
This interface allows the user to get CPU information.

pg_sys_cpu_usage_info:
This interface allows the user to get CPU usage information. Values are a percentage of time spent by CPUs for all operations.

pg_sys_memory_info:
This interface allows the user to get memory usage information. All the values are in bytes.

pg_sys_io_analysis_info:
This interface allows the user to get an I/O analysis of block devices.

pg_sys_disk_info:
This interface allows the user to get the disk information.

pg_sys_load_avg_info:
This interface allows the user to get the average load of the system over 1, 5, 10 and 15 minute intervals.

pg_sys_process_info:
This interface allows the user to get process information.

pg_sys_network_info:
This interface allows the user to get network interface information.

pg_sys_cpu_memory_by_process:
This interface allows the user to get the CPU and memory information for each process ID.

pg_top

主页:https://pg_top.gitlab.io

简介:类似于Unix top的工具,可以监控PostgreSQL的进程状态。

pg_top screenshot

pg_systat

主页:https://pg_systat.gitlab.io

简介:PostgreSQL统计信息显示工具。

pg_systat screenshot

pg_proctab

主页:https://pg_proctab.gitlab.io/

简介:用于查询系统进程表的PostgreSQL扩展工具。

pg_proctab