Skip to content
This PostgreSQL extension implements tables and views to get information about server resources : CPU, RAM, partitions, SO, etc
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
Makefile
README
resources--0.1.0.sql
resources.control

README

resources  extension
======================================

This PostgreSQL extension implements  tables and views  to get information about server resources : CPU, RAM, partitions, SO, etc 
#required PG10+, file_fdw extension and linux SO

IMPORTANT: There're bugs in the existing version, please contact to me.


Building and install
--------
Run: make install 
In postgresql execute: CREATE EXTENSION resources CASCADE;


--It create schema resources
              




Example of use
-------

--TABLES:
resources.cpu_loadavg  -- CPU use on last 1, 5 y 10 minutes
resources.cpu_use      -- CPU use by user, sys, nice, idle, wait
resources.distribution -- SO distribution
resources.lscpu        -- CPU characteristics
resources.meminfo      -- MEM RAM use
resources.partitions   -- HDD partitions use
resources.ps_postgresv2  -- PG process data to build v_ps_postgrev2 view





--VIEWS:

resources.v_ps_postgresv2-- View to show PG process (PID,db_name, CPU_percent, mem_percent, IP, state, query, backend type)


Anthony R. Sotolongo leon
asotolongo@gmail.com

You can’t perform that action at this time.