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

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

2007-01-09 Thread Tony Caduto
Harald Armin Massa wrote: 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,

Re: [GENERAL] is there a tracking trace tool like the SQL Analizer

2007-01-09 Thread Magnus Hagander
Hi, I may be wrong but: Enabling query logging (in the options dialog) will only log the SQL pgAdmin III sends to the server, it will not capture the query for a selected process in the server status dialog. If you want something like the trace in MS SQL server Lightning Admin has

Re: [GENERAL] is there a tracking trace tool like the SQL Analizer

2007-01-09 Thread Dave Page
--- Original Message --- From: Tony Caduto [EMAIL PROTECTED] To: Harald Armin Massa [EMAIL PROTECTED] Sent: 1/9/07, 7:15:52 PM Subject: Re: [GENERAL] is there a tracking trace tool like the SQL Analizer Harald Armin Massa wrote: Jeffrey, Not exactly. SQL Analyzer also

Re: [GENERAL] is there a tracking trace tool like the SQL Analizer

2007-01-09 Thread Tony Caduto
Dave Page wrote: That's not what Harald was referring to. The server status dialog monitors the entire server via pg_stat*. /D Hi Dave, It was not just a response to Harald's comment, but also the one right above his :-) You can achieve something similar by enabling query logging in

[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.ThanksGet your FREE, LinuxWaves.com Email Now! -- http://www.LinuxWaves.comJoin Linux Discussions! -- http://Community.LinuxWaves.com

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

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: There is

Re: [GENERAL] is there a tracking trace tool like the SQL Analizer

2007-01-08 Thread Tony Caduto
guillermo arias 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

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
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

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. You can

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

Re: [GENERAL] is there a tracking trace tool like the SQL Analizer

2007-01-08 Thread Dave Page
--- 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

Re: [GENERAL] is there a tracking trace tool like the SQL Analizer

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

Re: [GENERAL] is there a tracking trace tool like the SQL Analizer

2007-01-08 Thread Dave Page
--- Original Message --- From: Jeffrey Melloy [EMAIL PROTECTED] To: Dave Page [EMAIL PROTECTED] Sent: 1/8/07, 8:18:02 PM Subject: Re: [GENERAL] is there a tracking trace tool like the SQL Analizer How long has that been available for OS X? Last time I looked at it it wasn't. 2