Redshift Observatory

System Table Tracker

System view pg_catalog.stl_cdc_checkpoints version 1.0.71912 / 2024-08-02

schema name column data type
pg_catalog stl_cdc_checkpoints bytes_downloaded int8
pg_catalog stl_cdc_checkpoints channel_state char(128)
pg_catalog stl_cdc_checkpoints checkpoint char(128)
pg_catalog stl_cdc_checkpoints connection_id char(128)
pg_catalog stl_cdc_checkpoints db_name char(128)
pg_catalog stl_cdc_checkpoints export_identifier char(64)
pg_catalog stl_cdc_checkpoints num_tables_modified int4
pg_catalog stl_cdc_checkpoints recordtime timestamp
pg_catalog stl_cdc_checkpoints rows int8
pg_catalog stl_cdc_checkpoints s3_path char(512)
pg_catalog stl_cdc_checkpoints status char(16)
pg_catalog stl_cdc_checkpoints type char(16)

View Text

SELECT stll_cdc_checkpoints.recordtime,
       stll_cdc_checkpoints.connection_id,
       stll_cdc_checkpoints.db_name,
       stll_cdc_checkpoints.s3_path,
       stll_cdc_checkpoints.checkpoint,
       stll_cdc_checkpoints.type,
       stll_cdc_checkpoints.num_tables_modified,
       stll_cdc_checkpoints.status,
       stll_cdc_checkpoints.bytes_downloaded,
       stll_cdc_checkpoints.channel_state,
       stll_cdc_checkpoints.export_identifier,
       stll_cdc_checkpoints.rows
FROM stll_cdc_checkpoints


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