| From: | kaustubh kelkar <ksquare16(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org |
| Subject: | PostgrSQL server : CPU and Memory |
| Date: | 2017-05-18 03:50:44 |
| Message-ID: | CALb1ETPD_yjC4Jc2rKhesm=rO+xZZGNaiTd-FothPUh+5uSWrQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Hi ,
I am a developer and I want to monitor metrics related to CPU and Memory of
PostgreSQL server only using SQL queries.
Do we have any system tables which can give us the data? I have found this
one
https://aaronparecki.com/2015/02/19/8/monitoring-cpu-memory-usage-from-postgres
but dont know whether it is exactly the same what I need.
I am able to fetch the same using scripts (batch/shell) but getting data
from SQL will be my main task.
--
Kaus2bh Kelkar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2017-05-18 04:03:10 | Re: PostgrSQL server : CPU and Memory |
| Previous Message | Gavin Flower | 2017-05-18 00:22:43 | Re: column names and dollar sign |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2017-05-18 04:03:10 | Re: PostgrSQL server : CPU and Memory |
| Previous Message | Adrian Klaver | 2017-05-13 22:26:56 | Re: [SQL] PostgreSQL 9.3 DB initialization issue |