forked from mtusi2026/mtusi2026lab2
FastAPI-сервис с opaque-сессиями (Argon2id, SHA-256 фингерпринт), PostgreSQL как источником истины, Valkey как кэшем сессий, keyset-пагинацией, пулом соединений и таймаутами. Добавлены миграции, compose-стенд, скрипт рестарта, студенческие проверки и evidence.
23 lines
1.2 KiB
Plaintext
23 lines
1.2 KiB
Plaintext
SET
|
|
SET
|
|
QUERY PLAN
|
|
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
Limit (cost=903.23..903.36 rows=50 width=70) (actual time=2.525..2.529 rows=50 loops=1)
|
|
Buffers: shared hit=361
|
|
-> Sort (cost=903.23..915.49 rows=4903 width=70) (actual time=2.525..2.526 rows=50 loops=1)
|
|
Sort Key: created_at, id
|
|
Sort Method: top-N heapsort Memory: 38kB
|
|
Buffers: shared hit=361
|
|
-> Seq Scan on messages (cost=0.00..740.36 rows=4903 width=70) (actual time=0.617..2.086 rows=4982 loops=1)
|
|
Filter: ((chat_id = '00000000-0000-4000-8000-0000000000aa'::uuid) AND (ROW(created_at, id) > ROW((now() - '01:23:20'::interval), '00000000-0000-4000-8000-000000000000'::uuid)))
|
|
Rows Removed by Filter: 12145
|
|
Buffers: shared hit=355
|
|
Planning:
|
|
Buffers: shared hit=106
|
|
Planning Time: 0.203 ms
|
|
Execution Time: 2.550 ms
|
|
(14 rows)
|
|
|
|
RESET
|
|
RESET
|