Redshift Observatory

System Table Tracker

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

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