Re: Buffers option - Mailing list pgsql-general

From Luca Ferrari
Subject Re: Buffers option
Date
Msg-id CAKoxK+44WVs4uxsY0pmOwEAzry1bJPXYCZRBLzwvLJ6Y8TCFhg@mail.gmail.com
Whole thread Raw
In response to Buffers option  (hmidi slim <hmidi.slim2@gmail.com>)
Responses Re: Buffers option
List pgsql-general
On Fri, Nov 24, 2017 at 12:30 PM, hmidi slim <hmidi.slim2@gmail.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


pgsql-general by date:

Previous
From: hmidi slim
Date:
Subject: Buffers option
Next
From: Dmitry Lazurkin
Date:
Subject: Re: Implementation of gtrgm_out for gevel