Redshift Observatory

System Table Tracker

System view pg_catalog.stl_compile_info version 1.0.77272 / 2024-11-01

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