Le 23/02/2011 09:10, salah jubeh a écrit :
> [...]
> This is a simple way to check if there is no activity on the table,
>
> SELECT relname,seq_tup_read,idx_tup_fetch FROM pg_stat_user_tables
> WHERE (idx_tup_fetch + seq_tup_read)= 0;
>
>
> Is there is any way to make similar checks on views
>
No, there's no stats on views.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com