Redshift Observatory

System Table Tracker

System view pg_catalog.svl_datashare_usage_consumer version 1.0.46806 / 2023-02-21

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	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,
       CASE
         WHEN stl_datashare_request_consumer.api_call = 5
           THEN CAST(CAST('GET FUNCTION' AS varchar) AS varchar(25))
         ELSE CAST(CAST('GET RELATION' AS varchar) AS varchar(25))
       END AS request_type,
       CAST(stl_datashare_request_consumer.transaction_uid AS varchar(50)) AS transaction_uid,
       stl_datashare_request_consumer.endtime AS recordtime,
       stl_datashare_request_consumer.status,
       CAST(stl_datashare_request_consumer.message AS varchar(512)) AS error
FROM stl_datashare_request_consumer
WHERE stl_datashare_request_consumer.api_call >= 2
  AND stl_datashare_request_consumer.api_call <= 5
  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