Queries

SELECT "queue_job".id FROM "queue_job" WHERE (("queue_job"."name" = $1)  AND  ("queue_job"."state" = $2)) ORDER BY "queue_job"."date_created" DESC,"queue_job"."date_done" DESC

CREATE INDEX CONCURRENTLY ON queue_job (name)

Rows: 8333974
Row progression: 8333974, 694498, 347249

Row estimates
- name (=): 694498
- state (=): 4166987
- date_created (sort): 23

Existing indexes
- id PRIMARY
- channel
- company_id
- identity_key WHERE ((state)::text = ANY (ARRAY[('pending'::character varying)::text, ('enqueued'::character varying)::text])) AND (identity_key IS NOT NULL)
- state
- uuid

SELECT "production_schedule_line".id FROM "production_schedule_line" WHERE ("production_schedule_line"."production_ticket_id" IS NULL   AND  ("production_schedule_line"."to_skip" IS NULL or "production_schedule_line"."to_skip" = false )) ORDER BY "production_schedule_line"."id"

SELECT "queue_job".id FROM "queue_job" WHERE (("queue_job"."name" = $1)  AND  ("queue_job"."state" = $2)) ORDER BY "queue_job"."date_created" ASC  limit $3

CREATE INDEX CONCURRENTLY ON queue_job (name)

Rows: 8333974
Row progression: 8333974, 694498, 347249

Row estimates
- name (=): 694498
- state (=): 4166987
- date_created (sort): 23

Existing indexes
- id PRIMARY
- channel
- company_id
- identity_key WHERE ((state)::text = ANY (ARRAY[('pending'::character varying)::text, ('enqueued'::character varying)::text])) AND (identity_key IS NOT NULL)
- state
- uuid

SELECT "stock_scrap".id FROM "stock_scrap" WHERE ("stock_scrap"."move_id" in ($1)) ORDER BY "stock_scrap"."id"

CREATE INDEX CONCURRENTLY ON stock_scrap (move_id)

Rows: 7133
Row progression: 7133, 1

Row estimates
- move_id (=): 1
- id (sort): 1

Existing indexes
- id PRIMARY

SELECT "material_requisition".id FROM "material_requisition" WHERE ("material_requisition"."state" = $1) ORDER BY "material_requisition"."create_date" DESC

CREATE INDEX CONCURRENTLY ON material_requisition (state, create_date)

Rows: 52665
Row progression: 52665, 10533, 0

Row estimates
- state (=): 10533
- create_date (sort): 1

Existing indexes
- id PRIMARY

DISCARD ALL

SELECT id FROM "product_category" WHERE id IN ($1)

SELECT base_registry_signaling.last_value,
                                  base_cache_signaling.last_value
                           FROM base_registry_signaling, base_cache_signaling

SELECT "stock_scrap".id FROM "stock_scrap" WHERE ("stock_scrap"."scrap_ticket_id" in ($1)) ORDER BY "stock_scrap"."id" DESC

CREATE INDEX CONCURRENTLY ON stock_scrap (scrap_ticket_id)

Rows: 7133
Row progression: 7133, 1

Row estimates
- scrap_ticket_id (=): 1
- id (sort): 1

Existing indexes
- id PRIMARY

BEGIN ISOLATION LEVEL REPEATABLE READ

SELECT "stock_location".id FROM "stock_location" WHERE ("stock_location"."parent_right" >= $1) ORDER BY "stock_location"."parent_left"

SELECT "stock_location".id FROM "stock_location" WHERE ("stock_location"."parent_left" <= $1) ORDER BY "stock_location"."parent_left"

SELECT "swk_sub_purchase".id FROM "swk_sub_purchase" WHERE ("swk_sub_purchase"."move_id" in ($1)) ORDER BY "swk_sub_purchase"."id"

Covered by index on (move_id)
Rows: 174645
Row progression: 174645, 1

Row estimates
- move_id (=): 1
- id (sort): 1

Existing indexes
- id PRIMARY
- move_id
- name
- state

SELECT "stock_move_line".id FROM "stock_move_line" WHERE ("stock_move_line"."move_id" in ($1)) ORDER BY "stock_move_line"."id"

Covered by index on (move_id)
Rows: 5854267
Row progression: 5854267, 1

Row estimates
- move_id (=): 1
- id (sort): 1

Existing indexes
- id PRIMARY
- move_id
- picking_id
- product_id, state
- product_qty, move_id

SELECT substr(p.res_id, $1)::integer, p.value_float
                FROM ir_property p
                WHERE p.fields_id=$2
                    AND (p.company_id=$3 OR p.company_id IS NULL)
                    AND (p.res_id IN ($4) OR p.res_id IS NULL)
                ORDER BY p.company_id NULLS FIRST

SELECT "res_partner"."id" as "id","res_partner"."phone" as "phone","res_partner"."supplier" as "supplier","res_partner"."activity_date_deadline" as "activity_date_deadline","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."lang" as "lang","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."sale_warn_msg" as "sale_warn_msg","res_partner"."street2" as "street2","res_partner"."cancelled_order_count" as "cancelled_order_count","res_partner"."customer_platform" as "customer_platform","res_partner"."company_id" as "company_id","res_partner"."picking_warn" as "picking_warn","res_partner"."employee" as "employee","res_partner"."user_id" as "user_id","res_partner"."vat" as "vat","res_partner"."tz" as "tz","res_partner"."mobile" as "mobile","res_partner"."message_bounce" as "message_bounce","res_partner"."debit_limit" as "debit_limit","res_partner"."name" as "name","res_partner"."zip" as "zip","res_partner"."signup_token" as "signup_token","res_partner"."purchase_warn" as "purchase_warn","res_partner"."write_date" as "write_date","res_partner"."team_id" as "team_id","res_partner"."create_uid" as "create_uid","res_partner"."message_last_post" as "message_last_post","res_partner"."is_company" as "is_company","res_partner"."website" as "website","res_partner"."opt_out" as "opt_out","res_partner"."picking_warn_msg" as "picking_warn_msg","res_partner"."comment" as "comment","res_partner"."purchase_warn_msg" as "purchase_warn_msg","res_partner"."first_order_date" as "first_order_date","res_partner"."create_date" as "create_date","res_partner"."display_name" as "display_name","res_partner"."city" as "city","res_partner"."signup_type" as "signup_type","res_partner"."write_uid" as "write_uid","res_partner"."title" as "title","res_partner"."date" as "date","res_partner"."color" as "color","res_partner"."commercial_partner_id" as "commercial_partner_id","res_partner"."barcode" as "barcode","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."credit_limit" as "credit_limit","res_partner"."signup_expiration" as "signup_expiration","res_partner"."state_id" as "state_id","res_partner"."total_orders_group" as "total_orders_group","res_partner"."email" as "email","res_partner"."active" as "active","res_partner"."partner_share" as "partner_share","res_partner"."parent_id" as "parent_id","res_partner"."commercial_partner_country_id" as "commercial_partner_country_id","res_partner"."function" as "function","res_partner"."company_name" as "company_name","res_partner"."type" as "type","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."invoice_warn" as "invoice_warn","res_partner"."swk_order_count" as "swk_order_count","res_partner"."country_id" as "country_id","res_partner"."ref" as "ref","res_partner"."average_basket_size" as "average_basket_size","res_partner"."customer" as "customer","res_partner"."suborder_count" as "suborder_count","res_partner"."sale_warn" as "sale_warn","res_partner"."last_order_date" as "last_order_date","res_partner"."street" as "street","res_partner"."dh_id" as "dh_id","res_partner"."industry_id" as "industry_id" FROM "res_partner" WHERE "res_partner".id IN ($1)

