PgHero

Live Queries

4 queries

Pid Duration State
2829907 00:07:22 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
2831430 00:01:03 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
2831818 2.3 s active
odoo
DELETE FROM material_requisition_add WHERE id IN (7552, 7553, 7554, 7555, 7556, 7557, 7558, 7559, 7560, 7561, 7562, 7563, 7564, 7565, 7566, 7567, 7568, 7569, 7570, 7571, 7572, 7573, 7574, 7575, 7576, 7577, 7578, 7579, 7580, 7581, 7582, 7583, 7584, 7585, 7586, 7587, 7588, 7589, 7590, 7591, 7592, 7593, 7594, 7595, 7596, 7597, 7598, 7599, 7600, 7601, 7602, 7603, 7604, 7605, 7606, 7607, 7608, 7609, 7610, 7611, 7612, 7613, 7614, 7615, 7616, 7617, 7618, 7619, 7620, 7621, 7622, 7623, 7624, 7625, 7626, 7627, 7628, 7629, 7630, 7631, 7632, 7633, 7701, 7634, 7635, 7636, 7637, 7638, 7639, 7640, 7641, 7642, 7643, 7644, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7653, 7654, 7655, 7656, 7657, 7658, 7659, 7660, 7661, 7662, 7663, 7664, 7665, 7702, 7666, 7703, 7667, 7668, 7669, 7670, 7671, 7672, 7673, 7674, 7675, 7676, 7677, 7678, 7679, 7680, 7704, 7705, 7706, 7681, 7682, 7683, 7684, 7685, 7686, 7687, 7688, 7689, 7690, 7691, 7692, 7693, 7694, 7695, 7696, 7697, 7698, 7699, 7700, 7707, 7708, 7709, 7710, 7711, 7712, 7713, 7
2830732 0.0 s idle in transaction
odoo
SELECT "stock_scrap"."id" as "id","stock_scrap"."scrap_location_id" as "scrap_location_id","stock_scrap"."is_swk_scrap" as "is_swk_scrap","stock_scrap"."value" as "value","stock_scrap"."origin" as "origin","stock_scrap"."owner_id" as "owner_id","stock_scrap"."currency_id" as "currency_id","stock_scrap"."date" as "date","stock_scrap"."production_id" as "production_id","stock_scrap"."value_food" as "value_food","stock_scrap"."move_id" as "move_id","stock_scrap"."warehouse_id" as "warehouse_id","stock_scrap"."scrap_qty" as "scrap_qty","stock_scrap"."product_id" as "product_id","stock_scrap"."workorder_id" as "workorder_id","stock_scrap"."value_nonfood" as "value_nonfood","stock_scrap"."picking_id" as "picking_id","stock_scrap"."create_uid" as "create_uid","stock_scrap"."state" as "state","stock_scrap"."create_date" as "create_date","stock_scrap"."product_uom_id" as "product_uom_id","stock_scrap"."kitchen_ticket" as "kitchen_ticket","stock_scrap"."write_date" as "write_date","stock_scrap"."date_expected" as "dat

You may need to restart your app servers afterwards.