FirebirdSQL logo

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)