powered by simpleCommunicator - 2.0.53     © 2025 Programmizd 02
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / В логе видны часто выполняющиеся запросы
4 сообщений из 4, страница 1 из 1
В логе видны часто выполняющиеся запросы
    #39386022
Фотография Gallemar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Добрый день
Несколько дней назад на сервере бд/1с появились зависания системы, при включении логирования вижу частые (по 800 в минуту) запросы к пустой базе, по запросу к pg_stat_user_tables вижу частые чтения к таблице из запроса, таблица в топе по seq_scan.
У меня два вопроса:
1. Может ли такой частый запрос повлиять на работы системы (Windows)?
2. Как вывести в лог pid и базу, в который выполняется запрос?
...
Рейтинг: 0 / 0
В логе видны часто выполняющиеся запросы
    #39386214
Фотография vyegorov
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
...
Рейтинг: 0 / 0
В логе видны часто выполняющиеся запросы
    #39386337
Фотография Gallemar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
vyegorov,спасибо
...
Рейтинг: 0 / 0
В логе видны часто выполняющиеся запросы
    #39386344
Фотография Gallemar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Можете подсказать, выделенное красным что означает:
2017-01-18 00:08:28.592 IRKT,"postgres","Trade_17_01_17",11052,"::1:63577",587e3af8.2b2c,2154,"SELECT",2017-01-17 23:40:40 IRKT,14/35624,0,LOG,00000,"duration: 0.000 ms execute <unnamed> : SELECT
T1.IDRRef,
T1.Marked_,
T1.Date_Time_,
T1.BusinessProcess_TYPE,
T1.BusinessProcess_RTRef,
T1.BusinessProcess_RRRef,
T1.Point_TYPE,
T1.Point_RTRef,
T1.Point_RRRef,
T1.Name_,
T1.Executed_,
T1.Fld7279_,
T1.Fld7280_,
T1.Fld7281_TYPE,
T1.Fld7281_RTRef,
T1.Fld7281_RRRef,
T1.Fld7282RRef,
T1.Fld7425_,
T1.Fld7426_,
T1.Fld7427_,
T1.Fld8655_,
T1.MainAddrPropRRef
FROM (SELECT
T2.Date_Time_ AS Date_Time_,
T2.Executed_ AS Executed_,
T2.Name_ AS Name_,
T2.Fld7279_ AS Fld7279_,
T2.Point_TYPE AS Point_TYPE,
T2.Point_RTRef AS Point_RTRef,
T2.Point_RRRef AS Point_RRRef,
T2.Fld7280_ AS Fld7280_,
T2.BusinessProcess_TYPE AS BusinessProcess_TYPE,
T2.BusinessProcess_RTRef AS BusinessProcess_RTRef,
T2.BusinessProcess_RRRef AS BusinessProcess_RRRef,
T2.IDRRef AS IDRRef,
T2.Marked_ AS Marked_,
T2.Fld7425_ AS Fld7425_,
T2.Fld8655_ AS Fld8655_,
T2.MainAddrPropRRef AS MainAddrPropRRef,
T2.Fld7427_ AS Fld7427_,
T2.Fld7281_TYPE AS Fld7281_TYPE,
T2.Fld7281_RTRef AS Fld7281_RTRef,
T2.Fld7281_RRRef AS Fld7281_RRRef,
T2.Fld7282RRef AS Fld7282RRef,
T2.Fld7426_ AS Fld7426_
FROM (SELECT
T3._Date_Time AS Date_Time_,
T3._Executed AS Executed_,
T3._Name AS Name_,
T3._Fld7279 AS Fld7279_,
T3._Point_TYPE AS Point_TYPE,
T3._Point_RTRef AS Point_RTRef,
T3._Point_RRRef AS Point_RRRef,
T3._Fld7280 AS Fld7280_,
T3._BusinessProcess_TYPE AS BusinessProcess_TYPE,
T3._BusinessProcess_RTRef AS BusinessProcess_RTRef,
T3._BusinessProcess_RRRef AS BusinessProcess_RRRef,
T3._IDRRef AS IDRRef,
T3._Marked AS Marked_,
T3._Fld7425 AS Fld7425_,
T3._Fld8655 AS Fld8655_,
T3._Fld7283RRef AS MainAddrPropRRef,
T3._Fld7427 AS Fld7427_,
T3._Fld7281_TYPE AS Fld7281_TYPE,
T3._Fld7281_RTRef AS Fld7281_RTRef,
T3._Fld7281_RRRef AS Fld7281_RRRef,
T3._Fld7282RRef AS Fld7282RRef,
T3._Fld7426 AS Fld7426_
FROM _Task7257 T3
WHERE T3._Fld7283RRef = '\\200\\361\\000PV\\247y\\346\\021\\344\\347\\364d{\\277]'::bytea AND ((((T3._Executed = FALSE) AND (T3._Fld7425 = TRUE)) AND (T3._Fld7426 < '2017-01-18 00:08:28'::timestamp)))) T2) T1",,,,,,,,,""
2017-01-18 00:08:28.592 IRKT,"postgres","Trade_17_01_17",9832,"::1:63573",587e3aee.2668,2080,"PARSE",2017-01-17 23:40:30 IRKT,12/95717,0,LOG,00000,"duration: 0.000 ms parse <unnamed>: SELECT
T1.IDRRef,
T1.Marked_,
T1.Date_Time_,
T1.BusinessProcess_TYPE,
T1.BusinessProcess_RTRef,
T1.BusinessProcess_RRRef,
T1.Point_TYPE,
T1.Point_RTRef,
T1.Point_RRRef,
T1.Name_,
T1.Executed_,
T1.Fld7279_,
T1.Fld7280_,
T1.Fld7281_TYPE,
T1.Fld7281_RTRef,
T1.Fld7281_RRRef,
T1.Fld7282RRef,
T1.Fld7425_,
T1.Fld7426_,
T1.Fld7427_,
T1.Fld8655_,
T1.MainAddrPropRRef
FROM (SELECT
T2.Fld7282RRef AS Fld7282RRef,
T2.Name_ AS Name_,
T2.Fld7426_ AS Fld7426_,
T2.Fld8655_ AS Fld8655_,
T2.Date_Time_ AS Date_Time_,
T2.Fld7280_ AS Fld7280_,
T2.MainAddrPropRRef AS MainAddrPropRRef,
T2.Fld7281_TYPE AS Fld7281_TYPE,
T2.Fld7281_RTRef AS Fld7281_RTRef,
T2.Fld7281_RRRef AS Fld7281_RRRef,
T2.Fld7279_ AS Fld7279_,
T2.Marked_ AS Marked_,
T2.Fld7427_ AS Fld7427_,
T2.Point_TYPE AS Point_TYPE,
T2.Point_RTRef AS Point_RTRef,
T2.Point_RRRef AS Point_RRRef,
T2.Executed_ AS Executed_,
T2.BusinessProcess_TYPE AS BusinessProcess_TYPE,
T2.BusinessProcess_RTRef AS BusinessProcess_RTRef,
T2.BusinessProcess_RRRef AS BusinessProcess_RRRef,
T2.Fld7425_ AS Fld7425_,
T2.IDRRef AS IDRRef
FROM (SELECT
T3._Fld7282RRef AS Fld7282RRef,
T3._Name AS Name_,
T3._Fld7426 AS Fld7426_,
T3._Fld8655 AS Fld8655_,
T3._Date_Time AS Date_Time_,
T3._Fld7280 AS Fld7280_,
T3._Fld7283RRef AS MainAddrPropRRef,
T3._Fld7281_TYPE AS Fld7281_TYPE,
T3._Fld7281_RTRef AS Fld7281_RTRef,
T3._Fld7281_RRRef AS Fld7281_RRRef,
T3._Fld7279 AS Fld7279_,
T3._Marked AS Marked_,
T3._Fld7427 AS Fld7427_,
T3._Point_TYPE AS Point_TYPE,
T3._Point_RTRef AS Point_RTRef,
T3._Point_RRRef AS Point_RRRef,
T3._Executed AS Executed_,
T3._BusinessProcess_TYPE AS BusinessProcess_TYPE,
T3._BusinessProcess_RTRef AS BusinessProcess_RTRef,
T3._BusinessProcess_RRRef AS BusinessProcess_RRRef,
T3._Fld7425 AS Fld7425_,
T3._IDRRef AS IDRRef
FROM _Task7257 T3
WHERE T3._Fld7283RRef = '\\200\\361\\000PV\\247y\\346\\021\\344\\351\\231\\335\\251h\\230'::bytea AND ((((T3._Executed = FALSE) AND (T3._Fld7425 = TRUE)) AND (T3._Fld7426 < '2017-01-18 00:08:28'::timestamp)))) T2) T1",,,,,,,,,""
...
Рейтинг: 0 / 0
4 сообщений из 4, страница 1 из 1
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / В логе видны часто выполняющиеся запросы
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]