From: | "Timmer, Marius" <marius(dot)timmer(at)uni-muenster(dot)de> |
---|---|
To: | pgsql-hackerspostgresqlorg <pgsql-hackers(at)postgresql(dot)org> |
Subject: | [PATCH] explain sortorder |
Date: | 2014-11-25 13:03:23 |
Message-ID: | F4FF595C-D39D-4036-A446-57C91ABE6B31@exchange.wwu.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello everyone,
For creating indexes on more than one column, it is useful to know the sort
order of each sort key. So now, if you run EXPLAIN in VERBOSE mode, you get
the sort order information in the order the sort keys are displayed - Lukas
- This patch is meant for discussion
- It’s against the master branch
- The patch compiles successfully and one test (inherit) is affected
- There are no platform-specific items in this patch
- The patch, as described, enhances EXPLAIN VERBOSE. For an example, see
the regression test
- There is no TODO item referring to this patch
@patchname: explain_sortorder v2
@version: 2.01
@author: Marius Timmer <mtimm_01(at)uni-muenster(dot)de>,
Arne Scheffer <arne(dot)scheffer(at)uni-muenster(dot)de>,
Lukas Kreft <lukaskreft(at)uni-muenster(dot)de>
@description: Display sort order options in VERBOSE mode of EXPLAIN
- The situation
Currently I am able to run a EXPLAIN-Statement (verbose) for getting more
Information about a Query. But it is not enough to check in which order the
results will be sorted, what could be interesting to modify some Statements
so they can become more performant.
- What this patch does
This patch will add one more information to the result of an EXPLAIN-
Statement in verbose-mode. You will find the new property "Sort order"
which tells you the order of the used keys while sorting.
You can use it in all available Formats.
Greetings,
Marius Timmer
Attachment | Content-Type | Size |
---|---|---|
explain_sortorder-v2.patch | application/octet-stream | 15.3 KB |
unknown_filename | text/plain | 142 bytes |
smime.p7s | application/pkcs7-signature | 4.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2014-11-25 13:23:31 | Re: Missing OOM checks in libpq (was Re: Replication connection URI?) |
Previous Message | Fujii Masao | 2014-11-25 12:53:10 | Re: The problems of PQhost() |