Advertisement
Guest User

Untitled

a guest
Feb 28th, 2020
215
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. EXPLAIN (ANALYZE, BUFFERS)
  2. with tagged as (
  3. SELECT "subscriptions".*
  4. FROM "subscriptions"
  5. WHERE "subscriptions"."project_id" = 12345
  6. AND "subscriptions"."trashed_at" IS NULL
  7. AND ((tags @> ARRAY['crt:2020_02']::varchar[]))
  8. )
  9. select *
  10. from tagged
  11. ORDER BY created_at DESC
  12. LIMIT 30 OFFSET 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement