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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
