Transaction progress

From: Pablo Yaggi <pyaggi(at)aulamagna(dot)com(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: Transaction progress
Date: 2003-01-19 17:53:49
Message-ID: 200301191453.49707.pyaggi@aulamagna.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 24 hours,
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.remuneracion from inars_rectificaciones b2 where inars_nocontrib_perm1.cuil=b2.cuil and inars_nocontrib_perm1.cuit=b2.cuit and inars_nocontrib_perm1.ano=b2.ano and inars_nocontrib_perm1.mes=b2.mes;

Thank's in advance,

Pablo Yaggi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mike 2003-01-19 20:35:58 problems configuring with readline and zlib
Previous Message Ben-Nes Michael 2003-01-19 16:24:05 libpq.so.2.2 & libpq.so.3.0