catalog.profiles table
The catalog.profiles table contains timing information for running SQL commands from client connections. SQL profiling is enabled by using the Profile property or -profile command-line option.
SQL profile statistics are also logged to the file $NCHOME/omnibus/log/servername_profiler_report.logn, at the interval specified in the ProfileStatsInterval property or -profilestatsinterval command-line option.
The following table describes the columns in the catalog.profiles table.
| Column name | Data type | Description |
|---|---|---|
| ConnectionID | integer | Connection identifier. |
| UID | integer | User identifier. |
| AppName | varchar(40) | Name of the connected application. |
| HostName | varchar(40) | Name of the connected host. |
| ProfiledFrom | time | Time at which profiling began. |
| LastSQLTime | real | Duration, in seconds, of the last SQL command. |
| MinSQLTime | real | Shortest running time, in seconds, for this client. |
| MaxSQLTime | real | Longest running time, in seconds, for this client. |
| PeriodSQLTime | real | Amount of time, in seconds, that the application has spent running SQL since the last profile report. |
| TotalSQLTime | real | Total time, in seconds, for running all SQL commands for this client. |
| LastTimingAt | time | Last time an SQL profile was taken for this client. |
| NumSubmits | integer | Number of submissions for this client. A single submission can contain multiple SQL commands, run with the go command. |
| TotalParseTime | real | Records the total amount of time spent parsing commands for this client. |
| TotalResolveTime | real | Records the total amount of time spent resolving commands for this client. |
| TotalExecTime | real | Records the total amount of time spent running commands for this client. |