PGBouncer インテグレーションのメトリクス

PGBouncer の監視に使う Datadog の公式インテグレーションです。収集するメトリクスは 44 件あります。

公式の紹介文 (英語)

Track connection pool metrics and monitor traffic to and from your application.

種別の内訳

  • gauge (その時点の値): 37 件
  • rate (1 秒あたりの値): 7 件

メトリクスの一覧

説明は公式の定義の英文をそのまま載せています。

メトリクス種別単位
pgbouncer.clients.connect_timeWhen the connection was made (seconds since epoch)gaugesecond
pgbouncer.clients.prepared_statementsThe number of prepared statements that the client has preparedgaugequery
pgbouncer.clients.request_timeWhen last request was issued (seconds since epoch)gaugesecond
pgbouncer.clients.waitCurrent waiting time in secondsgaugesecond
pgbouncer.clients.wait_usThe microsecond portion of the current waiting timegaugemicrosecond
pgbouncer.databases.current_connectionsCurrent number of connections for this databasegaugeconnection
pgbouncer.databases.max_connectionsMaximum number of allowed connectionsgaugeconnection
pgbouncer.databases.pool_sizeMaximum number of server connectionsgaugeconnection
pgbouncer.max_client_connThe maximum number of client connections allowed.gaugeconnection
pgbouncer.pools.cl_activeClient connections linked to server connection and able to process queriesgaugeconnection
pgbouncer.pools.cl_waitingClient connections waiting on a server connectiongaugeconnection
pgbouncer.pools.maxwaitHow long the first (oldest) client in the queue has waited, in secondsgaugesecond
pgbouncer.pools.maxwait_usMicrosecond part of the maximum waiting timegaugemicrosecond
pgbouncer.pools.sv_activeServer connections linked to a client connectiongaugeconnection
pgbouncer.pools.sv_idleServer connections idle and ready for a client querygaugeconnection
pgbouncer.pools.sv_loginServer connections currently in the process of logging ingaugeconnection
pgbouncer.pools.sv_testedServer connections currently running either server_reset_query or server_check_querygaugeconnection
pgbouncer.pools.sv_usedServer connections idle more than server_check_delay, needing server_check_querygaugeconnection
pgbouncer.servers.connect_timeWhen the connection was made (seconds since epoch)gaugesecond
pgbouncer.servers.prepared_statementsThe number of prepared statements that are prepared on the server, limited by the max_prepared_statements settinggaugequery
pgbouncer.servers.request_timeWhen last request was issued (seconds since epoch)gaugesecond
pgbouncer.stats.avg_bind_countThe average number of prepared statements readied for execution by clients and forwarded to PostgreSQL per second in last stat periodgaugequery/second
pgbouncer.stats.avg_client_parse_countThe average number of prepared statements created by clients per second in last stat periodgaugequery/second
pgbouncer.stats.avg_queryThe average query durationgaugemicrosecond
pgbouncer.stats.avg_query_countThe average number of queries per second in last stat periodgaugequery/second
pgbouncer.stats.avg_query_timeThe average query durationgaugemicrosecond
pgbouncer.stats.avg_recvThe client network traffic receivedgaugebyte/second
pgbouncer.stats.avg_reqThe average number of requests per second in last stat periodgaugerequest/second
pgbouncer.stats.avg_sentThe client network traffic sentgaugebyte/second
pgbouncer.stats.avg_server_parse_countThe average number of prepared statements created by pgbouncer on a server per second in last stat periodgaugequery/second
pgbouncer.stats.avg_transaction_countThe average number of transactions per second in last stat periodgaugetransaction/second
pgbouncer.stats.avg_transaction_timeThe average transaction durationgaugemicrosecond
pgbouncer.stats.avg_wait_timeTime spent by clients waiting for a server, in microseconds (average per second)gaugemicrosecond
pgbouncer.stats.bind_count_per_secondThe rate of prepared statements readied for execution by clients and forwarded to PostgreSQLgaugequery/second
pgbouncer.stats.bytes_received_per_secondThe total network traffic receivedratebyte/second
pgbouncer.stats.bytes_sent_per_secondThe total network traffic sentratebyte/second
pgbouncer.stats.client_parse_count_per_secondThe rate of prepared statements created by clientsgaugequery/second
pgbouncer.stats.queries_per_secondThe query rateratequery/second
pgbouncer.stats.requests_per_secondThe request rateraterequest/second
pgbouncer.stats.server_parse_count_per_secondThe rate of prepared statements created by pgbouncer on a servergaugequery/second
pgbouncer.stats.total_query_timeTime spent by pgbouncer actively querying PostgreSQLratemicrosecond
pgbouncer.stats.total_transaction_timeTime spent by pgbouncer in transactionsratemicrosecond
pgbouncer.stats.total_wait_timeTime spent by clients waiting for a server, in microsecondsgaugemicrosecond
pgbouncer.stats.transactions_per_secondThe transaction rateratetransaction/second

公式ドキュメント

PGBouncer インテグレーションの公式ドキュメント

メトリクスの名前と説明は Datadog の公式インテグレーションの定義 (Copyright Datadog, Inc.・BSD-3-Clause) を英文のまま載せています。利用条件の全文は サイトについてにあります。