PostgreSQL version:

track_functions

Enables tracking of function call counts and time used. Specify pl to track only procedural-language functions, all to also track SQL and C language functions. The default is none, which disables function statistics tracking. Only superusers can change this setting.

SQL-language functions that are simple enough to be inlined into the calling query will not be tracked, regardless of this setting.

Recommendations

Set it to 'pl' to collect stats on user-defined functions. Very useful for stored procedure performance profiling and troubleshooting.

Comments