
Find Unused Indexes in PostgreSQL: A Quick Guide
Learn how to find unused indexes in PostgreSQL using pg_stat_user_indexes. Improve database performance and reduce bloat with our step-by-step guide.
September 3, 2026 · 7 min read
Mobin Yazdanparast
What We Learned Building DBO Studio 1.1.0
DBO Studio 1.1.0 is about removing uncertainty: schema diagrams for unfamiliar databases, Safe Mode for the wrong connection, typed editors for real column types, and pagination so a SELECT without LIMIT no longer means fetch everything.
September 3, 2026 · 8 min read
Mobin Yazdanparast
PostgreSQL Composite Indexes Best Practices
Master PostgreSQL composite indexes best practices: column order, leftmost prefix rule, INCLUDE, and when to prefer multicolumn over separate indexes for faster queries.
August 21, 2026 · 7 min read
Mobin Yazdanparast
What Is a Database Index? A Beginner's Guide
A clear explanation of what a database index is, how it improves data retrieval speed, and the structural trade-offs involved in SQL index creation.
August 4, 2026 · 9 min read
Mobin Yazdanparast