PostgreSQL fields

Module for parsing the PostgreSQL log files.

postgresql

Fields from PostgreSQL logs.

log

Fields from the PostgreSQL log files.

postgresql.log.timestamp

[7.3.0] Deprecated in 7.3.0.

The timestamp from the log line.

postgresql.log.core_id

Core id

type: long

postgresql.log.database

Name of database

example: mydb

postgresql.log.query

Query statement.

example: SELECT * FROM users;

postgresql.log.query_step

Statement step when using extended query protocol (one of statement, parse, bind or execute)

example: parse

postgresql.log.query_name

Name given to a query when using extended query protocol. If it is "<unnamed>", or not present, this field is ignored.

example: pdo_stmt_00000001

postgresql.log.error.code

Error code returned by Postgres (if any)

type: long

postgresql.log.timezone

type: alias

alias to: event.timezone

postgresql.log.thread_id

type: alias

alias to: process.pid

postgresql.log.user

type: alias

alias to: user.name

postgresql.log.level

type: alias

alias to: log.level

postgresql.log.message

type: alias

alias to: message