Redshift Research Project

System Table Tracker

System Table Version 1.0.41533 / 2022-09-18

schema name column data type
pg_catalog stl_alter_dist_sort cutoff_xid int8
pg_catalog stl_alter_dist_sort dest_rows int8
pg_catalog stl_alter_dist_sort dst_sorted_rows int8
pg_catalog stl_alter_dist_sort event char(128)
pg_catalog stl_alter_dist_sort eventtime timestamp
pg_catalog stl_alter_dist_sort is_autoworker_altered int4
pg_catalog stl_alter_dist_sort nth_checkpoint int4
pg_catalog stl_alter_dist_sort num_sort_iterations int4
pg_catalog stl_alter_dist_sort num_sort_keys int4
pg_catalog stl_alter_dist_sort origin_dist_style int4
pg_catalog stl_alter_dist_sort pid int4
pg_catalog stl_alter_dist_sort redo_delete_rows int8
pg_catalog stl_alter_dist_sort request_sort int4
pg_catalog stl_alter_dist_sort shadow_tbl_num_blocks int8
pg_catalog stl_alter_dist_sort src_rows int8
pg_catalog stl_alter_dist_sort src_table_num_blocks int8
pg_catalog stl_alter_dist_sort target_distkey int4
pg_catalog stl_alter_dist_sort tbl int4
pg_catalog stl_alter_dist_sort undone_rows int8
pg_catalog stl_alter_dist_sort undone_txns int8
pg_catalog stl_alter_dist_sort xid int8

View Text

SELECT stll_alter_dist_sort.xid,
       stll_alter_dist_sort.cutoff_xid,
       stll_alter_dist_sort.tbl,
       stll_alter_dist_sort.event,
       stll_alter_dist_sort.src_rows,
       stll_alter_dist_sort.dest_rows,
       stll_alter_dist_sort.redo_delete_rows,
       stll_alter_dist_sort.undone_rows,
       stll_alter_dist_sort.undone_txns,
       stll_alter_dist_sort.eventtime,
       stll_alter_dist_sort.origin_dist_style,
       stll_alter_dist_sort.num_sort_keys,
       stll_alter_dist_sort.target_distkey,
       stll_alter_dist_sort.request_sort,
       stll_alter_dist_sort.num_sort_iterations,
       stll_alter_dist_sort.dst_sorted_rows,
       stll_alter_dist_sort.is_autoworker_altered,
       stll_alter_dist_sort.src_table_num_blocks,
       stll_alter_dist_sort.nth_checkpoint,
       stll_alter_dist_sort.pid,
       stll_alter_dist_sort.shadow_tbl_num_blocks
FROM stll_alter_dist_sort


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