Redshift Observatory

System Table Tracker

System table pg_catalog.stcs_internal_query_details version 1.0.76913 / 2024-10-24

schema name column data type PK U NN
pg_catalog stcs_internal_query_details auto_mounted_tables_accessed int4 NN
pg_catalog stcs_internal_query_details __cluster_type char(4) NN
pg_catalog stcs_internal_query_details cs_node_nums int4 NN
pg_catalog stcs_internal_query_details datasharing_spectrum_tables_accessed int4 NN
pg_catalog stcs_internal_query_details datasharing_tables_accessed int4 NN
pg_catalog stcs_internal_query_details dirty_tables_read int4 NN
pg_catalog stcs_internal_query_details exec_cluster_size int4 NN
pg_catalog stcs_internal_query_details exec_time_wo_compilation int8 NN
pg_catalog stcs_internal_query_details initial_query_time int8 NN
pg_catalog stcs_internal_query_details is_burst_for_at_task int4 NN
pg_catalog stcs_internal_query_details is_multi int4 NN
pg_catalog stcs_internal_query_details is_short_query int4 NN
pg_catalog stcs_internal_query_details lf_datasharing_spectrum_tables_accessed int4 NN
pg_catalog stcs_internal_query_details lf_datasharing_tables_accessed int4 NN
pg_catalog stcs_internal_query_details __log_generated_date char(8) NN
pg_catalog stcs_internal_query_details memory_demanding_info int8 NN
pg_catalog stcs_internal_query_details new_model_reason int4 NN
pg_catalog stcs_internal_query_details nobackup_tables_accessed int4 NN
pg_catalog stcs_internal_query_details num_pce_segs int4 NN
pg_catalog stcs_internal_query_details num_rowsets int4 NN
pg_catalog stcs_internal_query_details __path varchar(2050) NN
pg_catalog stcs_internal_query_details pg_tables_accessed int4 NN
pg_catalog stcs_internal_query_details qpc_source_qid int8 NN
pg_catalog stcs_internal_query_details query int4 NN
pg_catalog stcs_internal_query_details query_cmd_type int4 NN
pg_catalog stcs_internal_query_details query_target_table_type int4 NN
pg_catalog stcs_internal_query_details reported_peak_usage_bytes int8 NN
pg_catalog stcs_internal_query_details result_cache_miss_reason int4 NN
pg_catalog stcs_internal_query_details seldispatch_status int4 NN
pg_catalog stcs_internal_query_details __size int8 NN
pg_catalog stcs_internal_query_details spectrum_file_count int4 NN
pg_catalog stcs_internal_query_details __spectrum_oid varchar(128) NN
pg_catalog stcs_internal_query_details spectrum_tables_accessed int4 NN
pg_catalog stcs_internal_query_details system_tables_accessed int4 NN
pg_catalog stcs_internal_query_details user_perm_tables_accessed int4 NN
pg_catalog stcs_internal_query_details user_query_id int8 NN
pg_catalog stcs_internal_query_details user_temp_tables_accessed int4 NN
pg_catalog stcs_internal_query_details uses_new_cost_model char(1) NN
pg_catalog stcs_internal_query_details volt_temp_tables_accessed int4 NN
pg_catalog stcs_internal_query_details wlm_query_memory int8 NN
pg_catalog stcs_internal_query_details wlm_slot_type char(8) NN
pg_catalog stcs_internal_query_details xid int8 NN
pg_catalog stcs_internal_query_details xregion_datasharing_tables_accessed int4 NN
pg_catalog stcs_internal_query_details zindex_tables_accessed int4 NN


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