Redshift Observatory

System Table Tracker

System view pg_catalog.stl_prefetch_stats version 1.0.52931 / 2023-07-07

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