Discussion:
[ADMIN] trigger statistics?
(too old to reply)
Rural Hunter
2011-12-17 03:36:59 UTC
Permalink
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?
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Jerry Sievers
2011-12-17 13:31:31 UTC
Permalink
Post by Rural Hunter
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.
Post by Rural Hunter
--
http://www.postgresql.org/mailpref/pgsql-admin
--
Jerry Sievers
Postgres DBA/Development Consulting
e: ***@comcast.net
p: 305.321.1144
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...