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
> --- 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 Mas
> 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 s
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, Qu
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
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
> --- 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 lon
TECTED]>
> 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
> --- 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"
> i
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
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.
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
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
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.co
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
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
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
17 matches
Mail list logo
