Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_auto_task_events	actor_pid	int4
pg_catalog	stl_auto_task_events	event_time	timestamp
pg_catalog	stl_auto_task_events	max_execution_time_sec	int4
pg_catalog	stl_auto_task_events	message	char(300)
pg_catalog	stl_auto_task_events	pid	int4
pg_catalog	stl_auto_task_events	priority	float8
pg_catalog	stl_auto_task_events	production_time	int8
pg_catalog	stl_auto_task_events	retry_count	int4
pg_catalog	stl_auto_task_events	run_queries	int4
pg_catalog	stl_auto_task_events	task_id	int8
pg_catalog	stl_auto_task_events	task_state	char(50)
pg_catalog	stl_auto_task_events	task_type	char(100)

View Text

SELECT stll_auto_task_events.actor_pid,
       stll_auto_task_events.task_type,
       stll_auto_task_events.task_state,
       stll_auto_task_events.priority,
       stll_auto_task_events.run_queries,
       stll_auto_task_events.pid,
       stll_auto_task_events.retry_count,
       stll_auto_task_events.production_time,
       stll_auto_task_events.max_execution_time_sec,
       stll_auto_task_events.event_time,
       stll_auto_task_events.message,
       stll_auto_task_events.task_id
FROM stll_auto_task_events

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