Redshift Observatory

System Table Tracker

System view pg_catalog.stl_spatial_index version 1.0.56754 / 2023-09-21

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