3 posts tagged with "Launch week"

Today we're launching the SQL query toolkit, a tool to analyze, explore, and share SQL queries with plans, that lives inside Postgres AI Console.

Why we built this​

Our Postgres AI Joe Bot has always maintained query analysis history, allowing users to revisit analyzed queries, view execution plans, and explore performance visualizations. We've integrated two super popular open-source visualization services, explain.depesz.com and PEV2 (explain.dalibo.com), directly into Postgres AI Console, giving you a secure, private environment to analyze and share queries with your team.

Our approach is "private by default" — your queries and execution plans stay confidential within your workspace. But we know collaboration extends beyond your immediate team.

Core features​

The SQL query toolkit lets you bring your own SQL queries and execution plans from any environment, and then analyze them using different visualization tools. The integrated Postgres AI Assistant provides optimization suggestions and explains performance issues based on your actual plans. You can also easily share your analysis with others through simple permalinks that don't require an account to view.

Real-world use case​

Let's consider an example. A developer encounters a slow query with multiple subqueries in production. They use the SQL Query Toolkit to:

1. Import the query and plan - paste the problematic SQL and execution plan into the toolkit

2. Analyze with visualization tools

3. Get insights from the Postgres AI Assistant

4. Share findings - generate a permalink to collaborate with the team on solutions

Getting started​

The SQL Query Toolkit is available as part of the postgres.ai platform at https://console.postgres.ai. Just log into Console, navigate to SQL Optimization → Add Query, and you're good to go!

Today we're releasing postgres_ai monitoring v0.7, a monitoring solution built specifically for Postgres experts who need rapid root cause analysis and deep performance insights. This isn't a tool for beginners—it's designed for experienced DBAs and SREs who need to understand complex performance issues in minutes, not hours.

Want to see it in action? Try our live demo (login: demo / password: demo) to explore the dashboards and see real-time Postgres monitoring in action.

The cost of experimentation determines the pace of innovation. In database development, this cost has traditionally been measured in hours and thousands of dollars per environment. DBLab Engine 4.0 changes this equation fundamentally with instant database branching.

New version delivers comprehensive database branching for Postgres with unique set of characteristics:

• Git-like semantics: branches are named pointers to snapshots
• O(1) scaling for both storage and compute costs
• True open source (Apache 2.0 license)