Redshift Observatory

System Table Tracker

System table pg_catalog.stcs_query_history_base version 1.0.39009 / 2022-06-08

schema name column data type PK U NN
pg_catalog stcs_query_history_base child_query_id int4 NN
pg_catalog stcs_query_history_base child_query_sequence int4 NN
pg_catalog stcs_query_history_base __cluster_type char(4) NN
pg_catalog stcs_query_history_base concurrency_scaling_status int4 NN
pg_catalog stcs_query_history_base db char(64) NN
pg_catalog stcs_query_history_base error_message char(512) NN
pg_catalog stcs_query_history_base eventtime int8 NN
pg_catalog stcs_query_history_base label char(320) NN
pg_catalog stcs_query_history_base location_tag char(32) NN
pg_catalog stcs_query_history_base __log_generated_date char(8) NN
pg_catalog stcs_query_history_base __path varchar(2050) NN
pg_catalog stcs_query_history_base pid int4 NN
pg_catalog stcs_query_history_base query_id int8 NN
pg_catalog stcs_query_history_base query_text char(4000) NN
pg_catalog stcs_query_history_base query_type char(32) NN
pg_catalog stcs_query_history_base redshift_version char(256) NN
pg_catalog stcs_query_history_base result_cache_source_query int8 NN
pg_catalog stcs_query_history_base returned_bytes int8 NN
pg_catalog stcs_query_history_base returned_rows int8 NN
pg_catalog stcs_query_history_base service_class int4 NN
pg_catalog stcs_query_history_base __size int8 NN
pg_catalog stcs_query_history_base __spectrum_oid varchar(128) NN
pg_catalog stcs_query_history_base status char(10) NN
pg_catalog stcs_query_history_base task int4 NN
pg_catalog stcs_query_history_base total_exec_time int8 NN
pg_catalog stcs_query_history_base total_queue_time int8 NN
pg_catalog stcs_query_history_base usage_limit char(150) NN
pg_catalog stcs_query_history_base user_id int4 NN
pg_catalog stcs_query_history_base xid int8 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