FirebirdSQL logo
 Security tablesCharacter Sets and Collations 

PLG$USERS

User and authentication information of the Legacy_UserManager user manager, used for authentication by the Legacy_Auth authentication plugins.

Column Name Data Type Description

PLG$USER_NAME

VARCHAR(63)

Username

PLG$GROUP_NAME

VARCHAR(63)

Group name

PLG$UID

INTEGER

User id

PLG$GID

INTEGER

Group id

PLG$PASSWD

VARBINARY(64)

Password hash

PLG$COMMENT

BLOB TEXT

Comment text

PLG$FIRST_NAME

VARCHAR(32)

Firstname

PLG$MIDDLE_NAME

VARCHAR(32)

Middle name

PLG$LAST_NAME

VARCHAR(32)

Lastname

PLG$PROF_PSQL_STATS

Profiler PSQL statistics.

Column Name Data Type Description

PROFILE_ID

BIGINT

Profile session id

STATEMENT_ID

BIGINT

Statement id

REQUEST_ID

BIGINT

Request id

LINE_NUM

INTEGER

PSQL line number of the statement

COLUMN_NUM

INTEGER

PSQL column number of the statement

COUNTER

BIGINT

Number of executed times of the line/column

MIN_ELAPSED_TIME

BIGINT

Minimal elapsed time (in nanoseconds) of a line/column execution

MAX_ELAPSED_TIME

BIGINT

Maximum elapsed time (in nanoseconds) of a line/column execution

TOTAL_ELAPSED_TIME

BIGINT

Accumulated elapsed time (in nanoseconds) of the line/column executions