FirebirdSQL logo

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)