Online Documentation for SQL Manager for PostgreSQL

Viewing Locks

The Locks tab of the Server Status viewer displays the current locks outstanding in the PostgreSQL Lock Manager. This information can be useful when attempting to debug or track down deadlocks on your server.

The list displays the locks as a grid with the following columns: PID, Database, Relation, User, Transaction, Access Mode, Granted, Query Start, Query. If more convenient, you can change the order of the columns by dragging their headers horizontally.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.

Right-click an item within the list to call the context menu allowing you to refresh the list or cancel execution of a query.

Locks view tools are also available through the Navigation bar of the Server Status viewer. Using the Navigation bar you can also set the Refresh Rate for the lock list.