Skip site navigation (1) Skip section navigation (2)

Re: Percent of update completed

From: Colin McGuigan <cmcguigan(at)earthcomber(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Percent of update completed
Date: 2005-02-07 18:45:12
Message-ID: 4207B738.9040501@earthcomber.com (view raw or flat)
Thread:
Lists: pgsql-novice
Tom Lane wrote:
> Not directly, but if you use the contrib/pgstattuple module you can get
> readings on the numbers of committed and uncommitted tuples in the
> table.  The rate at which the uncommitted-tuples count increases would
> tell you how fast the update is proceeding.  (You should probably not
> assume that you started with zero uncommitted tuples, unless you know
> you'd vacuumed the table just beforehand.)

Thanks, Tom.

I've run it, and I see the dead_tuple_count, but I don't see an 
uncommitted count.  The dead_tuple_count seems to oscillate, too -- it 
increases slowly, but sometimes decreases immediately after.  Is that 
normal?

I don't see an uncommitted tuples count, though.

--Colin McGuigan

In response to

pgsql-novice by date

Next:From: John ZwiebelDate: 2005-02-07 22:34:29
Subject: psql regular expression matching POSIX
Previous:From: Michael FuhrDate: 2005-02-07 16:26:32
Subject: Re: simple query question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group