Redshift Observatory

System Table Tracker

System table pg_catalog.stcs_mv_aqmv version 1.0.41194 / 2022-09-03

schema name column data type PK U NN
pg_catalog stcs_mv_aqmv algebra_translation_time int4 NN
pg_catalog stcs_mv_aqmv amvs_count int4 NN
pg_catalog stcs_mv_aqmv aqmv_cost float8 NN
pg_catalog stcs_mv_aqmv aqmv_exec_time_est int4 NN
pg_catalog stcs_mv_aqmv aqmv_exec_time_est_error int4 NN
pg_catalog stcs_mv_aqmv aqmv_status int4 NN
pg_catalog stcs_mv_aqmv candidates int4 NN
pg_catalog stcs_mv_aqmv candidates_fetching_time int4 NN
pg_catalog stcs_mv_aqmv __cluster_type char(4) NN
pg_catalog stcs_mv_aqmv costing_time int4 NN
pg_catalog stcs_mv_aqmv endtime int8 NN
pg_catalog stcs_mv_aqmv __log_generated_date char(8) NN
pg_catalog stcs_mv_aqmv matches int4 NN
pg_catalog stcs_mv_aqmv mvs_used char(400) NN
pg_catalog stcs_mv_aqmv original_cost float8 NN
pg_catalog stcs_mv_aqmv original_exec_time_est int4 NN
pg_catalog stcs_mv_aqmv original_exec_time_est_error int4 NN
pg_catalog stcs_mv_aqmv __path varchar(2050) NN
pg_catalog stcs_mv_aqmv query int8 NN
pg_catalog stcs_mv_aqmv __size int8 NN
pg_catalog stcs_mv_aqmv __spectrum_oid varchar(128) NN
pg_catalog stcs_mv_aqmv starttime int8 NN
pg_catalog stcs_mv_aqmv total_cpu_time int4 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