Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3client_trace version 1.0.52931 / 2023-07-07

schema name column data type
pg_catalog stl_s3client_trace bucket char(64)
pg_catalog stl_s3client_trace col_num int4
pg_catalog stl_s3client_trace flags int4
pg_catalog stl_s3client_trace http_method char(64)
pg_catalog stl_s3client_trace is_partial int4
pg_catalog stl_s3client_trace is_s3commit_write int4
pg_catalog stl_s3client_trace is_wam_write int4
pg_catalog stl_s3client_trace is_xregion int4
pg_catalog stl_s3client_trace key char(256)
pg_catalog stl_s3client_trace message char(256)
pg_catalog stl_s3client_trace node int4
pg_catalog stl_s3client_trace one_perm_rep int4
pg_catalog stl_s3client_trace pid int4
pg_catalog stl_s3client_trace query int4
pg_catalog stl_s3client_trace recordtime timestamp
pg_catalog stl_s3client_trace region char(64)
pg_catalog stl_s3client_trace s3_action char(64)
pg_catalog stl_s3client_trace s3_write_type char(64)
pg_catalog stl_s3client_trace slice int4
pg_catalog stl_s3client_trace start_offset int8
pg_catalog stl_s3client_trace table_id int4
pg_catalog stl_s3client_trace userid int4
pg_catalog stl_s3client_trace wam_precommit_id int4

View Text

SELECT stll_s3client_trace.userid,
       stll_s3client_trace.query,
       stll_s3client_trace.slice,
       stll_s3client_trace.recordtime,
       stll_s3client_trace.pid,
       stll_s3client_trace.http_method,
       stll_s3client_trace.s3_action,
       stll_s3client_trace.bucket,
       stll_s3client_trace.key,
       stll_s3client_trace.message,
       stll_s3client_trace.node,
       stll_s3client_trace.table_id,
       stll_s3client_trace.one_perm_rep,
       stll_s3client_trace.flags,
       stll_s3client_trace.s3_write_type,
       stll_s3client_trace.is_s3commit_write,
       stll_s3client_trace.is_partial,
       stll_s3client_trace.start_offset,
       stll_s3client_trace.col_num,
       stll_s3client_trace.is_wam_write,
       stll_s3client_trace.wam_precommit_id,
       stll_s3client_trace.region,
       stll_s3client_trace.is_xregion
FROM stll_s3client_trace


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