Skip to main content

how to find vertica write per sec

  • March 28, 2014
  • 3 replies
  • 23 views

Sai_Pasupulati
how to find vertica write per sec i am using this query to find
SELECT  node_name,
  round(min(start_time), 'MI') as start_time,
  round(max(end_time), 'MI') as end_time,
  round( ( (sum(total_read_bytes_end_value - total_read_bytes_start_value) / 1024) / 
           (datediff('millisecond', min(start_time), max(end_time)) / 1000.0) )::float, 2) as read_kbytes_per_sec,
  round( ( (sum(total_written_bytes_end_value - total_written_bytes_start_value) / 1024) / 
           (datediff('millisecond', min(start_time), max(end_time)) / 1000.0) )::float, 2) as written_kbytes_per_sec FROM v_internal.dc_io_info_by_minute GROUP BY node_name, round(start_time, 'MI') ORDER BY 2 desc ; 


3 replies

zvika_gutkin
Forum|alt.badge.img
  • Participating Frequently
  • March 28, 2014
Hi ,
you can use system_resource_usage which give you avg cpu , memory ,network sent and receive and also I/O read & write per minute.

Hope that helps 

Zvika

Sai_Pasupulati
  • Author
  • Participating Frequently
  • March 28, 2014
Thank Zvika, it is very helpfull.
 I/O read & write per minute we get in io_read_kbytes_per_second,io_written_kbytes_per_second.
is there way to convert these numbers into rows per second.


zvika_gutkin
Forum|alt.badge.img
  • Participating Frequently
  • March 29, 2014
try query_profiles .

it will give you for non executing queries the num rows processed and the time the query ran .
then you will be able to see the rows/sec for the query .

Zvika