Re: Minor verbosity increase for analyze
| От | Bruce Momjian |
|---|---|
| Тема | Re: Minor verbosity increase for analyze |
| Дата | |
| Msg-id | 200308261538.h7QFco607286@candle.pha.pa.us обсуждение исходный текст |
| Ответ на | Minor verbosity increase for analyze (Mark Kirkwood <markir@paradise.net.nz>) |
| Список | pgsql-patches |
Newest version of patch applied. Thanks. --------------------------------------------------------------------------- Mark Kirkwood wrote: > Attached is a (very small) patch to make analyze display some > interesting info in > verbose mode about the analyzed relation (pages, rows per block and rows ). > > This is all available in the statistics catalog but I have found it > useful to see it appear as > you run... > > mods to : > > src/backend/commands/analyze.c > > plain diff against current CVS (31/07/2003 NZST) > > Best wishes > > Mark > > > 696a697,702 > > /* > > * emit some interesting relation info > > */ > > elog(elevel, " pages = %d rows/page = %d rows = %d", > > onerel->rd_nblocks, (int)tuplesperpage, (int)*totalrows); > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-patches по дате отправления: