Re: SELECT performance drop

With Pascal's suggestion, I added a new index:

CREATE INDEX fm_order_sid_type_idx ON fm_order (session_id, type);

which improved the query to 2mS!

https://explain.depesz.com/s/oxvs

Thank you, Pascal!

On Thu, Jan 24, 2019 at 9:52 AM Jan Nielsen <jan(dot)sture(dot)nielsen(at)gmail(dot)com>
wrote:

>
>
> 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
>
>