Covered by index on (id)
Rows: 731
Row progression: 731, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- commercial_partner_id
- company_id
- date
- dh_id, active
- display_name
- name
- parent_id
- ref
- total_orders_group

SELECT f.name, d.json_value FROM ir_default d
                    JOIN ir_model_fields f ON d.field_id=f.id
                    JOIN res_users u ON u.id=$1
                    WHERE f.model=$2
                        AND (d.user_id IS NULL OR d.user_id=u.id)
                        AND (d.company_id IS NULL OR d.company_id=u.company_id)
                        AND d.condition IS NULL
                    ORDER BY d.user_id, d.company_id, d.id

SELECT DISTINCT "purchase_line_id" FROM "stock_move" WHERE "id" IN ($1)

Covered by index on (id)
Rows: 5958755
Row progression: 5958755, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- company_id
- create_date
- created_production_id
- created_purchase_line_id
- date
- date_expected
- inventory_id, location_dest_id
- location_dest_id, created_purchase_line_id
- location_dest_id, state, product_id, date
- location_id
- name
- origin_returned_move_id
- picking_id, location_dest_id
- product_id, location_id, location_dest_id, company_id, state
- product_id, location_id, location_dest_id, state
- production_id, location_dest_id
- purchase_line_id
- raw_material_production_id, location_dest_id
- sale_line_id, location_dest_id
- scrapped
- state

SELECT DISTINCT "picking_id" FROM "stock_move" WHERE "id" IN ($1)

Covered by index on (id)
Rows: 5958755
Row progression: 5958755, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- company_id
- create_date
- created_production_id
- created_purchase_line_id
- date
- date_expected
- inventory_id, location_dest_id
- location_dest_id, created_purchase_line_id
- location_dest_id, state, product_id, date
- location_id
- name
- origin_returned_move_id
- picking_id, location_dest_id
- product_id, location_id, location_dest_id, company_id, state
- product_id, location_id, location_dest_id, state
- production_id, location_dest_id
- purchase_line_id
- raw_material_production_id, location_dest_id
- sale_line_id, location_dest_id
- scrapped
- state

SELECT "material_requisition".id FROM "material_requisition" WHERE ("material_requisition"."schedule_id" in ($1)) ORDER BY "material_requisition"."create_date" DESC

CREATE INDEX CONCURRENTLY ON material_requisition (schedule_id)

Rows: 52665
Row progression: 52665, 37

Row estimates
- schedule_id (=): 37
- create_date (sort): 1

Existing indexes
- id PRIMARY

SELECT "queue_job".id FROM "queue_job" WHERE ("queue_job"."uuid" = $1) ORDER BY "queue_job"."date_created" DESC,"queue_job"."date_done" DESC  limit $2

Covered by index on (uuid)
Rows: 8333974
Row progression: 8333974, 1

Row estimates
- uuid (=): 1
- date_created (sort): 23

Existing indexes
- id PRIMARY
- channel
- company_id
- identity_key WHERE ((state)::text = ANY (ARRAY[('pending'::character varying)::text, ('enqueued'::character varying)::text])) AND (identity_key IS NOT NULL)
- state
- uuid

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"."id" in ($1)) 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"

SELECT "stock_picking"."id" as "id" FROM "stock_picking" WHERE "stock_picking".id IN ($1)

Covered by index on (id)
Rows: 3404060
Row progression: 3404060, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- backorder_id
- company_id
- date
- group_id, picking_type_id, location_dest_id
- name, company_id UNIQUE
- origin
- priority
- sale_id
- scheduled_date
- state, picking_type_id, scheduled_date

SELECT DISTINCT "move_id" FROM "stock_move_line" WHERE "id" IN ($1)

Covered by index on (id)
Rows: 5854267
Row progression: 5854267, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- move_id
- picking_id
- product_id, state
- product_qty, move_id

select nextval($1)

INSERT INTO "stock_move" ("id", "product_id", "ordered_qty", "scrapped", "state", "product_uom_qty", "procure_method", "group_id", "picking_id", "sequence", "to_refund", "company_id", "location_dest_id", "priority", "name", "is_done", "location_id", "date_expected", "origin", "date", "propagate", "additional", "product_uom", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval($1), $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, (now() at time zone $26), (now() at time zone $27)) RETURNING id

INSERT INTO "res_users_log" ("id", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval($1), $2, $3, (now() at time zone $4), (now() at time zone $5)) RETURNING id

SELECT "stock_move_line".id FROM "stock_move_line" WHERE ("stock_move_line"."picking_id" in ($1))

Covered by index on (picking_id)
Rows: 5854267
Row progression: 5854267, 4

Row estimates
- picking_id (=): 4

Existing indexes
- id PRIMARY
- move_id
- picking_id
- product_id, state
- product_qty, move_id

SELECT "product_product"."id" as "id","product_product"."message_last_post" as "message_last_post","product_product"."volume" as "volume","product_product"."production_cost_food" as "production_cost_food","product_product"."production_cost_nonfood" as "production_cost_nonfood","product_product"."create_date" as "create_date","product_product"."write_date" as "write_date","product_product"."write_uid" as "write_uid","product_product"."active" as "active","product_product"."default_code" as "default_code","product_product"."product_tmpl_id" as "product_tmpl_id","product_product"."product_id" as "product_id","product_product"."create_uid" as "create_uid","product_product"."activity_date_deadline" as "activity_date_deadline","product_product"."barcode" as "barcode","product_product"."weight" as "weight" FROM "product_product" WHERE "product_product".id IN ($1)

Covered by index on (id)
Rows: 1540846
Row progression: 1540846, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- barcode UNIQUE
- default_code
- product_tmpl_id
- product_tmpl_id, default_code

SELECT DISTINCT "raw_material_production_id" FROM "stock_move" WHERE "id" IN ($1)

Covered by index on (id)
Rows: 5958755
Row progression: 5958755, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- company_id
- create_date
- created_production_id
- created_purchase_line_id
- date
- date_expected
- inventory_id, location_dest_id
- location_dest_id, created_purchase_line_id
- location_dest_id, state, product_id, date
- location_id
- name
- origin_returned_move_id
- picking_id, location_dest_id
- product_id, location_id, location_dest_id, company_id, state
- product_id, location_id, location_dest_id, state
- production_id, location_dest_id
- purchase_line_id
- raw_material_production_id, location_dest_id
- sale_line_id, location_dest_id
- scrapped
- state

