Redshift Observatory

System Table Tracker

System view pg_catalog.svl_s3query version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	svl_s3query	avg_request_duration	int8
pg_catalog	svl_s3query	avg_request_parallelism	float8
pg_catalog	svl_s3query	elapsed	int8
pg_catalog	svl_s3query	endtime	timestamp
pg_catalog	svl_s3query	external_table_name	text
pg_catalog	svl_s3query	file_format	char(16)
pg_catalog	svl_s3query	files	int4
pg_catalog	svl_s3query	is_nested	char(1)
pg_catalog	svl_s3query	is_partitioned	char(1)
pg_catalog	svl_s3query	is_rrscan	char(1)
pg_catalog	svl_s3query	max_concurrent_slowdown_count	int4
pg_catalog	svl_s3query	max_request_duration	int8
pg_catalog	svl_s3query	max_request_parallelism	int4
pg_catalog	svl_s3query	max_retries	int4
pg_catalog	svl_s3query	max_split_size	int8
pg_catalog	svl_s3query	node	int4
pg_catalog	svl_s3query	query	int4
pg_catalog	svl_s3query	s3query_returned_bytes	int8
pg_catalog	svl_s3query	s3query_returned_rows	int8
pg_catalog	svl_s3query	s3_scanned_bytes	int8
pg_catalog	svl_s3query	s3_scanned_rows	int8
pg_catalog	svl_s3query	segment	int4
pg_catalog	svl_s3query	slice	int4
pg_catalog	svl_s3query	slowdown_count	int4
pg_catalog	svl_s3query	splits	int4
pg_catalog	svl_s3query	starttime	timestamp
pg_catalog	svl_s3query	step	int4
pg_catalog	svl_s3query	total_retries	int4
pg_catalog	svl_s3query	total_split_size	int8
pg_catalog	svl_s3query	userid	int4

View Text

SELECT stl_s3query.userid,
       stl_s3query.query,
       stl_s3query.segment,
       stl_s3query.step,
       stl_s3query.node,
       stl_s3query.slice,
       stl_s3query.starttime,
       stl_s3query.endtime,
       date_diff(CAST('us' AS text),
                 stl_s3query.starttime,
                 stl_s3query.endtime) AS elapsed,
       btrim(CAST(stl_s3query.external_table_name AS text)) AS external_table_name,
       stl_s3query.file_format,
       stl_s3query.is_partitioned,
       stl_s3query.is_rrscan,
       stl_s3query.is_nested,
       stl_s3query.s3_scanned_rows,
       stl_s3query.s3_scanned_bytes,
       stl_s3query.s3query_returned_rows,
       stl_s3query.s3query_returned_bytes,
       stl_s3query.files,
       stl_s3query.splits,
       stl_s3query.total_split_size,
       stl_s3query.max_split_size,
       stl_s3query.total_retries,
       stl_s3query.max_retries,
       stl_s3query.max_request_duration,
       stl_s3query.avg_request_duration,
       stl_s3query.max_request_parallelism,
       stl_s3query.avg_request_parallelism,
       stl_s3query.slowdown_count,
       stl_s3query.max_concurrent_slowdown_count
FROM stl_s3query
WHERE stl_s3query.is_copy = 0

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers