Database Indexing Visualized
A visually interactive approach to understanding and debugging query performance
👇 I'm interactive, change the query or hide an index to see what happens!👇 I'm interactive, change the query to see what happens!
Loading Postgres in your browser
Loading
Fully customize the setup by heading over to the playground
Databases are complex; understanding them no longer has to be.
For the first time ever, our IndeX-Rayâ„¢ technology provides a dynamic visual representation of how databases process queries. Look inside the database to discover exactly how it found the information that you were asking for. Indexes, JOINs, expressions, and more; it's all there waiting to be explored.
This goes well beyond the typical "Visual Explain Plans" offered by other tools. Instead of just reporting the work done by each stage, we show how that work was actually done.
Oh, and did we mention that this is generated from a database in realtime as you type?
Special Offer for Early Adopters
Excited by what we're building? Support us by becoming a special lifetime member today!
For a very limited time, our earliest supporters will recieve lifetime access to everything that Query Doctor has to offer. This includes unrestricted access to IndeX-Rayâ„¢ in the playground, our full catalog of courses, and other fun perks and surprises. Lifetime members are also trusted partners of the Query Doctor community who have have exclusive access to help shape our future.
Once this offer is gone it will not return. Don't miss out on this unique opportunity!
Get started by visiting your Account page today.
See Databases Differently
About Us
Frustrated by how mysterious databases appear to be, we embarked on an ambitous journey to allow anyone to quickly understand them. We believe that there is no better way to learn than to see what databases do and are building disruptive technology to enable that.
We call one of the core technologies IndeX-Rayâ„¢ and it is at the heart of the playground, our visualization platform, as well as what our interactive course is centered around.
"I'm just a developer"
If your code interacts with a database in any way, then you've come to the right place. As Kai Sassnowski brilliantly shares: 'indexes are for queries'. As a developer, you are responsible for writing those queries.
Your Query, Your Setup
Static examples aren't interesting. Find out how the database runs YOUR query.
What-If-Analysis
Why didn't the database use an index? Force it to and instantly find out
Complex Query Support
Powered by PGlite, explore how data moves through plan stages for any common query.
Share with your Peers
Find something interesting? Have questions? Discuss with a unique link to your example
See Databases Differently
No spam, pinky promise.
Our CourseAvailable to lifetime members today!
There are plenty of courses about databases out there, but there has never been one quite like this before.
This course transforms knowledge about database indexing into a super power for developers. While topics like block size, file formats, and compression tradeoffs are all interesting, this course doesn't cover any of that. Instead it focuses on building a powerful mental model for how to use indexing most effectively. Using a novel approach, this course asks you to act as the database, learning how (and why) it works by making the same decisions under the same constraints that it does.
Regardless of your familiarity with databases, including any prior bad experiences with them, the concepts will be introduced in an intuitive new manner from the ground up. Think of this as the "Hello, World!" course for database indexing.
For a limited time, the course is available today to lifetime members for a discounted rate! General availability at full price is coming soon.