Redshift Observatory

System Table Tracker

System view pg_catalog.stl_datashare_request_producer version 1.0.70890 / 2024-07-14

schema	name	column	data type
pg_catalog	stl_datashare_request_producer	api_call	int4
pg_catalog	stl_datashare_request_producer	backend_start_time	timestamp
pg_catalog	stl_datashare_request_producer	consumeraccountid	char(50)
pg_catalog	stl_datashare_request_producer	consumernamespace	char(50)
pg_catalog	stl_datashare_request_producer	consumer_region	char(64)
pg_catalog	stl_datashare_request_producer	consumer_transaction_uid	char(50)
pg_catalog	stl_datashare_request_producer	dbid	int4
pg_catalog	stl_datashare_request_producer	dbtype	int4
pg_catalog	stl_datashare_request_producer	endtime	timestamp
pg_catalog	stl_datashare_request_producer	handler_start_time	timestamp
pg_catalog	stl_datashare_request_producer	is_versioned_request	int4
pg_catalog	stl_datashare_request_producer	message	char(512)
pg_catalog	stl_datashare_request_producer	obj_name	char(128)
pg_catalog	stl_datashare_request_producer	obj_oid	int4
pg_catalog	stl_datashare_request_producer	obj_type	int4
pg_catalog	stl_datashare_request_producer	overridden_snapshot_xmin	int8
pg_catalog	stl_datashare_request_producer	pid	int4
pg_catalog	stl_datashare_request_producer	producer_cluster_id	char(50)
pg_catalog	stl_datashare_request_producer	requestid	char(50)
pg_catalog	stl_datashare_request_producer	sb_version	int8
pg_catalog	stl_datashare_request_producer	shareid	int4
pg_catalog	stl_datashare_request_producer	sharename	char(128)
pg_catalog	stl_datashare_request_producer	starttime	timestamp
pg_catalog	stl_datashare_request_producer	status	int4
pg_catalog	stl_datashare_request_producer	userid	int4
pg_catalog	stl_datashare_request_producer	xid	int8

View Text

SELECT stll_datashare_request_producer.userid,
       stll_datashare_request_producer.pid,
       stll_datashare_request_producer.requestid,
       stll_datashare_request_producer.sb_version,
       stll_datashare_request_producer.dbtype,
       stll_datashare_request_producer.dbid,
       stll_datashare_request_producer.shareid,
       stll_datashare_request_producer.sharename,
       stll_datashare_request_producer.api_call,
       stll_datashare_request_producer.obj_type,
       stll_datashare_request_producer.obj_oid,
       stll_datashare_request_producer.obj_name,
       stll_datashare_request_producer.starttime,
       stll_datashare_request_producer.endtime,
       stll_datashare_request_producer.status,
       stll_datashare_request_producer.message,
       stll_datashare_request_producer.consumeraccountid,
       stll_datashare_request_producer.consumernamespace,
       stll_datashare_request_producer.consumer_transaction_uid,
       stll_datashare_request_producer.is_versioned_request,
       stll_datashare_request_producer.overridden_snapshot_xmin,
       stll_datashare_request_producer.xid,
       stll_datashare_request_producer.backend_start_time,
       stll_datashare_request_producer.handler_start_time,
       stll_datashare_request_producer.consumer_region,
       stll_datashare_request_producer.producer_cluster_id
FROM stll_datashare_request_producer

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