| 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: | Whole Thread | Raw Message | 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.? |