Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Is there a monitoring table available with the last-touch timestamp for a table?
Is it possible to somehow find out the last-touch time for a table in vertica, possibly via some kind of a monitor table? The use case I am trying to solve for is when using some "cache" type tables for reports which I want to linger while their being active, but if no query's touched the table for X amount of time, I want to have a garbage-collection procedure drop the table.