Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_superblock_trickle_validation_stats	log_blocks_prefetched	int8
pg_catalog	stl_superblock_trickle_validation_stats	log_blocks_prefetched_pending_io	int8
pg_catalog	stl_superblock_trickle_validation_stats	log_blocks_read_sync	int8
pg_catalog	stl_superblock_trickle_validation_stats	log_blocks_validated	int8
pg_catalog	stl_superblock_trickle_validation_stats	log_entries_validated	int8
pg_catalog	stl_superblock_trickle_validation_stats	log_rotation	int4
pg_catalog	stl_superblock_trickle_validation_stats	node	int4
pg_catalog	stl_superblock_trickle_validation_stats	record_time	timestamp
pg_catalog	stl_superblock_trickle_validation_stats	snapshot_sb_num_blocks	int8
pg_catalog	stl_superblock_trickle_validation_stats	snapshot_sb_version	int8
pg_catalog	stl_superblock_trickle_validation_stats	start_time	timestamp
pg_catalog	stl_superblock_trickle_validation_stats	tree_based_sb_mode	int4
pg_catalog	stl_superblock_trickle_validation_stats	tree_entries_validated	int8
pg_catalog	stl_superblock_trickle_validation_stats	tree_trickle_validation_done	int4
pg_catalog	stl_superblock_trickle_validation_stats	trickle_validation_done	int4
pg_catalog	stl_superblock_trickle_validation_stats	was_tree_validated	int4
pg_catalog	stl_superblock_trickle_validation_stats	xid	int8

View Text

SELECT stll_superblock_trickle_validation_stats.node,
       stll_superblock_trickle_validation_stats.record_time,
       stll_superblock_trickle_validation_stats.snapshot_sb_version,
       stll_superblock_trickle_validation_stats.snapshot_sb_num_blocks,
       stll_superblock_trickle_validation_stats.log_entries_validated,
       stll_superblock_trickle_validation_stats.log_blocks_validated,
       stll_superblock_trickle_validation_stats.tree_based_sb_mode,
       stll_superblock_trickle_validation_stats.tree_entries_validated,
       stll_superblock_trickle_validation_stats.trickle_validation_done,
       stll_superblock_trickle_validation_stats.log_rotation,
       stll_superblock_trickle_validation_stats.was_tree_validated,
       stll_superblock_trickle_validation_stats.tree_trickle_validation_done,
       stll_superblock_trickle_validation_stats.xid,
       stll_superblock_trickle_validation_stats.start_time,
       stll_superblock_trickle_validation_stats.log_blocks_prefetched,
       stll_superblock_trickle_validation_stats.log_blocks_prefetched_pending_io,
       stll_superblock_trickle_validation_stats.log_blocks_read_sync
FROM stll_superblock_trickle_validation_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