SELECT "stock_picking".id FROM "stock_picking" WHERE ("stock_picking"."id" in ($1)) ORDER BY "stock_picking"."id"

Covered by index on (id)
Rows: 3404060
Row progression: 3404060, 1

Row estimates
- id (=): 1
- id (sort): 1

Existing indexes
- id PRIMARY
- backorder_id
- company_id
- date
- group_id, picking_type_id, location_dest_id
- name, company_id UNIQUE
- origin
- priority
- sale_id
- scheduled_date
- state, picking_type_id, scheduled_date

SELECT "material_requisition"."id" as "id","material_requisition"."schedule_id" as "schedule_id" FROM "material_requisition" WHERE "material_requisition".id IN ($1)

Covered by index on (id)
Rows: 52665
Row progression: 52665, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY

SELECT DISTINCT "inventory_id" FROM "stock_move" WHERE "id" IN ($1)

Covered by index on (id)
Rows: 5958755
Row progression: 5958755, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- company_id
- create_date
- created_production_id
- created_purchase_line_id
- date
- date_expected
- inventory_id, location_dest_id
- location_dest_id, created_purchase_line_id
- location_dest_id, state, product_id, date
- location_id
- name
- origin_returned_move_id
- picking_id, location_dest_id
- product_id, location_id, location_dest_id, company_id, state
- product_id, location_id, location_dest_id, state
- production_id, location_dest_id
- purchase_line_id
- raw_material_production_id, location_dest_id
- sale_line_id, location_dest_id
- scrapped
- state

SELECT COUNT(*) FROM ir_module_module WHERE state LIKE $1

SELECT "product_template"."id" as "id","product_template"."name" as "name","product_template"."color" as "color","product_template"."purchase_method" as "purchase_method","product_template"."non_food" as "non_food","product_template"."description_pickingout" as "description_pickingout","product_template"."sale_line_warn_msg" as "sale_line_warn_msg","product_template"."priority" as "priority","product_template"."print_as" as "print_as","product_template"."station_id" as "station_id","product_template"."delivery_minimum_stock" as "delivery_minimum_stock","product_template"."delivery_frequency" as "delivery_frequency","product_template"."procurement_target_days" as "procurement_target_days","product_template"."swk_inventory_loss" as "swk_inventory_loss","product_template"."sequence" as "sequence","product_template"."allow_negative_stock" as "allow_negative_stock","product_template"."purchase_line_warn" as "purchase_line_warn","product_template"."delivery_quantity" as "delivery_quantity","product_template"."description_pickingin" as "description_pickingin","product_template"."list_price" as "list_price","product_template"."expense_policy" as "expense_policy","product_template"."production_time" as "production_time","product_template"."zomato_new" as "zomato_new","product_template"."looker_subcategory_id" as "looker_subcategory_id","product_template"."pr_printer_id" as "pr_printer_id","product_template"."looker_category_id" as "looker_category_id","product_template"."uom_id" as "uom_id","product_template"."delivery_day" as "delivery_day","product_template"."rental" as "rental","product_template"."type" as "type","product_template"."life_time" as "life_time","product_template"."purchase_line_warn_msg" as "purchase_line_warn_msg","product_template"."zomato_spicy" as "zomato_spicy","product_template"."invoice_policy" as "invoice_policy","product_template"."production_instructions" as "production_instructions","product_template"."arabic_description" as "arabic_description","product_template"."swk_accounting_tag" as "swk_accounting_tag","product_template"."bom_cost" as "bom_cost","product_template"."write_date" as "write_date","product_template"."write_uid" as "write_uid","product_template"."calculated_selling" as "calculated_selling","product_template"."create_uid" as "create_uid","product_template"."uom_po_id" as "uom_po_id","product_template"."sale_ok" as "sale_ok","product_template"."description" as "description","product_template"."sale_delay" as "sale_delay","product_template"."produce_delay" as "produce_delay","product_template"."use_time" as "use_time","product_template"."categ_id" as "categ_id","product_template"."is_printed" as "is_printed","product_template"."production_minimum_stock" as "production_minimum_stock","product_template"."production_weekday" as "production_weekday","product_template"."price_as_attribute" as "price_as_attribute","product_template"."zomato_vegan" as "zomato_vegan","product_template"."purchase_ok" as "purchase_ok","product_template"."removal_time" as "removal_time","product_template"."responsible_id" as "responsible_id","product_template"."tracking" as "tracking","product_template"."company_id" as "company_id","product_template"."description_purchase" as "description_purchase","product_template"."service_type" as "service_type","product_template"."print_bold" as "print_bold","product_template"."production_quantity" as "production_quantity","product_template"."automatic_variant_create" as "automatic_variant_create","product_template"."swk_scrap_account" as "swk_scrap_account","product_template"."transferable_storage_temperature" as "transferable_storage_temperature","product_template"."zomato_tag" as "zomato_tag","product_template"."target_stock_override" as "target_stock_override","product_template"."classification" as "classification","product_template"."create_date" as "create_date","product_template"."uom_id_temp" as "uom_id_temp","product_template"."active" as "active","product_template"."alert_time" as "alert_time","product_template"."description_sale" as "description_sale","product_template"."description_picking" as "description_picking","product_template"."sale_line_warn" as "sale_line_warn","product_template"."container_price" as "container_price","product_template"."image_url" as "image_url","product_template"."has_non_empty_bom" as "has_non_empty_bom","product_template"."daily_consumption_override" as "daily_consumption_override","product_template"."transferable_type" as "transferable_type","product_template"."activity_date_deadline" as "activity_date_deadline","product_template"."message_last_post" as "message_last_post","product_template"."swk_inventory_gain" as "swk_inventory_gain","product_template"."pt_printer_id" as "pt_printer_id" FROM "product_template" WHERE "product_template".id IN ($1)

Covered by index on (id)
Rows: 30383
Row progression: 30383, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- company_id
- name

SELECT "ir_model".id FROM "ir_model" WHERE ("ir_model"."model"::text like $1) ORDER BY COALESCE("ir_model"."is_mail_thread", $2) DESC,"ir_model"."name" ASC

SELECT "stock_picking".id FROM "stock_picking" WHERE ("stock_picking"."id" in ($1)) ORDER BY "stock_picking"."priority" DESC,"stock_picking"."date" ASC,"stock_picking"."id" DESC

Covered by index on (id)
Rows: 3404060
Row progression: 3404060, 1

Row estimates
- id (=): 1
- priority (sort): 3404060

Existing indexes
- id PRIMARY
- backorder_id
- company_id
- date
- group_id, picking_type_id, location_dest_id
- name, company_id UNIQUE
- origin
- priority
- sale_id
- scheduled_date
- state, picking_type_id, scheduled_date

UPDATE "swk_scrap_ticket" SET "currency_id"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)

Covered by index on (id)
Rows: 18139
Row progression: 18139, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- name
- state

COMMIT

SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."model" = $1)  AND  ("ir_model_data"."res_id" in ($2))) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name"

