Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?

2007-01-09 Thread Harald Armin Massa
Jeffrey, 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. that is within Tools / View Server Status of pgAdmin III Of course, Query Command String has to be

Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?

2007-01-09 Thread Jeffrey Melloy
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 wh

Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?

2007-01-08 Thread Harald Armin Massa
Ian, Query Analyzer is EXPLAIN with a GUI. Anyway, I have not heard of such a thing for PostgreSQL, On my installation of PostgreSQL from the stock windows installer there was installed PgAdmin, which has quite a GUI for EXPLAIN. The query plan is displayed very nice and I find it easier to u

Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?

2007-01-08 Thread Ian Harding
On 1/8/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: On Mon, 2007-01-08 at 12:56 -0600, Jeffrey Melloy wrote: > > > 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.

Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?

2007-01-08 Thread Jeffrey Melloy
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 hear

Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?

2007-01-08 Thread Ian Harding
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

Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?

2007-01-08 Thread Jeffrey Melloy
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: > > The

Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?

2007-01-08 Thread Ian Harding
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

[GENERAL] is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?

2007-01-08 Thread guillermo arias
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.comJoin Linux Discussions! --> http://Community.LinuxWaves.com