Re: How to know server status variable in postgresql? - Mailing list pgsql-general

From Sameer Kumar
Subject Re: How to know server status variable in postgresql?
Date
Msg-id CADp-Sm4u51DLuf_uH0maUwwmKdDuq+WuqGyVeGwASwP6wHg_Zw@mail.gmail.com
Whole thread Raw
In response to How to know server status variable in postgresql?  (ambilalmca <ambilalmca@gmail.com>)
Responses Re: How to know server status variable in postgresql?  (ambilalmca <ambilalmca@gmail.com>)
List pgsql-general

On Tue, Jan 7, 2014 at 8:33 PM, ambilalmca <ambilalmca@gmail.com> wrote:
Hai, I am developing a java application for performance counter. For that i
want to collect all server status counter names with current value. i just
did it for MySQl by, *"SHOW GLOBAL STATUS"*.

What details do you want to collect? That command in MySQL may be giving you few counters, but which of those are of your interest?



Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M : +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz

email patch

This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).

Attachment

pgsql-general by date:

Previous
From: Sameer Kumar
Date:
Subject: Re: Sudden slow down and spike in system CPU causes max_connections to get exhausted
Next
From: Raphael Bauduin
Date:
Subject: returning json object with subset of keys