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 are executed on a
> database during a specified period of time. Kindly let me know if any of
> you knows of such a tool for PostgreSQL.
>
> Agha Asif Raza