Queries

Total Time	Average Time	Calls
2,501 min 43%	19 ms	8,081,063 odoo
`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` Details `CREATE INDEX CONCURRENTLY ON queue_job (name)` `Rows: 7734585 Row progression: 7734585, 703144, 234381 Row estimates - name (=): 703144 - state (=): 2578195 - date_created (sort): 22 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`
1,893 min 33%	232 ms	489,389 odoo
`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"`
1,034 min 18%	15 ms	4,185,356 odoo
`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` Details `CREATE INDEX CONCURRENTLY ON queue_job (name)` `Rows: 7734585 Row progression: 7734585, 703144, 234381 Row estimates - name (=): 703144 - state (=): 2578195 - date_created (sort): 22 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`
126 min 2%	2 ms	3,956,741 odoo
`SELECT "stock_scrap".id FROM "stock_scrap" WHERE ("stock_scrap"."move_id" in ($1)) ORDER BY "stock_scrap"."id"` Details `CREATE INDEX CONCURRENTLY ON stock_scrap (move_id)` `Rows: 8154 Row progression: 8154, 1 Row estimates - move_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY`
44 min 0.8%	21 ms	124,014 odoo
`SELECT "material_requisition".id FROM "material_requisition" WHERE ("material_requisition"."state" = $1) ORDER BY "material_requisition"."create_date" DESC` Details `CREATE INDEX CONCURRENTLY ON material_requisition (state, create_date)` `Rows: 50330 Row progression: 50330, 16777, 0 Row estimates - state (=): 16777 - create_date (sort): 1 Existing indexes - id PRIMARY`
37 min 0.6%	0 ms	72,404,940 odoo
`DISCARD ALL`
17 min 0.3%	0 ms	64,046,865 odoo
`SELECT id FROM "product_category" WHERE id IN ($1)`
15 min 0.3%	0 ms	34,861,230 odoo
`SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling`
15 min 0.3%	1,107 ms	788 odoo
`SELECT "stock_production_lot".id FROM "stock_production_lot" WHERE ("stock_production_lot"."automatic_scrap" IS NULL or "stock_production_lot"."automatic_scrap" = $1 ) ORDER BY "stock_production_lot"."id"`
14 min 0.2%	668 ms	1,263 odoo
SELECT "material_requisition_line".id FROM "material_requisition_line" LEFT JOIN "res_partner" as "material_requisition_line__partner_id" ON ("material_requisition_line"."partner_id" = "material_requisition_line__partner_id"."id") LEFT JOIN "product_category" as "material_requisition_line__categ_id" ON ("material_requisition_line"."categ_id" = "material_requisition_line__categ_id"."id") LEFT JOIN "product_product" as "material_requisition_line__product_id" ON ("material_requisition_line"."product_id" = "material_requisition_line__product_id"."id") WHERE ("material_requisition_line"."requisition_id" in ($1)) ORDER BY "material_requisition_line__partner_id"."display_name" ,"material_requisition_line__categ_id"."parent_left" ,"material_requisition_line__product_id"."default_code" ,"material_requisition_line__product_id"."id"
11 min 0.2%	16 ms	43,924 odoo
`SELECT "kitchen_ticket".id FROM "kitchen_ticket" WHERE ("kitchen_ticket"."transfer_id" in ($1)) ORDER BY "kitchen_ticket"."id"` Details `CREATE INDEX CONCURRENTLY ON kitchen_ticket (transfer_id)` `Rows: 79293 Row progression: 79293, 1 Row estimates - transfer_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - name - order_id - state`
10 min 0.2%	2 ms	246,793 odoo
`SELECT "stock_scrap".id FROM "stock_scrap" WHERE ("stock_scrap"."scrap_ticket_id" in ($1)) ORDER BY "stock_scrap"."id" DESC` Details `CREATE INDEX CONCURRENTLY ON stock_scrap (scrap_ticket_id)` `Rows: 8154 Row progression: 8154, 1 Row estimates - scrap_ticket_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY`
8 min 0.1%	0 ms	74,951,328 odoo
`BEGIN ISOLATION LEVEL REPEATABLE READ`
5 min < 0.1%	0 ms	1,610,318 odoo
`SELECT "stock_location".id FROM "stock_location" WHERE ("stock_location"."parent_right" >= $1) ORDER BY "stock_location"."parent_left"`
5 min < 0.1%	0 ms	1,610,318 odoo
`SELECT "stock_location".id FROM "stock_location" WHERE ("stock_location"."parent_left" <= $1) ORDER BY "stock_location"."parent_left"`
4 min < 0.1%	0 ms	9,816,714 odoo
`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: 5568534 Row progression: 5568534, 1 Row estimates - move_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
4 min < 0.1%	0 ms	12,032,301 odoo
`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: 164790 Row progression: 164790, 1 Row estimates - move_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - move_id - name - state`
4 min < 0.1%	0 ms	5,345,407 odoo
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: 728 Row progression: 728, 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`
4 min < 0.1%	998 ms	220 odoo
SELECT "material_requisition_line".id FROM "material_requisition_line" LEFT JOIN "res_partner" as "material_requisition_line__partner_id" ON ("material_requisition_line"."partner_id" = "material_requisition_line__partner_id"."id") LEFT JOIN "product_category" as "material_requisition_line__categ_id" ON ("material_requisition_line"."categ_id" = "material_requisition_line__categ_id"."id") LEFT JOIN "product_product" as "material_requisition_line__product_id" ON ("material_requisition_line"."product_id" = "material_requisition_line__product_id"."id") WHERE ((("material_requisition_line"."state" = $1) AND ("material_requisition_line"."dispatch_qty" > $2)) AND "material_requisition_line"."out_transfer_id" IS NULL ) ORDER BY "material_requisition_line__partner_id"."display_name" ,"material_requisition_line__categ_id"."parent_left" ,"material_requisition_line__product_id"."default_code" ,"material_requisition_line__product_id"."id"
3 min < 0.1%	0 ms	1,652,776 odoo
`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`
3 min < 0.1%	0 ms	7,111,782 odoo
`SELECT DISTINCT "picking_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5656816 Row progression: 5656816, 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
3 min < 0.1%	0 ms	7,521,728 odoo
`SELECT DISTINCT "purchase_line_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5656816 Row progression: 5656816, 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
3 min < 0.1%	0 ms	6,035,633 odoo
`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"`
2 min < 0.1%	0 ms	4,859,222 odoo
`SELECT DISTINCT "move_id" FROM "stock_move_line" WHERE "id" IN ($1)` `Covered by index on (id) Rows: 5568534 Row progression: 5568534, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
2 min < 0.1%	0 ms	1,674,057 odoo
`select nextval($1)`
1 min < 0.1%	0 ms	181,681 odoo
`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`
1 min < 0.1%	0 ms	4,277,618 odoo
`SELECT "stock_picking".id FROM "stock_picking" WHERE ("stock_picking"."id" in ($1)) ORDER BY "stock_picking"."id"` `Covered by index on (id) Rows: 3243605 Row progression: 3243605, 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`
1 min < 0.1%	0 ms	3,304,012 odoo
`SELECT DISTINCT "raw_material_production_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5656816 Row progression: 5656816, 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
1 min < 0.1%	0 ms	3,135,836 odoo
`SELECT DISTINCT "inventory_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5656816 Row progression: 5656816, 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
1 min < 0.1%	0 ms	3,101,679 odoo
`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: 3243605 Row progression: 3243605, 1 Row estimates - id (=): 1 - priority (sort): 3243605 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`
1 min < 0.1%	1 ms	107,588 odoo
`SELECT COUNT(*) FROM ir_module_module WHERE state LIKE $1`
1 min < 0.1%	0 ms	1,648,451 odoo
`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: 50330 Row progression: 50330, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY`
1 min < 0.1%	0 ms	36,368,532 odoo
`COMMIT`
1 min < 0.1%	0 ms	2,375,409 odoo
`SELECT DISTINCT "production_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5656816 Row progression: 5656816, 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
1 min < 0.1%	925 ms	63 odoo
SELECT "stock_quant".id FROM "stock_location" as "stock_quant__location_id","stock_quant" WHERE ("stock_quant"."location_id"="stock_quant__location_id"."id") AND ((((((("stock_quant__location_id"."usage" = $1) AND ("stock_quant__location_id"."comment" != $2)) AND ("stock_quant__location_id"."active" = $3)) AND ("stock_quant"."quantity" > $4)) AND "stock_quant"."lot_id" IS NOT NULL) AND ("stock_quant"."removal_date" < $5)) AND ("stock_quant"."lot_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,$1
1 min < 0.1%	0 ms	123,392 odoo
`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: 18343 Row progression: 18343, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - name - state`
1 min < 0.1%	0 ms	123,393 odoo
`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: 18343 Row progression: 18343, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - name - state`
1 min < 0.1%	0 ms	370,126 odoo
`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"` Details `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`
1 min < 0.1%	0 ms	833,164 odoo
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: 728 Row progression: 728, 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`
1 min < 0.1%	0 ms	1,407,416 odoo
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)
1 min < 0.1%	0 ms	1,636,897 odoo
`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: 1414 Row progression: 1414, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY`
1 min < 0.1%	0 ms	277,185 odoo
`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"`
1 min < 0.1%	0 ms	800,921 odoo
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: 30363 Row progression: 30363, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - name`
1 min < 0.1%	0 ms	3,548,786 odoo
`SELECT "mrp_production".id FROM "mrp_production" WHERE ("mrp_production"."id" in ($1)) ORDER BY "mrp_production"."id"` `Covered by index on (id) Rows: 388806 Row progression: 388806, 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`
1 min < 0.1%	0 ms	105,687 odoo
`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`
1 min < 0.1%	0 ms	693,775 odoo
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
1 min < 0.1%	0 ms	123,394 odoo
`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: 18343 Row progression: 18343, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - name - state`
1 min < 0.1%	0 ms	38,582,002 odoo
`ROLLBACK`
1 min < 0.1%	0 ms	1,165,935 odoo
`SELECT DISTINCT "origin_returned_move_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5656816 Row progression: 5656816, 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
0 min < 0.1%	0 ms	6,127,627 odoo
`SELECT "purchase_order".id FROM "purchase_order" WHERE $1 ORDER BY "purchase_order"."id"`
0 min < 0.1%	0 ms	1,165,935 odoo
`SELECT DISTINCT "workorder_id" FROM "stock_move" WHERE "id" IN ($1)` Covered by index on (id) Rows: 5656816 Row progression: 5656816, 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
0 min < 0.1%	0 ms	499,978 odoo
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
0 min < 0.1%	0 ms	4,267,092 odoo
`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"`
0 min < 0.1%	0 ms	204,692 odoo
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: 1540718 Row progression: 1540718, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - barcode UNIQUE - default_code - product_tmpl_id - product_tmpl_id, default_code`
0 min < 0.1%	0 ms	2,448,019 odoo
`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: 388806 Row progression: 388806, 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`
0 min < 0.1%	0 ms	334,000 odoo
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: 487785 Row progression: 487785, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - name, product_id UNIQUE`
0 min < 0.1%	0 ms	3,751,607 odoo
`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: 167351 Row progression: 167351, 1 Row estimates - id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - date_planned - order_id`
0 min < 0.1%	0 ms	338,820 odoo
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)
0 min < 0.1%	0 ms	3,135,858 odoo
`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: 68266 Row progression: 68266, 1 Row estimates - id (=): 1 - date (sort): 1 Existing indexes - id PRIMARY - company_id - state`
0 min < 0.1%	0 ms	262,095 odoo
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)
0 min < 0.1%	0 ms	570,635 odoo
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: 5568534 Row progression: 5568534, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - move_id - picking_id - product_id, state - product_qty, move_id`
0 min < 0.1%	0 ms	272,386 odoo
`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`
0 min < 0.1%	0 ms	181,750 odoo
`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"`
0 min < 0.1%	0 ms	61,973 odoo
`SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id=m.id) WHERE m.model=$1 AND r.active AND r.perm_read AND (r.id IN (SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id=gu.gid) WHERE gu.uid=$2) OR r.global)`
0 min < 0.1%	0 ms	3,112,474 odoo
`SELECT "stock_inventory_line".id FROM "stock_inventory_line" WHERE $1 ORDER BY "stock_inventory_line"."id"`
0 min < 0.1%	8 ms	1,485 odoo
UPDATE "stock_production_lot" SET "automatic_scrap"=$1,"write_uid"=$2,"write_date"=(now() at time zone $3) WHERE id IN ($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) `Covered by index on (id) Rows: 487785 Row progression: 487785, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - name, product_id UNIQUE`
0 min < 0.1%	0 ms	107,588 odoo
`SELECT latest_version FROM ir_module_module WHERE name=$1`
0 min < 0.1%	0 ms	239,742 odoo
`SELECT "product_template"."id" as "id" FROM "product_template" WHERE "product_template".id IN ($1, $2)` `Covered by index on (id) Rows: 30363 Row progression: 30363, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - company_id - name`
0 min < 0.1%	0 ms	1,884,411 odoo
`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"`
0 min < 0.1%	0 ms	304,060 odoo
`SELECT "res_users"."id" as "id" FROM "res_users" WHERE "res_users".id IN ($1)`
0 min < 0.1%	0 ms	353,634 odoo
`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"`
0 min < 0.1%	0 ms	2,146,833 odoo
`SELECT "swk_production_ticket".id FROM "swk_production_ticket" WHERE $1 ORDER BY "swk_production_ticket"."id"`
0 min < 0.1%	0 ms	107,588 odoo
`SELECT * FROM ir_cron WHERE numbercall != $1 AND active AND nextcall <= (now() at time zone $2) ORDER BY priority`
0 min < 0.1%	0 ms	123,476 odoo
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)
0 min < 0.1%	0 ms	84,653 odoo
`SELECT MAX(CASE WHEN perm_read THEN $1 ELSE $2 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = $3 AND gu.uid = $4 AND a.active IS TRUE`
0 min < 0.1%	0 ms	69,592 odoo
`SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."module" = $1) AND ("ir_model_data"."name" = $2)) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name"` Details `CREATE INDEX CONCURRENTLY ON ir_model_data (name)` `Rows: 6818839 Row progression: 6818839, 7 Row estimates - name (=): 7 - module (=): 60882 - module (sort): 60882 - model (sort): 158578 - name (sort): 7 Existing indexes - id PRIMARY - model, res_id - module, name UNIQUE`
0 min < 0.1%	2 ms	5,090 odoo
SELECT "stock_production_lot"."id" as "id","stock_production_lot"."product_uom_id" as "product_uom_id","stock_production_lot"."life_date" as "life_date","stock_production_lot"."alert_date" as "alert_date","stock_production_lot"."expiration_alert" as "expiration_alert","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"."before_expiration_alert" as "before_expiration_alert","stock_production_lot"."ref" as "ref","stock_production_lot"."automatic_scrap_cancelled" as "automatic_scrap_cancelled","stock_production_lot"."write_date" as "write_date","stock_production_lot"."automatic_scrap" as "automatic_scrap","stock_production_lot"."use_next_on_work_order_id" as "use_next_on_work_order_id","stock_production_lot"."message_last_post" as "message_last_post","stock_production_lot"."create_uid" as "create_uid","stock_production_lot"."use_date" as "use_date","stock_production_lot"."name" as "name","stock_production_lot"."product_id" as "product_id" FROM "stock_production_lot" WHERE "stock_production_lot".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) `Covered by index on (id) Rows: 487785 Row progression: 487785, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - name, product_id UNIQUE`
0 min < 0.1%	1 ms	11,438 odoo
`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: 8154 Row progression: 8154, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY`
0 min < 0.1%	0 ms	124,800 odoo
`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`
0 min < 0.1%	3 ms	2,220 odoo
SELECT "stock_quant".id FROM "stock_quant" WHERE ("stock_quant"."lot_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)) ORDER BY "stock_quant"."id" `Covered by index on (lot_id) Rows: 984446 Row progression: 984446, 2 Row estimates - lot_id (=): 2 - id (sort): 1 Existing indexes - id PRIMARY - location_id, lot_id, quantity - lot_id - product_id, location_id, lot_id`
0 min < 0.1%	3 ms	2,220 odoo
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
0 min < 0.1%	0 ms	171,768 odoo
`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`
0 min < 0.1%	0 ms	117,247 odoo
`SELECT "product_product"."id" as "id" FROM "product_product" WHERE "product_product".id IN ($1, $2)` `Covered by index on (id) Rows: 1540718 Row progression: 1540718, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - barcode UNIQUE - default_code - product_tmpl_id - product_tmpl_id, default_code`
0 min < 0.1%	0 ms	310,648 odoo
`SELECT DISTINCT "scrap_ticket_id" FROM "stock_scrap" WHERE "id" IN ($1)` `Covered by index on (id) Rows: 8154 Row progression: 8154, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY`
0 min < 0.1%	0 ms	23,438 odoo
`SELECT "stock_location".id FROM "stock_location" WHERE (("stock_location"."active" = $1) AND ("stock_location"."usage" = $2)) ORDER BY "stock_location"."parent_left"`
0 min < 0.1%	3 ms	2,220 odoo
SELECT "stock_quant"."id" as "id","stock_quant"."lot_id" as "lot_id" FROM "stock_quant" WHERE "stock_quant".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) `Covered by index on (id) Rows: 984446 Row progression: 984446, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - location_id, lot_id, quantity - lot_id - product_id, location_id, lot_id`
0 min < 0.1%	0 ms	157,613 odoo
`SELECT "product_category".id FROM "product_category" WHERE ("product_category"."parent_id" in ($1)) ORDER BY "product_category"."parent_left"`
0 min < 0.1%	0 ms	246,788 odoo
`SELECT "swk_scrap_ticket"."id" as "id" FROM "swk_scrap_ticket" WHERE "swk_scrap_ticket".id IN ($1)` `Covered by index on (id) Rows: 18343 Row progression: 18343, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - name - state`
0 min < 0.1%	2 ms	3,678 odoo
`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`
0 min < 0.1%	0 ms	42,761 odoo
`SELECT $1 FROM res_groups_users_rel WHERE uid=$2 AND gid IN (SELECT res_id FROM ir_model_data WHERE module=$3 AND name=$4)`
0 min < 0.1%	0 ms	310,648 odoo
`SELECT "swk_scrap_ticket".id FROM "swk_scrap_ticket" WHERE ("swk_scrap_ticket"."id" in ($1)) ORDER BY "swk_scrap_ticket"."id"` `Covered by index on (id) Rows: 18343 Row progression: 18343, 1 Row estimates - id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - name - state`
0 min < 0.1%	0 ms	288,195 odoo
`SELECT "mail_message_subtype".id FROM "mail_message_subtype" WHERE ("mail_message_subtype"."res_model" IS NULL OR $1) ORDER BY "mail_message_subtype"."sequence" ,"mail_message_subtype"."id"`
0 min < 0.1%	0 ms	1,165,957 odoo
`SELECT "mrp_workorder".id FROM "mrp_workorder" WHERE ("mrp_workorder"."id" in ($1)) ORDER BY "mrp_workorder"."id"`
0 min < 0.1%	0 ms	1,165,957 odoo
`SELECT "mrp_production".id FROM "mrp_production" WHERE $1 ORDER BY "mrp_production"."id"`
0 min < 0.1%	0 ms	186,364 odoo
`SELECT password, password_crypt FROM res_users WHERE id=$1 AND active`
0 min < 0.1%	0 ms	94,774 odoo
`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"."picking_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"`
0 min < 0.1%	1 ms	5,099 odoo
`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: 8154 Row progression: 8154, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY`
0 min < 0.1%	0 ms	151,524 odoo
`SELECT "mail_message"."id" as "id" FROM "mail_message" WHERE "mail_message".id IN ($1)` `Covered by index on (id) Rows: 26283628 Row progression: 26283628, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - author_id - mail_activity_type_id - message_id - model, res_id - parent_id - res_id - subtype_id`
0 min < 0.1%	0 ms	112,181 odoo
`SELECT "res_users"."id" as "id","res_users__partner_id"."lang" as "lang","res_users__partner_id"."tz" as "tz" FROM "res_users","res_partner" as "res_users__partner_id" WHERE "res_users".id IN ($1) AND ("res_users"."partner_id" = "res_users__partner_id"."id")`
0 min < 0.1%	0 ms	117,308 odoo
`SELECT "stock_picking"."id" as "id" FROM "stock_picking" WHERE "stock_picking".id IN ($1)` `Covered by index on (id) Rows: 3243605 Row progression: 3243605, 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`