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

Reply via email to