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

From: "Jeffrey Melloy" <melloyj(at)alliancetechnologies(dot)net>
To: harding(dot)ian(at)gmail(dot)com
Cc: guillermoariast(at)linuxwaves(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?
Date: 2007-01-08 18:54:37
Message-ID: 3d2ffcdd0701081054g1df922a4ge9e0751320abecc9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)ian(at)gmail(dot)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(at)linuxwaves(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeffrey Melloy 2007-01-08 18:56:52 Re: is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?
Previous Message Ian Harding 2007-01-08 18:39:30 Re: is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?