Re: SELECT performance drop
| От | Jan Nielsen |
|---|---|
| Тема | Re: SELECT performance drop |
| Дата | |
| Msg-id | CANxH4hFR6+wjcWTjf_+MtW5iGkNq7yxLXKyyyeUtoiRZ+BuOFA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: SELECT performance drop (legrand legrand <legrand_legrand@hotmail.com>) |
| Ответы |
RE:SELECT performance drop
|
| Список | pgsql-performance |
On Tue, Jan 22, 2019 at 2:55 PM legrand legrand <legrand_legrand@hotmail.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. Thank you so much!
В списке pgsql-performance по дате отправления: