Postgres 13

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

CREATE TABLE my_features
(
  id uuid NOT NULL,
  feature_id uuid NOT NULL,
  begin_time timestamptz NOT NULL,
  duration integer NOT NULL
)

CREATE TABLE


INSERT INTO my_features
VALUES ('aa79414c-9b2f-419d-9812-c66c6b5bba2b', 
         'ae83c512-1af7-43df-8b95-135c647a41f3',
         '2021-01-01 00:00:01' ,5)

INSERT 0 1


INSERT INTO my_features
VALUES ('aa79414c-9b2f-419d-9812-c66c6b5bba23', 
         'ae83c512-1af7-43df-8b95-135c647a41f3',
         '2021-01-01 00:00:25' ,5)

INSERT 0 1


SELECT *
FROM my_features


id
feature_id
begin_time
duration


aa79414c-9b2f-419d-9812-c66c6b5bba2b
ae83c512-1af7-43df-8b95-135c647a41f3
2021-01-01 00:00:01+00
5

aa79414c-9b2f-419d-9812-c66c6b5bba23
ae83c512-1af7-43df-8b95-135c647a41f3
2021-01-01 00:00:25+00
5



SELECT 2


SELECT * -- DISTINCT f1.*
FROM my_features f1
JOIN my_features f2
  ON f1.feature_id = f2.feature_id
 AND f1.id <> f2.id
 AND (f1.begin_time::date, f1.begin_time::date + '30 minutes'::INTERVAL)
    OVERLAPS (f2.begin_time::date, f2.begin_time::date + '30 minutes'::INTERVAL)


id
feature_id
begin_time
duration
id
feature_id
begin_time
duration


aa79414c-9b2f-419d-9812-c66c6b5bba2b
ae83c512-1af7-43df-8b95-135c647a41f3
2021-01-01 00:00:01+00
5
aa79414c-9b2f-419d-9812-c66c6b5bba23
ae83c512-1af7-43df-8b95-135c647a41f3
2021-01-01 00:00:25+00
5

aa79414c-9b2f-419d-9812-c66c6b5bba23
ae83c512-1af7-43df-8b95-135c647a41f3
2021-01-01 00:00:25+00
5
aa79414c-9b2f-419d-9812-c66c6b5bba2b
ae83c512-1af7-43df-8b95-135c647a41f3
2021-01-01 00:00:01+00
5



SELECT 2

id	feature_id	begin_time	duration
aa79414c-9b2f-419d-9812-c66c6b5bba2b	ae83c512-1af7-43df-8b95-135c647a41f3	2021-01-01 00:00:01+00	5
aa79414c-9b2f-419d-9812-c66c6b5bba23	ae83c512-1af7-43df-8b95-135c647a41f3	2021-01-01 00:00:25+00	5