Redshift Observatory

System Table Tracker

System view pg_catalog.stl_commit_stats version 1.0.70890 / 2024-07-14

schema name column data type
pg_catalog stl_commit_stats batched_by int8
pg_catalog stl_commit_stats dirtyblocks int8
pg_catalog stl_commit_stats endflush timestamp
pg_catalog stl_commit_stats endlocal timestamp
pg_catalog stl_commit_stats endstage timestamp
pg_catalog stl_commit_stats endtime timestamp
pg_catalog stl_commit_stats extwritelatency int8
pg_catalog stl_commit_stats headers int8
pg_catalog stl_commit_stats metadatawritten int4
pg_catalog stl_commit_stats newblocks int8
pg_catalog stl_commit_stats node int4
pg_catalog stl_commit_stats numxids int4
pg_catalog stl_commit_stats oldestxid int8
pg_catalog stl_commit_stats permblocks int8
pg_catalog stl_commit_stats queuelen int8
pg_catalog stl_commit_stats sb_version int8
pg_catalog stl_commit_stats startglobal timestamp
pg_catalog stl_commit_stats startqueue timestamp
pg_catalog stl_commit_stats startwork timestamp
pg_catalog stl_commit_stats tombstonedblocks int8
pg_catalog stl_commit_stats tossedblocks int8
pg_catalog stl_commit_stats xid int8

View Text

SELECT stll_commit_stats.xid,
       stll_commit_stats.node,
       stll_commit_stats.startqueue,
       stll_commit_stats.startwork,
       stll_commit_stats.endflush,
       stll_commit_stats.endstage,
       stll_commit_stats.endlocal,
       stll_commit_stats.startglobal,
       stll_commit_stats.endtime,
       stll_commit_stats.queuelen,
       stll_commit_stats.permblocks,
       stll_commit_stats.newblocks,
       stll_commit_stats.dirtyblocks,
       stll_commit_stats.tombstonedblocks,
       stll_commit_stats.tossedblocks,
       stll_commit_stats.headers,
       stll_commit_stats.numxids,
       stll_commit_stats.oldestxid,
       stll_commit_stats.extwritelatency,
       stll_commit_stats.metadatawritten,
       stll_commit_stats.batched_by,
       stll_commit_stats.sb_version
FROM stll_commit_stats


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