Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_load_history_base	bytes_copied	int8
pg_catalog	stl_load_history_base	child_query_id	int4
pg_catalog	stl_load_history_base	child_query_sequence	int4
pg_catalog	stl_load_history_base	copy_job_id	int8
pg_catalog	stl_load_history_base	data_source	char(256)
pg_catalog	stl_load_history_base	db	char(64)
pg_catalog	stl_load_history_base	error_count	int4
pg_catalog	stl_load_history_base	event_time	timestamp
pg_catalog	stl_load_history_base	file_bytes	int8
pg_catalog	stl_load_history_base	file_bytes_scanned	int8
pg_catalog	stl_load_history_base	file_count	int4
pg_catalog	stl_load_history_base	file_count_scanned	int4
pg_catalog	stl_load_history_base	file_format	char(16)
pg_catalog	stl_load_history_base	filename	char(256)
pg_catalog	stl_load_history_base	pid	int4
pg_catalog	stl_load_history_base	query_id	int8
pg_catalog	stl_load_history_base	rows_copied	int8
pg_catalog	stl_load_history_base	slice	int4
pg_catalog	stl_load_history_base	status	int4
pg_catalog	stl_load_history_base	table_name	char(128)
pg_catalog	stl_load_history_base	user_id	int4
pg_catalog	stl_load_history_base	xid	int8

View Text

SELECT stll_load_history_base.user_id,
       stll_load_history_base.db,
       stll_load_history_base.xid,
       stll_load_history_base.pid,
       stll_load_history_base.query_id,
       stll_load_history_base.child_query_sequence,
       stll_load_history_base.child_query_id,
       stll_load_history_base.status,
       stll_load_history_base.table_name,
       stll_load_history_base.event_time,
       stll_load_history_base.slice,
       stll_load_history_base.filename,
       stll_load_history_base.file_count,
       stll_load_history_base.file_bytes,
       stll_load_history_base.file_count_scanned,
       stll_load_history_base.file_bytes_scanned,
       stll_load_history_base.bytes_copied,
       stll_load_history_base.rows_copied,
       stll_load_history_base.file_format,
       stll_load_history_base.error_count,
       stll_load_history_base.data_source,
       stll_load_history_base.copy_job_id
FROM stll_load_history_base

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