On Mon, May 14, 2007 at 11:09:21AM -0700, Y Sidhu wrote: > The stats_block_level and stats_row_level are NOT enabled. The question is > how to use pg_stats. Do I access/see them via the ANALYZE command? or using > SQL. I cannot find any document which will get me started on this.
Ok, we're both confused I think... I thought you were talking about the pg_stat* views, which depend on the statistics collector (that's what the stats_* parameters control). That actually has nothing at all to do with pg_stats or pg_statistics. Those deal with statistics about the data in the database, and not about statistics from the engine (which is what the pg_stat* views do...). If you want to know about pg_stats, take a look at http://www.postgresql.org/docs/8.2/interactive/view-pg-stats.html ... but normally you shouldn't need to worry yourself about that. Are you trying to debug something? Information about the backend statistics can be found at http://www.postgresql.org/docs/8.2/interactive/monitoring.html -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate