Hi,
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.
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. Do I need to set something else to be able to get this information??
Regards, Vinita Bansal
_________________________________________________________________
Get headhunted by 5000 tech recruiters. http://www.naukri.com/tieups/tieups.php?othersrcp=736 Post your CV on naukri.com.
---------------------------(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
