From: | Daniel Gomez Blanco <nanodgb(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Queries/executions per second |
Date: | 2013-08-12 10:04:00 |
Message-ID: | CAL4HELeGfAO9sB8C1YQ=mY9UVgRLGC=JPjFCPik0OdCnHA2rEA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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?
Cheers,
Daniel
From | Date | Subject | |
---|---|---|---|
Next Message | raghu ram | 2013-08-12 10:08:41 | Re: Queries/executions per second |
Previous Message | Tom Lane | 2013-08-10 14:23:33 | Re: LEFT JOIN problem |