Request a Demo
5.26. Message Log
Prev UpChapter 5. Using PPEMHome Next

5.26. Message Log #

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 the specified instance:

  1. In the navigation panel, go to Infrastructure → Instances.

  2. Click the name of the instance.

  3. 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.

Prev Up Next
5.25. Instance Roles Home 5.27. Task Console
epub pdf