Postgres Pro
Downloads
Home   >   mailing lists

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

From Bartosz Dmytrak
Subject Re: Fwd: Functions not visible in pg_stat_user_functions view
Date
Msg-id CAD8_UcYuMZATiG+CybTsBnb8fojcKQKQdwN-+o9hu3aVUYZv8g@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: Functions not visible in pg_stat_user_functions view  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view

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 by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Fwd: Functions not visible in pg_stat_user_functions view
Next
From: hamann.w@t-online.de
Date:
Subject: optimize query?