Redshift Observatory

System Table Tracker

System view pg_catalog.stl_user_query_history_redacted version 1.0.76142 / 2024-10-08

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

View Text

SELECT stll_user_query_history_redacted.user_id,
       stll_user_query_history_redacted.query_id,
       stll_user_query_history_redacted.label,
       stll_user_query_history_redacted.xid,
       stll_user_query_history_redacted.pid,
       stll_user_query_history_redacted.database_name,
       stll_user_query_history_redacted.query_type,
       stll_user_query_history_redacted.status,
       stll_user_query_history_redacted.result_cache_source_query,
       stll_user_query_history_redacted.start_time,
       stll_user_query_history_redacted.end_time,
       stll_user_query_history_redacted.queue_time,
       stll_user_query_history_redacted.execution_time,
       stll_user_query_history_redacted.error_message,
       stll_user_query_history_redacted.returned_rows,
       stll_user_query_history_redacted.returned_bytes,
       stll_user_query_history_redacted.redshift_version,
       stll_user_query_history_redacted.usage_limit,
       stll_user_query_history_redacted.internal_query,
       stll_user_query_history_redacted.query_text_redacted,
       stll_user_query_history_redacted.compute_type,
       stll_user_query_history_redacted.compile_time,
       stll_user_query_history_redacted.planning_time,
       stll_user_query_history_redacted.pure_planning_time,
       stll_user_query_history_redacted.lock_wait_time,
       stll_user_query_history_redacted.service_class_id,
       stll_user_query_history_redacted.service_class_name,
       stll_user_query_history_redacted.query_priority,
       stll_user_query_history_redacted.short_query_accelerated,
       stll_user_query_history_redacted.user_query_hash,
       stll_user_query_history_redacted.generic_query_hash,
       stll_user_query_history_redacted.query_hash_version
FROM stll_user_query_history_redacted
WHERE stll_user_query_history_redacted.access_control = 0
   OR stll_user_query_history_redacted.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