Table Columns

Query ID. The query column can be used to join other system tables and views.

sliceid

integer

Number that identifies the slice where the query was running.

recordtime

timestamp

Time the record is logged.

pid

integer

Process ID. All of the queries in a session are
run in the same process, so this value remains constant if you run a
series of queries in the same session.

http_method

character(64)

HTTP method name corresponding to the Amazon S3
request.

bucket

character(64)

Amazon S3 bucket name.

key

character(256)

Key corresponding to the Amazon S3 object.

error

character(1024)

Error message.

Usage Notes

If you see multiple errors with "Connection timed out", you might have a
networking issue. If you're using Enhanced VPC Routing, verify that you have a valid
network path between your cluster's VPC and your data resources. For more
information, see Amazon Redshift Enhanced
VPC Routing

Sample Query

The following query returns the errors from COPY commands executed during the
current session.

select query, sliceid, substring(key from 1 for 20) as file,
substring(error from 1 for 35) as error
from stl_s3client_error
where pid = pg_backend_pid()
order by query desc;