We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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