Search Postgresql Archives

PostgrSQL server : CPU and Memory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: PostgrSQL server : CPU and Memory
From: kaustubh kelkar <ksquare16@xxxxxxxxx>
Date: Thu, 18 May 2017 09:20:44 +0530
Arc-authentication-results: i=1; mx.google.com; dkim=fail header.i=@gmail.com; spf=pass (google.com: best guess record for domain of pgsql-general-owner+m230976=spinic=gmail.com@xxxxxxxxxxxxxx designates 2a02:16a8:dc51::56 as permitted sender) smtp.mailfrom=pgsql-general-owner+M230976=spinic=gmail.com@xxxxxxxxxxxxxx; dmarc=fail (p=NONE sp=NONE dis=NONE) header.from=gmail.com
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=sender:precedence:list-unsubscribe:list-subscribe:list-post :list-owner:list-id:list-help:list-archive:to:subject:message-id :date:from:mime-version:dkim-signature:arc-authentication-results; bh=voHbTkvE4ziILLJsxpXQrkz9kXz85Waq2xSlrgBuKgc=; b=gHrmS3uKkT5iO7lZtNaOzK7NyTwrKxzdL9C4NeiUzSkrOI4q0LbVtVeT9zoHh9R6tQ OfU8Gnr5hUT43hfyvKCv3ux1nT6ycOPQeZ4bhxG9AnVuiXw6XomOJ+OfqZYXpQiqIJYy wFYoSTq7YLhvs2GDIvOnR0sc+sdhvozA5YB2FTw0djgZKYH0lPzz186ae/Uapgy5hMsQ eJHZIdKZPKJom9vbWL144x0jIis0qymVDCyuK/TiCvFKO5iskFZNAxvl1IFrzvXXt0Oq 0lPKoZog7DYwMeu1/J/a9TENb76Uioj9WGoyfEvAPlaKcZ8PaHd/HjREdLbl0VKxVd4d NC2A==
Arc-seal: i=1; a=rsa-sha256; t=1495079503; cv=none; d=google.com; s=arc-20160816; b=PT9FIU0kU1etOjMWowM/nP/UitTs3tcqOuUlBy6EUtFRZTGQ5CdudgjHP0sFYpTPnF 7r8XLVvt3pi9nbpvo7+gbMq3flNqOmrB3HhQK7aC45C6HMkbYijvpkLnzhAK2wFYh/Bi 1MkpaguzlbuFsmpvGGLmz8Ziq0Tyl4Yz2yuau8jowVdygxkSdZ6lXM7AHYpFtgZzRPk5 sVT3a7XvZKJRBcfPscgvfVYgaXzgdwKE37YylZnICO7AeRhjshSOZGZsttk9CNY44mK3 F4yCJ6pad5SNrVOCfV6ibxPz2aDh3cHDRf8sAAYH51mrq5A2O+tXH96RT58aiWBGcM+m 0a6A==

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: PostgrSQL server : CPU and Memory
  - From: John R Pierce

Prev by Date: Re: column names and dollar sign
Next by Date: Re: PostgrSQL server : CPU and Memory
Previous by thread: column names and dollar sign
Next by thread: Re: PostgrSQL server : CPU and Memory
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]