| From: | "vinita bansal" <sagivini(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | generating statistics |
| Date: | 2005-03-16 14:08:49 |
| Message-ID: | BAY20-F30AAA8C0E64D3D2BBEE3BCCB480@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | FERREIRA William (COFRAMI) | 2005-03-16 14:17:57 | plPerl subroutine |
| Previous Message | Richard Huxton | 2005-03-16 13:51:51 | Re: 2 questions about types |