{"draftJsState":{"blocks":[{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"pgpro_tune - КОМПЛЕКСНЫЙ КОРРЕЛЯЦИОННЫЙ АНАЛИЗ СУБД и VMSTAT","type":"unstyled","key":"41jvf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-------------------------------------------------------------------------","type":"unstyled","key":"57ea1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1. СТАТИСТИЧЕСКИЙ АНАЛИЗ ОЖИДАНИЙ СУБД","type":"unstyled","key":"3hovg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-14 09:56","type":"unstyled","key":"cfmpi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-14 12:18","type":"unstyled","key":"ek6s1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ГРАНИЧНЫЕ ЗНАЧЕНИЯ И МЕДИАНА|№|SPEED |WAITINGS|BUFFERPIN |EXTENSION |IO |IPC |LOCK |LWLOCK |TIMEOUT |","type":"unstyled","key":"25g95"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MIN|1| 000000381424,0000| 000000049576,0000| 000000000000,0000| 000000000000,0000| 000000049564,0000| 000000000001,0000| 000000000004,0000| 000000000002,0000| 000000000003,0000|","type":"unstyled","key":"f52cd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MEDIAN| | 000000433329,0000| 000000079295,0000| 000000000000,0000| 000000000000,0000| 000000079271,0000| 000000000002,0000| 000000000010,0000| 000000000005,0000| 000000000007,0000|","type":"unstyled","key":"eh2j0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MAX|143| 000000700915,0000| 000000225664,0000| 000000000000,0000| 000000000000,0000| 000000225366,0000| 000000000014,0000| 000000000141,0000| 000000000089,0000| 000000000055,0000|","type":"unstyled","key":"jjm0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1 ЛИНИЯ ТРЕНДА ОПЕРАЦИОННОЙ СКОРОСТИ","type":"unstyled","key":"a2sls"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ПО ЛИНИИ РЕГРЕССИИ вида : Y = a + bt ; ГДЕ t - точка наблюдения.","type":"unstyled","key":"bgsh2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,8500","type":"unstyled","key":"cc20j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000042,7300","type":"unstyled","key":"h471"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"1v55g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"6977h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"8fnvu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.2 ЛИНИЯ ТРЕНДА ОЖИДАНИЙ СУБД","type":"unstyled","key":"4ilal"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ПО ЛИНИИ РЕГРЕССИИ вида : Y = a + bt ; ГДЕ t - точка наблюдения.","type":"unstyled","key":"8guon"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,8800","type":"unstyled","key":"9l587"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000043,2300","type":"unstyled","key":"eip9u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"7hdi2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"d6rp1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"f8467"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.3 РЕГРЕССИЯ ОПЕРАЦИОННОЙ СКОРОСТИ(Y) по ОЖИДАНИЯМ(X) СУБД","type":"unstyled","key":"bbnj6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЛИНИЯ РЕГРЕССИИ вида : Y = a + bX","type":"unstyled","key":"21h4r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9900","type":"unstyled","key":"7ive6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000044,8300","type":"unstyled","key":"b3t4r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"3bnla"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"af0ru"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"5o83a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2. КОРРЕЛЯЦИЯ: ОПЕРАЦИОННАЯ СКОРОСТЬ - ОЖИДАНИЯ СУБД","type":"unstyled","key":"698a4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Положительная или отсутствует","type":"unstyled","key":"c23vq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3. КОМПЛЕКСНЫЙ АНАЛИЗ ПО ТИПАМ ОЖИДАНИЙ(wait_event_type)","type":"unstyled","key":"bqm5p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.1 BufferPin","type":"unstyled","key":"eaqmo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"6s5m3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"uqic"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.2 Extension","type":"unstyled","key":"3sjv5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"1acg2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"2ldlv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.3 IO","type":"unstyled","key":"a32bl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"917q4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000001,0000","type":"unstyled","key":"1m77c"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"9qrgu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"fotfq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация ВКО.","type":"unstyled","key":"d8h97"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВЗВЕШЕННАЯ КОРРЕЛЯЦИЯ ОЖИДАНИЙ(ВКО):| 000000000001,0000|","type":"unstyled","key":"1bfav"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КРИТИЧЕСКОЕ ЗНАЧЕНИЕ : Немедленный анализ и действие. Основной фокус расследования.","type":"unstyled","key":"3stl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 3. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"5oean"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ ОЖИДАНИЯ СУБД(Y) ПО ОЖИДАНИЯМ ТИПА IO(X)","type":"unstyled","key":"adfa5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000001,0000","type":"unstyled","key":"8is80"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000045,0000","type":"unstyled","key":"eevp4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"9lgi6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"5ikqn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"8i501"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕКОМЕНДУЕМЫЕ ДЕЙСТВИЯ:","type":"unstyled","key":"fe3qs"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Анализ и оптимизация топ-запросов по времени ожидания IO","type":"unstyled","key":"3f4f0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Проверка и оптимизация индексов (добавление недостающих, удаление неиспользуемых)","type":"unstyled","key":"6nqlu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Настройка параметров effective_io_concurrency и random_page_cost для используемого оборудования","type":"unstyled","key":"7o507"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.4 IPC","type":"unstyled","key":"elnsi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"ar0p0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9522","type":"unstyled","key":"edr2q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"f0tmh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"4q3fm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация ВКО.","type":"unstyled","key":"ahcsq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВЗВЕШЕННАЯ КОРРЕЛЯЦИЯ ОЖИДАНИЙ(ВКО):| 000000000000,0000|","type":"unstyled","key":"3b9bp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВКО < 0.01 : Игнорировать в текущем анализе.","type":"unstyled","key":"ajio6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.5 Lock","type":"unstyled","key":"d8ol0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"4bpi9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9237","type":"unstyled","key":"7lmom"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"42gdp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"6gsnf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация ВКО.","type":"unstyled","key":"f91ua"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВЗВЕШЕННАЯ КОРРЕЛЯЦИЯ ОЖИДАНИЙ(ВКО):| 000000000000,0000|","type":"unstyled","key":"2l9i2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВКО < 0.01 : Игнорировать в текущем анализе.","type":"unstyled","key":"6p3sk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.6 LWLock","type":"unstyled","key":"erreu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"c7t8p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9308","type":"unstyled","key":"3t6s3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"4jaj7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"37lip"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация ВКО.","type":"unstyled","key":"557eu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВЗВЕШЕННАЯ КОРРЕЛЯЦИЯ ОЖИДАНИЙ(ВКО):| 000000000000,0000|","type":"unstyled","key":"84cg2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВКО < 0.01 : Игнорировать в текущем анализе.","type":"unstyled","key":"4qfop"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.7 Timeout","type":"unstyled","key":"1g5cc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"94sfi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9810","type":"unstyled","key":"7g5gu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"aq39g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"d8o53"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация ВКО.","type":"unstyled","key":"7i12t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВЗВЕШЕННАЯ КОРРЕЛЯЦИЯ ОЖИДАНИЙ(ВКО):| 000000000000,0000|","type":"unstyled","key":"d3a5p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВКО < 0.01 : Игнорировать в текущем анализе.","type":"unstyled","key":"de4f4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕЗУЛЬТАТ ОТЧЕТА: ИНТЕГРАЛЬНЫЙ ПРИОРИТЕТ ТИПА ОЖИДАНИЯ","type":"unstyled","key":"dsv2t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"№ | WAIT_EVENT_TYPE | ПРИОРИТЕТ","type":"unstyled","key":"4a55"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1|IO| 000000000000,6271","type":"unstyled","key":"8rust"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-------------------------------------------------------------------------","type":"unstyled","key":"548hg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.ТРЕНДОВЫЙ АНАЛИЗ ПРОИЗВОДИТЕЛЬНОСТИ vmstat","type":"unstyled","key":"2d85q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-14 09:56","type":"unstyled","key":"bkp13"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-14 12:18","type":"unstyled","key":"ce3sk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ГРАНИЧНЫЕ ЗНАЧЕНИЯ И МЕДИАНА|№|procs -> r |procs -> b|cpu -> wa|cpu -> id|","type":"unstyled","key":"pfdq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MIN|1| 000000000001,0000| 000000000009,0000| 000000000063,0000| 000000000001,0000|","type":"unstyled","key":"bb5j1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MEDIAN| | 000000000002,0000| 000000000014,0000| 000000000068,0000| 000000000012,0000|","type":"unstyled","key":"cgbbt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MAX|143| 000000000003,0000| 000000000042,0000| 000000000072,0000| 000000000019,0000|","type":"unstyled","key":"crocr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"procs -> r: Количество процессов в очереди на выполнение.","type":"unstyled","key":"eq05m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"procs -> b: Количество процессов, находящихся в состоянии","type":"unstyled","key":"8fnlh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"непрерываемого сна (обычно ожидание IO).","type":"unstyled","key":"72ntq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Рост b — прямой признак того, что процессы не могут продолжить работу.","type":"unstyled","key":"9065d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"cpu -> wa: Процент простоя CPU в ожидании IO.","type":"unstyled","key":"j3ap"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"cpu -> id: Процент полного простоя CPU","type":"unstyled","key":"q53c"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"(если id низкий, а ожиданий много —","type":"unstyled","key":"biuu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"значит CPU занят обработкой других задач или переключениями).","type":"unstyled","key":"9vnhc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"procs -> r: Количество процессов в очереди на выполнение","type":"unstyled","key":"4vqu3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЛИНИЯ РЕГРЕССИИ по t: Y = a + bt","type":"unstyled","key":"2n13b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,7500","type":"unstyled","key":"3hkc3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000040,8600","type":"unstyled","key":"9c98d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Хорошее.","type":"unstyled","key":"fldgj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет от 60% до 80% вариации.","type":"unstyled","key":"8s5lr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Достоверная и практически полезная модель.","type":"unstyled","key":"6t036"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Негативный тренд (ухудшение)","type":"unstyled","key":"fqeji"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициента Тренда | 000000000030,5900","type":"unstyled","key":"dpich"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Очень высокая скорость изменения при отличной объясняющей способности модели (R2>0,8).","type":"unstyled","key":"fmcuc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Значения редко встречаются и указывают на серьёзные проблемы.","type":"unstyled","key":"3g7t3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Создать инцидент, привлечь экспертов.","type":"unstyled","key":"9oi5o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕКОМЕНДУЕМЫЕ МЕРОПРИЯТИЯ","type":"unstyled","key":"diqm8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Проверить загрузку процессора, выявить процессы-потребители, проанализировать планировщик.","type":"unstyled","key":"99big"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"procs -> b: Количество процессов, находящихся в состоянии","type":"unstyled","key":"rqjj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"непрерываемого сна (обычно ожидание IO).","type":"unstyled","key":"5srp4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЛИНИЯ РЕГРЕССИИ по t: Y = a + bt","type":"unstyled","key":"9h102"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,8700","type":"unstyled","key":"brt1k"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000042,9600","type":"unstyled","key":"7c288"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"9umpn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"5kshg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"1r6cq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Негативный тренд (ухудшение)","type":"unstyled","key":"42dt6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициента Тренда | 000000000037,2500","type":"unstyled","key":"76pc2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Очень высокая скорость изменения при отличной объясняющей способности модели (R2>0,8).","type":"unstyled","key":"ci6kv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Значения редко встречаются и указывают на серьёзные проблемы.","type":"unstyled","key":"7ubvv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Создать инцидент, привлечь экспертов.","type":"unstyled","key":"14sbr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕКОМЕНДУЕМЫЕ МЕРОПРИЯТИЯ","type":"unstyled","key":"4asc0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Исследовать дисковую подсистему (iostat, iotop), проверить наличие медленных устройств, конфликтов ввода-вывода.","type":"unstyled","key":"6qlgk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"cpu -> wa: Процент простоя CPU в ожидании IO.","type":"unstyled","key":"b8gjt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЛИНИЯ РЕГРЕССИИ по t: Y = a + bt","type":"unstyled","key":"rff1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,1300","type":"unstyled","key":"3hcbb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000019,6000","type":"unstyled","key":"ft7d9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Неудовлетворительное.","type":"unstyled","key":"j8v7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет менее 20% (вплоть до 0%) вариации.","type":"unstyled","key":"825ne"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Модель бесполезна. Коэффициенты, даже если они значимы,","type":"unstyled","key":"ab127"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Негативный тренд (ухудшение)","type":"unstyled","key":"42eu0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициента Тренда | 000000000002,4800","type":"unstyled","key":"emo5f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шум или статистически незначимые изменения","type":"unstyled","key":"4rd4i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Игнорировать либо учитывать в долгосрочной статистике без оперативных действий.","type":"unstyled","key":"c8k4i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"cpu -> id: Процент полного простоя CPU.","type":"unstyled","key":"2rrll"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЛИНИЯ РЕГРЕССИИ по t: Y = a + bt","type":"unstyled","key":"bdu5a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9600","type":"unstyled","key":"92kkr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона |-000000000044,4500","type":"unstyled","key":"euil"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"1en7m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"a6r92"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"31v66"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Негативный тренд (ухудшение)","type":"unstyled","key":"9gcf0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициента Тренда | 000000000042,7600","type":"unstyled","key":"f7vrf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Очень высокая скорость изменения при отличной объясняющей способности модели (R2>0,8).","type":"unstyled","key":"boppl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Значения редко встречаются и указывают на серьёзные проблемы.","type":"unstyled","key":"fql6m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Создать инцидент, привлечь экспертов.","type":"unstyled","key":"37r1s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕКОМЕНДУЕМЫЕ МЕРОПРИЯТИЯ","type":"unstyled","key":"a96cr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Проверить, не связано ли с уменьшением полезной работы.","type":"unstyled","key":"7ah4g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-------------------------------------------------------------------------","type":"unstyled","key":"a58u2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3. СТАТИСТИЧЕСКИЙ АНАЛИЗ ОЖИДАНИЙ СУБД и МЕТРИК vmstat","type":"unstyled","key":"38g1p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-14 09:56","type":"unstyled","key":"cik0f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-14 12:18","type":"unstyled","key":"6m62d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"CPU = 8","type":"unstyled","key":"6u69i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"RAM =7.497(GB)","type":"unstyled","key":"54o7j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ГРАНИЧНЫЕ ЗНАЧЕНИЯ И МЕДИАНА|№|procs_r|procs_b |memory_swpd |memory_free |memory_buff |memory_cache |swap_si |swap_so |io_bi |io_bo |system_in |system_cs |cpu_us |cpu_sy |cpu_id |cpu_wa |cpu_st |","type":"unstyled","key":"eui5n"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MIN|1| 000000000001,0000| 000000000009,0000| 000000000176,0000| 000000000178,0000| 000000000057,0000| 000000006383,0000| 000000000000,0000| 000000000000,0000| 000000027692,0000| 000000018624,0000| 000000021132,0000| 000000030977,0000| 000000000010,0000| 000000000006,0000| 000000000001,0000| 000000000063,0000| 000000000000,0000|","type":"unstyled","key":"80d8e"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MEDIAN| | 000000000002,0000| 000000000014,0000| 000000000176,0000| 000000000180,0000| 000000000106,0000| 000000006689,0000| 000000000000,0000| 000000000000,0000| 000000028625,0000| 000000020169,0000| 000000021941,0000| 000000032995,0000| 000000000012,0000| 000000000006,0000| 000000000012,0000| 000000000068,0000| 000000000000,0000|","type":"unstyled","key":"9s6rf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MAX|143| 000000000003,0000| 000000000042,0000| 000000000176,0000| 000000000183,0000| 000000000162,0000| 000000006791,0000| 000000000000,0000| 000000000000,0000| 000000032045,0000| 000000027664,0000| 000000030661,0000| 000000047774,0000| 000000000022,0000| 000000000009,0000| 000000000019,0000| 000000000072,0000| 000000000000,0000|","type":"unstyled","key":"1gg6a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОТНОСИТЕЛЬНЫЕ ПОКАЗАТЕЛИ vmstat","type":"unstyled","key":"a7f8a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"us(user time) + sy(system time) (% свыше 80%) | 000000000000,0000","type":"unstyled","key":"br469"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"OK: менее 25% тестового периода","type":"unstyled","key":"fromf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"r — процессы в run queue (готовы к выполнению): % превышения ядер CPU | 000000000000,0000","type":"unstyled","key":"d6pjm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"OK: менее 25% тестового периода - очередь процессов превышает количество ядер CPU","type":"unstyled","key":"a4f02"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"sy — system time: % превышение 30% | 000000000000,0000","type":"unstyled","key":"bfnvc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"OK: менее 25% тестового периода - доля system time превышает 30%","type":"unstyled","key":"7bbvq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"free — свободная RAM (% менее 5%) | 000000000100,0000","type":"unstyled","key":"ba0mr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM: более 50% тестового периода - свободная RAM менее 5%","type":"unstyled","key":"aatid"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"swap in (% тестового периода) | 000000000000,0000","type":"unstyled","key":"rsc8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОК : Свопинг в RAM не используется","type":"unstyled","key":"4u0m7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"swap out (% тестового периода) | 000000000000,0000","type":"unstyled","key":"217ef"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОК : Свопинг из RAM не используется","type":"unstyled","key":"c7ecc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"wa(ожидание IO) свыше 10% | 000000000100,0000","type":"unstyled","key":"9ngo2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM: более 50% тестового периода - wa > 10%","type":"unstyled","key":"e0kug"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"b(процессы в uninterruptible sleep): % превышения ядер CPU | 000000000100,0000","type":"unstyled","key":"5e2si"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM: более 50% тестового периода - b(процессы в uninterruptible sleep) превышает количество ядер CPU","type":"unstyled","key":"d9ihc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЧАСТЬ-1. АНАЛИЗ ОЖИДАНИЙ СУБД и МЕТРИК vmstat","type":"unstyled","key":"du7jg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1. IO(ИНТЕГРАЛЬНЫЙ ПРИОРИТЕТ) | 000000000000,6271","type":"unstyled","key":"b4o6j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ПРИРОДА ОЖИДАНИЯ: Процесс ждет завершения операции ввода-вывода","type":"unstyled","key":"6fbin"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"(чтения страницы с диска или записи на диск). Наиболее \"дисковый\" тип ожидания.","type":"unstyled","key":"8cc8f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Наиболее \"дисковый\" тип ожидания.","type":"unstyled","key":"bl4ki"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1.1. Корреляция: IO и bi(блоки, считанные с устройств)","type":"unstyled","key":"f8qqb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"4j6g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,2794","type":"unstyled","key":"ekiem"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"5evjg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"6olte"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"СЛАБАЯ ИЛИ СРЕДНЯЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"83e3r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"addpp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"83pbe"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1.2. Корреляция: IO и bo(блоки, записанные на устройства)","type":"unstyled","key":"coe56"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"fb01f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,8752","type":"unstyled","key":"765cr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"7pv15"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"1pdm4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"b8gsc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"50got"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ IO(Y) ПО bo(блоки, записанные на устройства)(X)","type":"unstyled","key":"33tbj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,7700","type":"unstyled","key":"1f0n9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000041,1900","type":"unstyled","key":"34pkf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Хорошее.","type":"unstyled","key":"8qnsc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет от 60% до 80% вариации.","type":"unstyled","key":"8865f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Достоверная и практически полезная модель.","type":"unstyled","key":"7vhco"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"*INFO: Указывает на сброс \"грязных\" страниц (checkpointer, bgwriter).","type":"unstyled","key":"e760g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1.3. Корреляция: IO и wa(ожидание IO)","type":"unstyled","key":"73q3u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"813ek"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,0706","type":"unstyled","key":"89umj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Незначима","type":"unstyled","key":"8452d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Незначима","type":"unstyled","key":"5v0g1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"СЛАБАЯ ИЛИ СРЕДНЯЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"d7fps"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"c3ce2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЧАСТЬ-2. АНАЛИЗ МЕТРИК vmstat","type":"unstyled","key":"f4g62"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.1. Корреляция cs(переключения контекста) и in(прерывания)","type":"unstyled","key":"40jve"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"4fb6c"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9962","type":"unstyled","key":"d5bfj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"8gl9v"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"65n92"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"blu60"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"dqstk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ cs(переключения контекста)(Y) ПО in(прерывания)(X)","type":"unstyled","key":"fmu8i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9900","type":"unstyled","key":"251fa"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000044,8900","type":"unstyled","key":"1it4a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"2mqck"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"anf8b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"4ktg4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"*INFO: Переключения контекста могут быть вызваны прерываниями.","type":"unstyled","key":"bmnf9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.2. Корреляция cs(переключения контекста) и us(user time)","type":"unstyled","key":"auk7c"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"1ps8q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9936","type":"unstyled","key":"2qlv7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"47quq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"38u62"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"eft4g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"70dti"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ cs(переключения контекста)(Y) ПО us(user time)(X)","type":"unstyled","key":"82d7r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9900","type":"unstyled","key":"69ifj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000044,8100","type":"unstyled","key":"2johm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"6f9b1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"vgk1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"basaa"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"*INFO: Возможно проблема в пользовательском приложении(resource contention).","type":"unstyled","key":"ehud0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.3. Корреляция cs(переключения контекста) и sy(system time)","type":"unstyled","key":"994i6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"973rl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9539","type":"unstyled","key":"e27o9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"6f5ul"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"kn99"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"dmbkp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"98v6d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ cs(переключения контекста)(Y) ПО sy(system time)(X)","type":"unstyled","key":"ah6a6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9100","type":"unstyled","key":"4losb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000043,6500","type":"unstyled","key":"2te5j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"dno34"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"4u8ba"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"bhd29"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"*INFO: Ядро тратит много времени на переключение контекста и планирование,","type":"unstyled","key":"csc2i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"вместо полезной работы.","type":"unstyled","key":"8g6ve"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЧАСТЬ-3. АНАЛИЗ IO","type":"unstyled","key":"adh73"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.1. Отношение прочитанных блоков shared_buffers","type":"unstyled","key":"87g52"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Эмпирические ориентиры","type":"unstyled","key":"am0ol"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"для оценки типа нагрузки(OLAP/OLTP):","type":"unstyled","key":"30jv6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"OLTP сценарий.","type":"unstyled","key":"eeb7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.2. SHARED_BUFFERS HIT RATIO | MIN | MEDIAN | MAX |","type":"unstyled","key":"brr5h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"INFO: приемлемо для OLAP, особенно при работе с большими таблицами | 000000000096,1780| 000000000096,7979| 000000000098,5116|","type":"unstyled","key":"b65em"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.3. Корреляция: операционная скорость и прочитанные блоки","type":"unstyled","key":"bk3j1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"d5937"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"aue9d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"14k7u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"epj59"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"INFO : Слабая корреляция.","type":"unstyled","key":"6olh5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.4. Корреляция: операционная скорость и записанные блоки","type":"unstyled","key":"a5jhc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"dvkbv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,2619","type":"unstyled","key":"5qvma"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"9c1fg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"3db9j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"СЛАБАЯ ИЛИ СРЕДНЯЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"1q4h0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"19aua"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"6b6em"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"INFO : Слабая корреляция.","type":"unstyled","key":"8tnqp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.5. Корреляция: shared_buffers hit и прочитанные блоки","type":"unstyled","key":"6g3sr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"911pr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: |-000000000000,9831","type":"unstyled","key":"fjphm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"3fen4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"j2i5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"8pk76"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"41f3b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ shared_buffers hit(Y) ПО прочитанные блоки(X)","type":"unstyled","key":"crqii"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9700","type":"unstyled","key":"fute1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона |-000000000044,5100","type":"unstyled","key":"4l06n"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"b99kr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"6qcsi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"ep3lf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"OK : Эффективное кэширование.","type":"unstyled","key":"ac41j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Высокая предсказуемость.","type":"unstyled","key":"41bbq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Когда нагрузка попадает в кэш, это реально снижает дисковую нагрузку.","type":"unstyled","key":"9h2fu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.6. Корреляция: прочитанные блоки и swap in","type":"unstyled","key":"4ob7k"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"5kdu5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"3h5ac"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"seng"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"e03eg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.7. Корреляция: грязные блоки и bo(блоки записанные на устройства)","type":"unstyled","key":"1ugpk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"29psl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"8jel6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"1ll86"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"ao36r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.8. Корреляция: записанные блоки и bo(блоки записанные на устройства)","type":"unstyled","key":"du9d7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"7k70u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9045","type":"unstyled","key":"an0dn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"ppfb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"fbc2d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"6m2du"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"1bnj7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ записанные блоки(Y) ПО bo(блоки записанные на устройства)(X)","type":"unstyled","key":"b5lba"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,8200","type":"unstyled","key":"7lgcj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000042,1300","type":"unstyled","key":"llk7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"1vrd2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"62l0k"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"3tsbs"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM","type":"unstyled","key":"ba8r6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Возможна чрезмерная агрессивная запись.","type":"unstyled","key":"99sfq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.9. Корреляция: hit и us(user time)","type":"unstyled","key":"bb54j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"eogl9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Положительная или отсутствует","type":"unstyled","key":"bge6a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"6avgp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"87f1j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.10. Корреляция: hit и sy(system time)","type":"unstyled","key":"b4rjq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"cbkfn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Положительная или отсутствует","type":"unstyled","key":"42eti"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"76p9r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"au0al"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.11. Корреляция: грязные блоки и wa(ожидание IO)","type":"unstyled","key":"7780s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"6rvek"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"4c39b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"9mgd1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"454ov"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Часть-4. СТАТИСТИКА VM_DIRTY*","type":"unstyled","key":"1av3q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"dirty_kb/dirty_ratio/dirty_background_ratio | MIN | MEDIAN | MAX |","type":"unstyled","key":"89ona"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"dirty pages size (KB) | 000000005624,0000| 000000007086,0000| 000000017954,0000|","type":"unstyled","key":"84cm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"dirty_ratio | 000000000000,0000| 000000000000,0000| 000000000001,0000|","type":"unstyled","key":"8t1l5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"dirty_bg_percent | 000000000001,0000| 000000000001,0000| 000000000003,0000|","type":"unstyled","key":"eplso"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"available_mem_mb | 000000004447,0000| 000000004679,0000| 000000004720,5000|","type":"unstyled","key":"o4n8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.1. Корреляция: dirty pages size(KB) и so(swap-out)","type":"unstyled","key":"76vgf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"1j7uf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"56s0l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"90qv0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"a2okp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.2. Корреляция: dirty pages size(KB) и wa(ожидание IO)","type":"unstyled","key":"r3t2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"2rtr6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"9vlf9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"7ue7i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"euqnv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.3. Корреляция: dirty pages size(KB) и b(процессы в uninterruptible sleep)","type":"unstyled","key":"e9c1f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"njmq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9943","type":"unstyled","key":"aq2ol"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"erpf5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"ev7d7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"1bhq0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"evjsj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ dirty pages size(KB)(Y) ПО b(процессы в uninterruptible sleep)(X)","type":"unstyled","key":"84m7c"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9900","type":"unstyled","key":"foqd3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000044,8400","type":"unstyled","key":"78hp4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"ba36v"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"c1iud"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"ifqs"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM","type":"unstyled","key":"43min"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Процессы СУБД (например, backend-процессы) массово блокируются в состоянии I/O wait.","type":"unstyled","key":"6mhpg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Подтверждает корреляцию с wa и требует настройки vm.dirty_* параметров и/или улучшения дисков.","type":"unstyled","key":"dqoou"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Очередь процессов в состоянии b указывает на системный I/O bottleneck.","type":"unstyled","key":"392p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.4. Корреляция: dirty pages size (KB) и free(свободная RAM)","type":"unstyled","key":"75lbt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"22cuo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Положительная или отсутствует","type":"unstyled","key":"6j53d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"27plt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"pa80"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.5. Корреляция: dirty pages size(KB) и bo(блоки записанные на устройства)","type":"unstyled","key":"fh8ar"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"5gt5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9063","type":"unstyled","key":"14qja"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"1jt6o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"fi170"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"cobq6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"9kt1l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ dirty pages size(KB)(Y) ПО bo(блоки записанные на устройства)(X)","type":"unstyled","key":"4jdnm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,8200","type":"unstyled","key":"acfgi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000042,1900","type":"unstyled","key":"ei7l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"coeqr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"ft244"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"7v7gl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM","type":"unstyled","key":"3d0h6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Механизм обратной записи не успевает за генерацией dirty pages.","type":"unstyled","key":"a4gfg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Это может быть как из-за медленного диска, так и из-за агрессивной работы приложения.","type":"unstyled","key":"13jcn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.6. Корреляция: dirty pages size(KB) и sy(system time)","type":"unstyled","key":"4t021"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"739if"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9506","type":"unstyled","key":"baeuo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"b62uq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"119ut"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"4q3tt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"8a702"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ dirty pages size(KB)(Y) ПО sy(system time)(X)","type":"unstyled","key":"8g6vl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9000","type":"unstyled","key":"a8k5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000043,5500","type":"unstyled","key":"2pp3e"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"fp997"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"30b35"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"7csei"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM","type":"unstyled","key":"f2ii6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Высокие накладные расходы ядра ОС","type":"unstyled","key":"7h018"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"на управление памятью и операциями ввода-вывода.","type":"unstyled","key":"au8cp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Ядро тратит значительное время","type":"unstyled","key":"5av40"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"на обработку страниц памяти, что может снижать общую производительность.","type":"unstyled","key":"2ctj8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНДЕКС ПРИОРИТЕТА КОРРЕЛЯЦИИ (Correlation Priority Index, CPI)","type":"unstyled","key":"3q7vb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОРРЕЛИРУЕМЫЕ ЗНАЧЕНИЯ | CPI","type":"unstyled","key":"b1e2b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.1. Корреляция cs(переключения контекста) и in(прерывания)| 000000000000,9954","type":"unstyled","key":"4sgcf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.3. Корреляция: dirty pages size(KB) и b(процессы в uninterruptible sleep)| 000000000000,9900","type":"unstyled","key":"cbeaa"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.2. Корреляция cs(переключения контекста) и us(user time)| 000000000000,9876","type":"unstyled","key":"ce53h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.5. Корреляция: shared_buffers hit и прочитанные блоки| 000000000000,9493","type":"unstyled","key":"43nsm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.3. Корреляция cs(переключения контекста) и sy(system time)| 000000000000,8322","type":"unstyled","key":"43q83"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.6. Корреляция: dirty pages size(KB) и sy(system time)| 000000000000,8168","type":"unstyled","key":"e2h70"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.5. Корреляция: dirty pages size(KB) и bo(блоки записанные на устройства)| 000000000000,5846","type":"unstyled","key":"39gn0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.8. Корреляция: записанные блоки и bo(блоки записанные на устройства)| 000000000000,5727","type":"unstyled","key":"8mki8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1.2. Корреляция: IO и bo(блоки, записанные на устройства)| 000000000000,0000","type":"unstyled","key":"aq1g7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-------------------------------------------------------------------------","type":"unstyled","key":"asg6l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4. ДИАГРАММА ПАРЕТО ПО WAIT_EVENT","type":"unstyled","key":"e1t94"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-14 09:56","type":"unstyled","key":"693bu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-14 12:18","type":"unstyled","key":"svc6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"WAIT_EVENT_TYPE | WAIT_EVENT | COUNT | PCT |","type":"unstyled","key":"bvkc9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"IO|DataFileRead|14355148| 000000000099,9500|","type":"unstyled","key":"doegp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-------------------------------------------------------------------------","type":"unstyled","key":"33can"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"5. ДИАГРАММА ПАРЕТО ПО QUERYID","type":"unstyled","key":"8tu4p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-14 09:56","type":"unstyled","key":"453og"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-14 12:18","type":"unstyled","key":"9ues"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"QUERYID - идентификатор SQL выражения |","type":"unstyled","key":"epqgh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"CALLS - количество выполнений |","type":"unstyled","key":"3hq6t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"WAITINGS - Ожидания wait_event_type по данному queryid |","type":"unstyled","key":"5a07u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"PCT - отношение ожиданий wait_event_type по данному queryid |","type":"unstyled","key":"c8q99"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"к общему количество ожиданий wait_event_type |","type":"unstyled","key":"3ojh9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"DBNAME ROLENAME - Наименование БД и Роли |","type":"unstyled","key":"90u27"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"WAIT_EVENT LIST - Список событий ожиданий |","type":"unstyled","key":"8um9f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1. IO. ИНТЕГРАЛЬНЫЙ ПРИОРИТЕТ ТИПА ОЖИДАНИЯ = | 000000000000,6271","type":"unstyled","key":"beg30"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"QUERYID | CALLS | WAITINGS | PCT | WAIT_EVENT LIST |","type":"unstyled","key":"40d7t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-2753873076014177353| 000017073086,0000|12243131| 000000000085,2400|DataFileRead DataFileWrite SlruRead |","type":"unstyled","key":"985ij"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-------------------------------------------------------------------------","type":"unstyled","key":"mp02"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"СПИСОК SQL ВЫРАЖЕНИЙ","type":"unstyled","key":"1e7ts"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-14 09:56","type":"unstyled","key":"34jv5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-14 12:18","type":"unstyled","key":"djqcf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"QUERYID | SQL TEXT |","type":"unstyled","key":"cvcr4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"6351079688994699458|select scenario2()","type":"unstyled","key":"26hvs"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-3822600778594048981|select scenario3()","type":"unstyled","key":"6onfh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-2753873076014177353|select scenario1()","type":"unstyled","key":"6hoi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"e5o7d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"marker","key":"Rf17ybpJHQcrZwCs2pND"}],"entityMap":{}},"mentions":[]}