FirebirdSQL logo

PLG$PROF_PSQL_STATS

Profiler PSQL statistics.

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

PLG$PROF_PSQL_STATS_VIEW

Profiler aggregated view for PSQL 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)

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

PLG$PROF_RECORD_SOURCES

Profiler information on record sources.

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

PLG$PROF_RECORD_SOURCE_STATS

Profiler record sources statistics.

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