Redshift Observatory

System Table Tracker

System view pg_catalog.stl_internal_query_details version 1.0.77272 / 2024-11-01

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,
       stll_internal_query_details.exec_cluster_size,
       stll_internal_query_details.auto_mounted_tables_accessed,
       stll_internal_query_details.spectrum_file_count,
       stll_internal_query_details.datasharing_spectrum_tables_accessed,
       stll_internal_query_details.lf_datasharing_spectrum_tables_accessed,
       stll_internal_query_details.num_pce_segs
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