> ------- Original Message ------- > From: "Ian Harding" <[EMAIL PROTECTED]> > To: "Jeffrey Melloy" <[EMAIL PROTECTED]> > Sent: 1/8/07, 7:06:31 PM > Subject: Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer" > in MS sqlserver.? > > I thought that was called SQL Profiler. > > http://msdn2.microsoft.com/en-us/library/ms181091.aspx > > Query Analyzer is EXPLAIN with a GUI. > > http://msdn2.microsoft.com/en-gb/library/aa178423(SQL.80).aspx > > Anyway, I have not heard of such a thing for PostgreSQL, although I am > sure the basic information you want could be obtained from logging > queries and timing.
pgAdmin has graphical explain, and basic activity monitoring. It is free, and has great support! Regards, Dave ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster