Once you know that a table is not currently used, the next question is When was it last used?
Knowing when a table was last used
Getting ready
Using 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 possibilities, neither of which...
