Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog stl_superblock_vacuum allocatedafter int8
pg_catalog stl_superblock_vacuum allocatedbefore int8
pg_catalog stl_superblock_vacuum commitendtime timestamp
pg_catalog stl_superblock_vacuum commitstarttime timestamp
pg_catalog stl_superblock_vacuum freeafter int8
pg_catalog stl_superblock_vacuum freebefore int8
pg_catalog stl_superblock_vacuum freelistafter int8
pg_catalog stl_superblock_vacuum freelistbefore int8
pg_catalog stl_superblock_vacuum leadersnapshotafter int8
pg_catalog stl_superblock_vacuum leadersnapshotbefore int8
pg_catalog stl_superblock_vacuum leaderstarttime timestamp
pg_catalog stl_superblock_vacuum logafter int8
pg_catalog stl_superblock_vacuum logbefore int8
pg_catalog stl_superblock_vacuum metadataafter int8
pg_catalog stl_superblock_vacuum metadatabefore int8
pg_catalog stl_superblock_vacuum node int4
pg_catalog stl_superblock_vacuum nodeendtime timestamp
pg_catalog stl_superblock_vacuum nodestarttime timestamp
pg_catalog stl_superblock_vacuum permafter int8
pg_catalog stl_superblock_vacuum permbefore int8
pg_catalog stl_superblock_vacuum pgwalafter int8
pg_catalog stl_superblock_vacuum pgwalbefore int8
pg_catalog stl_superblock_vacuum sbtreeafter int8
pg_catalog stl_superblock_vacuum sbtreebefore int8
pg_catalog stl_superblock_vacuum success int4
pg_catalog stl_superblock_vacuum tempafter int8
pg_catalog stl_superblock_vacuum tempbefore int8
pg_catalog stl_superblock_vacuum tombstonedsbtreeafter int8
pg_catalog stl_superblock_vacuum tombstonedsbtreebefore int8

View Text

SELECT stll_superblock_vacuum.leaderstarttime,
       stll_superblock_vacuum.node,
       stll_superblock_vacuum.nodestarttime,
       stll_superblock_vacuum.nodeendtime,
       stll_superblock_vacuum.commitstarttime,
       stll_superblock_vacuum.commitendtime,
       stll_superblock_vacuum.success,
       stll_superblock_vacuum.permbefore,
       stll_superblock_vacuum.tempbefore,
       stll_superblock_vacuum.leadersnapshotbefore,
       stll_superblock_vacuum.pgwalbefore,
       stll_superblock_vacuum.metadatabefore,
       stll_superblock_vacuum.freebefore,
       stll_superblock_vacuum.allocatedbefore,
       stll_superblock_vacuum.permafter,
       stll_superblock_vacuum.tempafter,
       stll_superblock_vacuum.leadersnapshotafter,
       stll_superblock_vacuum.pgwalafter,
       stll_superblock_vacuum.metadataafter,
       stll_superblock_vacuum.freeafter,
       stll_superblock_vacuum.allocatedafter,
       stll_superblock_vacuum.freelistbefore,
       stll_superblock_vacuum.freelistafter,
       stll_superblock_vacuum.logbefore,
       stll_superblock_vacuum.logafter,
       stll_superblock_vacuum.sbtreebefore,
       stll_superblock_vacuum.sbtreeafter,
       stll_superblock_vacuum.tombstonedsbtreebefore,
       stll_superblock_vacuum.tombstonedsbtreeafter
FROM stll_superblock_vacuum


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