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,
0
Comments
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
NC