Hi Team,
I've a question from customer who is running Vertica 9.2 about the query that running during Vertica node down will complete very slow. For example, this query will complete within 1 minute during normal situation. But if there's a Vertica node down (maybe from H/W failure) during this query is running, it will run finish more than 15 minutes.
Do we have any parameters to help on this?
Thank you.
Best Regards,
Sittisak Jongvattanasiri
Get the query transaction_id and statement_id and run the below query will show on which step it's taking max time.
select node_name, execution_step, max(completion_time - time) as total_time from dc_query_executions where transaction_id= and statement_id= group by 1,2;
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
