Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_analyze	auto_analyze_phase	char(100)
pg_catalog	stl_analyze	database	char(30)
pg_catalog	stl_analyze	endtime	timestamp
pg_catalog	stl_analyze	is_auto	char(1)
pg_catalog	stl_analyze	is_background	char(1)
pg_catalog	stl_analyze	modified_rows	float8
pg_catalog	stl_analyze	num_new_predicate_cols	int4
pg_catalog	stl_analyze	num_predicate_cols	int4
pg_catalog	stl_analyze	prevtime	timestamp
pg_catalog	stl_analyze	rows	float8
pg_catalog	stl_analyze	starttime	timestamp
pg_catalog	stl_analyze	status	char(15)
pg_catalog	stl_analyze	table_id	int4
pg_catalog	stl_analyze	threshold_percent	float8
pg_catalog	stl_analyze	userid	int4
pg_catalog	stl_analyze	xid	int8

View Text

SELECT stll_analyze.userid,
       stll_analyze.xid,
       stll_analyze.database,
       stll_analyze.table_id,
       stll_analyze.status,
       stll_analyze.rows,
       stll_analyze.modified_rows,
       stll_analyze.threshold_percent,
       stll_analyze.is_auto,
       stll_analyze.starttime,
       stll_analyze.endtime,
       stll_analyze.prevtime,
       stll_analyze.num_predicate_cols,
       stll_analyze.num_new_predicate_cols,
       stll_analyze.is_background,
       stll_analyze.auto_analyze_phase
FROM stll_analyze

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