SVL_S3LOG

Use the SVL_S3LOG view to get details about Amazon Redshift Spectrum queries at the segment and node slice level.

SVL_S3LOG is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.

Table columns

Column name	Data type	Description
pid	integer	The process ID.
query	integer	The query ID.
segment	integer	The segment number. A query consists of multiple segments, and each segment consists of one or more steps.
step	integer	The query step that ran.
node	integer	The node number.
slice	integer	The data slice that a particular segment ran against.
eventtime	timestamp	Time in UTC that the step started executing.
message	text	Message for the log entry.

Sample query

The following example queries SVL_S3LOG for the last query that ran.

select * 
from svl_s3log 
where query = pg_last_query_id() 
order by query,segment,slice;