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

[8.0.0] Deprecated in 8.0.0.

Core id. (deprecated, there is no core_id in PostgreSQL logs, this is actually session_line_number).

type: alias

alias to: postgresql.log.session_line_number

postgresql.log.client_addr

Host where the connection originated from.

example: 127.0.0.1

postgresql.log.client_port

Port where the connection originated from.

example: 59700

postgresql.log.session_id

PostgreSQL session.

example: 5ff1dd98.22

postgresql.log.session_line_number

Line number inside a session. (%l in log_line_prefix).

type: long

postgresql.log.database

Name of database.

example: postgres

postgresql.log.query

Query statement. In the case of CSV parse, look at command_tag to get more context.

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

Type of session’s current command. The complete list can be found at: src/include/tcop/cmdtaglist.h

example: SELECT

postgresql.log.session_start_time

Time when this session started.

type: date

postgresql.log.virtual_transaction_id

Backend local transaction id.

postgresql.log.transaction_id

The id of current transaction.

type: long

postgresql.log.sql_state_code

State code returned by Postgres (if any). See also https://www.postgresql.org/docs/current/errcodes-appendix.html

type: keyword

postgresql.log.detail

More information about the message, parameters in case of a parametrized query. e.g. Role \"user\" does not exist., parameters: $1 = 42, etc.

postgresql.log.hint

A possible solution to solve an error.

postgresql.log.internal_query

Internal query that led to the error (if any).

postgresql.log.internal_query_pos

Character count of the internal query (if any).

type: long

postgresql.log.context

Error context.

postgresql.log.query_pos

Character count of the error position (if any).

type: long

postgresql.log.location

Location of the error in the PostgreSQL source code (if log_error_verbosity is set to verbose).

postgresql.log.application_name

Name of the application of this event. It is defined by the client.

postgresql.log.backend_type

Type of backend of this event. Possible types are autovacuum launcher, autovacuum worker, logical replication launcher, logical replication worker, parallel worker, background writer, client backend, checkpointer, startup, walreceiver, walsender and walwriter. In addition, background workers registered by extensions may have additional types.

example: client backend

postgresql.log.error.code

[8.0.0] Deprecated in 8.0.0.

Error code returned by Postgres (if any). Deprecated: errors can have letters. Use sql_state_code instead.

type: alias

alias to: postgresql.log.sql_state_code

postgresql.log.timezone

type: alias

alias to: event.timezone

postgresql.log.user

type: alias

alias to: user.name

postgresql.log.level

Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, INFO, NOTICE, WARNING, ERROR, LOG, FATAL, and PANIC.

type: alias

example: LOG

alias to: log.level

postgresql.log.message

type: alias

alias to: message