Re: Fwd: Functions not visible in pg_stat_user_functions view - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Fwd: Functions not visible in pg_stat_user_functions view
Date
Msg-id 5107EAB4.4000505@gmail.com
Whole thread Raw
In response to Fwd: Functions not visible in pg_stat_user_functions view  (Bartosz Dmytrak <bdmytrak@gmail.com>)
Responses Re: Fwd: Functions not visible in pg_stat_user_functions view
List pgsql-general
On 01/29/2013 03:50 AM, Bartosz Dmytrak wrote:
> Hi all,
> Does anyone have an idea why it works like this?

Not quite sure what you are asking. On the assumption that functions are
not showing up in the view, have you checked:

http://www.postgresql.org/docs/9.2/static/runtime-config-statistics.html#GUC-TRACK-FUNCTIONS
"
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.

Note: SQL-language functions that are simple enough to be "inlined" into
the calling query will not be tracked, regardless of this setting.
"

>
> Regards,
> Bartek
>


--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: Chris Angelico
Date:
Subject: Re: inet/cidr ipv6 operations
Next
From: Bartosz Dmytrak
Date:
Subject: Re: Fwd: Functions not visible in pg_stat_user_functions view