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: "[email protected]" <[email protected]> To: Niraj Patel <[email protected]> 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 [email protected]: approve niIGwr unsubscribe pgsql-performance [email protected] 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 [email protected] If you need help or have questions about the mailing list, please contact the people who manage the list by sending a message to [email protected] You can manage your subscription by visiting the following WWW location: <http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org/npatel%40gridsolv.com>
