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 | http://candle.pha.pa.us pgman@candle.pha.pa.us | (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 match