interpret vacuum verbose output
От | Shankar K |
---|---|
Тема | interpret vacuum verbose output |
Дата | |
Msg-id | 20030604164557.24757.qmail@web21102.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: interpret vacuum verbose output
Re: interpret vacuum verbose output |
Список | pgsql-admin |
hi all, I'm trying to evaluate the frequecy to run vacuum analyze on key tables. so if anyone could help me to interpret the output of vacuum analyze verbose output that would be great. below is the output of one of our major indexes. INFO: --Relation public.accounts-- INFO: Index accounts_u1: Pages 1503; Tuples 231: Deleted 55448. CPU 0.01s/0.14u sec elapsed 0.15 sec. INFO: Index account_u1: Pages 1997; Tuples 231: Deleted 55448. CPU 0.01s/0.13u sec elapsed 0.15 sec. INFO: Index account_u2: Pages 2415; Tuples 231: Deleted 55448. CPU 0.00s/0.14u sec elapsed 0.30 sec. INFO: Removed 55448 tuples in 2367 pages. CPU 0.04s/0.11u sec elapsed 0.41 sec. INFO: Pages 11266: Changed 4, Empty 0; Tup 231: Vac 55448, Keep 0, UnUsed 205434. Total CPU 0.12s/0.56u sec elapsed 1.08 sec. thanks Shankar __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
В списке pgsql-admin по дате отправления: