Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog stl_incremental_resize_state blockchainmetachainblocks int4
pg_catalog stl_incremental_resize_state datablocks int4
pg_catalog stl_incremental_resize_state distallblocks int4
pg_catalog stl_incremental_resize_state distallrows int8
pg_catalog stl_incremental_resize_state globalslicenum int4
pg_catalog stl_incremental_resize_state leadersnapshotblocks int4
pg_catalog stl_incremental_resize_state localslicenum int4
pg_catalog stl_incremental_resize_state metachainblocks int4
pg_catalog stl_incremental_resize_state metadatablocks int4
pg_catalog stl_incremental_resize_state nodenum int4
pg_catalog stl_incremental_resize_state persist_temp_tables_state char(100)
pg_catalog stl_incremental_resize_state pgwalblocks int4
pg_catalog stl_incremental_resize_state resizeid char(128)
pg_catalog stl_incremental_resize_state resizephase char(32)
pg_catalog stl_incremental_resize_state resizeplanstate char(32)
pg_catalog stl_incremental_resize_state rows int8
pg_catalog stl_incremental_resize_state starttime timestamp
pg_catalog stl_incremental_resize_state temp_blocks int4
pg_catalog stl_incremental_resize_state temp_distall_blocks int4
pg_catalog stl_incremental_resize_state temp_distall_rows int8
pg_catalog stl_incremental_resize_state temp_rows int8

View Text

SELECT stll_incremental_resize_state.resizeid,
       stll_incremental_resize_state.starttime,
       stll_incremental_resize_state.resizephase,
       stll_incremental_resize_state.resizeplanstate,
       stll_incremental_resize_state.nodenum,
       stll_incremental_resize_state.globalslicenum,
       stll_incremental_resize_state.localslicenum,
       stll_incremental_resize_state.datablocks,
       stll_incremental_resize_state.metadatablocks,
       stll_incremental_resize_state.distallblocks,
       stll_incremental_resize_state.metachainblocks,
       stll_incremental_resize_state.blockchainmetachainblocks,
       stll_incremental_resize_state.leadersnapshotblocks,
       stll_incremental_resize_state.pgwalblocks,
       stll_incremental_resize_state.rows,
       stll_incremental_resize_state.distallrows,
       stll_incremental_resize_state.persist_temp_tables_state,
       stll_incremental_resize_state.temp_blocks,
       stll_incremental_resize_state.temp_distall_blocks,
       stll_incremental_resize_state.temp_rows,
       stll_incremental_resize_state.temp_distall_rows
FROM stll_incremental_resize_state


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