Column | TDV JDBC Data Type | Nullable | Description |
RESOURCE_ID | INTEGER | The resource ID. | |
RESOURCE_NAME | VARCHAR(255) | The resource name. | |
RESOURCE_TYPE | VARCHAR(255) | The resource type. Can be TABLE or DATASOURCE. | |
OWNER_ID | INTEGER | Owner’s user ID. | |
OWNER | VARCHAR(255) | Owner’s name. | |
PARENT_PATH | VARCHAR(255) | Path to the folder that contains the resource. | |
IS_ENABLED | VARCHAR(20) | Indicates if statistics data will be used. Can be true or false. | |
STATUS | VARCHAR(20) | Statistics status: STALE, NOT_LOADED, FAILED, UNKNOWN, or UP. | |
LAST_REFRESH_END | TIMESTAMP | The time the last gather process finished. | |
LAST_SUCCESS_END | TIMESTAMP | The last time gather process finished successfully. | |
LAST_FAIL_END | TIMESTAMP | The last time gather process finished with an error. | |
LAST_SUCCESS_DURATION | BIGINT | Elapsed time (in milliseconds) of the last successful statistics gather process. | |
LAST_FAIL_DURATION | BIGINT | Elapsed time (in milliseconds) of the last failed statistics gather process. | |
NUM_SUCCESS | INTEGER | Number of times stats data was successfully refreshed since last server start. | |
NUM_FAIL | INTEGER | Number of times statistics data failed to refresh since the last time the server started. | |
MESSAGE | VARCHAR(255) | Message that provides additional information for some status types. | |
CURRENT_REFRESH_START | TIMESTAMP | Yes | The time currently running stats gather process started. NULL if not currently running. |
CURRENT_DURATION | BIGINT | Yes | Elapsed time of currently running stats gather process. NULL if not currently running. |