BEGIN; CREATE EXTENSION IF NOT EXISTS pgcrypto; INSERT INTO users (id, username, display_name, password_hash, created_at) VALUES ( '00000000-0000-4000-8000-000000000001', 'benchmark_user', 'Benchmark User', 'benchmark_not_for_login', NOW() ); -- Пять тестовых чатов. INSERT INTO chats (id, title, created_at) SELECT ('00000000-0000-4000-8000-' || LPAD(n::text, 12, '0'))::uuid, 'Benchmark Chat ' || n, NOW() FROM generate_series(101, 105) AS n; -- Добавляем пользователя в каждый чат. INSERT INTO chat_members (chat_id, user_id) SELECT id, '00000000-0000-4000-8000-000000000001'::uuid FROM chats WHERE title LIKE 'Benchmark Chat %'; -- Генерируем 120 000 сообщений. -- Распределение: 60k, 30k, 15k, 10k, 5k. WITH distribution(chat_num, message_count) AS ( VALUES (101, 60000), (102, 30000), (103, 15000), (104, 10000), (105, 5000) ) INSERT INTO messages ( id, chat_id, sender_id, text, created_at ) SELECT gen_random_uuid(), ('00000000-0000-4000-8000-' || LPAD(d.chat_num::text, 12, '0'))::uuid, '00000000-0000-4000-8000-000000000001'::uuid, 'Benchmark message ' || s.n || ' in chat ' || d.chat_num, TIMESTAMPTZ '2026-01-01 00:00:00+00' + s.n * INTERVAL '1 second' FROM distribution d CROSS JOIN LATERAL generate_series(1, d.message_count) AS s(n); COMMIT; ANALYZE messages;