PLG$PROF_RECORD_SOURCE_STATS_VIEW
Profiler aggregated view for record source statistics.
Column Name | Data Type | Description |
---|---|---|
|
|
Profile session id |
|
|
Statement id |
|
|
Statement type: |
|
|
Package name |
|
|
Routine name |
|
|
Parent statement id |
|
|
Statement type: |
|
|
Parent routine name |
|
|
SQL text (if statement type is |
|
|
Cursor id |
|
|
Name of explicit cursor |
|
|
PSQL line number of the cursor |
|
|
PSQL column number of the cursor |
|
|
Record source id |
|
|
Parent record source id |
|
|
Indentation level for the record source |
|
|
Access path of the record source |
|
|
Number of times the record source was opened |
|
|
Minimal elapsed time (in nanoseconds) of a record source open |
|
|
Maximum elapsed time (in nanoseconds) of a record source open |
|
|
Accumulated elapsed time (in nanoseconds) of record source opens |
|
|
Average elapsed time (in nanoseconds) of record source opens |
|
|
Number of fetches from the record source |
|
|
Minimal elapsed time (in nanoseconds) of a record source fetch |
|
|
Maximum elapsed time (in nanoseconds) of a record source fetch |
|
|
Accumulated elapsed time (in nanoseconds) of record source fetches |
|
|
Average elapsed time (in nanoseconds) of record source fetches |
|
|
Total elapsed time (in nanoseconds) or record source opens and fetches |