Redshift Observatory

System Table Tracker

System view pg_catalog.stl_internal_query_details version 1.0.39251 / 2022-06-17

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	est_peak_mem_needed	int8
pg_catalog	stl_internal_query_details	initial_query_time	timestamp
pg_catalog	stl_internal_query_details	is_short_query	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	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	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_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.est_peak_mem_needed,
       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
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