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