Using the Postgresql Server Overview dashboard (4309875)

Server Overview

The Server Overview dashboard gives an overview of key segments for the PostgreSQL server, including host metrics. Information includes availability and connection status, storage and host information, and operations and performance metrics. The right side of the page features an expandable summary box that can display the Top 10 SQL executed in the current time range by one of several metrics or the Top 10 Alarms currently active for this server. In the action panel on the right pane, the PostgreSQL Agent Selector allows you to switch between PostgreSQL servers. 

Current Backends

Data

• PID – Process ID of the backend.
• User – The user name that owns the backend.
• App Name – The application where the backend originated from, if provided in the connection string.
• DB – Name of the database the backend is connected to.
• State – Current overall state of the backend.
• State Change – Time when the last time the backend state was changed.
• Runtime – How long the backend has existed.
• Waiting – Whether or not the backend is waiting for a lock to open in order to perform its query.
• Wait Event – Wait event type if the backend is waiting (9.6+).
• Wait Event Type – Wait event name if the backend is waiting (9.6+). 
• Query – Current or last query executed by the backend. Shown in an abbreviated state in order to fit in the table cell.
• Query Start – Time when the currently active query was started or start of the last query if not active.
• Xact Start – Time when the backend’s current transaction was started or null if no transaction is active. 

Actions

• DB (drilldown) – Navigates to the Databases dashboard with DB selected.
• Query (dwell or drilldown) - Shows the full query text in a formatted, colored state for better readability.  

• Cancel – Cancel the backend’s current query.
• Terminate – Terminates the backend, i.e. kills the process.