Perfomance issue. statement in the log file..
| От | Bala Venkat |
|---|---|
| Тема | Perfomance issue. statement in the log file.. |
| Дата | |
| Msg-id | CACnhOfKAm0B+-+umnNLCPE-is5ymrj7msDZybkrvnrhgAjGg+Q@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Perfomance issue. statement in the log file..
(Roxanne Reid-Bennett <rox@tara-lu.com>)
Re: Perfomance issue. statement in the log file.. (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Список | pgsql-general |
Dear All -
We are seeing lot of these statements in the log file. We have 2 functions . Submit and update . Between submit and update which will int the process, the messages are appearning. The process is very slow. We don't know if this the main reason for the performance issue2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: execute <unnamed>: SELECT 1 FROM pg_catalog.pg_attrdef WHERE adrelid = $1 AND adn
um = $2 AND pg_catalog.pg_get_expr(adbin, adrelid) LIKE '%nextval(%'
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testDETAIL: parameters: $1 = '3003958', $2 = '1'
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.059 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.117 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 1.087 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: execute <unnamed>: SELECT attnotnull FROM pg_catalog.pg_attribute WHERE attrelid =
$1 AND attnum = $2
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testDETAIL: parameters: $1 = '3003958', $2 = '1'
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.037 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.081 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.120 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: execute <unnamed>: SELECT 1 FROM pg_catalog.pg_attrdef WHERE adrelid = $1 AND adn
um = $2 AND pg_catalog.pg_get_expr(adbin, adrelid) LIKE '%nextval(%'
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testDETAIL: parameters: $1 = '3003958', $2 = '2'
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.028 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.058 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.163 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: execute <unnamed>: SELECT attnotnull FROM pg_catalog.pg_attribute WHERE attrelid =
$1 AND attnum = $2
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testDETAIL: parameters: $1 = '3003958', $2 = '2'
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.032 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.074 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.118 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: execute <unnamed>: SELECT 1 FROM pg_catalog.pg_attrdef WHERE adrelid = $1 AND adn
um = $2 AND pg_catalog.pg_get_expr(adbin, adrelid) LIKE '%nextval(%'
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testDETAIL: parameters: $1 = '3003958', $2 = '3'
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.027 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.058 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.161 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: execute <unnamed>: SELECT attnotnull FROM pg_catalog.pg_attribute WHERE attrelid =
$1 AND attnum = $2
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testDETAIL: parameters: $1 = '3003958', $2 = '3'
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.032 ms
2016-02-23 18:11:24 GMT 172.26.22.145(52330) user=postgres , db=testLOG: duration: 1210.331 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 1.230 ms
2016-02-23 18:11:24 GMT IpAddress(33946) user=UserName , db=testLOG: duration: 0.083 ms
В списке pgsql-general по дате отправления: