cost of query done - recorded anywhere?

From: "Massa, Harald Armin" <chef(at)ghum(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: cost of query done - recorded anywhere?
Date: 2009-10-08 14:56:43
Message-ID: e3e180dc0910080756lbb88606x9619a4b8dc83c011@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I know that is possible via
EXPLAIN and EXPLAIN ANALYZE
to get planned and actual time for one query - but no results.

I am looking for information like:

"to do this query, I had to":

- read x <units> from disk/os.cache
- get n <units> from my own buffers
- do n1 comparisons of strings
- do n2 comparisons of inet
- sort n3 tuples via xxx-sort
- write z pages to disk
...
And I want to use the results as normal - so to say, have a logging "what is
the database really doing with all my hardwar" during normal operations.

Are those information available somewhere? Something like pg_buffercache on
steroids.
Something like the windows performance-monitor is logging for the whole
system.

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
%s is too gigantic of an industry to bend to the whims of reality

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Shane 2009-10-08 15:24:41 Tips/Hacks to create minial DB from the execution of several (simple) SQL requests.
Previous Message Leonardo M. Ramé 2009-10-08 13:58:05 Query inside RTF