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,
+2Hi 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
NC
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
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
