You can use EXPLAIN and EXPLAIN ANALYZE
For details please have a look at -->
http://www.postgresql.org/docs/8.1/interactive/performance-tips.html
/Shoaib
On 6/16/06, shyju c.k <newslttr(at)gmail(dot)com> wrote:
>
>
> hai all
>
> plz send gen info abt query optimizer technic in postgresql
>
> with example
>