Re: Buffers option

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: hmidi slim <hmidi(dot)slim2(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Buffers option
Date: 2017-11-24 12:46:35
Message-ID: CAKoxK+44WVs4uxsY0pmOwEAzry1bJPXYCZRBLzwvLJ6Y8TCFhg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 24, 2017 at 12:30 PM, hmidi slim <hmidi(dot)slim2(at)gmail(dot)com> wrote:
> I didn't get the number of read and hit buffers when I rexecute the query
> many times.How can I Fix that? and I tried the options costs, timing and I
> got the same plan query however when trying the option format json it works.

Not sure but I see a lot of nodes 'never executed' and 'rows=0' on the
first loop. Could it be the optimzer did not execute nothing at all?

Luca

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Lazurkin 2017-11-24 13:06:18 Re: Implementation of gtrgm_out for gevel
Previous Message hmidi slim 2017-11-24 11:30:47 Buffers option