CREATE INDEX CONCURRENTLY ON ir_model_data (res_id)

Rows: 6818839
Row progression: 6818839, 1

Row estimates
- res_id (=): 1
- model (=): 158578
- module (sort): 60882
- model (sort): 158578
- name (sort): 7

Existing indexes
- id PRIMARY
- model, res_id
- module, name UNIQUE

INSERT INTO "stock_move_line" ("id", "product_id", "owner_id", "location_id", "done_wo", "package_id", "product_uom_qty", "qty_done", "done_move", "ordered_qty", "product_uom_id", "date", "location_processed", "move_line_processed", "lot_id", "location_dest_id", "move_id", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval($1), $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, (now() at time zone $20), (now() at time zone $21)) RETURNING id

SELECT DISTINCT "production_id" FROM "stock_move" WHERE "id" IN ($1)

Covered by index on (id)
Rows: 5958755
Row progression: 5958755, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- company_id
- create_date
- created_production_id
- created_purchase_line_id
- date
- date_expected
- inventory_id, location_dest_id
- location_dest_id, created_purchase_line_id
- location_dest_id, state, product_id, date
- location_id
- name
- origin_returned_move_id
- picking_id, location_dest_id
- product_id, location_id, location_dest_id, company_id, state
- product_id, location_id, location_dest_id, state
- production_id, location_dest_id
- purchase_line_id
- raw_material_production_id, location_dest_id
- sale_line_id, location_dest_id
- scrapped
- state

UPDATE "swk_scrap_ticket" SET "scrap_quantity"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)

Covered by index on (id)
Rows: 18139
Row progression: 18139, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- name
- state

SELECT "res_partner"."id" as "id","res_partner"."barcode" as "barcode","res_partner"."customer" as "customer","res_partner"."partner_share" as "partner_share","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."credit_limit" as "credit_limit","res_partner"."total_orders_group" as "total_orders_group","res_partner"."cancelled_order_count" as "cancelled_order_count","res_partner"."email" as "email","res_partner"."create_date" as "create_date","res_partner"."write_uid" as "write_uid","res_partner"."company_id" as "company_id","res_partner"."activity_date_deadline" as "activity_date_deadline","res_partner"."message_bounce" as "message_bounce","res_partner"."function" as "function","res_partner"."supplier" as "supplier","res_partner"."user_id" as "user_id","res_partner"."company_name" as "company_name","res_partner"."team_id" as "team_id","res_partner"."picking_warn" as "picking_warn","res_partner"."average_basket_size" as "average_basket_size","res_partner"."ref" as "ref","res_partner"."last_order_date" as "last_order_date","res_partner"."create_uid" as "create_uid","res_partner"."opt_out" as "opt_out","res_partner"."tz" as "tz","res_partner"."employee" as "employee","res_partner"."street" as "street","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."lang" as "lang","res_partner"."sale_warn" as "sale_warn","res_partner"."customer_platform" as "customer_platform","res_partner"."first_order_date" as "first_order_date","res_partner"."phone" as "phone","res_partner"."dh_id" as "dh_id","res_partner"."write_date" as "write_date","res_partner"."title" as "title","res_partner"."commercial_partner_id" as "commercial_partner_id","res_partner"."is_company" as "is_company","res_partner"."signup_expiration" as "signup_expiration","res_partner"."street2" as "street2","res_partner"."signup_token" as "signup_token","res_partner"."debit_limit" as "debit_limit","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."state_id" as "state_id","res_partner"."picking_warn_msg" as "picking_warn_msg","res_partner"."sale_warn_msg" as "sale_warn_msg","res_partner"."vat" as "vat","res_partner"."mobile" as "mobile","res_partner"."date" as "date","res_partner"."color" as "color","res_partner"."type" as "type","res_partner"."parent_id" as "parent_id","res_partner"."name" as "name","res_partner"."zip" as "zip","res_partner"."commercial_partner_country_id" as "commercial_partner_country_id","res_partner"."signup_type" as "signup_type","res_partner"."invoice_warn" as "invoice_warn","res_partner"."purchase_warn" as "purchase_warn","res_partner"."country_id" as "country_id","res_partner"."website" as "website","res_partner"."suborder_count" as "suborder_count","res_partner"."active" as "active","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."comment" as "comment","res_partner"."purchase_warn_msg" as "purchase_warn_msg","res_partner"."display_name" as "display_name","res_partner"."city" as "city","res_partner"."message_last_post" as "message_last_post","res_partner"."industry_id" as "industry_id","res_partner"."swk_order_count" as "swk_order_count" FROM "res_partner" WHERE "res_partner".id IN ($1)

Covered by index on (id)
Rows: 731
Row progression: 731, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- commercial_partner_id
- company_id
- date
- dh_id, active
- display_name
- name
- parent_id
- ref
- total_orders_group

SELECT "production_schedule"."id" as "id","production_schedule"."write_uid" as "write_uid","production_schedule"."write_date" as "write_date","production_schedule"."name" as "name","production_schedule"."create_uid" as "create_uid","production_schedule"."create_date" as "create_date","production_schedule"."state" as "state" FROM "production_schedule" WHERE "production_schedule".id IN ($1)

Covered by index on (id)
Rows: 1529
Row progression: 1529, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY

SELECT "res_users"."id" as "id","res_users"."signature" as "signature","res_users"."active" as "active","res_users"."action_id" as "action_id","res_users"."notification_type" as "notification_type","res_users"."target_sales_invoiced" as "target_sales_invoiced","res_users"."write_uid" as "write_uid","res_users"."password" as "password","res_users"."printer_tray_id" as "printer_tray_id","res_users"."password_crypt" as "password_crypt","res_users"."alias_id" as "alias_id","res_users"."share" as "share","res_users"."company_id" as "company_id","res_users"."sale_team_id" as "sale_team_id","res_users"."create_date" as "create_date","res_users"."login" as "login","res_users"."printing_action" as "printing_action","res_users"."target_sales_won" as "target_sales_won","res_users"."write_date" as "write_date","res_users"."create_uid" as "create_uid","res_users"."partner_id" as "partner_id","res_users"."target_sales_done" as "target_sales_done","res_users"."printing_printer_id" as "printing_printer_id" FROM "res_users" WHERE "res_users".id IN ($1)

UPDATE "stock_move_line" SET "product_qty"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)

Covered by index on (id)
Rows: 5854267
Row progression: 5854267, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- move_id
- picking_id
- product_id, state
- product_qty, move_id

SELECT "stock_production_lot"."id" as "id","stock_production_lot"."write_uid" as "write_uid","stock_production_lot"."create_date" as "create_date","stock_production_lot"."removal_date" as "removal_date","stock_production_lot"."alert_date" as "alert_date","stock_production_lot"."automatic_scrap" as "automatic_scrap","stock_production_lot"."automatic_scrap_cancelled" as "automatic_scrap_cancelled","stock_production_lot"."message_last_post" as "message_last_post","stock_production_lot"."ref" as "ref","stock_production_lot"."product_uom_id" as "product_uom_id","stock_production_lot"."create_uid" as "create_uid","stock_production_lot"."expiration_alert" as "expiration_alert","stock_production_lot"."use_date" as "use_date","stock_production_lot"."write_date" as "write_date","stock_production_lot"."product_id" as "product_id","stock_production_lot"."name" as "name","stock_production_lot"."before_expiration_alert" as "before_expiration_alert","stock_production_lot"."life_date" as "life_date","stock_production_lot"."use_next_on_work_order_id" as "use_next_on_work_order_id" FROM "stock_production_lot" WHERE "stock_production_lot".id IN ($1)

