Monitoring Network Performance - Query Needed


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.


Please suggest.


Thank You


Ujjwal Rana




  • Options


    • Use Vertica provides Vnetperf utility.

    Example :

     /opt/vertica/bin/vnetperf --condense --hosts, --identity-file '/root/.ssh/vid_rsa'


  • Options
    SruthiASruthiA Vertica Employee Administrator



      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




  • Options

    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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file