Redshift Research Project

System Table Tracker

System Table Version 1.0.41533 / 2022-09-18

schema name column data type
pg_catalog svl_user_info external_id varchar(128)
pg_catalog svl_user_info last_ddl_ts timestamp
pg_catalog svl_user_info sessiontimeout int4
pg_catalog svl_user_info syslogaccess varchar(256)
pg_catalog svl_user_info usecatupd bool
pg_catalog svl_user_info useconnlimit varchar(256)
pg_catalog svl_user_info usecreatedb bool
pg_catalog svl_user_info usename varchar(128)
pg_catalog svl_user_info usesuper bool
pg_catalog svl_user_info usesysid int4

View Text

SELECT CAST(pg_shadow.usename AS varchar) AS usename,
       pg_shadow.usesysid,
       pg_shadow.usecreatedb,
       pg_shadow.usesuper,
       pg_shadow.usecatupd,
       CAST(CASE
              WHEN pse_col1.value = CAST(-1 AS text)
                THEN CAST('UNLIMITED' AS text)
              ELSE pse_col1.value
            END AS varchar) AS useconnlimit,
       CAST(CASE
              WHEN pse_col2.value = CAST(-1 AS text)
                OR pg_shadow.usesuper = TRUE
                THEN CAST('UNRESTRICTED' AS text)
              ELSE CAST('RESTRICTED' AS text)
            END AS varchar) AS syslogaccess,
       COALESCE(CAST(pse_col3.value AS integer),
                0) AS sessiontimeout,
       stl_userlog.recordtime AS last_ddl_ts,
       CAST(pg_identity.externalid AS varchar(128)) AS external_id
FROM pg_shadow
     LEFT JOIN pg_shadow_extended AS pse_col1 ON pg_shadow.usesysid = pse_col1.sysid
                                             AND pse_col1.colnum = 1
     LEFT JOIN pg_shadow_extended AS pse_col2 ON pg_shadow.usesysid = pse_col2.sysid
                                             AND pse_col2.colnum = 2
     LEFT JOIN pg_shadow_extended AS pse_col3 ON pg_shadow.usesysid = pse_col3.sysid
                                             AND pse_col3.colnum = 3
     LEFT JOIN (SELECT stl_userlog.userid,
                       max(stl_userlog.recordtime) AS recordtime
                FROM stl_userlog
                GROUP BY stl_userlog.userid) AS stl_userlog ON stl_userlog.userid = pg_shadow.usesysid
     LEFT JOIN pg_identity ON pg_shadow.usesysid = pg_identity.useid
WHERE pg_shadow.usesysid > 1


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