Thread: trigger statistics?

trigger statistics?

From
Rural Hunter
Date:
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?

Re: trigger statistics?

From
Jerry Sievers
Date:
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