Re: Too many SET TimeZone and Application_name queries

On 10/11/19 4:49 AM, Amarendra Konda wrote:
> Hi,
> 
> In our test environment, it was observed that there are too many queries 
> were getting fired to the database server, even though they are not part 
> of the SQL query execution.
> 
> And the number of queries that were coming to server are very high. Can 
> you please suggest on how to avoid these queries to the database server ?

My guess is your application server/framework is setting the below.
What are you using for above?

> 
> 
> 2019-10-10 13:37:25 UTC:172.31.77.194(36920): 
> user1@new_unity_green1:[2549]:LOG:  duration: 0.081 ms  statement: *SET 
> application_name='PostgreSQL JDBC Driver';*
> 2019-10-10 13:37:25 UTC:172.31.69.112(45682): 
> user1@new_unity_green0:[3545]:LOG:  duration: 0.036 ms  statement: *SET 
> TimeZone='UTC';*
> 2019-10-10 13:37:25 
> UTC:172.31.77.194(36902):user1@new_unity_green1:[2112]:LOG:  duration: 
> 0.177 ms  statement: *SET TimeZone='Etc/UTC';SET 
> application_name='PostgreSQL JDBC Driver';*
> 
> 
> *_Environment_*
> 
>   * PGBouncer 1.9
>   * JDBC Driver 42.2.8
>   * Java 1.8
>   * PostgreSQL 9.6.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.3
>     20140911 (Red Hat 4.8.3-9), 64-bit
> 
> 
> Application Server, pgBouncer and database server are all configured 
> with UTC only.
> 
> =>show timezone;
>   TimeZone
> ----------
>   UTC
> 
> Thanks in advance,
> 
> Regards, Amarendra
> 
> 
> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com