ExoBench
exobench.ai
Code Intelligence
AI Development Tools
Databases & DBMS
Claim pageClaim
Follow
Overview
News
Salaries
Products
People
Growth
Offices
Financials
Overview
AI-powered SQL query optimization. Connect via MCP, run real benchmarks against your database, and let AI iterate until your queries are fast.
News
How One Extra JOIN Reliably Breaks Postgres
Adding a 5-row lookup table to a 9-table billing query flips the plan from 0.3ms nested loops to 467ms hash joins. The cause is join_collapse_limit = 8, a default Postgres has shipped since 2005. SQL Server and MySQL don't have this cliff. Measured across
Read more
Report
JOIN FETCH May Not Save You - Seven things JPA developers believe about N+1, checked against the SQL that Hibernate and EclipseLink actually prepared - Blog
We ran a JPA N+1 detector over Shopizer, Apache Fineract, and Spring PetClinic, then used it to check the standard fixes. A second JOIN FETCH query left the N+1 at 12 statements. Fetching the parent collection left 25. setMaxResults silently lost its LIMI
Read more
Report
How Fast Are Postgres 19 Graph Queries? Part 1: What Are They Actually Doing?
Postgres 19 adds SQL/PGQ graph queries. Measured against a PostgreSQL 19beta1 build, the fixed-depth graph query compiles to the exact same plan as a hand-written join, and the variable-depth traversal that graph databases were built for still falls to a
Read more
Report