Re: CLUSTER VERBOSE (9.1.3)
| От | Robert Haas |
|---|---|
| Тема | Re: CLUSTER VERBOSE (9.1.3) |
| Дата | |
| Msg-id | CA+TgmobgfJgc2G7onQVq2gUThxTavCmBe6CFgZkaBLfhxMR4Sg@mail.gmail.com обсуждение исходный текст |
| Ответ на | CLUSTER VERBOSE (9.1.3) (Larry Rosenman <ler@lerctr.org>) |
| Ответы |
Re: CLUSTER VERBOSE (9.1.3)
|
| Список | pgsql-hackers |
On Mon, Mar 5, 2012 at 4:40 PM, Larry Rosenman <ler@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
В списке pgsql-hackers по дате отправления: