Skip to main content

Query and analyze data in Aiven for PostgreSQL®

Write and run queries, and identify and optimize slow queries in your Aiven for PostgreSQL® service.

Tools for finding and fixing slow queries​

  • Aiven AI Database Optimizer, in the Observe section as AI insights, suggests optimizations automatically, without you writing any analysis queries yourself.
  • pg_stat_statements gives you the underlying query statistics instead, so you can write your own analysis queries rather than relying on automated suggestions.
  • PG Studio's AI assistant is a separate feature. It doesn't analyze historical query performance the way AI insights or pg_stat_statements do.

Historical analysis compared to live queries​

Identifying slow queries and optimizing them both work from statistics on completed executions. Detecting and terminating long-running queries, in contrast, targets queries that are running right now. Use the historical tools to prevent slow queries, and the live tools to react to one that's already blocking other work.

Related pages