From: | "Campbell, Lance" <lance(at)uiuc(dot)edu> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | pg_stat_all_indexes |
Date: | 2007-11-02 15:17:00 |
Message-ID: | B10E6810AC2A2F4EA7550D072CDE8760197DD1@SAB-FENWICK.sab.uiuc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
PostgreSQL: 8.2.4
I did the following query on my database:
select * from pg_stat_all_indexes;
My hope was to see if my indexes are being used. The values I got were
all 0's for the columns: idx_scan, idx_tup_read, and idx_tup_fetch.
Is there a different query to tell me how often indexes are being used?
My postgresql.conf file settings are:
#-----------------------------------------------------------------------
----
# RUNTIME STATISTICS
#-----------------------------------------------------------------------
----
# - Query/Index Statistics Collector -
#stats_command_string = on
#update_process_title = on
#stats_start_collector = on # needed for block or row stats
# (change requires restart)
#stats_block_level = off
#stats_row_level = off
#stats_reset_on_server_start = off # (change requires restart)
# - Statistics Monitoring -
#log_parser_stats = off
#log_planner_stats = off
#log_executor_stats = off
#log_statement_stats = off
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-11-02 15:25:01 | Re: jumpstart - pgsql.v824 |
Previous Message | Peter Childs | 2007-11-02 15:15:14 | Re: jumpstart - pgsql.v824 |