Postgres Pro
Downloads
Home   >   mailing lists

Re: What am I missing? Explain row estimate wrong - Mailing list pgsql-admin

From Feike Steenbergen
Subject Re: What am I missing? Explain row estimate wrong
Date
Msg-id CAK_s-G2Bkn=A5dzgBa5CsgFy=xhDePbPw0ou_iaV-aerTgRvDA@mail.gmail.com
Whole thread Raw
In response to What am I missing? Explain row estimate wrong  (Jorge Torralba <jorge.torralba@gmail.com>)
List pgsql-admin
Tree view
> select histogram_bounds from pg_stats where tablename ='mytable' and attname = 'id';        

Do any of the < 12345 values appear in the most_common_vals (mcv) list? 
https://www.postgresql.org/docs/current/static/view-pg-stats.html

To my knowledge, mcv entries are calculated first, and then the histogram bounds are taken into account:
https://www.postgresql.org/docs/current/static/row-estimation-examples.html  
     

pgsql-admin by date:

Previous
From: xujian
Date:
Subject: Re: open database on read only file system
Next
From: "David G. Johnston"
Date:
Subject: Re: open database on read only file system