FirebirdSQL logo
 Security tablesCharacter Sets and Collations 

Plugin tables are tables — or views — created for or by various plugins to the Firebird engine. The standard plugin tables have the prefix PLG$.

Important

The plugin tables do not always exist. For example, some tables only exist in the security database, and other tables will only be created on first use of a plugin.

This appendix only documents plugin tables which are created by plugins included in a standard Firebird 5.0 deployment.

Plugin tables are not considered system tables.
Note
Profiler table names are plugin-specific

The tables listed in this appendix for the profiler (starting with PLG$PROF_) are created by the Default_Profiler plugin. If a custom profiler plugin is created, it may use different table names.
List of plugin tables
[fblangref50-appx07-profcursors]

Profiler information on cursors

[fblangref50-appx07-profpsqlstats]

Profiler PSQL statistics

[fblangref50-appx07-profpsqlstatsview]

Profiler aggregated view for PSQL statistics

[fblangref50-appx07-profrecordsources]

Profiler information on record sources

[fblangref50-appx07-profrecordsourcestats]

Profiler record source statistics

[fblangref50-appx07-profrecordsourcestatsview]

Profiler aggregated view for record source statistics

[fblangref50-appx07-profrequests]

Profiler information on requests

[fblangref50-appx07-profsessions]

Profiler sessions

[fblangref50-appx07-profstatements]

Profiler information on statements

[fblangref50-appx07-profstatementstatsview]

Profiler aggregated view for statement statistics

[fblangref50-appx07-srp]

Users and authentication information of the Srp user manager

[fblangref50-appx07-users]

User and authentication information of the Legacy_UserManager user manager

PLG$PROF_CURSORS

Profiler information on cursors.

Column Name Data Type Description

PROFILE_ID

BIGINT

Profile session id

STATEMENT_ID

BIGINT

Statement id

CURSOR_ID

INTEGER

Cursor id

NAME

CHAR(63)

Name of explicit cursor

LINE_NUM

INTEGER

PSQL line number of the cursor

COLUMN_NUM

INTEGER

PSQL column number of the cursor

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

PLG$PROF_PSQL_STATS_VIEW

Profiler aggregated view for PSQL 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)

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)

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

AVG_ELAPSED_TIME

BIGINT

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

PLG$PROF_RECORD_SOURCES

Profiler information on record sources.

Column Name Data Type Description

PROFILE_ID

BIGINT

Profile session id

STATEMENT_ID

BIGINT

Statement id

CURSOR_ID

INTEGER

Cursor id

RECORD_SOURCE_ID

INTEGER

Record source id

PARENT_RECORD_SOURCE_ID

INTEGER

Parent record source id

LEVEL

INTEGER

Indentation level for the record source

ACCESS_PATH

VARCHAR(255)

Access path of the record source

PLG$PROF_RECORD_SOURCE_STATS

Profiler record sources statistics.

Column Name Data Type Description

PROFILE_ID

BIGINT

Profile session id

STATEMENT_ID

BIGINT

Statement id

REQUEST_ID

BIGINT

Request id

CURSOR_ID

INTEGER

Cursor id

RECORD_SOURCE_ID

INTEGER

Record source id

OPEN_COUNTER

BIGINT

Number of times the record source was opened

OPEN_MIN_ELAPSED_TIME

BIGINT

Minimal elapsed time (in nanoseconds) of a record source open

OPEN_MAX_ELAPSED_TIME

BIGINT

Maximum elapsed time (in nanoseconds) of a record source open

OPEN_TOTAL_ELAPSED_TIME

BIGINT

Accumulated elapsed time (in nanoseconds) of record source opens

FETCH_COUNTER

BIGINT

Number of fetches from the record source

FETCH_MIN_ELAPSED_TIME

BIGINT

Minimal elapsed time (in nanoseconds) of a record source fetch

FETCH_MAX_ELAPSED_TIME

BIGINT

Maximum elapsed time (in nanoseconds) of a record source fetch

FETCH_TOTAL_ELAPSED_TIME

BIGINT

Accumulated elapsed time (in nanoseconds) of record source fetches

PLG$PROF_RECORD_SOURCE_STATS_VIEW

Profiler aggregated view for record source 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)

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)

CURSOR_ID

INTEGER

Cursor id

CURSOR_NAME

CHAR(63)

Name of explicit cursor

CURSOR_LINE_NUM

INTEGER

PSQL line number of the cursor

CURSOR_COLUMN_NUM

INTEGER

PSQL column number of the cursor

RECORD_SOURCE_ID

INTEGER

Record source id

PARENT_RECORD_SOURCE_ID

INTEGER

Parent record source id

LEVEL

INTEGER

Indentation level for the record source

ACCESS_PATH

VARCHAR(255)

Access path of the record source

OPEN_COUNTER

BIGINT

Number of times the record source was opened

OPEN_MIN_ELAPSED_TIME

BIGINT

Minimal elapsed time (in nanoseconds) of a record source open

OPEN_MAX_ELAPSED_TIME

BIGINT

Maximum elapsed time (in nanoseconds) of a record source open

OPEN_TOTAL_ELAPSED_TIME

BIGINT

Accumulated elapsed time (in nanoseconds) of record source opens

OPEN_AVG_ELAPSED_TIME

BIGINT

Average elapsed time (in nanoseconds) of record source opens

FETCH_COUNTER

BIGINT

Number of fetches from the record source

FETCH_MIN_ELAPSED_TIME

BIGINT

Minimal elapsed time (in nanoseconds) of a record source fetch

FETCH_MAX_ELAPSED_TIME

BIGINT

Maximum elapsed time (in nanoseconds) of a record source fetch

FETCH_TOTAL_ELAPSED_TIME

BIGINT

Accumulated elapsed time (in nanoseconds) of record source fetches

FETCH_AVG_ELAPSED_TIME

BIGINT

Average elapsed time (in nanoseconds) of record source fetches

OPEN_FETCH_TOTAL_ELAPSED_TIME

BIGINT

Total elapsed time (in nanoseconds) or record source opens and fetches

PLG$PROF_REQUESTS

Profiler information on requests.

Column Name Data Type Description

PROFILE_ID

BIGINT

Profile session id

STATEMENT_ID

BIGINT

Statement id

REQUEST_ID

BIGINT

Request id

CALLER_STATEMENT_ID

BIGINT

Caller statement id

CALLER_REQUEST_ID

BIGINT

Caller request id

START_TIMESTAMP

TIMESTAMP WITH TIME ZONE

Instant when request started

FINISH_TIMESTAMP

TIMESTAMP WITH TIME ZONE

Instant when request finished

TOTAL_ELAPSED_TIME

BIGINT

Accumulated elapsed time (in nanoseconds) of the request

PLG$PROF_SESSIONS

Profiler sessions.

Column Name Data Type Description

PROFILE_ID

BIGINT

Profile session id

ATTACHMENT_ID

BIGINT

Attachment id

USER_NAME

CHAR(63)

User which started the profile session

DESCRIPTION

VARCHAR(255)

Description of the profile session (parameter of RDB$PROFILER.START_SESSION)

START_TIMESTAMP

TIMESTAMP WITH TIME ZONE

Instant when session started

FINISH_TIMESTAMP

TIMESTAMP WITH TIME ZONE

Instant when session finished

PLG$PROF_STATEMENTS

Profiler information on statements.

Column Name Data Type Description

PROFILE_ID

BIGINT

Profile session id

STATEMENT_ID

BIGINT

Statement id

PARENT_STATEMENT_ID

BIGINT

Parent 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

SQL_TEXT

BLOB TEXT

SQL text (if statement type is BLOCK)

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

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