Collect PostgreSQL statistics information like 'pg_stat_activity'.
$ npm i pg-stats --save'use strict';
const pgs = require('pg-stats');
const cn = 'postgres://postgres:password@localhost:5432/postgres';
pgs(cn).then(results => {
console.log(results['pg_stat_activity']);
})| view name |
|---|
| pg_stat_acrivity |
| pg_stat_database |
| pg_stat_user_tables |
| pg_stat_sys_tables |
| pg_stat_all_tables |
| pg_stat_user_indexes |
| pg_stat_sys_indexes |
| pg_stat_all_indexes |
| pg_statio_user_tables |
| pg_statio_sys_tables |
| pg_statio_all_tables |
| pg_statio_user_indexes |
| pg_statio_sys_indexes |
| pg_statio_all_indexes |
Please check official document https://www.postgresql.org/docs/9.6/static/monitoring-stats.html
MIT © munisystem