Redshift Observatory

System Table Tracker

System view pg_catalog.sys_query_detail version 1.0.74503 / 2024-09-16

schema name column data type
pg_catalog sys_query_detail alert varchar(1024)
pg_catalog sys_query_detail blocks_read int8
pg_catalog sys_query_detail blocks_write int8
pg_catalog sys_query_detail child_query_sequence int4
pg_catalog sys_query_detail data_skewness int4
pg_catalog sys_query_detail duration int8
pg_catalog sys_query_detail end_time timestamp
pg_catalog sys_query_detail input_bytes int8
pg_catalog sys_query_detail input_rows int8
pg_catalog sys_query_detail is_active varchar(1)
pg_catalog sys_query_detail is_rrscan varchar(1)
pg_catalog sys_query_detail local_read_io int8
pg_catalog sys_query_detail metrics_level varchar(11)
pg_catalog sys_query_detail output_bytes int8
pg_catalog sys_query_detail output_rows int8
pg_catalog sys_query_detail plan_node_id int4
pg_catalog sys_query_detail plan_parent_id int4
pg_catalog sys_query_detail query_id int8
pg_catalog sys_query_detail remote_read_io int8
pg_catalog sys_query_detail segment_id int4
pg_catalog sys_query_detail source varchar(64)
pg_catalog sys_query_detail spilled_block_local_disk int8
pg_catalog sys_query_detail spilled_block_remote_disk int8
pg_catalog sys_query_detail start_time timestamp
pg_catalog sys_query_detail step_attribute varchar(64)
pg_catalog sys_query_detail step_id int4
pg_catalog sys_query_detail step_name varchar(256)
pg_catalog sys_query_detail stream_id int4
pg_catalog sys_query_detail table_id int4
pg_catalog sys_query_detail table_name varchar(136)
pg_catalog sys_query_detail time_skewness int4
pg_catalog sys_query_detail user_id int4

View Text

Error: describing system view <sys_query_detail> is disabled.

Note the AWS are as you see here censoring the SQL of more recent system tables views. This is problematic, as the docs are no good, and so it's not uncommon to need to view the text to make sense of the output. I am of the view AWS, at least as far as Redshift are concerned, has a culture of secrecy and I see this as more of the same. I can see absolutely no reason or benefit, for users, for censoring the view text.


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