Plugin Tables

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