PgHero

Live Queries

9 queries

Pid Duration State
289936 00:04:47 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
289664 00:02:05 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
292218 00:02: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
289937 0.3 s idle in transaction
odoo
SELECT "stock_quant"."id" as "id","stock_quant"."commissary_quantity" as "commissary_quantity","stock_quant"."location_id" as "location_id","stock_quant"."commissary_reserved" as "commissary_reserved","stock_quant"."write_date" as "write_date","stock_quant"."reserved_quantity" as "reserved_quantity","stock_quant"."owner_id" as "owner_id","stock_quant"."removal_date" as "removal_date","stock_quant"."create_date" as "create_date","stock_quant"."product_id" as "product_id","stock_quant"."quantity" as "quantity","stock_quant"."package_id" as "package_id","stock_quant"."lot_id" as "lot_id","stock_quant"."create_uid" as "create_uid","stock_quant"."write_uid" as "write_uid","stock_quant"."in_date" as "in_date","stock_quant"."company_id" as "company_id" FROM "stock_quant" WHERE "stock_quant".id IN (10563061)
292966 0.2 s active
odoo
SELECT "queue_job".id FROM "queue_job" WHERE ((("queue_job"."state" = 'pending')  AND  ("queue_job"."date_created" > '2023-10-01 20:00:00'))  AND  (("queue_job"."name" not in ('sale.order.update_deliverect_order_status','swk.suborder.process_suborder_job','sale.order.auto_confirm_job','swk.suborder.print_suborder_job','swk.suborder.action_reconcile_job','sale.order.automatic_printing','stock.move._check_availability')) OR "queue_job"."name" IS NULL)) ORDER BY "queue_job"."date_created"  
292965 0.2 s active
odoo
SELECT "queue_job".id FROM "queue_job" WHERE ((("queue_job"."state" = 'pending')  AND  ("queue_job"."date_created" > '2023-10-01 20:00:00'))  AND  (("queue_job"."name" not in ('sale.order.update_deliverect_order_status','swk.suborder.process_suborder_job','sale.order.auto_confirm_job','swk.suborder.print_suborder_job','swk.suborder.action_reconcile_job','sale.order.automatic_printing','stock.move._check_availability')) OR "queue_job"."name" IS NULL)) ORDER BY "queue_job"."date_created"  
292225 0.2 s active
odoo
SELECT "queue_job".id FROM "queue_job" WHERE ((("queue_job"."state" = 'pending')  AND  ("queue_job"."date_created" > '2023-10-01 20:00:00'))  AND  (("queue_job"."name" not in ('sale.order.update_deliverect_order_status','swk.suborder.process_suborder_job','sale.order.auto_confirm_job','swk.suborder.print_suborder_job','swk.suborder.action_reconcile_job','sale.order.automatic_printing','stock.move._check_availability')) OR "queue_job"."name" IS NULL)) ORDER BY "queue_job"."date_created"  
289681 0.2 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 (233769974, 233770437, 233770438, 233770447, 233770448, 233770449, 233770450, 233770451, 233770452, 233770453, 233770454, 233770455, 233770456, 233770457, 233770463, 233770464, 233770465, 233770468, 233770472, 233770473, 233770476, 233770477, 233770479, 233770480, 233770481, 233770486, 233770487, 233770488, 233770495, 233770505, 233770506, 233770507, 233770509, 233770510, 233770511, 233770515, 233770518, 233770519, 233770526, 233770527, 233770528, 233770529, 233770530, 233770534, 233770537, 233770538, 233770545, 233770546, 233770547, 233770548, 233770549, 233770554, 233770555, 233770556, 233770557, 233770558, 233770559, 233770565, 233770567, 233770569, 233770579, 233770580, 233770584, 233770585, 233770587, 233770588, 233770589, 233770590, 233770607, 233770608, 233770616, 233770617, 233770619, 233770620, 233770621, 2
292219 -0.0 s active
odoo
SELECT "ir_default".id FROM "ir_default" WHERE ((("ir_default"."field_id" in (3329,6440,6358,3311,4157,8422,3670,2944,8424,8423,3500,3089,8229,2249,4151,3715,3303,3328,3239,3621,3821,3443,3111,4152,3774,3773,8242,4117,4024,3669,2943,8425,8426,5881,5915,1096,2405,453,333,5311,2052,6016,3285,5664,1830,6335,1852,2807,5627,2581,4912,2512,4295,2034,4911,1851,2033,2041,4294,2511,2580,5626,2806,5663,6334,3284,6015,261,798,7229,1743,1931,2180,4323,2037,4334,1728,1754,2203,1970,1756,1733,1972,4336,2205,2198,1747,1965,1729,4329,3117,3518,6157,6130,5987,3846,7419,8298,2686,6502,2664,2104,1883,4348,1789,2264,4866,7685,4734,6956,6808,3442,5221,3054,3701,5237,966,3057,1534,4855,2716,354,430,217,228,273,300,285,378,5641,5464,5447,5586,5756,9678,8114,7466,8272,6994,7635,9427,8968,9527,7421,7024,8902,7133,7041,9677,8312,8377,8881,7104,9402,7053,9475,8998,9676,6417,2391,1459,1449,1435,5901,1517,4390,6459,6452,4280,9413,3630,3099,5245,3417,3374,3416,3267,9039,9040,7990,9594,6150,9635,2712,6127,4136,9549,2467,2606,4610,644,7054

You may need to restart your app servers afterwards.