Redshift Observatory

System Table Tracker

System view pg_catalog.stl_bkg_compile_info version 1.0.67699 / 2024-05-26

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

View Text

SELECT stll_bkg_compile_info.userid,
       stll_bkg_compile_info.xid,
       stll_bkg_compile_info.pid,
       stll_bkg_compile_info.query,
       stll_bkg_compile_info.segment,
       stll_bkg_compile_info.locus,
       stll_bkg_compile_info.starttime,
       stll_bkg_compile_info.endtime,
       stll_bkg_compile_info.bytes,
       stll_bkg_compile_info.path,
       stll_bkg_compile_info.compile,
       stll_bkg_compile_info.complevel,
       stll_bkg_compile_info.cachehit,
       stll_bkg_compile_info.tokwaittime,
       stll_bkg_compile_info.compilestarttime,
       stll_bkg_compile_info.compileendtime,
       stll_bkg_compile_info.compilelocktime,
       stll_bkg_compile_info.compilememory,
       stll_bkg_compile_info.putsuccess,
       stll_bkg_compile_info.getsuccess,
       stll_bkg_compile_info.puttime,
       stll_bkg_compile_info.gettime,
       stll_bkg_compile_info.objsize,
       stll_bkg_compile_info.skip_opt_compile,
       stll_bkg_compile_info.cachehit_name
FROM stll_bkg_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