What query currently running within function

Поиск
Список
Период
Сортировка
От Rebecca Clarke
Тема What query currently running within function
Дата
Msg-id CAMChtdcDM-kRCbND=1=umQ1JhmjrfCRf9R=UWXQPnCSL6a1nUQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: What query currently running within function
Re: What query currently running within function
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: "vibhor.kumar@enterprisedb.com"
Дата:
Сообщение: Re: inequality testing in jsonb query
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: What query currently running within function