Redshift Observatory

System Table Tracker

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

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 query_command_sequence char(32)
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,
       stll_restarted_sessions_internal.query_command_sequence
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