Re: Queries/executions per second

On Mon, Aug 12, 2013 at 3:34 PM, Daniel Gomez Blanco <nanodgb(at)gmail(dot)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.

http://dalibo.github.io/pgbadger/

Thanks & Regards
Raghu Ram