postgres_exporter SQL解析

定义变量名称

pg_stat_bgwriter

"checkpoints_timed":     {COUNTER, "Number of scheduled checkpoints that have been performed", nil, nil},
"checkpoints_req":       {COUNTER, "Number of requested checkpoints that have been performed", nil, nil},
"checkpoint_write_time": {COUNTER, "Total amount of time that has been spent in the portion of checkpoint processing where files are written to disk, in milliseconds", nil, nil},
"checkpoint_sync_time":  {COUNTER, "Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk, in milliseconds", nil, nil},
"buffers_checkpoint":    {COUNTER, "Number of buffers written during checkpoints", nil, nil},
"buffers_clean":         {COUNTER, "Number of buffers written by the background writer", nil, nil},
"maxwritten_clean":      {COUNTER, "Number of times the background writer stopped a cleaning scan because it had written too many buffers", nil, nil},
"buffers_backend":       {COUNTER, "Number of buffers written directly by a backend", nil, nil},
"buffers_backend_fsync": {COUNTER, "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)", nil, nil},
"buffers_alloc":         {COUNTER, "Number of buffers allocated", nil, nil},
"stats_reset":           {COUNTER, "Time at which these statistics were last reset", nil, nil},

pg_stat_database

"datid":          {LABEL, "OID of a database", nil, nil},
"datname":        {LABEL, "Name of this database", nil, nil},
"numbackends":    {GAUGE, "Number of backends currently connected to this database. This is the only column in this view that returns a value reflecting current state; all other columns return the accumulated values since the last reset.", nil, nil},
"xact_commit":    {COUNTER, "Number of transactions in this database that have been committed", nil, nil},
"xact_rollback":  {COUNTER, "Number of transactions in this database that have been rolled back", nil, nil},
"blks_read":      {COUNTER, "Number of disk blocks read in this database", nil, nil},
"blks_hit":       {COUNTER, "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)", nil, nil},
"tup_returned":   {COUNTER, "Number of rows returned by queries in this database", nil, nil},
"tup_fetched":    {COUNTER, "Number of rows fetched by queries in this database", nil, nil},
"tup_inserted":   {COUNTER, "Number of rows inserted by queries in this database", nil, nil},
"tup_updated":    {COUNTER, "Number of rows updated by queries in this database", nil, nil},
"tup_deleted":    {COUNTER, "Number of rows deleted by queries in this database", nil, nil},
"conflicts":      {COUNTER, "Number of queries canceled due to conflicts with recovery in this database. (Conflicts occur only on standby se