Files
2026-11-07 00:02:31 +03:00

26 lines
1.2 KiB
SQL

-- Воспроизводимый набор: 2 чата по 12 000 сообщений (24 000 всего). Повторный запуск ничего не дублирует.
INSERT INTO users(id, username, display_name, password_hash, created_at)
VALUES ('00000000-0000-0000-0000-000000000001', 'explain_user', 'Explain', 'x', now())
ON CONFLICT DO NOTHING;
INSERT INTO chats(id, title, created_at) VALUES
('00000000-0000-0000-0000-0000000000c1', 'explain target', now()),
('00000000-0000-0000-0000-0000000000c2', 'explain noise', now())
ON CONFLICT DO NOTHING;
INSERT INTO chat_members(chat_id, user_id, joined_at)
SELECT c.id, '00000000-0000-0000-0000-000000000001', now()
FROM chats c
WHERE c.id IN ('00000000-0000-0000-0000-0000000000c1', '00000000-0000-0000-0000-0000000000c2')
ON CONFLICT DO NOTHING;
INSERT INTO messages(id, chat_id, sender_id, text, created_at)
SELECT md5(c.id::text || g)::uuid, c.id, '00000000-0000-0000-0000-000000000001',
'msg ' || g, timestamptz '2026-01-01 00:00:00+00' + g * interval '1 second'
FROM (VALUES ('00000000-0000-0000-0000-0000000000c1'::uuid),
('00000000-0000-0000-0000-0000000000c2'::uuid)) c(id),
generate_series(1, 12000) g
ON CONFLICT DO NOTHING;
ANALYZE messages;