Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3commit_stats version 1.0.58558 / 2023-10-25

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