Redshift Observatory

System Table Tracker

System view pg_catalog.svl_datashare_usage_producer version 1.0.72982 / 2024-08-17

schema	name	column	data type
pg_catalog	svl_datashare_usage_producer	consumer_account	varchar(16)
pg_catalog	svl_datashare_usage_producer	consumer_namespace	varchar(64)
pg_catalog	svl_datashare_usage_producer	consumer_region	varchar(64)
pg_catalog	svl_datashare_usage_producer	consumer_transaction_uid	varchar(50)
pg_catalog	svl_datashare_usage_producer	error	varchar(512)
pg_catalog	svl_datashare_usage_producer	object_name	varchar(128)
pg_catalog	svl_datashare_usage_producer	object_oid	int4
pg_catalog	svl_datashare_usage_producer	object_type	varchar(64)
pg_catalog	svl_datashare_usage_producer	recordtime	timestamp
pg_catalog	svl_datashare_usage_producer	request_id	varchar(50)
pg_catalog	svl_datashare_usage_producer	request_type	varchar(25)
pg_catalog	svl_datashare_usage_producer	share_id	int4
pg_catalog	svl_datashare_usage_producer	share_name	varchar(128)
pg_catalog	svl_datashare_usage_producer	status	int4

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