Skip to content

Monitor server log events via SQLSTATE messages classes #235

@psoo

Description

@psoo

In pgwatch2, we monitor server log events like ERROR, FATAL and count their occurences.

This is far too generic and i doubt the usefulness of this information at (e.g. ERROR can be just
a mistyped query or the like).

Instead, i suggest to count the server log events according their SQLSTATE classes. The first
two bytes of an SQLSTATE identifier describes the message class a specific message belongs to (e.g. 53 for insufficient resources). This way we can distuingish specific error conditions and expose them in a more meaningful context.

Metadata

Metadata

Assignees

No one assigned

    Labels

    metricsMetrics related issues

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions