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:
Option | Action |
---|---|
Add named restore point | Click 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 Server | Click to establish a connection with the selected server. |
Create | Click to access a context menu that provides context-sensitive selections.Your selection opens a Create dialog for creating a new object. |
CREATE Script | Click to open the Query tool to edit or view the CREATE script. |
CREATE Script | Click to open the Query tool to edit or view the CREATE script. |
Dashboards | Click through for quick access to PEM dashboards. |
Delete/Drop | Click 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 Cascade | Click to delete the currently selected object and all dependent objects from the server. |
Debugging | Click to access the Debugger tool. |
Grant Wizard | Click to access the Grant Wizard tool. |
Maintenance... | Click to open the Maintenance... dialog to VACUUM, ANALYZE, REINDEX, or CLUSTER. |
Management | Click 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 Data | Use 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:
Option | Action |
---|---|
Import/Export... | Click open the [Import/Export...](#import_export_data) dialog to import data to or export data from the selected table. |
Reset Statistics | Click to reset statistics for the selected table. |
Scripts | Click to open the Query tool to edit or view the selected script from the flyout menu. |
Truncate | Click to remove all rows from a table. |
Truncate Cascade | Click to remove all rows from a table and its child tables. |
View First 100 Rows | Click to access the data grid that displays the first 100 rows of the selected table. |
View Last 100 Rows | Click to access the data grid that displays the last 100 rows of the selected table. |
View All Rows | Click 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.
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
orDatabase 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:
Panel | Description |
---|---|
PID | The process ID associated with the row. |
User | The name of the user that owns the object. |
Database | displays the database name. |
Backends | displays the number of current connections to the database. |
Backend start | The start time of the backend process. |
Xact Committed | displays the number of transactions committed to the database within the last week. |
Xact Rolled Back | displays the number of transactions rolled back within the last week. |
Blocks Read | displays the number of blocks read from memory (in megabytes) within the last week. |
Blocks Hit | displays the number of blocks hit in the cache (in megabytes) within the last week. |
Tuples Returned | displays the number of tuples returned within the last week. |
Tuples Fetched | displays the number of tuples fetched within the last week. |
Tuples Inserted | displays the number of tuples inserted into the database within the last week. |
Tuples Updated | displays the number of tuples updated in the database within the last week. |
Tuples Deleted | displays the number of tuples deleted from the database within the last week. |
Last statistics reset | displays the time of the last statistics reset for the database. |
Tablespace conflicts | displays the number of queries canceled because of recovery conflict with dropped tablespaces in database. |
Lock conflicts | displays the number of queries canceled because of recovery conflict with locks in database. |
Snapshot conflicts | displays the number of queries canceled because of recovery conflict with old snapshots in database. |
Bufferpin conflicts | displays the number of queries canceled because of recovery conflict with pinned buffers in database. |
Temporary files | displays the total number of temporary files, including those used by the statistics collector. |
Size of temporary files | displays the size of the temporary files. |
Deadlocks | displays the number of queries canceled because of a recovery conflict with deadlocks in database. |
Block read time | displays the number of milliseconds required to read the blocks read. |
Block write time | displays the number of milliseconds required to write the blocks read. |
Size | displays the size (in megabytes) of the selected database. |
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 toYes
indicate that you would like the table to display alerts that you have acknowledged with a checkbox in theAck'ed
column. Set the field toNo
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.