PgHero

Live Queries

4 queries

Pid Duration State
4003445 00:04:45 idle in transaction
odoo
SELECT *
                                       FROM ir_cron
                                       WHERE numbercall != 0
                                          AND active
                                          AND nextcall <= (now() at time zone 'UTC')
                                          AND id=1
                                       FOR UPDATE NOWAIT
4004035 00:02:57 idle in transaction
odoo
SELECT *
                                       FROM ir_cron
                                       WHERE numbercall != 0
                                          AND active
                                          AND nextcall <= (now() at time zone 'UTC')
                                          AND id=17
                                       FOR UPDATE NOWAIT
4003366 30.3 s active
odoo
DELETE FROM mrp_product_produce WHERE id IN (9966249, 9966250, 9966251, 9966252, 9966253, 9967548, 9966255, 9966256, 9966257, 9966258, 9966259, 9966260, 9966261, 9966262, 9966263, 9966264, 9966265, 9966266, 9966267, 9966268, 9966269, 9966270, 9966271, 9966272, 9966273, 9966274, 9966275, 9966276, 9966277, 9966278, 9966279, 9966280, 9966281, 9966282, 9966283, 9966284, 9966285, 9966286, 9966287, 9966288, 9966289, 9966290, 9966291, 9966292, 9966293, 9966294, 9966295, 9966296, 9966297, 9966298, 9966299, 9966300, 9966301, 9966302, 9966303, 9965279, 9965280, 9966304, 9966746, 9966747, 9966748, 9966749, 9966750, 9966751, 9966752, 9966753, 9966754, 9966755, 9966756, 9966757, 9966758, 9966759, 9966760, 9966761, 9966762, 9966763, 9966764, 9966765, 9966766, 9966767, 9966768, 9966769, 9966770, 9966771, 9966772, 9966773, 9966774, 9966775, 9966776, 9966777, 9966778, 9966779, 9966780, 9966781, 9966782, 9966783, 9966784, 9966785, 9966786, 9966787, 9966788, 9966789, 9966790, 9966791, 9966792, 9966793, 9966794, 9966795, 996679
4003868 0.1 s idle in transaction
odoo
SELECT "stock_scrap"."id" as "id","stock_scrap"."lot_id" as "lot_id","stock_scrap"."state" as "state","stock_scrap"."date_expected" as "date_expected","stock_scrap"."scrap_ticket_id" as "scrap_ticket_id","stock_scrap"."scrap_location_id" as "scrap_location_id","stock_scrap"."initial_quantity" as "initial_quantity","stock_scrap"."is_swk_scrap" as "is_swk_scrap","stock_scrap"."package_id" as "package_id","stock_scrap"."company_id" as "company_id","stock_scrap"."name" as "name","stock_scrap"."production_id" as "production_id","stock_scrap"."date" as "date","stock_scrap"."variation" as "variation","stock_scrap"."origin" as "origin","stock_scrap"."write_uid" as "write_uid","stock_scrap"."owner_id" as "owner_id","stock_scrap"."currency_id" as "currency_id","stock_scrap"."product_id" as "product_id","stock_scrap"."workorder_id" as "workorder_id","stock_scrap"."value" as "value","stock_scrap"."move_id" as "move_id","stock_scrap"."warehouse_id" as "warehouse_id","stock_scrap"."create_date" as "create_date","stock_scr

You may need to restart your app servers afterwards.