Redshift Observatory

System Table Tracker

System view pg_catalog.stl_process_state version 1.0.39251 / 2022-06-17

schema	name	column	data type
pg_catalog	stl_process_state	mem_current_rss_anon_kb	int8
pg_catalog	stl_process_state	mem_current_rss_file_kb	int8
pg_catalog	stl_process_state	mem_current_rss_kb	int8
pg_catalog	stl_process_state	mem_current_rss_shared_kb	int8
pg_catalog	stl_process_state	mem_current_swap_kb	int8
pg_catalog	stl_process_state	mem_current_virtual_kb	int8
pg_catalog	stl_process_state	mem_peak_rss_kb	int8
pg_catalog	stl_process_state	mem_peak_virtual_kb	int8
pg_catalog	stl_process_state	node	int4
pg_catalog	stl_process_state	pid	int4
pg_catalog	stl_process_state	process_type	int4
pg_catalog	stl_process_state	process_type_str	char(64)
pg_catalog	stl_process_state	record_time	timestamp

View Text

SELECT stll_process_state.pid,
       stll_process_state.node,
       stll_process_state.process_type,
       stll_process_state.process_type_str,
       stll_process_state.record_time,
       stll_process_state.mem_current_virtual_kb,
       stll_process_state.mem_peak_virtual_kb,
       stll_process_state.mem_current_rss_kb,
       stll_process_state.mem_peak_rss_kb,
       stll_process_state.mem_current_rss_anon_kb,
       stll_process_state.mem_current_rss_file_kb,
       stll_process_state.mem_current_rss_shared_kb,
       stll_process_state.mem_current_swap_kb
FROM stll_process_state

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