Redshift Observatory

System Table Tracker

System view pg_catalog.stl_compile_info version 1.0.69451 / 2024-06-27

schema	name	column	data type
pg_catalog	stl_compile_info	bytes	int8
pg_catalog	stl_compile_info	cachehit	int4
pg_catalog	stl_compile_info	cachehit_name	char(40)
pg_catalog	stl_compile_info	compile	int4
pg_catalog	stl_compile_info	compileendtime	timestamp
pg_catalog	stl_compile_info	compilelocktime	int8
pg_catalog	stl_compile_info	compilememory	int8
pg_catalog	stl_compile_info	compilestarttime	timestamp
pg_catalog	stl_compile_info	complevel	int4
pg_catalog	stl_compile_info	endtime	timestamp
pg_catalog	stl_compile_info	getsuccess	int4
pg_catalog	stl_compile_info	gettime	int8
pg_catalog	stl_compile_info	locus	int4
pg_catalog	stl_compile_info	objsize	int8
pg_catalog	stl_compile_info	path	char(255)
pg_catalog	stl_compile_info	pid	int4
pg_catalog	stl_compile_info	query	int4
pg_catalog	stl_compile_info	replace_obj_status	int4
pg_catalog	stl_compile_info	segment	int4
pg_catalog	stl_compile_info	skip_opt_compile	int4
pg_catalog	stl_compile_info	starttime	timestamp
pg_catalog	stl_compile_info	tokwaittime	int8
pg_catalog	stl_compile_info	userid	int4
pg_catalog	stl_compile_info	xid	int8

View Text

SELECT stll_compile_info.userid,
       stll_compile_info.xid,
       stll_compile_info.pid,
       stll_compile_info.query,
       stll_compile_info.segment,
       stll_compile_info.locus,
       stll_compile_info.starttime,
       stll_compile_info.endtime,
       stll_compile_info.bytes,
       stll_compile_info.path,
       stll_compile_info.compile,
       stll_compile_info.complevel,
       stll_compile_info.cachehit,
       stll_compile_info.tokwaittime,
       stll_compile_info.compilestarttime,
       stll_compile_info.compileendtime,
       stll_compile_info.compilelocktime,
       stll_compile_info.compilememory,
       stll_compile_info.getsuccess,
       stll_compile_info.gettime,
       stll_compile_info.objsize,
       stll_compile_info.skip_opt_compile,
       stll_compile_info.replace_obj_status,
       stll_compile_info.cachehit_name
FROM stll_compile_info

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