Re: [GENERAL] profiling store procedure

2012-03-23 Thread Guillaume Lelarge
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

Re: [GENERAL] profiling store procedure

2012-03-23 Thread Sergey Konoplev
On Fri, Mar 23, 2012 at 11:16 AM, Geek Matter 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

[GENERAL] profiling store procedure

2012-03-23 Thread Geek Matter
what tool is suitable for profiling store procedure in postgresql? sql server has sql profiles, how about postgresql?