Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

how to calculate TPS of insert/update and delete, IO tps, network tps

how to calculate TPS of insert/update and delete, IO tps, network tps in vertica.

basically i want see the performance of the my db for a particular time.

 

Thanks in advance.

 

Raj

Comments

  •  

    Did you check system tables like "dc_requests_issued", "dc_io_info_by_second" & "dc_network_info_by_second".

     

    Or have you already checked these and it didn't help?

  • Thanks for the pravesh,

     

    Yes i checked these tables. But I am unawarw that which column to consider in both io_info and network_info tables. 

  • I think you will need columns "total_read_bytes_start_value", "total_read_bytes_end_value" and "start_time", "end_time".

     

    Difference of "total_read_bytes_end_value" and "total_read_bytes_start_value" for a time duration (end_time - start_time) should give you total read bytes.

     

    Similarly, you can calculate total written bytes (total_written_bytes_end_value and total_written_bytes_start_value).

     

    For network usage, similar columns would be "tx_bytes_*_value" and "rx_bytes_*_value".

     

    You can also refer to system views "io_usage" and "network_usage" which are built upon the same system tables and simple to understand. However, they will give you minute wise information.

     

    Hope this helps.

     

     

     

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.