What do the PostgreSQL agent "Current Locks" and "Explain Plan Request" dashboards display?
The Current Locks page shows current locks in the server from the last server data sample and related information. In the action panel on the right pane, the PostgreSQL Agent Selector allows you to switch between PostgreSQL servers.
Data
Top-left Table Section
Top Graphs
Table
If Enable Explain Plans is set to true in the agent properties, this form allows a user with the PostgreSQL Administrator role to request explain plans. The text area field will be pre-filled with the normalized query text of the statement being investigated. It can (or must be) modified to an appropriate form for the PostgreSQL server to consider it a legitimate statement (? replaced with real numerical or string values). The database is also auto-selected, but may be switched.
When done, click the Execute button to request the Explain plan and wait. After a short time, a popup should launch with the results of the explain plan request similar to the screenshot below. The Foglight user and statement performed will also be logged to the Agent Log.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center