Redshift Observatory

System Table Tracker

System view pg_catalog.stl_commit_stats version 1.0.45698 / 2023-01-27

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	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
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