Redshift Observatory

System Table Tracker

System view pg_catalog.stl_perf_histograms version 1.0.47470 / 2023-03-11

schema	name	column	data type
pg_catalog	stl_perf_histograms	hundred_ms	int4
pg_catalog	stl_perf_histograms	hundred_us	int4
pg_catalog	stl_perf_histograms	inf	int4
pg_catalog	stl_perf_histograms	max	float8
pg_catalog	stl_perf_histograms	mean	float8
pg_catalog	stl_perf_histograms	min	float8
pg_catalog	stl_perf_histograms	name	char(64)
pg_catalog	stl_perf_histograms	node	int4
pg_catalog	stl_perf_histograms	now	timestamp
pg_catalog	stl_perf_histograms	one_ms	int4
pg_catalog	stl_perf_histograms	one_s	int4
pg_catalog	stl_perf_histograms	since	timestamp
pg_catalog	stl_perf_histograms	stdev	float8
pg_catalog	stl_perf_histograms	sum	float8
pg_catalog	stl_perf_histograms	ten_ms	int4
pg_catalog	stl_perf_histograms	ten_s	int4
pg_catalog	stl_perf_histograms	ten_us	int4
pg_catalog	stl_perf_histograms	total	int4

View Text

SELECT stll_perf_histograms.now,
       stll_perf_histograms.since,
       stll_perf_histograms.name,
       stll_perf_histograms.mean,
       stll_perf_histograms.stdev,
       stll_perf_histograms.ten_us,
       stll_perf_histograms.hundred_us,
       stll_perf_histograms.one_ms,
       stll_perf_histograms.ten_ms,
       stll_perf_histograms.hundred_ms,
       stll_perf_histograms.one_s,
       stll_perf_histograms.ten_s,
       stll_perf_histograms.inf,
       stll_perf_histograms.min,
       stll_perf_histograms.max,
       stll_perf_histograms.total,
       stll_perf_histograms.sum,
       stll_perf_histograms.node
FROM stll_perf_histograms

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