Re: What query currently running within function

[Guillaume Lelarge <guillaume@xxxxxxxxxxxx>]

Hi,

2014-07-22 11:36 GMT+02:00 Rebecca Clarke <r.clarke83@xxxxxxxxx>:

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