Redshift Observatory

System Table Tracker

System table pg_catalog.stcs_query_detail version 1.0.45698 / 2023-01-27

schema name column data type PK U NN
pg_catalog stcs_query_detail alert char(1024) NN
pg_catalog stcs_query_detail blocks_read int8 NN
pg_catalog stcs_query_detail blocks_write int8 NN
pg_catalog stcs_query_detail child_query_id int4 NN
pg_catalog stcs_query_detail child_query_sequence int4 NN
pg_catalog stcs_query_detail __cluster_type char(4) NN
pg_catalog stcs_query_detail cpu_time int8 NN
pg_catalog stcs_query_detail endtime int8 NN
pg_catalog stcs_query_detail input_bytes int8 NN
pg_catalog stcs_query_detail input_rows int8 NN
pg_catalog stcs_query_detail internal_query char(1) NN
pg_catalog stcs_query_detail is_rrscan char(1) NN
pg_catalog stcs_query_detail local_read_io int8 NN
pg_catalog stcs_query_detail __log_generated_date char(8) NN
pg_catalog stcs_query_detail output_bytes int8 NN
pg_catalog stcs_query_detail output_rows int8 NN
pg_catalog stcs_query_detail __path varchar(2050) NN
pg_catalog stcs_query_detail query_id int8 NN
pg_catalog stcs_query_detail remote_read_io int8 NN
pg_catalog stcs_query_detail segment_id int4 NN
pg_catalog stcs_query_detail __size int8 NN
pg_catalog stcs_query_detail slice int4 NN
pg_catalog stcs_query_detail source char(64) NN
pg_catalog stcs_query_detail __spectrum_oid varchar(128) NN
pg_catalog stcs_query_detail starttime int8 NN
pg_catalog stcs_query_detail step_id int4 NN
pg_catalog stcs_query_detail step_name int4 NN
pg_catalog stcs_query_detail stream_id int4 NN
pg_catalog stcs_query_detail table_id int4 NN
pg_catalog stcs_query_detail table_name char(136) NN
pg_catalog stcs_query_detail user_id 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