Redshift Observatory

System Table Tracker

System view pg_catalog.stl_predicate_information version 1.0.76642 / 2024-10-18

schema	name	column	data type
pg_catalog	stl_predicate_information	expr_datatype	int4
pg_catalog	stl_predicate_information	expr_id	int4
pg_catalog	stl_predicate_information	expr_name	char(64)
pg_catalog	stl_predicate_information	node_id	int4
pg_catalog	stl_predicate_information	parent_node_id	int4
pg_catalog	stl_predicate_information	query	int4
pg_catalog	stl_predicate_information	rrscan_status	int8
pg_catalog	stl_predicate_information	segment	int4
pg_catalog	stl_predicate_information	step	int4
pg_catalog	stl_predicate_information	userid	int4

View Text

SELECT stll_predicate_information.userid,
       stll_predicate_information.query,
       stll_predicate_information.segment,
       stll_predicate_information.step,
       stll_predicate_information.node_id,
       stll_predicate_information.parent_node_id,
       stll_predicate_information.expr_datatype,
       stll_predicate_information.expr_name,
       stll_predicate_information.expr_id,
       stll_predicate_information.rrscan_status
FROM stll_predicate_information

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