how to monitor/examine the database - Mailing list pgsql-hackers

From Ilan Fait
Subject how to monitor/examine the database
Date
Msg-id C9E46ACE328FD311B70200508B91AD8CA8FEF3@EXCHANGE
Whole thread Raw
List pgsql-hackers
<br /><br /><br /><p><font face="Arial" size="2">  Hi,</font><br /><font face="Arial" size="2"> </font><br /><font
face="Arial"size="2">  I am testing the PostgerSQL database and I would like to if there any<b></b></font><b></b><b>
<fontface="Times New Roman">benchmarking tools</font></b><br /><font face="Times New Roman">  to  examine the database
andcan give a report about the database activity.</font><br /><font face="Times New Roman"> In Oracle you have</font>
<fontface="Arial" size="2">the Utlbstat/utlestat and statspack (available from 8.1.6): </font><br /><font face="Arial"
size="2"> These two bundled with the Oracle Server generate complete reports of the database activity. </font><br
/><fontface="Arial" size="2"> The new STATSPACK utility bundled with Oracle 8.1.6 and up allows more flexibility in<br
/> managing statistical snapshots.</font><br /><font face="Times New Roman">  Thanks,</font><br /><font face="Times New
Roman">  Ilan</font><p><b><font color="#000000" face="Century
Gothic">_________________________________________</font></b><br/><b><font color="#000000" face="Century Gothic">ILAN
FAIT</font></b><br/><font color="#000000" face="Century Gothic" size="2">Tel: 972-9-9519133  Ex.247    iWeb
Technologies</font><br/><font color="#000000" face="Century Gothic" size="2">Fax: 972-9-9519134                91
MedinatHa'Yehudim St.</font><br /><font color="#000000" face="Century Gothic"
size="2">                                                    Herzliya 46120 IL</font><br /><font color="#000000"
face="CenturyGothic" size="2"><a href="mailto:ilan@iweb.com">mailto:ilan@iweb.com</a>    www.iweb.com</font><br /> 

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: stuck spin lock with many concurrent users
Next
From: nj7e@yahoo.com (John Moore)
Date:
Subject: Re: Backup and Recovery