From: Mischa Sandberg <mischa@ca.sophos.com>
To: pgsql-performance@postgresql.org
Subject: Re: Selects query stats?
Date: Tue, 23 May 2006 11:32:28 -0700
Message-ID: <4473553C.1010804@ca.sophos.com> (raw)
In-Reply-To: <82252882-2A15-4823-A517-7AB3161889D1@hi5.com>
References: <9C4E40CF-6C06-4297-AF32-A7EF2A3F3C0F@hi5.com>
<4473512E.7020805@ca.sophos.com>
<82252882-2A15-4823-A517-7AB3161889D1@hi5.com>
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mischa@ca.sophos.com
Subject: Re: Selects query stats?
In-Reply-To: <4473553C.1010804@ca.sophos.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox