| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: What query currently running within function |
| Date: | 2014-07-31 13:18:45 |
| Message-ID: | CAHyXU0yge+iHxR_sH0FvL=9dvCigFdPHpL39B6vj9x66LXbofA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jul 22, 2014 at 4:36 AM, Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com> 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 the _myfunction()
> query.
>
> I'm running postgresql 9.1
>
> Thanks in advance.
raise notices or warnings in the log. if the function is sql and
not pl/pgsql, you can wrap the RAISE feature.
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2014-07-31 13:24:04 | Re: String concatenation operator which keeps trailing spaces in CHAR(n) columns |
| Previous Message | Merlin Moncure | 2014-07-31 13:17:04 | Re: String concatenation operator which keeps trailing spaces in CHAR(n) columns |