Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXPLAIN (ANALYZE, BUFFERS)
- with tagged as (
- SELECT "subscriptions".*
- FROM "subscriptions"
- WHERE "subscriptions"."project_id" = 12345
- AND "subscriptions"."trashed_at" IS NULL
- AND ((tags @> ARRAY['crt:2020_02']::varchar[]))
- )
- select *
- from tagged
- ORDER BY created_at DESC
- LIMIT 30 OFFSET 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement