Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_storage_oid_events	current_ddl_version	int8
pg_catalog	stl_storage_oid_events	current_dml_version	int8
pg_catalog	stl_storage_oid_events	current_sb_version	int8
pg_catalog	stl_storage_oid_events	current_structure_version	int8
pg_catalog	stl_storage_oid_events	database	char(256)
pg_catalog	stl_storage_oid_events	dirtiness_type	char(20)
pg_catalog	stl_storage_oid_events	event	char(256)
pg_catalog	stl_storage_oid_events	host	char(256)
pg_catalog	stl_storage_oid_events	pid	int4
pg_catalog	stl_storage_oid_events	recordtime	timestamp
pg_catalog	stl_storage_oid_events	remote_oid	int4
pg_catalog	stl_storage_oid_events	schema	char(256)
pg_catalog	stl_storage_oid_events	storage_oid_table_count	int4
pg_catalog	stl_storage_oid_events	table_id	int4
pg_catalog	stl_storage_oid_events	table_name	char(256)
pg_catalog	stl_storage_oid_events	table_size	int8
pg_catalog	stl_storage_oid_events	total_grafted_superblock_size	int8
pg_catalog	stl_storage_oid_events	userid	int4
pg_catalog	stl_storage_oid_events	xid	int8

View Text

SELECT stll_storage_oid_events.xid,
       stll_storage_oid_events.event,
       stll_storage_oid_events.table_id,
       stll_storage_oid_events.remote_oid,
       stll_storage_oid_events.userid,
       stll_storage_oid_events.pid,
       stll_storage_oid_events.recordtime,
       stll_storage_oid_events.current_dml_version,
       stll_storage_oid_events.current_structure_version,
       stll_storage_oid_events.current_sb_version,
       stll_storage_oid_events.current_ddl_version,
       stll_storage_oid_events.host,
       stll_storage_oid_events.database,
       stll_storage_oid_events.schema,
       stll_storage_oid_events.table_name,
       stll_storage_oid_events.table_size,
       stll_storage_oid_events.dirtiness_type,
       stll_storage_oid_events.total_grafted_superblock_size,
       stll_storage_oid_events.storage_oid_table_count
FROM stll_storage_oid_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