PostgreSQL (10) show all NOTICE messages I use https://console.bluemix.net/docs/services/ComposeForPostgreSQL/index.html#about-compose-for-postgresql

And for some select with long column alias ex:

select id as "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"
from tableName


I receive the following message:

NOTICE:  identifier "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" will be truncated to "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"

Successfully run. Total query runtime: 166 msec.


Where can I find all these messages?

PS
I use sequelize and I met this problem  https://github.com/sequelize/sequelize/issues/2084
after migration from MySQL.

And I want to monitor if there are no selects in the application with such issue.
You can change log_min_messages  to notice which will then write all notices to the server's log file. 

Note that a client can overwrite that setting any time, so it's not 100% reliable.