Covered by index on (id)
Rows: 503626
Row progression: 503626, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- name, product_id UNIQUE

SELECT "ir_sequence".id FROM "ir_sequence" LEFT JOIN "res_company" as "ir_sequence__company_id" ON ("ir_sequence"."company_id" = "ir_sequence__company_id"."id") WHERE ((("ir_sequence"."active" = $1)  AND  ("ir_sequence"."code" = $2))  AND  (("ir_sequence"."company_id" in ($3)) OR "ir_sequence"."company_id" IS NULL)) ORDER BY "ir_sequence__company_id"."sequence" ,"ir_sequence__company_id"."name"

SELECT "stock_move_line"."id" as "id","stock_move_line"."product_id" as "product_id","stock_move_line"."product_uom_qty" as "product_uom_qty","stock_move_line"."lot_produced_id" as "lot_produced_id","stock_move_line"."location_id" as "location_id","stock_move_line"."ordered_qty" as "ordered_qty","stock_move_line"."lot_name" as "lot_name","stock_move_line"."product_uom_id" as "product_uom_id","stock_move_line"."create_date" as "create_date","stock_move_line"."location_dest_id" as "location_dest_id","stock_move_line"."done_wo" as "done_wo","stock_move_line"."qty_done" as "qty_done","stock_move_line"."date" as "date","stock_move_line"."write_date" as "write_date","stock_move_line"."package_id" as "package_id","stock_move_line"."create_uid" as "create_uid","stock_move_line"."picking_id" as "picking_id","stock_move_line"."workorder_id" as "workorder_id","stock_move_line"."state" as "state","stock_move_line"."done_move" as "done_move","stock_move_line"."lot_id" as "lot_id","stock_move_line"."write_uid" as "write_uid","stock_move_line"."location_processed" as "location_processed","stock_move_line"."production_id" as "production_id","stock_move_line"."move_id" as "move_id","stock_move_line"."reference" as "reference","stock_move_line"."lot_produced_qty" as "lot_produced_qty","stock_move_line"."product_qty" as "product_qty","stock_move_line"."result_package_id" as "result_package_id","stock_move_line"."move_line_processed" as "move_line_processed","stock_move_line"."owner_id" as "owner_id" FROM "stock_move_line" WHERE "stock_move_line".id IN ($1)

Covered by index on (id)
Rows: 5854267
Row progression: 5854267, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- move_id
- picking_id
- product_id, state
- product_qty, move_id

INSERT INTO "stock_scrap" ("id", "product_id", "name", "is_swk_scrap", "state", "location_id", "date_expected", "product_uom_id", "scrap_ticket_id", "company_id", "lot_id", "initial_quantity", "scrap_qty", "scrap_location_id", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval($1), $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, (now() at time zone $17), (now() at time zone $18)) RETURNING id

SELECT "mrp_production".id FROM "mrp_production" WHERE ("mrp_production"."id" in ($1)) ORDER BY "mrp_production"."id"

Covered by index on (id)
Rows: 412902
Row progression: 412902, 1

Row estimates
- id (=): 1
- id (sort): 1

Existing indexes
- id PRIMARY
- date_finished
- date_planned_finished
- date_planned_start
- date_start
- name, company_id UNIQUE

SELECT "product_template"."id" as "id","product_template"."target_stock_override" as "target_stock_override","product_template"."uom_id" as "uom_id","product_template"."sale_ok" as "sale_ok","product_template"."use_time" as "use_time","product_template"."purchase_line_warn" as "purchase_line_warn","product_template"."list_price" as "list_price","product_template"."description_pickingin" as "description_pickingin","product_template"."expense_policy" as "expense_policy","product_template"."production_time" as "production_time","product_template"."delivery_quantity" as "delivery_quantity","product_template"."delivery_day" as "delivery_day","product_template"."write_uid" as "write_uid","product_template"."write_date" as "write_date","product_template"."create_uid" as "create_uid","product_template"."transferable_type" as "transferable_type","product_template"."type" as "type","product_template"."purchase_ok" as "purchase_ok","product_template"."uom_po_id" as "uom_po_id","product_template"."removal_time" as "removal_time","product_template"."invoice_policy" as "invoice_policy","product_template"."purchase_line_warn_msg" as "purchase_line_warn_msg","product_template"."categ_id" as "categ_id","product_template"."is_printed" as "is_printed","product_template"."production_instructions" as "production_instructions","product_template"."uom_id_temp" as "uom_id_temp","product_template"."arabic_description" as "arabic_description","product_template"."looker_category_id" as "looker_category_id","product_template"."create_date" as "create_date","product_template"."classification" as "classification","product_template"."swk_scrap_account" as "swk_scrap_account","product_template"."print_bold" as "print_bold","product_template"."description" as "description","product_template"."active" as "active","product_template"."sale_delay" as "sale_delay","product_template"."produce_delay" as "produce_delay","product_template"."company_id" as "company_id","product_template"."responsible_id" as "responsible_id","product_template"."alert_time" as "alert_time","product_template"."production_minimum_stock" as "production_minimum_stock","product_template"."production_weekday" as "production_weekday","product_template"."has_non_empty_bom" as "has_non_empty_bom","product_template"."price_as_attribute" as "price_as_attribute","product_template"."looker_subcategory_id" as "looker_subcategory_id","product_template"."calculated_selling" as "calculated_selling","product_template"."message_last_post" as "message_last_post","product_template"."procurement_target_days" as "procurement_target_days","product_template"."swk_inventory_gain" as "swk_inventory_gain","product_template"."activity_date_deadline" as "activity_date_deadline","product_template"."description_purchase" as "description_purchase","product_template"."color" as "color","product_template"."tracking" as "tracking","product_template"."service_type" as "service_type","product_template"."non_food" as "non_food","product_template"."production_quantity" as "production_quantity","product_template"."station_id" as "station_id","product_template"."automatic_variant_create" as "automatic_variant_create","product_template"."zomato_tag" as "zomato_tag","product_template"."transferable_storage_temperature" as "transferable_storage_temperature","product_template"."bom_cost" as "bom_cost","product_template"."pt_printer_id" as "pt_printer_id","product_template"."zomato_spicy" as "zomato_spicy","product_template"."sequence" as "sequence","product_template"."allow_negative_stock" as "allow_negative_stock","product_template"."description_picking" as "description_picking","product_template"."description_sale" as "description_sale","product_template"."sale_line_warn" as "sale_line_warn","product_template"."container_price" as "container_price","product_template"."purchase_method" as "purchase_method","product_template"."image_url" as "image_url","product_template"."delivery_minimum_stock" as "delivery_minimum_stock","product_template"."swk_inventory_loss" as "swk_inventory_loss","product_template"."zomato_new" as "zomato_new","product_template"."name" as "name","product_template"."daily_consumption_override" as "daily_consumption_override","product_template"."pr_printer_id" as "pr_printer_id","product_template"."zomato_vegan" as "zomato_vegan","product_template"."rental" as "rental","product_template"."life_time" as "life_time","product_template"."description_pickingout" as "description_pickingout","product_template"."sale_line_warn_msg" as "sale_line_warn_msg","product_template"."priority" as "priority","product_template"."print_as" as "print_as","product_template"."delivery_frequency" as "delivery_frequency","product_template"."swk_accounting_tag" as "swk_accounting_tag" FROM "product_template" WHERE "product_template".id IN ($1)

