Files
mtusi2026lab2/benchmark_seed.sql
2026-10-13 15:27:39 +03:00

63 lines
1.5 KiB
PL/PgSQL

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;