Redshift Observatory

System Table Tracker

System view pg_catalog.stl_commit_internal_stats version 1.0.57864 / 2023-10-14

schema	name	column	data type
pg_catalog	stl_commit_internal_stats	blocks_pending_write	int8
pg_catalog	stl_commit_internal_stats	encrypted_log_blocks_written	int4
pg_catalog	stl_commit_internal_stats	headers_swept	int8
pg_catalog	stl_commit_internal_stats	index_log_regenerated	int4
pg_catalog	stl_commit_internal_stats	lastackwaittime	float8
pg_catalog	stl_commit_internal_stats	log_based	int4
pg_catalog	stl_commit_internal_stats	log_based_flags	int4
pg_catalog	stl_commit_internal_stats	log_blocks_written	int4
pg_catalog	stl_commit_internal_stats	metadata_delta_validated	int4
pg_catalog	stl_commit_internal_stats	new_sb_tree_blocks	int8
pg_catalog	stl_commit_internal_stats	node	int4
pg_catalog	stl_commit_internal_stats	numacksprocessed	int8
pg_catalog	stl_commit_internal_stats	num_metadata_blocks_retained	int4
pg_catalog	stl_commit_internal_stats	num_modified_hdrs_tracked	int8
pg_catalog	stl_commit_internal_stats	numreadsprocessed	int8
pg_catalog	stl_commit_internal_stats	pendingwritesissued	int8
pg_catalog	stl_commit_internal_stats	prefetchesskipped	int8
pg_catalog	stl_commit_internal_stats	processtime	float8
pg_catalog	stl_commit_internal_stats	sb_size	int8
pg_catalog	stl_commit_internal_stats	sb_sweep_optimized_commit	int4
pg_catalog	stl_commit_internal_stats	sb_sweep_tracking	int4
pg_catalog	stl_commit_internal_stats	sb_tree_blocks	int8
pg_catalog	stl_commit_internal_stats	sb_version	int8
pg_catalog	stl_commit_internal_stats	tablebasedtosseligible	int4
pg_catalog	stl_commit_internal_stats	tables_changed	int4
pg_catalog	stl_commit_internal_stats	tables_swept	int4
pg_catalog	stl_commit_internal_stats	tables_total	int4
pg_catalog	stl_commit_internal_stats	tossed_sb_tree_blocks	int8
pg_catalog	stl_commit_internal_stats	total_metadata_blocks	int4
pg_catalog	stl_commit_internal_stats	xid	int8

View Text

SELECT stll_commit_internal_stats.xid,
       stll_commit_internal_stats.node,
       stll_commit_internal_stats.prefetchesskipped,
       stll_commit_internal_stats.numreadsprocessed,
       stll_commit_internal_stats.numacksprocessed,
       stll_commit_internal_stats.tablebasedtosseligible,
       stll_commit_internal_stats.lastackwaittime,
       stll_commit_internal_stats.processtime,
       stll_commit_internal_stats.log_based,
       stll_commit_internal_stats.log_based_flags,
       stll_commit_internal_stats.index_log_regenerated,
       stll_commit_internal_stats.tables_total,
       stll_commit_internal_stats.tables_swept,
       stll_commit_internal_stats.headers_swept,
       stll_commit_internal_stats.tables_changed,
       stll_commit_internal_stats.blocks_pending_write,
       stll_commit_internal_stats.num_metadata_blocks_retained,
       stll_commit_internal_stats.total_metadata_blocks,
       stll_commit_internal_stats.sb_size,
       stll_commit_internal_stats.num_modified_hdrs_tracked,
       stll_commit_internal_stats.sb_sweep_tracking,
       stll_commit_internal_stats.sb_version,
       stll_commit_internal_stats.sb_sweep_optimized_commit,
       stll_commit_internal_stats.metadata_delta_validated,
       stll_commit_internal_stats.pendingwritesissued,
       stll_commit_internal_stats.sb_tree_blocks,
       stll_commit_internal_stats.log_blocks_written,
       stll_commit_internal_stats.encrypted_log_blocks_written,
       stll_commit_internal_stats.new_sb_tree_blocks,
       stll_commit_internal_stats.tossed_sb_tree_blocks
FROM stll_commit_internal_stats

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