Redshift Observatory

System Table Tracker

System view pg_catalog.stl_truncate_history version 1.0.62312 / 2024-01-27

schema	name	column	data type
pg_catalog	stl_truncate_history	is_extended_protocol	int4
pg_catalog	stl_truncate_history	is_safe	int4
pg_catalog	stl_truncate_history	is_temp	int4
pg_catalog	stl_truncate_history	is_user	int4
pg_catalog	stl_truncate_history	logtime	timestamp
pg_catalog	stl_truncate_history	query_text	char(256)
pg_catalog	stl_truncate_history	table_id	int4
pg_catalog	stl_truncate_history	table_name	char(128)
pg_catalog	stl_truncate_history	xid	int8

View Text

SELECT stll_truncate_history.logtime,
       stll_truncate_history.xid,
       stll_truncate_history.table_id,
       stll_truncate_history.table_name,
       stll_truncate_history.is_temp,
       stll_truncate_history.is_safe,
       stll_truncate_history.is_extended_protocol,
       stll_truncate_history.is_user,
       stll_truncate_history.query_text
FROM stll_truncate_history

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