Re: How to find the table which is not used in recent 3 month?

Поиск
Список
Период
Сортировка
От Prince Pathria
Тема Re: How to find the table which is not used in recent 3 month?
Дата
Msg-id CAON0Daz4qZCaoYZOm66e4NxZp0=yPxJdbEu8+e5eRXZ4G9j1dw@mail.gmail.com
обсуждение исходный текст
Ответ на How to find the table which is not used in recent 3 month?  (Frantz Song <frantz.song@gmail.com>)
Ответы Re: How to find the table which is not used in recent 3 month?
Список pgsql-admin
Дерево обсуждения
Hi Frantz,

For the same thing we have enabled "pg_stat_statements" on postgresql.conf. 
If you are not using "pg_stat_statements" as of now, sadly you're left with 2 options
1. Slow logs with lower response time, if you have enabled them, though not much trustworthy.
2. Grep in application logs of all apps using postgres as database backend.

Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com


On Mon, Dec 31, 2018 at 11:59 AM Frantz Song <frantz.song@gmail.com> wrote:
Dear all,

I'm use postgresql 9.6, it have 800+tables and some of them is not frequently used. 
How to find the table which is not used in recent 3 month? 

Thanks!

--
P Help save trees...please don't print this e-mail unless you really need to.

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

Предыдущее
От: Adarsh Sharma
Дата:
Сообщение: Re: How to find the table which is not used in recent 3 month?
Следующее
От: Sylvain Fauvel
Дата:
Сообщение: Re: How to find the table which is not used in recent 3 month?