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: [email protected], [email protected] 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