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.
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.