NOTE: You are looking at documentation for an older release. For the latest information, see the current release documentation.

› ›

PostgreSQL fields

Module for parsing the PostgreSQL log files.

postgresql fields

Fields from PostgreSQL logs.

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

type: long

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