-- Воспроизводимый набор: 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;