Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3commit_stats version 1.0.59596 / 2023-11-12

schema	name	column	data type
pg_catalog	stl_s3commit_stats	dynamo_get_avg_latency_usec	int8
pg_catalog	stl_s3commit_stats	dynamo_write_avg_latency_usec	int8
pg_catalog	stl_s3commit_stats	end_time	timestamp
pg_catalog	stl_s3commit_stats	node	int4
pg_catalog	stl_s3commit_stats	num_add_tags_issued_to_s3	int8
pg_catalog	stl_s3commit_stats	num_delete_tags_issued_to_s3	int8
pg_catalog	stl_s3commit_stats	num_non_persistent_tagless_blocks	int8
pg_catalog	stl_s3commit_stats	num_tombstoned_guids	int8
pg_catalog	stl_s3commit_stats	num_tossed_guids	int8
pg_catalog	stl_s3commit_stats	num_tossed_in_writes1	int8
pg_catalog	stl_s3commit_stats	num_tossed_tagless_s3_writes	int8
pg_catalog	stl_s3commit_stats	num_untagged_s3_writes	int8
pg_catalog	stl_s3commit_stats	num_untagged_untracked	int8
pg_catalog	stl_s3commit_stats	s3commit_disable_latency	int8
pg_catalog	stl_s3commit_stats	s3commit_enable_latency	int8
pg_catalog	stl_s3commit_stats	s3_write_add_tag_latency	int8
pg_catalog	stl_s3commit_stats	s3_write_delete_tag_latency	int8
pg_catalog	stl_s3commit_stats	s3_write_untagged_latency	int8
pg_catalog	stl_s3commit_stats	start_time	timestamp
pg_catalog	stl_s3commit_stats	synced_commits_to_s3	int4
pg_catalog	stl_s3commit_stats	xid	int8

View Text

SELECT stll_s3commit_stats.xid,
       stll_s3commit_stats.node,
       stll_s3commit_stats.start_time,
       stll_s3commit_stats.end_time,
       stll_s3commit_stats.s3_write_untagged_latency,
       stll_s3commit_stats.s3_write_add_tag_latency,
       stll_s3commit_stats.s3_write_delete_tag_latency,
       stll_s3commit_stats.num_untagged_s3_writes,
       stll_s3commit_stats.num_add_tags_issued_to_s3,
       stll_s3commit_stats.num_delete_tags_issued_to_s3,
       stll_s3commit_stats.dynamo_write_avg_latency_usec,
       stll_s3commit_stats.synced_commits_to_s3,
       stll_s3commit_stats.s3commit_enable_latency,
       stll_s3commit_stats.s3commit_disable_latency,
       stll_s3commit_stats.dynamo_get_avg_latency_usec,
       stll_s3commit_stats.num_tossed_guids,
       stll_s3commit_stats.num_tombstoned_guids,
       stll_s3commit_stats.num_untagged_untracked,
       stll_s3commit_stats.num_tossed_tagless_s3_writes,
       stll_s3commit_stats.num_tossed_in_writes1,
       stll_s3commit_stats.num_non_persistent_tagless_blocks
FROM stll_s3commit_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