PgHero

Live Queries

10 queries

Pid Duration State
69669 00:08:00 idle in transaction
odoo 
SELECT *
                                       FROM ir_cron
                                       WHERE numbercall != 0
                                          AND active
                                          AND nextcall <= (now() at time zone 'UTC')
                                          AND id=8
                                       FOR UPDATE NOWAIT
69768 00:08:00 idle in transaction
odoo 
SELECT "ir_model"."id" as "id","ir_model"."info" as "info","ir_model"."create_uid" as "create_uid","ir_model"."create_date" as "create_date","ir_model"."write_date" as "write_date","ir_model"."transient" as "transient","ir_model"."model" as "model","ir_model"."is_mail_thread" as "is_mail_thread","ir_model"."state" as "state","ir_model"."name" as "name","ir_model"."write_uid" as "write_uid" FROM "ir_model" WHERE "ir_model".id IN (286)
69873 00:06:12 idle in transaction
odoo 
SELECT *
                                       FROM ir_cron
                                       WHERE numbercall != 0
                                          AND active
                                          AND nextcall <= (now() at time zone 'UTC')
                                          AND id=7
                                       FOR UPDATE NOWAIT
69988 00:01:00 idle in transaction
odoo 
SELECT *
                                       FROM ir_cron
                                       WHERE numbercall != 0
                                          AND active
                                          AND nextcall <= (now() at time zone 'UTC')
                                          AND id=15
                                       FOR UPDATE NOWAIT
69968 59.7 s idle in transaction
odoo 
SELECT "ir_model"."id" as "id","ir_model"."info" as "info","ir_model"."state" as "state","ir_model"."create_uid" as "create_uid","ir_model"."create_date" as "create_date","ir_model"."transient" as "transient","ir_model"."model" as "model","ir_model"."is_mail_thread" as "is_mail_thread","ir_model"."write_date" as "write_date","ir_model"."write_uid" as "write_uid","ir_model"."name" as "name" FROM "ir_model" WHERE "ir_model".id IN (286)
69929 56.4 s active
odoo 
SELECT "sale_order".id FROM "sale_order" WHERE (("sale_order"."warehouse_id" = 59)  AND  ("sale_order"."fo_state" = 'packed')) ORDER BY "sale_order"."date_order" ASC  limit 1
70148 7.2 s active
odoo 
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id") WHERE (("stock_move"."scrapped" IS NULL or "stock_move"."scrapped" = false )  AND  ("stock_move"."production_id" in (11080993))) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"
70147 7.2 s active
odoo 
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id") WHERE (("stock_move"."scrapped" IS NULL or "stock_move"."scrapped" = false )  AND  ("stock_move"."production_id" in (11080993))) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"
69860 7.2 s active
odoo 
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_picking" as "stock_move__picking_id" ON ("stock_move"."picking_id" = "stock_move__picking_id"."id") WHERE (("stock_move"."scrapped" IS NULL or "stock_move"."scrapped" = false )  AND  ("stock_move"."production_id" in (11080993))) ORDER BY "stock_move__picking_id"."priority" DESC,"stock_move__picking_id"."date" ASC,"stock_move__picking_id"."id" DESC,"stock_move"."sequence" ,"stock_move"."id"
69902 0.6 s idle in transaction
odoo 
 SELECT message_attachment_rel.message_id, message_attachment_rel.attachment_id FROM message_attachment_rel, "ir_attachment"
                    WHERE 1=1 AND message_attachment_rel.message_id IN (233272514, 233553191, 233553301, 235220213, 235220253, 235538886, 235538887, 235538888, 235538891, 235538892, 235538894, 235538901, 235538902, 235538903, 235538904, 235538908, 235538910, 235538912, 235538915, 235538919, 235538925, 235538931, 235538932, 235538933, 235538934, 235538935, 235538939, 235538940, 235538954, 235538955, 235538956, 235538957, 235538958, 235538961, 235538962, 235538972, 235538973, 235538974, 235538978, 235538979, 235538980, 235538986, 235538987, 235538988, 235538989, 235538990, 235538999, 235539000, 235539016, 235539017, 235539018, 235539021, 235539022, 235539023, 235539028, 235539029, 235539030, 235539031, 235539032, 235539036, 235539037, 235539056, 235539057, 235539061, 235539062, 235539065, 235539066, 235539069, 235539077, 235539078, 235539079, 235539080, 235539081, 235539082, 235539086, 2

You may need to restart your app servers afterwards.