Postgres 13

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

CREATE TABLE mytable (
    uuid int,
    page text,
    date_id int,
    time_id int
);

INSERT INTO mytable VALUES
(1, 'Pulse', 20210224, 1633),
(1, 'QC', 20210224, 1633),
(1, 'QC', 20210224, 1634),
(1, 'Measure', 20210224, 1635),
(1, 'QC', 20210224, 1635);

SELECT * FROM mytable;

CREATE TABLE



INSERT 0 5




uuid
page
date_id
time_id


1
Pulse
20210224
1633

1
QC
20210224
1633

1
QC
20210224
1634

1
Measure
20210224
1635

1
QC
20210224
1635



SELECT 5


SELECT 
    *,
    lag(page) over (partition by uuid, page order by date_id, time_id)
FROM mytable 


uuid
page
date_id
time_id
lag


1
Measure
20210224
1635
null

1
Pulse
20210224
1633
null

1
QC
20210224
1633
null

1
QC
20210224
1634
QC

1
QC
20210224
1635
QC



SELECT 5


SELECT 
    *,
    CASE WHEN page = lag(page) over (partition by uuid, page order by date_id, time_id) THEN 0 ELSE 1 END as is_diff
FROM mytable 


uuid
page
date_id
time_id
is_diff


1
Measure
20210224
1635
1

1
Pulse
20210224
1633
1

1
QC
20210224
1633
1

1
QC
20210224
1634
0

1
QC
20210224
1635
0



SELECT 5


SELECT 
    *, 
    SUM(is_diff) OVER (ORDER BY date_id, time_id, uuid, page) 
FROM (
    SELECT 
        *,
        CASE WHEN page = lag(page) over (partition by uuid, page order by date_id, time_id) THEN 0 ELSE 1 END as is_diff
    FROM mytable 
)s


uuid
page
date_id
time_id
is_diff
sum


1
Pulse
20210224
1633
1
1

1
QC
20210224
1633
1
2

1
QC
20210224
1634
0
2

1
Measure
20210224
1635
1
3

1
QC
20210224
1635
0
3



SELECT 5

uuid	page	date_id	time_id
1	Pulse	20210224	1633
1	QC	20210224	1633
1	QC	20210224	1634
1	Measure	20210224	1635
1	QC	20210224	1635