Redshift Observatory

System Table Tracker

System view pg_catalog.stl_prefetch_stats version 1.0.48714 / 2023-04-06

schema	name	column	data type
pg_catalog	stl_prefetch_stats	columnid	int8
pg_catalog	stl_prefetch_stats	eventtime	timestamp
pg_catalog	stl_prefetch_stats	node	int4
pg_catalog	stl_prefetch_stats	numprefetches	int8
pg_catalog	stl_prefetch_stats	pid	int4
pg_catalog	stl_prefetch_stats	query	int4
pg_catalog	stl_prefetch_stats	tableid	int8

View Text

SELECT stll_prefetch_stats.eventtime,
       stll_prefetch_stats.node,
       stll_prefetch_stats.pid,
       stll_prefetch_stats.query,
       stll_prefetch_stats.tableid,
       stll_prefetch_stats.columnid,
       stll_prefetch_stats.numprefetches
FROM stll_prefetch_stats

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers