The Firebird 5.0 Language Reference

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