Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog sys_query_history database_name varchar(128)
pg_catalog sys_query_history elapsed_time int8
pg_catalog sys_query_history end_time timestamp
pg_catalog sys_query_history error_message varchar(512)
pg_catalog sys_query_history execution_time int8
pg_catalog sys_query_history query_id int8
pg_catalog sys_query_history query_label varchar(320)
pg_catalog sys_query_history query_text varchar(4000)
pg_catalog sys_query_history query_type varchar(32)
pg_catalog sys_query_history queue_time int8
pg_catalog sys_query_history redshift_version char(32)
pg_catalog sys_query_history result_cache_hit bool
pg_catalog sys_query_history returned_bytes int8
pg_catalog sys_query_history returned_rows int8
pg_catalog sys_query_history session_id int4
pg_catalog sys_query_history start_time timestamp
pg_catalog sys_query_history status char(10)
pg_catalog sys_query_history transaction_id int8
pg_catalog sys_query_history usage_limit varchar(150)
pg_catalog sys_query_history user_id int4

View Text

Error: describing system view <sys_query_history> 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 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