Re: explain analyze faster then query

2018-11-25 Thread Justin Pryzby
On Sun, Nov 25, 2018 at 03:37:46PM +0200, Mariel Cherkassky wrote: > I run it from inside the machine on the local database. > For example : > > db=# create table rule_test as select generate_series(1,1); > SELECT 1 > db=# explain analyze select generate_series from rule_test orde

Re: explain analyze faster then query

2018-11-25 Thread Mariel Cherkassky
I run it from inside the machine on the local database. For example : db=# create table rule_test as select generate_series(1,1); SELECT 1 db=# explain analyze select generate_series from rule_test order by generate_series asc;

Re: explain analyze faster then query

2018-11-25 Thread Justin Pryzby
Cc: pgsql-performance@lists.postgresql.org, pgsql-ad...@lists.postgresql.org Please avoid simultaneously sending the same question to multiple lists. It means that people can't see each others replies and everything that implies. On Sun, Nov 25, 2018 at 03:08:33PM +0200, Mariel Cherkassk