# system_stats

主页：[https://github.com/EnterpriseDB/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](https://pg_top.gitlab.io)

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

![pg_top screenshot](../../../../../ff_internal_upload/img/2022/pg_top-2.png)

# pg_systat

主页：[https://pg_systat.gitlab.io](https://pg_systat.gitlab.io)

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

![pg_systat screenshot](../../../../../ff_internal_upload/img/2022/pg_systat-dbxact.png)

# pg_proctab

主页：[https://pg_proctab.gitlab.io/](https://pg_proctab.gitlab.io)

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

![pg_proctab](../../../../../ff_internal_upload/img/2022/pg_proctab.png)