Redshift Observatory

System Table Tracker

System table pg_catalog.stcs_query_block_stats version 1.0.48004 / 2023-03-20

schema name column data type PK U NN
pg_catalog stcs_query_block_stats block_faults int4 NN
pg_catalog stcs_query_block_stats block_reads int4 NN
pg_catalog stcs_query_block_stats block_reads_already_in_s3 int4 NN
pg_catalog stcs_query_block_stats blocks_used int8 NN
pg_catalog stcs_query_block_stats __cluster_type char(4) NN
pg_catalog stcs_query_block_stats disk_fetches int8 NN
pg_catalog stcs_query_block_stats disk_prefetches int8 NN
pg_catalog stcs_query_block_stats __log_generated_date char(8) NN
pg_catalog stcs_query_block_stats max_block_fetchtime int8 NN
pg_catalog stcs_query_block_stats max_transblock_fetchtime int8 NN
pg_catalog stcs_query_block_stats megatrans_block_fault int8 NN
pg_catalog stcs_query_block_stats megatrans_block_fetches int8 NN
pg_catalog stcs_query_block_stats megatrans_block_prefetches int8 NN
pg_catalog stcs_query_block_stats megatrans_block_reads int8 NN
pg_catalog stcs_query_block_stats __path varchar(2050) NN
pg_catalog stcs_query_block_stats query int4 NN
pg_catalog stcs_query_block_stats s3_fetches int8 NN
pg_catalog stcs_query_block_stats s3_prefetches int8 NN
pg_catalog stcs_query_block_stats segment int4 NN
pg_catalog stcs_query_block_stats __size int8 NN
pg_catalog stcs_query_block_stats slice int4 NN
pg_catalog stcs_query_block_stats __spectrum_oid varchar(128) NN
pg_catalog stcs_query_block_stats total_block_fetchtime int8 NN
pg_catalog stcs_query_block_stats total_transblock_fetchtime int8 NN
pg_catalog stcs_query_block_stats transblock_faults int4 NN
pg_catalog stcs_query_block_stats trans_block_fetches int8 NN
pg_catalog stcs_query_block_stats trans_block_prefetches int8 NN
pg_catalog stcs_query_block_stats transblock_reads 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