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