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 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

---