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);
>
