Time Profiling inside the procedure

Поиск
Список
Период
Сортировка
От niraj patel
Тема Time Profiling inside the procedure
Дата
Msg-id 844670.76810.qm@web1207.biz.mail.gq1.yahoo.com
обсуждение исходный текст
Список 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@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>

В списке pgsql-performance по дате отправления:

Предыдущее
От: nair rajiv
Дата:
Сообщение: query cost too high, anyway to reduce it
Следующее
От: "Ashish Kumar Singh"
Дата:
Сообщение: performance while importing a very large data set in to database