1 |
pg_postmaster |
start_time_seconds |
GAUGE |
Time at which postmaster started |
2 |
pg_replication |
|
|
|
|
|
lag |
GAUGE |
Replication lag behind master in seconds |
|
|
is_replica |
GAUGE |
Indicates if this host is a slave |
3 |
pg_stat_user_tables |
|
|
|
|
|
datname |
LABEL |
Name of current database |
|
|
schemaname |
LABEL |
Name of the schema that this table is in |
|
|
relname |
LABEL |
Name of this table |
|
|
seq_scan |
COUNTER |
Number of sequential scans initiated on this table |
|
|
seq_tup_read |
COUNTER |
Number of live rows fetched by sequential scans |
|
|
idx_scan |
COUNTER |
Number of index scans initiated on this table |
|
|
idx_tup_fetch |
COUNTER |
Number of live rows fetched by index scans |
|
|
n_tup_ins |
COUNTER |
Number of rows inserted |
|
|
n_tup_upd |
COUNTER |
Number of rows updated |
|
|
n_tup_del |
COUNTER |
Number of rows deleted |
|
|
n_tup_hot_upd |
COUNTER |
Number of rows HOT updated (i.e., with no separate index update required) |
|
|
n_live_tup |
GAUGE |
Estimated number of live rows |
|
|
n_dead_tup |
GAUGE |
Estimated number of dead rows |
|
|
n_mod_since_analyze |
GAUGE |
Estimated number of rows changed since last analyze |
|
|
last_vacuum |
GAUGE |
Last time at which this table was manually vacuumed (not counting VACUUM FULL) |
|
|
last_autovacuum |
GAUGE |
Last time at which this table was vacuumed by the autovacuum daemon |
|
|
last_analyze |
GAUGE |
Last time at which this table was manually analyzed |
|
|
last_autoanalyze |
GAUGE |
Last time at which this table was analyzed by the autovacuum daemon |
|
|
vacuum_count |
COUNTER |
Number of times this table has been manually vacuumed (not counting VACUUM FULL) |
|
|
autovacuum_count |
COUNTER |
Number of times this table has been vacuumed by the autovacuum daemon |
|
|
analyze_count |
COUNTER |
Number of times this table has been manually analyzed |
|
|
autoanalyze_count |
COUNTER |
Number of times this table has been analyzed by the autovacuum daemon |
4 |
pg_statio_user_tables |
|
|
|
|
|
datname |
LABEL |
Name of current database |
|
|
schemaname |
LABEL |
Name of the schema that this table is in |
|
|
relname |
LABEL |
Name of this table |
|
|
heap_blks_read |
COUNTER |
Number of disk blocks read from this table |
|
|
heap_blks_hit |
COUNTER |
Number of buffer hits in this table |
|
|
idx_blks_read |
COUNTER |
Number of disk blocks read from all indexes on this table |
|
|
idx_blks_hit |
COUNTER |
Number of buffer hits in all indexes on this table |
|
|
toast_blks_read |
COUNTER |
Number of disk blocks read from this table’s TOAST table (if any) |
|
|
toast_blks_hit |
COUNTER |
Number of buffer hits in this table’s TOAST table (if any) |
|
|
tidx_blks_read |
COUNTER |
Number of disk blocks read from this table’s TOAST table indexes (if any) |
|
|
tidx_blks_hit |
COUNTER |
Number of buffer hits in this table’s TOAST table indexes (if any) |
5 |
pg_database |
|
|
|
|
|
datname |
LABEL |
Name of the database |
|
|
size_bytes |
GAUGE |
Disk space used by the database |
6 |
pg_archiver |
|
|
|
|
|
pending_wal_count |
GAUGE |
No. of pending WAL files to be archived |
7 |
pg_stat_user_indexes |
|
|
|
|
|
schemaname |
LABEL |
Name of the schema that this table is in |
|
|
relname |
LABEL |
Name of the table for this index |
|
|
indexrelname |
LABEL |
Name of this index |
|
|
idx_scan |
COUNTER |
Number of index scans initiated on this index |
|
|
idx_tup_read |
COUNTER |
Number of index entries returned by scans on this index |
|
|
idx_tup_fetch |
COUNTER |
Number of live table rows fetched by simple index scans using this index |
8 |
pg_statio_user_indexes |
|
|
|
|
|
schemaname |
LABEL |
Name of the schema that this table is in |
|
|
relname |
LABEL |
Name of the table for this index |
|
|
indexrelname |
LABEL |
Name of this index |
|
|
idx_blks_read |
COUNTER |
Number of disk blocks read from this index |
|
|
idx_blks_hit |
COUNTER |
Number of buffer hits in this index |
9 |
pg_total_relation_size |
|
|
|
|
|
datname |
LABEL |
Database name |
|
|
schemaname |
LABEL |
Name of the schema that this table is in |
|
|
relname |
LABEL |
Name of this table |
|
|
bytes |
GAUGE |
total disk space usage for the specified table and associated indexes |
10 |
pg_blocked |
|
|
|
|
|
type |
LABEL |
The lock type |
|
|
datname |
LABEL |
Database name |
|
|
schemaname |
LABEL |
The schema on which a query is blocked |
|
|
reltype |
LABEL |
The type of relation |
|
|
relname |
LABEL |
The relation on which a query is blocked |
|
|
queries |
GAUGE |
The current number of blocked queries |
11 |
pg_oldest_blocked |
|
|
|
|
|
age_seconds |
GAUGE |
Largest number of seconds any transaction is currently waiting on a lock |
|
|
datname |
LABEL |
Database name |
12 |
pg_slow |
|
|
|
|
|
queries |
GAUGE |
Current number of slow queries |
|
|
datname |
LABEL |
Database name |
13 |
pg_long_running_transactions |
|
|
|
|
|
datname |
LABEL |
Database name |
|
|
queries |
GAUGE |
Current number of long running transactions |
|
|
age_in_seconds |
GAUGE |
The current maximum transaction age in seconds |
14 |
pg_vacuum |
|
|
|
|
|
datname |
LABEL |
Database name |
|
|
queries |
GAUGE |
The current number of VACUUM queries |
|
|
age_in_seconds |
GAUGE |
The current maximum VACUUM query age in seconds |
15 |
pg_vacuum_analyze |
|
|
|
|
|
datname |
LABEL |
Database name |
|
|
queries |
GAUGE |
The current number of VACUUM ANALYZE queries |
|
|
age_in_seconds |
GAUGE |
The current maximum VACUUM ANALYZE query age in seconds |
16 |
pg_stuck_idle_in_transaction |
|
|
|
|
|
datname |
LABEL |
Database name |
|
|
queries |
GAUGE |
Current number of queries that are stuck being idle in transactions |
17 |
pg_txid |
|
|
|
|
|
current |
COUNTER |
Current 64-bit transaction id of the query used to collect this metric (truncated to low 52 bits) |
|
|
xmin |
COUNTER |
Oldest transaction id of a transaction still in progress, i.e. not known committed or aborted (truncated to low 52 bits) |
|
|
xmin_age |
GAUGE |
Age of oldest transaction still not committed or aborted measured in transaction ids |
18 |
pg_database_datfrozenxid |
|
|
|
|
|
datname |
LABEL |
Database name |
|
|
age |
GAUGE |
Age of the oldest transaction that has not been frozen |
19 |
pg_wal_position |
|
|
|
|
|
bytes |
COUNTER |
Postgres LSN (log sequence number) being generated on primary or replayed on replica (truncated to low 52 bits) |
20 |
pg_replication_slots |
|
|
|
|
|
slot_name |
LABEL |
Slot Name |
|
|
slot_type |
LABEL |
Slot Type |
|
|
active |
GAUGE |
Boolean flag indicating whether this slot has a consumer streaming from it |
|
|
xmin_age |
GAUGE |
Age of oldest transaction that cannot be vacuumed due to this replica |
|
|
catalog_xmin_age |
GAUGE |
Age of oldest transaction that cannot be vacuumed from catalogs due to this replica (used by logical replication) |
|
|
restart_lsn_bytes |
GAUGE |
Amount of data on in xlog that must be this replica may need to complete recovery |
|
|
confirmed_flush_lsn_bytes |
GAUGE |
Amount of data on in xlog that must be this replica has not yet received |
21 |
pg_stat_ssl |
|
|
|
|
|
pid |
LABEL |
Process ID of a backend or WAL sender process |
|
|
active |
GAUGE |
Boolean flag indicating if SSL is used on this connection |
|
|
bits |
GAUGE |
Number of bits in the encryption algorithm is in use |
|
|
compression |
GAUGE |
Boolean flag indicating if SSL compression is in use |
22 |
pg_table_bloat |
|
|
|
|
|
datname |
LABEL |
Database name |
|
|
schemaname |
LABEL |
Schema name |
|
|
tablename |
LABEL |
Table name |
|
|
real_size |
GAUGE |
Table real size |
|
|
extra_size |
GAUGE |
Estimated extra size not used/needed in the table. This extra size is composed by the fillfactor, bloat and alignment padding spaces |
|
|
extra_ratio |
GAUGE |
Estimated ratio of the real size used by extra_size |
|
|
fillfactor |
GAUGE |
Table fillfactor |
|
|
bloat_size |
GAUGE |
Estimated size of the bloat without the extra space kept for the fillfactor |
|
|
bloat_ratio |
GAUGE |
Estimated ratio of the real size used by bloat_size |
|
|
is_na |
GAUGE |
Estimation not aplicable, If true, do not trust the stats |
23 |
pg_index |
|
|
|
|
|
datname |
LABEL |
Database name |
|
|
schema_name |
LABEL |
Schema name |
|
|
tblname |
LABEL |
Table name |
|
|
idxname |
LABEL |
Index Name |
|
|
real_size |
GAUGE |
Index size |
|
|
extra_size |
GAUGE |
Index extra size |
|
|
extra_ratio |
GAUGE |
Index extra ratio |
|
|
fillfactor |
GAUGE |
Fillfactor |
|
|
bloat_size |
GAUGE |
Estimate index bloat size |
|
|
bloat_ratio |
GAUGE |
Estimate index bloat size ratio |
|
|
is_na |
GAUGE |
Estimate Not aplicable, bad statistic |
24 |
pg_replication_status |
|
|
|
|
|
application_name |
LABEL |
Application or node name |
|
|
client_addr |
LABEL |
Client ip address |
|
|
state |
LABEL |
Client replication state |
|
|
lag_size_bytes |
GAUGE |
Replication lag size in bytes |