Too many SET TimeZone and Application_name queries

From: Amarendra Konda <amar(dot)vijaya(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Too many SET TimeZone and Application_name queries
Date: 2019-10-11 11:49:10
Message-ID: CAJNAD0=HYZ3KNmuA9aJvRWz=05MwsHs5g_Vbo8nBu=q1Nf0FnQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

2019-10-10 13:37:25 UTC:172.31.77.194(36920):
user1(at)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(at)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(at)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Clavadetscher 2019-10-11 12:00:35 Re: Trigger
Previous Message Thomas Kellerer 2019-10-11 11:40:18 JSON vs. JSONB storage size