Major When debug is enabled, the PostgreSQL driver is very verbose. SonarQube SQL logs are lost in this noise.
DEBUG and TRACE logs of org.postgresql.jdbc.PgConnection and org.postgresql.core.v3.QueryExecutorImpl should be disabled:
2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection] setAutoCommit = false 2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection] setAutoCommit = true 2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection] setAutoCommit = false 2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection] setAutoCommit = true 2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection] setAutoCommit = false 2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection] setAutoCommit = true 2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection] setAutoCommit = false 2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection] setAutoCommit = true 2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection] setAutoCommit = false 2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection] setAutoCommit = true 2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection] setAutoCommit = false 2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection] setAutoCommit = true
2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] FE=> Bind(stmt=null,portal=null,$1=<'sonar.lf.aboutText'>) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] FE=> Describe(portal=null) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] FE=> Execute(portal=null,limit=0) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] FE=> Sync 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] <=BE BindComplete [unnamed] 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] <=BE CommandStatus(BEGIN) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] <=BE ParseComplete [null] 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] <=BE BindComplete [unnamed] 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] <=BE RowDescription(6) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] Field(key,VARCHAR,65535,T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] Field(empty,BOOL,1,T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] Field(textvalue,VARCHAR,65535,T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] Field(clobvalue,TEXT,65535,T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] Field(resourceid,INT8,8,T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] Field(userid,INT8,8,T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] <=BE CommandStatus(SELECT 0) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl] <=BE ReadyForQuery(T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][sql] time=1ms | sql=select p.prop_key as "key", p.is_empty as empty, p.text_value as textValue, p.clob_value as clobValue, p.resource_id as resourceId, p.user_id as userId from properties p where p.prop_key in ( ? ) and p.resource_id is null and p.user_id is null order by p.id | params=sonar.lf.aboutText 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] <=BE ParseComplete [null] 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] <=BE BindComplete [unnamed] 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] <=BE CommandStatus(BEGIN) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] <=BE ParseComplete [null] 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] <=BE BindComplete [unnamed] 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] <=BE RowDescription(6) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] Field(key,VARCHAR,65535,T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] Field(empty,BOOL,1,T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] Field(textvalue,VARCHAR,65535,T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] Field(clobvalue,TEXT,65535,T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] Field(resourceid,INT8,8,T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] Field(userid,INT8,8,T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] <=BE CommandStatus(SELECT 0) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl] <=BE ReadyForQuery(T) 2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][sql] time=2ms | sql=select p.prop_key as "key", p.is_empty as empty, p.text_value as textValue, p.clob_value as clobValue, p.resource_id as resourceId, p.user_id as userId from properties p where p.prop_key=? and p.resource_id is null and p.user_id is null | params=sonar.forceAuthentication