Hi,
2014-07-22 11:36 GMT+02:00 Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com>:
> 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?
>
Unfortunately, no. Even with the latest release. pg_stat_activity shows you
what the client fires, not what the server does.
> 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.
>
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com