The Firebird 5.0 Language Reference

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

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

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

Profiler aggregated view for statement statistics.

Column Name Data Type Description

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

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

Column Name	Data Type	Description
`PLG$USER_NAME`	`VARCHAR(63)`	Username
`PLG$VERIFIER`	`VARBINARY(128)`	SRP verifier^[1] 1. See http://srp.stanford.edu/design.html for details
`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$USER_NAME

VARCHAR(63)

Username

PLG$VERIFIER

VARBINARY(128)

SRP verifier^[1]

1. See http://srp.stanford.edu/design.html for details

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

Plugin Tables

Plugin tables

PLG$PROF_CURSORS

PLG$PROF_STATEMENT_STATS_VIEW

PLG$SRP

`PLG$PROF_CURSORS`

`PLG$PROF_STATEMENT_STATS_VIEW`

`PLG$SRP`