Redshift Observatory

System Table Tracker

System view pg_catalog.stl_datashare_dsms version 1.0.40677 / 2022-08-14

schema	name	column	data type
pg_catalog	stl_datashare_dsms	apicall	int4
pg_catalog	stl_datashare_dsms	endtime	timestamp
pg_catalog	stl_datashare_dsms	initial_query_time	timestamp
pg_catalog	stl_datashare_dsms	message	char(512)
pg_catalog	stl_datashare_dsms	pid	int4
pg_catalog	stl_datashare_dsms	produceraccount	char(12)
pg_catalog	stl_datashare_dsms	producernamespace	char(128)
pg_catalog	stl_datashare_dsms	requestid	char(50)
pg_catalog	stl_datashare_dsms	role	int4
pg_catalog	stl_datashare_dsms	shareid	int4
pg_catalog	stl_datashare_dsms	sharename	char(128)
pg_catalog	stl_datashare_dsms	starttime	timestamp
pg_catalog	stl_datashare_dsms	status	int4
pg_catalog	stl_datashare_dsms	userid	int4
pg_catalog	stl_datashare_dsms	username	char(128)
pg_catalog	stl_datashare_dsms	xid	int8

View Text

SELECT stll_datashare_dsms.userid,
       stll_datashare_dsms.username,
       stll_datashare_dsms.xid,
       stll_datashare_dsms.pid,
       stll_datashare_dsms.initial_query_time,
       stll_datashare_dsms.requestid,
       stll_datashare_dsms.shareid,
       stll_datashare_dsms.sharename,
       stll_datashare_dsms.produceraccount,
       stll_datashare_dsms.producernamespace,
       stll_datashare_dsms.role,
       stll_datashare_dsms.apicall,
       stll_datashare_dsms.starttime,
       stll_datashare_dsms.endtime,
       stll_datashare_dsms.status,
       stll_datashare_dsms.message
FROM stll_datashare_dsms

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