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;
Query Operators:
addr ses-id opname phase rows time in1 in2 stmt-type
ae50b3a 23 scan open 0 00:00.00 0 0 SELECT
af269d0 5 nljoin next 224717 00:01.82 af26a90 aeb4478 SELECT
af26a90 5 scan next 472 00:00.20 0 0 SELECT
aeb4478 5 scan next 50 00:01.63 0 0 SELECT
ad3c530 26 scan open 0 00:00.00 0 0 UPDATE (all)
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.