On Tue, Jul 22, 2014 at 4:36 AM, Rebecca Clarke 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
On Tue, Jul 22, 2014 at 2:45 AM, Guillaume Lelarge
wrote:
> Unfortunately, no. Even with the latest release. pg_stat_activity shows you
> what the client fires, not what the server does.
pg_stat_statements has a "track" GUC which controls whether or not
nested statements, such as statements exec
Hi,
2014-07-22 11:36 GMT+02:00 Rebecca Clarke :
> 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_act
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 adva
