Redshift Observatory

System Table Tracker

System table pg_catalog.stcs_internal_query_details version 1.0.41533 / 2022-09-18

schema name column data type PK U 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_tables_accessed int4 NN
pg_catalog stcs_internal_query_details dirty_tables_read int4 NN
pg_catalog stcs_internal_query_details est_peak_mem_needed int8 NN
pg_catalog stcs_internal_query_details initial_query_time int8 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 __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_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 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 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_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_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