How to profile plpgsql function in PostgreSQL 9.2

3
votes

I'd like to find the bottlenecks in a plpgsql function, so I'm looking for a profiler.

How do I enable the PostgreSQL function profiler? suggests loading the plugin_profiler.dll library, but it was written for 8.3 and there seems to be no such thing in 9.2

I've also installed and the debugger described at http://git.postgresql.org/gitweb/?p=pldebugger.git;a=summary (which is included with 9.2), but can't see any way of using it as a profiler.

The simple "RAISE NOTICE" method wouldn't be effective for me, because the function executes in < 0.1 ms, but is called many times.

1
performancepostgresqlprofilingplpgsql

1 Answers

6
votes

PostgreSQL 9.2 has buildin SQL profiler, try to use it - if your plpgsql contains some SQL queries.

http://www.postgresql.org/docs/9.2/static/pgstatstatements.html

and now, plpgsql_check has integrated profiler