Redshift Observatory

System Table Tracker

System view pg_catalog.stl_state_partitions version 1.0.74998 / 2024-09-20

schema	name	column	data type
pg_catalog	stl_state_partitions	capacity	int4
pg_catalog	stl_state_partitions	diskno	int4
pg_catalog	stl_state_partitions	failed	int4
pg_catalog	stl_state_partitions	host	int4
pg_catalog	stl_state_partitions	is_san	int4
pg_catalog	stl_state_partitions	mbps	int4
pg_catalog	stl_state_partitions	mount	char(256)
pg_catalog	stl_state_partitions	owner	int4
pg_catalog	stl_state_partitions	part_begin	int8
pg_catalog	stl_state_partitions	part_end	int8
pg_catalog	stl_state_partitions	reads	int8
pg_catalog	stl_state_partitions	seek_back	int4
pg_catalog	stl_state_partitions	seek_forward	int4
pg_catalog	stl_state_partitions	timestamp	int8
pg_catalog	stl_state_partitions	tossed	int4
pg_catalog	stl_state_partitions	used	int4
pg_catalog	stl_state_partitions	writes	int8

View Text

SELECT stll_state_partitions.timestamp,
       stll_state_partitions.owner,
       stll_state_partitions.host,
       stll_state_partitions.diskno,
       stll_state_partitions.part_begin,
       stll_state_partitions.part_end,
       stll_state_partitions.used,
       stll_state_partitions.tossed,
       stll_state_partitions.capacity,
       stll_state_partitions.reads,
       stll_state_partitions.writes,
       stll_state_partitions.seek_forward,
       stll_state_partitions.seek_back,
       stll_state_partitions.is_san,
       stll_state_partitions.failed,
       stll_state_partitions.mbps,
       stll_state_partitions.mount
FROM stll_state_partitions

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