Redshift Observatory

System Table Tracker

System table pg_catalog.stcs_query_metrics version 1.0.60353 / 2023-11-24

schema name column data type PK U NN
pg_catalog stcs_query_metrics blocks_read int8 NN
pg_catalog stcs_query_metrics blocks_to_disk int8 NN
pg_catalog stcs_query_metrics __cluster_type char(4) NN
pg_catalog stcs_query_metrics cpu_time int8 NN
pg_catalog stcs_query_metrics __log_generated_date char(8) NN
pg_catalog stcs_query_metrics max_blocks_read int4 NN
pg_catalog stcs_query_metrics max_blocks_to_disk int8 NN
pg_catalog stcs_query_metrics max_cpu_time int8 NN
pg_catalog stcs_query_metrics max_query_scan_size int8 NN
pg_catalog stcs_query_metrics max_rows int8 NN
pg_catalog stcs_query_metrics max_run_time int8 NN
pg_catalog stcs_query_metrics __path varchar(2050) NN
pg_catalog stcs_query_metrics query int4 NN
pg_catalog stcs_query_metrics query_priority int4 NN
pg_catalog stcs_query_metrics query_queue_time int8 NN
pg_catalog stcs_query_metrics query_scan_size int8 NN
pg_catalog stcs_query_metrics rows int8 NN
pg_catalog stcs_query_metrics run_time int8 NN
pg_catalog stcs_query_metrics segment int4 NN
pg_catalog stcs_query_metrics service_class int4 NN
pg_catalog stcs_query_metrics service_class_name char(64) NN
pg_catalog stcs_query_metrics __size int8 NN
pg_catalog stcs_query_metrics slices int4 NN
pg_catalog stcs_query_metrics __spectrum_oid varchar(128) NN
pg_catalog stcs_query_metrics starttime int8 NN
pg_catalog stcs_query_metrics step int4 NN
pg_catalog stcs_query_metrics step_type int4 NN
pg_catalog stcs_query_metrics userid 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