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@postgresql.org" <pgsql-performance-owner@postgresql.org> To: Niraj Patel <npatel@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 majordomo@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-owner@postgresql.org