On Fri, Mar 23, 2012 at 11:16 AM, Geek Matter <geekmatter@xxxxxxxxx> 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@xxxxxxxxx Skype: gray-hemp -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
