ifstats_rate (raw poll data)
ifstats_ltd (hourly rollup)
ifstats_eqd (daily rollup)
ifstats_gtd (weekly rollup)
Original Message:
Sent: 07-29-2020 05:49 AM
From: Bruno Sousa
Subject: Vertica tables doubt
Thank you for the feedback, Aravind!
And the _rate table? what does it mean?
Where can I find the raw data (as polled data) information table for IFStats in Vertica?
Thank you.
Best regards
Bruno Sousa
Original Message:
Sent: 07-29-2020 05:35 AM
From: Aravind Sugur
Subject: Vertica tables doubt
The daily rollups are stored in a table named from the dataset name concatenated with the string "_eqd", such as "ifstats_eqd".
The hourly rollups are stored in a table named from the dataset name concatenated with the string "_ltd", such as "ifstats_ltd".
Long term roll-up data consists of weekly, monthly, and quarterly rollups and is calculated from the daily rollup records. The long term data is stored in a table named from the dataset name concatenated with the string "_gtd", such as
Original Message:
Sent: 07-29-2020 05:21 AM
From: Bruno Sousa
Subject: Vertica tables doubt
Hello,
For the If Stats data in NetOPs Vertica I see the following tables:
ifstats_eqd
ifstats_gtd
ifstats_rate
Does anyone know what are the differences between these tables?
Thank you.
Best regards
Bruno Sousa