Queries

Total Time	Average Time	Calls
837 min 31%	605 ms	82,937 odoo
`SELECT max(id) FROM ir_attachment WHERE create_uid = $1 AND url like $2 GROUP BY datas_fname ORDER BY datas_fname` Details `CREATE INDEX CONCURRENTLY ON ir_attachment USING gist (url gist_trgm_ops)` `Rows: 1259653 Row progression: 1259653, 17 Row estimates - url (~~): 17 - create_uid (=): 314913 - datas_fname (sort): 1 Existing indexes - id PRIMARY - checksum - res_model, res_id - url`
487 min 18%	2,814 ms	10,385 odoo
`SELECT "product_price_history".id FROM "product_price_history" WHERE ((("product_price_history"."company_id" = $1) AND ("product_price_history"."product_id" = $2)) AND ("product_price_history"."datetime" < $3)) ORDER BY "product_price_history"."datetime" DESC,"product_price_history"."id" DESC limit $4` Details `CREATE INDEX CONCURRENTLY ON product_price_history (product_id, datetime)` `Rows: 11412050 Row progression: 11412050, 6185, 619 Row estimates - product_id (=): 6185 - datetime (<): 1141206 - company_id (=): 11412050 - datetime (sort): 6 Existing indexes - id PRIMARY`
455 min 17%	521 ms	52,449 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1)) ORDER BY "swk_suborder"."id"` Details `CREATE INDEX CONCURRENTLY ON swk_suborder (so_line_id)` `Rows: 1102512 Row progression: 1102512, 1 Row estimates - so_line_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
195 min 7%	571 ms	20,450 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1,$2)) ORDER BY "swk_suborder"."id"` Details `CREATE INDEX CONCURRENTLY ON swk_suborder (so_line_id)` `Rows: 1102512 Row progression: 1102512, 1 Row estimates - so_line_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
74 min 3%	574 ms	7,767 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1,$2,$3)) ORDER BY "swk_suborder"."id"` Details `CREATE INDEX CONCURRENTLY ON swk_suborder (so_line_id)` `Rows: 1102512 Row progression: 1102512, 1 Row estimates - so_line_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
63 min 2%	4 ms	988,028 odoo
`SELECT count($1) FROM "order_dispatch" WHERE ((("order_dispatch"."retry" IS NULL or "order_dispatch"."retry" = $2 ) AND ("order_dispatch"."state" = $3)) AND "order_dispatch"."sync_id" IS NULL )`
61 min 2%	4 ms	879,277 odoo
`SELECT "mrp_bom".id FROM "mrp_bom" LEFT JOIN "product_product" as "mrp_bom__product_id" ON ("mrp_bom"."product_id" = "mrp_bom__product_id"."id") WHERE ((("mrp_bom"."active" = $1) AND (("mrp_bom"."product_id" = $2) OR ("mrp_bom"."product_id" IS NULL AND ("mrp_bom"."product_tmpl_id" = $3)))) AND ("mrp_bom"."company_id" = $4)) ORDER BY "mrp_bom"."sequence" ,"mrp_bom__product_id"."default_code" ,"mrp_bom__product_id"."id" limit $5`
40 min 2%	463 ms	5,194 odoo
`SELECT "mrp_production".id FROM "mrp_production" WHERE ("mrp_production"."product_id" in ($1)) ORDER BY "mrp_production"."date_planned_start" ASC,"mrp_production"."id"` Details `CREATE INDEX CONCURRENTLY ON mrp_production (product_id, date_planned_start)` `Rows: 1099308 Row progression: 1099308, 62, 0 Row estimates - product_id (=): 62 - 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`
39 min 1%	0 ms	59,565,952 odoo
`DISCARD ALL`
30 min 1%	566 ms	3,135 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1,$2,$3,$4)) ORDER BY "swk_suborder"."id"` Details `CREATE INDEX CONCURRENTLY ON swk_suborder (so_line_id)` `Rows: 1102512 Row progression: 1102512, 1 Row estimates - so_line_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
26 min 1.0%	13,000 ms	120 odoo
`SELECT res_partner.id FROM "res_partner" WHERE (("res_partner"."type" != $1) OR "res_partner"."type" IS NULL ) AND (res_partner.email ilike $2 OR res_partner.display_name ilike $3 OR res_partner.ref ilike $4 OR res_partner.vat ilike $5) -- don't panic, trust postgres bitmap ORDER BY res_partner.display_name ilike $6 desc, res_partner.display_name`
24 min 0.9%	2,116 ms	691 odoo
`SELECT count($1) FROM "sale_order" WHERE (("sale_order"."warehouse_id" = $2) AND (("sale_order"."fo_state" not in ($3,$4,$5)) OR "sale_order"."fo_state" IS NULL)) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($6))) AND (("sale_order"."warehouse_id" in ($7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17)) OR ("sale_order"."warehouse_id" in ($18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28))))`
18 min 0.7%	5,847 ms	181 odoo
`SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = $1) AND (("res_partner"."type" != $2) OR "res_partner"."type" IS NULL ) AND (res_partner.email ilike $3 OR res_partner.display_name ilike $4 OR res_partner.ref ilike $5 OR res_partner.vat ilike $6) -- don't panic, trust postgres bitmap ORDER BY res_partner.display_name ilike $7 desc, res_partner.display_name`
16 min 0.6%	4,245 ms	226 odoo
`SELECT COUNT(DISTINCT partner_id) FROM sale_order WHERE is_food_order = $1 AND employee_meal = $2 AND state = $3 AND date_order >= $4 AND date_order <= $5 AND warehouse_id = $6 AND partner_id NOT IN (SELECT DISTINCT partner_id FROM sale_order WHERE is_food_order = $7 AND date_order < $8 AND warehouse_id = $9)`
15 min 0.6%	0 ms	29,608,132 odoo
`SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling`
12 min 0.5%	1,259 ms	592 odoo
`SELECT count($1) FROM "sale_order" WHERE (("sale_order"."fo_state" not in ($2,$3,$4)) OR "sale_order"."fo_state" IS NULL) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($5))) AND (("sale_order"."warehouse_id" in ($6)) OR ("sale_order"."warehouse_id" in ($7))))`
12 min 0.5%	566 ms	1,287 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1,$2,$3,$4,$5)) ORDER BY "swk_suborder"."id"` Details `CREATE INDEX CONCURRENTLY ON swk_suborder (so_line_id)` `Rows: 1102512 Row progression: 1102512, 1 Row estimates - so_line_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
11 min 0.4%	0 ms	12,834,582 odoo
`SELECT count($1) FROM "order_dispatch" WHERE ((("order_dispatch"."retry" IS NULL or "order_dispatch"."retry" = $2 ) AND ("order_dispatch"."state" = $3)) AND ("order_dispatch"."source" = $4))`
10 min 0.4%	0 ms	71,021,122 odoo
`BEGIN ISOLATION LEVEL REPEATABLE READ`
8 min 0.3%	0 ms	8,816,071 odoo
`SELECT "order_dispatch".id FROM "order_dispatch" WHERE ((("order_dispatch"."retry" IS NULL or "order_dispatch"."retry" = $1 ) AND ("order_dispatch"."state" = $2)) AND ("order_dispatch"."source" = $3)) ORDER BY "order_dispatch"."create_date" limit $4 offset $5`
8 min 0.3%	702 ms	688 odoo
`SELECT "sale_order".id FROM "sale_order" WHERE (("sale_order"."warehouse_id" = $1) AND (("sale_order"."fo_state" not in ($2,$3,$4)) OR "sale_order"."fo_state" IS NULL)) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($5))) AND (("sale_order"."warehouse_id" in ($6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16)) OR ("sale_order"."warehouse_id" in ($17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27)))) ORDER BY "sale_order"."date_order" DESC,"sale_order"."id" DESC limit $28`
6 min 0.2%	615 ms	598 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1,$2,$3,$4,$5,$6)) ORDER BY "swk_suborder"."id"` Details `CREATE INDEX CONCURRENTLY ON swk_suborder (so_line_id)` `Rows: 1102512 Row progression: 1102512, 1 Row estimates - so_line_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
6 min 0.2%	0 ms	11,603,546 odoo
`SELECT id FROM "res_users" WHERE id IN ($1)`
5 min 0.2%	2,029 ms	160 odoo
`SELECT count($1) FROM "sale_order" WHERE (("sale_order"."fo_state" not in ($2,$3,$4)) OR "sale_order"."fo_state" IS NULL) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($5))) AND (("sale_order"."warehouse_id" in ($6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16)) OR ("sale_order"."warehouse_id" in ($17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27))))`
5 min 0.2%	0 ms	1,001,166 odoo
`SELECT count($1) FROM "order_dispatch" WHERE ((("order_dispatch"."response"::text like $2) AND ("order_dispatch"."create_date" > $3)) AND ("order_dispatch"."state" = $4))`
5 min 0.2%	3 ms	111,485 odoo
`SELECT "mrp_bom".id FROM "mrp_bom" WHERE (("mrp_bom"."active" = $1) AND ("mrp_bom"."product_tmpl_id" in ($2))) ORDER BY "mrp_bom"."sequence"` Details `CREATE INDEX CONCURRENTLY ON mrp_bom (product_tmpl_id)` `Rows: 10996 Row progression: 10996, 1 Row estimates - product_tmpl_id (=): 1 - active (=): 5498 - sequence (sort): 10996 Existing indexes - id PRIMARY`
4 min 0.2%	1,149 ms	226 odoo
SELECT COUNT(DISTINCT so.partner_id) FROM sale_order so WHERE so.is_food_order = $1 AND employee_meal = $2 AND so.state = $3 AND so.date_order >= $4 AND so.date_order <= $5 AND warehouse_id = $6 AND so.partner_id IN (SELECT DISTINCT so2.partner_id FROM sale_order so2 WHERE so2.is_food_order = $7 AND so2.date_order < $8 AND warehouse_id = $9) AND so.brand_id NOT IN (SELECT DISTINCT so3.brand_id FROM sale_order so3 WHERE so3.is_food_order AND so3.partner_id = so.partner_id AND so3.date_order < $10 AND warehouse_id = $11 AND so.brand_id = so3.brand_id)
4 min 0.2%	1,110 ms	226 odoo
`SELECT COUNT(DISTINCT partner_id) FROM sale_order WHERE is_food_order = $1 AND employee_meal = $2 AND state = $3 AND date_order >= $4 AND date_order <= $5 AND warehouse_id = $6 AND partner_id IN (SELECT DISTINCT partner_id FROM sale_order WHERE is_food_order = $7 AND date_order < $8 AND warehouse_id = $9)`
4 min 0.2%	3 ms	83,715 odoo
`SELECT "mrp_bom".id FROM "mrp_bom" WHERE ((("mrp_bom"."active" = $1) AND "mrp_bom"."product_id" IS NULL ) AND ("mrp_bom"."product_tmpl_id" = $2)) ORDER BY "mrp_bom"."sequence" limit $3` Details `CREATE INDEX CONCURRENTLY ON mrp_bom (product_tmpl_id)` `Rows: 10996 Row progression: 10996, 1 Row estimates - product_tmpl_id (=): 1 - active (=): 5498 - product_id (null): 10976 - sequence (sort): 10996 Existing indexes - id PRIMARY`
4 min 0.1%	3 ms	69,012 odoo
`INSERT INTO "mail_message" ("id", "model", "reply_to", "body", "no_auto_thread", "message_type", "author_id", "date", "res_id", "parent_id", "message_id", "record_name", "subtype_id", "email_from", "subject", "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`
4 min 0.1%	1,364 ms	171 odoo
SELECT count($1) FROM "sale_order" WHERE (((("sale_order"."state" in ($2,$3)) AND ("sale_order"."employee_meal" IS NULL or "sale_order"."employee_meal" = $4 )) AND ("sale_order"."warehouse_id" = $5)) AND ("sale_order"."is_food_order" = $6)) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($7))) AND (("sale_order"."warehouse_id" in ($8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24)) OR ("sale_order"."warehouse_id" in ($25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41))))
4 min 0.1%	0 ms	2,351,579 odoo
`SELECT "order_dispatch".id FROM "order_dispatch" WHERE (((("order_dispatch"."retry" IS NULL or "order_dispatch"."retry" = $1 ) AND ("order_dispatch"."edd" <= $2)) AND ("order_dispatch"."state" = $3)) AND "order_dispatch"."sync_id" IS NOT NULL) ORDER BY "order_dispatch"."create_date" limit $4`
3 min 0.1%	2,141 ms	86 odoo
SELECT min("sale_order".id) AS id, count("sale_order".id) AS "warehouse_id_count" , sum("sale_order"."amount_total") AS "amount_total" ,"sale_order"."warehouse_id" as "warehouse_id" FROM "sale_order" LEFT JOIN "stock_warehouse" as "sale_order__warehouse_id" ON ("sale_order"."warehouse_id" = "sale_order__warehouse_id"."id") WHERE (("sale_order"."fo_state" not in ($1,$2,$3)) OR "sale_order"."fo_state" IS NULL) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($4))) AND (("sale_order"."warehouse_id" in ($5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15)) OR ("sale_order"."warehouse_id" in ($16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26)))) GROUP BY "sale_order"."warehouse_id","sale_order__warehouse_id"."name" ORDER BY "sale_order__warehouse_id"."name"
3 min 0.1%	604 ms	291 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1,$2,$3,$4,$5,$6,$7)) ORDER BY "swk_suborder"."id"` Details `CREATE INDEX CONCURRENTLY ON swk_suborder (so_line_id)` `Rows: 1102512 Row progression: 1102512, 1 Row estimates - so_line_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
3 min 0.1%	1,263 ms	132 odoo
SELECT min("order_dispatch".id) AS id, count("order_dispatch".id) AS "__count" , "order_dispatch"."warehouse_id" as "warehouse_id" FROM "order_dispatch" LEFT JOIN "stock_warehouse" as "order_dispatch__warehouse_id" ON ("order_dispatch"."warehouse_id" = "order_dispatch__warehouse_id"."id") WHERE (("order_dispatch"."create_date" >= $1) AND ("order_dispatch"."create_date" <= $2)) GROUP BY "order_dispatch"."warehouse_id","order_dispatch__warehouse_id"."name" ORDER BY "order_dispatch__warehouse_id"."name"
3 min 0.1%	1,254 ms	132 odoo
`SELECT min("order_dispatch".id) AS id, count("order_dispatch".id) AS "__count" , "order_dispatch"."state" as "state" FROM "order_dispatch" WHERE (("order_dispatch"."create_date" >= $1) AND ("order_dispatch"."create_date" <= $2)) GROUP BY "order_dispatch"."state" ORDER BY "state"` Details `CREATE INDEX CONCURRENTLY ON order_dispatch (create_date)` `Rows: 504490 Row progression: 504490, 50449 Row estimates - create_date (>=): 50449 - create_date (<=): 50449 - state (sort): 252245 Existing indexes - id PRIMARY - edd - retry - state - sync_id`
3 min 0.1%	1,252 ms	132 odoo
`SELECT min("order_dispatch".id) AS id, count("order_dispatch".id) AS "__count" FROM "order_dispatch" WHERE (("order_dispatch"."create_date" >= $1) AND ("order_dispatch"."create_date" <= $2))` Details `CREATE INDEX CONCURRENTLY ON order_dispatch (create_date)` `Rows: 504490 Row progression: 504490, 50449 Row estimates - create_date (>=): 50449 - create_date (<=): 50449 Existing indexes - id PRIMARY - edd - retry - state - sync_id`
3 min < 0.1%	612 ms	260 odoo
`SELECT count($1) FROM "sale_order" WHERE (((("sale_order"."state" in ($2,$3)) AND ("sale_order"."employee_meal" IS NULL or "sale_order"."employee_meal" = $4 )) AND ("sale_order"."warehouse_id" = $5)) AND ("sale_order"."is_food_order" = $6)) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($7))) AND (("sale_order"."warehouse_id" in ($8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18)) OR ("sale_order"."warehouse_id" in ($19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29))))`
3 min < 0.1%	5 ms	32,366 odoo
INSERT INTO "stock_move" ("id", "company_id", "name", "rule_id", "is_done", "procure_method", "location_dest_id", "scrapped", "product_uom_qty", "priority", "location_id", "to_refund", "ordered_qty", "group_id", "state", "product_id", "date_expected", "warehouse_id", "date", "partner_id", "sale_line_id", "sequence", "additional", "origin", "propagate", "picking_type_id", "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, $26, $27, $28, $29, (now() at time zone $30), (now() at time zone $31)) RETURNING id
2 min < 0.1%	887 ms	167 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1)) AND (("swk_suborder"."kitchen_id" in ($2)) OR ("swk_suborder"."kitchen_id" in ($3))) ORDER BY "swk_suborder"."id" DESC`
2 min < 0.1%	865 ms	160 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1,$2)) AND (("swk_suborder"."kitchen_id" in ($3)) OR ("swk_suborder"."kitchen_id" in ($4))) ORDER BY "swk_suborder"."id" DESC`
2 min < 0.1%	225 ms	570 odoo
`SELECT count($1) FROM "sale_order" WHERE (((("sale_order"."state" in ($2,$3)) AND ("sale_order"."employee_meal" IS NULL or "sale_order"."employee_meal" = $4 )) AND ("sale_order"."warehouse_id" = $5)) AND ("sale_order"."is_food_order" = $6)) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($7))) AND (("sale_order"."warehouse_id" in ($8)) OR ("sale_order"."warehouse_id" in ($9))))`
2 min < 0.1%	941 ms	132 odoo
SELECT min("order_dispatch".id) AS id, count("order_dispatch".id) AS "__count" , "order_dispatch"."warehouse_id" as "warehouse_id" ,"order_dispatch"."state" as "state" FROM "order_dispatch" LEFT JOIN "stock_warehouse" as "order_dispatch__warehouse_id" ON ("order_dispatch"."warehouse_id" = "order_dispatch__warehouse_id"."id") WHERE (("order_dispatch"."create_date" >= $1) AND ("order_dispatch"."create_date" <= $2)) GROUP BY "order_dispatch"."warehouse_id","order_dispatch"."state","order_dispatch__warehouse_id"."name" ORDER BY "order_dispatch__warehouse_id"."name" ,"state"
2 min < 0.1%	5,868 ms	20 odoo
`SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = $1) AND (res_partner.email ilike $2 OR res_partner.display_name ilike $3 OR res_partner.ref ilike $4 OR res_partner.vat ilike $5) -- don't panic, trust postgres bitmap ORDER BY res_partner.display_name ilike $6 desc, res_partner.display_name`
2 min < 0.1%	16 ms	7,101 odoo
`SELECT "product_product".id FROM "product_product" WHERE (("product_product"."product_tmpl_id" = $1) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($2)))) ORDER BY "product_product"."default_code" ,"product_product"."id"`
2 min < 0.1%	1,490 ms	71 odoo
`SELECT count($1) FROM "sale_order" WHERE (("sale_order"."fo_state" not in ($2,$3,$4)) OR "sale_order"."fo_state" IS NULL) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($5))) AND (("sale_order"."warehouse_id" in ($6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22)) OR ("sale_order"."warehouse_id" in ($23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39))))`
2 min < 0.1%	3 ms	32,366 odoo
`SELECT "mrp_bom".id FROM "mrp_bom" LEFT JOIN "product_product" as "mrp_bom__product_id" ON ("mrp_bom"."product_id" = "mrp_bom__product_id"."id") WHERE (("mrp_bom"."active" = $1) AND (("mrp_bom"."product_id" = $2) OR ("mrp_bom"."product_id" IS NULL AND ("mrp_bom"."product_tmpl_id" = $3)))) ORDER BY "mrp_bom"."sequence" ,"mrp_bom__product_id"."default_code" ,"mrp_bom__product_id"."id" limit $4`
2 min < 0.1%	6,800 ms	15 odoo
`SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = $1) AND ((("res_partner"."type" != $2) OR "res_partner"."type" IS NULL ) OR ("res_partner"."type" = $3)) AND (res_partner.email ilike $4 OR res_partner.display_name ilike $5 OR res_partner.ref ilike $6 OR res_partner.vat ilike $7) -- don't panic, trust postgres bitmap ORDER BY res_partner.display_name ilike $8 desc, res_partner.display_name`
2 min < 0.1%	8 ms	10,961 odoo
SELECT "product_product"."id" as "id","product_product"."product_tmpl_id" as "product_tmpl_id" FROM "product_product" WHERE "product_product".id IN ($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, $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, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000) `Covered by index on (id) Rows: 1137427 Row progression: 1137427, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - barcode UNIQUE - default_code - product_tmpl_id`
2 min < 0.1%	929 ms	100 odoo
`SELECT count($1) FROM "swk_suborder" WHERE ("swk_suborder"."state" in ($2,$3)) AND (("swk_suborder"."kitchen_id" in ($4)) OR ("swk_suborder"."kitchen_id" in ($5)))`
2 min < 0.1%	30,159 ms	3 odoo
SELECT count($1) FROM "sale_order" WHERE ((("sale_order"."fo_state" not in ($2,$3,$4)) OR "sale_order"."fo_state" IS NULL) AND (((("sale_order"."name"::text ilike $5) OR ("sale_order"."client_order_ref"::text ilike $6)) OR ("sale_order"."partner_id" in ($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,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373,$374,$375,$376,$377,$378,$379,$380,$381,$382,$383,$384,$385,$386,$387,$388,$389,$390,$391,$392,$393,$394,$395,$396,$397,$398,$399,$400,$401,$402,$403,$404,$405,$406,$407,$408,$409,$410,$411,$412,$413,$414,$415,$416,$417,$418,$419,$420,$421,$422,$423,$424,$425,$426,$427,$428,$429,$430,$431,$432,$433,$434,$435,$436,$437,$438,$439,$440,$441,$442,$443,$444,$445,$446,$447,$448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,$459,$460,$461,$462,$463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,$474,$475,$476,$477,$478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,$489,$490,$491,$492,$493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,$504,$505,$506,$507,$508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,$519,$520,$521,$522,$523,$524,$525,$526,$527,$528,$529,$530,$531,$532,$533,$534,$535,$536,$537,$538,$539,$540,$541,$542,$543,$544,$545,$546,$547,$548,$549,$550,$551,$552,$553,$554,$555,$556,$557,$558,$559,$560,$561,$562,$563,$564,$565,$566,$567,$568,$569,$570,$571,$572,$573,$574,$575,$576,$577,$578,$579,$580,$581,$582,$583,$584,$585,$586,$587,$588,$589,$590,$591,$592,$593,$594,$595,$596,$597,$598,$599,$600,$601,$602,$603,$604,$605,$606,$607,$608,$609,$610,$611,$612,$613,$614,$615,$616,$617,$618,$619,$620,$621,$622,$623,$624,$625,$626,$627,$628,$629,$630,$631,$632,$633,$634,$635,$636,$637,$638,$639,$640,$641,$642,$643,$644,$645,$646,$647,$648,$649,$650,$651,$652,$653,$654,$655,$656,$657,$658,$659,$660,$661,$662,$663,$664,$665,$666,$667,$668,$669,$670,$671,$672,$673,$674,$675,$676,$677,$678,$679,$680,$681,$682,$683,$684,$685,$686,$687,$688,$689,$690,$691,$692,$693,$694,$695,$696,$697,$698,$699,$700,$701,$702,$703,$704,$705,$706,$707,$708,$709,$710,$711,$712,$713,$714,$715,$716,$717,$718,$719,$720,$721,$722,$723,$724,$725,$726,$727,$728,$729,$730,$731,$732,$733,$734,$735,$736,$737,$738,$739,$740,$741,$742,$743,$744,$745,$746,$747,$748,$749,$750,$751,$752,$753,$754,$755,$756,$757,$758,$759,$760,$761,$762,$763,$764,$765,$766,$767,$768,$769,$770,$771,$772,$773,$774,$775,$776,$777,$778,$779,$780,$781,$782,$783,$784,$785,$786,$787,$788,$789,$790,$791,$792,$793,$794,$795,$796,$797,$798,$799,$800,$801,$802,$803,$804,$805,$806,$807,$808,$809,$810,$811,$812,$813,$814,$815,$816,$817,$818,$819,$820,$821,$822,$823,$824,$825,$826,$827,$828,$829,$830,$831,$832,$833,$834,$835,$836,$837,$838,$839,$840,$841,$842,$843,$844,$845,$846,$847,$848,$849,$850,$851,$852,$853,$854,$855,$856,$857,$858,$859,$860,$861,$862,$863,$864,$865,$866,$867,$868,$869,$870,$871,$872,$873,$874,$875,$876,$877,$878,$879,$880,$881,$882,$883,$884,$885,$886,$887,$888,$889,$890,$891,$892,$893,$894,$895,$896,$897,$898,$899,$900,$901,$902,$903,$904,$905,$906,$907,$908,$909,$910,$911,$912,$913,$914,$915,$916,$917,$918,$919,$920,$921,$922,$923,$924,$925,$926,$927,$928,$929,$930,$931,$932,$933,$934,$935,$936,$937,$938,$939,$940,$941,$942,$943,$944,$945,$946,$947,$948,$949,$950,$951,$952,$953,$954,$955,$956,$957,$958,$959,$960,$961,$962,$963,$964,$965,$966,$967,$968,$969,$970,$971,$972,$973,$974,$975,$976,$977,$978,$979,$980,$981,$982,$983,$984,$985,$986,$987,$988,$989,$990,$991,$992,$993,$994,$995,$996,$997,$998,$999,$1000,$1001,$1002,$1003,$1004,$1005,$1006,$1007,$1008,$1009,$1010,$1011,$1012,$1013,$1014,$1015,$1016,$1017,$1018,$1019,$1020,$1021,$1022,$1023,$1024,$1025,$1026,$1027,$1028,$1029,$1030,$1031,$1032,$1033,$1034,$1035,$1036,$1037,$1038,$1039,$1040,$1041,$1042,$1043,$1044,$1045,$1046,$1047,$1048,$1049,$1050,$1051,$1052,$1053,$1054,$1055,$1056,$1057,$1058,$1059,$1060,$1061,$1062,$1063,$1064,$1065,$1066,$1067,$1068,$1069,$1070,$1071,$1072,$1073,$1074,$1075,$1076,$1077,$1078,$1079,$1080,$1081,$1082,$1083,$1084,$1085,$1086,$1087,$1088,$1089,$1090,$1091,$1092,$1093,$1094,$1095,$1096,$1097,$1098,$1099,$1100,$1101,$1102,$1103,$1104,$1105,$1106,$1107,$1108,$1109,$1110,$1111,$1112,$1113,$1114,$1115,$1116,$1117,$1118,$1119,$1120,$1121,$1122,$1123,$1124,$1125,$1126,$1127,$1128,$1129,$1130,$1131,$1132,$1133,$1134,$1135,$1136,$1137,$1138,$1139,$1140,$1141,$1142,$1143,$1144,$1145,$1146,$1147,$1148,$1149,$1150,$1151,$1152,$1153,$1154,$1155,$1156,$1157,$1158,$1159,$1160,$1161,$1162,$1163,$1164,$1165,$1166,$1167,$1168,$1169,$1170,$1171,$1172,$1173,$1174,$1175,$1176,$1177,$1178,$1179,$1180,$1181,$1182,$1183,$1184,$1185,$1186,$1187,$1188,$1189,$1190,$1191,$1192,$1193,$1194,$1195,$1196,$1197,$1198,$1199,$1200,$1201,$1202,$1203,$1204,$1205,$1206,$1207,$1208,$1209,$1210,$1211,$1212,$1213,$1214,$1215,$1216,$1217,$1218,$1219,$1220,$1221,$1222,$1223,$1224,$1225,$1226,$1227,$1228,$1229,$1230,$1231,$1232,$1233,$1234,$1235,$1236,$1237,$1238,$1239,$1240,$1241,$1242,$1243,$1244,$1245,$1246,$1247,$1248,$1249,$1250,$1251,$1252,$1253,$1254,$1255,$1256,$1257,$1258,$1259,$1260,$1261,$1262,$1263,$1264,$1265,$1266,$1267,$1268,$1269,$1270,$1271,$1272,$1273,$1274,$1275,$1276,$1277,$1278,$1279,$1280,$1281,$1282,$1283,$1284,$1285,$1286,$1287,$1288,$1289,$1290,$1291,$1292,$1293,$1294,$1295,$1296,$1297,$1298,$1299,$1300,$1301,$1302,$1303,$1304,$1305,$1306,$1307,$1308,$1309,$1310,$1311,$1312,$1313,$1314,$1315,$1316,$1317,$1318,$1319,$1320,$1321,$1322,$1323,$1324,$1325,$1326,$1327,$1328,$1329,$1330,$1331,$1332,$1333,$1334,$1335,$1336,$1337,$1338,$1339,$1340,$1341,$1342,$1343,$1344,$1345,$1346,$1347,$1348,$1349,$1350,$1351,$1352,$1353,$1354,$1355,$1356,$1357,$1358,$1359,$1360,$1361,$1362,$1363,$1364,$1365,$1366,$1367,$1368,$1369,$1370,$1371,$1372,$1373,$1374,$1375,$1376,$1377,$1378,$1379,$1380,$1381,$1382,$1383,$1384,$1385,$1386,$1387,$1388,$1389,$1390,$1391,$1392,$1393,$1394,$1395,$1396,$1397,$1398,$1399,$1400,$1401,$1402,$1403,$1404,$1405,$1406,$1407,$1408,$1409,$1410,$1411,$1412,$1413,$1414,$1415,$1416,$1417,$1418,$1419,$1420,$1421,$1422,$1423,$1424,$1425,$1426,$1427,$1428,$1429,$1430,$1431,$1432,$1433,$1434,$1435,$1436,$1437,$1438,$1439,$1440,$1441,$1442,$1443,$1444,$1445,$1446,$1447,$1448,$1449,$1450,$1451,$1452,$1453,$1454,$1455,$1456,$1457,$1458,$1459,$1460,$1461,$1462,$1463,$1464,$1465,$1466,$1467,$1468,$1469,$1470,$1471,$1472,$1473,$1474,$1475,$1476,$1477,$1478,$1479,$1480,$1481,$1482,$1483,$1484,$1485,$1486,$1487,$1488,$1489,$1490,$1491,$1492,$1493,$1494,$1495,$1496,$1497,$1498,$1499,$1500,$1501,$1502,$1503,$1504,$1505,$1506,$1507,$1508,$1509,$1510,$1511,$1512,$1513,$1514,$1515,$1516,$1517,$1518,$1519,$1520,$1521,$1522,$1523,$1524,$1525,$1526,$1527,$1528,$1529,$1530,$1531,$1532,$1533,$1534,$1535,$1536,$1537,$1538,$1539,$1540,$1541,$1542,$1543,$1544,$1545,$1546,$1547,$1548,$1549,$1550,$1551,$1552,$1553,$1554,$1555,$1556,$1557,$1558,$1559,$1560,$1561,$1562,$1563,$1564,$1565,$1566,$1567,$1568,$1569,$1570,$1571,$1572,$1573,$1574,$1575,$1576,$1577,$1578,$1579,$1580,$1581,$1582,$1583,$1584,$1585,$1586,$1587,$1588,$1589,$1590,$1591,$1592,$1593,$1594,$1595,$1596,$1597,$1598,$1599,$1600,$1601,$1602,$1603,$1604,$1605,$1606,$1607,$1608,$1609,$1610,$1611,$1612,$1613,$1614,$1615,$1616,$1617,$1618,$1619,$1620,$1621,$1622,$1623,$1624,$1625,$1626,$1627,$1628,$1629,$1630,$1631,$1632,$1633,$1634,$1635,$1636,$1637,$1638,$1639,$1640,$1641,$1642,$1643,$1644,$1645,$1646,$1647,$1648,$1649,$1650,$1651,$1652,$1653,$1654,$1655,$1656,$1657,$1658,$1659,$1660,$1661,$1662,$1663,$1664,$1665,$1666,$1667,$1668,$1669,$1670,$1671,$1672,$1673,$1674,$1675,$1676,$1677,$1678,$1679,$1680,$1681,$1682,$1683,$1684,$1685,$1686,$1687,$1688,$1689,$1690,$1691,$1692,$1693,$1694,$1695,$1696,$1697,$1698,$1699,$1700,$1701,$1702,$1703,$1704,$1705,$1706,$1707,$1708,$1709,$1710,$1711,$1712,$1713,$1714,$1715,$1716,$1717,$1718,$1719,$1720,$1721,$1722,$1723,$1724,$1725,$1726,$1727,$1728,$1729,$1730,$1731,$1732,$1733,$1734,$1735,$1736,$1737,$1738,$1739,$1740,$1741,$1742,$1743,$1744,$1745,$1746,$1747,$1748,$1749,$1750,$1751,$1752,$1753,$1754,$1755,$1756,$1757,$1758,$1759,$1760,$1761,$1762,$1763,$1764,$1765,$1766,$1767,$1768,$1769,$1770,$1771,$1772,$1773,$1774,$1775,$1776,$1777,$1778,$1779,$1780,$1781,$1782,$1783,$1784,$1785,$1786,$1787,$1788,$1789,$1790,$1791,$1792,$1793,$1794,$1795,$1796,$1797,$1798,$1799,$1800,$1801,$1802,$1803,$1804,$1805,$1806,$1807,$1808,$1809,$1810,$1811
2 min < 0.1%	0 ms	1,468,020 odoo
`SELECT count($1) FROM "order_dispatch" WHERE (("order_dispatch"."retry" IS NULL or "order_dispatch"."retry" = $2 ) AND ("order_dispatch"."state" = $3))`
1 min < 0.1%	25,721 ms	3 odoo
SELECT "sale_order".id FROM "sale_order" WHERE ((("sale_order"."fo_state" not in ($1,$2,$3)) OR "sale_order"."fo_state" IS NULL) AND (((("sale_order"."name"::text ilike $4) OR ("sale_order"."client_order_ref"::text ilike $5)) OR ("sale_order"."partner_id" in ($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,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373,$374,$375,$376,$377,$378,$379,$380,$381,$382,$383,$384,$385,$386,$387,$388,$389,$390,$391,$392,$393,$394,$395,$396,$397,$398,$399,$400,$401,$402,$403,$404,$405,$406,$407,$408,$409,$410,$411,$412,$413,$414,$415,$416,$417,$418,$419,$420,$421,$422,$423,$424,$425,$426,$427,$428,$429,$430,$431,$432,$433,$434,$435,$436,$437,$438,$439,$440,$441,$442,$443,$444,$445,$446,$447,$448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,$459,$460,$461,$462,$463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,$474,$475,$476,$477,$478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,$489,$490,$491,$492,$493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,$504,$505,$506,$507,$508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,$519,$520,$521,$522,$523,$524,$525,$526,$527,$528,$529,$530,$531,$532,$533,$534,$535,$536,$537,$538,$539,$540,$541,$542,$543,$544,$545,$546,$547,$548,$549,$550,$551,$552,$553,$554,$555,$556,$557,$558,$559,$560,$561,$562,$563,$564,$565,$566,$567,$568,$569,$570,$571,$572,$573,$574,$575,$576,$577,$578,$579,$580,$581,$582,$583,$584,$585,$586,$587,$588,$589,$590,$591,$592,$593,$594,$595,$596,$597,$598,$599,$600,$601,$602,$603,$604,$605,$606,$607,$608,$609,$610,$611,$612,$613,$614,$615,$616,$617,$618,$619,$620,$621,$622,$623,$624,$625,$626,$627,$628,$629,$630,$631,$632,$633,$634,$635,$636,$637,$638,$639,$640,$641,$642,$643,$644,$645,$646,$647,$648,$649,$650,$651,$652,$653,$654,$655,$656,$657,$658,$659,$660,$661,$662,$663,$664,$665,$666,$667,$668,$669,$670,$671,$672,$673,$674,$675,$676,$677,$678,$679,$680,$681,$682,$683,$684,$685,$686,$687,$688,$689,$690,$691,$692,$693,$694,$695,$696,$697,$698,$699,$700,$701,$702,$703,$704,$705,$706,$707,$708,$709,$710,$711,$712,$713,$714,$715,$716,$717,$718,$719,$720,$721,$722,$723,$724,$725,$726,$727,$728,$729,$730,$731,$732,$733,$734,$735,$736,$737,$738,$739,$740,$741,$742,$743,$744,$745,$746,$747,$748,$749,$750,$751,$752,$753,$754,$755,$756,$757,$758,$759,$760,$761,$762,$763,$764,$765,$766,$767,$768,$769,$770,$771,$772,$773,$774,$775,$776,$777,$778,$779,$780,$781,$782,$783,$784,$785,$786,$787,$788,$789,$790,$791,$792,$793,$794,$795,$796,$797,$798,$799,$800,$801,$802,$803,$804,$805,$806,$807,$808,$809,$810,$811,$812,$813,$814,$815,$816,$817,$818,$819,$820,$821,$822,$823,$824,$825,$826,$827,$828,$829,$830,$831,$832,$833,$834,$835,$836,$837,$838,$839,$840,$841,$842,$843,$844,$845,$846,$847,$848,$849,$850,$851,$852,$853,$854,$855,$856,$857,$858,$859,$860,$861,$862,$863,$864,$865,$866,$867,$868,$869,$870,$871,$872,$873,$874,$875,$876,$877,$878,$879,$880,$881,$882,$883,$884,$885,$886,$887,$888,$889,$890,$891,$892,$893,$894,$895,$896,$897,$898,$899,$900,$901,$902,$903,$904,$905,$906,$907,$908,$909,$910,$911,$912,$913,$914,$915,$916,$917,$918,$919,$920,$921,$922,$923,$924,$925,$926,$927,$928,$929,$930,$931,$932,$933,$934,$935,$936,$937,$938,$939,$940,$941,$942,$943,$944,$945,$946,$947,$948,$949,$950,$951,$952,$953,$954,$955,$956,$957,$958,$959,$960,$961,$962,$963,$964,$965,$966,$967,$968,$969,$970,$971,$972,$973,$974,$975,$976,$977,$978,$979,$980,$981,$982,$983,$984,$985,$986,$987,$988,$989,$990,$991,$992,$993,$994,$995,$996,$997,$998,$999,$1000,$1001,$1002,$1003,$1004,$1005,$1006,$1007,$1008,$1009,$1010,$1011,$1012,$1013,$1014,$1015,$1016,$1017,$1018,$1019,$1020,$1021,$1022,$1023,$1024,$1025,$1026,$1027,$1028,$1029,$1030,$1031,$1032,$1033,$1034,$1035,$1036,$1037,$1038,$1039,$1040,$1041,$1042,$1043,$1044,$1045,$1046,$1047,$1048,$1049,$1050,$1051,$1052,$1053,$1054,$1055,$1056,$1057,$1058,$1059,$1060,$1061,$1062,$1063,$1064,$1065,$1066,$1067,$1068,$1069,$1070,$1071,$1072,$1073,$1074,$1075,$1076,$1077,$1078,$1079,$1080,$1081,$1082,$1083,$1084,$1085,$1086,$1087,$1088,$1089,$1090,$1091,$1092,$1093,$1094,$1095,$1096,$1097,$1098,$1099,$1100,$1101,$1102,$1103,$1104,$1105,$1106,$1107,$1108,$1109,$1110,$1111,$1112,$1113,$1114,$1115,$1116,$1117,$1118,$1119,$1120,$1121,$1122,$1123,$1124,$1125,$1126,$1127,$1128,$1129,$1130,$1131,$1132,$1133,$1134,$1135,$1136,$1137,$1138,$1139,$1140,$1141,$1142,$1143,$1144,$1145,$1146,$1147,$1148,$1149,$1150,$1151,$1152,$1153,$1154,$1155,$1156,$1157,$1158,$1159,$1160,$1161,$1162,$1163,$1164,$1165,$1166,$1167,$1168,$1169,$1170,$1171,$1172,$1173,$1174,$1175,$1176,$1177,$1178,$1179,$1180,$1181,$1182,$1183,$1184,$1185,$1186,$1187,$1188,$1189,$1190,$1191,$1192,$1193,$1194,$1195,$1196,$1197,$1198,$1199,$1200,$1201,$1202,$1203,$1204,$1205,$1206,$1207,$1208,$1209,$1210,$1211,$1212,$1213,$1214,$1215,$1216,$1217,$1218,$1219,$1220,$1221,$1222,$1223,$1224,$1225,$1226,$1227,$1228,$1229,$1230,$1231,$1232,$1233,$1234,$1235,$1236,$1237,$1238,$1239,$1240,$1241,$1242,$1243,$1244,$1245,$1246,$1247,$1248,$1249,$1250,$1251,$1252,$1253,$1254,$1255,$1256,$1257,$1258,$1259,$1260,$1261,$1262,$1263,$1264,$1265,$1266,$1267,$1268,$1269,$1270,$1271,$1272,$1273,$1274,$1275,$1276,$1277,$1278,$1279,$1280,$1281,$1282,$1283,$1284,$1285,$1286,$1287,$1288,$1289,$1290,$1291,$1292,$1293,$1294,$1295,$1296,$1297,$1298,$1299,$1300,$1301,$1302,$1303,$1304,$1305,$1306,$1307,$1308,$1309,$1310,$1311,$1312,$1313,$1314,$1315,$1316,$1317,$1318,$1319,$1320,$1321,$1322,$1323,$1324,$1325,$1326,$1327,$1328,$1329,$1330,$1331,$1332,$1333,$1334,$1335,$1336,$1337,$1338,$1339,$1340,$1341,$1342,$1343,$1344,$1345,$1346,$1347,$1348,$1349,$1350,$1351,$1352,$1353,$1354,$1355,$1356,$1357,$1358,$1359,$1360,$1361,$1362,$1363,$1364,$1365,$1366,$1367,$1368,$1369,$1370,$1371,$1372,$1373,$1374,$1375,$1376,$1377,$1378,$1379,$1380,$1381,$1382,$1383,$1384,$1385,$1386,$1387,$1388,$1389,$1390,$1391,$1392,$1393,$1394,$1395,$1396,$1397,$1398,$1399,$1400,$1401,$1402,$1403,$1404,$1405,$1406,$1407,$1408,$1409,$1410,$1411,$1412,$1413,$1414,$1415,$1416,$1417,$1418,$1419,$1420,$1421,$1422,$1423,$1424,$1425,$1426,$1427,$1428,$1429,$1430,$1431,$1432,$1433,$1434,$1435,$1436,$1437,$1438,$1439,$1440,$1441,$1442,$1443,$1444,$1445,$1446,$1447,$1448,$1449,$1450,$1451,$1452,$1453,$1454,$1455,$1456,$1457,$1458,$1459,$1460,$1461,$1462,$1463,$1464,$1465,$1466,$1467,$1468,$1469,$1470,$1471,$1472,$1473,$1474,$1475,$1476,$1477,$1478,$1479,$1480,$1481,$1482,$1483,$1484,$1485,$1486,$1487,$1488,$1489,$1490,$1491,$1492,$1493,$1494,$1495,$1496,$1497,$1498,$1499,$1500,$1501,$1502,$1503,$1504,$1505,$1506,$1507,$1508,$1509,$1510,$1511,$1512,$1513,$1514,$1515,$1516,$1517,$1518,$1519,$1520,$1521,$1522,$1523,$1524,$1525,$1526,$1527,$1528,$1529,$1530,$1531,$1532,$1533,$1534,$1535,$1536,$1537,$1538,$1539,$1540,$1541,$1542,$1543,$1544,$1545,$1546,$1547,$1548,$1549,$1550,$1551,$1552,$1553,$1554,$1555,$1556,$1557,$1558,$1559,$1560,$1561,$1562,$1563,$1564,$1565,$1566,$1567,$1568,$1569,$1570,$1571,$1572,$1573,$1574,$1575,$1576,$1577,$1578,$1579,$1580,$1581,$1582,$1583,$1584,$1585,$1586,$1587,$1588,$1589,$1590,$1591,$1592,$1593,$1594,$1595,$1596,$1597,$1598,$1599,$1600,$1601,$1602,$1603,$1604,$1605,$1606,$1607,$1608,$1609,$1610,$1611,$1612,$1613,$1614,$1615,$1616,$1617,$1618,$1619,$1620,$1621,$1622,$1623,$1624,$1625,$1626,$1627,$1628,$1629,$1630,$1631,$1632,$1633,$1634,$1635,$1636,$1637,$1638,$1639,$1640,$1641,$1642,$1643,$1644,$1645,$1646,$1647,$1648,$1649,$1650,$1651,$1652,$1653,$1654,$1655,$1656,$1657,$1658,$1659,$1660,$1661,$1662,$1663,$1664,$1665,$1666,$1667,$1668,$1669,$1670,$1671,$1672,$1673,$1674,$1675,$1676,$1677,$1678,$1679,$1680,$1681,$1682,$1683,$1684,$1685,$1686,$1687,$1688,$1689,$1690,$1691,$1692,$1693,$1694,$1695,$1696,$1697,$1698,$1699,$1700,$1701,$1702,$1703,$1704,$1705,$1706,$1707,$1708,$1709,$1710,$1711,$1712,$1713,$1714,$1715,$1716,$1717,$1718,$1719,$1720,$1721,$1722,$1723,$1724,$1725,$1726,$1727,$1728,$1729,$1730,$1731,$1732,$1733,$1734,$1735,$1736,$1737,$1738,$1739,$1740,$1741,$1742,$1743,$1744,$1745,$1746,$1747,$1748,$1749,$1750,$1751,$1752,$1753,$1754,$1755,$1756,$1757,$1758,$1759,$1760,$1761,$1762,$1763,$1764,$1765,$1766,$1767,$1768,$1769,$1770,$1771,$1772,$1773,$1774,$1775,$1776,$1777,$1778,$1779,$1780,$1781,$1782,$1783,$1784,$1785,$1786,$1787,$1788,$1789,$1790,$1791,$1792,$1793,$1794,$1795,$1796,$1797,$1798,$1799,$1800,$1801,$1802,$1803,$1804,$1805,$1806,$1807,$1808,$1809,$1
1 min < 0.1%	2 ms	41,937 odoo
`UPDATE "ir_attachment" SET "store_fname"=$1,"file_size"=$2,"index_content"=$3,"checksum"=$4,"db_datas"=$5,"write_uid"=$6,"write_date"=(now() at time zone $7) WHERE id IN ($8)` `Covered by index on (id) Rows: 1259653 Row progression: 1259653, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - checksum - res_model, res_id - url`
1 min < 0.1%	4 ms	16,257 odoo
`SELECT "order_dispatch".id FROM "order_dispatch" WHERE ((("order_dispatch"."retry" IS NULL or "order_dispatch"."retry" = $1 ) AND "order_dispatch"."sync_id" IS NULL ) AND ("order_dispatch"."state" = $2)) ORDER BY "order_dispatch"."create_date" limit $3`
1 min < 0.1%	13 ms	5,279 odoo
`SELECT "product_product".id FROM "product_product" WHERE (("product_product"."active" = $1) AND ("product_product"."product_tmpl_id" in ($2))) ORDER BY "product_product"."default_code" ,"product_product"."id"` `Covered by index on (product_tmpl_id) Rows: 1137427 Row progression: 1137427, 545, 273 Row estimates - product_tmpl_id (=): 545 - active (=): 568714 - default_code (sort): 0 - id (sort): 1 Existing indexes - id PRIMARY - barcode UNIQUE - default_code - product_tmpl_id`
1 min < 0.1%	18 ms	3,765 odoo
`SELECT "product_product".id FROM "product_product" WHERE ((("product_product"."product_tmpl_id" = $1) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($2)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($3)))) ORDER BY "product_product"."default_code" ,"product_product"."id"`
1 min < 0.1%	4 ms	16,386 odoo
`SELECT "swk_brand"."id" as "id","swk_brand"."logo" as "logo" FROM "swk_brand" WHERE "swk_brand".id IN ($1)`
1 min < 0.1%	610 ms	103 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1,$2,$3,$4,$5,$6,$7,$8)) ORDER BY "swk_suborder"."id"` Details `CREATE INDEX CONCURRENTLY ON swk_suborder (so_line_id)` `Rows: 1102512 Row progression: 1102512, 1 Row estimates - so_line_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
1 min < 0.1%	0 ms	7,018,731 odoo
`SELECT $2 FROM ONLY "public"."res_users" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x`
1 min < 0.1%	4 ms	16,277 odoo
INSERT INTO "sale_order" ("id", "deliverect_id", "fixed_fee", "commission_percentage", "user_id", "company_id", "name", "deliverect_otp", "vat_percentage", "platform_id", "scheduled_order", "date_order", "picking_policy", "forced_confirmation", "packed", "employee_meal", "warehouse_id", "pickup_time", "food_platform_service_fee", "food_platform_total", "pricelist_id", "jsonrequest", "state", "payment_method", "partner_id", "portfolio_acquisition", "note", "brand_acquisition", "incremental_fee", "access_token", "partner_shipping_id", "team_id", "completed", "partner_invoice_id", "gateway_fee_percentage", "code", "platform_discounted_amount", "is_food_order", "brand_id", "brand_partner_id", "delivery_charge", "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, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, (now() at time zone $44), (now() at time zone $45)) RETURNING id
1 min < 0.1%	0 ms	41,135,919 odoo
`ROLLBACK`
1 min < 0.1%	2,712 ms	20 odoo
SELECT min("sale_order".id) AS id, count("sale_order".id) AS "__count" , sum("sale_order"."amount_total") AS "amount_total" ,date_trunc($1, timezone($2, timezone($3,"sale_order"."date_order"))) as "date_order" FROM "sale_order" WHERE (("sale_order"."fo_state" not in ($4,$5,$6)) OR "sale_order"."fo_state" IS NULL) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($7))) AND (("sale_order"."warehouse_id" in ($8)) OR ("sale_order"."warehouse_id" in ($9)))) GROUP BY date_trunc('month', timezone('Asia/Riyadh', timezone('UTC',"sale_order"."date_order"))) ORDER BY "date_order"
1 min < 0.1%	1 ms	71,990 odoo
`INSERT INTO product_attribute_value_product_configurator_attribute_rel (product_configurator_attribute_id, product_attribute_value_id) (SELECT a, b FROM unnest(ARRAY[$1]) AS a, unnest(ARRAY[$2]) AS b) EXCEPT (SELECT product_configurator_attribute_id, product_attribute_value_id FROM product_attribute_value_product_configurator_attribute_rel WHERE product_configurator_attribute_id IN ($3))`
1 min < 0.1%	1 ms	94,053 odoo
`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`
1 min < 0.1%	2,646 ms	20 odoo
`SELECT min("sale_order".id) AS id, count("sale_order".id) AS "__count" , sum("sale_order"."amount_total") AS "amount_total" FROM "sale_order" WHERE (("sale_order"."fo_state" not in ($1,$2,$3)) OR "sale_order"."fo_state" IS NULL) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($4))) AND (("sale_order"."warehouse_id" in ($5)) OR ("sale_order"."warehouse_id" in ($6))))`
1 min < 0.1%	928 ms	54 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1,$2,$3)) AND (("swk_suborder"."kitchen_id" in ($4)) OR ("swk_suborder"."kitchen_id" in ($5))) ORDER BY "swk_suborder"."id" DESC`
1 min < 0.1%	1 ms	33,306 odoo
`INSERT INTO "swk_suborder" ("id", "quantity", "employee_meal", "menu_item", "printed", "items_in_combo", "so_id", "forced", "food_item", "name", "pending_checked", "so_line_id", "product_uom_id", "state", "processed", "date", "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, (now() at time zone $19), (now() at time zone $20)) RETURNING id`
1 min < 0.1%	687 ms	71 odoo
`SELECT "product_product".id FROM "product_template" as "product_product__product_tmpl_id","product_product" WHERE ("product_product"."product_tmpl_id"="product_product__product_tmpl_id"."id") AND ((("product_product"."active" = $1) AND ("product_product__product_tmpl_id"."categ_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17))) AND ("product_product"."default_code"::text ilike $18)) ORDER BY "product_product"."default_code" ,"product_product"."id" limit $19`
1 min < 0.1%	1 ms	69,542 odoo
`UPDATE "swk_suborder" SET "production_cost"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 1102512 Row progression: 1102512, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
1 min < 0.1%	85 ms	571 odoo
SELECT "product_product".id FROM "product_product" WHERE (((((((("product_product"."product_tmpl_id" = $1) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($2)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($3)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($4)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($5)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($6)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($7)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($8)))) ORDER BY "product_product"."default_code" ,"product_product"."id"
1 min < 0.1%	75 ms	633 odoo
SELECT "product_product".id FROM "product_product" WHERE (((((("product_product"."product_tmpl_id" = $1) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($2)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($3)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($4)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($5)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($6)))) ORDER BY "product_product"."default_code" ,"product_product"."id"
1 min < 0.1%	0 ms	1,001,581 odoo
`SELECT count($1) FROM "order_dispatch" WHERE (("order_dispatch"."state" = $2) AND ("order_dispatch"."source" = $3))`
1 min < 0.1%	1 ms	33,306 odoo
INSERT INTO "mrp_production" ("id", "product_id", "is_locked", "picking_type_id", "origin", "company_id", "date_planned_start", "product_qty", "propagate", "bom_id", "name", "priority", "procurement_group_id", "date_planned_finished", "user_id", "product_uom_id", "location_dest_id", "state", "suborder_id", "location_src_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, $20, $21, $22, (now() at time zone $23), (now() at time zone $24)) RETURNING id
1 min < 0.1%	16 ms	2,725 odoo
SELECT "product_product".id FROM "product_product" WHERE (((("product_product"."product_tmpl_id" = $1) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($2)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($3)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($4)))) ORDER BY "product_product"."default_code" ,"product_product"."id"
1 min < 0.1%	0 ms	29,885,125 odoo
`COMMIT`
1 min < 0.1%	0 ms	98,040 odoo
`UPDATE "order_dispatch" SET "state"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 504490 Row progression: 504490, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - edd - retry - state - sync_id`
1 min < 0.1%	2,356 ms	18 odoo
`SELECT min("order_dispatch".id) AS id, count("order_dispatch".id) AS "__count" , "order_dispatch"."state" as "state" FROM "order_dispatch" WHERE ("order_dispatch"."state" != $1) GROUP BY "order_dispatch"."state" ORDER BY "state"`
1 min < 0.1%	0 ms	105,523 odoo
`INSERT INTO "product_configurator_attribute" ("id", "product_tmpl_id", "minimum", "maximum", "owner_model", "attribute_id", "owner_id", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval($1), $2, $3, $4, $5, $6, $7, $8, $9, (now() at time zone $10), (now() at time zone $11)) RETURNING id`
1 min < 0.1%	0 ms	173,337 odoo
`UPDATE "product_configurator_attribute" SET "write_uid"=$1,"write_date"=(now() at time zone $2) WHERE id IN ($3)` `Covered by index on (id) Rows: 31933538 Row progression: 31933538, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - owner_id - owner_model`
1 min < 0.1%	114 ms	368 odoo
SELECT "product_product".id FROM "product_product" WHERE (((((((((("product_product"."product_tmpl_id" = $1) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($2)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($3)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($4)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($5)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($6)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($7)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($8)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($9)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($10)))) ORDER BY "product_product"."default_code" ,"product_product"."id"
1 min < 0.1%	131 ms	319 odoo
SELECT "product_product".id FROM "product_product" WHERE ((((((((("product_product"."product_tmpl_id" = $1) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($2)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($3)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($4)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($5)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($6)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($7)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($8)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($9)))) ORDER BY "product_product"."default_code" ,"product_product"."id"
1 min < 0.1%	78 ms	534 odoo
SELECT "product_product".id FROM "product_product" WHERE ((((((("product_product"."product_tmpl_id" = $1) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($2)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($3)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($4)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($5)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($6)))) AND ("product_product"."id" in (SELECT "product_product_id" FROM "product_attribute_value_product_product_rel" WHERE "product_attribute_value_id" IN ($7)))) ORDER BY "product_product"."default_code" ,"product_product"."id"
1 min < 0.1%	13,850 ms	3 odoo
SELECT "sale_order".id FROM "sale_order" WHERE ((("sale_order"."fo_state" not in ($1,$2,$3)) OR "sale_order"."fo_state" IS NULL) AND (((("sale_order"."name"::text ilike $4) OR ("sale_order"."client_order_ref"::text ilike $5)) OR ("sale_order"."partner_id" in ($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,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$363,$364,$365,$366,$367,$368,$369,$370,$371,$372,$373,$374,$375,$376,$377,$378,$379,$380,$381,$382,$383,$384,$385,$386,$387,$388,$389,$390,$391,$392,$393,$394,$395,$396,$397,$398,$399,$400,$401,$402,$403,$404,$405,$406,$407,$408,$409,$410,$411,$412,$413,$414,$415,$416,$417,$418,$419,$420,$421,$422,$423,$424,$425,$426,$427,$428,$429,$430,$431,$432,$433,$434,$435,$436,$437,$438,$439,$440,$441,$442,$443,$444,$445,$446,$447,$448,$449,$450,$451,$452,$453,$454,$455,$456,$457,$458,$459,$460,$461,$462,$463,$464,$465,$466,$467,$468,$469,$470,$471,$472,$473,$474,$475,$476,$477,$478,$479,$480,$481,$482,$483,$484,$485,$486,$487,$488,$489,$490,$491,$492,$493,$494,$495,$496,$497,$498,$499,$500,$501,$502,$503,$504,$505,$506,$507,$508,$509,$510,$511,$512,$513,$514,$515,$516,$517,$518,$519,$520,$521,$522,$523,$524,$525,$526,$527,$528,$529,$530,$531,$532,$533,$534,$535,$536,$537,$538,$539,$540,$541,$542,$543,$544,$545,$546,$547,$548,$549,$550,$551,$552,$553,$554,$555,$556,$557,$558,$559,$560,$561,$562,$563,$564,$565,$566,$567,$568,$569,$570,$571,$572,$573,$574,$575,$576,$577,$578,$579,$580,$581,$582,$583,$584,$585,$586,$587,$588,$589,$590,$591,$592,$593,$594,$595,$596,$597,$598,$599,$600,$601,$602,$603,$604,$605,$606,$607,$608,$609,$610,$611,$612,$613,$614,$615,$616,$617,$618,$619,$620,$621,$622,$623,$624))) OR ("sale_order"."unified_receipt_number" = $625))) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($626))) AND (("sale_order"."warehouse_id" in ($627)) OR ("sale_order"."warehouse_id" in ($628)))) ORDER BY "sale_order"."date_order" DESC,"sale_order"."id" DESC limit $629
1 min < 0.1%	349 ms	112 odoo
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/
1 min < 0.1%	2,286 ms	17 odoo
`SELECT count($1) FROM "order_dispatch" WHERE ("order_dispatch"."retry" IS NULL or "order_dispatch"."retry" = $2 )`
1 min < 0.1%	900 ms	43 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1,$2,$3,$4)) AND (("swk_suborder"."kitchen_id" in ($5)) OR ("swk_suborder"."kitchen_id" in ($6))) ORDER BY "swk_suborder"."id" DESC`
1 min < 0.1%	0 ms	125,713 odoo
SELECT "sale_order"."id" as "id","sale_order"."access_token" as "access_token","sale_order"."pricelist_id" as "pricelist_id","sale_order"."incoterm" as "incoterm","sale_order"."scheduled_order" as "scheduled_order","sale_order"."platform_amount_untaxed" as "platform_amount_untaxed","sale_order"."discount_percentage" as "discount_percentage","sale_order"."brand_partner_id" as "brand_partner_id","sale_order"."date_order" as "date_order","sale_order"."platform_amount_tax" as "platform_amount_tax","sale_order"."gross_sales_price_discounted" as "gross_sales_price_discounted","sale_order"."campaign_id" as "campaign_id","sale_order"."validity_date" as "validity_date","sale_order"."date_alert" as "date_alert","sale_order"."platform_amount_total" as "platform_amount_total","sale_order"."delivery_fee" as "delivery_fee","sale_order"."analytic_account_id" as "analytic_account_id","sale_order"."procurement_group_id" as "procurement_group_id","sale_order"."source_id" as "source_id","sale_order"."date_completed" as "date_completed","sale_order"."fo_state" as "fo_state","sale_order"."delivery_fee_vat_amount" as "delivery_fee_vat_amount","sale_order"."code" as "code","sale_order"."warehouse_id" as "warehouse_id","sale_order"."medium_id" as "medium_id","sale_order"."create_date" as "create_date","sale_order"."date_packed" as "date_packed","sale_order"."delivery_fee_net" as "delivery_fee_net","sale_order"."cancelled_state" as "cancelled_state","sale_order"."invoice_number" as "invoice_number","sale_order"."payment_term_id" as "payment_term_id","sale_order"."platform_id" as "platform_id","sale_order"."create_uid" as "create_uid","sale_order"."confirmation_date" as "confirmation_date","sale_order"."activity_date_deadline" as "activity_date_deadline","sale_order"."total_items" as "total_items","sale_order"."cancelled_message" as "cancelled_message","sale_order"."vat_amount" as "vat_amount","sale_order"."brand_id" as "brand_id","sale_order"."fiscal_position_id" as "fiscal_position_id","sale_order"."write_uid" as "write_uid","sale_order"."completed" as "completed","sale_order"."cost_of_food" as "cost_of_food","sale_order"."net_sales_price" as "net_sales_price","sale_order"."company_id" as "company_id","sale_order"."message_last_post" as "message_last_post","sale_order"."packed" as "packed","sale_order"."food_cost" as "food_cost","sale_order"."gateway_fee_amount" as "gateway_fee_amount","sale_order"."deliverect_id" as "deliverect_id","sale_order"."team_id" as "team_id","sale_order"."is_food_order" as "is_food_order","sale_order"."forced_confirmation" as "forced_confirmation","sale_order"."food_cost_nonfood" as "food_cost_nonfood","sale_order"."gateway_fee_vat_amount" as "gateway_fee_vat_amount","sale_order"."deliverect_otp" as "deliverect_otp","sale_order"."employee_meal" as "employee_meal","sale_order"."date_cancelled" as "date_cancelled","sale_order"."gross_sales_price" as "gross_sales_price","sale_order"."commission_amount" as "commission_amount","sale_order"."dh_token" as "dh_token","sale_order"."pickup_time" as "pickup_time","sale_order"."opportunity_id" as "opportunity_id","sale_order"."portfolio_acquisition" as "portfolio_acquisition","sale_order"."discount_amount" as "discount_amount","sale_order"."commission_vat_amount" as "commission_vat_amount","sale_order"."instashop_id" as "instashop_id","sale_order"."state" as "state","sale_order"."brand_acquisition" as "brand_acquisition","sale_order"."net_account_receivable" as "net_account_receivable","sale_order"."gift_error" as "gift_error","sale_order"."zomato_id" as "zomato_id","sale_order"."invoice_status" as "invoice_status","sale_order"."swk_margin" as "swk_margin","sale_order"."fixed_fee" as "fixed_fee","sale_order"."vat_percentage" as "vat_percentage","sale_order"."zomato_otp" as "zomato_otp","sale_order"."commission_percentage" as "commission_percentage","sale_order"."note" as "note","sale_order"."swk_margin_rate" as "swk_margin_rate","sale_order"."incremental_fee" as "incremental_fee","sale_order"."unified_receipt_number" as "unified_receipt_number","sale_order"."amount_untaxed" as "amount_untaxed","sale_order"."cost_of_food_percentage" as "cost_of_food_percentage","sale_order"."delivery_charge" as "delivery_charge","sale_order"."delivery_status" as "delivery_status","sale_order"."write_date" as "write_date","sale_order"."food_cost_percentage" as "food_cost_percentage","sale_order"."amount_tax" as "amount_tax","sale_order"."gateway_fee_percentage" as "gateway_fee_percentage","sale_order"."delivery_tacking_number" as "delivery_tacking_number","sale_order"."amount_total" as "amount_total","sale_order"."food_cost_nonfood_percentage" as "food_cost_nonfood_percentage","sale_order"."food_platform_service_fee" as "food_platform_service_fee","sale_order"."delivery_id" as "delivery_id","sale_order"."margin" as "margin","sale_order"."gems_fee" as "gems_fee","sale_order"."payment_method" as "payment_method","sale_order"."delivery_partner" as "delivery_partner","sale_order"."user_id" as "user_id","sale_order"."picking_policy" as "picking_policy","sale_order"."max_gem" as "max_gem","sale_order"."delivery_json" as "delivery_json","sale_order"."longitude" as "longitude","sale_order"."partner_id" as "partner_id","sale_order"."jsonrequest" as "jsonrequest","sale_order"."gem_fee_payable" as "gem_fee_payable","sale_order"."name" as "name","sale_order"."latitude" as "latitude","sale_order"."partner_invoice_id" as "partner_invoice_id","sale_order"."food_platform_total" as "food_platform_total","sale_order"."commisionable_gmv" as "commisionable_gmv","sale_order"."origin" as "origin","sale_order"."partner_shipping_id" as "partner_shipping_id","sale_order"."loyalty_message" as "loyalty_message","sale_order"."platform_discounted_amount" as "platform_discounted_amount","sale_order"."client_order_ref" as "client_order_ref" FROM "sale_order" WHERE "sale_order".id IN ($1) AND (("sale_order"."company_id" IS NULL OR ("sale_order"."company_id" in ($2))) AND (("sale_order"."warehouse_id" in ($3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19)) OR ("sale_order"."warehouse_id" in ($20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36))))
1 min < 0.1%	1 ms	34,771 odoo
`UPDATE "swk_suborder" SET "manufacturing_order"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 1102512 Row progression: 1102512, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
1 min < 0.1%	104 ms	370 odoo
`SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count" , sum("sale_report"."price_subtotal") AS "price_subtotal" FROM "sale_report" WHERE (("sale_report"."date" <= $1) AND ("sale_report"."date" >= $2)) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in ($3)))`
1 min < 0.1%	340 ms	112 odoo
WITH query_stats AS ( SELECT LEFT(query, $1) AS query, queryid AS query_hash, rolname AS user, ((total_plan_time + total_exec_time) / $2 / $3) AS total_minutes, ((total_plan_time + total_exec_time) / calls) AS average_time, calls FROM pg_stat_statements INNER JOIN pg_database ON pg_database.oid = pg_stat_statements.dbid INNER JOIN pg_roles ON pg_roles.oid = pg_stat_statements.userid WHERE calls > $4 AND pg_database.datname = current_database() ) SELECT query, query AS explainable_query, query_hash, query_stats.user, total_minutes, average_time, calls, total_minutes * $5 / (SELECT SUM(total_minutes) FROM query_stats) AS total_percent, (SELECT SUM(total_minutes) FROM query_stats) AS all_queries_total_minutes FROM query_stats ORDER BY "total_minutes" DESC LIMIT $6 /pghero/
1 min < 0.1%	2,516 ms	15 odoo
`SELECT min("order_dispatch".id) AS id, count("order_dispatch".id) AS "__count" FROM "order_dispatch" WHERE ("order_dispatch"."state" != $1)`
1 min < 0.1%	102 ms	370 odoo
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count" , sum("sale_report"."price_subtotal") AS "price_subtotal" ,"sale_report"."team_id" as "team_id" FROM "sale_report" LEFT JOIN "crm_team" as "sale_report__team_id" ON ("sale_report"."team_id" = "sale_report__team_id"."id") LEFT JOIN (SELECT DISTINCT ON (res_id) res_id, value FROM "ir_translation" WHERE name=$1 AND lang=$2 AND value!=$3 ORDER BY res_id, id DESC) as "sale_report__team_id__name" ON ("sale_report__team_id"."id" = "sale_report__team_id__name"."res_id") WHERE (("sale_report"."date" <= $4) AND ("sale_report"."date" >= $5)) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in ($6))) GROUP BY "sale_report"."team_id",COALESCE("sale_report__team_id__name"."value","sale_report__team_id"."name") ORDER BY COALESCE("sale_report__team_id__name"."value", "sale_report__team_id"."name")
1 min < 0.1%	1 ms	34,771 odoo
`UPDATE "swk_suborder" SET "brand_id"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 1102512 Row progression: 1102512, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
1 min < 0.1%	0 ms	86,006 odoo
SELECT product_attribute_line_product_attribute_value_rel.product_attribute_line_id, product_attribute_line_product_attribute_value_rel.product_attribute_value_id FROM product_attribute_line_product_attribute_value_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") LEFT JOIN (SELECT DISTINCT ON (res_id) res_id, value FROM "ir_translation" WHERE name=$1 AND lang=$2 AND value!=$3 ORDER BY res_id, id DESC) as "product_attribute_value__attribute_id__name" ON ("product_attribute_value__attribute_id"."id" = "product_attribute_value__attribute_id__name"."res_id") WHERE ("product_attribute_value"."active" = $4) AND product_attribute_line_product_attribute_value_rel.product_attribute_line_id IN ($5) AND product_attribute_line_product_attribute_value_rel.product_attribute_value_id = product_attribute_value.id ORDER BY "product_attribute_value"."sequence" ,"product_attribute_value__attribute_id"."sequence" ,COALESCE("product_attribute_value__attribute_id__name"."value", "product_attribute_value__attribute_id"."name") ,"product_attribute_value"."id" OFFSET $6
1 min < 0.1%	1 ms	32,366 odoo
`UPDATE "stock_move" SET "reference"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 1014670 Row progression: 1014670, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - create_date - created_production_id - date - date_expected - location_dest_id - location_id - name - origin_returned_move_id - picking_id - product_id - product_id, location_id, location_dest_id, company_id, state - product_id, location_id, location_dest_id, state - production_id - purchase_line_id - raw_material_production_id - sale_line_id - scrapped - state`
1 min < 0.1%	659 ms	53 odoo
`SELECT "swk_suborder".id FROM "swk_suborder" WHERE ("swk_suborder"."so_line_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9)) ORDER BY "swk_suborder"."id"` Details `CREATE INDEX CONCURRENTLY ON swk_suborder (so_line_id)` `Rows: 1102512 Row progression: 1102512, 1 Row estimates - so_line_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
1 min < 0.1%	93 ms	370 odoo
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count" , sum("sale_report"."price_subtotal") AS "price_subtotal" ,"sale_report"."warehouse_id" as "warehouse_id" FROM "sale_report" LEFT JOIN "stock_warehouse" as "sale_report__warehouse_id" ON ("sale_report"."warehouse_id" = "sale_report__warehouse_id"."id") WHERE (("sale_report"."date" <= $1) AND ("sale_report"."date" >= $2)) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in ($3))) GROUP BY "sale_report"."warehouse_id","sale_report__warehouse_id"."name" ORDER BY "sale_report__warehouse_id"."name"
1 min < 0.1%	1 ms	34,771 odoo
`UPDATE "swk_suborder" SET "order_partner_id"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($4)` `Covered by index on (id) Rows: 1102512 Row progression: 1102512, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - brand_id - date - kitchen_id - manufacturing_order - name - order_partner_id - picking_id - platform_id - so_id - state`
1 min < 0.1%	2,296 ms	15 odoo
`SELECT min("order_dispatch".id) AS id, count("order_dispatch".id) AS "__count" , "order_dispatch"."warehouse_id" as "warehouse_id" FROM "order_dispatch" LEFT JOIN "stock_warehouse" as "order_dispatch__warehouse_id" ON ("order_dispatch"."warehouse_id" = "order_dispatch__warehouse_id"."id") WHERE ("order_dispatch"."state" != $1) GROUP BY "order_dispatch"."warehouse_id","order_dispatch__warehouse_id"."name" ORDER BY "order_dispatch__warehouse_id"."name"`