From: | niraj patel <npatel(at)gridsolv(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Time Profiling inside the procedure |
Date: | 2009-12-05 01:18:28 |
Message-ID: | 844670.76810.qm@web1207.biz.mail.gq1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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>
From | Date | Subject | |
---|---|---|---|
Next Message | Ing . Marcos Luís Ortíz Valmaseda | 2009-12-05 14:16:38 | Re: performance while importing a very large data set in to database |
Previous Message | Andreas Thiel | 2009-12-04 23:03:12 | Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum |