Ask a Question
Report a Bug
This page in other versions:
Warning: This documentation is for a pre-release version of pgAdmin 4
The Query Tool toolbar uses context-sensitive icons that provide shortcuts to
frequently performed tasks. If an icon is highlighted, the option is enabled;
if the icon is grayed-out, the task is disabled.
The Query Tool and
View/Edit Data tools are actually different operating
modes of the same tool. Some controls will be disabled in either mode.
Hover over an icon in pgAdmin to display a tooltip that describes the icon’s
Click the Save icon to perform a quick-save of a previously saved query, or to access the
Select Save to save the selected content of the SQL Editor panel in a file.
Select Save As to open a new browser dialog and specify a new location to which to save the
selected content of the SQL Editor panel.
Click the Copy icon to copy the content with or without header:
Click the Copy icon to copy the content that is currently highlighted in the Data Output
Click Copy with headers to copy the highlighted content along with the header.
Click the Filter icon to set filtering and sorting criteria for the data when in View/Edit data
mode. Click the down arrow to access other filtering and sorting options:
Click Sort/Filter to open the sorting and filtering dialogue. In the SQL Filter, you can
enter a SQL query as filtering criteria. In Data Sorting, you can select the column and
specify the order for sorting.
Click Filter by Selection to show only the rows containing the values in the selected cells.
Click Exclude by Selection to show only the rows that do not contain the values in the
Click Remove Sort/Filter to remove any previously selected sort or filtering options.
Click the Execute/Refresh icon to either execute or refresh the query highlighted in the SQL
editor panel. Click the down arrow to access other execution options:
Add a check next to Auto-Rollback to instruct the server to automatically roll back a
transaction if an error occurs during the transaction.
Add a check next to Auto-Commit to instruct the server to automatically commit each
transaction. Any changes made by the transaction will be visible to others, and
durable in the event of a crash.
Click the Explain analyze icon to invoke an EXPLAIN ANALYZE command on the current query.
Navigate through the Explain Options menu to select options for the EXPLAIN command:
Select Verbose to display additional information regarding the query plan.
Select Costs to include information on the estimated startup and total cost of each
plan node, as well as the estimated number of rows and the estimated width of each
Select Buffers to include information on buffer usage.
Select Timing to include information about the startup time and the amount of time
spent in each node of the query.
Select Summary to include the summary information about the query plan.
Use options on the Clear drop-down menu to erase display contents:
Select Clear Query Window to erase the content of the SQL Editor panel.
Select Clear History to erase the content of the History tab.