Redshift Observatory

System Table Tracker

System view pg_catalog.stl_s3partition_elimination version 1.0.76913 / 2024-10-24

schema	name	column	data type
pg_catalog	stl_s3partition_elimination	assigned_partitions	int4
pg_catalog	stl_s3partition_elimination	assignment	char(1)
pg_catalog	stl_s3partition_elimination	duration	int8
pg_catalog	stl_s3partition_elimination	endtime	timestamp
pg_catalog	stl_s3partition_elimination	fetched_partitions	int4
pg_catalog	stl_s3partition_elimination	node	int4
pg_catalog	stl_s3partition_elimination	qualified_partitions	int4
pg_catalog	stl_s3partition_elimination	query	int4
pg_catalog	stl_s3partition_elimination	scan_type	int4
pg_catalog	stl_s3partition_elimination	segment	int4
pg_catalog	stl_s3partition_elimination	slice	int4
pg_catalog	stl_s3partition_elimination	starttime	timestamp
pg_catalog	stl_s3partition_elimination	total_partitions	int4
pg_catalog	stl_s3partition_elimination	userid	int4
pg_catalog	stl_s3partition_elimination	user_query_id	int8
pg_catalog	stl_s3partition_elimination	uuid	char(36)

View Text

SELECT stll_s3partition_elimination.userid,
       stll_s3partition_elimination.query,
       stll_s3partition_elimination.uuid,
       stll_s3partition_elimination.segment,
       stll_s3partition_elimination.node,
       stll_s3partition_elimination.slice,
       stll_s3partition_elimination.starttime,
       stll_s3partition_elimination.endtime,
       stll_s3partition_elimination.total_partitions,
       stll_s3partition_elimination.qualified_partitions,
       stll_s3partition_elimination.assignment,
       stll_s3partition_elimination.duration,
       stll_s3partition_elimination.assigned_partitions,
       stll_s3partition_elimination.scan_type,
       stll_s3partition_elimination.fetched_partitions,
       stll_s3partition_elimination.user_query_id
FROM stll_s3partition_elimination
WHERE stll_s3partition_elimination.access_control = 0
   OR stll_s3partition_elimination.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