Covered by index on (id)
Rows: 30383
Row progression: 30383, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- company_id
- name

SELECT "stock_warehouse".id FROM "stock_warehouse" WHERE ((("stock_warehouse"."active" = $1)  AND  ("stock_warehouse"."view_location_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22)))  AND  ("stock_warehouse"."view_location_id" in ($23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279,$280,$281,$282,$283,$284,$285,$286,$287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362))) ORDER BY "stock_warehouse"."name"   limit $363

UPDATE "swk_scrap_ticket" SET "value"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)

Covered by index on (id)
Rows: 18139
Row progression: 18139, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- name
- state

UPDATE "stock_move_line" SET "state"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)

Covered by index on (id)
Rows: 5854267
Row progression: 5854267, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- move_id
- picking_id
- product_id, state
- product_qty, move_id

ROLLBACK

SELECT "stock_warehouse".id FROM "stock_warehouse" WHERE ((("stock_warehouse"."active" = $1)  AND  ("stock_warehouse"."view_location_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143,$144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156,$157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169,$170,$171,$172,$173,$174,$175,$176,$177,$178,$179,$180,$181,$182,$183,$184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195,$196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208,$209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221,$222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234,$235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247,$248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260,$261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273,$274,$275,$276,$277,$278,$279,$280,$281,$282,$283,$284,$285,$286,$287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299,$300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312,$313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325,$326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338,$339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351,$352)))  AND  ("stock_warehouse"."view_location_id" in ($353,$354,$355,$356,$357,$358,$359,$360,$361,$362))) ORDER BY "stock_warehouse"."name"   limit $363

SELECT DISTINCT "origin_returned_move_id" FROM "stock_move" WHERE "id" IN ($1)

Covered by index on (id)
Rows: 5958755
Row progression: 5958755, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- company_id
- create_date
- created_production_id
- created_purchase_line_id
- date
- date_expected
- inventory_id, location_dest_id
- location_dest_id, created_purchase_line_id
- location_dest_id, state, product_id, date
- location_id
- name
- origin_returned_move_id
- picking_id, location_dest_id
- product_id, location_id, location_dest_id, company_id, state
- product_id, location_id, location_dest_id, state
- production_id, location_dest_id
- purchase_line_id
- raw_material_production_id, location_dest_id
- sale_line_id, location_dest_id
- scrapped
- state

SELECT DISTINCT "workorder_id" FROM "stock_move" WHERE "id" IN ($1)

Covered by index on (id)
Rows: 5958755
Row progression: 5958755, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- company_id
- create_date
- created_production_id
- created_purchase_line_id
- date
- date_expected
- inventory_id, location_dest_id
- location_dest_id, created_purchase_line_id
- location_dest_id, state, product_id, date
- location_id
- name
- origin_returned_move_id
- picking_id, location_dest_id
- product_id, location_id, location_dest_id, company_id, state
- product_id, location_id, location_dest_id, state
- production_id, location_dest_id
- purchase_line_id
- raw_material_production_id, location_dest_id
- sale_line_id, location_dest_id
- scrapped
- state

SELECT "purchase_order".id FROM "purchase_order" WHERE $1 ORDER BY "purchase_order"."id"

SELECT "purchase_order_line".id FROM "purchase_order_line" LEFT JOIN "purchase_order" as "purchase_order_line__order_id" ON ("purchase_order_line"."order_id" = "purchase_order_line__order_id"."id") WHERE ("purchase_order_line"."id" in ($1)) ORDER BY "purchase_order_line__order_id"."date_order" DESC,"purchase_order_line__order_id"."id" DESC,"purchase_order_line"."sequence" ,"purchase_order_line"."id"

UPDATE "stock_scrap" SET "currency_id"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)

Covered by index on (id)
Rows: 7133
Row progression: 7133, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY

SELECT "product_product"."id" as "id","product_product"."product_tmpl_id" as "product_tmpl_id","product_product"."barcode" as "barcode","product_product"."message_last_post" as "message_last_post","product_product"."create_uid" as "create_uid","product_product"."write_date" as "write_date","product_product"."production_cost_food" as "production_cost_food","product_product"."product_id" as "product_id","product_product"."activity_date_deadline" as "activity_date_deadline","product_product"."create_date" as "create_date","product_product"."weight" as "weight","product_product"."production_cost_nonfood" as "production_cost_nonfood","product_product"."default_code" as "default_code","product_product"."active" as "active","product_product"."write_uid" as "write_uid","product_product"."volume" as "volume" FROM "product_product" WHERE "product_product".id IN ($1, $2)

Covered by index on (id)
Rows: 1540846
Row progression: 1540846, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- barcode UNIQUE
- default_code
- product_tmpl_id
- product_tmpl_id, default_code

UPDATE "stock_scrap" SET "date"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)

Covered by index on (id)
Rows: 7133
Row progression: 7133, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY

SELECT "stock_move_line"."id" as "id","stock_move_line"."picking_id" as "picking_id" FROM "stock_move_line" WHERE "stock_move_line".id IN ($1)

Covered by index on (id)
Rows: 5854267
Row progression: 5854267, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- move_id
- picking_id
- product_id, state
- product_qty, move_id

UPDATE "stock_move" SET "state"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)

Covered by index on (id)
Rows: 5958755
Row progression: 5958755, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- company_id
- create_date
- created_production_id
- created_purchase_line_id
- date
- date_expected
- inventory_id, location_dest_id
- location_dest_id, created_purchase_line_id
- location_dest_id, state, product_id, date
- location_id
- name
- origin_returned_move_id
- picking_id, location_dest_id
- product_id, location_id, location_dest_id, company_id, state
- product_id, location_id, location_dest_id, state
- production_id, location_dest_id
- purchase_line_id
- raw_material_production_id, location_dest_id
- sale_line_id, location_dest_id
- scrapped
- state

SELECT "ir_model_data"."id" as "id","ir_model_data"."module" as "module","ir_model_data"."name" as "name","ir_model_data"."res_id" as "res_id" FROM "ir_model_data" WHERE "ir_model_data".id IN ($1)

Covered by index on (id)
Rows: 6818839
Row progression: 6818839, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- model, res_id
- module, name UNIQUE

SELECT "res_currency"."id" as "id","res_currency"."currency_subunit_label" as "currency_subunit_label","res_currency"."rounding" as "rounding","res_currency"."create_uid" as "create_uid","res_currency"."active" as "active","res_currency"."create_date" as "create_date","res_currency"."currency_unit_label" as "currency_unit_label","res_currency"."position" as "position","res_currency"."symbol" as "symbol","res_currency"."write_date" as "write_date","res_currency"."write_uid" as "write_uid","res_currency"."name" as "name" FROM "res_currency" WHERE "res_currency".id IN ($1)

UPDATE "stock_scrap" SET "warehouse_id"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)

