On Fri, 2012-03-23 at 00:16 -0700, Geek Matter wrote: > what tool is suitable for profiling store procedure in postgresql? sql server > has sql profiles, how about postgresql?
The EDB PL/pgsql profiler tool is probably the easier tool to work with if you want to profile PL/pgsql functions. That's also the only available automatic tool I know. You can also use the manual way, but it isn't easy. See this great post from Hubert Lubaczewski (aka Depesz): http://www.depesz.com/2010/03/18/profiling-stored-proceduresfunctions/ -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
