May 2018
Intermediate to advanced
576 pages
30h 25m
English
The table_file_access_info(schemaname, tablename) function returns the last access and modification times for a given table using the filesystem as a source of information.
The last query uses this data to get the latest time any of these files were modified or read by PostgreSQL. Beware that this is not a very reliable way to get information about the latest use of any table, but it gives you a rough upper-limit estimate about when it was last modified or read (for example, consider the autovacuum process accessing a table).
You can definitely improve and personalize the preceding function. I advise you to look at the PostgreSQL documentation and read about two built-in functions, pg_ls_dir(dirname text) and pg_stat_file(filename ...