Using explain I am not able to get the detailed information.
I want to know abotu optimizing the postgre.
Shridhar Daithankar wrote:
> On 28 Oct 2002 at 11:52, Savita wrote:
>
> > Hi all,
> >
> > I have created the indexs on some table but still I am not getting the
> > performance as required.Some sql statements are taking very long time to
> > execute.
> >
> > Is there any way to analyse the performance in postgre,I am able to analyses
> > it in MSSQL.
>
> What does explain tells about the query?
>
> Bye
> Shridhar
>
> --
> Robot, n.: University administrator.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------