Re: generating statistics

On Wed, Mar 16, 2005 at 02:08:49PM +0000, vinita bansal wrote:

> I have set the following variables in postgresql.conf to true:
> stats_start_collector,stats_command_string, stats_row_level,
> stats_reset_on_server_start.

Did you uncomment the settings in addition to setting them to true?

> I am trying to get a list of all used indices and referenced tables in the
> database for a particular run. According to the doc. the following tables
> should contain this information: pg_stat_user_indexes, pg_stat_all_tables.
> But, these tables are not getting populated.

Did you restart the database after making the configuration changes?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/