The onstat -g pqs command displays the operators for all SQL queries.
Query Operators: addr ses-id opname phase rows time in1 in2 stmt-type ----------------------------------------------------------------------------------- 6cdb9538 201012 sort close 7 00:00.00 6cdb9838 0 6cdb9838 201012 scan close 7 00:00.00 0 0 6db8f8c8 200987 sort close 1 00:00.00 6c99b038 0 6c99b038 200987 scan close 6 00:00.00 0 0 3da3fa038 22905965 sort create 0 00:00.00 3da3fa438 0 3da3fa438 22905965 scan next 2177 00:00.00 0 0 22820742 - wbe DR Wait 60 0 0 9.35 Off 22662219 - wbe DR Wait 60 0 0 9.35 Off 22617207 - resource DR Wait 60 0 0 9.35 Off 22616715 - resource DR Wait 60 0 0 9.35 Off 22616711 - resource DR Wait 60 0 0 9.35 Off 22571703 - wbe DR Wait 60 0 0 9.35 Off
Field | 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. |
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.