Redshift Observatory

System Table Tracker

System view pg_catalog.stl_restarted_sessions_internal version 1.0.41881 / 2022-09-30

schema	name	column	data type
pg_catalog	stl_restarted_sessions_internal	are_commands_repeated	char(10)
pg_catalog	stl_restarted_sessions_internal	auto_resume	char(10)
pg_catalog	stl_restarted_sessions_internal	can_reissue_query	char(10)
pg_catalog	stl_restarted_sessions_internal	conn_state	char(100)
pg_catalog	stl_restarted_sessions_internal	current_executing_command	char(10)
pg_catalog	stl_restarted_sessions_internal	currenttime	timestamp
pg_catalog	stl_restarted_sessions_internal	in_authentication	char(10)
pg_catalog	stl_restarted_sessions_internal	in_xact_blk	char(10)
pg_catalog	stl_restarted_sessions_internal	is_bootstrap	char(10)
pg_catalog	stl_restarted_sessions_internal	is_extended_protocol	char(10)
pg_catalog	stl_restarted_sessions_internal	is_idle_connection	char(10)
pg_catalog	stl_restarted_sessions_internal	is_inc_resize	char(10)
pg_catalog	stl_restarted_sessions_internal	is_protocol_v3	char(10)
pg_catalog	stl_restarted_sessions_internal	is_read_only	char(10)
pg_catalog	stl_restarted_sessions_internal	is_reforkable	char(10)
pg_catalog	stl_restarted_sessions_internal	is_restarted_session	char(10)
pg_catalog	stl_restarted_sessions_internal	is_single_stmt_query	char(10)
pg_catalog	stl_restarted_sessions_internal	is_ssl_compressed	char(10)
pg_catalog	stl_restarted_sessions_internal	named_prep_stmt_ct	int4
pg_catalog	stl_restarted_sessions_internal	parked_state_in_proxy	char(10)
pg_catalog	stl_restarted_sessions_internal	pid	int4
pg_catalog	stl_restarted_sessions_internal	session_size	int8
pg_catalog	stl_restarted_sessions_internal	temp_tbl_created	char(10)
pg_catalog	stl_restarted_sessions_internal	unnamed_stmt_ct	int4
pg_catalog	stl_restarted_sessions_internal	unsupported_command_sequence	char(10)
pg_catalog	stl_restarted_sessions_internal	written_state_to_disk	char(10)

View Text

SELECT stll_restarted_sessions_internal.currenttime,
       stll_restarted_sessions_internal.is_reforkable,
       stll_restarted_sessions_internal.temp_tbl_created,
       stll_restarted_sessions_internal.named_prep_stmt_ct,
       stll_restarted_sessions_internal.unnamed_stmt_ct,
       stll_restarted_sessions_internal.in_xact_blk,
       stll_restarted_sessions_internal.is_read_only,
       stll_restarted_sessions_internal.is_single_stmt_query,
       stll_restarted_sessions_internal.conn_state,
       stll_restarted_sessions_internal.pid,
       stll_restarted_sessions_internal.in_authentication,
       stll_restarted_sessions_internal.is_bootstrap,
       stll_restarted_sessions_internal.is_restarted_session,
       stll_restarted_sessions_internal.is_extended_protocol,
       stll_restarted_sessions_internal.is_idle_connection,
       stll_restarted_sessions_internal.current_executing_command,
       stll_restarted_sessions_internal.is_ssl_compressed,
       stll_restarted_sessions_internal.is_protocol_v3,
       stll_restarted_sessions_internal.are_commands_repeated,
       stll_restarted_sessions_internal.unsupported_command_sequence,
       stll_restarted_sessions_internal.can_reissue_query,
       stll_restarted_sessions_internal.parked_state_in_proxy,
       stll_restarted_sessions_internal.session_size,
       stll_restarted_sessions_internal.is_inc_resize,
       stll_restarted_sessions_internal.written_state_to_disk,
       stll_restarted_sessions_internal.auto_resume
FROM stll_restarted_sessions_internal

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