Re: [PERFORM] Profiler for PostgreSQL

2005-07-15 Thread Andreas Pflug
Bruce Momjian wrote: Agha Asif Raza wrote: Is there any MS-SQL Server like 'Profiler' available for PostgreSQL? A profiler is a tool that monitors the database server and outputs a detailed trace of all the transactions/queries that are executed on a database during a specified period of time

Re: [PERFORM] Profiler for PostgreSQL

2005-07-14 Thread Simon Riggs
On Thu, 2005-07-14 at 14:29 +0800, Christopher Kings-Lynne wrote: > Try turning on query logging and using the 'pqa' utility on pgfoundry.org. Have you got that to work for 8 ? pqa 1.5 doesn't even work with its own test file. Best Regards, Simon Riggs ---(end of broadc

Re: [PERFORM] Profiler for PostgreSQL

2005-07-13 Thread Bruce Momjian
Agha Asif Raza wrote: > Is there any MS-SQL Server like 'Profiler' available for PostgreSQL? A > profiler is a tool that monitors the database server and outputs a detailed > trace of all the transactions/queries that are executed on a database during > a specified period of time. Kindly let me

Re: [PERFORM] Profiler for PostgreSQL

2005-07-13 Thread Christopher Kings-Lynne
Try turning on query logging and using the 'pqa' utility on pgfoundry.org. Chris Agha Asif Raza wrote: Is there any MS-SQL Server like 'Profiler' available for PostgreSQL? A profiler is a tool that monitors the database server and outputs a detailed trace of all the transactions/queries that a