Redshift Observatory

System Table Tracker

System table pg_catalog.stcs_aggr version 1.0.61395 / 2023-12-30

schema name column data type PK U NN
pg_catalog stcs_aggr bytes int8 NN
pg_catalog stcs_aggr __cluster_type char(4) NN
pg_catalog stcs_aggr dist_by_distinct int4 NN
pg_catalog stcs_aggr endtime int8 NN
pg_catalog stcs_aggr flushable int4 NN
pg_catalog stcs_aggr is_diskbased char(1) NN
pg_catalog stcs_aggr __log_generated_date char(8) NN
pg_catalog stcs_aggr maxlength int4 NN
pg_catalog stcs_aggr memory_usage_ratio int4 NN
pg_catalog stcs_aggr num_flushes int4 NN
pg_catalog stcs_aggr occupied int4 NN
pg_catalog stcs_aggr __path varchar(2050) NN
pg_catalog stcs_aggr query int4 NN
pg_catalog stcs_aggr resizes int4 NN
pg_catalog stcs_aggr rows int8 NN
pg_catalog stcs_aggr segment int4 NN
pg_catalog stcs_aggr __size int8 NN
pg_catalog stcs_aggr slice int4 NN
pg_catalog stcs_aggr slots int4 NN
pg_catalog stcs_aggr __spectrum_oid varchar(128) NN
pg_catalog stcs_aggr starttime int8 NN
pg_catalog stcs_aggr step int4 NN
pg_catalog stcs_aggr tasknum int4 NN
pg_catalog stcs_aggr tbl int4 NN
pg_catalog stcs_aggr type char(6) NN
pg_catalog stcs_aggr used_agg_prefetching char(1) NN
pg_catalog stcs_aggr used_mega_block char(1) NN
pg_catalog stcs_aggr userid int4 NN
pg_catalog stcs_aggr varagg_opt_bitmap int8 NN
pg_catalog stcs_aggr varchar_agg_opt char(1) NN
pg_catalog stcs_aggr workmem int8 NN


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