Гость
Целевая тема:
Создать новую тему:
Автор:
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / В логе видны часто выполняющиеся запросы / 4 сообщений из 4, страница 1 из 1
17.01.2017, 13:05
    #39386022
Gallemar
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
В логе видны часто выполняющиеся запросы
Добрый день
Несколько дней назад на сервере бд/1с появились зависания системы, при включении логирования вижу частые (по 800 в минуту) запросы к пустой базе, по запросу к pg_stat_user_tables вижу частые чтения к таблице из запроса, таблица в топе по seq_scan.
У меня два вопроса:
1. Может ли такой частый запрос повлиять на работы системы (Windows)?
2. Как вывести в лог pid и базу, в который выполняется запрос?
...
Рейтинг: 0 / 0
17.01.2017, 16:32
    #39386214
vyegorov
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
В логе видны часто выполняющиеся запросы
...
Рейтинг: 0 / 0
17.01.2017, 19:06
    #39386337
Gallemar
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
В логе видны часто выполняющиеся запросы
vyegorov,спасибо
...
Рейтинг: 0 / 0
17.01.2017, 19:21
    #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
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / В логе видны часто выполняющиеся запросы / 4 сообщений из 4, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


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