Postgres Pro
Downloads
Home   >   mailing lists

Least and most accessed tables in a database.. - Mailing list pgsql-admin

From Rajesh Kumar Mallah
Subject Least and most accessed tables in a database..
Date
Msg-id 200303191638.05331.mallah@trade-india.com
Whole thread Raw
Responses Re: Least and most accessed tables in a database..  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: Shanmugasundaram Doraisamy
Date:
Subject: How to stop a particular database - reg.
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: Least and most accessed tables in a database..