onstat -g pqs command: Print operators for all SQL queries
Use the onstat -g pqs command to display information about the operators used in all of the SQL queries that are currently running.
You can specify one of the following invocations:
Invocation | Explanation |
---|---|
onstat -g pqs | Displays a one-line summary for each session. |
onstat -g pqs sessionid | Displays information for the session that you specify. |
Example output
The following example shows
the results when three separate SQL statements are run in different
sessions. The statements are:
select * from syscolumns;
select * from systables a, systables b;
update t1 set rowsize = rowsize +100;
Output description
- addr
- The address of the operator in memory. You can use this address to track which SCAN operator belongs to each JOIN operator.
- ses-id
- The session ID in which the SQL statement was run.
- opname
- The name of the operator.
- phase
- The phase in which the operator was used. For example OPEN, NEXT, CLOSE.
- rows
- The number of rows that are processed by the operator.
- time
- The amount of time to process the operator. The time is displayed to the millisecond. A time of 01:20.10 is 1 minute, 20 seconds, and 10 milliseconds.
- in1
- The first (outer) operator in the join.
- in2
- The second (inner) operator in the join.
- stmt-type
- The type of SQL statement, such as SELECT, UPDATE, DELETE.