Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

tracking object changes in Vertica

Is there a way to find out who made the latest modification to an object such as a table or view in release 7.1?



  • There are two types of objects whose last modified time is recorded.


    In the system table PROJECTION_DELETE_CONCERNS: 

    Lists projections whose design may cause performance issues when deleting data. This table is generated by calling the EVALUATE_DELETE_PERFORMANCE function.


    In the system table COMMENTS, which contains information about comments associated with objects in the database.


    Hope that helps,



  • Although the retention may be limited, you may want to try looking in query_requests:


    select start_timestamp, user_name, request from query_requests where request_type = 'DDL';

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.