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

There is no GUI tool that I know of, but there is EXPLAIN which gives
the same information.

- Ian

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

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.

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