Redshift Observatory

System Table Tracker

System view pg_catalog.stl_compile_service version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	stl_compile_service	bytes	int8
pg_catalog	stl_compile_service	locus	int4
pg_catalog	stl_compile_service	lookupendtime	timestamp
pg_catalog	stl_compile_service	lookupstarttime	timestamp
pg_catalog	stl_compile_service	lookupsuccess	int4
pg_catalog	stl_compile_service	path	char(255)
pg_catalog	stl_compile_service	pid	int4
pg_catalog	stl_compile_service	putendtime	timestamp
pg_catalog	stl_compile_service	putstarttime	timestamp
pg_catalog	stl_compile_service	putsuccess	int4
pg_catalog	stl_compile_service	query	int4
pg_catalog	stl_compile_service	segment	int4
pg_catalog	stl_compile_service	userid	int4
pg_catalog	stl_compile_service	xid	int8

View Text

SELECT stll_compile_service.userid,
       stll_compile_service.xid,
       stll_compile_service.pid,
       stll_compile_service.query,
       stll_compile_service.segment,
       stll_compile_service.locus,
       stll_compile_service.bytes,
       stll_compile_service.path,
       stll_compile_service.lookupstarttime,
       stll_compile_service.lookupendtime,
       stll_compile_service.lookupsuccess,
       stll_compile_service.putstarttime,
       stll_compile_service.putendtime,
       stll_compile_service.putsuccess
FROM stll_compile_service

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