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

explain analyze faster then query

2018-11-25 Thread Mariel Cherkassky
Hi, I'm using postgres 9.6. I have a table with 100M+ records which consume on disk about 8GB. In addition I have an index on the id column of the table. When I run in psql : explain analyze select id from my_table order by id The query returns output after 130 seconds which is great. The plan that