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_UcboDu3QwtesT2GWZ4vsPfz84qYinbTQo=9hvP0yJkdc6Q@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: Functions not visible in pg_stat_user_functions view  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Fwd: Functions not visible in pg_stat_user_functions view  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
2013/1/29 Adrian Klaver <adrian.klaver@gmail.com>

Are they never tracked or just sometimes?
Is it particular functions or random?


and this is strange for me.
I have few DBs with the same function (copy -> paste), in one DB they are tracked (visible in pg_stat_user_functions) in other not. In DB where some functions are not tracked, others are visible - no issue. I cannot find any logical connection between function structure and visibility in pg_stat_user_functions.

Regards,
Bartek

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: Optimizing select count query which often takes over 10 seconds
Next
From: Alexander Farber
Date:
Subject: Re: Optimizing select count query which often takes over 10 seconds