Redshift Observatory

System Table Tracker

System view pg_catalog.stl_mv_aqmv version 1.0.59596 / 2023-11-12

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