Redshift Observatory

System Table Tracker

System view pg_catalog.stl_sorted_checker_leader version 1.0.60140 / 2023-11-19

schema	name	column	data type
pg_catalog	stl_sorted_checker_leader	colid	int8
pg_catalog	stl_sorted_checker_leader	compression	int4
pg_catalog	stl_sorted_checker_leader	datatype	int4
pg_catalog	stl_sorted_checker_leader	dbname	char(128)
pg_catalog	stl_sorted_checker_leader	endtime	timestamp
pg_catalog	stl_sorted_checker_leader	fixer	int4
pg_catalog	stl_sorted_checker_leader	num_incorrect_sorted_rows	int8
pg_catalog	stl_sorted_checker_leader	qid	int8
pg_catalog	stl_sorted_checker_leader	relid	int8
pg_catalog	stl_sorted_checker_leader	schema	char(128)
pg_catalog	stl_sorted_checker_leader	sorted_corrupt	int4
pg_catalog	stl_sorted_checker_leader	starttime	timestamp
pg_catalog	stl_sorted_checker_leader	tablename	char(128)
pg_catalog	stl_sorted_checker_leader	version	int4
pg_catalog	stl_sorted_checker_leader	xid	int8

View Text

SELECT stll_sorted_checker_leader.starttime,
       stll_sorted_checker_leader.endtime,
       stll_sorted_checker_leader.xid,
       stll_sorted_checker_leader.qid,
       stll_sorted_checker_leader.dbname,
       stll_sorted_checker_leader.schema,
       stll_sorted_checker_leader.tablename,
       stll_sorted_checker_leader.relid,
       stll_sorted_checker_leader.colid,
       stll_sorted_checker_leader.datatype,
       stll_sorted_checker_leader.compression,
       stll_sorted_checker_leader.sorted_corrupt,
       stll_sorted_checker_leader.num_incorrect_sorted_rows,
       stll_sorted_checker_leader.fixer,
       stll_sorted_checker_leader.version
FROM stll_sorted_checker_leader

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