Re: What query currently running within function - Mailing list pgsql-general

On Tue, Jul 22, 2014 at 4:36 AM, Rebecca Clarke <r.clarke83@gmail.com> wrote:
> Hi all,
>
> Presently I'm executing a function that runs many queries within it.
>
> select * from _myfunction();
>
> Is there a way to see what query it is up to within the function?
> When I do a select of pg_stat_activity it just shows me the _myfunction()
> query.
>
> I'm running postgresql 9.1
>
> Thanks in advance.

raise notices or warnings in the log.    if the function is sql and
not pl/pgsql, you can wrap the RAISE feature.

merlin