CREATE VIEW v_perf_data_5min 
WITH ( timescaledb.continuous,
    timescaledb.refresh_lag = '1m',
    timescaledb.refresh_interval = '30m',timescaledb.ignore_invalidation_older_than ='1s' )
AS
    SELECT
   time_bucket('5 min', time) as bucket,
   avg(doctets) as doctets,
   max(dpkts) as dpkts,
   index,
   ne_id
 FROM tb_perf_data
GROUP BY bucket, ne_id,index;