SYSTEMSQLEXECUTIONSTEPS: Data Dictionary SQL Execution Steps
read only
- Catálogo:
DataDictionary - Esquema:
Invantive - Label: SQL Execution Steps
Individual processing steps executed by Invantive's UniversalSQL engine during the execution of SQL statements, their relationships and their statistics.
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla SYSTEMSQLEXECUTIONSTEPS. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ALGORITHM |
varchar2 |
Algorithm | How the step went about its work where it had a choice: what a join chose, such as an index join on columns or a nested loop, and for a nested loop why no index was taken.Empty where the step had no choice. | ||
ALIAS |
varchar2 |
Alias | Alias of the result set. | ||
API_ |
int64 |
Llamadas a la API reales | Llamadas a la API reales | ||
API_ |
int64 |
Llamadas a la API desde la Caché del disco | API Calls From Disk Cache | ||
API_ |
int64 |
Llamadas a la API desde la Caché de memoria | API Calls From Memory Cache | ||
API_ |
int64 |
API: Filas reales | API: Filas reales | ||
API_ |
int64 |
Filas de la API procedentes de la Caché del disco | API Rows From Disk Cache | ||
API_ |
int64 |
Filas de la API procedentes de la Caché de memoria | API Rows From Memory Cache | ||
BYTES_ |
int64 |
Bytes en | Number of bytes input. | ||
BYTES_ |
int64 |
Bytes de salida | Number of bytes output. | ||
COLUMNS_ |
int32 |
Columnas en | Number of columns input. | ||
COLUMNS_ |
int32 |
Columnas fuera | Number of columns output. | ||
COUNTERS |
varchar2 |
Counters | What the step itself did, counted, as a JSON object of the counts which are not zero, such as {"PlanBuilds":1,"PairsEvaluated":12}: plans built, expressions found in or added to the expression cache, the algorithm a join chose, pairs a join evaluated, rows sorted.The counts of a statement are the sum over its steps.Empty when the step counted nothing. | ||
DEPTH |
int32 |
Depth | Depth of the step. | ||
DESCRIPTION |
varchar2 |
Description | Description of the step. | ||
DURATION_ |
double |
Tiempo de CPU (ms) | Duration in milliseconds of CPU usage on this step. | ||
DURATION_ |
double |
Duración de E/S (ms) | Duration in milliseconds of the I/O on this step. | ||
DURATION_ |
double |
Duración (ms) | Duration in milliseconds of the step. | ||
DURATION_ |
double |
Duración del sueño (ms) | Duration in milliseconds of the sleep on this step. | ||
DURATION_ |
int64 |
Duración (garrapatas) | Duration in ticks of the step. | ||
END_ |
datetime |
Hora de finalización | Time at which the SQL execution was ended (UTC). | ||
ESTIMATED_ |
int64 |
Número estimado de filas | Rows of the table read by the step as its data container declares them, before any filter; compare with ROWS_OUT.Empty where nothing is declared. | ||
EXECUTION_ |
guid |
ID de ejecución | Unique ID of the SQL statement execution. | ||
EXECUTION_ |
guid |
ID de opciones de ejecución | Execution options ID. | ||
FINGER_ |
varchar2 |
Huella digital | Unique finger print | ||
GC_ |
int32 |
Recogidas de basura de generación 0 en curso | Number of garbage collections of generation 0 in the whole process while the step ran, not counting those of generation 1 and 2.The process runs other statements and work of its own at the same time, so the collections were not necessarily caused by the step, and a step and its children count the same collections.Empty while the step runs. | ||
GC_ |
int32 |
Recogidas de basura de generación 1 en curso | Number of garbage collections of generation 1 in the whole process while the step ran, not counting those of generation 2.The process runs other statements and work of its own at the same time, so the collections were not necessarily caused by the step, and a step and its children count the same collections.Empty while the step runs. | ||
GC_ |
int32 |
Recogidas de basura de generación 2 en curso | Number of full garbage collections, of generation 2, in the whole process while the step ran.The process runs other statements and work of its own at the same time, so the collections were not necessarily caused by the step, and a step and its children count the same collections.Empty while the step runs. | ||
GC_ |
double |
Pausa en la recolección de basura durante el proceso (ms) | Milliseconds in which the garbage collector paused the whole process while the step ran.A pause stops every statement running at that moment, so it is not time lost by the step alone, and a step and its children count the same pauses.Empty while the step runs and on .NET Framework, which does not measure it. | ||
HEAP_ |
int64 |
Bytes asignados en el montón | Number of bytes allocated on the managed heap by the thread of the step, from its start until its end.Counts bytes allocated rather than bytes retained, so it never decreases; a step and its children on one thread both count the same bytes, as they both count the same milliseconds.Empty when the step ended on another thread than the one which started it. | ||
ID |
int64 |
ID | Unique ID of the step. | ||
KIND |
varchar2 |
Tipo de paso | What the step does, such as DataContainerRead, Join, Filter or Sort; empty where the code which made the step did not state it. | ||
MANAGED_ |
int32 |
ID de Hilo Administrado | Managed thread ID. | ||
PARAMETERS |
varchar2 |
Parameters | Parameters of the step. | ||
PARENT_ |
int64 |
Identificación primaria | ID of the parent step. | ||
REQUEST_ |
varchar2 |
Solicitar ID | Request ID. | ||
ROOT_ |
int64 |
ID de raíz | Unique ID of the step at the root of the tree. | ||
ROWS_ |
int64 |
Filas en | Number of rows input. | ||
ROWS_ |
int64 |
Filas hacia afuera | Number of rows output. | ||
SHARED_ |
int64 |
Recuento de bytes añadidos a los objetos compartidos | Recuento de bytes añadidos a los objetos compartidos | ||
SHARED_ |
int64 |
Longitud total de los bytes de los objetos compartidos | Longitud total de los bytes de los objetos compartidos | ||
SHARED_ |
int64 |
Objetos compartidos: bytes ya compartidos, recuento | Objetos compartidos: bytes ya compartidos, recuento | ||
SHARED_ |
int64 |
Objetos compartidos Bytes ya compartidos Longitud | Objetos compartidos Bytes ya compartidos Longitud | ||
SHARED_ |
int64 |
Objetos compartidos, bytes, recuento de reutilizaciones | Objetos compartidos, bytes, recuento de reutilizaciones | ||
SHARED_ |
int64 |
Objetos compartidos Bytes Longitud de reutilización | Objetos compartidos Bytes Longitud de reutilización | ||
SHARED_ |
int64 |
Recuento de adiciones de cadenas en objetos compartidos | Shared Objects Text Add Count | ||
SHARED_ |
int64 |
Objetos compartidos: añadir longitud a una cadena | Shared Objects Text Add Length | ||
SHARED_ |
int64 |
Objetos compartidos: Cadena ya compartida. Recuento | Shared Objects Text Already Shared Count | ||
SHARED_ |
int64 |
Objetos compartidos: cadena ya compartida, longitud | Shared Objects Text Already Shared Length | ||
SHARED_ |
int64 |
Recuento de reutilización de cadenas en objetos compartidos | Shared Objects Text Reuse Count | ||
SHARED_ |
int64 |
Longitud de reutilización de cadenas en objetos compartidos | Shared Objects Text Reuse Length | ||
START_ |
datetime |
Hora de Inicio | Time at which the SQL execution step was started (UTC). | ||
STATEMENT_ |
guid |
ID de estado de cuenta | Unique ID of the SQL statement. | ||
STEP_ |
double |
Reloj de duración de pasos (ms) | Duration in milliseconds of the step (excluding children). | ||
STEP_ |
double |
Pasos CPU Duración (ms) | Duration in milliseconds of CPU usage on this step (excluding children). | ||
STEP_ |
double |
Duración de la E/S por paso (ms) | Duration in milliseconds of the I/O on this step (excluding children). | ||
STEP_ |
double |
Duración del sueño por etapas (ms) | Duration in milliseconds of the sleep on this step (excluding children). | ||
TASK_ |
int32 |
ID de Tarea | Task ID. | ||
THREAD_ |
int64 |
Tiempo de CPU del hilo (ns) | CPU time in nanoseconds, kernel plus user, which the operating system charged to the thread of the step while it ran.A measurement, where DURATION_CPU_MS beside it is the wall clock minus the measured I/O and sleep and therefore also absorbs every wait nobody measured.A step and its children on one thread both count the same time.Empty when the step ended on another thread than the one which started it, or on a platform without a cheap per-thread clock.The resolution of the figure is the resolution of the per-thread clock of the platform, which is coarser than a nanosecond on some of them; a step short enough may therefore report zero rather than a small number. | ||
TOTAL_ |
int64 |
Total de llamadas a la API (reales) | Total de llamadas a la API (reales) | ||
TOTAL_ |
int64 |
Total de llamadas a la API desde la Caché del disco | Total API Calls From Disk Cache | ||
TOTAL_ |
int64 |
Total de llamadas a la API desde la Caché de memoria | Total API Calls From Memory Cache | ||
TOTAL_ |
int64 |
Total de filas de la API (datos reales) | Total de filas de la API (datos reales) | ||
TOTAL_ |
int64 |
Total de filas de la API procedentes de la Caché del disco | Total API Rows From Disk Cache | ||
TOTAL_ |
int64 |
Total de filas de la API procedentes de la Caché de memoria | Total API Rows From Memory Cache | ||
TOTAL_ |
int64 |
Total de objetos compartidos (en bytes) - Recuento de adiciones | Total de objetos compartidos (en bytes) - Recuento de adiciones | ||
TOTAL_ |
int64 |
Total de objetos compartidos (en bytes) + longitud | Total de objetos compartidos (en bytes) + longitud | ||
TOTAL_ |
int64 |
Total de bytes de objetos compartidos ya compartidos: recuento | Total de bytes de objetos compartidos ya compartidos: recuento | ||
TOTAL_ |
int64 |
Total de objetos compartidos (en bytes) ya compartidos: longitud | Total de objetos compartidos (en bytes) ya compartidos: longitud | ||
TOTAL_ |
int64 |
Total de objetos compartidos, bytes, número de reutilizaciones | Total de objetos compartidos, bytes, número de reutilizaciones | ||
TOTAL_ |
int64 |
Total de objetos compartidos, bytes, longitud de reutilización | Total de objetos compartidos, bytes, longitud de reutilización | ||
TOTAL_ |
int64 |
Recuento total de adiciones de cadenas en objetos compartidos | Total Shared Objects Text Add Count | ||
TOTAL_ |
int64 |
Longitud total de las cadenas de los objetos compartidos | Total Shared Objects Text Add Length | ||
TOTAL_ |
int64 |
Total de objetos compartidos Cadena ya compartida Recuento | Total Shared Objects Text Already Shared Count | ||
TOTAL_ |
int64 |
Total de objetos compartidos Cadena ya compartida Longitud | Total Shared Objects Text Already Shared Length | ||
TOTAL_ |
int64 |
Recuento total de reutilización de cadenas en objetos compartidos | Total Shared Objects Text Reuse Count | ||
TOTAL_ |
int64 |
Longitud total de reutilización de cadenas en objetos compartidos | Total Shared Objects Text Reuse Length |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
SYSTEMSQLEXECUTIONSTEPS_ |
EXECUTION_ |
SYSTEMSQLEXECUTIONS.ID |
Key | |
SYSTEMSQLEXECUTIONSTEPS_ |
PARENT_ |
SYSTEMSQLEXECUTIONSTEPS.ID |
Key | |
SYSTEMSQLEXECUTIONSTEPS_ |
ROOT_ |
SYSTEMSQLEXECUTIONSTEPS.ID |
Key | |
SYSTEMSQLEXECUTIONSTEPS_ |
STATEMENT_ |
SYSTEMSQLAREA.ID |
Key |
Referenciado por
- SESSIONIOS
EXECUTION_STEP_ID(Textual) - SYSTEMSQLEXECUTIONSLEEPS
EXECUTION_STEP_ID(Key) - SYSTEMSQLEXECUTIONSTEPS
PARENT_ID(Key) - SYSTEMSQLEXECUTIONSTEPS
ROOT_ID(Key)
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: