Redshift Observatory

System Table Tracker

System view pg_catalog.svcs_perf_histograms version 1.0.40677 / 2022-08-14

View Text

SELECT CAST('1970-01-01 00:00:00' AS timestamp) + (CAST((CAST(stcs_perf_histograms.now AS numeric) / (1000.0 * 1000.0)) + 946684800.0 AS double precision) * CAST('00:00:01' AS interval)) AS now,
       CAST('1970-01-01 00:00:00' AS timestamp) + (CAST((CAST(stcs_perf_histograms.since AS numeric) / (1000.0 * 1000.0)) + 946684800.0 AS double precision) * CAST('00:00:01' AS interval)) AS since,
       stcs_perf_histograms.name,
       stcs_perf_histograms.mean,
       stcs_perf_histograms.stdev,
       stcs_perf_histograms.ten_us,
       stcs_perf_histograms.hundred_us,
       stcs_perf_histograms.one_ms,
       stcs_perf_histograms.ten_ms,
       stcs_perf_histograms.hundred_ms,
       stcs_perf_histograms.one_s,
       stcs_perf_histograms.ten_s,
       stcs_perf_histograms.inf,
       stcs_perf_histograms.min,
       stcs_perf_histograms.max,
       stcs_perf_histograms.total,
       stcs_perf_histograms.sum,
       stcs_perf_histograms.node
FROM stcs_perf_histograms

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