Redshift Observatory

System Table Tracker

System view pg_catalog.svl_datashare_usage_consumer version 1.0.56952 / 2023-09-29

schema	name	column	data type
pg_catalog	svl_datashare_usage_consumer	error	varchar(512)
pg_catalog	svl_datashare_usage_consumer	pid	int4
pg_catalog	svl_datashare_usage_consumer	recordtime	timestamp
pg_catalog	svl_datashare_usage_consumer	request_id	varchar(50)
pg_catalog	svl_datashare_usage_consumer	request_type	varchar(25)
pg_catalog	svl_datashare_usage_consumer	retry_times	int4
pg_catalog	svl_datashare_usage_consumer	status	int4
pg_catalog	svl_datashare_usage_consumer	transaction_uid	varchar(50)
pg_catalog	svl_datashare_usage_consumer	userid	int4
pg_catalog	svl_datashare_usage_consumer	xid	int8

View Text

SELECT stl_datashare_request_consumer.userid,
       stl_datashare_request_consumer.pid,
       stl_datashare_request_consumer.xid,
       CAST(stl_datashare_request_consumer.requestid AS varchar(50)) AS request_id,
       CAST(CASE
              WHEN stl_datashare_request_consumer.api_call = 5
                THEN CAST('GET FUNCTION' AS text)
              WHEN stl_datashare_request_consumer.api_call = 14
                OR stl_datashare_request_consumer.api_call = 15
                THEN CAST('BATCH GET RELATION' AS text)
              ELSE CAST('GET RELATION' AS text)
            END AS varchar(25)) AS request_type,
       CAST(stl_datashare_request_consumer.transaction_uid AS varchar(50)) AS transaction_uid,
       stl_datashare_request_consumer.endtime AS recordtime,
       CASE
         WHEN stl_datashare_request_consumer.status = 29550
           THEN 29500
         WHEN stl_datashare_request_consumer.status = 29551
           THEN 29501
         WHEN stl_datashare_request_consumer.status = 29552
           THEN 29502
         WHEN stl_datashare_request_consumer.status = 29553
           THEN 29503
         WHEN stl_datashare_request_consumer.status = 29554
           THEN 29504
         ELSE stl_datashare_request_consumer.status
       END AS status,
       CAST(stl_datashare_request_consumer.message AS varchar(512)) AS error,
       stl_datashare_request_consumer.retry_times
FROM stl_datashare_request_consumer
WHERE ((stl_datashare_request_consumer.api_call >= 2
    AND stl_datashare_request_consumer.api_call <= 5)
    OR (stl_datashare_request_consumer.api_call >= 14
    AND stl_datashare_request_consumer.api_call <= 15))
  AND stl_datashare_request_consumer.dbtype > 0

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