May 2018
Intermediate to advanced
576 pages
30h 25m
English
The pg_stat_user_tables view shows the current statistics for table usage.
To see whether a table is used, you check for changes in its usage counts.
The previous query selects all the tables where any of the usage counts for SELECT or data manipulation have changed.