PPEM logs DBMS instances. To provide logging, you must first install and configure logging tools.
To view the message log of all instances, in the navigation panel, go to Monitoring → Message journal.
To view the message log of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Message journal.
The table of messages with the following columns will be displayed:
Date, time: The date and time when the message was created.
Instance: The instance associated with the message.
Session: The ID of the user session where the message was created.
Application: The source application of the message.
User: The user on behalf of which the session was initiated.
Database: The database associated with the user session.
Type.
Possible values:
DEBUG1
DEBUG2
DEBUG3
DEBUG4
DEBUG5
INFO
NOTICE
WARNING
ERROR
LOG
FATAL
PANIC
For more information about message types, refer to the official Postgres Pro documentation.
SQLSTATE code: The SQLSTATE code of the message.
Message.
Details: The detailed text of the message.
Hint: The error hint.
Only values of the ERROR, FATAL,
and PANIC messages are displayed in this column.
Query ID: The ID of the query associated with the message.
You can use this ID to find statistics in the pg_stat_activity,
pg_stat_statements, and pgpro_stats
views.
Query: The text of the query associated with the message.