PostgreSQL fields

Module for parsing the PostgreSQL log files.

postgresql fields

Fields from PostgreSQL logs.

log fields

Fields from the PostgreSQL log files.

postgresql.log.timestamp

The timestamp from the log line.

postgresql.log.timezone

The timezone of timestamp.

postgresql.log.thread_id

type: long

Process id

postgresql.log.user

example: admin

Name of user

postgresql.log.database

example: mydb

Name of database

postgresql.log.level

example: FATAL

The log level.

postgresql.log.duration

type: float

example: 30.0

Duration of a query.

postgresql.log.query

example: SELECT * FROM users;

Query statement.

postgresql.log.message

type: text

The logged message.