What query currently running within function

From: Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: What query currently running within function
Date: 2014-07-22 09:36:34
Message-ID: CAMChtdcDM-kRCbND=1=umQ1JhmjrfCRf9R=UWXQPnCSL6a1nUQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2014-07-22 09:45:19 Re: What query currently running within function
Previous Message vibhor.kumar@enterprisedb.com 2014-07-22 02:51:07 Re: inequality testing in jsonb query