Redshift Observatory

System Table Tracker

System view pg_catalog.stl_load_error_detail_base version 1.0.40677 / 2022-08-14

schema	name	column	data type
pg_catalog	stl_load_error_detail_base	child_query_id	int4
pg_catalog	stl_load_error_detail_base	col_length	char(10)
pg_catalog	stl_load_error_detail_base	col_name	char(127)
pg_catalog	stl_load_error_detail_base	db	char(64)
pg_catalog	stl_load_error_detail_base	err_code	int4
pg_catalog	stl_load_error_detail_base	err_reason	char(100)
pg_catalog	stl_load_error_detail_base	filename	char(256)
pg_catalog	stl_load_error_detail_base	line_number	int8
pg_catalog	stl_load_error_detail_base	pid	int4
pg_catalog	stl_load_error_detail_base	position	int4
pg_catalog	stl_load_error_detail_base	query_id	int8
pg_catalog	stl_load_error_detail_base	raw_field_value	char(1024)
pg_catalog	stl_load_error_detail_base	raw_line	char(1024)
pg_catalog	stl_load_error_detail_base	slice	int4
pg_catalog	stl_load_error_detail_base	starttime	timestamp
pg_catalog	stl_load_error_detail_base	table_id	int4
pg_catalog	stl_load_error_detail_base	type	char(10)
pg_catalog	stl_load_error_detail_base	user_id	int4
pg_catalog	stl_load_error_detail_base	xid	int8

View Text

SELECT stll_load_error_detail_base.user_id,
       stll_load_error_detail_base.query_id,
       stll_load_error_detail_base.child_query_id,
       stll_load_error_detail_base.pid,
       stll_load_error_detail_base.db,
       stll_load_error_detail_base.xid,
       stll_load_error_detail_base.slice,
       stll_load_error_detail_base.table_id,
       stll_load_error_detail_base.starttime,
       stll_load_error_detail_base.filename,
       stll_load_error_detail_base.line_number,
       stll_load_error_detail_base.col_name,
       stll_load_error_detail_base.type,
       stll_load_error_detail_base.col_length,
       stll_load_error_detail_base.position,
       stll_load_error_detail_base.raw_line,
       stll_load_error_detail_base.raw_field_value,
       stll_load_error_detail_base.err_code,
       stll_load_error_detail_base.err_reason
FROM stll_load_error_detail_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