On Mon, Mar 5, 2012 at 4:40 PM, Larry Rosenman <l...@lerctr.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
