|
В логе видны часто выполняющиеся запросы
|
|||
---|---|---|---|
#18+
Добрый день Несколько дней назад на сервере бд/1с появились зависания системы, при включении логирования вижу частые (по 800 в минуту) запросы к пустой базе, по запросу к pg_stat_user_tables вижу частые чтения к таблице из запроса, таблица в топе по seq_scan. У меня два вопроса: 1. Может ли такой частый запрос повлиять на работы системы (Windows)? 2. Как вывести в лог pid и базу, в который выполняется запрос? ... |
|||
:
Нравится:
Не нравится:
|
|||
17.01.2017, 13:05 |
|
В логе видны часто выполняющиеся запросы
|
|||
---|---|---|---|
#18+
Gallemar, 1. Может. 2. https://www.postgresql.org/docs/current/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT ... |
|||
:
Нравится:
Не нравится:
|
|||
17.01.2017, 16:32 |
|
В логе видны часто выполняющиеся запросы
|
|||
---|---|---|---|
#18+
vyegorov,спасибо ... |
|||
:
Нравится:
Не нравится:
|
|||
17.01.2017, 19:06 |
|
В логе видны часто выполняющиеся запросы
|
|||
---|---|---|---|
#18+
Можете подсказать, выделенное красным что означает: 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",,,,,,,,,"" ... |
|||
:
Нравится:
Не нравится:
|
|||
17.01.2017, 19:21 |
|
|
start [/forum/topic.php?fid=53&fpage=79&tid=1996751]: |
0ms |
get settings: |
9ms |
get forum list: |
14ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
38ms |
get topic data: |
11ms |
get forum data: |
3ms |
get page messages: |
40ms |
get tp. blocked users: |
1ms |
others: | 323ms |
total: | 445ms |
0 / 0 |