Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3client version 1.0.51304 / 2023-06-04

schema name column data type
pg_catalog stl_s3client app_connect_time int8
pg_catalog stl_s3client bucket char(64)
pg_catalog stl_s3client col_num int4
pg_catalog stl_s3client compression_time int8
pg_catalog stl_s3client connect_time int8
pg_catalog stl_s3client data_size int8
pg_catalog stl_s3client end_time int8
pg_catalog stl_s3client extended_request_id char(128)
pg_catalog stl_s3client flags int4
pg_catalog stl_s3client http_method char(64)
pg_catalog stl_s3client ip_address char(64)
pg_catalog stl_s3client is_partial int4
pg_catalog stl_s3client is_s3commit_write int4
pg_catalog stl_s3client is_spectrum_request int4
pg_catalog stl_s3client is_wam_write int4
pg_catalog stl_s3client is_xregion int4
pg_catalog stl_s3client key char(256)
pg_catalog stl_s3client node int4
pg_catalog stl_s3client one_perm_rep int4
pg_catalog stl_s3client original_start_time_us int8
pg_catalog stl_s3client pid int4
pg_catalog stl_s3client query int4
pg_catalog stl_s3client recordtime timestamp
pg_catalog stl_s3client region char(64)
pg_catalog stl_s3client request_id char(32)
pg_catalog stl_s3client retries int4
pg_catalog stl_s3client s3_action char(64)
pg_catalog stl_s3client s3_write_type char(64)
pg_catalog stl_s3client segnum int8
pg_catalog stl_s3client slice int4
pg_catalog stl_s3client start_offset int8
pg_catalog stl_s3client start_time int8
pg_catalog stl_s3client tbl_id int4
pg_catalog stl_s3client thread_id int4
pg_catalog stl_s3client total_transfer_time_us_with_retries int8
pg_catalog stl_s3client transfer_size int8
pg_catalog stl_s3client transfer_time int8
pg_catalog stl_s3client userid int4
pg_catalog stl_s3client wam_precommit_id int4

View Text

SELECT stll_s3client.userid,
       stll_s3client.query,
       stll_s3client.slice,
       stll_s3client.recordtime,
       stll_s3client.pid,
       stll_s3client.http_method,
       stll_s3client.s3_action,
       stll_s3client.bucket,
       stll_s3client.key,
       stll_s3client.transfer_size,
       stll_s3client.data_size,
       stll_s3client.start_time,
       stll_s3client.end_time,
       stll_s3client.transfer_time,
       stll_s3client.compression_time,
       stll_s3client.connect_time,
       stll_s3client.app_connect_time,
       stll_s3client.retries,
       stll_s3client.request_id,
       stll_s3client.extended_request_id,
       stll_s3client.ip_address,
       stll_s3client.thread_id,
       stll_s3client.original_start_time_us,
       stll_s3client.total_transfer_time_us_with_retries,
       stll_s3client.node,
       stll_s3client.tbl_id,
       stll_s3client.one_perm_rep,
       stll_s3client.flags,
       stll_s3client.s3_write_type,
       stll_s3client.is_s3commit_write,
       stll_s3client.is_partial,
       stll_s3client.start_offset,
       stll_s3client.col_num,
       stll_s3client.is_wam_write,
       stll_s3client.wam_precommit_id,
       stll_s3client.region,
       stll_s3client.is_xregion,
       stll_s3client.is_spectrum_request,
       stll_s3client.segnum
FROM stll_s3client


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