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_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 |
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 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