PEM Main Browser Window v8

The PEM client features a menu bar and a window divided into two panes: the Browser tree control in the left pane, and a tabbed browser in the right pane.

Menus displayed across the top of the browser window provide quick, context-sensitive access to PEM features and functionality.

The PEM Client Object Browser

The Browser tree control provides access to information and management options for the database objects that reside on each server. The tree control expands to display a hierarchical view of the servers and objects that are monitored by the PEM server. You can use context menu options (accessed by right-clicking on nodes of the tree control) to create new objects, and modify and delete existing objects if your role holds the required privileges.

Expand nodes in the tree control to display a hierarchical view of the database objects that reside on a selected server:

• Use the plus sign (+) to the left of a node to expand a segment of the tree control.
• Click the minus sign (-) to the left of a node to close that node.

Right-click on a node of the tree control to access a context-sensitive menu and perform common tasks. Context menu options may include one or more of the following selections:

The context-sensitive menus associated with Tables and nested Table nodes provides additional display options:

The PEM Tabbed Browser Window

The main panel of the PEM client contains a collection of tabs that display information about the object currently selected in the tree control.

The Dashboard tab is context-sensitive; when you navigate to the Dashboard tab from a server group or the PEM Agents node, the EDB Postgres Welcome window opens, allowing you to:

• Click the Add New Server icon to open the Create - Server dialog to define a connection to a server.
• Click the Configure PEM icon to open the Server Configuration dialog and modify server parameters.
• Click the Getting Started icon to open a new tab, displaying the PEM Getting Started section at the EnterpriseDB website.
• Click the EDB Website icon to navigate to the home page of the EnterpriseDB website. The EnterpriseDB website features news about upcoming events and other projects.
• Click the PostgreSQL Website icon to navigate to the PostgreSQL project website. The PostgreSQL site features news about recent releases and other project information.
• Click the EDB Blogs icon to navigate to the EDB Blog page, where you can review the most-recent employee posts to Postgres related blogs.

Highlight the name of an agent or server and navigate to the Dashboard tab to review session or server activity for the currently selected object.

When opened from the name of an agent or server, the Dashboard tab provides a graphical analysis of usage statistics:

• The Server sessions or Database sessions graph displays the interactions with the server or database.
• The Transactions per second graph displays the commits, rollbacks, and total transactions per second that are taking place on the server or database.
• The Tuples In graph displays the number of tuples inserted, updated, and deleted on the server or database.
• The Tuples out graph displays the number of tuples fetched and returned from the server or database.
• The Block I/O graph displays the number of blocks read from the filesystem or fetched from the buffer cache (but not the operating system's file system cache) for the server or database.
• The Server activity tabbed panel displays tables that contain session information, session locks, prepared transactions and configuration.

Navigate to the Properties tab to review the properties of the item currently highlighted in the tree control.

The SQL tab displays the SQL code used to generate the object currently selected in the Browser tree control.

The Statistics tab displays the statistics gathered for each object on the tree control; the statistics displayed in the table vary by the type of object that is highlighted. Click a column heading to sort the table by the data displayed in the column; click again to reverse the sort order. The following table lists some of the statistics that may be displayed:

The Dependencies tab displays the objects on which the currently selected object depends. To ensure the integrity of the database structure, the server makes sure that you do not accidentally drop objects that other objects depend on; you must use DROP CASCADE to remove an object on which another object depends.

The Dependencies table displays:

• The Type field specifies the parent object type.
• The Name field specifies the identifying name of the parent object.
• The Restriction field describes the dependency relationship between the currently selected object and the parent.

The Dependents tab displays a table of objects that depend on the object currently selected in the Browser tree. A dependent object can be dropped without affecting the object currently selected in the Browser tree control.

• The Type field specifies the dependent object type.
• The Name field specifies the identifying name for the dependent object.
• The Restriction field describes the dependency relationship between the currently selected object and the parent.
• Navigate to the Monitoring tab to access information presented on PEM dashboards. Dashboards display statistical information about the objects monitored by the PEM server.

PEM will open additional tabs when you access PEM functionality through the Management or Tools dialogs. Right-click the current tab and select from a context menu that allows you to customize the display for your working style:

• Click Remove Panel to remove the currently selected panel.
• Click Rename Panel to rename the currently selected panel.
• Click Detach Panel to detach the currently selected panel, repositioning it for convenience.
• Click Add Panel and select any of the available options to be added to the panels.

The PEM client will preserve any adjustments when you exit the program; to reset the PEM client to its original format, select Reset Layout from the File menu.

Using Chart, Graph and Table Controls

Use the icons in the upper-right corner of each graphic on a PEM Client dashboard to control, download, and customize the charts, graphs and tables displayed in the PEM client.

Use the Refresh icon to display the most-recent content available from the PEM probes.

Select the Download icon to download a .jpeg or .png image of the chart or graph. By default, the file will be in .jpeg format; to save the file as a .png, use the Personalize icon to modify the download format.

Select the Fullscreen icon to expand the chart or graph to fill the main pane of the PEM client.

Select the Personalize icon to modify the display properties of the chart or graph for your session only.

Use the Information icon to access information about the chart or graph.

Personalizing a Graphic

When you select the Personalize icon, the Personalize chart configuration dialog opens:

Use controls on the Personalize chart configuration dialog to modify the properties of the graphic:

• Use the Auto Refresh control to increase or decrease the number of seconds between refreshes.
• Use the Auto Refresh field to specify the number of seconds between updates of the data displayed in the table or chart.
• If applicable, use the Download as field to indicate if you would like a chart to be downloaded as a JPEG image or a PNG image.
• If applicable, use the Colours selectors to specify the display colors that will be used on a chart.
• If applicable, set the Show Acknowledged Alerts switch to Yes indicate that you would like the table to display alerts that you have acknowledged with a checkbox in the Ack'ed column. Set the field to No to indicate that the table should hide any acknowledged alerts. The switch acts as a toggle; acknowledged alerts are not purged from the table content until the time specified in the alert definition passes.

After personalizing the display properties, use the controls in the upper-right hand corner to apply your changes:

• Use the Delete icon to reset the properties of the graphic to their default settings; use the drop-down listbox to access a menu that allows you to apply the change to only this instance of the graphic, or to the same graphic when displayed on other dashboards.
• Use the Save icon to save your changes to the properties for the graphic; use the drop-down listbox to access a menu that allows you to apply the change to only this instance of the graphic, or to the same graphic when displayed on other dashboards.
• Click the X to close the dialog without changing the properties of the graphic.

• On this page
• The PEM Client Object Browser
• The PEM Tabbed Browser Window
• Using Chart, Graph and Table Controls