The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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.
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.