Provides table functions to access system-level statistics for monitoring purpose
Maintainer(s):
dentiny
Installing and Loading
INSTALL system_stats FROM community;
LOAD system_stats;
Example
-- Get memory information
SELECT * FROM sys_memory_info();
-- Get CPU information
SELECT * FROM sys_cpu_info();
-- Get disk information
SELECT * FROM sys_disk_info();
-- Get network information
SELECT * FROM sys_network_info();
-- Get OS information
SELECT * FROM sys_os_info();
About system_stats
The system_stats extension provides table functions to access system-level statistics (including memory, CPU, and disk) that can be used for monitoring.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| sys_cpu_info | table | NULL | NULL | |
| sys_disk_info | table | NULL | NULL | |
| sys_memory_info | table | NULL | NULL | |
| sys_network_info | table | NULL | NULL | |
| sys_os_info | table | NULL | NULL |
Overloaded Functions
| function_name | function_type | description | comment | examples | |—————|—————|————-|———|———-|
Added Types
| type_name | type_size | logical_type | type_category | internal | |———–|———-:|————–|—————|———-|
Added Settings
| name | description | input_type | scope | aliases | |——|————-|————|——-|———|