IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.

› ›

PostgreSQL fields

edit

PostgreSQL fields

edit

Module for parsing the PostgreSQL log files.

postgresql fields

edit

Fields from PostgreSQL logs.

log fields

edit

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.

« Osquery fields Redis fields »