Calculate the table count of each day

-- 计算前七天中每一天的 ci 表的行数.
-- Calculate the rows count of ci table for each of the first seven days.
select d::date, (select count(*) from ci where created_at < d) as count
from generate_series(now()::date - interval '7' day, now()::date, interval '1' day) as d;