Redshift Observatory

System Table Tracker

System view pg_catalog.stl_core_stat version 1.0.51304 / 2023-06-04

schema	name	column	data type
pg_catalog	stl_core_stat	core	int4
pg_catalog	stl_core_stat	currenttime	timestamp
pg_catalog	stl_core_stat	elapsed	int8
pg_catalog	stl_core_stat	idle	int8
pg_catalog	stl_core_stat	iowait	int8
pg_catalog	stl_core_stat	irq	int8
pg_catalog	stl_core_stat	node	int4
pg_catalog	stl_core_stat	ntime	int8
pg_catalog	stl_core_stat	query	int4
pg_catalog	stl_core_stat	sampletime	timestamp
pg_catalog	stl_core_stat	segment	int4
pg_catalog	stl_core_stat	softirq	int8
pg_catalog	stl_core_stat	stime	int8
pg_catalog	stl_core_stat	utime	int8

View Text

SELECT stll_core_stat.currenttime,
       stll_core_stat.sampletime,
       stll_core_stat.query,
       stll_core_stat.segment,
       stll_core_stat.node,
       stll_core_stat.core,
       stll_core_stat.elapsed,
       stll_core_stat.utime,
       stll_core_stat.stime,
       stll_core_stat.ntime,
       stll_core_stat.idle,
       stll_core_stat.iowait,
       stll_core_stat.irq,
       stll_core_stat.softirq
FROM stll_core_stat

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