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/ ---------------------------(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