Redshift Observatory

System Table Tracker

System view pg_catalog.stl_diskman_query_block_read_stats version 1.0.46534 / 2023-02-21

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