devwithjev
Submit a build

Query workload classifier for Postgres

A desktop app that uses Jev to classify your entire query workload and tell you which queries to EXPLAIN ANALYZE first.

Frone0910 in r/SQL@Frone0910
I built an app that uses Jev to classify your entire query workload and tell you which queries to EXPLAIN ANALYZE first I posted here last month about RDST, the free desktop app that runs the slow query to EXPLAIN to index recommendation loop. The biggest change since then is what happens before EXPLAIN. When a database has thousands of distinct query shapes, you can't EXPLAIN ANALYZE all of them, and sorting queries by their performance doesn't always tell you which ones are actually badly written. RDST now answers that with Jev, a small classification model from TypeSafe that answers fixed multiple-choice questions about a query in a fraction of a second. Every query shape it discovers gets classified from its SQL and the schema, without executing anything, on five structural questions:
Sep 23, 2026Reddit postsView on Reddit

Also filed under Tools & apps

  • Google Icons Search Tool

    Roman Khrupa built a tool that searches Google Icons using JEV (Laya-MLX).

  • AI Slop Finder for X

    Utkarsh Singh built an AI-slop finder for X using Jev. A content script extracts tweet text, sends it through a backend API to Jev, and displays the resulting AI-slop score as a badge on the tweet.

  • Precise Citations on Document Pages

    Pushkar Jain says @knowyourcompani uses Jev from @typesafeai to render exact citations on document pages, upgrading from chunk box mapping to more precise citations.

  • Chrome Extension Classifies X Content

    Tafar built a Chrome extension with Jev that quietly analyzes what he is seeing and classifies it as Opinion, Engagement bait, and other categories. He says it is clean enough to look like a new feature on X.