Search Postgresql Archives

Re: is there a tracking trace tool like the "SQL

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

 



On Mon, 2007-01-08 at 12:56 -0600, Jeffrey Melloy wrote:
> 
> 
> 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.

pg_stat_activity?

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

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





[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