PostgreSQL fieldsedit

Module for parsing the PostgreSQL log files.

postgresql fieldsedit

Fields from PostgreSQL logs.

log fieldsedit

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.