Redshift Observatory

System Table Tracker

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

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 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
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