Redshift Observatory

System Table Tracker

System view pg_catalog.sys_connection_log version 1.0.60353 / 2023-11-24

schema name column data type
pg_catalog sys_connection_log application_name char(250)
pg_catalog sys_connection_log auth_method char(32)
pg_catalog sys_connection_log database_name char(50)
pg_catalog sys_connection_log driver_version char(64)
pg_catalog sys_connection_log duration int8
pg_catalog sys_connection_log event char(50)
pg_catalog sys_connection_log global_session_id char(36)
pg_catalog sys_connection_log iam_auth_guid char(36)
pg_catalog sys_connection_log mtu int4
pg_catalog sys_connection_log os_version char(64)
pg_catalog sys_connection_log plugin_name char(32)
pg_catalog sys_connection_log protocol_version int4
pg_catalog sys_connection_log record_time timestamp
pg_catalog sys_connection_log remote_host char(45)
pg_catalog sys_connection_log remote_port char(32)
pg_catalog sys_connection_log session_id int4
pg_catalog sys_connection_log ssl_cipher char(128)
pg_catalog sys_connection_log ssl_compression char(64)
pg_catalog sys_connection_log ssl_expansion char(64)
pg_catalog sys_connection_log ssl_version char(50)
pg_catalog sys_connection_log user_name char(50)

View Text

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