Covered by index on (id)
Rows: 7133
Row progression: 7133, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY

SELECT "mrp_production".id FROM "mrp_production" WHERE ("mrp_production"."id" in ($1)) ORDER BY "mrp_production"."date_planned_start" ASC,"mrp_production"."id"

Covered by index on (id)
Rows: 412902
Row progression: 412902, 1

Row estimates
- id (=): 1
- date_planned_start (sort): 1
- id (sort): 1

Existing indexes
- id PRIMARY
- date_finished
- date_planned_finished
- date_planned_start
- date_start
- name, company_id UNIQUE

SELECT "res_users".id FROM "res_users" LEFT JOIN "res_partner" as "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (("res_users"."active" = $1)  AND  ("res_users"."login" = $2)) ORDER BY "res_users__partner_id"."name" ,"res_users"."login"

UPDATE "stock_scrap" SET "value_food"=$1,"value"=$2,"value_nonfood"=$3,"write_uid"=$4,"write_date"=(now() at time zone $5) WHERE id IN ($6)

Covered by index on (id)
Rows: 7133
Row progression: 7133, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY

UPDATE "stock_scrap" SET "variation"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)

Covered by index on (id)
Rows: 7133
Row progression: 7133, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY

SELECT "purchase_order_line".id FROM "purchase_order_line" WHERE ("purchase_order_line"."id" in ($1)) ORDER BY "purchase_order_line"."id"

Covered by index on (id)
Rows: 177142
Row progression: 177142, 1

Row estimates
- id (=): 1
- id (sort): 1

Existing indexes
- id PRIMARY
- date_planned
- order_id

SELECT "ir_sequence"."id" as "id","ir_sequence"."number_next" as "number_next","ir_sequence"."padding" as "padding","ir_sequence"."active" as "active","ir_sequence"."create_uid" as "create_uid","ir_sequence"."prefix" as "prefix","ir_sequence"."number_increment" as "number_increment","ir_sequence"."auto_reset" as "auto_reset","ir_sequence"."code" as "code","ir_sequence"."implementation" as "implementation","ir_sequence"."write_date" as "write_date","ir_sequence"."company_id" as "company_id","ir_sequence"."last_prefix" as "last_prefix","ir_sequence"."write_uid" as "write_uid","ir_sequence"."use_date_range" as "use_date_range","ir_sequence"."name" as "name","ir_sequence"."create_date" as "create_date","ir_sequence"."suffix" as "suffix" FROM "ir_sequence" WHERE "ir_sequence".id IN ($1)

SELECT "stock_move_line"."id" as "id","stock_move_line"."package_id" as "package_id","stock_move_line"."create_uid" as "create_uid","stock_move_line"."picking_id" as "picking_id","stock_move_line"."workorder_id" as "workorder_id","stock_move_line"."create_date" as "create_date","stock_move_line"."lot_id" as "lot_id","stock_move_line"."write_uid" as "write_uid","stock_move_line"."lot_produced_qty" as "lot_produced_qty","stock_move_line"."move_id" as "move_id","stock_move_line"."production_id" as "production_id","stock_move_line"."done_wo" as "done_wo","stock_move_line"."date" as "date","stock_move_line"."write_date" as "write_date","stock_move_line"."result_package_id" as "result_package_id","stock_move_line"."product_id" as "product_id","stock_move_line"."lot_produced_id" as "lot_produced_id","stock_move_line"."product_uom_qty" as "product_uom_qty","stock_move_line"."owner_id" as "owner_id","stock_move_line"."location_processed" as "location_processed","stock_move_line"."ordered_qty" as "ordered_qty","stock_move_line"."product_uom_id" as "product_uom_id","stock_move_line"."lot_name" as "lot_name","stock_move_line"."location_id" as "location_id","stock_move_line"."move_line_processed" as "move_line_processed","stock_move_line"."qty_done" as "qty_done","stock_move_line"."location_dest_id" as "location_dest_id" FROM "stock_move_line" WHERE "stock_move_line".id IN ($1)

Covered by index on (id)
Rows: 5854267
Row progression: 5854267, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- move_id
- picking_id
- product_id, state
- product_qty, move_id

SELECT "stock_inventory".id FROM "stock_inventory" WHERE ("stock_inventory"."id" in ($1)) ORDER BY "stock_inventory"."date" DESC,"stock_inventory"."id" DESC

Covered by index on (id)
Rows: 70868
Row progression: 70868, 1

Row estimates
- id (=): 1
- date (sort): 1

Existing indexes
- id PRIMARY
- company_id
- state

SELECT "material_requisition"."id" as "id","material_requisition"."name" as "name" FROM "material_requisition" WHERE "material_requisition".id IN ($1)

Covered by index on (id)
Rows: 52665
Row progression: 52665, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY

SELECT latest_version FROM ir_module_module WHERE name=$1

SELECT "stock_inventory_line".id FROM "stock_inventory_line" WHERE $1 ORDER BY "stock_inventory_line"."id"

SELECT "product_template"."id" as "id" FROM "product_template" WHERE "product_template".id IN ($1, $2)

Covered by index on (id)
Rows: 30383
Row progression: 30383, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- company_id
- name

UPDATE "queue_job" SET "channel"=$1 WHERE id IN ($2)

Covered by index on (id)
Rows: 8333974
Row progression: 8333974, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- channel
- company_id
- identity_key WHERE ((state)::text = ANY (ARRAY[('pending'::character varying)::text, ('enqueued'::character varying)::text])) AND (identity_key IS NOT NULL)
- state
- uuid

UPDATE "stock_move_line" SET "move_line_processed"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)

Covered by index on (id)
Rows: 5854267
Row progression: 5854267, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- move_id
- picking_id
- product_id, state
- product_qty, move_id

SELECT "mail_message_subtype".id FROM "mail_message_subtype" WHERE ("mail_message_subtype"."res_model" = $1) ORDER BY "mail_message_subtype"."sequence" ,"mail_message_subtype"."id"

UPDATE "queue_job" SET "identity_key"=$1,"date_enqueued"=$2,"date_started"=$3,"company_id"=$4,"exc_info"=$5,"eta"=$6,"max_retries"=$7,"state"=$8,"result"=$9,"priority"=$10,"user_id"=$11,"retry"=$12,"date_done"=$13 WHERE id IN ($14)

