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

2020-04-14 Thread Pavel Stehule
ú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 St

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

2020-04-14 Thread Julien Rouhaud
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=# E

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

2020-04-14 Thread Pavel Stehule
ú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 > >> > > >> > I

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

2020-04-14 Thread Pavel Stehule
ú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 = 'CZ0201';

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

2020-04-14 Thread Julien Rouhaud
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 = > > > 'C

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

2020-04-14 Thread Julien Rouhaud
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 >> > understan

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

2020-04-14 Thread Amit Langote
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

2020-04-14 Thread Pavel Stehule
ú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

2020-04-14 Thread Julien Rouhaud
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, ANALY

Display of buffers for planning time show nothing for second run

2020-04-14 Thread Pavel Stehule
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, ANALYZE) SELECT * FROM obce WHERE okres_id = 'CZ0201'; ┌──