Whoops, you're right. On 1/8/07, Ian Harding <[EMAIL PROTECTED]> wrote:
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. - Ian On 1/8/07, Jeffrey Melloy <[EMAIL PROTECTED]> wrote: > Not exactly. SQL Analyzer also includes live monitoring of whatever queries > are coming into the database. You can achieve something similar by enabling > query logging in the settings. > > > On 1/8/07, Ian Harding <[EMAIL PROTECTED]> wrote: > > > > There is no GUI tool that I know of, but there is EXPLAIN which gives > > the same information. > > > > - Ian > > > > On 1/8/07, guillermo arias <[EMAIL PROTECTED] > wrote: > > > is there a tracking trace tool in postgre? like the "SQL Analizer" in MS > > > sqlserver. > > > > > > I have downloaded the PGAdmin III and i have not found any tool like > this. > > > > > > Thanks > > > > > > > > > ________________________________ > > > Get your FREE, LinuxWaves.com Email Now! --> http://www.LinuxWaves.com > > > Join Linux Discussions! --> http://Community.LinuxWaves.com > > > > ---------------------------(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 > > > >
