Redshift Observatory

System Table Tracker

System view pg_catalog.stl_superblock_trickle_validation_summary version 1.0.46607 / 2023-02-12

schema	name	column	data type
pg_catalog	stl_superblock_trickle_validation_summary	log_blocks_validated	int8
pg_catalog	stl_superblock_trickle_validation_summary	log_entries_validated	int8
pg_catalog	stl_superblock_trickle_validation_summary	log_rotation_done	int4
pg_catalog	stl_superblock_trickle_validation_summary	node	int4
pg_catalog	stl_superblock_trickle_validation_summary	num_steps_log_rotation	int4
pg_catalog	stl_superblock_trickle_validation_summary	num_steps_trickle_validation	int4
pg_catalog	stl_superblock_trickle_validation_summary	record_time	timestamp
pg_catalog	stl_superblock_trickle_validation_summary	snapshot_sb_num_blocks	int8
pg_catalog	stl_superblock_trickle_validation_summary	snapshot_sb_version	int8
pg_catalog	stl_superblock_trickle_validation_summary	tree_based_sb_mode	int4
pg_catalog	stl_superblock_trickle_validation_summary	tree_entries_validated	int8
pg_catalog	stl_superblock_trickle_validation_summary	tree_trickle_validation_done	int4
pg_catalog	stl_superblock_trickle_validation_summary	trickle_validation_done	int4

View Text

SELECT stll_superblock_trickle_validation_summary.node,
       stll_superblock_trickle_validation_summary.record_time,
       stll_superblock_trickle_validation_summary.snapshot_sb_version,
       stll_superblock_trickle_validation_summary.snapshot_sb_num_blocks,
       stll_superblock_trickle_validation_summary.log_blocks_validated,
       stll_superblock_trickle_validation_summary.log_entries_validated,
       stll_superblock_trickle_validation_summary.tree_based_sb_mode,
       stll_superblock_trickle_validation_summary.tree_entries_validated,
       stll_superblock_trickle_validation_summary.tree_trickle_validation_done,
       stll_superblock_trickle_validation_summary.trickle_validation_done,
       stll_superblock_trickle_validation_summary.num_steps_trickle_validation,
       stll_superblock_trickle_validation_summary.log_rotation_done,
       stll_superblock_trickle_validation_summary.num_steps_log_rotation
FROM stll_superblock_trickle_validation_summary

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