Low query performance - load interconnect interface
Need help, I can not find the cause of abnormal behavior.
I have two same 6 nodes cluster :
1 cluster - Vertica 220.127.116.11 CentOS 6.9
2 cluster - Vertica 18.104.22.168 CentOS 7.3
I run test query, result for 1 cluster ~6 sec, for 2 cluster ~ 67 sec.
EXPLAIN for sql does not differ.
In the monitoring system, when I run the query, I see that for the 2 cluster there is a load on the network 30-70MB/s on the interconnect interface.
On 1 cluster this behavior is not observed.
How can I find the reason for this behavior?