PgHero

Live Queries

12 queries

Pid Duration State
1341207 00:19:12 idle in transaction
odoo14 
SELECT name, id, state, demo AS dbdemo, latest_version AS installed_version  FROM ir_module_module WHERE name IN ('base', 'uom', 'customer_search_filter', 'list_view_sticky_header', 'web', 'bus', 'barcodes', 'login_user_detail', 'web_editor', 'auth_totp', 'resource', 'web_sheet_full_width', 'smile_audit', 'sql_request_abstract', 'web_tour', 'hspl_user_simulation', 'filter_multi_user', 'web_group_expand', 'web_refresher', 'muk_web_theme', 'web_fontawesome', 'web_widget_url_advanced', 'utm', 'social_media', 'base_address_city', 'attachment_indexation', 'web_kanban_gauge', 'base_import', 'inputmask_widget', 'base_setup', 'google_account', 'web_widget_numeric_step', 'http_routing', 'web_dialog_size', 'microsoft_account', 'mail', 'contacts', 'product', 'sql_export', 'link_tracker', 'google_drive', 'sql_export_mail', 'hr', 'prt_email_from', 'gamification', 'web_pwa_oca', 'web_unsplash', 'auto_backup_upload', 'ARABIA_debug_mode', 'access_cost_price_product', 'iap', 'auth_signup', 'base_automation', 'phone_validatio
1341215 00:19:10 idle in transaction
odoo14 
SELECT value FROM ir_translation
                       WHERE lang='ar_001' AND type in ('code') AND src='This name is already registered with this product type.' AND md5(src)=md5('This name is already registered with this product type.')
1343779 0.5 s active
odoo14 
SELECT res_partner.id
                         FROM "res_partner"
                       WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false ) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private'))) AND  (res_partner.email ilike '%جهازى%'
                           OR res_partner.display_name ilike '%جهازى%'
                           OR res_partner.ref ilike '%جهازى%'
                           OR res_partner.vat ilike NULL)
                           -- don't panic, trust postgres bitmap
                     ORDER BY  res_partner.display_name ilike '%جهازى%' desc,
                              res_partner.display_name
1321769 0.5 s active
odoo14 
SELECT res_partner.id
                         FROM "res_partner"
                       WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false ) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private'))) AND  (res_partner.email ilike '%جهازى%'
                           OR res_partner.display_name ilike '%جهازى%'
                           OR res_partner.ref ilike '%جهازى%'
                           OR res_partner.vat ilike NULL)
                           -- don't panic, trust postgres bitmap
                     ORDER BY  res_partner.display_name ilike '%جهازى%' desc,
                              res_partner.display_name
1343778 0.5 s active
odoo14 
SELECT res_partner.id
                         FROM "res_partner"
                       WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false ) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private'))) AND  (res_partner.email ilike '%جهازى%'
                           OR res_partner.display_name ilike '%جهازى%'
                           OR res_partner.ref ilike '%جهازى%'
                           OR res_partner.vat ilike NULL)
                           -- don't panic, trust postgres bitmap
                     ORDER BY  res_partner.display_name ilike '%جهازى%' desc,
                              res_partner.display_name
1343781 0.5 s active
odoo14 
SELECT res_partner.id
                         FROM "res_partner"
                       WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false ) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private'))) AND  (res_partner.email ilike '%شركة العروس%'
                           OR res_partner.display_name ilike '%شركة العروس%'
                           OR res_partner.ref ilike '%شركة العروس%'
                           OR res_partner.vat ilike NULL)
                           -- don't panic, trust postgres bitmap
                     ORDER BY  res_partner.display_name ilike '%شركة العروس%' desc,
                              res_partner.display_name
1343780 0.5 s active
odoo14 
SELECT res_partner.id
                         FROM "res_partner"
                       WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false ) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private'))) AND  (res_partner.email ilike '%شركة العروس%'
                           OR res_partner.display_name ilike '%شركة العروس%'
                           OR res_partner.ref ilike '%شركة العروس%'
                           OR res_partner.vat ilike NULL)
                           -- don't panic, trust postgres bitmap
                     ORDER BY  res_partner.display_name ilike '%شركة العروس%' desc,
                              res_partner.display_name
1330213 0.5 s active
odoo14 
SELECT res_partner.id
                         FROM "res_partner"
                       WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false ) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private'))) AND  (res_partner.email ilike '%شركة العروس%'
                           OR res_partner.display_name ilike '%شركة العروس%'
                           OR res_partner.ref ilike '%شركة العروس%'
                           OR res_partner.vat ilike NULL)
                           -- don't panic, trust postgres bitmap
                     ORDER BY  res_partner.display_name ilike '%شركة العروس%' desc,
                              res_partner.display_name
1343782 0.2 s active
odoo14 
SELECT res_partner.id
                         FROM "res_partner"
                       WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false ) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private'))) AND  (res_partner.email ilike '%جهازى%'
                           OR res_partner.display_name ilike '%جهازى%'
                           OR res_partner.ref ilike '%جهازى%'
                           OR res_partner.vat ilike NULL)
                           -- don't panic, trust postgres bitmap
                     ORDER BY  res_partner.display_name ilike '%جهازى%' desc,
                              res_partner.display_name
1335971 0.2 s active
odoo14 
SELECT res_partner.id
                         FROM "res_partner"
                       WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false ) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private'))) AND  (res_partner.email ilike '%جهازى%'
                           OR res_partner.display_name ilike '%جهازى%'
                           OR res_partner.ref ilike '%جهازى%'
                           OR res_partner.vat ilike NULL)
                           -- don't panic, trust postgres bitmap
                     ORDER BY  res_partner.display_name ilike '%جهازى%' desc,
                              res_partner.display_name
1343783 0.2 s active
odoo14 
SELECT res_partner.id
                         FROM "res_partner"
                       WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false ) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = 'private'))) AND  (res_partner.email ilike '%جهازى%'
                           OR res_partner.display_name ilike '%جهازى%'
                           OR res_partner.ref ilike '%جهازى%'
                           OR res_partner.vat ilike NULL)
                           -- don't panic, trust postgres bitmap
                     ORDER BY  res_partner.display_name ilike '%جهازى%' desc,
                              res_partner.display_name
1320509 0.0 s idle in transaction
odoo14 
SELECT "res_partner"."id" as "id", "res_partner"."company_name" as "company_name", "res_partner"."title" as "title", "res_partner"."is_company" as "is_company", "res_partner"."partner_type" as "partner_type", "res_partner"."lang" as "lang", "res_partner"."vat" as "vat", "res_partner"."phone_sanitized" as "phone_sanitized", "res_partner"."write_date" as "write_date", "res_partner"."picking_warn" as "picking_warn", "res_partner"."company_id" as "company_id", "res_partner"."warning_stage" as "warning_stage", "res_partner"."active_limit" as "active_limit", "res_partner"."city" as "city", "res_partner"."street" as "street", "res_partner"."function" as "function", "res_partner"."comment" as "comment", "res_partner"."blocking_stage" as "blocking_stage", "res_partner"."website" as "website", "res_partner"."display_name" as "display_name", "res_partner"."user_id" as "user_id", "res_partner"."email_normalized" as "email_normalized", "res_partner"."phone" as "phone", "res_partner"."city_id" as "city_id", "res_partner".

You may need to restart your app servers afterwards.