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.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.