Ole Tange <[EMAIL PROTECTED]> writes:
> As I read it the output tells me what was done during the milliseconds:

No, you have a fundamental misconception here.  The notation means that
the first output row from a plan step was delivered after X
milliseconds, and the last row after Y milliseconds.

The "gap" you are looking at is the time to do the Sort (since a sort
can't deliver the first output row until it's finished the sort).

It is gonna take a while to sort 175000 rows ... but possibly increasing
sort_mem would help.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to