I wonder if there if it is possible to monitor the network performance from vertica database ? I am looking for the query statement inorder to monitor the network performance.
/opt/vertica/bin/vnetperf --condense --hosts 10.20.100.66,10.20.100.67 --identity-file '/root/.ssh/vid_rsa'
Adding to what Adiran has mentioned, There is a system table called network_usage which contains history of network bandwidth usage.
select * from network_usage;
For more information, Please refer to http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/MONITOR/NETWORK_USAGE.htm?Highlight=network_usage
Be careful with what Adrian suggested. That simulates Vertica network activity, it is to see the network throughput not to monitor the network activity. Actually it will add A LOT of network traffic while you run it. So it is to measure performance not to monitor network performance during your cluster activity. Actually is recommended to measure that performance when the db is down.