Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_rebuild_info version 1.0.77706 / 2024-11-05

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_ver_dead_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 toast_num_dead_tups int8
pg_catalog stl_catalog_rebuild_info toast_num_live_tups int8
pg_catalog stl_catalog_rebuild_info toast_num_ver_dead_tups int8
pg_catalog stl_catalog_rebuild_info toast_ver_dead_tup_sz_in_bytes 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 total_toast_dead_tup_sz int8
pg_catalog stl_catalog_rebuild_info total_toast_live_tup_sz int8
pg_catalog stl_catalog_rebuild_info tuple_storage_duration_in_msec int8
pg_catalog stl_catalog_rebuild_info ver_dead_tup_sz_in_bytes 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,
       stll_catalog_rebuild_info.toast_num_live_tups,
       stll_catalog_rebuild_info.toast_num_dead_tups,
       stll_catalog_rebuild_info.total_toast_live_tup_sz,
       stll_catalog_rebuild_info.total_toast_dead_tup_sz,
       stll_catalog_rebuild_info.num_ver_dead_tups,
       stll_catalog_rebuild_info.ver_dead_tup_sz_in_bytes,
       stll_catalog_rebuild_info.toast_num_ver_dead_tups,
       stll_catalog_rebuild_info.toast_ver_dead_tup_sz_in_bytes
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