Redshift Observatory

System Table Tracker

System view pg_catalog.stl_udf_log version 1.0.70890 / 2024-07-14

schema	name	column	data type
pg_catalog	stl_udf_log	created	timestamp
pg_catalog	stl_udf_log	filename	char(256)
pg_catalog	stl_udf_log	funcname	char(256)
pg_catalog	stl_udf_log	level_name	char(64)
pg_catalog	stl_udf_log	level_number	int4
pg_catalog	stl_udf_log	lineno	int4
pg_catalog	stl_udf_log	message	char(4096)
pg_catalog	stl_udf_log	module	char(256)
pg_catalog	stl_udf_log	msecs	float8
pg_catalog	stl_udf_log	name	char(256)
pg_catalog	stl_udf_log	node	int4
pg_catalog	stl_udf_log	path_name	char(256)
pg_catalog	stl_udf_log	process	int8
pg_catalog	stl_udf_log	process_name	char(256)
pg_catalog	stl_udf_log	query	int8
pg_catalog	stl_udf_log	relative_created	float8
pg_catalog	stl_udf_log	seq	int4
pg_catalog	stl_udf_log	slice	int4
pg_catalog	stl_udf_log	thread	int8
pg_catalog	stl_udf_log	thread_name	char(256)
pg_catalog	stl_udf_log	traceback	char(4096)

View Text

SELECT stll_udf_log.query,
       stll_udf_log.message,
       stll_udf_log.created,
       stll_udf_log.filename,
       stll_udf_log.funcname,
       stll_udf_log.level_name,
       stll_udf_log.level_number,
       stll_udf_log.lineno,
       stll_udf_log.module,
       stll_udf_log.msecs,
       stll_udf_log.name,
       stll_udf_log.path_name,
       stll_udf_log.process,
       stll_udf_log.process_name,
       stll_udf_log.relative_created,
       stll_udf_log.thread,
       stll_udf_log.thread_name,
       stll_udf_log.traceback,
       stll_udf_log.node,
       stll_udf_log.slice,
       stll_udf_log.seq
FROM stll_udf_log
WHERE stll_udf_log.access_control = 0
   OR stll_udf_log.access_control IS NULL
   OR NOT is_seclog_downgrade_enabled()

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