Redshift Observatory

System Table Tracker

System table pg_catalog.stcs_external_query_detail_base version 1.0.52931 / 2023-07-07

schema name column data type PK U NN
pg_catalog stcs_external_query_detail_base child_query_id int4 NN
pg_catalog stcs_external_query_detail_base child_query_sequence int4 NN
pg_catalog stcs_external_query_detail_base __cluster_type char(4) NN
pg_catalog stcs_external_query_detail_base duration int8 NN
pg_catalog stcs_external_query_detail_base endtime int8 NN
pg_catalog stcs_external_query_detail_base eventtime int8 NN
pg_catalog stcs_external_query_detail_base file_format char(16) NN
pg_catalog stcs_external_query_detail_base files_scanned int4 NN
pg_catalog stcs_external_query_detail_base location char(256) NN
pg_catalog stcs_external_query_detail_base __log_generated_date char(8) NN
pg_catalog stcs_external_query_detail_base logging_tag char(32) NN
pg_catalog stcs_external_query_detail_base node int4 NN
pg_catalog stcs_external_query_detail_base num_bytes int8 NN
pg_catalog stcs_external_query_detail_base num_rows int8 NN
pg_catalog stcs_external_query_detail_base __path varchar(2050) NN
pg_catalog stcs_external_query_detail_base pg_query_text char(4000) NN
pg_catalog stcs_external_query_detail_base pid int4 NN
pg_catalog stcs_external_query_detail_base qualified_partitions int4 NN
pg_catalog stcs_external_query_detail_base query_id int8 NN
pg_catalog stcs_external_query_detail_base segment_id int4 NN
pg_catalog stcs_external_query_detail_base __size int8 NN
pg_catalog stcs_external_query_detail_base slice int4 NN
pg_catalog stcs_external_query_detail_base sourcetype char(32) NN
pg_catalog stcs_external_query_detail_base __spectrum_oid varchar(128) NN
pg_catalog stcs_external_query_detail_base starttime int8 NN
pg_catalog stcs_external_query_detail_base table_name char(256) NN
pg_catalog stcs_external_query_detail_base total_files int4 NN
pg_catalog stcs_external_query_detail_base total_partitions int4 NN
pg_catalog stcs_external_query_detail_base user_id int4 NN
pg_catalog stcs_external_query_detail_base warning_message char(4000) NN
pg_catalog stcs_external_query_detail_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