Security tablesCharacter Sets and Collations

`PLG$PROF_PSQL_STATS`

Profiler PSQL statistics.

Column Name Data Type Description

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

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

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

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

docnext count = 6

`PLG$PROF_RECORD_SOURCES`

Profiler information on record sources.

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

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

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

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

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

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

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

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

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

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

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

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)