User guide

The user activity log is useful primarily for troubleshooting purposes. It tracks information about the types
of queries that both the users and the system perform in the database.
The connection log and user log both correspond to information that is stored in the system tables in your
database.You can use the system tables to obtain the same information, but the log files provide an
easier mechanism for retrieval and review. The log files rely on Amazon S3 permissions rather than
database permissions to perform queries against the tables. Additionally, by viewing the information in
log files rather than querying the system tables, you reduce any impact of interacting with the database.
Connection Log
Logs authentication attempts, and connections and disconnections. The following table describes the
information in the connection log.
DescriptionColumn name
Connection or authentication event.event
Time the event occurred.recordtime
Name or IP address of remote host.remotehost
Port number for remote host.remoteport
Process ID associated with the statement.pid
Database name.dbname
User name.username
Authentication method.authmethod
Duration of connection in microseconds.duration
User Log
Records details for the following changes to a database user:
• Create user
• Drop user
• Alter user (rename)
• Alter user (alter properties)
DescriptionColumn name
ID of the user who generated the entry.userid
User name of the user affected by the change.username
For a rename action, the original user name. For any other action, this field is empty.oldusername
API Version 2012-12-01
216
Amazon Redshift Management Guide
Connection Log