gp_log_command_timings
The gp_toolkit.gp_log_command_timings view uses an external table to read the log files on the master and report the run time of SQL commands in a database session.
The use of this view requires superuser permissions.
| Column | Description |
|---|---|
logsession |
The session identifier (prefixed with |
logcmdcount |
The command number within a session (prefixed with |
logdatabase |
The name of the database |
loguser |
The name of the database user |
logpid |
The process ID (prefixed with |
logtimemin |
The time of the first log message for this command |
logtimemax |
The time of the last log message for this command |
logduration |
Statement duration from start to end time |