LoggedStatements Table

Structure

CREATE TABLE "LoggedStatements"
(
"ExecutedOn" TIMESTAMP,
"User" VARCHAR(40) COLLATE "ANSI_CI",
"Process" VARCHAR(40) COLLATE "ANSI_CI",
"SessionID" INTEGER,
"SessionName" VARCHAR(40) COLLATE "ANSI_CI",
"SessionDescription" CLOB COLLATE "ANSI",
"DatabaseName" VARCHAR(40) COLLATE "ANSI_CI",
"SQL" CLOB COLLATE "ANSI_CI",
"ExecutionTime" FLOAT,
"RowsAffected" INTEGER
)

Description

This table contains the SQL statements that have been logged while SQL statement logging was enabled for ElevateDB via the ENABLE STATEMENT LOGGING statement. This information is useful in determining which SQL statements are causing performance issues in the ElevateDB engine or ElevateDB Server.

The SQL statement logging is engine-wide functionality, which means that this table represents the slowest SQL statements across all sessions, not just the current session that is querying this table.

The current user must be granted the system-defined Administrators role in order to view this table. Please see the User Security topic for more information.

Related DDL Statements

Statement

Description

ENABLE STATEMENT LOGGING	Enables SQL statement logging
DISABLE STATEMENT LOGGING	Disables SQL statement logging

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap