PgHero

Live Queries

7 queries

Pid Duration State
570194 0.6 s idle in transaction
/home/application/bundle/ruby/3.4.0/bin/sidekiq ankipro
UPDATE "text_to_speeches" SET "audio_file" = 'ttsen-US_8869f858c5b16400a05ce2f3a197de595b910d26f8ff8fc98459b51a226cebda.mp320260428-1-z9fhwm', "updated_at" = '2026-04-28 12:07:21.984449' WHERE "text_to_speeches"."id" = 1305403
1274308 0.0 s active
/home/application/bundle/ruby/3.4.0/bin/pitchfork ankipro
WITH subtree_decks AS ( SELECT id, ancestry FROM v2.decks WHERE (id IN (30685410) OR ancestry LIKE '/30685410/%') AND state NOT IN (1,4,6) ), min_next_reviews AS ( SELECT deck_id, MIN(next_review_at) AS min_next_review_at FROM v2.card_progresses WHERE deck_id IN (SELECT id FROM subtree_decks) AND user_id = 5772036 AND frozen = false GROUP BY deck_id ) SELECT sd.id AS deck_id, sd.ancestry, mn.min_next_review_at FROM subtree_decks sd LEFT JOIN min_next_reviews mn ON sd.id = mn.deck_id
205761 0.0 s active
/home/application/bundle/ruby/3.4.0/bin/pitchfork ankipro
SELECT "v2"."decks"."id" FROM "v2"."decks" WHERE ("v2"."decks"."ancestry" LIKE '/29952748/32197401/%' OR "v2"."decks"."id" = 32197401) AND "v2"."decks"."state" != 6
1131027 0.0 s active
/home/application/bundle/ruby/3.4.0/bin/pitchfork ankipro
SELECT "v2"."card_progresses"."id", "v2"."card_progresses"."ease_factor", "v2"."card_progresses"."frozen", "v2"."card_progresses"."interval", "v2"."card_progresses"."learning_state", "v2"."card_progresses"."learning_steps_index", "v2"."card_progresses"."next_review_at", "v2"."card_progresses"."ordinal", "v2"."card_progresses"."raw_next_review_at", "v2"."card_progresses"."to_learn_in_current_sl_round", "v2"."card_progresses"."note_id", "v2"."card_progresses"."user_id", "v2"."card_progresses"."created_at", "v2"."card_progresses"."updated_at", "v2"."card_progresses"."fetch_priority", "v2"."card_progresses"."deck_id", "v2"."card_progresses"."undo_data" FROM "v2"."card_progresses" WHERE "v2"."card_progresses"."note_id" IN (6171562109, 6171562108, 6171562107, 6171562106) AND "v2"."card_progresses"."ordinal" IN (0, 0, 0, 0) AND "v2"."card_progresses"."user_id" = 2405588
2836135 -0.0 s idle in transaction
/home/application/bundle/ruby/3.4.0/bin/pitchfork ankipro
BEGIN
1130816 -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" = 'deck_clone' LIMIT 1 FOR UPDATE SKIP LOCKED
2836220 -0.0 s idle in transaction
/home/application/bundle/ruby/3.4.0/bin/pitchfork ankipro
UPDATE "users" SET "updated_at" = '2026-04-28 12:07:22.694139', "metadata" = '{"deck_added":true,"ai_gen_with_prompt":4,"created_cards_count":5097,"studied_cards_count":16641,"last_learning_session":1777378042}' WHERE "users"."id" = 3572006

You may need to restart your app servers afterwards.