We help IT Professionals succeed at work.

postges, how to get time when the table was last updated

rgbcof asked
How to get the time of when a particular table was last updated, had row inserted, or row deleted?
Watch Question


Unfortunately there is nothing stored in pg that holds this information.
However , you can add a timestamp column to your table and update it via a trigger or a part of the SP code that updates your table (if you use SP for that)


I looked for it too, but couldn't find any.  Thanks for your confirmation. I did find add, update, and delete count statistic for each table, so I can use those.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.