Redshift Observatory

System Table Tracker

System view pg_catalog.svcs_perf_histograms version 1.0.39278 / 2022-07-23

schema name column data type
pg_catalog svcs_perf_histograms hundred_ms int4
pg_catalog svcs_perf_histograms hundred_us int4
pg_catalog svcs_perf_histograms inf int4
pg_catalog svcs_perf_histograms max float8
pg_catalog svcs_perf_histograms mean float8
pg_catalog svcs_perf_histograms min float8
pg_catalog svcs_perf_histograms name char(64)
pg_catalog svcs_perf_histograms node int4
pg_catalog svcs_perf_histograms now timestamp
pg_catalog svcs_perf_histograms one_ms int4
pg_catalog svcs_perf_histograms one_s int4
pg_catalog svcs_perf_histograms since timestamp
pg_catalog svcs_perf_histograms stdev float8
pg_catalog svcs_perf_histograms sum float8
pg_catalog svcs_perf_histograms ten_ms int4
pg_catalog svcs_perf_histograms ten_s int4
pg_catalog svcs_perf_histograms ten_us int4
pg_catalog svcs_perf_histograms total int4

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