I need to monitor the DB performance on a distributed system with multiple databases. Some of the database servers use pgbouncer to pool connections and in those servers I can connect to pgbouncer and execute a SHOW STATS; command to retrieve certain statistics, I'm interested in the following:

avg_req | avg_recv | avg_sent | avg_query

 563 |  1080453 |  2060908 |     57718

The columns means:

avg_req Average requests per second in last stat period.

avg_recv Average received (from clients) bytes per second.

avg_sent Average sent (to clients) bytes per second.

avg_query Average query duration in microseconds.

Now my question is, is there a way of gathering this information without using pgbouncer on a postgresql server?

I need to monitor the DB performance on a distributed system with multiple databases. Some of the database servers use pgbouncer to pool connections and in those servers I can connect to pgbouncer and execute a SHOW STATS; command to retrieve certain statistics, I'm interested in the following:

 avg_req | avg_recv | avg_sent | avg_query
------------------------------------------
     563 |  1080453 |  2060908 |     57718

The columns means:

• avg_req
  Average requests per second in last stat period.
• avg_recv
  Average received (from clients) bytes per second.
• avg_sent
  Average sent (to clients) bytes per second.
• avg_query
  Average query duration in microseconds.

Now my question is, is there a way of gathering this information without using pgbouncer on a postgresql server?