Redshift Observatory

System Table Tracker

System view pg_catalog.stl_state_table_column_metadata version 1.0.76913 / 2024-10-24

schema	name	column	data type
pg_catalog	stl_state_table_column_metadata	column_id	int4
pg_catalog	stl_state_table_column_metadata	num_blocks	int8
pg_catalog	stl_state_table_column_metadata	row_count	int8
pg_catalog	stl_state_table_column_metadata	slice	int4
pg_catalog	stl_state_table_column_metadata	table_id	int4
pg_catalog	stl_state_table_column_metadata	temp	int4
pg_catalog	stl_state_table_column_metadata	timestamp	int8

View Text

SELECT stll_state_table_column_metadata.timestamp,
       stll_state_table_column_metadata.slice,
       stll_state_table_column_metadata.table_id,
       stll_state_table_column_metadata.column_id,
       stll_state_table_column_metadata.num_blocks,
       stll_state_table_column_metadata.row_count,
       stll_state_table_column_metadata.temp
FROM stll_state_table_column_metadata

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