From: Jerry Sievers <gsievers19@comcast.net>
To: Rural Hunter <ruralhunter@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: trigger statistics?
Date: Sat, 17 Dec 2011 08:31:31 -0500
Message-ID: <87bor7wci4.fsf@comcast.net> (raw)
In-Reply-To: <4EEC0E5B.3010208@gmail.com>
References: <4EEC0E5B.3010208@gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, ruralhunter@gmail.com
Subject: Re: trigger statistics?
In-Reply-To: <87bor7wci4.fsf@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox