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