From: Yuri Levinsky <yuril@celltick.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Current query of the PL/pgsql procedure.
Date: Sun, 15 Dec 2013 16:18:18 +0000
Message-ID: <C9278837BA426D4DBDF8996DB89023260B685B@Cobra.celltick.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
Attachments:image003.jpg (image/jpeg, 2.2K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: yuril@celltick.com
Subject: Re: Current query of the PL/pgsql procedure.
In-Reply-To: <C9278837BA426D4DBDF8996DB89023260B685B@Cobra.celltick.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox