Postgres Pro
Downloads
Home   >   mailing lists

Re: profiling store procedure - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: profiling store procedure
Date
Msg-id CAL_0b1t9hY93ULtd2UMp7Z2Qu_Ch0pCR-C3PbyOHBcMarVYQPg@mail.gmail.com
Whole thread Raw
In response to profiling store procedure  (Geek Matter <geekmatter@yahoo.com>)
List pgsql-general
Tree view 
On Fri, Mar 23, 2012 at 11:16 AM, Geek Matter <geekmatter@yahoo.com> wrote:
> what tool is suitable for profiling store procedure in postgresql? sql
> server has sql profiles, how about postgresql?

You can use the pg_stat_statements
(http://www.postgresql.org/docs/9.1/interactive/pgstatstatements.html)
extension to do profiling. Turn track_utility to on to collect DDL and
set track to all to collect queries inside functions.

--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com
LinkedIn: http://ru.linkedin.com/in/grayhemp
JID/GTalk: gray.ru@gmail.com Skype: gray-hemp

pgsql-general by date:

Previous
From: Heiko Wundram
Date:
Subject: Re: [SOLVED] Very high memory usage on restoring dump (with plain pqsl) on pg 9.1.2
Next
From: Guillaume Lelarge
Date:
Subject: Re: profiling store procedure