Least and most accessed tables in a database..
Least and most accessed tables in a database..
От:
Rajesh Kumar Mallah <mallah@trade-india.com>
Дата:
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.
Re: Least and most accessed tables in a database..
От:
Rajesh Kumar Mallah <mallah@trade-india.com>
Дата:
my GUC is configured like this: # # Access statistics collection # stats_start_collector = true stats_reset_on_server_start = true stats_command_string = true stats_row_level = true #stats_block_level = false how come there is not a single row in pg_statio_user_tables any of the stat is having a non zero value ? tradein_clients=# SELECT schemaname,relname,heap_blks_read,heap_blks_hit from pg_statio_user_tables where ( heap_blks_read > 0 or heap_blks_hit >0 or idx_blks_read >0 or idx_blks_hit > 0 or toast_blks_read > 0 or toast_blks_hit > 0 or tidx_blks_read > 0 or tidx_blks_hit > 0 ); +------------+---------+----------------+---------------+ | schemaname | relname | heap_blks_read | heap_blks_hit | +------------+---------+----------------+---------------+ +------------+---------+----------------+---------------+ (0 rows) Regds Mallah. On Wednesday 19 Mar 2003 4:38 pm, Rajesh Kumar Mallah wrote: > 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 > > -- 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.
Re: Least and most accessed tables in a database..
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Rajesh Kumar Mallah writes: > #stats_block_level = false > how come there is not a single row in pg_statio_user_tables > any of the stat is having a non zero value ? statio is block-level statistics, no? regards, tom lane
Re: Least and most accessed tables in a database..
От:
<mallah@trade-india.com>
Дата:
yes it does work after making it true. but am i in the right track in solving my problem? regds mallah. > Rajesh Kumar Mallah writes: >> #stats_block_level = false > >> how come there is not a single row in pg_statio_user_tables >> any of the stat is having a non zero value ? > > statio is block-level statistics, no? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' > the postmaster ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/