Type: enum
Default: none
Context: superuser
Restart: false
Values: [none, pl, all]

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 and users with the appropriate SET privilege 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