Redshift Observatory

System Table Tracker

System view pg_catalog.stl_persisted_sessions_on_disk version 1.0.39009 / 2022-06-08

schema	name	column	data type
pg_catalog	stl_persisted_sessions_on_disk	eventname	char(30)
pg_catalog	stl_persisted_sessions_on_disk	expirationtime	timestamp
pg_catalog	stl_persisted_sessions_on_disk	pid	int4
pg_catalog	stl_persisted_sessions_on_disk	recordtime	timestamp
pg_catalog	stl_persisted_sessions_on_disk	sessionid	char(36)

View Text

SELECT stll_persisted_sessions_on_disk.recordtime,
       stll_persisted_sessions_on_disk.pid,
       stll_persisted_sessions_on_disk.sessionid,
       stll_persisted_sessions_on_disk.expirationtime,
       stll_persisted_sessions_on_disk.eventname
FROM stll_persisted_sessions_on_disk

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