Redshift Observatory

System Table Tracker

System view pg_catalog.stl_diskman_query_block_read_stats version 1.0.54239 / 2023-08-04

schema	name	column	data type
pg_catalog	stl_diskman_query_block_read_stats	diskman_read_append_pending_io	int8
pg_catalog	stl_diskman_query_block_read_stats	diskman_read_disk	int8
pg_catalog	stl_diskman_query_block_read_stats	diskman_read_memory	int8
pg_catalog	stl_diskman_query_block_read_stats	node_num	int4
pg_catalog	stl_diskman_query_block_read_stats	query_read_append_pending_io	int8
pg_catalog	stl_diskman_query_block_read_stats	query_read_disk	int8
pg_catalog	stl_diskman_query_block_read_stats	query_read_memory	int8
pg_catalog	stl_diskman_query_block_read_stats	read_completion_in_diskman	int8
pg_catalog	stl_diskman_query_block_read_stats	read_completion_outside_diskman	int8
pg_catalog	stl_diskman_query_block_read_stats	read_completion_redirected	int8
pg_catalog	stl_diskman_query_block_read_stats	read_io_redirected	int8
pg_catalog	stl_diskman_query_block_read_stats	recordtime	timestamp

View Text

SELECT stll_diskman_query_block_read_stats.recordtime,
       stll_diskman_query_block_read_stats.node_num,
       stll_diskman_query_block_read_stats.query_read_memory,
       stll_diskman_query_block_read_stats.query_read_disk,
       stll_diskman_query_block_read_stats.diskman_read_memory,
       stll_diskman_query_block_read_stats.diskman_read_disk,
       stll_diskman_query_block_read_stats.read_io_redirected,
       stll_diskman_query_block_read_stats.read_completion_outside_diskman,
       stll_diskman_query_block_read_stats.read_completion_in_diskman,
       stll_diskman_query_block_read_stats.read_completion_redirected,
       stll_diskman_query_block_read_stats.query_read_append_pending_io,
       stll_diskman_query_block_read_stats.diskman_read_append_pending_io
FROM stll_diskman_query_block_read_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