Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_history_base version 1.0.40496 / 2022-08-08

schema	name	column	data type
pg_catalog	stl_query_history_base	child_query_id	int4
pg_catalog	stl_query_history_base	child_query_sequence	int4
pg_catalog	stl_query_history_base	concurrency_scaling_status	int4
pg_catalog	stl_query_history_base	db	char(64)
pg_catalog	stl_query_history_base	error_message	char(512)
pg_catalog	stl_query_history_base	eventtime	timestamp
pg_catalog	stl_query_history_base	label	char(320)
pg_catalog	stl_query_history_base	location_tag	char(32)
pg_catalog	stl_query_history_base	pid	int4
pg_catalog	stl_query_history_base	query_id	int8
pg_catalog	stl_query_history_base	query_text	char(4000)
pg_catalog	stl_query_history_base	query_type	char(32)
pg_catalog	stl_query_history_base	redshift_version	char(256)
pg_catalog	stl_query_history_base	result_cache_source_query	int8
pg_catalog	stl_query_history_base	returned_bytes	int8
pg_catalog	stl_query_history_base	returned_rows	int8
pg_catalog	stl_query_history_base	service_class	int4
pg_catalog	stl_query_history_base	status	char(10)
pg_catalog	stl_query_history_base	task	int4
pg_catalog	stl_query_history_base	total_exec_time	int8
pg_catalog	stl_query_history_base	total_queue_time	int8
pg_catalog	stl_query_history_base	usage_limit	char(150)
pg_catalog	stl_query_history_base	user_id	int4
pg_catalog	stl_query_history_base	xid	int8

View Text

SELECT stll_query_history_base.user_id,
       stll_query_history_base.query_id,
       stll_query_history_base.child_query_id,
       stll_query_history_base.child_query_sequence,
       stll_query_history_base.label,
       stll_query_history_base.xid,
       stll_query_history_base.pid,
       stll_query_history_base.db,
       stll_query_history_base.query_type,
       stll_query_history_base.query_text,
       stll_query_history_base.eventtime,
       stll_query_history_base.status,
       stll_query_history_base.result_cache_source_query,
       stll_query_history_base.concurrency_scaling_status,
       stll_query_history_base.error_message,
       stll_query_history_base.task,
       stll_query_history_base.service_class,
       stll_query_history_base.returned_rows,
       stll_query_history_base.returned_bytes,
       stll_query_history_base.total_queue_time,
       stll_query_history_base.total_exec_time,
       stll_query_history_base.redshift_version,
       stll_query_history_base.location_tag,
       stll_query_history_base.usage_limit
FROM stll_query_history_base

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