Ways to check the status of a long-running transaction

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Ways to check the status of a long-running transaction
Date: 2005-01-20 04:06:44
Message-ID: 20050120040644.GA67721@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

I recall this being discussed before, but I couldn't manage to find it
in the archives.

Is there any way to see how many rows a running transaction has written?
vacuum analyze verbose only reports visible rows.
--
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex 2005-01-20 04:20:26 Re: Unique Index
Previous Message Chris Travers 2005-01-20 03:46:13 Would a wiki help newbies?

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2005-01-20 04:57:12 Re: Ways to check the status of a long-running transaction
Previous Message Hannu Krosing 2005-01-20 01:32:09 Re: US Patents vs Non-US software ...