Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3partition_predicate version 1.0.46534 / 2023-02-21

schema	name	column	data type
pg_catalog	stl_s3partition_predicate	effectiveness	char(32)
pg_catalog	stl_s3partition_predicate	error	char(1024)
pg_catalog	stl_s3partition_predicate	eventtime	timestamp
pg_catalog	stl_s3partition_predicate	node	int4
pg_catalog	stl_s3partition_predicate	predicate	char(1024)
pg_catalog	stl_s3partition_predicate	query	int4
pg_catalog	stl_s3partition_predicate	segment	int4
pg_catalog	stl_s3partition_predicate	slice	int4
pg_catalog	stl_s3partition_predicate	userid	int4

View Text

SELECT stll_s3partition_predicate.userid,
       stll_s3partition_predicate.query,
       stll_s3partition_predicate.segment,
       stll_s3partition_predicate.node,
       stll_s3partition_predicate.slice,
       stll_s3partition_predicate.eventtime,
       stll_s3partition_predicate.predicate,
       stll_s3partition_predicate.effectiveness,
       stll_s3partition_predicate.error
FROM stll_s3partition_predicate

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