Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog stl_restarted_sessions currenttime timestamp
pg_catalog stl_restarted_sessions dbname char(50)
pg_catalog stl_restarted_sessions newpid int4
pg_catalog stl_restarted_sessions oldpid int4
pg_catalog stl_restarted_sessions parkedtime timestamp
pg_catalog stl_restarted_sessions remotehost char(32)
pg_catalog stl_restarted_sessions remoteport char(32)
pg_catalog stl_restarted_sessions session_vars char(2000)
pg_catalog stl_restarted_sessions username char(50)

View Text

SELECT stll_restarted_sessions.currenttime,
       stll_restarted_sessions.dbname,
       stll_restarted_sessions.newpid,
       stll_restarted_sessions.oldpid,
       stll_restarted_sessions.username,
       stll_restarted_sessions.remotehost,
       stll_restarted_sessions.remoteport,
       stll_restarted_sessions.parkedtime,
       stll_restarted_sessions.session_vars
FROM stll_restarted_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