Redshift Observatory

System Table Tracker

System view pg_catalog.stl_udf_usage_in_query version 1.0.121010 / 2025-08-28

schema	name	column	data type
pg_catalog	stl_udf_usage_in_query	func_id	int4
pg_catalog	stl_udf_usage_in_query	func_name	char(200)
pg_catalog	stl_udf_usage_in_query	func_type	int4
pg_catalog	stl_udf_usage_in_query	in_case_expr	int4
pg_catalog	stl_udf_usage_in_query	in_targetlist	int4
pg_catalog	stl_udf_usage_in_query	join_side	int4
pg_catalog	stl_udf_usage_in_query	nested_udf	int4
pg_catalog	stl_udf_usage_in_query	nodeid	int4
pg_catalog	stl_udf_usage_in_query	plan_node_type	int4
pg_catalog	stl_udf_usage_in_query	query	int4
pg_catalog	stl_udf_usage_in_query	recordtime	timestamp

View Text

SELECT stll_udf_usage_in_query.query,
       stll_udf_usage_in_query.nodeid,
       stll_udf_usage_in_query.plan_node_type,
       stll_udf_usage_in_query.func_id,
       stll_udf_usage_in_query.func_name,
       stll_udf_usage_in_query.func_type,
       stll_udf_usage_in_query.in_targetlist,
       stll_udf_usage_in_query.recordtime,
       stll_udf_usage_in_query.in_case_expr,
       stll_udf_usage_in_query.join_side,
       stll_udf_usage_in_query.nested_udf
FROM stll_udf_usage_in_query

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers