Re: Least and most accessed tables in a database..

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.