-- Slow query from New Relic
SELECT  tickets.id, tickets.last_reply_at FROM "tickets"  WHERE "tickets"."company_id" = 6814 AND "tickets"."spam" = 'f' AND "tickets"."state" != 2 AND "tickets"."trash" = 'f' AND "tickets"."processed" = 't' AND "tickets"."state" = 3 ORDER BY "tickets"."last_reply_at" ASC LIMIT 20 OFFSET 0
EXPLAIN (ANALYZE, COSTS, BUFFERS, VERBOSE) SELECT  tickets.id, tickets.last_reply_at FROM "tickets"  WHERE "tickets"."company_id" = 6814 AND "tickets"."spam" = 'f' AND "tickets"."state" != 2 AND "tickets"."trash" = 'f' AND "tickets"."processed" = 't' AND "tickets"."state" = 3 ORDER BY "tickets"."last_reply_at" ASC LIMIT 20 OFFSET 0;

-- Slow query from Postgres' log
EXPLAIN (ANALYZE, COSTS, BUFFERS, VERBOSE) SELECT  tickets.id, tickets.last_reply_at FROM "tickets"  WHERE "tickets"."company_id" = 6814 AND "tickets"."spam" = 'f' AND "tickets"."state" != 2 AND "tickets"."trash" = 'f' AND "tickets"."processed" = 't' AND "tickets"."state" = 1 AND (("tickets"."private" = 'f' OR ("tickets"."user_assignee" = 3970597 OR "tickets"."group_assignee" IN (SELECT "user_groups"."group_id" FROM "user_groups"  WHERE "user_groups"."user_id" = 3970597)))) ORDER BY "tickets"."last_reply_at" ASC LIMIT 20 OFFSET 0;

-- Slow query I posted in a Github issue
EXPLAIN (ANALYZE, VERBOSE, BUFFERS, COSTS) SELECT COUNT(*) FROM "tickets" INNER JOIN "ticket_labels" ON "ticket_labels"."ticket_id" = "tickets"."id" WHERE "tickets"."company_id" = 6814 AND "tickets"."spam" = 'f' AND "tickets"."state" != 2 AND "tickets"."trash" = 'f' AND "tickets"."processed" = 't' AND "tickets"."state" = 1 AND (("ticket_labels"."label_id" = 16192 AND "ticket_labels"."company_id" = 6814));

-- Another slow query from Postgres' log at peak load
EXPLAIN (ANALYZE, VERBOSE, BUFFERS, COSTS) SELECT tickets.id, tickets.last_reply_at FROM "tickets"  WHERE "tickets"."company_id" = 6814 AND "tickets"."spam" = 'f' AND "tickets"."state" != 2 AND "tickets"."trash" = 'f' AND "tickets"."processed" = 't' AND "tickets"."state" = 1 AND (("tickets"."private" = 'f' OR ("tickets"."user_assignee" = 3970597 OR "tickets"."group_assignee" IN (SELECT "user_groups"."group_id" FROM "user_groups"  WHERE "user_groups"."user_id" = 3970597)))) ORDER BY "tickets"."last_reply_at" ASC LIMIT 20 OFFSET 0;