Identifying old/unused views and table

Поиск
Список
Период
Сортировка
От Jason Long
Тема Identifying old/unused views and table
Дата
Msg-id 1317156710.29484.4.camel@localhost.localdomain
обсуждение исходный текст
Ответы Re: Identifying old/unused views and table
Список pgsql-general
I have an application with a couple hundred views and a couple hundred
tables.

Is there some way I can find out which views have been accessed in the
last 6 months or so?  Or some way to log this?

I know there are views and tables that are no longer in used by my
application and I am looking for a way to identify them.


В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Broersma
Дата:
Сообщение: Re: live metadata changes v8.3.4
Следующее
От: David North
Дата:
Сообщение: bytea columns and large values