| 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" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: SELECT performance drop |
| Date: | 2019-01-24 16:52:03 |
| Message-ID: | CANxH4hGKLRzeyajh1ZQPhkveCgNHDuiatof-HOWXDJ4kbnJPzQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Jan 23, 2019 at 12:37 PM legrand legrand <
legrand_legrand(at)hotmail(dot)com> wrote:
> Hi,
> is there an index on
> fm_order(session_id,type)?
>
There isn't at the moment:
table_name | index_name | column_name
----------------+------------------------------+-------------
fm_account | fm_account_pkey | id
fm_account | uk_5p6qalvucbxmw9u64wf0aif9d | name
fm_allocation | fm_allocation_pkey | id
fm_approval | fm_approval_pkey | id
fm_capital | fm_capital_pkey | id
fm_grant | fm_grant_pkey | id
fm_market | fm_market_pkey | id
fm_marketplace | fm_marketplace_pkey | id
fm_order | fm_order_pkey | id
fm_person | fm_person_pkey | id
fm_session | fm_session_pkey | id
fm_trader | fm_trader_pkey | id
>
> regards
> PAscal
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Nielsen | 2019-01-24 18:04:57 | Re: SELECT performance drop |
| Previous Message | Arne Roland | 2019-01-24 14:44:41 | RE: dsa_allocate() faliure |