Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #14162: No statistics for functions used as aggregates - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #14162: No statistics for functions used as aggregates
Date
Msg-id CAB7nPqR=bRraNG2Vp4FUukjA9QOJsRouh-skGzRjrtHR9ArQNA@mail.gmail.com
Whole thread Raw
In response to BUG #14162: No statistics for functions used as aggregates  (dmigowski@ikoffice.de)
Responses Re: BUG #14162: No statistics for functions used as aggregates  (Daniel Migowski <dmigowski@ikoffice.de>)
List pgsql-bugs
Tree view 
On Sat, May 28, 2016 at 10:52 PM,  <dmigowski@ikoffice.de> wrote:
> I created some user defined aggregate with a user defined plpgsql SFUNC.
>
> The calls to plpgsql functions used in these aggregates are not counted by
> the statistics collector when the aggregate is used, but calling them
> directly will work.

Are you sure that track_functions is enabled? If it disabled by
default. In order to track the number of calls of user-defined
functions it needs to be set to "pl" or "all".
--
Michael

pgsql-bugs by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: ram consumption
Next
From: Daniel Migowski
Date:
Subject: Re: BUG #14162: No statistics for functions used as aggregates