Postgres Pro
Downloads
Home   >   mailing lists

Re: Bad estimates - Mailing list pgsql-performance

From Don Seiler
Subject Re: Bad estimates
Date
Msg-id CAHJZqBCGV8Ke12RuOvZVs6E088UBY8CP=CoMQmJVfGEsM6yzDw@mail.gmail.com
Whole thread Raw
In response to Bad estimates  (Artur Zając <azajac@ang.com.pl>)
Responses RE: Bad estimates
List pgsql-performance
Tree view
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';

Don.

--
Don Seiler
www.seiler.us

pgsql-performance by date:

Previous
From: "Alex Ignatov"
Date:
Subject: RE: Query became very slow after 9.6 -> 10 upgrade
Next
From: Dmitry Shalashov
Date:
Subject: Re: Query became very slow after 9.6 -> 10 upgrade