I see that some of the queries are shown twice in the query_requests table (exactly same stmt.) and both have the success as true.
Was it executed twice or just the entry in the query_requests table ,if so why ?
The combination of TRANSACTION_ID, STATEMENT_ID, and REQUEST_ID uniquely identifies a statement within a session.
Can you share those values and the node_name?
Here are the details
Since the request ids are different does that mean the same statement is being executed twice ?
Since you have SET SESSION AUTOCOMMIT TO on;
The STATEMENT_ID is not incremented.
The incremented REQUEST_ID shows it is probably a different INSERT request.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.