#!/bin/sh set -eu cd "$(dirname "$0")/.." docker compose exec -T postgres psql -U messenger -d messenger -v ON_ERROR_STOP=1 <<'SQL' INSERT INTO users (id, username, display_name, password_hash) VALUES ('aaaaaaaa-aaaa-4aaa-8aaa-aaaaaaaaaaaa', 'plan_user', 'Plan user', 'not-used') ON CONFLICT (id) DO NOTHING; INSERT INTO chats (id, title) VALUES ('bbbbbbbb-bbbb-4bbb-8bbb-bbbbbbbbbbbb', 'Plan history') ON CONFLICT (id) DO NOTHING; INSERT INTO chat_members (chat_id, user_id) VALUES ('bbbbbbbb-bbbb-4bbb-8bbb-bbbbbbbbbbbb', 'aaaaaaaa-aaaa-4aaa-8aaa-aaaaaaaaaaaa') ON CONFLICT DO NOTHING; INSERT INTO messages (id, chat_id, sender_id, text, created_at) SELECT ('00000000-0000-4000-8000-' || lpad(item::text, 12, '0'))::uuid, 'bbbbbbbb-bbbb-4bbb-8bbb-bbbbbbbbbbbb', 'aaaaaaaa-aaaa-4aaa-8aaa-aaaaaaaaaaaa', 'plan message ' || item, '2026-01-01T00:00:00Z'::timestamptz + item * interval '1 microsecond' FROM generate_series(1, 10000) AS item ON CONFLICT (id) DO NOTHING; ANALYZE messages; EXPLAIN (ANALYZE, BUFFERS) SELECT id, chat_id, sender_id, text, created_at FROM messages WHERE chat_id = 'bbbbbbbb-bbbb-4bbb-8bbb-bbbbbbbbbbbb' ORDER BY created_at, id LIMIT 50; SQL