Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_catalog_rebuild_info	commit_lock_acq_duration_in_msec	int8
pg_catalog	stl_catalog_rebuild_info	commit_message_mutex_acq_time_in_msec	int8
pg_catalog	stl_catalog_rebuild_info	database	int4
pg_catalog	stl_catalog_rebuild_info	heap_xlog_duration_in_msec	int8
pg_catalog	stl_catalog_rebuild_info	index_xlog_duration_in_msec	int8
pg_catalog	stl_catalog_rebuild_info	message	char(128)
pg_catalog	stl_catalog_rebuild_info	num_dead_tups	int8
pg_catalog	stl_catalog_rebuild_info	num_live_tups	int8
pg_catalog	stl_catalog_rebuild_info	num_xlog_fsyncs	int8
pg_catalog	stl_catalog_rebuild_info	num_xlog_writes	int8
pg_catalog	stl_catalog_rebuild_info	rebuild_duration_in_msec	int8
pg_catalog	stl_catalog_rebuild_info	rebuild_mode	char(8)
pg_catalog	stl_catalog_rebuild_info	repwal_duration_in_msec	int8
pg_catalog	stl_catalog_rebuild_info	starttime	timestamp
pg_catalog	stl_catalog_rebuild_info	startup	int4
pg_catalog	stl_catalog_rebuild_info	table_name	char(64)
pg_catalog	stl_catalog_rebuild_info	table_oid	int8
pg_catalog	stl_catalog_rebuild_info	total_dead_tup_sz	int8
pg_catalog	stl_catalog_rebuild_info	total_duration_in_msec	int8
pg_catalog	stl_catalog_rebuild_info	total_live_tup_sz	int8
pg_catalog	stl_catalog_rebuild_info	tuple_storage_duration_in_msec	int8
pg_catalog	stl_catalog_rebuild_info	versioned_rebuild	int4
pg_catalog	stl_catalog_rebuild_info	versioned_rebuild_pivot_xid	int8
pg_catalog	stl_catalog_rebuild_info	xid	int8
pg_catalog	stl_catalog_rebuild_info	xlog_fsync_duration_in_msec	int8
pg_catalog	stl_catalog_rebuild_info	xlog_insert_lock_acq_time_in_msec	int8
pg_catalog	stl_catalog_rebuild_info	xlog_write_duration_in_msec	int8
pg_catalog	stl_catalog_rebuild_info	xlog_write_lock_acq_time_in_msec	int8

View Text

SELECT stll_catalog_rebuild_info.xid,
       stll_catalog_rebuild_info.database,
       stll_catalog_rebuild_info.table_name,
       stll_catalog_rebuild_info.table_oid,
       stll_catalog_rebuild_info.num_live_tups,
       stll_catalog_rebuild_info.num_dead_tups,
       stll_catalog_rebuild_info.total_live_tup_sz,
       stll_catalog_rebuild_info.total_dead_tup_sz,
       stll_catalog_rebuild_info.starttime,
       stll_catalog_rebuild_info.tuple_storage_duration_in_msec,
       stll_catalog_rebuild_info.commit_lock_acq_duration_in_msec,
       stll_catalog_rebuild_info.rebuild_duration_in_msec,
       stll_catalog_rebuild_info.total_duration_in_msec,
       stll_catalog_rebuild_info.message,
       stll_catalog_rebuild_info.rebuild_mode,
       stll_catalog_rebuild_info.startup,
       stll_catalog_rebuild_info.versioned_rebuild,
       stll_catalog_rebuild_info.versioned_rebuild_pivot_xid,
       stll_catalog_rebuild_info.heap_xlog_duration_in_msec,
       stll_catalog_rebuild_info.index_xlog_duration_in_msec,
       stll_catalog_rebuild_info.xlog_write_duration_in_msec,
       stll_catalog_rebuild_info.xlog_fsync_duration_in_msec,
       stll_catalog_rebuild_info.repwal_duration_in_msec,
       stll_catalog_rebuild_info.xlog_write_lock_acq_time_in_msec,
       stll_catalog_rebuild_info.xlog_insert_lock_acq_time_in_msec,
       stll_catalog_rebuild_info.num_xlog_writes,
       stll_catalog_rebuild_info.num_xlog_fsyncs,
       stll_catalog_rebuild_info.commit_message_mutex_acq_time_in_msec
FROM stll_catalog_rebuild_info

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