Re: BUG #14162: No statistics for functions used as aggregates
От | Michael Paquier |
---|---|
Тема | Re: BUG #14162: No statistics for functions used as aggregates |
Дата | |
Msg-id | CAB7nPqRwvFnEtUOH2XrWfghCk-PR4n8DP4zMJQ8duzQK2wc3DQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: BUG #14162: No statistics for functions used as aggregates (Daniel Migowski <dmigowski@ikoffice.de>) |
Ответы |
Re: BUG #14162: No statistics for functions used as
aggregates
|
Список | pgsql-bugs |
On Mon, May 30, 2016 at 4:56 PM, Daniel Migowski <dmigowski@ikoffice.de> wr= ote: > Yes, I am sure. To measure my function I had to recreate it with a differ= ent name, and create a plpgsql wrapper function with the original signature= that calls it. Now I was able to get my results and the function showed up= in the stats. The wrapper didn't! (please do not top-post it breaks the logic of the thread). Ah I see I got confused, nodeAgg.c does not track statistics of the transition or final functions when an aggregate is invoked, and has never done it. There is no call to pgstat_init_function_usage() when FunctionCallInvoke() is called so you cannot track statistics regarding that. Maybe that would be a interesting feature, but controlled by a different GUC than track_functions. -- Michael
В списке pgsql-bugs по дате отправления: