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.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to