Thread: is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?

is there a tracking trace tool in postgre? like the "SQL Analizer" in MS sqlserver.I have downloaded the PGAdmin III
andi have not found any tool like this.Thanks Get your FREE, LinuxWaves.com Email Now! -->
http://www.LinuxWaves.comJoinLinux 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 <guillermoariast@linuxwaves.com> 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

On Mon, 2007-01-08 at 12:56 -0600, Jeffrey Melloy wrote:
>
>
> On 1/8/07, Jeffrey Melloy <melloyj@alliancetechnologies.net> 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.

pg_stat_activity?

>
>
>         On 1/8/07, Ian Harding <harding.ian@gmail.com> 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
>                 <guillermoariast@linuxwaves.com> 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
>
>
>
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

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 Email Now! --> http://www.LinuxWaves.com
> Join Linux Discussions! --> http://Community.LinuxWaves.com
Hi,
You can do this with Postgresql by turning on log statements in the
postgresql.conf file.
You can then trace all the statements that the server executed in the
log and the values that where passed.

You could also check out Lightning Admin instead of pgAdmin III.
We have a feature that can capture the currently running statement from
a process and list them all in a memo.
Can be handy.
You can find out more here:
http://www.amsoftwaredesign.com/onlinehelp/pgla/server_status.htm
While not free, Lightning Admin is SUPER inexpensive :-) and you will
get great support.

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration

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 <melloyj@alliancetechnologies.net> 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 <harding.ian@gmail.com> 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 <guillermoariast@linuxwaves.com > 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
> >
>
>

Whoops, you're right.

On 1/8/07, Joshua D. Drake <jd@commandprompt.com> wrote:
> On Mon, 2007-01-08 at 12:56 -0600, Jeffrey Melloy wrote:
> >
> >
> > On 1/8/07, Jeffrey Melloy <melloyj@alliancetechnologies.net> 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.
>
> pg_stat_activity?
>

The SQL Profiler tool also keeps data that meet your criteria for
later analysis as well.  It is very good.

- Ian

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
understand then text output.

Harald


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.

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.

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 enabled on the server; and
the security implications of that setting have to be considered before
:)

best wishes,

Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.

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, Query Command String has to be enabled on the server; and
> the security implications of that setting have to be considered before
> :)
>
> best wishes,
>
> Harald
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 something similar:
http://www.amsoftwaredesign.com/onlinehelp/pgla/server_status.htm
You can select the process ID you want, then check the Capture selected
rows query option and all the queries for that process that become
visible will be
logged to a memo control, you can then copy the captured queries to
where ever you like.


Later,

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration

> 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 something similar:
> http://www.amsoftwaredesign.com/onlinehelp/pgla/server_status.htm
> You can select the process ID you want, then check the Capture selected
> rows query option and all the queries for that process that become
> visible will be
> logged to a memo control, you can then copy the captured queries to
> where ever you like.

Out of curiosity, how does that work? I mean, how does it pick up when a
new query has been issued? Do you use some server-proc to tail the
logfile or such?

//Magnus