Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > pgsql.interfaces.jdbc > #1
| Newsgroups | pgsql.interfaces.jdbc |
|---|---|
| Date | 2015-11-24 12:50 -0800 |
| Message-ID | <5dbbaa55-b71d-4ff8-8e1c-0815424756f1@googlegroups.com> (permalink) |
| Subject | How to avoid SET application_name = '' |
| From | fabio.caiut@gmail.com |
Hello, I'm trying to understand the "SET application_name" command sent by the driver. We have a server with high concurrency, ~25K TPS, and looking the top queries (with pg_stat_statements view) I get that it's the query taking more time. The command is very fast but the number of calls is huge. TOP 10 Queries (only ~2 hours) calls | total_time | avg_time | rows | avg_rows | hit_percent | ----------+------------+----------+----------+----------+-------------+------------------------------ 55782793 | 8212550.69 | 0.15 | 0 | 0.00 | | SET application_name = '' 4425751 | 322475.14 | 0.07 | 138606 | 0.00 | 98.98 | /* load one-to-many ... 4097384 | 963780.17 | 0.24 | 84514 | 0.00 | 99.77 | /* load ... 3908144 | 366598.92 | 0.09 | 3834578 | 0.00 | 100.00 | /* load ... 2596097 | 480030.01 | 0.18 | 2596097 | 1.00 | 100.00 | /* SELECT count(*) FROM ... 2365353 | 290965.73 | 0.12 | 2365335 | 0.00 | 99.99 | /* load ... 2081011 | 127373.91 | 0.06 | 379289 | 0.00 | 99.59 | /* load collection ... 1303931 | 145544.50 | 0.11 | 1303925 | 0.00 | 95.94 | /* load ... 1274982 | 577683.73 | 0.45 | 1274982 | 1.00 | 100.00 | /* Select count(*) from ... 1203475 | 1522327.87 | 1.26 | 4405775 | 3.00 | 89.44 | /* load ... I'm thinking as the application name is empty maybe this command could be avoid. I have asked our Glassfish people to unmark this option if possible but they told me they don't know how to do it, where to do it. Any ideas? Thanks! Caiut
Back to pgsql.interfaces.jdbc | Next | Find similar
How to avoid SET application_name = '' fabio.caiut@gmail.com - 2015-11-24 12:50 -0800
csiph-web