Postgres Pro
Downloads
Home   >   mailing lists

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

From Rebecca Clarke
Subject What query currently running within function
Date
Msg-id CAMChtdcDM-kRCbND=1=umQ1JhmjrfCRf9R=UWXQPnCSL6a1nUQ@mail.gmail.com
Whole thread Raw
Responses Re: What query currently running within function  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: What query currently running within function  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: "vibhor.kumar@enterprisedb.com"
Date:
Subject: Re: inequality testing in jsonb query
Next
From: Guillaume Lelarge
Date:
Subject: Re: What query currently running within function