Redshift Observatory

System Table Tracker

System view pg_catalog.stl_persisted_sessions_on_disk version 1.0.40325 / 2022-07-29

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 Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers