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"*. is their any query similar this
to collect those details from the database. I am new to postgresql, so
I want to collect,
*Connections. *
Current connections. The number of currently open connections.
Connections executing requests. The number of currently open connections
that are executing requests.
Idle connections. The number of currently idle connections.
Max connections. The maximum number o
oh thanks @Sameer Kumar
Thanks & Regards,
A.Mohamed Bilal
On Thu, Jan 9, 2014 at 12:50 PM, Sameer Kumar [via PostgreSQL] <
ml-node+s1045698n5786022...@n5.nabble.com> wrote:
>
>
>
> On Wed, Jan 8, 2014 at 7:22 PM, ambilalmca <[hidden
> email]<http://user/SendEma
@ sameer khan, i got query for all except *Number of cached blocks read,
Number of cached index blocks read, Number of cached sequence blocks read*.
can you tell query for these three counters only?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-know-server-sta
an 10, 2014 at 2:57 PM, ambilalmca <[hidden
> email]<http://user/SendEmail.jtp?type=node&node=5786458&i=0>
> > wrote:
>
>> @ sameer khan,
>
> That's Sameer Kumar :-)
>
>> i got query for all except
>
>
>
>> *Number of cac
portant counter to know postgresql
> server status. thats why i am asking @sameer
>
> Thanks & Regards,
> A.Mohamed Bilal
>
>
> On Sat, Jan 11, 2014 at 7:15 PM, Sameer Kumar [via PostgreSQL] <
> ml-node+s1045698n5786458...@n5.nabble.com> wrote:
>
>>
>&
