Redshift Observatory

System Table Tracker

System view pg_catalog.svl_datashare_usage_consumer version 1.0.70695 / 2024-07-11

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