Redshift Observatory

System Table Tracker

System view pg_catalog.stl_restarted_sessions version 1.0.52931 / 2023-07-07

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