Rural Hunter <ruralhunter@gmail.com> writes:
> I noticed there were some statistics for triggers in pgAdmin III GUI,
> such as total execution count and execution time. But they are all
> empty. is there any way to enable those statistics?
See the following manual section...
18.9. Run-time Statistics
track_functions (enum)
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.
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 305.321.1144