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.
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 по дате отправления: