Alvaro Herrera wrote:
Yeah, the problem seems underspecified.
So, Dan, the question is, what are you trying to measure?
This might be a statistic that management has always been given,
for Oracle, and you need to produce the "same" number for PostgreSQL.
If not, it's hard to figure out what a
On Tue, 2006-05-23 at 15:55 -0400, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > OTOH ISTM it would be easy to modify Postgres so as to count statements
> > in the stat collector, by turning pgstat_report_activity into a routine
> > that sent a count (presumably always 1) instead
On 5/23/06, Dan Gorman <[EMAIL PROTECTED]> wrote:
What I am looking for is that our DB is doing X selects a min.
If you're using 7.4, you can use log_duration to only log duration. It
won't log all the query text, only one short line per query. Then you
can use pgFouine to analyze this and havi
On Tue, May 23, 2006 at 03:50:01PM -0400, Alvaro Herrera wrote:
> Tom Lane wrote:
>
> > Counting individual statements would add overhead (which the OP already
> > declared unacceptable) and there are some definitional issues too, like
> > whether to count statements executed within functions.
>
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> OTOH ISTM it would be easy to modify Postgres so as to count statements
> in the stat collector, by turning pgstat_report_activity into a routine
> that sent a count (presumably always 1) instead of the query string, and
> then just add the count to a co
Tom Lane wrote:
> Counting individual statements would add overhead (which the OP already
> declared unacceptable) and there are some definitional issues too, like
> whether to count statements executed within functions.
Yeah, the problem seems underspecified. How do you count statements
added o
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Tue, May 23, 2006 at 11:33:12AM -0700, Dan Gorman wrote:
>> In any other DB (oracle, mysql) I know how many queries (selects) per
>> second the database is executing. How do I get this
>> number out of postgres?
> You can't. You also can't know how
Yeah, I'm not really concerned about the app or sys performance, just
a basic question of how do I get the rate of selects that are being
executed.
In a previous post from Jim, he noted it cannot be done. I am very
surprised postgres can't do this basic functionality. Does anyone
know if
On Tue, 2006-05-23 at 11:33 -0700, Dan Gorman wrote:
> In any other DB (oracle, mysql) I know how many queries (selects) per
> second the database is executing. How do I get this
> number out of postgres?
>
>
> I have a perl script that can test this, but no way the db tells me
> how fast it's g
On Tue, May 23, 2006 at 11:33:12AM -0700, Dan Gorman wrote:
> In any other DB (oracle, mysql) I know how many queries (selects) per
> second the database is executing. How do I get this
> number out of postgres?
You can't. You also can't know how many DML statements were executed
(though you can
In any other DB (oracle, mysql) I know how many queries (selects) per second the database is executing. How do I get this number out of postgres?I have a perl script that can test this, but no way the db tells me how fast it's going.(e.g. in oracle: select sum(executions) from v$sqlarea;)Regards,Da
Dan Gorman wrote:
What I am looking for is that our DB is doing X selects a min.
What specifically would you like to measure?
Duration for specific queries?
Queries in an app for which you have no source?
There may be a way to get what you want by other means ...
Details?
I gather you cannot j
What I am looking for is that our DB is doing X selects a min.
Turning on logging isn't an option as it will create too much IO in
our enviornment.
Regards,
Dan Gorman
On May 23, 2006, at 11:15 AM, Mischa Sandberg wrote:
Dan Gorman wrote:
All,
I might be completely crazy here, but it seem
Dan Gorman wrote:
All,
I might be completely crazy here, but it seems every other database
exposes select query stats. Postgres only exposes
updates/deletes/inserts. Is there something I am missing here?
Perhaps.
You can EXPLAIN ANALYZE a SELECT, just like i/u/d -- but then you
don't get th
All,
I might be completely crazy here, but it seems every other database
exposes select query stats. Postgres only exposes updates/deletes/
inserts. Is there something I am missing here?
Best Regards,
Dan Gorman
---(end of broadcast)---
TIP 9
that worked like a champ nice call as always!
thanks
Tim Jones
Healthcare Project Manager
Optio Software, Inc.
(770) 576-3555
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, May 22, 2006 7:07 PM
To: Tim Jones
Cc: pgsql-performance@postgresql.org
Subject: Re: [
16 matches
Mail list logo
