stats_* parameters).
Regards,
--
Husam
http://firstdba.googlepages.com
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Aaron Bono
Sent: Wednesday, September 20, 2006 11:46 AM
To: Tomeh, Husam
Cc: pgsql admin
Subject: Re: [ADMIN] Monitor
ECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Aaron BonoSent:
Wednesday, September 20, 2006 11:46 AMTo: Tomeh, HusamCc:
pgsql adminSubject: Re: [ADMIN] Monitoring
Connections I checked the pg_stat_activity table and it doesn't give any more
information than I got from the ps command. Is t
amSent: Wednesday, September 20, 2006 11:22 AMTo: Aaron
Bono; pgsql adminSubject: Re: [ADMIN] Monitoring
Connections
Query the
pg_stat_activity.
For more
detailed stats activities, you may query the pg_stat_* and pg_statio_*
system views.
http://www.postgresql.org/docs/8.0/static/monitorin
adminSubject: Re: [ADMIN] Monitoring
Connections
Query the
pg_stat_activity.
For more
detailed stats activities, you may query the pg_stat_* and pg_statio_*
system views.
http://www.postgresql.org/docs/8.0/static/monitoring.html
--
Husam
http://firstdba.googlepages.com
From
Behalf Of Aaron
BonoSent: Wednesday, September 20, 2006 10:48 AMTo: pgsql
adminSubject: [ADMIN] Monitoring Connections
Is there a way to get diagnostics on current connections to the
database? Specifically I am looking for:1. How many current
connections are there?2. Who is connected (user name
Is there a way to get diagnostics on current connections to the database? Specifically I am looking for:1. How many current connections are there?2. Who is connected (user name, database and from what IP address)?
3. When was the last time the connection was used?4. When was the connection establi
