| From: | Jan Nielsen <jan(dot)sture(dot)nielsen(at)gmail(dot)com> |
|---|---|
| To: | legrand legrand <legrand_legrand(at)hotmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: SELECT performance drop |
| Date: | 2019-01-22 22:28:31 |
| Message-ID: | CANxH4hFR6+wjcWTjf_+MtW5iGkNq7yxLXKyyyeUtoiRZ+BuOFA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Jan 22, 2019 at 2:55 PM legrand legrand <legrand_legrand(at)hotmail(dot)com>
wrote:
> Hello,
> could you check that statistics for fm_session are accurate ?
>
> Regards
> PAscal
>
heroku pg:psql -c "SELECT schemaname, relname, last_analyze FROM
pg_stat_all_tables WHERE relname LIKE 'fm_%'"
schemaname | relname | last_analyze
------------+----------------+--------------
public | fm_account |
public | fm_allocation |
public | fm_approval |
public | fm_capital |
public | fm_grant |
public | fm_market |
public | fm_marketplace |
public | fm_order |
public | fm_person |
public | fm_session |
public | fm_trader |
I suspect you'd say "not accurate"? :-o After ANALYZE, the performance is
much better <https://explain.depesz.com/s/p9KX>. Thank you so much!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Finnerty | 2019-01-23 13:50:52 | Re: SELECT performance drop |
| Previous Message | legrand legrand | 2019-01-22 21:55:23 | Re: SELECT performance drop |