Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

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_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 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
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