QUERY PLAN Limit (cost=0.85..9258.41 rows=61 width=2162) (actual time=2.352..33.389 rows=61 loops=1) -> Nested Loop (cost=0.85..4025217.24 rows=26523 width=2162) (actual time=2.351..33.376 rows=61 loops=1) -> Index Scan using products_pinned_at_listed_at_ix on products (cost=0.43..3929423.12 rows=26523 width=1463) (actual time=2.325..32.872 rows=61 loops=1) Filter: ((desc_tsv @@ '''nike'':*'::tsquery) AND (status = 'published'::prod_status)) Rows Removed by Filter: 3376 -> Index Scan using shops_pkey on shops (cost=0.42..3.61 rows=1 width=699) (actual time=0.006..0.006 rows=1 loops=61) Index Cond: (id = products.shop_id) Planning Time: 5.115 ms Execution Time: 33.509 ms