Ask a Question
Report a Bug
This page in other versions:
Warning: This documentation is for a pre-release version of pgAdmin 4
The right pane of the pgAdmin window features a collection of tabs that
display information about the object currently selected in the pgAdmin tree
control in the left window. Select a tab to access information about the
highlighted object in the tree control.
The graphs on the Dashboard tab provides an active analysis of the usage
statistics for the selected server or database:
The Server activity panel displays information about sessions, locks, prepared
transactions, and server configuration (if applicable). The information is
presented in context-sensitive tables. Use controls located above the table to:
You can use icons in the Sessions table to review or control the state of a
The Properties tab displays information about the object selected.
Click the Delete icon in the toolbar under the browser tab to delete the
selected objects in the Properties panel.
Click the Drop Cascade icon in the toolbar under the browser tab to delete the
selected objects and all dependent objects in the Properties panel.
Click the Edit icon in the toolbar under the browser tabs to launch the
Properties dialog for the selected object.
To preserve any changes to the Properties dialog, click the Save icon; your
modifications will be displayed in the updated Properties tab.
Details about the object highlighted in the tree control are displayed in one or
more collapsible panels. You can use the arrow to the left of each panel label
to open or close a panel.
The SQL tab displays the SQL script that created the highlighted object, and
when applicable, a (commented out) SQL statement that will DROP the selected
object. You can copy the SQL statements to the editor of your choice using cut
and paste shortcuts.
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 selected. 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 are available:
The Dependencies tab displays the objects on which the currently selected
object depends. If a dependency is dropped, the object currently selected in
the pgAdmin tree control will be affected. To ensure the integrity of the entire
database structure, the database server makes sure that you do not accidentally
drop objects that other objects depend on; you must use the DROP CASCADE command
to remove an object with a dependency.
The Dependencies table displays the following information:
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:
If the field is auto, the selected object can be dropped separately from
the parent object, and will be dropped if the parent object is dropped.
If the field is internal, the selected object was created during the
creation of the parent object, and will be dropped if the parent object
If the field is normal, the selected object can be dropped without
dropping the parent object.
If the field is blank, the selected object is required by the system,
and cannot be dropped.
The Dependents tab displays a table of objects that depend on the object
currently selected in the pgAdmin browser. A dependent object can be dropped
without affecting the object currently selected in the pgAdmin tree control.
Additional tabs open when you access the extended functionality offered by
pgAdmin tools (such as the Query tool, Debugger, or SQL editor). Use the close
icon (X) located in the upper-right corner of each tab to close the tab when you
are finished using the tool. Like permanent tabs, these tabs may be repositioned
in the pgAdmin client window.
By default, each time you open a tool, pgAdmin will open a new browser tab. You
can control this behavior by modifying the Display node of the Preferences
dialog for each tool. To open the Preferences dialog, select Preferences
from the File menu.