Redshift Observatory

System Table Tracker

System view pg_catalog.stl_datashare_changes_consumer version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	stl_datashare_changes_consumer	action	int4
pg_catalog	stl_datashare_changes_consumer	actiontime	timestamp
pg_catalog	stl_datashare_changes_consumer	arn	char(192)
pg_catalog	stl_datashare_changes_consumer	initial_query_time	timestamp
pg_catalog	stl_datashare_changes_consumer	message	char(512)
pg_catalog	stl_datashare_changes_consumer	pid	int4
pg_catalog	stl_datashare_changes_consumer	produceraccount	char(12)
pg_catalog	stl_datashare_changes_consumer	producernamespace	char(128)
pg_catalog	stl_datashare_changes_consumer	sharedbid	int4
pg_catalog	stl_datashare_changes_consumer	sharedbname	char(128)
pg_catalog	stl_datashare_changes_consumer	sharename	char(128)
pg_catalog	stl_datashare_changes_consumer	status	int4
pg_catalog	stl_datashare_changes_consumer	targetid	int4
pg_catalog	stl_datashare_changes_consumer	targetname	char(128)
pg_catalog	stl_datashare_changes_consumer	targettype	int4
pg_catalog	stl_datashare_changes_consumer	userid	int4
pg_catalog	stl_datashare_changes_consumer	username	char(128)
pg_catalog	stl_datashare_changes_consumer	xid	int8

View Text

SELECT stll_datashare_changes_consumer.userid,
       stll_datashare_changes_consumer.username,
       stll_datashare_changes_consumer.xid,
       stll_datashare_changes_consumer.pid,
       stll_datashare_changes_consumer.initial_query_time,
       stll_datashare_changes_consumer.actiontime,
       stll_datashare_changes_consumer.action,
       stll_datashare_changes_consumer.sharedbid,
       stll_datashare_changes_consumer.sharedbname,
       stll_datashare_changes_consumer.sharename,
       stll_datashare_changes_consumer.produceraccount,
       stll_datashare_changes_consumer.producernamespace,
       stll_datashare_changes_consumer.targettype,
       stll_datashare_changes_consumer.targetid,
       stll_datashare_changes_consumer.targetname,
       stll_datashare_changes_consumer.status,
       stll_datashare_changes_consumer.message,
       stll_datashare_changes_consumer.arn
FROM stll_datashare_changes_consumer

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