Re: trigger statistics? - Mailing list pgsql-admin

From Jerry Sievers
Subject Re: trigger statistics?
Date
Msg-id 87bor7wci4.fsf@comcast.net
Whole thread Raw
In response to trigger statistics?  (Rural Hunter <ruralhunter@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Rural Hunter
Date:
Subject: trigger statistics?
Next
From: 杨晓青
Date:
Subject: Re: Index error on recovery