Bu jadvalda 100 000 000 yozuv bor
CREATE TABLE posts (
id BIGSERIAL PRIMARY KEY,
title VARCHAR(255) NOT NULL,
text TEXT NOT NULL
);
#######################################
So'rov:
SELECT *
FROM posts
WHERE title = 'Python tutorial';
Ijro rejasi:
Seq Scan on posts
(xarajat=0.00..20834.00 satrlar=1 kenglik=64)
(haqiqiy vaqt=0.025..10350.421 satrlar=1)
Filtr: (title = 'Python tutorial')
Filtr bilan olib tashlangan satrlar: 99999999
Rejalashtirish vaqti: 0.120 ms
Ijro vaqti: 10350.500 ms
Bu rejadan nima ko'rish mumkin? Uni qanday optimallashtirish mumkin?
