Redshift Observatory

System Table Tracker

System view pg_catalog.stl_proc_stat version 1.0.54899 / 2023-08-15

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