According to docs, analyze ,by default, will try to sample 30000 rows from a table.
(I've read analyze.c note about Haas and Stokes IBM Research ).
But my question is, why does 'analyze verbose' report that it has scanned '30000 of NNNN pages, containing NNNN live rows and 0 dead rows; 30000 rows in sample,....'
As most tables would store more than 1 row per page, I expected that 30000 rows would require a lot fewer than 30000 pages to be scanned. Why is it saying it's scanned 30000 pages instead of only 30000 rows ?
Confused. thanks.