Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_block_stats version 1.0.50300 / 2023-05-09

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