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

Sure see log_statement in postgresql.conf.  There are a lot of settings
in there to control what is logged.

  Bruce Momjian                        |               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to