Redshift Observatory

System Table Tracker

System view pg_catalog.stl_spatial_index version 1.0.39009 / 2022-06-08

schema	name	column	data type
pg_catalog	stl_spatial_index	created	char(1)
pg_catalog	stl_spatial_index	mem_allowance	int8
pg_catalog	stl_spatial_index	num_inner	int8
pg_catalog	stl_spatial_index	num_outer	int8
pg_catalog	stl_spatial_index	predicate	int4
pg_catalog	stl_spatial_index	predicted_size	int8
pg_catalog	stl_spatial_index	pruned_tuples	int8
pg_catalog	stl_spatial_index	query	int4
pg_catalog	stl_spatial_index	segment	int4
pg_catalog	stl_spatial_index	slice	int4
pg_catalog	stl_spatial_index	step	int4
pg_catalog	stl_spatial_index	type	int4

View Text

SELECT stll_spatial_index.query,
       stll_spatial_index.slice,
       stll_spatial_index.segment,
       stll_spatial_index.step,
       stll_spatial_index.type,
       stll_spatial_index.num_inner,
       stll_spatial_index.num_outer,
       stll_spatial_index.pruned_tuples,
       stll_spatial_index.predicate,
       stll_spatial_index.created,
       stll_spatial_index.mem_allowance,
       stll_spatial_index.predicted_size
FROM stll_spatial_index

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