Least and most accessed tables in a database..

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема Least and most accessed tables in a database..
Дата
Msg-id 200303191638.05331.mallah@trade-india.com
обсуждение исходный текст
Ответы Re: Least and most accessed tables in a database..  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Список pgsql-admin
Hi ,

Is there anyway to know which tables are least/most  accessed
in a database?

My original problem is that there are too my stray tables in my database
which i want to get rid of. i thought the tables which are least accessed
may be a good candidate for deletion.

just a thought does pg_statio_user_tables help ?

regds
mallah.




--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Shanmugasundaram Doraisamy
Дата:
Сообщение: How to stop a particular database - reg.
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: Least and most accessed tables in a database..