PgHero

Live Queries

12 queries

Pid Duration State
1370707 0.7 s active
/home/application/bundle/ruby/3.4.0/bin/sidekiq ankipro
SELECT DISTINCT "users"."id" AS alias_0, "users"."id" FROM "users" LEFT OUTER JOIN "devices" ON "devices"."user_id" = "users"."id" WHERE (last_seen_time > '2026-05-15 18:10:00.291431' OR last_seen_time IS NULL) AND "devices"."firebase_token" IS NOT NULL AND "users"."timezone_offset" IN (600, 0, -120, -240, -270) AND "users"."id" > 2785996 ORDER BY "users"."id" ASC LIMIT 500
1370706 0.7 s active
/home/application/bundle/ruby/3.4.0/bin/sidekiq ankipro
SELECT DISTINCT "users"."id" AS alias_0, "users"."id" FROM "users" LEFT OUTER JOIN "devices" ON "devices"."user_id" = "users"."id" WHERE (last_seen_time > '2026-05-15 18:10:00.291431' OR last_seen_time IS NULL) AND "devices"."firebase_token" IS NOT NULL AND "users"."timezone_offset" IN (600, 0, -120, -240, -270) AND "users"."id" > 2785996 ORDER BY "users"."id" ASC LIMIT 500
1370704 0.7 s active
/home/application/bundle/ruby/3.4.0/bin/sidekiq ankipro
SELECT DISTINCT "users"."id" AS alias_0, "users"."id" FROM "users" LEFT OUTER JOIN "devices" ON "devices"."user_id" = "users"."id" WHERE (last_seen_time > '2026-05-15 18:10:00.291431' OR last_seen_time IS NULL) AND "devices"."firebase_token" IS NOT NULL AND "users"."timezone_offset" IN (600, 0, -120, -240, -270) AND "users"."id" > 2785996 ORDER BY "users"."id" ASC LIMIT 500
508196 0.7 s active
/home/application/bundle/ruby/3.4.0/bin/sidekiq ankipro
SELECT DISTINCT "users"."id" AS alias_0, "users"."id" FROM "users" LEFT OUTER JOIN "devices" ON "devices"."user_id" = "users"."id" WHERE (last_seen_time > '2026-05-15 18:10:00.291431' OR last_seen_time IS NULL) AND "devices"."firebase_token" IS NOT NULL AND "users"."timezone_offset" IN (600, 0, -120, -240, -270) AND "users"."id" > 2785996 ORDER BY "users"."id" ASC LIMIT 500
1370721 0.7 s active
/home/application/bundle/ruby/3.4.0/bin/sidekiq ankipro
SELECT DISTINCT "users"."id" AS alias_0, "users"."id" FROM "users" LEFT OUTER JOIN "devices" ON "devices"."user_id" = "users"."id" WHERE (last_seen_time > '2026-05-15 18:10:00.291431' OR last_seen_time IS NULL) AND "devices"."firebase_token" IS NOT NULL AND "users"."timezone_offset" IN (600, 0, -120, -240, -270) AND "users"."id" > 2785996 ORDER BY "users"."id" ASC LIMIT 500
1370716 0.7 s active
/home/application/bundle/ruby/3.4.0/bin/sidekiq ankipro
SELECT DISTINCT "users"."id" AS alias_0, "users"."id" FROM "users" LEFT OUTER JOIN "devices" ON "devices"."user_id" = "users"."id" WHERE (last_seen_time > '2026-05-15 18:10:00.291431' OR last_seen_time IS NULL) AND "devices"."firebase_token" IS NOT NULL AND "users"."timezone_offset" IN (600, 0, -120, -240, -270) AND "users"."id" > 2785996 ORDER BY "users"."id" ASC LIMIT 500
1370713 0.7 s active
/home/application/bundle/ruby/3.4.0/bin/sidekiq ankipro
SELECT DISTINCT "users"."id" AS alias_0, "users"."id" FROM "users" LEFT OUTER JOIN "devices" ON "devices"."user_id" = "users"."id" WHERE (last_seen_time > '2026-05-15 18:10:00.291431' OR last_seen_time IS NULL) AND "devices"."firebase_token" IS NOT NULL AND "users"."timezone_offset" IN (600, 0, -120, -240, -270) AND "users"."id" > 2785996 ORDER BY "users"."id" ASC LIMIT 500
1370710 0.7 s active
/home/application/bundle/ruby/3.4.0/bin/sidekiq ankipro
SELECT DISTINCT "users"."id" AS alias_0, "users"."id" FROM "users" LEFT OUTER JOIN "devices" ON "devices"."user_id" = "users"."id" WHERE (last_seen_time > '2026-05-15 18:10:00.291431' OR last_seen_time IS NULL) AND "devices"."firebase_token" IS NOT NULL AND "users"."timezone_offset" IN (600, 0, -120, -240, -270) AND "users"."id" > 2785996 ORDER BY "users"."id" ASC LIMIT 500
1873542 0.0 s active
/home/application/bundle/ruby/3.4.0/bin/pitchfork ankipro
SELECT notes.id, notes.deck_id, notes.template_kind, notes.fields, notes.cards_count, notes.css, notes.created_at, notes.source FROM v2.notes AS notes WHERE notes.deck_id IN (32143489,31800660,34796171,32599221,28621592,32073699,33842947,29656498,33144475,29062993,33937703,33182579,33555074,29136653,33213968,29317473,28388826,32144216,29062917,32120749,33213965,33842711,34796194,29427280,26458810,33555078,28389055,34901031,29105878,26458816,32604281,31574391,31942401,31882107,32489988,28388813,33935132,31574370,31942793,33213962,33937421,32002927,34313933,32002622,33183760,31942036,33522147,33842610,33842607,34797586,34797198,29656099,31800656,34009529) ORDER BY notes.created_at DESC, notes.id DESC OFFSET 0 LIMIT 20;
2379564 -0.0 s active
/home/application/bundle/ruby/3.4.0/bin/pitchfork ankipro
SELECT "v2"."deck_counters"."id", "v2"."deck_counters"."recalculate_at", "v2"."deck_counters"."deck_id" FROM "v2"."deck_counters" WHERE "v2"."deck_counters"."deck_id" IN (35831671, 35831790, 35831657, 35831807, 35832002, 35831691, 35831758, 35831966, 35832226, 35831651) AND "v2"."deck_counters"."user_id" = 10221542
1151939 -0.0 s idle in transaction
/home/application/bundle/ruby/3.4.0/bin/rake ankipro
SELECT 1 AS one FROM "solid_queue_ready_executions" WHERE "solid_queue_ready_executions"."queue_name" = 'apptweet' LIMIT 1 FOR UPDATE SKIP LOCKED
339948 -0.0 s active
/home/application/bundle/ruby/3.4.0/bin/pitchfork ankipro
SELECT "users"."id", "users"."analytics_id", "users"."uid", "users"."apple_auth", "users"."timezone_offset", "users"."created_at", "users"."updated_at", "users"."onboarding_data", "users"."experiments", "users"."locale", "users"."provider", "users"."email", "users"."password_digest", "users"."current_app_version", "users"."premium", "users"."reset_password_token", "users"."reset_password_sent_at", "users"."app_features", "users"."metadata", "users"."name", "users"."username", "users"."avatar_color", "users"."country_code", "users"."qr_token", "users"."qr_token_expires_at", "users"."last_seen_time", "users"."last_seen_ip", "users"."qon_id", "users"."stripe_customer_id", "users"."avatar", "users"."first_destroy_reminder_sent", "users"."second_destroy_reminder_sent", "users"."generated", "users"."new_architecture", "users"."state", "users"."idfa", "users"."aaid", "users"."about", "users"."funnel_fox_id", "users"."referral_code", "users"."paywall_d0_discount_shown_at", "users"."paywall_d4_discount_shown_at", "us

You may need to restart your app servers afterwards.