Redshift Observatory

System Table Tracker

System view pg_catalog.stl_datashare_dsms version 1.0.51304 / 2023-06-04

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