PgHero

Live Queries

6 queries

Pid Duration State
2893241 00:02: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
2893159 00:02:02 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
2894861 00:01:23 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
2894855 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 (233556549, 233556762, 233556763, 233556863, 233556864, 233556867, 233556895, 233556896, 234390258, 234390491, 234390508, 234390527, 234390528, 235556842, 235556845, 235556846, 235556847, 235556848, 235556849, 235556855, 235556856, 235556871, 235556872, 235556873, 235556874, 235556875, 235556882, 235556883, 235556896, 235556897, 235556908, 235556909, 235556911, 235556912, 235556913, 235556918, 235556919, 235556923, 235556924, 235556939, 235556945, 235556949, 235556950, 235556951, 235556952, 235556953, 235556958, 235556959, 235556971, 235556972, 235556973, 235556974, 235556975, 235556979, 235556980, 235556993, 235556994, 235556995, 235557000, 235557001, 235557002, 235557003, 235557004, 235557008, 235557009, 235557024, 235557025, 235557026, 235557027, 235557028, 235557032, 235557033, 235557046, 235557047, 235557048, 2
2894867 0.0 s idle in transaction
odoo
 SELECT mail_compose_message_ir_attachments_rel.wizard_id, mail_compose_message_ir_attachments_rel.attachment_id FROM mail_compose_message_ir_attachments_rel, "ir_attachment"
                    WHERE 1=1 AND mail_compose_message_ir_attachments_rel.wizard_id IN (7566817, 7566818, 7566819, 7566820, 7566821, 7566822, 7566823, 7566824, 7566825, 7566826, 7566827, 7566828, 7566829, 7566830, 7566831, 7566832, 7566833, 7566834, 7566835, 7566836, 7566837, 7566838, 7566839, 7566840, 7566841, 7566842, 7566843, 7566844, 7566845, 7566846, 7566847, 7566848, 7566849, 7566850, 7566851, 7566852, 7566853, 7566854, 7566855, 7566856, 7566857, 7566858, 7566859, 7566860, 7566861, 7566862, 7566863, 7566864, 7566865, 7566866, 7566867, 7566868, 7566869, 7566870, 7566871, 7566872, 7566873, 7566874, 7566875, 7566876, 7566877, 7566878, 7566879, 7566880, 7566881, 7566882, 7566883, 7566884, 7566885, 7566886, 7566887, 7566888, 7566889, 7566890, 7566891, 7566892, 7566893, 7566894, 7566895, 7566896, 7566897, 7566898, 7566899, 7566900, 7566
2894856 0.0 s active
odoo
SELECT "stock_scrap".id FROM "stock_scrap" WHERE ("stock_scrap"."scrap_ticket_id" in (2621440,2621441,2621442,2621443,2621444,2621445,2621446,2621447,2621448,2621449,2621450,2621451,2621452,2621453,2621454,2621455,2621456,2621457,2621458,2621459,2621460,2621461,2621483,2621484,2621485,2621486,2621487,2621488,2621489,2621490,2621491,2621492,2621493,2621494,2621495,2621496,2621497,2621498,2621499,2621500,2621501,2621502,2621503,2621504,2621505,2621506,2621507,2621508,2621510,2621511,2621512,2621513,2621514,2621515,2621516,2621517,2621518,2621519,2621520,2621521,2621522,2621523,2621524,2621525,2621526,2621527,2621528,2621529,2621530,2621531,2621532,2621533,2621534,2621535,2621536,2621537,2621538,2621539,2621542,2621543,2621544,2621545,2621546,2621547,2621548,2621549,2621550,2621551,2621552,2621553,2621554,2621555,2621556,2621557,2621558,2621559,2621560,2621561,2621562,2621563,2621564,2621565,2621566,2621567,2621568,2621569,2621570,2621571,2621572,2621573,2621574,2621575,2621576,2621577,2621578,2621579,2621580,2

You may need to restart your app servers afterwards.