Redshift Research Project

System Table Tracker

System view pg_catalog.stl_proc_stat version 1.0.54239 / 2023-08-04

schema	name	column	data type
pg_catalog	stl_proc_stat	block_faults	int4
pg_catalog	stl_proc_stat	block_reads	int4
pg_catalog	stl_proc_stat	blocks_used	int8
pg_catalog	stl_proc_stat	comm_us	int8
pg_catalog	stl_proc_stat	daemonmemory	int8
pg_catalog	stl_proc_stat	endtime	timestamp
pg_catalog	stl_proc_stat	ipc_us	int8
pg_catalog	stl_proc_stat	lock_us	int8
pg_catalog	stl_proc_stat	max_block_fetchtime	int8
pg_catalog	stl_proc_stat	maxmemory	int8
pg_catalog	stl_proc_stat	max_transblock_fetchtime	int8
pg_catalog	stl_proc_stat	minflt	int8
pg_catalog	stl_proc_stat	pid	int4
pg_catalog	stl_proc_stat	processor	int4
pg_catalog	stl_proc_stat	query	int4
pg_catalog	stl_proc_stat	segment	int4
pg_catalog	stl_proc_stat	slice	int4
pg_catalog	stl_proc_stat	starttime	timestamp
pg_catalog	stl_proc_stat	stime	int8
pg_catalog	stl_proc_stat	tasknum	int4
pg_catalog	stl_proc_stat	total_block_fetchtime	int8
pg_catalog	stl_proc_stat	total_transblock_fetchtime	int8
pg_catalog	stl_proc_stat	transblock_faults	int4
pg_catalog	stl_proc_stat	transblock_reads	int4
pg_catalog	stl_proc_stat	utime	int8

View Text

SELECT stll_proc_stat.pid,
       stll_proc_stat.query,
       stll_proc_stat.slice,
       stll_proc_stat.segment,
       stll_proc_stat.starttime,
       stll_proc_stat.endtime,
       stll_proc_stat.tasknum,
       stll_proc_stat.utime,
       stll_proc_stat.stime,
       stll_proc_stat.processor,
       stll_proc_stat.minflt,
       stll_proc_stat.maxmemory,
       stll_proc_stat.daemonmemory,
       stll_proc_stat.block_reads,
       stll_proc_stat.block_faults,
       stll_proc_stat.total_block_fetchtime,
       stll_proc_stat.max_block_fetchtime,
       stll_proc_stat.transblock_reads,
       stll_proc_stat.transblock_faults,
       stll_proc_stat.total_transblock_fetchtime,
       stll_proc_stat.max_transblock_fetchtime,
       stll_proc_stat.blocks_used,
       stll_proc_stat.comm_us,
       stll_proc_stat.lock_us,
       stll_proc_stat.ipc_us
FROM stll_proc_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