Least and most accessed tables in a database..

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Least and most accessed tables in a database..
Date: 2003-03-19 11:08:05
Message-ID: 200303191638.05331.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-03-19 12:11:48 Re: Least and most accessed tables in a database..
Previous Message Shanmugasundaram Doraisamy 2003-03-19 07:08:59 How to stop a particular database - reg.