Redshift Observatory

System Table Tracker

System view pg_catalog.stl_create_table_ddl_summary version 1.0.67699 / 2024-05-26

schema name column data type
pg_catalog stl_create_table_ddl_summary db_name char(128)
pg_catalog stl_create_table_ddl_summary distkey_defined char(1)
pg_catalog stl_create_table_ddl_summary diststyle_defined char(1)
pg_catalog stl_create_table_ddl_summary num_cols_with_encode int4
pg_catalog stl_create_table_ddl_summary num_cols_without_encode int4
pg_catalog stl_create_table_ddl_summary querytime timestamp
pg_catalog stl_create_table_ddl_summary schema_name char(128)
pg_catalog stl_create_table_ddl_summary sortkey_defined char(1)
pg_catalog stl_create_table_ddl_summary table_name char(128)
pg_catalog stl_create_table_ddl_summary userid int4

View Text

SELECT stll_create_table_ddl_summary.querytime,
       stll_create_table_ddl_summary.userid,
       stll_create_table_ddl_summary.db_name,
       stll_create_table_ddl_summary.schema_name,
       stll_create_table_ddl_summary.table_name,
       stll_create_table_ddl_summary.num_cols_with_encode,
       stll_create_table_ddl_summary.num_cols_without_encode,
       stll_create_table_ddl_summary.sortkey_defined,
       stll_create_table_ddl_summary.distkey_defined,
       stll_create_table_ddl_summary.diststyle_defined
FROM stll_create_table_ddl_summary


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