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