Once you know that a table is not currently being used, the next question is, When was it last used?
Knowing when a table was last used
Getting ready
You need to use a user with appropriate privileges.
How to do it…
PostgreSQL does not have any built-in last used information about tables, so you have to use other means to figure it out.
If you have set up a cron job to collect usage statistics, as described in the previous chapter, then it is relatively easy to find out the last date of change using a SQL query.
Other than this, there are basically two...
