Re: Bad estimates

From: Don Seiler <don(at)seiler(dot)us>
To: Artur Zając <azajac(at)ang(dot)com(dot)pl>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Bad estimates
Date: 2017-11-22 14:49:04
Message-ID: CAHJZqBCGV8Ke12RuOvZVs6E088UBY8CP=CoMQmJVfGEsM6yzDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dmitry Shalashov 2017-11-22 14:51:22 Re: Query became very slow after 9.6 -> 10 upgrade
Previous Message Alex Ignatov 2017-11-22 14:44:18 RE: Query became very slow after 9.6 -> 10 upgrade