Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog svv_restore_table_state allow_snapshot_delete int4
pg_catalog svv_restore_table_state blocks_restored int8
pg_catalog svv_restore_table_state request_id text
pg_catalog svv_restore_table_state status text
pg_catalog svv_restore_table_state total_blocks int8

View Text

SELECT btrim(CAST(p.key AS text)) AS request_id,
       COALESCE(sum(s.total_blocks),
                CAST(0 AS bigint)) AS total_blocks,
       COALESCE(sum(s.blocks_restored),
                CAST(0 AS bigint)) AS blocks_restored,
       CASE
         WHEN max(s.in_progress) = 1
           THEN CAST('IN_PROGRESS' AS text)
         WHEN max(s.in_progress) = 0
           THEN CAST('SUCCESS' AS text)
         WHEN max(s.in_progress) = -1
           THEN CAST('DROPPED' AS text)
         WHEN max(s.in_progress) IS NULL
           THEN CAST('DROPPED' AS text)
         ELSE CAST('INVALID_STATUS' AS text)
       END AS status,
       CASE
         WHEN min(s.allow_snapshot_delete) IS NULL
           THEN 1
         ELSE min(s.allow_snapshot_delete)
       END AS allow_snapshot_delete
FROM pg_conf AS p
     LEFT JOIN stv_restore_table_state AS s ON p.value = CAST(s.table_id AS text)
WHERE p.key ~~ CAST('TLR_%' AS text)
GROUP BY p.key, p.value
ORDER BY p.key,
         p.value


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