Please enable JavaScript to view this site.

Data Dictionary Data Model

Navigation: » No topics above this level «

PERFORMANCEMEASUREMENTSLIVE: Data Dictionary Live Performance Measurements

Contents Previous Home Next More

Live executed performance benchmarks on currently active data containers.

Catalog: DataDictionary

Schema: Invantive

Alias: pme

Label: Live Performance Measurements

This is a read-only table function. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.

Table Function Columns

The columns of the table function PERFORMANCEMEASUREMENTSLIVE are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

CATALOG

string

Catalog

 

Catalog where the tables are contained in.

DURATION_MS

int64

Duration

 

Duration in milliseconds of the I/O.

ERROR_MESSAGE

string

Error Message

 

Error message that occurred during executing the I/O.

EXECUTION_DATE_UTC

datetime

Execution Date

 

Date at which the I/O was executed (UTC).

ID

int32

ID

 

Unique ID of the property.

PARTITIONS

string

Partitions

 

Partitions on which the I/O was executed.

PROVIDER_DATA_CONTAINER_ALIAS

string(4000)

Data Container Alias

Data container alias.

PROVIDER_DATA_CONTAINER_ID

string(4000)

Data Container ID

Data container ID.

PROVIDER_DESCRIPTION

string(16000)

Provider Description

Provider description.

PROVIDER_NAME

string(240)

Provider Name

Name of the provider.

PROVIDER_SHORT_NAME

string(240)

Provider Short Name

Provider short name.

ROW_COUNT

int64

Rows

 

Number of rows exchanged.

SCHEMA

string

Schema

 

Schema within the catalog where the table is contained in.

SUCCESSFUL

boolean

Succesful

 

Indicator whether the I/O completed successfully.

TABLE_NAME

string

Table Name

 

Name of the table.

 

17-05-2021 11:57 Version 20.1.419-BETA+3191