Postgres Pro
Downloads
Home   >   mailing lists

Current query of the PL/pgsql procedure. - Mailing list pgsql-performance

From Yuri Levinsky
Subject Current query of the PL/pgsql procedure.
Date
Msg-id C9278837BA426D4DBDF8996DB89023260B685B@Cobra.celltick.com
Whole thread Raw
Responses Re: Current query of the PL/pgsql procedure.  (Craig James <cjames@emolecules.com>)
Re: Current query of the PL/pgsql procedure.  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: Current query of the PL/pgsql procedure.  (Matheus de Oliveira <matioli.matheus@gmail.com>)
List pgsql-performance
Tree view

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

 

Attachment

pgsql-performance by date:

Previous
From: Bryce Covert
Date:
Subject: Re: Slow query due to slow I/O
Next
From: Craig James
Date:
Subject: Re: Current query of the PL/pgsql procedure.