Thread: 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@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:
approve niIGwr unsubscribe pgsql-performance npatel@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-owner@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>
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:
approve niIGwr unsubscribe pgsql-performance npatel@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-owner@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>