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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
