Redshift Observatory

System Table Tracker

System view pg_catalog.stl_incremental_resize_state version 1.0.60140 / 2023-11-19

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	incresize_mapping_method	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	src_localslicenum	int4
pg_catalog	stl_incremental_resize_state	src_nodenum	int4
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,
       stll_incremental_resize_state.src_nodenum,
       stll_incremental_resize_state.src_localslicenum,
       stll_incremental_resize_state.incresize_mapping_method
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