Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 524B416E34F9 for ; Sat, 17 Dec 2011 09:31:48 -0400 (AST) Received: from qmta09.westchester.pa.mail.comcast.net ([76.96.62.96]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RbuMa-0004vr-4V for pgsql-admin@postgresql.org; Sat, 17 Dec 2011 13:31:47 +0000 Received: from omta24.westchester.pa.mail.comcast.net ([76.96.62.76]) by qmta09.westchester.pa.mail.comcast.net with comcast id ADQU1i0021ei1Bg59DXYTk; Sat, 17 Dec 2011 13:31:32 +0000 Received: from homie ([68.45.149.190]) by omta24.westchester.pa.mail.comcast.net with comcast id ADXY1i00d46izrY3kDXYrZ; Sat, 17 Dec 2011 13:31:32 +0000 Received: by homie (Postfix, from userid 1000) id 3211018290F; Sat, 17 Dec 2011 08:31:31 -0500 (EST) To: Rural Hunter Cc: pgsql-admin@postgresql.org Subject: Re: trigger statistics? References: <4EEC0E5B.3010208@gmail.com> From: Jerry Sievers Date: Sat, 17 Dec 2011 08:31:31 -0500 In-Reply-To: <4EEC0E5B.3010208@gmail.com> (Rural Hunter's message of "Sat\, 17 Dec 2011 11\:36\:59 +0800") Message-ID: <87bor7wci4.fsf@comcast.net> User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.2 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Pg-Spam-Score: -2.1 (--) X-Archive-Number: 201112/84 X-Sequence-Number: 38842 Rural Hunter 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