PgHero

Live Queries

9 queries

Pid Duration State
565693 6.0 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 (10859799))) 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"  
564880 6.0 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 (10859799))) 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"  
565694 6.0 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 (10859799))) 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"  
565696 3.5 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"."raw_material_production_id" in (10859804))) 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"  
565210 3.5 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"."raw_material_production_id" in (10859804))) 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"  
565697 3.5 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"."raw_material_production_id" in (10859804))) 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"  
565209 -0.1 s idle in transaction
odoo
SELECT "ir_ui_view".id FROM "ir_ui_view" WHERE (((("ir_ui_view"."inherit_id" = 1023)  AND  ("ir_ui_view"."model" = 'product.template'))  AND  ("ir_ui_view"."mode" = 'extension'))  AND  ("ir_ui_view"."active" = true)) ORDER BY "ir_ui_view"."priority" ,"ir_ui_view"."id"  
564830 -0.1 s idle in transaction
odoo
SELECT "stock_warehouse".id FROM "stock_warehouse" WHERE ((("stock_warehouse"."active" = true)  AND  ("stock_warehouse"."view_location_id" in (605,2,9,8,1,19,21,22,24,20,23,43,45,47,44,46,48,25,27,29,28,26,30,11,15,12)))  AND  ("stock_warehouse"."view_location_id" in (1,11,12,13,14,16,537,539,540,541,538,542,37,39,40,41,38,42,17,415,418,417,416,419,420,133,137,138,136,134,135,73,77,75,78,74,76,648,650,651,649,652,653,586,588,589,590,587,591,672,673,674,677,675,676,678,679,680,683,681,682,684,685,686,689,687,688,560,563,564,565,562,561,593,595,596,597,594,598,85,88,89,86,90,87,31,34,36,33,35,32,333,337,336,335,338,334,67,70,69,68,72,71,103,106,108,104,105,107,517,519,520,522,521,518,487,489,490,492,491,488,445,447,448,450,449,446,523,525,526,528,527,524,493,495,496,498,497,494,427,429,430,432,431,428,475,477,478,480,479,476,469,471,472,474,473,470,451,453,454,456,455,452,499,501,502,504,503,500,481,483,484,486,485,482,457,459,460,462,461,458,339,342,340,341,343,344,439,441,442,444,443,440,397,400,401,402,399,
564482 -0.1 s idle in transaction
odoo
SELECT "swk_sub_purchase".id FROM "swk_sub_purchase" WHERE ("swk_sub_purchase"."move_id" in (93683544)) ORDER BY "swk_sub_purchase"."id"  

You may need to restart your app servers afterwards.