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