PLG$PROF_REQUESTS

Security tablesCharacter Sets and Collations

`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