Skip site navigation (1) Skip section navigation (2)

Re: Selects query stats?

From: Dan Gorman <dgorman(at)hi5(dot)com>
To: mischa(at)ca(dot)sophos(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Selects query stats?
Date: 2006-05-23 18:33:12
Message-ID: 127D68F6-7620-4A62-8D1A-9B475E7571CD@hi5.com (view raw or flat)
Thread:
Lists: pgsql-performance
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,
Dan Gorman




On May 23, 2006, at 11:32 AM, Mischa Sandberg wrote:

> 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 just time the app that's doing the selects,
> nor extract those selects and run them via psql and time them
> on their own?
>
>>> 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?
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match

In response to

Responses

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2006-05-23 18:41:00
Subject: Re: Selects query stats?
Previous:From: Mischa SandbergDate: 2006-05-23 18:32:28
Subject: Re: Selects query stats?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group