Collector reference

System

cpu

Collects:

• average cpu usage (in percent)

Default cron: every 5 minutes

virtual_memory

Collects:

• total memory (in bytes)
• available memory (in bytes)

Default cron: every 5 minutes

swap_memory

Collects:

• total swap memory (in bytes)
• available swap memory (in bytes)

Default cron: every 5 minutes

disk

Collects:

• total disk space (sum of all partitions) (in bytes)
• available disk space (sum of all partitions) (in bytes)
• reads count (sum of all partitions)
• writes count (sum of all partitions)
• bytes read (sum of all partitions)
• bytes written (sum of all partitions)

Default cron: every 5 minutes

network

Collects:

• total received bytes (IN)
• total sent bytes (OUT)

Default cron: every 5 minutes

load

Supported only in linux.

Collects:

• 1 minute load
• 5 minutes load
• 15 minutes load

Default cron: every 5 minutes

Postgres

pg_stat_statements

Collects statistics about statements execution. For each statement, following data is gathered:

• statement text
• user who executed the statement
• number of times executed
• average time spent in the statement (in milliseconds)
• minimum time spent in the statement (in milliseconds)
• maximum time spent in the statement (in milliseconds)
• total number of shared block cache hits by the statement
• total number of shared blocks read by the statement
• total number of local block cache hits by the statement
• total number of local blocks read by the statement

Default cron: every hour

pg_stat_activity

Collects information about each currently connected backend. For each backend, following data is gathered:

• process ID of a backend
• user who is logged into a backend
• name of the application that is connected to a backend
• IP address of the client connected to a backend
• name of the database a backend is connected to
• current overall state of this backend
• type of event for which the backend is waiting, if any
• wait event name if backend is currently waiting
• text of a backend's most recent query
• time when the currently active query was started

Default cron: every hour

pg_stat_user_tables

Collects information about each user-defined table. For each table, following data is gathered:

• Table name (in format schema.table)
• Number of sequential scans initiated on this table
• Number of live rows fetched by sequential scans
• Number of index scans initiated on this table
• Number of live rows fetched by index scans
• Estimated number of live rows
• Estimated number of dead rows
• Number of rows inserted
• Number of rows updated (includes HOT updated rows)
• Number of rows deleted
• Last time at which this table was manually vacuumed (not counting VACUUM FULL)
• Last time at which this table was vacuumed by the autovacuum daemon
• Last time at which this table was manually analyzed
• Last time at which this table was analyzed by the autovacuum daemon
• Number of times this table has been manually vacuumed (not counting VACUUM FULL)
• Number of times this table has been vacuumed by the autovacuum daemon
• Number of times this table has been manually analyzed
• Number of times this table has been analyzed by the autovacuum daemon

Default cron: every hour

pg_stat_user_indexes

Collects information about each user-defined index. For each index, following data is gathered:

• Table name (in format schema.table)
• Index name
• Number of index scans initiated on this index
• Number of index entries returned by scans on this index
• Number of live table rows fetched by simple index scans using this index

Default cron: every hour

pg_locks

Collects statistics about current database locks:

• Number of granted locks
• Number of not granted locks As well as processes which are blocking SQL statements. For each not granted lock, following data is gathered:
• Pid of blocked process
• Blocked user name
• Blocked application name
• Blocked client IP address
• Blocked database name
• Time when the blocked statement started
• Blocked statement text
• Pid of blocking process
• Blocking user name
• Blocking application name
• Blocking client IP address
• Blocking database name
• Blocking lock mode
• Blocking statement text

Default cron: every hour

pg_stat_archiver

Collects information about WAL archiver process's activity:

• Number of WAL files that have been successfully archived
• Time of the last successful archive operation
• Number of failed attempts for archiving WAL files
• Time of the last failed archival operation

Default cron: every hour