Features

Privacy

Powered by PGlite running locally in your browser, most features are available privately without requiring any external systems or communication. Keep your data safely where it belongs.

Realtime query visualizations

Stop reading EXPLAIN output and take the guesswork out of query optimization. With as-you-type query visualization, you can now instantly see how the database runs any query on any schema. Fully configurable sample data allows you to also see how all objects are processed including those that are ultimately discarded.

Take things a step further with the ability to create, drop, or even "hide" indexes for the database to use. This is the fastest way to iterate on query performance and discover all of the clever plans that the database can come up with.

Optimization ratings

Unclear if your query could be faster?

IndeX-Ray will show you how good (or bad!) the query is based on possible indexing strategies relevant to your setup. Oftentimes a missing index makes a world of difference, while other times a table scan is as good as it gets. Don't waste time wondering which situation you're in.

Scan type details

Using an index is not the same thing as using an index efficiently.

The critical information about how WHERE conditions (and JOIN clauses) are being evaluated is now at your fingertips with IndeX-Ray. Both in the diagram and embedded directly into the SQL text itself, quickly find out how the database is finding and filtering through its data when running a query.

Performance suggestions PRO

Looking for specific guidance to improve performance rather than just exploring with all of the great free features?

Pro users can get a variety of suggestions for improving query performance, including:

• Index suggestions - Whether simple or complex (e.g. using expressions), we'll find indexes that can make your query fly.
• Query rewrite suggestions - Sometimes the trick to improving performance is actually to tweak how the query is expressed to the database.
• General observations - Falling victim of a common anti-pattern? We'll find those too and point you in the right direction.

These suggestions are both contextual and specific. We take the entire query into consideration, check against the schema in the playground, and validate that the suggestions are valid (and beneficial).

StatisticsPRO

Query plans are created based on statistical metadata that the database captures about the information it stores. The more closely statistics in IndeX-Ray reflect those in the actual database, the more accurate the query plans will be.

Pro users get powerful tools in this regard, including the following abilities:

• Change the number of records in each table
• Modify per-column statistics, such as the number of distinct values
• Importing statistics directly from a source database

To improve accuracy and realism, IndeX-Ray defaults to planning queries as if there were 10,000 records in every table (including free users).

Import

Coming soon: Configure the playground directly from your source database.

With just a few clicks, you can connect your PostgreSQL database to IndeX-Ray and import the schema and statistics from it.

Want (or need) to keep the data from passing through our servers? Syncs can also be performed by running a local extension. This allows you to pull from a local database instance of PostgreSQL and also provides the ability to privately pull your data to your browser without ever passing through our servers.