FirebirdSQL logo
 Security tablesCharacter Sets and Collations 

PLG$PROF_STATEMENT_STATS_VIEW

Profiler aggregated view for statement statistics.

Column Name Data Type Description

PROFILE_ID

BIGINT

Profile session id

STATEMENT_ID

BIGINT

Statement id

STATEMENT_TYPE

VARCHAR(20)

Statement type: BLOCK, FUNCTION, PROCEDURE or TRIGGER

PACKAGE_NAME

CHAR(63)

Package name

ROUTINE_NAME

CHAR(63)

Routine name

PARENT_STATEMENT_ID

BIGINT

Parent statement id

PARENT_STATEMENT_TYPE

VARCHAR(20)

Parent statement type: BLOCK, FUNCTION, PROCEDURE or TRIGGER

PARENT_ROUTINE_NAME

CHAR(63)

Parent routine name

SQL_TEXT

BLOB TEXT

SQL text (if statement type is BLOCK)

COUNTER

BIGINT

Number of executed times of the line/column

MIN_ELAPSED_TIME

BIGINT

Minimal elapsed time (in nanoseconds) of a statement execution

MAX_ELAPSED_TIME

BIGINT

Maximum elapsed time (in nanoseconds) of a statement execution

TOTAL_ELAPSED_TIME

BIGINT

Accumulated elapsed time (in nanoseconds) of statement executions

AVG_ELAPSED_TIME

BIGINT

Average elapsed time (in nanoseconds) of statement executions

PLG$SRP

User and authentication information of the Srp user manager, used for authentication by the Srp family of authentication plugins.

Column Name Data Type Description

PLG$USER_NAME

VARCHAR(63)

Username

PLG$VERIFIER

VARBINARY(128)

SRP verifier[1]

PLG$SALT

VARBINARY(32)

User-specific salt

PLG$COMMENT

BLOB TEXT

Comment text

PLG$FIRST

VARCHAR(32)

Firstname

PLG$MIDDLE

VARCHAR(32)

Middle name

PLG$LAST

VARCHAR(32)

Lastname

PLG$ATTRIBUTES

BLOB TEXT

User attributes (a.k.a. tags)

PLG$ACTIVE

BOOLEAN

Active or inactive user