PgHero

Live Queries

7 queries

Pid Duration State
2782711 00:07:31 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
2782699 00:02:09 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
2784309 00:01:11 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
2782928 4.7 s active
odoo
DELETE FROM mrp_product_produce WHERE id IN (9969122, 9969123, 9969124, 9969125, 9969126, 9969127, 9969128, 9969129, 9969130, 9969131, 9969132, 9969133, 9969134, 9969135, 9969136, 9969137, 9969138, 9969139, 9969140, 9969141, 9969142, 9969143, 9969144, 9969145, 9969146, 9969147, 9969148, 9969149, 9969150, 9969151, 9969152, 9969153, 9969154, 9969155, 9969156, 9969157, 9969158, 9969159, 9969160, 9969161, 9969162, 9969163, 9969164, 9969165, 9969166, 9969167, 9969168, 9969169, 9969170, 9969171, 9969172, 9969173, 9969174, 9969175, 9969176, 9969177, 9969178, 9969179, 9969180, 9969181, 9969182, 9969183, 9969184, 9969185, 9969186, 9969187, 9969188, 9969189, 9969190, 9969191, 9969192, 9969193, 9969194, 9969195, 9969196, 9969197, 9969198, 9969199, 9969200, 9969201, 9969202, 9969203, 9969204, 9969205, 9969206, 9969207, 9969208, 9969209, 9969210, 9969211, 9969212, 9969213, 9969214, 9969215, 9969216, 9969217, 9969218, 9969219, 9969220, 9969221, 9969222, 9969223, 9969224, 9969225, 9969226, 9969227, 9969228, 9969229, 996923
2783588 0.5 s idle in transaction
odoo
SELECT "product_template"."id" as "id","product_template"."looker_subcategory_id" as "looker_subcategory_id","product_template"."message_last_post" as "message_last_post","product_template"."rental" as "rental","product_template"."life_time" as "life_time","product_template"."station_id" as "station_id","product_template"."description_purchase" as "description_purchase","product_template"."tracking" as "tracking","product_template"."service_type" as "service_type","product_template"."production_minimum_stock" as "production_minimum_stock","product_template"."automatic_variant_create" as "automatic_variant_create","product_template"."price_as_attribute" as "price_as_attribute","product_template"."looker_category_id" as "looker_category_id","product_template"."bom_cost" as "bom_cost","product_template"."classification" as "classification","product_template"."swk_inventory_loss" as "swk_inventory_loss","product_template"."target_stock_override" as "target_stock_override","product_template"."is_printed" as "is_p
2784487 0.3 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" in ('sale.order.update_deliverect_order_status','swk.suborder.process_suborder_job','swk.suborder.print_suborder_job','sale.order.automatic_printing','sale.order.auto_confirm_job'))) ORDER BY "queue_job"."date_created"  
2782960 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 (234311230, 235143802, 235154027, 235154028, 235154031, 235154072, 235154074, 235154075, 235154088, 235154204, 235154205, 235154214, 235154215, 235154217, 235154245, 235154247, 235154355, 235154372, 235154373, 235154374, 235154466, 235154512, 235154513, 235154514, 235154526, 235154527, 235154528, 235154538, 235154540, 235154689, 235154722, 235154723, 235154770, 235154818, 235154819, 235154820, 235154829, 235154892, 235154893, 235154902, 235154928, 235154955, 235154957, 235154958, 235154967, 235154968, 235154969, 235154987, 235154989, 235155142, 235155143, 235155198, 235155229, 235155231, 235155241, 235155351, 235155353, 235155361, 235155429, 235155430, 235155439, 235155475, 235155477, 235155484, 235155486, 235155487, 235155498, 235155499, 235155650, 235155651, 235155660, 235155730, 235155731, 235155741, 235155742, 2

You may need to restart your app servers afterwards.