Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_rebuild_info version 1.0.77777 / 2024-11-10

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