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