Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 14.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit

SELECT 1

CREATE TABLE mytable(
   name       text NOT NULL PRIMARY KEY
  ,version    int  NOT NULL
  ,processed  BOOLEAN  NOT NULL
  ,processing BOOLEAN  NOT NULL
  ,updated    INTEGER  NOT NULL
  ,ref_time   INTEGER  NOT NULL
);
INSERT INTO mytable(name,version,processed,processing,updated,ref_time) VALUES ('abc',1,'t','f',27794395,27794160);
INSERT INTO mytable(name,version,processed,processing,updated,ref_time) VALUES ('def',1,'t','f',27794395,27793440);
INSERT INTO mytable(name,version,processed,processing,updated,ref_time) VALUES ('ghi',1,'t','f',27794395,27793440);
INSERT INTO mytable(name,version,processed,processing,updated,ref_time) VALUES ('jkl',1,'f','f',27794395,27794160);
INSERT INTO mytable(name,version,processed,processing,updated,ref_time) VALUES ('mno',1,'t','f',27794395,27793440);
INSERT INTO mytable(name,version,processed,processing,updated,ref_time) VALUES ('pqr',1,'f','t',27794395,27794160);

CREATE TABLE

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

select ref_time, 
    count(*) cnt_total,
    count(*) filter(where processed) cnt_processed,
    avg(processed::int) * 100 percent_processed
from mytable
group by ref_time

ref_time
cnt_total
cnt_processed
percent_processed

27794160
3
1
33.33333333333333333300

27793440
3
3
100.00000000000000000000

SELECT 2

ref_time	cnt_total	cnt_processed	percent_processed
27794160	3	1	33.33333333333333333300
27793440	3	3	100.00000000000000000000