Not having found anything so far, does anyone know of, and can point me
to, either tools, or articles, that talk about doing tuning based on the
information that this sort of information can help with?
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EM
All,
Since I have not seen any follow up post,
I am wondering if my question is not clear or
what.
Anyway, my postgres version is 7.3.2, and I
want to know:
1. How to determine if some of indexes are used by
any queries, like Oracle's:
alter index my_index monitoring usage
2. The relationship bet
Hi,
I have query:
select pg_stat_get_numscans(76529669),
pg_stat_get_blocks_fetched(76529669),
pg_stat_get_blocks_hit(76529669);
The result is:
pg_stat_get_numscans | pg_stat_get_blocks_fetched |
pg_stat_get_blocks_hit
--++