Appendix G. Plugin tables
Plugin tables are tables — or views — created for or by various plugins to the Firebird engine.
The standard plugin tables have the prefix PLG$.
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.
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.
- Section G.1, “
PLG$PROF_CURSORS” Profiler information on cursors
- Section G.2, “
PLG$PROF_PSQL_STATS” Profiler PSQL statistics
- Section G.3, “
PLG$PROF_PSQL_STATS_VIEW” Profiler aggregated view for PSQL statistics
- Section G.4, “
PLG$PROF_RECORD_SOURCES” Profiler information on record sources
- Section G.5, “
PLG$PROF_RECORD_SOURCE_STATS” Profiler record source statistics
- Section G.6, “
PLG$PROF_RECORD_SOURCE_STATS_VIEW” Profiler aggregated view for record source statistics
- Section G.7, “
PLG$PROF_REQUESTS” Profiler information on requests
- Section G.8, “
PLG$PROF_SESSIONS” Profiler sessions
- Section G.9, “
PLG$PROF_STATEMENTS” Profiler information on statements
- Section G.10, “
PLG$PROF_STATEMENT_STATS_VIEW” Profiler aggregated view for statement statistics
- Section G.11, “
PLG$SRP” Users and authentication information of the Srp user manager
- Section G.12, “
PLG$USERS” User and authentication information of the Legacy_UserManager user manager
G.1. PLG$PROF_CURSORS
Profiler information on cursors.
| Column Name | Data Type | Description |
|---|---|---|
|
| Profile session id |
|
| Statement id |
|
| Cursor id |
|
| Name of explicit cursor |
|
| PSQL line number of the cursor |
|
| PSQL column number of the cursor |