Transaction progress - Mailing list pgsql-general

From Pablo Yaggi
Subject Transaction progress
Date
Msg-id 200301191453.49707.pyaggi@aulamagna.com.ar
Whole thread Raw
Responses Re: Transaction progress
List pgsql-general
Hi,
is there any way to know a transaction progress state ? I'm executing queries from psql and I have a query running for
24hours, 
and I don't know when It will end, is there any way I could know it ?
if not, can I estimate the time from the explain result ? how ?
this is the explain result about the query I'm running:

Hash Join  (cost=100347487.59..145240934.03 rows=26 width=60)
  ->  Index Scan using inars_rectificaciones_inx on inars_rectificaciones b2  (cost=0.00..37839140.62 rows=9546466
width=34)
  ->  Hash  (cost=100347379.07..100347379.07 rows=43407 width=26)
        ->  Seq Scan on inars_nocontrib_perm1  (cost=100000000.00..100347379.07 rows=43407 width=26)

and this is the query:

update inars_nocontrib_perm1  set
rectificada=TRUE,actividad=b2.actividad,presentacion=b2.presentacion,remuneracion=b2.remuneracionfrom
inars_rectificacionesb2 where inars_nocontrib_perm1.cuil=b2.cuil and inars_nocontrib_perm1.cuit=b2.cuit and
inars_nocontrib_perm1.ano=b2.anoand inars_nocontrib_perm1.mes=b2.mes; 

Thank's in advance,

Pablo Yaggi


pgsql-general by date:

Previous
From: "Ben-Nes Michael"
Date:
Subject: libpq.so.2.2 & libpq.so.3.0
Next
From: mike
Date:
Subject: problems configuring with readline and zlib