Redshift Observatory

System Table Tracker

System view pg_catalog.stl_user_query_history version 1.0.76913 / 2024-10-24

schema	name	column	data type
pg_catalog	stl_user_query_history	compile_time	int8
pg_catalog	stl_user_query_history	compute_type	char(32)
pg_catalog	stl_user_query_history	database_name	char(128)
pg_catalog	stl_user_query_history	end_time	timestamp
pg_catalog	stl_user_query_history	error_message	char(512)
pg_catalog	stl_user_query_history	execution_time	int8
pg_catalog	stl_user_query_history	generic_query_hash	char(40)
pg_catalog	stl_user_query_history	internal_query	char(1)
pg_catalog	stl_user_query_history	label	char(320)
pg_catalog	stl_user_query_history	lock_wait_time	int8
pg_catalog	stl_user_query_history	pid	int4
pg_catalog	stl_user_query_history	planning_time	int8
pg_catalog	stl_user_query_history	pure_planning_time	int8
pg_catalog	stl_user_query_history	query_hash_version	int4
pg_catalog	stl_user_query_history	query_id	int8
pg_catalog	stl_user_query_history	query_priority	char(20)
pg_catalog	stl_user_query_history	query_text	char(4000)
pg_catalog	stl_user_query_history	query_type	char(32)
pg_catalog	stl_user_query_history	queue_time	int8
pg_catalog	stl_user_query_history	redshift_version	char(32)
pg_catalog	stl_user_query_history	result_cache_source_query	int8
pg_catalog	stl_user_query_history	returned_bytes	int8
pg_catalog	stl_user_query_history	returned_rows	int8
pg_catalog	stl_user_query_history	service_class_id	int4
pg_catalog	stl_user_query_history	service_class_name	char(64)
pg_catalog	stl_user_query_history	short_query_accelerated	char(10)
pg_catalog	stl_user_query_history	start_time	timestamp
pg_catalog	stl_user_query_history	status	char(10)
pg_catalog	stl_user_query_history	usage_limit	char(150)
pg_catalog	stl_user_query_history	user_id	int4
pg_catalog	stl_user_query_history	user_query_hash	char(40)
pg_catalog	stl_user_query_history	xid	int8

View Text

SELECT stll_user_query_history.user_id,
       stll_user_query_history.query_id,
       stll_user_query_history.label,
       stll_user_query_history.xid,
       stll_user_query_history.pid,
       stll_user_query_history.database_name,
       stll_user_query_history.query_type,
       stll_user_query_history.status,
       stll_user_query_history.result_cache_source_query,
       stll_user_query_history.start_time,
       stll_user_query_history.end_time,
       stll_user_query_history.queue_time,
       stll_user_query_history.execution_time,
       stll_user_query_history.error_message,
       stll_user_query_history.returned_rows,
       stll_user_query_history.returned_bytes,
       stll_user_query_history.redshift_version,
       stll_user_query_history.usage_limit,
       stll_user_query_history.internal_query,
       stll_user_query_history.query_text,
       stll_user_query_history.compute_type,
       stll_user_query_history.compile_time,
       stll_user_query_history.planning_time,
       stll_user_query_history.pure_planning_time,
       stll_user_query_history.lock_wait_time,
       stll_user_query_history.service_class_id,
       stll_user_query_history.service_class_name,
       stll_user_query_history.query_priority,
       stll_user_query_history.short_query_accelerated,
       stll_user_query_history.user_query_hash,
       stll_user_query_history.generic_query_hash,
       stll_user_query_history.query_hash_version
FROM stll_user_query_history
WHERE stll_user_query_history.access_control = 0
   OR stll_user_query_history.access_control IS NULL
   OR NOT is_seclog_downgrade_enabled()

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