Redshift Observatory

System Table Tracker

System view pg_catalog.stl_sessions version 1.0.41194 / 2022-09-03

schema name column data type
pg_catalog stl_sessions db_name char(50)
pg_catalog stl_sessions endtime timestamp
pg_catalog stl_sessions process int4
pg_catalog stl_sessions starttime timestamp
pg_catalog stl_sessions timed_out int4
pg_catalog stl_sessions timeout_sec int4
pg_catalog stl_sessions userid int4
pg_catalog stl_sessions user_name char(50)

View Text

SELECT stll_sessions.userid,
       stll_sessions.starttime,
       stll_sessions.endtime,
       stll_sessions.process,
       stll_sessions.user_name,
       stll_sessions.db_name,
       stll_sessions.timeout_sec,
       stll_sessions.timed_out
FROM stll_sessions


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