| 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 |
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,
stl_datashare_request_consumer.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