Re: Fwd: Functions not visible in pg_stat_user_functions view

Поиск
Список
Период
Сортировка
Искать
От
Adrian Klaver
Тема
Re: Fwd: Functions not visible in pg_stat_user_functions view
Дата
Msg-id
5107EAB4.4000505@gmail.com
Ответ на
Список
Дерево обсуждения
Functions not visible in pg_stat_user_functions view Bartosz Dmytrak <bdmytrak@gmail.com>
Fwd: Functions not visible in pg_stat_user_functions view Bartosz Dmytrak <bdmytrak@gmail.com>
Re: Fwd: Functions not visible in pg_stat_user_functions view Adrian Klaver <adrian.klaver@gmail.com>
Re: Fwd: Functions not visible in pg_stat_user_functions view Bartosz Dmytrak <bdmytrak@gmail.com>
Re: Fwd: Functions not visible in pg_stat_user_functions view Adrian Klaver <adrian.klaver@gmail.com>
Re: Fwd: Functions not visible in pg_stat_user_functions view Bartosz Dmytrak <bdmytrak@gmail.com>
Re: Fwd: Functions not visible in pg_stat_user_functions view Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Fwd: Functions not visible in pg_stat_user_functions view Bartosz Dmytrak <bdmytrak@gmail.com>
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 по дате отправления
От: Chris Angelico
Дата:
Сообщение: Re: inet/cidr ipv6 operations
От: Bartosz Dmytrak
Дата:
FAQ