Redshift Observatory

System Table Tracker

System view pg_catalog.stl_spatial_join version 1.0.69952 / 2024-06-27

schema	name	column	data type
pg_catalog	stl_spatial_join	checksum	int8
pg_catalog	stl_spatial_join	distribution	int4
pg_catalog	stl_spatial_join	endtime	timestamp
pg_catalog	stl_spatial_join	predicate	int4
pg_catalog	stl_spatial_join	pruned_tuples	int8
pg_catalog	stl_spatial_join	query	int4
pg_catalog	stl_spatial_join	rows	int8
pg_catalog	stl_spatial_join	rtree_segment	int4
pg_catalog	stl_spatial_join	rtree_step	int4
pg_catalog	stl_spatial_join	segment	int4
pg_catalog	stl_spatial_join	slice	int4
pg_catalog	stl_spatial_join	starttime	timestamp
pg_catalog	stl_spatial_join	step	int4
pg_catalog	stl_spatial_join	tasknum	int4
pg_catalog	stl_spatial_join	tbl	int4
pg_catalog	stl_spatial_join	userid	int4

View Text

SELECT stll_spatial_join.userid,
       stll_spatial_join.query,
       stll_spatial_join.slice,
       stll_spatial_join.segment,
       stll_spatial_join.step,
       stll_spatial_join.rtree_segment,
       stll_spatial_join.rtree_step,
       stll_spatial_join.starttime,
       stll_spatial_join.endtime,
       stll_spatial_join.tasknum,
       stll_spatial_join.predicate,
       stll_spatial_join.rows,
       stll_spatial_join.pruned_tuples,
       stll_spatial_join.tbl,
       stll_spatial_join.checksum,
       stll_spatial_join.distribution
FROM stll_spatial_join
WHERE stll_spatial_join.access_control = 0
   OR stll_spatial_join.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