Online Documentation for SQL Manager for InterBase/Firebird

Viewing statements

The Statements tab of Database Monitor allows you to view the list of statements being currently executed in the database.

The window consists of two basic areas: Statement List and Statement Text.

The Statement List area displays the statements as a grid with the following columns:

ID, User, State, Start time, Protocol, Remote address.

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.

The Statement Text area displays the corresponding SELECT statement used to get data from system tables.

Statements management tools are available through the Navigation bar and toolbar of Database Monitor.