Search Shortcut cmd + k | ctrl + k
system_stats

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 | |——|————-|————|——-|———|