Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_prediction version 1.0.39278 / 2022-07-23

schema	name	column	data type
pg_catalog	stl_query_prediction	burst_exec_time	float8
pg_catalog	stl_query_prediction	burst_exec_time_error	float8
pg_catalog	stl_query_prediction	execution_time	float8
pg_catalog	stl_query_prediction	execution_time_error	float8
pg_catalog	stl_query_prediction	execution_time_without_compile	float8
pg_catalog	stl_query_prediction	execution_time_without_compile_error	float8
pg_catalog	stl_query_prediction	memory	float8
pg_catalog	stl_query_prediction	memory_error	float8
pg_catalog	stl_query_prediction	query	int4
pg_catalog	stl_query_prediction	xid	int8

View Text

SELECT stll_query_prediction.query,
       stll_query_prediction.xid,
       stll_query_prediction.execution_time,
       stll_query_prediction.execution_time_error,
       stll_query_prediction.memory,
       stll_query_prediction.memory_error,
       stll_query_prediction.execution_time_without_compile,
       stll_query_prediction.execution_time_without_compile_error,
       stll_query_prediction.burst_exec_time,
       stll_query_prediction.burst_exec_time_error
FROM stll_query_prediction

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