Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	svcs_error	context	char(100)
pg_catalog	svcs_error	errcode	int4
pg_catalog	svcs_error	error	char(512)
pg_catalog	svcs_error	file	char(90)
pg_catalog	svcs_error	linenum	int4
pg_catalog	svcs_error	pid	int4
pg_catalog	svcs_error	process	char(32)
pg_catalog	svcs_error	recordtime	timestamp
pg_catalog	svcs_error	userid	int4

View Text

SELECT stcs_error.userid,
       stcs_error.process,
       CAST('1970-01-01 00:00:00' AS timestamp) + (CAST((CAST(stcs_error.recordtime AS numeric) / (1000.0 * 1000.0)) + 946684800.0 AS double precision) * CAST('00:00:01' AS interval)) AS recordtime,
       stcs_error.pid,
       stcs_error.errcode,
       stcs_error.file,
       stcs_error.linenum,
       stcs_error.context,
       stcs_error.error
FROM stcs_error

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