YOUR AD GOES HERE

I reduced the search time on 900k items in db from 55.567 ms to 0.051 ms (How i did this ?)

Published 20, Sep 2026

5 128 Download

Description:
I had 900K+ products in PostgreSQL, and searching for a product by SKU was using a Sequential Scan.

In this video, I show how I used a B-tree index on the SKU column to change the query execution plan and reduce the search time.

I also use EXPLAIN ANALYZE to compare the query before and after the index and see what PostgreSQL is actually doing under the hood.

Topics:

* PostgreSQL indexes
* B-tree indexes
* Sequential Scan vs Index Scan
* EXPLAIN ANALYZE
* Query performance
* Database optimization
* PostgreSQL performance

Don't forget to follow me

LinkedIn: https://www.linkedin.com/in/abdelkader-ould-hennia
Twitter: https://x.com/Kader_1680
GitHub: https://github.com/Kader1680

Releted More Videos

Sorry!!! Nothing to show

You May Also Like

YOUR AD GOES HERE

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Dba: When use the SHOW PROCESSLIST vs SELECT * FROM information_schema.PROCESSLIST command?
Peter Schneider

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

SQL Query Select statement - Database management system@learninglaunch2181 @SQLBI
Learning Launch

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

E974 The Next Unicorns E2 Grove Collaborative CEO Stu Landesberg $100M+ rev selling natural products
This Week in Startups

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Excel Random Number Generator - Rand & RandBetween
Professor McLeod

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Assam government Free E rickshaw and moped apply // how to apply for free e riksa
DIGITAL ASSAM 2.0

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Microsoft SQL Server Performance Tuning Part 36 : Nested Loops_3 in SQL Server
RAV DBLearning

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

SQL SELECT Statement Explained: Retrieve Database Data Easily #Shorts #YTShorts #YoutubeShorts #SQL

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

【64分アニメ】おもいでのさんぽみち｜ながーい　のりまきを　つくろう｜しまじろうのわお！アニメ｜しまじろうチャンネル公式
しまじろうチャンネル（YouTube）

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Untangle Multi-Select Data—Rows of Comma-separated Lists from Select All Qs—with Excel Power Query ????
DoIT Training at Stony Brook University

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Performing a SELECT Count on multiple tables with specific criteria
Roel Van de Paar

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

PYTHON TUTORIAL FOR BEGINNERS IN 11 HOURS (in ENGLISH) || BASIC PYTHON PROGRAMMING || DATA SCIENCE
Sundeep Saradhi Kanthety

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

???? Learn the Numbers from 1 to 20 by Singing! ????
Smile and Learn - English

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Combine cells with TEXTJOIN
Spreadsheet Nation

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Full Guide To Score A* in CAIE O-Levels Maths (4024)
Abdullah Khan

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Addition! | Level 1 | Numberblocks
Numberblocks

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Python Full Course for Beginners (13 Hours) – From Zero to Hero
Data with Baraa

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Programming Trends Lost To History...
CodeHead

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

ETL vs ELT — Understanding Extract, Transform, Load vs Extract, Load, Transform | Uplatz
Uplatz

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

SQL : Combining sql select and Count
Hey Delphi

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Ascii Table | Characters | Decimal | TypeCasting
SHAZMA NOOR

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

If x﹥1 then nth root of x﹥1, and if 0﹤x﹤1 then 0﹤nth root of x﹤1 (Proof) (ILIEKMATHPHYSICS)
ILIEKMATHPHYSICS

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

Wonderlic Practice Test | Q68: From the list below, select all of the quadruped mammals that might
ThetaBuddy

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

How to Upload With the Best Video Settings on YouTube
GuideWise

I Reduced The Search Time On 900k Items In Db From 55567 Ms To 0051 Ms (How I Did This ) - YouTube Auto PHP Script

SQL 12c Tutorial 2 : SQL SELECT Statement with example
TechLake

YOUR AD GOES HERE