Re: GIN JSONB path index is not always used

2023-10-23 Thread Tomasz Szymański
Sorry for missing analyze and buffers, we did only had these plans at the time, providing ones performed with such: When it does us an index: --+ Limit (cost=255.29..32

Re: GIN JSONB path index is not always used

2023-10-23 Thread Jeff Janes
On Mon, Oct 23, 2023 at 6:33 AM Tomasz Szymański wrote: > Limit (cost=0.00..1184.30 rows=21 width=4) (actual > time=1567.136..1619.956 rows=1 loops=1) >-> Seq Scan on account_user (cost=0.00..256768.27 rows=4553 width=4) > (actual time=1567.135..1619.953 rows=1 loops=1) > It thinks the