Re: Selects query stats?
| От | Dan Gorman |
|---|---|
| Тема | Re: Selects query stats? |
| Дата | |
| Msg-id | 127D68F6-7620-4A62-8D1A-9B475E7571CD@hi5.com обсуждение исходный текст |
| Ответ на | Re: Selects query stats? (Mischa Sandberg <mischa@ca.sophos.com>) |
| Ответы |
Re: Selects query stats?
Re: Selects query stats? Re: Selects query stats? |
| Список | 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 themon 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 tochoose an index scan if your joining column's datatypes do notmatch
В списке pgsql-performance по дате отправления: