构建测试数据

create table test(dt timestamp,id int,val int);

insert into test select *,(random()*100)::int  from generate_series('2021-01-01'::timestamp,'2021-01-02'::timestamp,'1 sec') with ordinality;
复制

假设按10秒间隔抽取数据：

with t as
(
 select dt,extract('epoch' from dt)::int as dt_epoch,id,val from test
)
select * from  t where mod(t.dt_epoch,10)=0;
复制

假设按10分钟间隔抽取数据：

with t as
(
 select dt,extract('epoch' from dt)::int as dt_epoch,id,val from test
)
select * from  t where mod(t.dt_epoch,600)=0;
复制