Redshift Observatory

System Table Tracker

System view pg_catalog.stl_mv_aqmv version 1.0.70695 / 2024-07-11

schema name column data type
pg_catalog stl_mv_aqmv algebra_translation_time int4
pg_catalog stl_mv_aqmv amvs_count int4
pg_catalog stl_mv_aqmv aqmv_cost float8
pg_catalog stl_mv_aqmv aqmv_exec_time_est int4
pg_catalog stl_mv_aqmv aqmv_exec_time_est_error int4
pg_catalog stl_mv_aqmv aqmv_status int4
pg_catalog stl_mv_aqmv candidates int4
pg_catalog stl_mv_aqmv candidates_fetching_time int4
pg_catalog stl_mv_aqmv costing_time int4
pg_catalog stl_mv_aqmv endtime timestamp
pg_catalog stl_mv_aqmv matches int4
pg_catalog stl_mv_aqmv mvs_used char(400)
pg_catalog stl_mv_aqmv original_cost float8
pg_catalog stl_mv_aqmv original_exec_time_est int4
pg_catalog stl_mv_aqmv original_exec_time_est_error int4
pg_catalog stl_mv_aqmv query int8
pg_catalog stl_mv_aqmv starttime timestamp
pg_catalog stl_mv_aqmv total_cpu_time int4

View Text

SELECT stll_mv_aqmv.query,
       stll_mv_aqmv.starttime,
       stll_mv_aqmv.endtime,
       stll_mv_aqmv.candidates,
       stll_mv_aqmv.matches,
       stll_mv_aqmv.aqmv_cost,
       stll_mv_aqmv.original_cost,
       stll_mv_aqmv.costing_time,
       stll_mv_aqmv.aqmv_status,
       stll_mv_aqmv.original_exec_time_est,
       stll_mv_aqmv.original_exec_time_est_error,
       stll_mv_aqmv.aqmv_exec_time_est,
       stll_mv_aqmv.aqmv_exec_time_est_error,
       stll_mv_aqmv.candidates_fetching_time,
       stll_mv_aqmv.algebra_translation_time,
       stll_mv_aqmv.total_cpu_time,
       stll_mv_aqmv.amvs_count,
       stll_mv_aqmv.mvs_used
FROM stll_mv_aqmv


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