SQL query optimizer for Aiven for PostgreSQL®

Use Aiven's AI-powered SQL query optimizer to get optimization recommendations for your SQL queries.

If you're running an Aiven for PostgreSQL® service, you can also use Aiven's automatically generated suggestions for slow queries. In the Aiven Console, go to your service and click AI insights.

To optimize a query:

1. Click Tools > SQL query optimizer.
2. Click Optimize a query.
3. Select Aiven for PostgreSQL® as the database type.
4. Enter your query and click Next.
5. Optional: To improve the suggestions, submit the schema structure and statistics:
   1. Copy the query in Schema structure and statistics and execute it in your database.
   2. Paste the query output in Query output.
6. Click Optimize.

Related pages

• AI database optimizer for Aiven for PostgreSQL®
• Identify slow queries with pg_stat_statements
• SQL query optimizer for Aiven for MySQL®