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
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 |