Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

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