Tracing Codex's 640TB/year SQLite Writes
Instrumenting the Codex binary at runtime to see what queries it's making to the DB
Notes on making Postgres legible.
Query plans, index strategy and the planner's stranger decisions, from the team building Query Doctor.
Latest
EXPLAIN Quirks: PostgreSQL's Missing Index Usage Details
PostgreSQL's EXPLAIN command contains detailed information about many aspect of a query's execution plan. But one particular set of information is curiously absent.
IndeX-Ray™: Imaging Technology for Database Indexes
Today we introduce IndeX-Ray™ which is a simple, intuitive, and powerful way to visualize indexes inside of databases!
Covered Queries
Indexes tell databases where to find information that it is looking for. Under the right circumstances, the index can save the database even more time by providing the requested information directly.
What is an Index?
Indexes are the core component that drive efficient database performance. How do they do it?
Don't (Always) Use The Index
Indexes are incredible, but not magical. There are times when they should not be used. Forcing a database to use one when it doesn't naturally want to could cause performance to get worse.
Interested in what we're up to?
No spam, pinky promise.