Covered by index on (id)
Rows: 8333974
Row progression: 8333974, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- channel
- company_id
- identity_key WHERE ((state)::text = ANY (ARRAY[('pending'::character varying)::text, ('enqueued'::character varying)::text])) AND (identity_key IS NOT NULL)
- state
- uuid

UPDATE "stock_move" SET "is_done"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)

Covered by index on (id)
Rows: 5958755
Row progression: 5958755, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- company_id
- create_date
- created_production_id
- created_purchase_line_id
- date
- date_expected
- inventory_id, location_dest_id
- location_dest_id, created_purchase_line_id
- location_dest_id, state, product_id, date
- location_id
- name
- origin_returned_move_id
- picking_id, location_dest_id
- product_id, location_id, location_dest_id, company_id, state
- product_id, location_id, location_dest_id, state
- production_id, location_dest_id
- purchase_line_id
- raw_material_production_id, location_dest_id
- sale_line_id, location_dest_id
- scrapped
- state

SELECT product_attribute_value_product_product_rel.product_product_id, product_attribute_value_product_product_rel.product_attribute_value_id FROM product_attribute_value_product_product_rel, "product_attribute_value" LEFT JOIN "product_attribute" as "product_attribute_value__attribute_id" ON ("product_attribute_value"."attribute_id" = "product_attribute_value__attribute_id"."id")
                    WHERE ("product_attribute_value"."active" = $1) AND product_attribute_value_product_product_rel.product_product_id IN ($2, $3) AND product_attribute_value_product_product_rel.product_attribute_value_id = product_attribute_value.id
                     ORDER BY "product_attribute_value"."sequence" ,"product_attribute_value__attribute_id"."sequence" ,"product_attribute_value__attribute_id"."name" ,"product_attribute_value"."id"    OFFSET $4

INSERT INTO "mail_message" ("id", "res_id", "reply_to", "date", "parent_id", "message_type", "email_from", "model", "body", "record_name", "subtype_id", "subject", "author_id", "message_id", "no_auto_thread", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval($1), $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, (now() at time zone $18), (now() at time zone $19)) RETURNING id

SELECT "stock_location"."id" as "id","stock_location"."create_date" as "create_date","stock_location"."parent_right" as "parent_right","stock_location"."name" as "name","stock_location"."partner_id" as "partner_id","stock_location"."active" as "active","stock_location"."scrap_location" as "scrap_location","stock_location"."valuation_in_account_id" as "valuation_in_account_id","stock_location"."write_date" as "write_date","stock_location"."complete_name" as "complete_name","stock_location"."company_id" as "company_id","stock_location"."posx" as "posx","stock_location"."return_location" as "return_location","stock_location"."valuation_out_account_id" as "valuation_out_account_id","stock_location"."barcode" as "barcode","stock_location"."removal_strategy_id" as "removal_strategy_id","stock_location"."posy" as "posy","stock_location"."usage" as "usage","stock_location"."allow_negative_stock" as "allow_negative_stock","stock_location"."create_uid" as "create_uid","stock_location"."posz" as "posz","stock_location"."putaway_strategy_id" as "putaway_strategy_id","stock_location"."comment" as "comment","stock_location"."location_id" as "location_id","stock_location"."write_uid" as "write_uid","stock_location"."parent_left" as "parent_left" FROM "stock_location" WHERE "stock_location".id IN ($1, $2, $3)

SELECT "purchase_order_line".id FROM "purchase_order_line" LEFT JOIN "purchase_order" as "purchase_order_line__order_id" ON ("purchase_order_line"."order_id" = "purchase_order_line__order_id"."id") WHERE $1 ORDER BY "purchase_order_line__order_id"."date_order" DESC,"purchase_order_line__order_id"."id" DESC,"purchase_order_line"."sequence" ,"purchase_order_line"."id"

SELECT * FROM ir_cron
                              WHERE numbercall != $1
                                  AND active AND nextcall <= (now() at time zone $2)
                              ORDER BY priority

SELECT "swk_production_ticket".id FROM "swk_production_ticket" WHERE $1 ORDER BY "swk_production_ticket"."id"

SELECT "product_attribute_line".id FROM "product_attribute_line" WHERE ("product_attribute_line"."product_tmpl_id" in ($1,$2)) ORDER BY "product_attribute_line"."sequence" ,"product_attribute_line"."id"

Covered by index on (product_tmpl_id, attribute_id)
Rows: 3883
Row progression: 3883, 3

Row estimates
- product_tmpl_id (=): 3
- sequence (sort): 299
- id (sort): 1

Existing indexes
- id PRIMARY
- product_tmpl_id, attribute_id UNIQUE

SELECT "product_product"."id" as "id" FROM "product_product" WHERE "product_product".id IN ($1, $2)

Covered by index on (id)
Rows: 1540846
Row progression: 1540846, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- barcode UNIQUE
- default_code
- product_tmpl_id
- product_tmpl_id, default_code

SELECT DISTINCT "scrap_ticket_id" FROM "stock_scrap" WHERE "id" IN ($1)

Covered by index on (id)
Rows: 7133
Row progression: 7133, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY

SELECT "ir_model"."id" as "id","ir_model"."write_uid" as "write_uid","ir_model"."model" as "model","ir_model"."create_date" as "create_date","ir_model"."write_date" as "write_date","ir_model"."info" as "info","ir_model"."name" as "name","ir_model"."is_mail_thread" as "is_mail_thread","ir_model"."transient" as "transient","ir_model"."create_uid" as "create_uid","ir_model"."state" as "state" FROM "ir_model" WHERE "ir_model".id IN ($1)

Covered by index on (id)
Rows: 571
Row progression: 571, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- model UNIQUE

UPDATE "stock_quant" SET "commissary_reserved"=$1,"commissary_quantity"=$2,"write_uid"=$3,"write_date"=(now() at time zone $4) WHERE id IN ($5)

Covered by index on (id)
Rows: 1042929
Row progression: 1042929, 1

Row estimates
- id (=): 1

Existing indexes
- id PRIMARY
- location_id, lot_id, quantity
- lot_id
- product_id, location_id, lot_id

SELECT "stock_location".id FROM "stock_location" WHERE (("stock_location"."active" = $1)  AND  ("stock_location"."usage" = $2)) ORDER BY "stock_location"."parent_left"

SELECT schemaname AS schema, t.relname AS table, ix.relname AS name, regexp_replace(pg_get_indexdef(i.indexrelid), $1, $2) AS columns, regexp_replace(pg_get_indexdef(i.indexrelid), $3, $4) AS using, indisunique AS unique, indisprimary AS primary, indisvalid AS valid, indexprs::text, indpred::text, pg_get_indexdef(i.indexrelid) AS definition FROM pg_index i INNER JOIN pg_class t ON t.oid = i.indrelid INNER JOIN pg_class ix ON ix.oid = i.indexrelid LEFT JOIN pg_stat_user_indexes ui ON ui.indexrelid = i.indexrelid WHERE schemaname IS NOT NULL ORDER BY 1, 2 /*pghero*/