Time Profiling inside the procedure

Hi All,

I want to identify the bottleneck queries inside the procedure. I want to know which of the queries are taking the time. How can I measure time taken to execute the individual Query inside a Procedure ?

Thank You
Niraj Patel

________________________________
From: "pgsql-performance-owner(at)postgresql(dot)org" <pgsql-performance-owner(at)postgresql(dot)org>
To: Niraj Patel <npatel(at)gridsolv(dot)com>
Sent: Sat, 5 December, 2009 6:33:10 AM
Subject: Welcome to the pgsql-performance list!

Welcome to the pgsql-performance mailing list!
Your password at postgresql.org is

niIGwr

To leave this mailing list, send the following command in the body
of a message to majordomo(at)postgresql(dot)org:

approve niIGwr unsubscribe pgsql-performance npatel(at)gridsolv(dot)com

This command will work even if your address changes. For that reason,
among others, it is important that you keep a copy of this message.

To post a message to the mailing list, send it to
pgsql-performance(at)postgresql(dot)org

If you need help or have questions about the mailing list, please
contact the people who manage the list by sending a message to
pgsql-performance-owner(at)postgresql(dot)org

You can manage your subscription by visiting the following WWW location:
<http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org/npatel%40gridsolv.com>