pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
trigger statistics? 2+ messages / 2 participants [nested] [flat]
* trigger statistics? @ 2011-12-17 03:36 Rural Hunter <ruralhunter@gmail.com> 2011-12-17 13:31 ` Re: trigger statistics? Jerry Sievers <gsievers19@comcast.net> 0 siblings, 1 reply; 2+ messages in thread From: Rural Hunter @ 2011-12-17 03:36 UTC (permalink / raw) To: pgsql-admin 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? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: trigger statistics? 2011-12-17 03:36 trigger statistics? Rural Hunter <ruralhunter@gmail.com> @ 2011-12-17 13:31 ` Jerry Sievers <gsievers19@comcast.net> 0 siblings, 0 replies; 2+ messages in thread From: Jerry Sievers @ 2011-12-17 13:31 UTC (permalink / raw) To: Rural Hunter <ruralhunter@gmail.com>; +Cc: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-12-17 13:31 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-12-17 03:36 trigger statistics? Rural Hunter <ruralhunter@gmail.com> 2011-12-17 13:31 ` Jerry Sievers <gsievers19@comcast.net>
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