Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxxxx > 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
>




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux