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

Rajzz

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

Pravesh

 

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?

Rajzz

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. 

Pravesh

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.