Re: Fwd: Functions not visible in pg_stat_user_functions view

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fwd: Functions not visible in pg_stat_user_functions view
Date: 2013-01-29 15:28:52
Message-ID: 5107EAB4.4000505@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bartosz Dmytrak 2013-01-29 15:36:27 Re: Fwd: Functions not visible in pg_stat_user_functions view
Previous Message Chris Angelico 2013-01-29 15:27:32 Re: inet/cidr ipv6 operations