G.6. 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 |