Monitoring and evaluating queries

Perform real-time workload monitoring of your WarehousePG (WHPG) queries, identify resource-heavy statements, manage database sessions, and tune SQL execution plans with the Query Monitoring panel from the left sidebar.

Identifying and resolving workload bottlenecks

Track real-time execution progress and prevent resource-heavy statements from impacting system stability by using the Active Queries tab.

• The header cards show a live breakdown of connection states: Active, Idle, Idle in Tx, Tx (Abort), Fastpath, Disabled, Waiting, and Blocked. Focus on Idle in Tx and Waiting, as they typically indicate application-level leaks or locking contention.
• Identify memory spill activity by reviewing the Spill Activity section. The Queries Spilling, Total Spill Size, and Total Temp Files cards indicate queries that are exceeding their memory quotas and writing intermediate data to disk.
• Filter the query list by database, user, or resource group using the dropdowns above the table.
• If you have Admin or Operator privileges, use the Cancel Query action to gracefully stop a statement consuming excessive resources. The cancel action is disabled for queries in an idle state.

Understanding query statuses

Monitor the real-time state of database connections to identify performance bottlenecks and resource contention.

Identifying the longest-running queries

Review a ranked list of the slowest queries across the cluster using the Longest Queries tab. Use this tab to identify persistent slow queries that require index tuning or query rewriting.

Resolving connection leaks and session bloat

Identify connection leaks and manage dormant processes that consume system slots by accessing the Sessions tab.

• Filter sessions by database, user, resource group, or Active status using the dropdowns above the table. The Active column shows Yes or No to indicate whether a session is currently executing a command.
• Review the Application column to identify which tools (such as psql, pgadmin, or ETL drivers) are initiating connections and investigate sources of connection spikes.
• If a session is unresponsive or holding critical locks, use the Terminate Session action to forcefully close the connection and release all associated system resources.

Monitoring background processes

Use the Background Processes tab to view internal WHPG background workers and maintenance processes currently running on the cluster.

Authoring and tuning SQL statements

Explore data and analyze execution plans in a read-only environment with the Query Editor tab.

• Generate execution plans with the Explain and Analyze buttons. The result appears in two tabs: Plan, which renders a visual graph of the execution steps, and Raw, which shows the full text output. The plan view also surfaces key statistics alongside any warnings detected in the plan.
• Identify performance bottlenecks by reviewing the warnings provided in the execution plan. Focus on sequential scans on large tables or missing statistics, which are common causes of slow performance.
• Use the Format SQL button to clean up raw SQL for better readability.
• Once a query successfully executes, you can download the entire result set as a CSV file, allowing data portability into spreadsheets or external reporting tools.

Optimizing queries with the AI Assistant

Use the integrated AI Assistant to accelerate SQL authoring and simplify the debugging of complex performance issues.

• Generate queries from natural language pressing the keys Ctrl + K and asking the assistant to write a query for you using plain English. Because the assistant is schema-aware, it will reference your actual table and column names accurately.
• Optimize slow-running statements by providing a slow query statement into the assistant and asking for optimization suggestions. The assistant will analyze join efficiency, index usage, and cluster resource utilization to recommend a more efficient version of your code.
• When a query fails, provide the Postgres error message to the assistant. It will explain the failure in plain language and suggest the specific corrections needed to resolve the error.

Managing query history and results

Manage your recent query activity and retrieve data without re-executing heavy statements with the Results subtab within the Query Editor tab.

• View results from recent queries, including execution time, row count, and status.
• Use the Copy to Editor action to reload a previous query into the editor for further tuning, or View Results to inspect its output directly.