From: Don Seiler [mailto:don@seiler.us] Sent: Wednesday, November 22, 2017 5:49 PM To: Artur Zając <azajac@ang.com.pl> Cc: pgsql-performance@lists.postgresql.org Subject: Re: Bad estimates
I'm assuming you never analyzed the table after creation & data load? What does this show you:
select * from pg_stat_all_tables where relname='xyz';