Re: Display of buffers for planning time show nothing for second run

út 14. 4. 2020 v 11:35 odesílatel Julien Rouhaud napsal: > On Tue, Apr 14, 2020 at 11:25 AM Pavel Stehule > wrote: > > > > út 14. 4. 2020 v 10:40 odesílatel Amit Langote > napsal: > >> > >> On Tue, Apr 14, 2020 at 5:27 PM Julien Rouhaud > wrote: > >> > On Tue, Apr 14, 2020 at 10:18 AM Pavel

Re: Display of buffers for planning time show nothing for second run

On Tue, Apr 14, 2020 at 11:25 AM Pavel Stehule wrote: > > út 14. 4. 2020 v 10:40 odesílatel Amit Langote > napsal: >> >> On Tue, Apr 14, 2020 at 5:27 PM Julien Rouhaud wrote: >> > On Tue, Apr 14, 2020 at 10:18 AM Pavel Stehule >> > wrote: >> > > For second run I get >> > > >> > > postgres=#

Re: Display of buffers for planning time show nothing for second run

út 14. 4. 2020 v 10:49 odesílatel Julien Rouhaud napsal: > On Tue, Apr 14, 2020 at 10:36 AM Pavel Stehule > wrote: > > > > út 14. 4. 2020 v 10:27 odesílatel Julien Rouhaud > napsal: > >> > >> Hi, > >> > >> On Tue, Apr 14, 2020 at 10:18 AM Pavel Stehule > wrote: > >> > > >> > Hi > >> > > >> >

Re: Display of buffers for planning time show nothing for second run

út 14. 4. 2020 v 10:40 odesílatel Amit Langote napsal: > On Tue, Apr 14, 2020 at 5:27 PM Julien Rouhaud wrote: > > On Tue, Apr 14, 2020 at 10:18 AM Pavel Stehule > wrote: > > > For second run I get > > > > > > postgres=# EXPLAIN (BUFFERS, ANALYZE) SELECT * FROM obce WHERE > okres_id =

Re: Display of buffers for planning time show nothing for second run

On Tue, Apr 14, 2020 at 10:40 AM Amit Langote wrote: > > On Tue, Apr 14, 2020 at 5:27 PM Julien Rouhaud wrote: > > On Tue, Apr 14, 2020 at 10:18 AM Pavel Stehule > > wrote: > > > For second run I get > > > > > > postgres=# EXPLAIN (BUFFERS, ANALYZE) SELECT * FROM obce WHERE okres_id = > > >

Re: Display of buffers for planning time show nothing for second run

On Tue, Apr 14, 2020 at 10:36 AM Pavel Stehule wrote: > > út 14. 4. 2020 v 10:27 odesílatel Julien Rouhaud napsal: >> >> Hi, >> >> On Tue, Apr 14, 2020 at 10:18 AM Pavel Stehule >> wrote: >> > >> > Hi >> > >> > I am testing some features from Postgres 13, and I am not sure if I >> >

Re: Display of buffers for planning time show nothing for second run

On Tue, Apr 14, 2020 at 5:27 PM Julien Rouhaud wrote: > On Tue, Apr 14, 2020 at 10:18 AM Pavel Stehule > wrote: > > For second run I get > > > > postgres=# EXPLAIN (BUFFERS, ANALYZE) SELECT * FROM obce WHERE okres_id = > > 'CZ0201'; > >

Re: Display of buffers for planning time show nothing for second run

út 14. 4. 2020 v 10:27 odesílatel Julien Rouhaud napsal: > Hi, > > On Tue, Apr 14, 2020 at 10:18 AM Pavel Stehule > wrote: > > > > Hi > > > > I am testing some features from Postgres 13, and I am not sure if I > understand well to behave of EXPLAIN(ANALYZE, BUFFERS) > > > > When I run following

Re: Display of buffers for planning time show nothing for second run

Hi, On Tue, Apr 14, 2020 at 10:18 AM Pavel Stehule wrote: > > Hi > > I am testing some features from Postgres 13, and I am not sure if I > understand well to behave of EXPLAIN(ANALYZE, BUFFERS) > > When I run following statement first time in session I get > > postgres=# EXPLAIN (BUFFERS,