Hi, 2014-07-22 11:36 GMT+02:00 Rebecca Clarke <r.clark...@gmail.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
