io_usage history is much shorter then network usage

K_Krutiy

I am trying to analyze resource usage on my system

I am looking at

io_usage
network_usage
cpu_usage
etc


I was surprised to find out that io_usage history is much shorter then network usage

I can get only 299 records from io_usage.
With each record covers 1 minute my history for IO is only 299 minutes

From network_usage I can get 5365 records.
So I have as much as 20x longer history for NETWORK.


Is it possible to increase retention for io_usage to several days ?

Abhishek_Rana

Hi,

io_usage is not a data collector table, so information in it will keep on flushing . To get information for history of io_usage, you can refer to dc_io_info data collector table .

Regards'

Abhishek

Prasanta_Pal

Check out this link about datacollector table and data retention policies

https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/MONITOR/DATA_COLLECTOR.htm%3FTocPath%3DSQL%20Reference%20Manual|HP%20Vertica%20System%20Tables|V_MONITOR%20Schema|_____9

and
https://my.vertica.com/docs/7.0.x/HTML/index.htm#Attic/Troubleshooting/ConfiguringDataRetentionPolic...