Re: BUG #14162: No statistics for functions used as aggregates

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: dmigowski(at)ikoffice(dot)de
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14162: No statistics for functions used as aggregates
Date: 2016-05-30 03:53:12
Message-ID: CAB7nPqR=bRraNG2Vp4FUukjA9QOJsRouh-skGzRjrtHR9ArQNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sat, May 28, 2016 at 10:52 PM, <dmigowski(at)ikoffice(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Migowski 2016-05-30 07:56:46 Re: BUG #14162: No statistics for functions used as aggregates
Previous Message Mark Kirkwood 2016-05-29 10:36:07 Re: ram consumption