Redshift Observatory

System Table Tracker

System view pg_catalog.stl_internal_query_details version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	stl_internal_query_details	cs_node_nums	int4
pg_catalog	stl_internal_query_details	datasharing_tables_accessed	int4
pg_catalog	stl_internal_query_details	dirty_tables_read	int4
pg_catalog	stl_internal_query_details	exec_time_wo_compilation	int8
pg_catalog	stl_internal_query_details	initial_query_time	timestamp
pg_catalog	stl_internal_query_details	is_burst_for_at_task	int4
pg_catalog	stl_internal_query_details	is_multi	int4
pg_catalog	stl_internal_query_details	is_short_query	int4
pg_catalog	stl_internal_query_details	lf_datasharing_tables_accessed	int4
pg_catalog	stl_internal_query_details	memory_demanding_info	int8
pg_catalog	stl_internal_query_details	new_model_reason	int4
pg_catalog	stl_internal_query_details	nobackup_tables_accessed	int4
pg_catalog	stl_internal_query_details	num_rowsets	int4
pg_catalog	stl_internal_query_details	pg_tables_accessed	int4
pg_catalog	stl_internal_query_details	qpc_source_qid	int8
pg_catalog	stl_internal_query_details	query	int4
pg_catalog	stl_internal_query_details	query_cmd_type	int4
pg_catalog	stl_internal_query_details	query_target_table_type	int4
pg_catalog	stl_internal_query_details	reported_peak_usage_bytes	int8
pg_catalog	stl_internal_query_details	result_cache_miss_reason	int4
pg_catalog	stl_internal_query_details	seldispatch_status	int4
pg_catalog	stl_internal_query_details	spectrum_tables_accessed	int4
pg_catalog	stl_internal_query_details	system_tables_accessed	int4
pg_catalog	stl_internal_query_details	user_perm_tables_accessed	int4
pg_catalog	stl_internal_query_details	user_query_id	int8
pg_catalog	stl_internal_query_details	user_temp_tables_accessed	int4
pg_catalog	stl_internal_query_details	uses_new_cost_model	char(1)
pg_catalog	stl_internal_query_details	volt_temp_tables_accessed	int4
pg_catalog	stl_internal_query_details	wlm_query_memory	int8
pg_catalog	stl_internal_query_details	wlm_slot_type	char(8)
pg_catalog	stl_internal_query_details	xid	int8
pg_catalog	stl_internal_query_details	xregion_datasharing_tables_accessed	int4
pg_catalog	stl_internal_query_details	zindex_tables_accessed	int4

View Text

SELECT stll_internal_query_details.query,
       stll_internal_query_details.xid,
       stll_internal_query_details.initial_query_time,
       stll_internal_query_details.seldispatch_status,
       stll_internal_query_details.query_cmd_type,
       stll_internal_query_details.user_temp_tables_accessed,
       stll_internal_query_details.volt_temp_tables_accessed,
       stll_internal_query_details.spectrum_tables_accessed,
       stll_internal_query_details.user_perm_tables_accessed,
       stll_internal_query_details.system_tables_accessed,
       stll_internal_query_details.query_target_table_type,
       stll_internal_query_details.memory_demanding_info,
       stll_internal_query_details.nobackup_tables_accessed,
       stll_internal_query_details.zindex_tables_accessed,
       stll_internal_query_details.pg_tables_accessed,
       stll_internal_query_details.dirty_tables_read,
       stll_internal_query_details.wlm_slot_type,
       stll_internal_query_details.is_short_query,
       stll_internal_query_details.reported_peak_usage_bytes,
       stll_internal_query_details.wlm_query_memory,
       stll_internal_query_details.datasharing_tables_accessed,
       stll_internal_query_details.uses_new_cost_model,
       stll_internal_query_details.new_model_reason,
       stll_internal_query_details.num_rowsets,
       stll_internal_query_details.xregion_datasharing_tables_accessed,
       stll_internal_query_details.result_cache_miss_reason,
       stll_internal_query_details.cs_node_nums,
       stll_internal_query_details.is_multi,
       stll_internal_query_details.is_burst_for_at_task,
       stll_internal_query_details.user_query_id,
       stll_internal_query_details.lf_datasharing_tables_accessed,
       stll_internal_query_details.qpc_source_qid,
       stll_internal_query_details.exec_time_wo_compilation
FROM stll_internal_query_details

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