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-ow...@postgresql.org" <pgsql-performance-ow...@postgresql.org> To: Niraj Patel <npa...@gridsolv.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 majord...@postgresql.org: approve niIGwr unsubscribe pgsql-performance npa...@gridsolv.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@postgresql.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-ow...@postgresql.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>