Redshift Observatory

System Table Tracker

System view pg_catalog.stl_tidal_tbl_perm version 1.0.77687 / 2024-11-01

schema	name	column	data type
pg_catalog	stl_tidal_tbl_perm	block_count	int4
pg_catalog	stl_tidal_tbl_perm	db_id	int4
pg_catalog	stl_tidal_tbl_perm	delete_table_id	int4
pg_catalog	stl_tidal_tbl_perm	dist_style	int4
pg_catalog	stl_tidal_tbl_perm	partial_block_count	int4
pg_catalog	stl_tidal_tbl_perm	recordtime	int8
pg_catalog	stl_tidal_tbl_perm	slice	int4
pg_catalog	stl_tidal_tbl_perm	table_id	int4
pg_catalog	stl_tidal_tbl_perm	table_name	char(128)
pg_catalog	stl_tidal_tbl_perm	temp	int4
pg_catalog	stl_tidal_tbl_perm	user_id	int4

View Text

SELECT stll_tidal_tbl_perm.recordtime,
       stll_tidal_tbl_perm.user_id,
       stll_tidal_tbl_perm.table_name,
       stll_tidal_tbl_perm.table_id,
       stll_tidal_tbl_perm.delete_table_id,
       stll_tidal_tbl_perm.slice,
       stll_tidal_tbl_perm.temp,
       stll_tidal_tbl_perm.db_id,
       stll_tidal_tbl_perm.dist_style,
       stll_tidal_tbl_perm.block_count,
       stll_tidal_tbl_perm.partial_block_count
FROM stll_tidal_tbl_perm

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