Query log table in Vertica

What is the equivalent table of DBC query log (teradata) in Vertica? I'm looking for queries executed & their stats like total time taken,query name & resources used etc so far by my user. I thought query_requests or dc_requests_issued will give what i want but no luck. Note: I hope query profiling is not mandatory for viewing history of queries executed and their stats,


  • Options
    Navin_CNavin_C Vertica Customer
    Hi Mahesh,

    You can use any of these tables:
    1. Query_profiles
    2. Query_Events
    3. Execution_Engine_profiles(Detailed)

    Query profiling is not mandatory, but in order for the system tables to retrieve very old data, you need to increase the data collector policies for system tables

    Hope this helps

Leave a Comment

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