Re: CLUSTER VERBOSE (9.1.3)

On Mon, Mar 5, 2012 at 4:40 PM, Larry Rosenman <ler(at)lerctr(dot)org> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Is there any way to get more info out of CLUSTER VERBOSE so it says
> what index it's working on AFTER the table re-write?
>
> INFO:  clustering "public.values" using sequential scan and sort
> INFO:  "values": found 0 removable, 260953511 nonremovable row
> versions in 4224437 pages
> DETAIL:  0 dead row versions cannot be removed yet.
> CPU 168.02s/4324.68u sec elapsed 8379.12 sec.
>
>
> And at this point it's doing something(tm), I assume re-doing the indexes.
>
> It would be nice(tm) to get more info.
>
> Ideas?

Try setting client_min_messages=DEBUG1. At least on current sources
that gives some additional, relevant output; I think that's probably
there in 9.1.x as well.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company