Redshift Observatory

System Table Tracker

System view pg_catalog.svl_datashare_usage_producer version 1.0.66960 / 2024-04-27

View Text

SELECT stl_datashare_request_producer.shareid AS share_id,
       CAST(btrim(CAST(stl_datashare_request_producer.sharename AS text)) AS varchar(128)) AS share_name,
       CAST(stl_datashare_request_producer.requestid AS varchar(50)) AS request_id,
       CAST(CASE
              WHEN stl_datashare_request_producer.api_call = 5
                THEN CAST('GET FUNCTION' AS text)
              WHEN stl_datashare_request_producer.api_call = 14
                OR stl_datashare_request_producer.api_call = 15
                THEN CAST('BATCH GET RELATION' AS text)
              ELSE CAST('GET RELATION' AS text)
            END AS varchar(25)) AS request_type,
       CAST(CASE
              WHEN stl_datashare_request_producer.obj_type = 2
                THEN CAST('TABLE' AS text)
              WHEN stl_datashare_request_producer.obj_type = 3
                THEN CAST('VIEW' AS text)
              WHEN stl_datashare_request_producer.obj_type = 4
                THEN CAST('LATE BINDING VIEW' AS text)
              WHEN stl_datashare_request_producer.obj_type = 5
                THEN CAST('MATERIALIZED VIEW' AS text)
              WHEN stl_datashare_request_producer.obj_type = 6
                THEN CAST('FUNCTION' AS text)
              WHEN stl_datashare_request_producer.obj_type = 12
                THEN CAST('BATCH OF OBJECTS' AS text)
              ELSE CAST('UNKNOWN' AS text)
            END AS varchar(64)) AS object_type,
       stl_datashare_request_producer.obj_oid AS object_oid,
       CAST(btrim(CAST(stl_datashare_request_producer.obj_name AS text)) AS varchar(128)) AS object_name,
       CAST(stl_datashare_request_producer.consumeraccountid AS varchar(16)) AS consumer_account,
       CAST(stl_datashare_request_producer.consumernamespace AS varchar(64)) AS consumer_namespace,
       CAST(stl_datashare_request_producer.consumer_transaction_uid AS varchar(50)) AS consumer_transaction_uid,
       stl_datashare_request_producer.endtime AS recordtime,
       stl_datashare_request_producer.status,
       CAST(stl_datashare_request_producer.message AS varchar(512)) AS error,
       CAST(stl_datashare_request_producer.consumer_region AS varchar(64)) AS consumer_region
FROM stl_datashare_request_producer
WHERE stl_datashare_request_producer.shareid <> 0
  AND ((stl_datashare_request_producer.api_call >= 2
    AND stl_datashare_request_producer.api_call <= 5)
    OR (stl_datashare_request_producer.api_call >= 14
    AND stl_datashare_request_producer.api_call <= 15))

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