Top SQL view - PostgreSQL

Administration DBA Top SQL Top SQL view

The Top SQL view lists the 20 slowest database queries. This view requires a system data source and shows all statements in the database cache.

This option is not available if your N4 TOS is hosted by Kaleris. Double-click on a query to view extra detail in the SQL Text form.

The Database Performance Management privilege (on page 1) controls access to this view.

You can use the Actions menu to do the following:

 

Top SQL Columns - PostgreSQL

Short Name

Long Name

Description

Comment

Comment

The comments related to the SQL statement:

  • The default comment displays the user ID, session type, host name, the caller's Java class, and the line of the code that executed the SQL statement. 

  • If the N4 developer has entered a comment, then that comment will be displayed, up to 100 characters.

  • The comments appear on SQL statements that run while the comments are enabled (on page 1). If the SQL comments are disabled, then comments will not appear in this column.

Username

Database connection username

The user associated with executing the SQL statement.

Database Name

Database Name

The name of the database.

First characters

First characters

The first 30 characters of the SQL statement.

Full query

Full query text

The full text of the SQL statement.

Executions

Number of Executions

The number of times that the SQL statement has been executed.

Elapsed

Elapsed time(s)

The total time in seconds of all the executions of the SQL statement.

Elapsed per Exec

Elapsed time per exec(s)

The average execution time in seconds for this SQL statement. This is the (Elapsed) / (Number of Executions).

Rows Result

Rows Retrieved or Affected

The number of rows returned from the last execution of the SQL statement.

Cache Hit %

Buffer Cache Hit Percent

The percentage of reads from the database buffer cache to execute this SQL statement.