| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | vinita bansal <sagivini(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: generating statistics |
| Date: | 2005-03-16 15:21:40 |
| Message-ID: | 20050316152140.GA24504@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Miroslav Šulc | 2005-03-16 15:28:11 | Re: psql file restore - problem with encoding |
| Previous Message | John DeSoi | 2005-03-16 15:19:12 | Re: psql file restore - problem with encoding |