postgres set application name

[erik.dittert]

Hi,

 

is it possbile to set the current report name as application name for postgres db to detect which report takes big resources?

 

 

Thx!

 

Erik

[erik.dittert]

in php is easy with "pg_query("SET application_name = 'Test log line'");"

[erik.dittert]

in database settings is no problem, but i need it per report?

 

/sites/default/files/images/2014-11-03%2015_54_58-Jaspersoft_%20Datenquelle%20bearbeiten.jpg

[hozawa]

Don't know what the problem is. Can't you just make JasperReports Server datasource per each report with different application name?

[erik.dittert]

we have 100 or more Reports...

 

So its not a good idea to make for every Report a extra DB Connection...