Redshift Research Project

System Table Tracker

System view pg_catalog.svv_sem_usage version 1.0.51973 / 2023-06-17

View Text

SELECT stv_sem_usage.name,
       round((CAST(sum(stv_sem_usage.count) AS double precision) / CAST(sum(stv_sem_usage.mutex_requests) AS double precision)) * CAST(100.0 AS double precision),
             CAST(2 AS numeric)) AS miss_ratio,
       sum(stv_sem_usage.count) AS waits,
       sum(stv_sem_usage.mutex_requests) AS requests,
       round(CAST(sum(stv_sem_usage.waiting_time) AS numeric) / 1000000.0,
             3) AS wait_time_sec,
       round(CAST(max(stv_sem_usage.longest) AS numeric) / 1000000.0,
             3) AS longest_sec,
       round((CAST(sum(stv_sem_usage.waiting_time) AS numeric) / 1000.0) / CAST(sum(stv_sem_usage.count) AS numeric),
             2) AS miss_wait_msec,
       round((CAST(sum(stv_sem_usage.waiting_time) AS numeric) / 1000.0) / CAST(sum(stv_sem_usage.mutex_requests) AS numeric),
             3) AS expected_wait_msec
FROM stv_sem_usage
WHERE stv_sem_usage.node < 1000
GROUP BY stv_sem_usage.name
HAVING sum(stv_sem_usage.count) > 0
   AND sum(stv_sem_usage.mutex_requests) > 0
ORDER BY round(CAST(sum(stv_sem_usage.waiting_time) AS numeric) / 1000000.0,
               3) DESC

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