Getting stats out of postgresql - Mailing list pgsql-novice

From Crombleholme, Roy
Subject Getting stats out of postgresql
Date
Msg-id 4F9235D7B7D2D611B8DB000802E65AC5062325@lccmail2.lancscc.gov.uk
Whole thread Raw
List pgsql-novice
Hi all.  I am trying to get some stats out of postgresql.  I'm running 7.2.1
opn Solaris 8.  I want to be able to monitor the number of connections and
what people are connected and wat they are doing etc...  I have turned
access statistic gathering on in my postgresql.conf file so i could do with
getting the figures out of the database somehow with a monitoring tool.

Any ideas, my hair is beginning to get very thin!!! :(

Roy Crombleholme
Trainee ICT Engineer
ICT Services
Resources Directorate
Lancashire County Council
01772 5-31849
Email:  roy.crombleholme@its.lancscc.gov.uk


********************
This e-mail contains information intended for the addressee only.
It may be confidential and may be the subject of legal and/or professional privilege.
If you are not the addressee you are not authorised to disseminate, distribute, copy or use this e-mail or any
attachmentto it 
The content may be personal or contain personal opinions and unless specifically stated or followed up in writing, the
contentcannot be taken to form a contract or to be an expression of the County Council's position. 
LCC reserves the right to monitor all incoming and outgoing email
LCC has taken reasonable steps to ensure that outgoing communications do not contain  malicious software and it is your
responsibilityto carry out any checks on this email before accepting the email and opening attachments. 
********************


pgsql-novice by date:

Previous
From: papapep
Date:
Subject: Re: Inserting data of two other tables [Now deleting ...]
Next
From: Dani Oderbolz
Date:
Subject: Re: Create Table Unique problem... bug?