Current query of the PL/pgsql procedure.

From: Yuri Levinsky <yuril(at)celltick(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Current query of the PL/pgsql procedure.
Date: 2013-12-15 16:18:18
Message-ID: C9278837BA426D4DBDF8996DB89023260B685B@Cobra.celltick.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dear ALL,
I am running PL/pgsql procedure with sql statements that taking a long time. I able to see them in the log just after their completion. How can I see currently running SQL statement? I am able to see in pg_stat_activity only my call to function. Many thanks in advance.

Sincerely yours,

[Description: Celltick logo_highres]
Yuri Levinsky, DBA
Celltick Technologies Ltd., 32 Maskit St., Herzliya 46733, Israel
Mobile: +972 54 6107703, Office: +972 9 9710239; Fax: +972 9 9710222

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig James 2013-12-15 18:05:10 Re: Current query of the PL/pgsql procedure.
Previous Message Bryce Covert 2013-12-13 00:03:09 Re: Slow query due to slow I/O