- Metricbeat Reference: other versions:
- Overview
- Getting started with Metricbeat
- Setting up and running Metricbeat
- Upgrading Metricbeat
- How Metricbeat works
- Configuring Metricbeat
- Specify which modules to run
- Specify general settings
- Load external configuration files
- Configure the internal queue
- Configure the output
- Configure index lifecycle management
- Specify SSL settings
- Filter and enhance the exported data
- Define processors
- Add cloud metadata
- Add fields
- Add labels
- Add the local time zone
- Add tags
- Decode JSON fields
- Decode Base64 fields
- Decompress gzip fields
- Community ID Network Flow Hash
- Convert
- Drop events
- Drop fields from events
- Extract array
- Keep fields from events
- Registered Domain
- Rename fields from events
- Add Kubernetes metadata
- Add Docker metadata
- Add Host metadata
- Add Observer metadata
- Dissect strings
- DNS Reverse Lookup
- Add process metadata
- Parse data by using ingest node
- Enrich events with geoIP information
- Configure project paths
- Configure the Kibana endpoint
- Load the Kibana dashboards
- Load the Elasticsearch index template
- Configure logging
- Use environment variables in the configuration
- Autodiscover
- YAML tips and gotchas
- Regular expression support
- HTTP Endpoint
- metricbeat.reference.yml
- Beats central management
- Modules
- Aerospike module
- Apache module
- aws module
- Beat module
- Ceph module
- CockroachDB module
- consul module
- coredns module
- Couchbase module
- couchdb module
- Docker module
- Dropwizard module
- Elasticsearch module
- Elasticsearch ccr metricset
- Elasticsearch cluster_stats metricset
- Elasticsearch index metricset
- Elasticsearch index_recovery metricset
- Elasticsearch index_summary metricset
- Elasticsearch ml_job metricset
- Elasticsearch node metricset
- Elasticsearch node_stats metricset
- Elasticsearch pending_tasks metricset
- Elasticsearch shard metricset
- envoyproxy module
- Etcd module
- Golang module
- Graphite module
- HAProxy module
- HTTP module
- Jolokia module
- Kafka module
- Kibana module
- Kubernetes module
- Kubernetes apiserver metricset
- Kubernetes container metricset
- Kubernetes controllermanager metricset
- Kubernetes event metricset
- Kubernetes node metricset
- Kubernetes pod metricset
- Kubernetes proxy metricset
- Kubernetes scheduler metricset
- Kubernetes state_container metricset
- Kubernetes state_cronjob metricset
- Kubernetes state_deployment metricset
- Kubernetes state_node metricset
- Kubernetes state_pod metricset
- Kubernetes state_replicaset metricset
- Kubernetes state_statefulset metricset
- Kubernetes system metricset
- Kubernetes volume metricset
- kvm module
- Logstash module
- Memcached module
- MongoDB module
- MSSQL module
- Munin module
- MySQL module
- Nats module
- Nginx module
- Oracle module
- PHP_FPM module
- PostgreSQL module
- Prometheus module
- RabbitMQ module
- Redis module
- Statsd module
- System module
- System core metricset
- System cpu metricset
- System diskio metricset
- System entropy metricset
- System filesystem metricset
- System fsstat metricset
- System load metricset
- System memory metricset
- System network metricset
- System process metricset
- System process_summary metricset
- System raid metricset
- System socket metricset
- System socket_summary metricset
- System uptime metricset
- traefik module
- uwsgi module
- vSphere module
- Windows module
- ZooKeeper module
- Exported fields
- Aerospike fields
- Apache fields
- aws fields
- Beat fields
- Beat fields
- Ceph fields
- Cloud provider metadata fields
- CockroachDB fields
- Common fields
- consul fields
- coredns fields
- Couchbase fields
- couchdb fields
- Docker fields
- Docker fields
- Dropwizard fields
- ECS fields
- Elasticsearch fields
- envoyproxy fields
- Etcd fields
- Golang fields
- Graphite fields
- HAProxy fields
- Host fields
- HTTP fields
- Jolokia fields
- Jolokia Discovery autodiscover provider fields
- Kafka fields
- Kibana fields
- Kubernetes fields
- Kubernetes fields
- kvm fields
- Logstash fields
- Memcached fields
- MongoDB fields
- MSSQL fields
- Munin fields
- MySQL fields
- Nats fields
- Nginx fields
- Oracle fields
- PHP_FPM fields
- PostgreSQL fields
- Process fields
- Prometheus fields
- RabbitMQ fields
- Redis fields
- Statsd fields
- System fields
- traefik fields
- uwsgi fields
- vSphere fields
- Windows fields
- ZooKeeper fields
- Monitoring Metricbeat
- Securing Metricbeat
- Troubleshooting
- Get help
- Debug
- Common problems
- "open /compat/linux/proc: no such file or directory" error on FreeBSD
- Metricbeat collects system metrics for interfaces you didn’t configure
- Metricbeat uses too much bandwidth
- Error loading config file
- Found unexpected or unknown characters
- Logstash connection doesn’t work
- @metadata is missing in Logstash
- Not sure whether to use Logstash or Beats
- SSL client fails to connect to Logstash
- Monitoring UI shows fewer Beats than expected
- Contributing to Beats
PostgreSQL fields
editPostgreSQL fields
editMetrics collected from PostgreSQL servers.
postgresql
editPostgreSQL metrics.
activity
editOne document per server process, showing information related to the current activity of that process, such as state and current query. Collected by querying pg_stat_activity.
-
postgresql.activity.database.oid -
OID of the database this backend is connected to.
type: long
-
postgresql.activity.database.name -
Name of the database this backend is connected to.
type: keyword
-
postgresql.activity.pid -
Process ID of this backend.
type: long
-
postgresql.activity.user.id -
OID of the user logged into this backend.
type: long
-
postgresql.activity.user.name -
Name of the user logged into this backend.
-
postgresql.activity.application_name -
Name of the application that is connected to this backend.
-
postgresql.activity.client.address -
IP address of the client connected to this backend.
-
postgresql.activity.client.hostname -
Host name of the connected client, as reported by a reverse DNS lookup of client_addr.
-
postgresql.activity.client.port -
TCP port number that the client is using for communication with this backend, or -1 if a Unix socket is used.
type: long
-
postgresql.activity.backend_start -
Time when this process was started, i.e., when the client connected to the server.
type: date
-
postgresql.activity.transaction_start -
Time when this process' current transaction was started.
type: date
-
postgresql.activity.query_start -
Time when the currently active query was started, or if state is not active, when the last query was started.
type: date
-
postgresql.activity.state_change -
Time when the state was last changed.
type: date
-
postgresql.activity.waiting -
True if this backend is currently waiting on a lock.
type: boolean
-
postgresql.activity.state -
Current overall state of this backend. Possible values are:
- active: The backend is executing a query.
- idle: The backend is waiting for a new client command.
- idle in transaction: The backend is in a transaction, but is not currently executing a query.
- idle in transaction (aborted): This state is similar to idle in transaction, except one of the statements in the transaction caused an error.
- fastpath function call: The backend is executing a fast-path function.
- disabled: This state is reported if track_activities is disabled in this backend.
-
postgresql.activity.query -
Text of this backend’s most recent query. If state is active this field shows the currently executing query. In all other states, it shows the last query that was executed.
bgwriter
editStatistics about the background writer process’s activity. Collected using the pg_stat_bgwriter query.
-
postgresql.bgwriter.checkpoints.scheduled -
Number of scheduled checkpoints that have been performed.
type: long
-
postgresql.bgwriter.checkpoints.requested -
Number of requested checkpoints that have been performed.
type: long
-
postgresql.bgwriter.checkpoints.times.write.ms -
Total amount of time that has been spent in the portion of checkpoint processing where files are written to disk, in milliseconds.
type: float
-
postgresql.bgwriter.checkpoints.times.sync.ms -
Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk, in milliseconds.
type: float
-
postgresql.bgwriter.buffers.checkpoints -
Number of buffers written during checkpoints.
type: long
-
postgresql.bgwriter.buffers.clean -
Number of buffers written by the background writer.
type: long
-
postgresql.bgwriter.buffers.clean_full -
Number of times the background writer stopped a cleaning scan because it had written too many buffers.
type: long
-
postgresql.bgwriter.buffers.backend -
Number of buffers written directly by a backend.
type: long
-
postgresql.bgwriter.buffers.backend_fsync -
Number of times a backend had to execute its own fsync call (normally the background writer handles those even when the backend does its own write)
type: long
-
postgresql.bgwriter.buffers.allocated -
Number of buffers allocated.
type: long
-
postgresql.bgwriter.stats_reset -
Time at which these statistics were last reset.
type: date
database
editOne row per database, showing database-wide statistics. Collected by querying pg_stat_database
-
postgresql.database.oid -
OID of the database this backend is connected to.
type: long
-
postgresql.database.name -
Name of the database this backend is connected to.
type: keyword
-
postgresql.database.number_of_backends -
Number of backends currently connected to this database.
type: long
-
postgresql.database.transactions.commit -
Number of transactions in this database that have been committed.
type: long
-
postgresql.database.transactions.rollback -
Number of transactions in this database that have been rolled back.
type: long
-
postgresql.database.blocks.read -
Number of disk blocks read in this database.
type: long
-
postgresql.database.blocks.hit -
Number of times disk blocks were found already in the buffer cache, so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache, not the operating system’s file system cache).
type: long
-
postgresql.database.blocks.time.read.ms -
Time spent reading data file blocks by backends in this database, in milliseconds.
type: long
-
postgresql.database.blocks.time.write.ms -
Time spent writing data file blocks by backends in this database, in milliseconds.
type: long
-
postgresql.database.rows.returned -
Number of rows returned by queries in this database.
type: long
-
postgresql.database.rows.fetched -
Number of rows fetched by queries in this database.
type: long
-
postgresql.database.rows.inserted -
Number of rows inserted by queries in this database.
type: long
-
postgresql.database.rows.updated -
Number of rows updated by queries in this database.
type: long
-
postgresql.database.rows.deleted -
Number of rows deleted by queries in this database.
type: long
-
postgresql.database.conflicts -
Number of queries canceled due to conflicts with recovery in this database.
type: long
-
postgresql.database.temporary.files -
Number of temporary files created by queries in this database. All temporary files are counted, regardless of why the temporary file was created (e.g., sorting or hashing), and regardless of the log_temp_files setting.
type: long
-
postgresql.database.temporary.bytes -
Total amount of data written to temporary files by queries in this database. All temporary files are counted, regardless of why the temporary file was created, and regardless of the log_temp_files setting.
type: long
-
postgresql.database.deadlocks -
Number of deadlocks detected in this database.
type: long
-
postgresql.database.stats_reset -
Time at which these statistics were last reset.
type: date
statement
editOne document per query per user per database, showing information related invocation of that query, such as cpu usage and total time. Collected by querying pg_stat_statements.
-
postgresql.statement.user.id -
OID of the user logged into the backend that ran the query.
type: long
-
postgresql.statement.database.oid -
OID of the database the query was run on.
type: long
-
postgresql.statement.query.id -
ID of the statement.
type: long
-
postgresql.statement.query.text -
Query text
-
postgresql.statement.query.calls -
Number of times the query has been run.
type: long
-
postgresql.statement.query.rows -
Total number of rows returned by query.
type: long
-
postgresql.statement.query.time.total.ms -
Total number of milliseconds spent running query.
type: float
-
postgresql.statement.query.time.min.ms -
Minimum number of milliseconds spent running query.
type: float
-
postgresql.statement.query.time.max.ms -
Maximum number of milliseconds spent running query.
type: float
-
postgresql.statement.query.time.mean.ms -
Mean number of milliseconds spent running query.
type: long
-
postgresql.statement.query.time.stddev.ms -
Population standard deviation of time spent running query, in milliseconds.
type: long
-
postgresql.statement.query.memory.shared.hit -
Total number of shared block cache hits by the query.
type: long
-
postgresql.statement.query.memory.shared.read -
Total number of shared block cache read by the query.
type: long
-
postgresql.statement.query.memory.shared.dirtied -
Total number of shared block cache dirtied by the query.
type: long
-
postgresql.statement.query.memory.shared.written -
Total number of shared block cache written by the query.
type: long
-
postgresql.statement.query.memory.local.hit -
Total number of local block cache hits by the query.
type: long
-
postgresql.statement.query.memory.local.read -
Total number of local block cache read by the query.
type: long
-
postgresql.statement.query.memory.local.dirtied -
Total number of local block cache dirtied by the query.
type: long
-
postgresql.statement.query.memory.local.written -
Total number of local block cache written by the query.
type: long
-
postgresql.statement.query.memory.temp.read -
Total number of temp block cache read by the query.
type: long
-
postgresql.statement.query.memory.temp.written -
Total number of temp block cache written by the query.
type: long
On this page