Re: Fwd: Functions not visible in pg_stat_user_functions view

Поиск
Список
Период
Сортировка
От Bartosz Dmytrak
Тема Re: Fwd: Functions not visible in pg_stat_user_functions view
Дата
Msg-id CAD8_UcYuMZATiG+CybTsBnb8fojcKQKQdwN-+o9hu3aVUYZv8g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fwd: Functions not visible in pg_stat_user_functions view  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-general
Дерево обсуждения

2013/1/30 Albe Laurenz <laurenz.albe@wien.gv.at>
The most likely explanation for what you observe is that
the functions have never been called since track_functions
has been set to "all".

You can see if that is indeed the reason by calling one
of your "invisible" functions and see if it becomes
visible afterwards.


thanks a lot :)
works as described.

I think it is good idea to extend description in doc (http://www.postgresql.org/docs/9.2/static/monitoring-stats.html#PG-STAT-USER-FUNCTIONS-VIEW) to cover this case.

again: thank You very much for help.

Regards,
Bartek 

В списке pgsql-general по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: Fwd: Functions not visible in pg_stat_user_functions view
Следующее
От: hamann.w@t-online.de
Дата:
Сообщение: optimize query?