Postgres Pro
Downloads
Home   >   mailing lists

Perfomance issue. statement in the log file.. - Mailing list pgsql-general

From Bala Venkat
Subject Perfomance issue. statement in the log file..
Date
Msg-id CACnhOfKAm0B+-+umnNLCPE-is5ymrj7msDZybkrvnrhgAjGg+Q@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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 issue

Can you please help ? if any one has come across  this issue and resolved. Appreciate your time.

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 = '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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: json function question
Next
From: "David G. Johnston"
Date:
Subject: Re: json function question