EXTRACT(EPOCH FROM (times2 - times)) / 60
postgres 中计算date类型时间差,分钟为单位
select g.user_id, g.times2 - g.times cha,
EXTRACT(EPOCH FROM (times2 - times)) / 60
from (select user_id, times, lead(times) over (partition by user_id ORDER BY times) as times2 from G0802) g;