Redshift Observatory

System Table Tracker

System view pg_catalog.stl_datashare_write_history version 1.0.105373 / 2025-01-09

schema	name	column	data type
pg_catalog	stl_datashare_write_history	consumer_transaction_uid	char(64)
pg_catalog	stl_datashare_write_history	db_id	int4
pg_catalog	stl_datashare_write_history	db_name	char(128)
pg_catalog	stl_datashare_write_history	deleted_row_count	int4
pg_catalog	stl_datashare_write_history	inserted_row_count	int4
pg_catalog	stl_datashare_write_history	object_id	int4
pg_catalog	stl_datashare_write_history	object_name	char(128)
pg_catalog	stl_datashare_write_history	object_type	char(64)
pg_catalog	stl_datashare_write_history	query_type	char(64)
pg_catalog	stl_datashare_write_history	record_time	timestamp
pg_catalog	stl_datashare_write_history	transaction_id	int8
pg_catalog	stl_datashare_write_history	user_id	int4
pg_catalog	stl_datashare_write_history	user_name	char(128)
pg_catalog	stl_datashare_write_history	vpid	int4

View Text

SELECT stll_datashare_write_history.user_id,
       stll_datashare_write_history.user_name,
       stll_datashare_write_history.vpid,
       stll_datashare_write_history.transaction_id,
       stll_datashare_write_history.consumer_transaction_uid,
       stll_datashare_write_history.db_id,
       stll_datashare_write_history.db_name,
       stll_datashare_write_history.object_type,
       stll_datashare_write_history.object_id,
       stll_datashare_write_history.object_name,
       stll_datashare_write_history.query_type,
       stll_datashare_write_history.record_time,
       stll_datashare_write_history.inserted_row_count,
       stll_datashare_write_history.deleted_row_count
FROM stll_datashare_write_history

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