Database Indexing Visualized
A visual approach to understanding query execution, no EXPLAIN expertise required
Loading Postgres in your browser
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?
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 Course(coming soon!)
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.