5. PostgreSQL Transaction Counter

For PostgreSQL the connection parameters are the same as the schema options. The refresh rate determines the sampling interval.

Figure 6.6. PostgreSQL TX Counter Options

PostgreSQL TX Counter Options

The following SQL is used to sample the transaction rate.

select sum(xact_commit + xact_rollback) from pg_stat_database