Module for parsing the PostgreSQL log files.
Fields from PostgreSQL logs.
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