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.

PEM browser window

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:

OptionAction
Add named restore pointClick to create and enter the name of a restore point.
Backup...Click to open the Backup... dialog to backup database objects.
Backup Globals...Click to open the Backup Globals... dialog to backup cluster objects.
Backup Server...Click to open the Backup Server... dialog to backup a server.
Connect ServerClick to establish a connection with the selected server.
CreateClick to access a context menu that provides context-sensitive selections.Your selection opens a Create dialog for creating a new object.
CREATE ScriptClick to open the Query tool to edit or view the CREATE script.
CREATE ScriptClick to open the Query tool to edit or view the CREATE script.
DashboardsClick through for quick access to PEM dashboards.
Delete/DropClick to delete the currently selected object from the server.
Disconnect Database...Click to terminate a database connection.
Disconnect Server...Click to refresh the currently selected object.
Drop CascadeClick to delete the currently selected object and all dependent objects from the server.
DebuggingClick to access the Debugger tool.
Grant WizardClick to access the Grant Wizard tool.
Maintenance...Click to open the Maintenance... dialog to VACUUM, ANALYZE, REINDEX, or CLUSTER.
ManagementClick to access management tasks that are relevant to the node.
Properties...Click to review or modify the currently selected object's properties.
Refresh...Click to refresh the currently selected object.
Reload Configuration...Click to update configuration files without restarting the server.
Restore...Click to access the Restore dialog to restore database files from a backup.
View DataUse the View Data option to access the data stored in a selected table with the Data Output tab of the Query tool.

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

OptionAction
Import/Export...Click open the [Import/Export...](#import_export_data) dialog to import data to or export data from the selected table.
Reset StatisticsClick to reset statistics for the selected table.
ScriptsClick to open the Query tool to edit or view the selected script from the flyout menu.
TruncateClick to remove all rows from a table.
Truncate CascadeClick to remove all rows from a table and its child tables.
View First 100 RowsClick to access the data grid that displays the first 100 rows of the selected table.
View Last 100 RowsClick to access the data grid that displays the last 100 rows of the selected table.
View All RowsClick to access the data grid that displays all rows of the selected table.
View Filtered Rows...Click to access the Data Filter popup to apply a filter to a set of data.

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.

PEM browser - Welcome dashboard tab

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.

PEM browser - Dashboard tab

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.

PEM browser - Properties tab

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

PEM browser - SQL tab

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

PEM browser - Statistics tab

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:

PanelDescription
PIDThe process ID associated with the row.
UserThe name of the user that owns the object.
Databasedisplays the database name.
Backendsdisplays the number of current connections to the database.
Backend startThe start time of the backend process.
Xact Committeddisplays the number of transactions committed to the database within the last week.
Xact Rolled Backdisplays the number of transactions rolled back within the last week.
Blocks Readdisplays the number of blocks read from memory (in megabytes) within the last week.
Blocks Hitdisplays the number of blocks hit in the cache (in megabytes) within the last week.
Tuples Returneddisplays the number of tuples returned within the last week.
Tuples Fetcheddisplays the number of tuples fetched within the last week.
Tuples Inserteddisplays the number of tuples inserted into the database within the last week.
Tuples Updateddisplays the number of tuples updated in the database within the last week.
Tuples Deleteddisplays the number of tuples deleted from the database within the last week.
Last statistics resetdisplays the time of the last statistics reset for the database.
Tablespace conflictsdisplays the number of queries canceled because of recovery conflict with dropped tablespaces in database.
Lock conflictsdisplays the number of queries canceled because of recovery conflict with locks in database.
Snapshot conflictsdisplays the number of queries canceled because of recovery conflict with old snapshots in database.
Bufferpin conflictsdisplays the number of queries canceled because of recovery conflict with pinned buffers in database.
Temporary filesdisplays the total number of temporary files, including those used by the statistics collector.
Size of temporary filesdisplays the size of the temporary files.
Deadlocksdisplays the number of queries canceled because of a recovery conflict with deadlocks in database.
Block read timedisplays the number of milliseconds required to read the blocks read.
Block write timedisplays the number of milliseconds required to write the blocks read.
Sizedisplays the size (in megabytes) of the selected database.

PEM browser - Dependencies tab

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.

PEM browser - Dependents tab

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 browser - Global Overview tab

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.

PEM Agent and Server Status

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

Select the Download icon download 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 fullscreen to expand the chart or graph to fill the main pane of the PEM client.

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

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

Personalizing a Graphic

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

PEM personalize chart options

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.