Postgres 15

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

select version();

version

PostgreSQL 15.0 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 (log_session integer[]);

CREATE TABLE

insert into mytable (log_session) values 
  (array[105683,105694]), 
  (array[111833]), 
  (array[120285]), 
  (array[108592]), 
  (array[84659,84663]);

INSERT 0 5

select 
    count(*) filter(where array_length(log_session, 1) = 1) as cnt_length_1,
    count(*) filter(where array_length(log_session, 1) > 1) as cnt_length_more_than_1
from mytable

cnt_length_1
cnt_length_more_than_1

3
2

SELECT 1