Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog stl_query_block_stats block_faults int4
pg_catalog stl_query_block_stats block_reads int4
pg_catalog stl_query_block_stats block_reads_already_in_s3 int4
pg_catalog stl_query_block_stats blocks_used int8
pg_catalog stl_query_block_stats disk_fetches int8
pg_catalog stl_query_block_stats disk_prefetches int8
pg_catalog stl_query_block_stats max_block_fetchtime int8
pg_catalog stl_query_block_stats max_transblock_fetchtime int8
pg_catalog stl_query_block_stats megatrans_block_fault int8
pg_catalog stl_query_block_stats megatrans_block_fetches int8
pg_catalog stl_query_block_stats megatrans_block_prefetches int8
pg_catalog stl_query_block_stats megatrans_block_reads int8
pg_catalog stl_query_block_stats query int4
pg_catalog stl_query_block_stats s3_fetches int8
pg_catalog stl_query_block_stats s3_prefetches int8
pg_catalog stl_query_block_stats segment int4
pg_catalog stl_query_block_stats slice int4
pg_catalog stl_query_block_stats total_block_fetchtime int8
pg_catalog stl_query_block_stats total_transblock_fetchtime int8
pg_catalog stl_query_block_stats transblock_faults int4
pg_catalog stl_query_block_stats trans_block_fetches int8
pg_catalog stl_query_block_stats trans_block_prefetches int8
pg_catalog stl_query_block_stats transblock_reads int4

View Text

SELECT stll_query_block_stats.query,
       stll_query_block_stats.slice,
       stll_query_block_stats.segment,
       stll_query_block_stats.block_reads,
       stll_query_block_stats.block_faults,
       stll_query_block_stats.total_block_fetchtime,
       stll_query_block_stats.max_block_fetchtime,
       stll_query_block_stats.transblock_reads,
       stll_query_block_stats.transblock_faults,
       stll_query_block_stats.total_transblock_fetchtime,
       stll_query_block_stats.max_transblock_fetchtime,
       stll_query_block_stats.blocks_used,
       stll_query_block_stats.block_reads_already_in_s3,
       stll_query_block_stats.disk_fetches,
       stll_query_block_stats.disk_prefetches,
       stll_query_block_stats.s3_fetches,
       stll_query_block_stats.s3_prefetches,
       stll_query_block_stats.trans_block_fetches,
       stll_query_block_stats.trans_block_prefetches,
       stll_query_block_stats.megatrans_block_reads,
       stll_query_block_stats.megatrans_block_fault,
       stll_query_block_stats.megatrans_block_fetches,
       stll_query_block_stats.megatrans_block_prefetches
FROM stll_query_block_stats


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