forked from mtusi2026/mtusi2026lab2
18 lines
661 B
Plaintext
18 lines
661 B
Plaintext
BEGIN
|
|
INSERT 0 1
|
|
INSERT 0 1
|
|
INSERT 0 1
|
|
INSERT 0 10000
|
|
ANALYZE
|
|
fixture_rows=10000
|
|
Limit (cost=0.29..14.47 rows=51 width=68) (actual time=0.006..0.010 rows=51 loops=1)
|
|
Buffers: shared hit=3
|
|
-> Index Scan using ix_messages_history on messages (cost=0.29..280.02 rows=1006 width=68) (actual time=0.005..0.008 rows=51 loops=1)
|
|
Index Cond: ((chat_id = '20000000-0000-0000-0000-000000000001'::uuid) AND (ROW(created_at, id) > ROW('2026-01-01 00:00:09+00'::timestamp with time zone, '00000000-0000-0000-0000-000000000000'::uuid)))
|
|
Buffers: shared hit=3
|
|
Planning:
|
|
Buffers: shared hit=18
|
|
Planning Time: 0.044 ms
|
|
Execution Time: 0.020 ms
|
|
ROLLBACK
|