Help & User Guide

AWR / ASH Analysis

Use it when: the system is slow, you want to analyse performance over a specific period, or you need to identify the most expensive queries and wait events.

What you get: root cause of the problem, top queries, top wait events, optimisation recommendations.

Query Advisor

Use it when: you want to optimise specific queries without a direct database connection.

What you get: query analysis, index suggestions, optimised rewrite, estimated improvement.

Database Profile

Use it when: you want to track your database performance over time.

What you get: evolution of key metrics, progressive degradation detection, period comparisons.

Investigations

Use it when: there is an active incident or you want to document and resolve a problem collaboratively.

What you get: AI chat workspace, attachments, incident timeline and automatic postmortem.

Query Advisor (offline)

Use it when: you have pg_stat_statements output and want to identify the most problematic queries.

What you get: query cost ranking, index suggestions, execution plan analysis.

Investigations

Use it when: there is a performance problem and you want to analyse it with AI by attaching logs and execution plans.

What you get: AI-guided diagnosis with PostgreSQL-specific recommendations.