QUERY PLAN ------------------------------------------------------------------------------ Limit (cost=0.00..13700.25 rows=100 width=915) (actual time=0.013..0.114 rows=100 loops=1) -> Seq Scan on messages (cost=0.00..4085414.08 rows=29820 width=915) (actual time=0.013..0.106 rows=100 loops=1) Filter: ((context -> 'involved_parties'::text) @> '[{"id": 1, "type": 1}]'::jsonb) Planning time: 0.058 ms Execution time: 0.135 ms
Created
March 18, 2022 06:42
Optimized using sequential table scan with limit
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment