Redshift Observatory

System Table Tracker

System view pg_catalog.stl_table_version_events version 1.0.78160 / 2024-11-17

schema	name	column	data type
pg_catalog	stl_table_version_events	event	char(32)
pg_catalog	stl_table_version_events	event_location	char(16)
pg_catalog	stl_table_version_events	new_ddl_end_version	int8
pg_catalog	stl_table_version_events	new_ddl_start_version	int8
pg_catalog	stl_table_version_events	new_dml_version	int8
pg_catalog	stl_table_version_events	new_structure_delete_version	int8
pg_catalog	stl_table_version_events	new_structure_version	int8
pg_catalog	stl_table_version_events	old_ddl_end_version	int8
pg_catalog	stl_table_version_events	old_ddl_start_version	int8
pg_catalog	stl_table_version_events	old_dml_version	int8
pg_catalog	stl_table_version_events	old_structure_delete_version	int8
pg_catalog	stl_table_version_events	old_structure_version	int8
pg_catalog	stl_table_version_events	pid	int8
pg_catalog	stl_table_version_events	record_time	timestamp
pg_catalog	stl_table_version_events	table_id	int4
pg_catalog	stl_table_version_events	xid	int8

View Text

SELECT stll_table_version_events.record_time,
       stll_table_version_events.xid,
       stll_table_version_events.pid,
       stll_table_version_events.table_id,
       stll_table_version_events.old_dml_version,
       stll_table_version_events.new_dml_version,
       stll_table_version_events.old_ddl_end_version,
       stll_table_version_events.new_ddl_end_version,
       stll_table_version_events.old_ddl_start_version,
       stll_table_version_events.new_ddl_start_version,
       stll_table_version_events.old_structure_version,
       stll_table_version_events.new_structure_version,
       stll_table_version_events.old_structure_delete_version,
       stll_table_version_events.new_structure_delete_version,
       stll_table_version_events.event,
       stll_table_version_events.event_location
FROM stll_table_version_events

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