left join to a crossed joined number with extra timestamp concat (Stackoverflow 53794078), PostgreSQL

Language: Layout:

create table test_topups (amount int, result varchar(30), user_id int, updated_at timestamp default current_timestamp)\\
insert into test_topups (amount, result, user_id) values
(10, 'success', 1),
(20, 'failed', 2)\\

create table test_withdraws (w_amount int, user_id int, updated_at timestamp default current_timestamp)\\
insert into test_withdraws (w_amount, user_id) values (10, 1), (20, 2), (30, 10)\\

create table test_transfers (method varchar(30), amount int, user_id int, updated_at timestamp default current_timestamp)\\
insert into test_transfers (method, amount, user_id) values
('abc', 10, 3),
('xyz', 20, 4)\\

create table test_users (id int, f_name varchar(30), l_name varchar(30))\\
insert into test_users (id, f_name, l_name) values 
(1, 'first1', 'last1'),
(2, 'first2', 'last2'),
(3, 'first3', 'last3'),
(4, 'first4', 'last4'),
(5, 'first5', 'last5'),
(6, 'first6', 'last6')\\

SELECT 
 tup.amount, tup.result, 
 usr.id as user_id, 
 COALESCE(wd.w_amount, wdup.w_amount) as w_amount,
 COALESCE(trans.method, trup.max_method) as method,
 COALESCE(tup.updated_at, wd.updated_at, trans.updated_at) as updated_at,
 CASE WHEN nr.n = 1 THEN CONCAT(tup.updated_at,',',wdup.max_updated_at,',',trup.max_updated_at) END as tup_wd_tr_updated_at
FROM test_users usr
CROSS JOIN (SELECT generate_series n FROM generate_series(1, 3)) AS nr
LEFT JOIN test_topups tup ON tup.user_id = usr.id AND nr.n = 1
LEFT JOIN test_withdraws wd ON wd.user_id = usr.id AND nr.n = 2
LEFT JOIN test_transfers trans ON trans.user_id = usr.id AND nr.n = 3
LEFT JOIN (select user_id, w_amount, max(updated_at) as max_updated_at 
           from test_withdraws 
           group by user_id, w_amount) wdup
  ON wdup.user_id = tup.user_id AND wdup.w_amount = tup.amount
LEFT JOIN (select user_id, amount, max(updated_at) as max_updated_at, max(method) as max_method
           from test_transfers 
           group by user_id, amount) trup
  ON trup.user_id = tup.user_id AND trup.amount = tup.amount
WHERE (tup.user_id IS NOT NULL OR wd.user_id IS NOT NULL OR trans.user_id IS NOT NULL)
ORDER BY tup.user_id, wd.user_id, trans.user_id


absolute service time: 0,62 sec

left join to a crossed joined number with extra timestamp concat (Stac...