On Mon, Aug 12, 2013 at 3:34 PM, Daniel Gomez Blanco <nanodgb@gmail.com> wrote:
Hello,
Is there a way I can get the number of queries per second on a PostgreSQL database? I'm talking about the average number since the server, or the statistics collector, was started.
I have to generate a report for the database usage in my company. We chose queries per second as one of the metrics because it could be obtained for both MySQL (no transaction metrics are recorded) and Oracle (it can be easily calculated). Although it's not an optimal measure of the performance of a database, it gives an estimation of the total usage of the infrastructure.
I know in PostgreSLQ I can get the number of transactions executed or rolled back using pg_stat_database. But is there any way I can calculate the number of queries/executions?
You can generate these kind of statistics after analyzing database server log file with "PgBadger" Module.