Redshift Observatory

System Table Tracker

System view pg_catalog.stl_db_isolation_level version 1.0.43931 / 2022-11-18

schema	name	column	data type
pg_catalog	stl_db_isolation_level	command_type	char(20)
pg_catalog	stl_db_isolation_level	connected_db_id	int4
pg_catalog	stl_db_isolation_level	logtime	timestamp
pg_catalog	stl_db_isolation_level	new_isolation_level	char(20)
pg_catalog	stl_db_isolation_level	pid	int4
pg_catalog	stl_db_isolation_level	prev_isolation_level	char(20)
pg_catalog	stl_db_isolation_level	target_db_id	int4
pg_catalog	stl_db_isolation_level	target_db_name	char(30)
pg_catalog	stl_db_isolation_level	userid	int4

View Text

SELECT stll_db_isolation_level.userid,
       stll_db_isolation_level.pid,
       stll_db_isolation_level.logtime,
       stll_db_isolation_level.command_type,
       stll_db_isolation_level.prev_isolation_level,
       stll_db_isolation_level.new_isolation_level,
       stll_db_isolation_level.connected_db_id,
       stll_db_isolation_level.target_db_id,
       stll_db_isolation_level.target_db_name
FROM stll_db_isolation_level

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