{"draftJsState":{"blocks":[{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОМПЛЕКСНЫЙ КОРРЕЛЯЦИОННЫЙ АНАЛИЗ СУБД и VMSTAT","type":"unstyled","key":"fn5qj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-------------------------------------------------------------------------","type":"unstyled","key":"aigac"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1. СТАТИСТИЧЕСКИЙ АНАЛИЗ ОЖИДАНИЙ СУБД","type":"unstyled","key":"261em"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-05 18:09","type":"unstyled","key":"39ug5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-05 20:31","type":"unstyled","key":"5vleq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ГРАНИЧНЫЕ ЗНАЧЕНИЯ И МЕДИАНА|№|SPEED |WAITINGS|BUFFERPIN |EXTENSION |IO |IPC |LOCK |LWLOCK |TIMEOUT |","type":"unstyled","key":"55n36"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MIN|1| 000000375955,0000| 000000048536,0000| 000000000000,0000| 000000000000,0000| 000000048522,0000| 000000000001,0000| 000000000004,0000| 000000000002,0000| 000000000005,0000|","type":"unstyled","key":"2rks0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MEDIAN| | 000000383994,0000| 000000078011,0000| 000000000000,0000| 000000000000,0000| 000000077983,0000| 000000000002,0000| 000000000007,0000| 000000000006,0000| 000000000013,0000|","type":"unstyled","key":"3d3f6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MAX|143| 000000683866,0000| 000000226349,0000| 000000000000,0000| 000000000000,0000| 000000225947,0000| 000000000013,0000| 000000000135,0000| 000000000130,0000| 000000000125,0000|","type":"unstyled","key":"7n2th"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1 ЛИНИЯ ТРЕНДА ОПЕРАЦИОННОЙ СКОРОСТИ","type":"unstyled","key":"dtqtg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ПО ЛИНИИ РЕГРЕССИИ вида : Y = a + bt ; ГДЕ t - точка наблюдения.","type":"unstyled","key":"608kq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,7700","type":"unstyled","key":"224a0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000041,3300","type":"unstyled","key":"1ad2k"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Хорошее.","type":"unstyled","key":"8kiib"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет от 60% до 80% вариации.","type":"unstyled","key":"75vro"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Достоверная и практически полезная модель.","type":"unstyled","key":"5ma4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.2 ЛИНИЯ ТРЕНДА ОЖИДАНИЙ СУБД","type":"unstyled","key":"d9jkj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ПО ЛИНИИ РЕГРЕССИИ вида : Y = a + bt ; ГДЕ t - точка наблюдения.","type":"unstyled","key":"7h8k3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,8700","type":"unstyled","key":"9l9v8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000043,0100","type":"unstyled","key":"dt4mu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"6lhga"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"anodg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"5hv2s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.3 РЕГРЕССИЯ ОПЕРАЦИОННОЙ СКОРОСТИ(Y) по ОЖИДАНИЯМ(X) СУБД","type":"unstyled","key":"f3g38"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЛИНИЯ РЕГРЕССИИ вида : Y = a + bX","type":"unstyled","key":"5fb4k"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9700","type":"unstyled","key":"8dtc9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000044,5600","type":"unstyled","key":"5m3jg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"1khf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"9v8c2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"27d3e"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2. КОРРЕЛЯЦИЯ: ОПЕРАЦИОННАЯ СКОРОСТЬ - ОЖИДАНИЯ СУБД","type":"unstyled","key":"3r8u2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Положительная или отсутствует","type":"unstyled","key":"2lut3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3. КОМПЛЕКСНЫЙ АНАЛИЗ ПО ТИПАМ ОЖИДАНИЙ(wait_event_type)","type":"unstyled","key":"4sdv2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.1 BufferPin","type":"unstyled","key":"fj0cb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"a20va"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"a7fl7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.2 Extension","type":"unstyled","key":"537nn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"bnpp8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"dmds1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.3 IO","type":"unstyled","key":"9s7kq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"6bl33"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000001,0000","type":"unstyled","key":"68ess"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"bbsmi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"5fj97"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация ВКО.","type":"unstyled","key":"6vm79"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВЗВЕШЕННАЯ КОРРЕЛЯЦИЯ ОЖИДАНИЙ(ВКО):| 000000000001,0000|","type":"unstyled","key":"fs8aj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КРИТИЧЕСКОЕ ЗНАЧЕНИЕ : Немедленный анализ и действие. Основной фокус расследования.","type":"unstyled","key":"8i5b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 3. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"4uaon"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ ОЖИДАНИЯ СУБД(Y) ПО ОЖИДАНИЯМ ТИПА IO(X)","type":"unstyled","key":"62t76"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000001,0000","type":"unstyled","key":"1qct1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000045,0000","type":"unstyled","key":"4lnct"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"alqi7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"5lap6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"ffa2o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕКОМЕНДУЕМЫЕ ДЕЙСТВИЯ:","type":"unstyled","key":"7jm06"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Анализ и оптимизация топ-запросов по времени ожидания IO","type":"unstyled","key":"gtnh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Проверка и оптимизация индексов (добавление недостающих, удаление неиспользуемых)","type":"unstyled","key":"3t8us"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Настройка параметров effective_io_concurrency и random_page_cost для используемого оборудования","type":"unstyled","key":"5pfvj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.4 IPC","type":"unstyled","key":"flav"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"a6nqk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9746","type":"unstyled","key":"bonfc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"sh96"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"ds1d7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация ВКО.","type":"unstyled","key":"avh7f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВЗВЕШЕННАЯ КОРРЕЛЯЦИЯ ОЖИДАНИЙ(ВКО):| 000000000000,0000|","type":"unstyled","key":"f2tdq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВКО < 0.01 : Игнорировать в текущем анализе.","type":"unstyled","key":"dd2ol"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.5 Lock","type":"unstyled","key":"2mvm2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"4fdup"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9601","type":"unstyled","key":"8rhf9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"1ep5e"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"c1jk2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация ВКО.","type":"unstyled","key":"be68l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВЗВЕШЕННАЯ КОРРЕЛЯЦИЯ ОЖИДАНИЙ(ВКО):| 000000000000,0000|","type":"unstyled","key":"7mpbq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВКО < 0.01 : Игнорировать в текущем анализе.","type":"unstyled","key":"21hgn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.6 LWLock","type":"unstyled","key":"43q3f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"987jv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9577","type":"unstyled","key":"auc15"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"27ac"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"f8bos"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация ВКО.","type":"unstyled","key":"9t5cc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВЗВЕШЕННАЯ КОРРЕЛЯЦИЯ ОЖИДАНИЙ(ВКО):| 000000000000,0000|","type":"unstyled","key":"3u65e"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВКО < 0.01 : Игнорировать в текущем анализе.","type":"unstyled","key":"dih8k"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.7 Timeout","type":"unstyled","key":"705l0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"3rhcq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9672","type":"unstyled","key":"bvjr8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"d3m3q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"4m3se"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация ВКО.","type":"unstyled","key":"99c7g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВЗВЕШЕННАЯ КОРРЕЛЯЦИЯ ОЖИДАНИЙ(ВКО):| 000000000000,0000|","type":"unstyled","key":"d6psr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВКО < 0.01 : Игнорировать в текущем анализе.","type":"unstyled","key":"fa5q9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕЗУЛЬТАТ ОТЧЕТА: ИНТЕГРАЛЬНЫЙ ПРИОРИТЕТ ТИПА ОЖИДАНИЯ","type":"unstyled","key":"agf7n"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"№ | WAIT_EVENT_TYPE | ПРИОРИТЕТ","type":"unstyled","key":"45ec1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1|IO| 000000000000,6271","type":"unstyled","key":"9bt3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-------------------------------------------------------------------------","type":"unstyled","key":"ctpp1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.ТРЕНДОВЫЙ АНАЛИЗ ПРОИЗВОДИТЕЛЬНОСТИ vmstat","type":"unstyled","key":"220hu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-05 18:09","type":"unstyled","key":"9smdh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-05 20:31","type":"unstyled","key":"4t5la"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ГРАНИЧНЫЕ ЗНАЧЕНИЯ И МЕДИАНА|№|procs -> r |procs -> b|cpu -> wa|cpu -> id|","type":"unstyled","key":"fuue6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MIN|1| 000000000002,0000| 000000000009,0000| 000000000058,0000| 000000000002,0000|","type":"unstyled","key":"fisg1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MEDIAN| | 000000000003,0000| 000000000014,0000| 000000000062,0000| 000000000014,0000|","type":"unstyled","key":"7o0n5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MAX|143| 000000000004,0000| 000000000040,0000| 000000000067,0000| 000000000019,0000|","type":"unstyled","key":"82q7i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"procs -> r: Количество процессов в очереди на выполнение.","type":"unstyled","key":"3spi5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"procs -> b: Количество процессов, находящихся в состоянии","type":"unstyled","key":"7uohj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"непрерываемого сна (обычно ожидание IO).","type":"unstyled","key":"13t42"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Рост b — прямой признак того, что процессы не могут продолжить работу.","type":"unstyled","key":"1q2ca"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"cpu -> wa: Процент простоя CPU в ожидании IO.","type":"unstyled","key":"9qoac"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"cpu -> id: Процент полного простоя CPU","type":"unstyled","key":"6irss"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"(если id низкий, а ожиданий много —","type":"unstyled","key":"cfa7c"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"значит CPU занят обработкой других задач или переключениями).","type":"unstyled","key":"dr38"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"procs -> r: Количество процессов в очереди на выполнение","type":"unstyled","key":"13k5o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЛИНИЯ РЕГРЕССИИ по t: Y = a + bt","type":"unstyled","key":"b7746"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,7400","type":"unstyled","key":"gvsq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000040,7400","type":"unstyled","key":"q2c0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Хорошее.","type":"unstyled","key":"55tcn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет от 60% до 80% вариации.","type":"unstyled","key":"8hvd8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Достоверная и практически полезная модель.","type":"unstyled","key":"49rvb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Негативный тренд (ухудшение)","type":"unstyled","key":"7j5ng"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициента Тренда | 000000000030,2100","type":"unstyled","key":"668bq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Очень высокая скорость изменения при отличной объясняющей способности модели (R2>0,8).","type":"unstyled","key":"djecv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Значения редко встречаются и указывают на серьёзные проблемы.","type":"unstyled","key":"cdipo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Создать инцидент, привлечь экспертов.","type":"unstyled","key":"5r8v6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕКОМЕНДУЕМЫЕ МЕРОПРИЯТИЯ","type":"unstyled","key":"6pq1m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Проверить загрузку процессора, выявить процессы-потребители, проанализировать планировщик.","type":"unstyled","key":"3bq7j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"procs -> b: Количество процессов, находящихся в состоянии","type":"unstyled","key":"1nn4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"непрерываемого сна (обычно ожидание IO).","type":"unstyled","key":"49rnp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЛИНИЯ РЕГРЕССИИ по t: Y = a + bt","type":"unstyled","key":"4rhol"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,8700","type":"unstyled","key":"f40ib"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000042,9500","type":"unstyled","key":"9urm1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"6dknc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"6duis"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"eniup"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Негативный тренд (ухудшение)","type":"unstyled","key":"dmprf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициента Тренда | 000000000037,2300","type":"unstyled","key":"a6oa"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Очень высокая скорость изменения при отличной объясняющей способности модели (R2>0,8).","type":"unstyled","key":"a54rk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Значения редко встречаются и указывают на серьёзные проблемы.","type":"unstyled","key":"77f15"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Создать инцидент, привлечь экспертов.","type":"unstyled","key":"2h8ph"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕКОМЕНДУЕМЫЕ МЕРОПРИЯТИЯ","type":"unstyled","key":"4d594"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Исследовать дисковую подсистему (iostat, iotop), проверить наличие медленных устройств, конфликтов ввода-вывода.","type":"unstyled","key":"9nmo4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"cpu -> wa: Процент простоя CPU в ожидании IO.","type":"unstyled","key":"5kjpo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЛИНИЯ РЕГРЕССИИ по t: Y = a + bt","type":"unstyled","key":"jnou"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,0300","type":"unstyled","key":"89c3g"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000009,3700","type":"unstyled","key":"6rkkv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Неудовлетворительное.","type":"unstyled","key":"71mea"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет менее 20% (вплоть до 0%) вариации.","type":"unstyled","key":"6kfsq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Модель бесполезна. Коэффициенты, даже если они значимы,","type":"unstyled","key":"1hmv7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Негативный тренд (ухудшение)","type":"unstyled","key":"a8lvr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициента Тренда | 000000000000,2600","type":"unstyled","key":"72t4j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шум или статистически незначимые изменения","type":"unstyled","key":"f76jt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Игнорировать либо учитывать в долгосрочной статистике без оперативных действий.","type":"unstyled","key":"2ehdc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"cpu -> id: Процент полного простоя CPU.","type":"unstyled","key":"6f236"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЛИНИЯ РЕГРЕССИИ по t: Y = a + bt","type":"unstyled","key":"f0t5e"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9100","type":"unstyled","key":"442c6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона |-000000000043,6600","type":"unstyled","key":"fo5ej"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"bf2f0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"1flce"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"c8pkk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Негативный тренд (ухудшение)","type":"unstyled","key":"8t1ft"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициента Тренда | 000000000039,7400","type":"unstyled","key":"4o1g3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Очень высокая скорость изменения при отличной объясняющей способности модели (R2>0,8).","type":"unstyled","key":"d8r7d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Значения редко встречаются и указывают на серьёзные проблемы.","type":"unstyled","key":"1fbc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Создать инцидент, привлечь экспертов.","type":"unstyled","key":"bbmrm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕКОМЕНДУЕМЫЕ МЕРОПРИЯТИЯ","type":"unstyled","key":"2e9h7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Проверить, не связано ли с уменьшением полезной работы.","type":"unstyled","key":"fqq77"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-------------------------------------------------------------------------","type":"unstyled","key":"a889k"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3. СТАТИСТИЧЕСКИЙ АНАЛИЗ ОЖИДАНИЙ СУБД и МЕТРИК vmstat","type":"unstyled","key":"95i5q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-05 18:09","type":"unstyled","key":"4b8pc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-05 20:31","type":"unstyled","key":"n5mj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"CPU = 8","type":"unstyled","key":"8d1oe"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"RAM =7.497(GB)","type":"unstyled","key":"bhemd"},{"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":"eaahu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MIN|1| 000000000002,0000| 000000000009,0000| 000000000203,0000| 000000000176,0000| 000000000029,0000| 000000006556,0000| 000000000000,0000| 000000000000,0000| 000000027542,0000| 000000018190,0000| 000000021227,0000| 000000030992,0000| 000000000013,0000| 000000000007,0000| 000000000002,0000| 000000000058,0000| 000000000000,0000|","type":"unstyled","key":"1ou1t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MEDIAN| | 000000000003,0000| 000000000014,0000| 000000000206,0000| 000000000177,0000| 000000000089,0000| 000000006775,0000| 000000000000,0000| 000000000000,0000| 000000028314,0000| 000000020460,0000| 000000021720,0000| 000000032429,0000| 000000000014,0000| 000000000007,0000| 000000000014,0000| 000000000062,0000| 000000000000,0000|","type":"unstyled","key":"8agvh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"MAX|143| 000000000004,0000| 000000000040,0000| 000000000343,0000| 000000000180,0000| 000000000120,0000| 000000007028,0000| 000000000000,0000| 000000000000,0000| 000000033221,0000| 000000026894,0000| 000000030589,0000| 000000046911,0000| 000000000026,0000| 000000000011,0000| 000000000019,0000| 000000000067,0000| 000000000000,0000|","type":"unstyled","key":"6ji1i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОТНОСИТЕЛЬНЫЕ ПОКАЗАТЕЛИ vmstat","type":"unstyled","key":"612mo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"us(user time) + sy(system time) (% свыше 80%) | 000000000000,0000","type":"unstyled","key":"5ge7q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"OK: менее 25% тестового периода","type":"unstyled","key":"fkdgt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"r — процессы в run queue (готовы к выполнению): % превышения ядер CPU | 000000000000,0000","type":"unstyled","key":"8cfeg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"OK: менее 25% тестового периода - очередь процессов превышает количество ядер CPU","type":"unstyled","key":"ct2c5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"sy — system time: % превышение 30% | 000000000000,0000","type":"unstyled","key":"cmn0a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"OK: менее 25% тестового периода - доля system time превышает 30%","type":"unstyled","key":"2mbho"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"free — свободная RAM (% менее 5%) | 000000000100,0000","type":"unstyled","key":"3de29"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM: более 50% тестового периода - свободная RAM менее 5%","type":"unstyled","key":"clvqt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"swap in (% тестового периода) | 000000000000,0000","type":"unstyled","key":"9s6oq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОК : Свопинг в RAM не используется","type":"unstyled","key":"f1114"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"swap out (% тестового периода) | 000000000000,0000","type":"unstyled","key":"8gn24"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОК : Свопинг из RAM не используется","type":"unstyled","key":"f4b59"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"wa(ожидание IO) свыше 10% | 000000000100,0000","type":"unstyled","key":"3s3ju"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM: более 50% тестового периода - wa > 10%","type":"unstyled","key":"bqbjt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"b(процессы в uninterruptible sleep): % превышения ядер CPU | 000000000100,0000","type":"unstyled","key":"2jigt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM: более 50% тестового периода - b(процессы в uninterruptible sleep) превышает количество ядер CPU","type":"unstyled","key":"soc7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЧАСТЬ-1. АНАЛИЗ ОЖИДАНИЙ СУБД и МЕТРИК vmstat","type":"unstyled","key":"5r8lq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1. IO(ИНТЕГРАЛЬНЫЙ ПРИОРИТЕТ) | 000000000000,6271","type":"unstyled","key":"fr7vu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ПРИРОДА ОЖИДАНИЯ: Процесс ждет завершения операции ввода-вывода","type":"unstyled","key":"20dv5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"(чтения страницы с диска или записи на диск). Наиболее \"дисковый\" тип ожидания.","type":"unstyled","key":"36v89"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Наиболее \"дисковый\" тип ожидания.","type":"unstyled","key":"2035o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1.1. Корреляция: IO и bi(блоки, считанные с устройств)","type":"unstyled","key":"aar3l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"c85b1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,5543","type":"unstyled","key":"5a8ek"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"bkj2o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"48l1m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"e4krf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"bj01a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ IO(Y) ПО bi(блоки, считанные с устройств)(X)","type":"unstyled","key":"8f2up"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,3100","type":"unstyled","key":"54br"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000029,0000","type":"unstyled","key":"aj0a3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Слабое.","type":"unstyled","key":"2h86r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет менее 40%, но более 20% вариации.","type":"unstyled","key":"43sui"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Влияние факторов подтверждено, но модель ничего не предсказывает.","type":"unstyled","key":"4n1od"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"*INFO: Рост bi указывает на чтение данных, которых не было в кеше.","type":"unstyled","key":"8ednr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1.2. Корреляция: IO и bo(блоки, записанные на устройства)","type":"unstyled","key":"2n16a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"744kd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,8490","type":"unstyled","key":"bimku"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"67l04"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"f9pl9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"f0hp9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"eidc7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ IO(Y) ПО bo(блоки, записанные на устройства)(X)","type":"unstyled","key":"8id2s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,7200","type":"unstyled","key":"6ei8h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000040,3300","type":"unstyled","key":"893ha"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Хорошее.","type":"unstyled","key":"5q19j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет от 60% до 80% вариации.","type":"unstyled","key":"i83i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Достоверная и практически полезная модель.","type":"unstyled","key":"28khr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"*INFO: Указывает на сброс \"грязных\" страниц (checkpointer, bgwriter).","type":"unstyled","key":"8edg8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1.3. Корреляция: IO и wa(ожидание IO)","type":"unstyled","key":"c8l4r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"5ip08"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"anvnb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"5lkki"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"dp2v9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЧАСТЬ-2. АНАЛИЗ МЕТРИК vmstat","type":"unstyled","key":"9eubf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.1. Корреляция cs(переключения контекста) и in(прерывания)","type":"unstyled","key":"5jt70"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"2padj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9955","type":"unstyled","key":"d66ic"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"8jkr3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"3od1h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"dh2qc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"culdo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ cs(переключения контекста)(Y) ПО in(прерывания)(X)","type":"unstyled","key":"5o5mq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9900","type":"unstyled","key":"rvdu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000044,8700","type":"unstyled","key":"r5qf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"bk5nm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"25e9l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"9nvm8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"*INFO: Переключения контекста могут быть вызваны прерываниями.","type":"unstyled","key":"a4vpo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.2. Корреляция cs(переключения контекста) и us(user time)","type":"unstyled","key":"cul6l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"3s0j8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9942","type":"unstyled","key":"1pmej"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"1l86o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"8fe1s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"576j6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"6cjrf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ cs(переключения контекста)(Y) ПО us(user time)(X)","type":"unstyled","key":"9guca"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9900","type":"unstyled","key":"bb3be"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000044,8300","type":"unstyled","key":"724pr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"83q34"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"e83qk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"99j22"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"*INFO: Возможно проблема в пользовательском приложении(resource contention).","type":"unstyled","key":"7dfj0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.3. Корреляция cs(переключения контекста) и sy(system time)","type":"unstyled","key":"3h3nh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"59pik"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9767","type":"unstyled","key":"39ats"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"bnnvt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"d77li"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"2l3a8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"351fr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ cs(переключения контекста)(Y) ПО sy(system time)(X)","type":"unstyled","key":"ed2q1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9500","type":"unstyled","key":"41apt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000044,3200","type":"unstyled","key":"em658"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"5gmqm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"cu038"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"62beh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"*INFO: Ядро тратит много времени на переключение контекста и планирование,","type":"unstyled","key":"5d606"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"вместо полезной работы.","type":"unstyled","key":"7m85u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ЧАСТЬ-3. АНАЛИЗ IO","type":"unstyled","key":"30nc9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.1. Отношение прочитанных блоков shared_buffers","type":"unstyled","key":"fucdg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Эмпирические ориентиры","type":"unstyled","key":"35gut"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"для оценки типа нагрузки(OLAP/OLTP):","type":"unstyled","key":"dbl72"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"OLTP сценарий.","type":"unstyled","key":"7em35"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.2. SHARED_BUFFERS HIT RATIO | MIN | MEDIAN | MAX |","type":"unstyled","key":"fcl3l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"INFO: приемлемо для OLAP, особенно при работе с большими таблицами | 000000000096,0873| 000000000096,6382| 000000000098,3550|","type":"unstyled","key":"7ucra"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.3. Корреляция: операционная скорость и прочитанные блоки","type":"unstyled","key":"aj0rp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"cjcr4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,5818","type":"unstyled","key":"694ue"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"4dkot"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"c4fl9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"94ufe"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"bk5oa"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ операционная скорость(Y) ПО прочитанные блоки(X)","type":"unstyled","key":"268b9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,3400","type":"unstyled","key":"d0l66"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000030,1900","type":"unstyled","key":"cr980"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Слабое.","type":"unstyled","key":"1f7s8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет менее 40%, но более 20% вариации.","type":"unstyled","key":"5ahh1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Влияние факторов подтверждено, но модель ничего не предсказывает.","type":"unstyled","key":"2r1f3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"WARNING : Высокая корреляция.","type":"unstyled","key":"2jpd0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Производительности IO - недостаточно для данной нагрузки.","type":"unstyled","key":"iv8j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.4. Корреляция: операционная скорость и записанные блоки","type":"unstyled","key":"9ecam"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"fnnsc"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,3302","type":"unstyled","key":"ageg9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"4pd31"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"39gvr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"СЛАБАЯ ИЛИ СРЕДНЯЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"7g97f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"9ni4d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"aplas"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"INFO : Слабая корреляция.","type":"unstyled","key":"9qt2h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.5. Корреляция: shared_buffers hit и прочитанные блоки","type":"unstyled","key":"7b8iu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"bvnpu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Положительная или отсутствует","type":"unstyled","key":"4r52d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"cjqbe"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"3s5o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.6. Корреляция: прочитанные блоки и swap in","type":"unstyled","key":"644nj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"51ica"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"7p3hj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"ak1j3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"918da"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.7. Корреляция: грязные блоки и bo(блоки записанные на устройства)","type":"unstyled","key":"148p5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"8nbp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,0701","type":"unstyled","key":"36frp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Незначима","type":"unstyled","key":"4m01m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Незначима","type":"unstyled","key":"33ngk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"СЛАБАЯ ИЛИ СРЕДНЯЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"enumo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"7gcnm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.8. Корреляция: записанные блоки и bo(блоки записанные на устройства)","type":"unstyled","key":"3u63m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"1v9hd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,8762","type":"unstyled","key":"5f9og"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"4eac6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"4koj3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"2a6o6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"aaqr4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ записанные блоки(Y) ПО bo(блоки записанные на устройства)(X)","type":"unstyled","key":"4hna8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,7700","type":"unstyled","key":"9vba8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000041,2200","type":"unstyled","key":"7h9du"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Хорошее.","type":"unstyled","key":"3mpvo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет от 60% до 80% вариации.","type":"unstyled","key":"bfd2p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Достоверная и практически полезная модель.","type":"unstyled","key":"aljv8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ВОЗМОЖНЫЕ ПРИЧИНЫ:","type":"unstyled","key":"5uhqm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Неоптимальные настройки контрольных точек (checkpoint_timeout, max_wal_size).","type":"unstyled","key":"6tl9o"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Слишком агрессивные настройки фоновых писателей (bgwriter_delay, bgwriter_lru_maxpages).","type":"unstyled","key":"caaqg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Медленный диск под WAL или табличным пространством.","type":"unstyled","key":"6uldk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕКОМЕНДУЕМЫЕ ДЕЙСТВИЯ:","type":"unstyled","key":"477up"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Настроить контрольные точки, увеличив checkpoint_timeout и max_wal_size для более плавной записи.","type":"unstyled","key":"7g3t4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрегулировать параметры bgwriter.","type":"unstyled","key":"9quea"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Мониторить buffers_checkpoint, buffers_clean, buffers_backend в pg_stat_bgwriter.","type":"unstyled","key":"3jkj4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.9. Корреляция: hit и us(user time)","type":"unstyled","key":"ebdme"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"7pnas"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Положительная или отсутствует","type":"unstyled","key":"83a7u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"cfsdm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"fgdt5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.10. Корреляция: hit и sy(system time)","type":"unstyled","key":"1ncr2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"cm4s5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Положительная или отсутствует","type":"unstyled","key":"2fauu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"3ak2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"dinct"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.11. Корреляция: грязные блоки и wa(ожидание IO)","type":"unstyled","key":"bo4ih"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"a9e8b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"f84f9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"38ohv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"952nb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Часть-4. СТАТИСТИКА VM_DIRTY*","type":"unstyled","key":"f2bpr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"dirty_kb/dirty_ratio/dirty_background_ratio | MIN | MEDIAN | MAX |","type":"unstyled","key":"agqjd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"dirty pages size (KB) | 000000005666,0000| 000000007126,0000| 000000018146,0000|","type":"unstyled","key":"dea68"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"dirty_ratio | 000000000000,0000| 000000000000,0000| 000000000001,0000|","type":"unstyled","key":"6r2o1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"dirty_bg_percent | 000000000001,0000| 000000000001,0000| 000000000003,0000|","type":"unstyled","key":"4cta8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"available_mem_mb | 000000004677,0000| 000000004883,0000| 000000005079,0000|","type":"unstyled","key":"8dgv9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.1. Корреляция: dirty pages size(KB) и so(swap-out)","type":"unstyled","key":"7tve1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"bs7ss"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"9n1f2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"2i55p"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"dgnmv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.2. Корреляция: dirty pages size(KB) и wa(ожидание IO)","type":"unstyled","key":"5rtqn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"5puk9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Отрицательная или отсутствует","type":"unstyled","key":"6hpm3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"5155f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"cagvi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.3. Корреляция: dirty pages size(KB) и b(процессы в uninterruptible sleep)","type":"unstyled","key":"f89im"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"es6ml"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9924","type":"unstyled","key":"3umdi"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"81mfd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"6to0b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"b45o9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"d8o8d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ dirty pages size(KB)(Y) ПО b(процессы в uninterruptible sleep)(X)","type":"unstyled","key":"7164i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9800","type":"unstyled","key":"8hbug"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000044,7800","type":"unstyled","key":"8sr5l"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"e6r2"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"f560n"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"amvj0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM","type":"unstyled","key":"bf0u8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Процессы СУБД (например, backend-процессы) массово блокируются в состоянии I/O wait.","type":"unstyled","key":"5snu7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Подтверждает корреляцию с wa и требует настройки vm.dirty_* параметров и/или улучшения дисков.","type":"unstyled","key":"e40kf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Очередь процессов в состоянии b указывает на системный I/O bottleneck.","type":"unstyled","key":"d96t7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.4. Корреляция: dirty pages size (KB) и free(свободная RAM)","type":"unstyled","key":"ehk7r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"b1btp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Положительная или отсутствует","type":"unstyled","key":"8oilr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОРРЕЛЯЦИЙ: КОРРЕЛЯЦИЯ НЕСУЩЕСТВЕННА","type":"unstyled","key":"f3jk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНТЕРПРЕТАЦИЯ КОЭФФИЦИЕНТА ДЕТЕРМИНАЦИИ R2: НЕПРИГОДНАЯ МОДЕЛЬ","type":"unstyled","key":"7isv7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.5. Корреляция: dirty pages size(KB) и bo(блоки записанные на устройства)","type":"unstyled","key":"7833v"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"f7rfv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,8601","type":"unstyled","key":"aq190"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"3bq52"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"941b6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"a4jt4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"a9bgj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ dirty pages size(KB)(Y) ПО bo(блоки записанные на устройства)(X)","type":"unstyled","key":"cno9d"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,7400","type":"unstyled","key":"8rqep"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000040,7000","type":"unstyled","key":"6gv9i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Хорошее.","type":"unstyled","key":"2v5qh"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет от 60% до 80% вариации.","type":"unstyled","key":"1b7ck"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Достоверная и практически полезная модель.","type":"unstyled","key":"5vepe"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM","type":"unstyled","key":"f2fi5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Механизм обратной записи не успевает за генерацией dirty pages.","type":"unstyled","key":"7isgm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Это может быть как из-за медленного диска, так и из-за агрессивной работы приложения.","type":"unstyled","key":"e8thp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.6. Корреляция: dirty pages size(KB) и sy(system time)","type":"unstyled","key":"8mapa"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 1. Интерпретация корреляций.","type":"unstyled","key":"85p2m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ КОРРЕЛЯЦИИ: | 000000000000,9762","type":"unstyled","key":"5n77"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(эмпирическое правило): |Значима (p < ~0.05)","type":"unstyled","key":"a3849"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОЭФФИЦИЕНТ ЗНАЧИМОСТИ ОЦЕНКИ(t-критерий): |Значима (95% уровень)","type":"unstyled","key":"bjas5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ОЧЕНЬ ВЫСОКАЯ КОРРЕЛЯЦИЯ","type":"unstyled","key":"f3796"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Шаг 2. Интерпретация коэффициента детерминации R2.","type":"unstyled","key":"f8siv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"РЕГРЕССИЯ dirty pages size(KB)(Y) ПО sy(system time)(X)","type":"unstyled","key":"av8dt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Коэффициент детерминации R^2 | 000000000000,9500","type":"unstyled","key":"2ak1t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"угол наклона | 000000000044,3100","type":"unstyled","key":"97sne"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Качество модели: Очень высокое.","type":"unstyled","key":"55tve"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Интерпретация: Модель объясняет более 80% дисперсии зависимой переменной.","type":"unstyled","key":"3r30n"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вывод: Связь очень сильная, прогнозная способность высокая.","type":"unstyled","key":"fosv1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ALARM","type":"unstyled","key":"6q9no"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Высокие накладные расходы ядра ОС","type":"unstyled","key":"2fq8a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"на управление памятью и операциями ввода-вывода.","type":"unstyled","key":"a9bvt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Ядро тратит значительное время","type":"unstyled","key":"8lftv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"на обработку страниц памяти, что может снижать общую производительность.","type":"unstyled","key":"de6am"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ИНДЕКС ПРИОРИТЕТА КОРРЕЛЯЦИИ (Correlation Priority Index, CPI)","type":"unstyled","key":"f1vgf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"КОРРЕЛИРУЕМЫЕ ЗНАЧЕНИЯ | CPI","type":"unstyled","key":"5im0n"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.1. Корреляция cs(переключения контекста) и in(прерывания)| 000000000000,9952","type":"unstyled","key":"1ta37"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.2. Корреляция cs(переключения контекста) и us(user time)| 000000000000,9940","type":"unstyled","key":"bo3ie"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.3. Корреляция: dirty pages size(KB) и b(процессы в uninterruptible sleep)| 000000000000,9889","type":"unstyled","key":"4csas"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2.3. Корреляция cs(переключения контекста) и sy(system time)| 000000000000,9640","type":"unstyled","key":"6cgit"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.6. Корреляция: dirty pages size(KB) и sy(system time)| 000000000000,9636","type":"unstyled","key":"fo36j"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.8. Корреляция: записанные блоки и bo(блоки записанные на устройства)| 000000000000,8039","type":"unstyled","key":"6akbe"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4.5. Корреляция: dirty pages size(KB) и bo(блоки записанные на устройства)| 000000000000,7770","type":"unstyled","key":"3135u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1.2. Корреляция: IO и bo(блоки, записанные на устройства)| 000000000000,7586","type":"unstyled","key":"1gqqq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3.3. Корреляция: операционная скорость и прочитанные блоки| 000000000000,2457","type":"unstyled","key":"f402h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1.1.1. Корреляция: IO и bi(блоки, считанные с устройств)| 000000000000,0000","type":"unstyled","key":"1h6i3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-------------------------------------------------------------------------","type":"unstyled","key":"b47ss"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"4. ДИАГРАММА ПАРЕТО ПО WAIT_EVENT","type":"unstyled","key":"a66l4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-05 18:09","type":"unstyled","key":"39hs4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-05 20:31","type":"unstyled","key":"3hcu5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"WAIT_EVENT_TYPE | WAIT_EVENT | COUNT | PCT |","type":"unstyled","key":"f3cid"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"IO|DataFileRead|14159430| 000000000099,8400|","type":"unstyled","key":"eao5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-------------------------------------------------------------------------","type":"unstyled","key":"1705m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"5. ДИАГРАММА ПАРЕТО ПО QUERYID","type":"unstyled","key":"7tpug"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-05 18:09","type":"unstyled","key":"4aupk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-05 20:31","type":"unstyled","key":"c7pul"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"QUERYID - идентификатор SQL выражения |","type":"unstyled","key":"od37"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"CALLS - количество выполнений |","type":"unstyled","key":"74rv6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"WAITINGS - Ожидания wait_event_type по данному queryid |","type":"unstyled","key":"3tbj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"PCT - отношение ожиданий wait_event_type по данному queryid |","type":"unstyled","key":"959fm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"к общему количество ожиданий wait_event_type |","type":"unstyled","key":"dc35u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"DBNAME ROLENAME - Наименование БД и Роли |","type":"unstyled","key":"d22he"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"WAIT_EVENT LIST - Список событий ожиданий |","type":"unstyled","key":"1m1l3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1. IO. ИНТЕГРАЛЬНЫЙ ПРИОРИТЕТ ТИПА ОЖИДАНИЯ = | 000000000000,6271","type":"unstyled","key":"166l5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"QUERYID | CALLS | WAITINGS | PCT | DBNAME ROLENAME | WAIT_EVENT LIST |","type":"unstyled","key":"fe6vl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"8275902800498673318| 000016816525,0000|12059950| 000000000085,0400|pgbench_db expecto_user|DataFileRead DataFileWrite SlruRead |","type":"unstyled","key":"5rml"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-------------------------------------------------------------------------","type":"unstyled","key":"f2tra"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"СПИСОК SQL ВЫРАЖЕНИЙ","type":"unstyled","key":"158m9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-05 18:09","type":"unstyled","key":"1emnl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"2026-03-05 20:31","type":"unstyled","key":"6l9tk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"QUERYID | SQL TEXT |","type":"unstyled","key":"bk8p1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"8858888517606718968|SELECT c.relname, ns.nspname FROM pg_catalog.pg_class c","type":"unstyled","key":"1brdn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"JOIN pg_catalog.pg_namespace ns ON c.relnamespace OPERATOR(pg_catalog.=) ns.oid","type":"unstyled","key":"26s6q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"LEFT JOIN pg_catalog.pg_class t ON c.reltoastrelid OPERATOR(pg_catalog.=) t.oid","type":"unstyled","key":"8j7so"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"WHERE c.relpersistence OPERATOR(pg_catalog.!=) $1","type":"unstyled","key":"bdi2q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"AND c.relkind OPERATOR(pg_catalog.=) ANY (array[$2, $3])","type":"unstyled","key":"48s14"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ORDER BY c.relpages DESC","type":"unstyled","key":"dmv51"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"3895287528978123373|select scenario2()","type":"unstyled","key":"q7ap"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"-90887298659241024|select scenario3()","type":"unstyled","key":"8g86u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"8275902800498673318|select scenario1()","type":"unstyled","key":"c7t28"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"c6jfe"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"marker","key":"A8dhJ1LS1udjeL1x1sZ6"}],"entityMap":{}},"mentions":[]}