Queries

Total Time	Average Time	Calls
1,153 min 30%	8 ms	8,456,523 odoo
SELECT "res_partner"."id" as "id", "res_partner"."name" as "name", "res_partner"."display_name" as "display_name", "res_partner"."date" as "date", "res_partner"."title" as "title", "res_partner"."parent_id" as "parent_id", "res_partner"."ref" as "ref", "res_partner"."lang" as "lang", "res_partner"."tz" as "tz", "res_partner"."vat" as "vat", "res_partner"."website" as "website", "res_partner"."comment" as "comment", "res_partner"."active" as "active", "res_partner"."employee" as "employee", "res_partner"."function" as "function", "res_partner"."type" as "type", "res_partner"."street" as "street", "res_partner"."street2" as "street2", "res_partner"."zip" as "zip", "res_partner"."mobile" as "mobile", "res_partner"."is_company" as "is_company", "res_partner"."industry_id" as "industry_id", "res_partner"."company_id" as "company_id", "res_partner"."color" as "color", "res_partner"."partner_share" as "partner_share", "res_partner"."commercial_partner_id" as "commercial_partner_id", "res_partner"."commercial_company_name" as "commercial_company_name", "res_partner"."company_name" as "company_name", "res_partner"."message_main_attachment_id" as "message_main_attachment_id", "res_partner"."email_normalized" as "email_normalized", "res_partner"."message_bounce" as "message_bounce", "res_partner"."email" as "email", "res_partner"."phone" as "phone", "res_partner"."user_id" as "user_id", "res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack", "res_partner"."plan_to_change_car" as "plan_to_change_car", "res_partner"."phone_sanitized" as "phone_sanitized", "res_partner"."debit_limit" as "debit_limit", "res_partner"."last_time_entries_checked" as "last_time_entries_checked", "res_partner"."invoice_warn" as "invoice_warn", "res_partner"."invoice_warn_msg" as "invoice_warn_msg", "res_partner"."supplier_rank" as "supplier_rank", "res_partner"."customer_rank" as "customer_rank", "res_partner"."team_id" as "team_id", "res_partner"."picking_warn" as "picking_warn", "res_partner"."picking_warn_msg" as "picking_warn_msg", COALESCE("res_partner__website_meta_title"."value", "res_partner"."website_meta_title") as "website_meta_title", COALESCE("res_partner__website_meta_description"."value", "res_partner"."website_meta_description") as "website_meta_description", COALESCE("res_partner__website_meta_keywords"."value", "res_partner"."website_meta_keywords") as "website_meta_keywords", "res_partner"."website_meta_og_img" as "website_meta_og_img", COALESCE("res_partner__seo_name"."value", "res_partner"."seo_name") as "seo_name", "res_partner"."website_id" as "website_id", "res_partner"."is_published" as "is_published", "res_partner"."purchase_warn" as "purchase_warn", "res_partner"."purchase_warn_msg" as "purchase_warn_msg", COALESCE("res_partner__website_short_description"."value", "res_partner"."website_short_description") as "website_short_description", "res_partner"."sale_warn" as "sale_warn", "res_partner"."sale_warn_msg" as "sale_warn_msg", "res_partner"."available_in_pos" as "available_in_pos", "res_partner"."whatsapp_number" as "whatsapp_number", "res_partner"."whatsapp_device_id" as "whatsapp_device_id", "res_partner"."city_id" as "city_id", "res_partner"."delivery_area_id" as "delivery_area_id", "res_partner"."city" as "city", "res_partner"."warning_type" as "warning_type", "res_partner"."name_arabic" as "name_arabic", "res_partner"."credit_limit_days" as "credit_limit_days", "res_partner"."partner_latitude" as "partner_latitude", "res_partner"."partner_longitude" as "partner_longitude", "res_partner"."credit_limit" as "credit_limit", "res_partner"."over_credit" as "over_credit", "res_partner"."makani_number" as "makani_number", "res_partner"."stat" as "stat", "res_partner"."rcs" as "rcs", "res_partner"."date_birth" as "date_birth", "res_partner"."relation" as "relation", "res_partner"."nationality_country_id" as "nationality_country_id", "res_partner"."verified" as "verified", "res_partner"."country_id" as "country_id", "res_partner"."receivable_user_id" as "receivable_user_id", "res_partner"."state_id" as "state_id", "res_partner"."partner_group_id" as "partner_group_id", "res_partner"."commercial_group_id" as "commercial_group_id", "res_partner"."tax_id_not_applicable" as "tax_id_not_applicable", "res_partner"."create_uid" as "create_uid", "res_partner"."create_date" as "create_date", "res_partner"."write_uid" as "write_uid", "res_partner"."write_date" as "write_date" FROM "res_partner" LEFT JOIN "ir_translation" AS "res_partner__website_meta_title" ON ("res_partner"."id" = "res_partner__website_meta_title"."res_id" AND "res_partner__website_meta_title"."type" = $1 AND "res_partner__website_meta_title"."name" = $2 AND "res_partner__website_meta_title"."lang" = $3 AND "res_partner__website_meta_title"."value" != $4) LEFT JOIN "ir_translation" AS "res_partner__website_meta_description" ON ("res_partner"."id" = "res_partner__website_meta_description"."res_id" AND "res_partner__website_meta_description"."type" = $5 AND "res_partner__website_meta_description"."name" = $6 AND "res_partner__website_meta_description"."lang" = $7 AND "res_partner__website_meta_description"."value" != $8) LEFT JOIN "ir_translation" AS "res_partner__website_meta_keywords" ON ("res_partner"."id" = "res_partner__website_meta_keywords"."res_id" AND "res_partner__website_meta_keywords"."type" = $9 AND "res_partner__website_meta_keywords"."name" = $10 AND "res_partner__website_meta_keywords"."lang" = $11 AND "res_partner__website_meta_keywords"."value" != $12) LEFT JOIN "ir_translation" AS "res_partner__seo_name" ON ("res_partner"."id" = "res_partner__seo_name"."res_id" AND "res_partner__seo_name"."type" = $13 AND "res_partner__seo_name"."name" = $14 AND "res_partner__seo_name"."lang" = $15 AND "res_partner__seo_name"."value" != $16) LEFT JOIN "ir_translation" AS "res_partner__website_short_description" ON ("res_partner"."id" = "res_partner__website_short_description"."res_id" AND "res_partner__website_short_description"."type" = $17 AND "res_partner__website_short_description"."name" = $18 AND "res_partner__website_short_description"."lang" = $19 AND "res_partner__website_short_description"."value" != $20) WHERE "res_partner".id IN ($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
825 min 21%	6 ms	8,741,583 odoo
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN $1 WHEN age(now() AT TIME ZONE $2, max(B.last_poll)) > interval $3 THEN $4 WHEN age(now() AT TIME ZONE $5, max(B.last_presence)) > interval $6 THEN $7 ELSE $8 END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN ($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) AND U.active = $1009 GROUP BY U.partner_id
271 min 7%	2 ms	9,733,408 odoo
`SELECT res_users.partner_id FROM res_users JOIN hr_leave ON hr_leave.user_id = res_users.id AND state in ($1) AND res_users.active = $2 AND date_from <= $3::timestamp AND date_to >= $4::timestamp`
149 min 4%	3 ms	2,629,173 odoo
SELECT "mail_followers"."id" as "id", "mail_followers"."res_id" as "res_id" FROM "mail_followers" WHERE "mail_followers".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: 2248865 Row progression: 2248865, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - channel_id - partner_id - res_id - res_model - res_model, res_id, channel_id UNIQUE - res_model, res_id, partner_id UNIQUE`
133 min 3%	8 ms	938,843 odoo
`SELECT "mail_followers".id FROM "mail_followers" WHERE (("mail_followers"."res_model" = $1) AND ("mail_followers"."partner_id" in (SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = $2) AND ("res_partner"."id" in ($3)))))) ORDER BY "mail_followers"."id"`
113 min 3%	7 ms	921,711 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"."share" IS NULL or "res_users"."share" = $1 ) AND ("res_users"."sale_team_id" in ($2))) ORDER BY "res_users__partner_id"."name" ,"res_users"."login"`
82 min 2%	18 ms	269,561 odoo
SELECT "res_users"."id" as "id", "res_users"."partner_id" as "partner_id", "res_users"."login" as "login", "res_users"."signature" as "signature", "res_users"."active" as "active", "res_users"."action_id" as "action_id", "res_users"."share" as "share", "res_users"."company_id" as "company_id", "res_users"."notification_type" as "notification_type", "res_users"."microsoft_calendar_token_validity" as "microsoft_calendar_token_validity", "res_users"."karma" as "karma", "res_users"."rank_id" as "rank_id", "res_users"."next_rank_id" as "next_rank_id", "res_users"."odoobot_state" as "odoobot_state", "res_users"."odoobot_failed" as "odoobot_failed", "res_users"."sale_team_id" as "sale_team_id", "res_users"."chatter_position" as "chatter_position", "res_users"."oauth_provider_id" as "oauth_provider_id", "res_users"."oauth_uid" as "oauth_uid", "res_users"."oauth_access_token" as "oauth_access_token", "res_users"."microsoft_calendar_sync_token" as "microsoft_calendar_sync_token", "res_users"."target_sales_won" as "target_sales_won", "res_users"."target_sales_done" as "target_sales_done", "res_users"."website_id" as "website_id", "res_users"."read_only" as "read_only", "res_users"."target_sales_invoiced" as "target_sales_invoiced", "res_users"."helpdesk_target_closed" as "helpdesk_target_closed", "res_users"."helpdesk_target_rating" as "helpdesk_target_rating", "res_users"."helpdesk_target_success" as "helpdesk_target_success", "res_users"."create_uid" as "create_uid", "res_users"."create_date" as "create_date", "res_users"."write_uid" as "write_uid", "res_users"."write_date" as "write_date" 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"."share" IS NULL or "res_users"."share" = $1 ) OR EXISTS ( SELECT $2 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN ($3) ) ) AND (((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = $4 ) OR ("res_users__partner_id"."company_id" in ($5))) OR "res_users__partner_id"."company_id" IS NULL ) AND (((("res_users__partner_id"."type" != $6) OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL ) OR (("res_users__partner_id"."type" = $7) AND ("res_users__partner_id"."create_uid" = $8)))) AND "res_users".id IN ($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)
81 min 2%	18 ms	269,497 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"."partner_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)) AND (("res_users"."share" IS NULL or "res_users"."share" = $1001 ) OR EXISTS ( SELECT $1002 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN ($1003) ) ) AND (((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = $1004 ) OR ("res_users__partner_id"."company_id" in ($1005))) OR "res_users__partner_id"."company_id" IS NULL ) AND (((("res_users__partner_id"."type" != $1006) OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL ) OR (("res_users__partner_id"."type" = $1007) AND ("res_users__partner_id"."create_uid" = $1008)))) ORDER BY "res_users__partner_id"."name" ,"res_users"."login"
78 min 2%	105 ms	44,510 odoo
`SELECT max(id) FROM ir_attachment WHERE create_uid = $1 AND url like $2 GROUP BY name ORDER BY name` Details `CREATE INDEX CONCURRENTLY ON ir_attachment USING gist (url gist_trgm_ops)` `Rows: 681517 Row progression: 681517, 52 Row estimates - url (~~): 52 - create_uid (=): 4605 - name (sort): 24 Existing indexes - id PRIMARY - checksum - original_id - res_model, res_id - url`
72 min 2%	66 ms	65,684 odoo
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = $1) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $2 ) OR ("res_partner"."company_id" in ($3))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $4) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR (("res_partner"."type" = $5) AND ("res_partner"."create_uid" = $6)))) AND (res_partner.email ilike $7 OR res_partner.display_name ilike $8 OR res_partner.ref ilike $9 OR res_partner.vat ilike $10) -- don't panic, trust postgres bitmap ORDER BY res_partner.display_name ilike $11 desc, res_partner.display_name
71 min 2%	403 ms	10,516 odoo
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in (SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ($1,$2)))) AND ("mail_message"."author_id" = $3)) AND ("mail_message"."res_id" != $4)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != $5) OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC LIMIT $6
59 min 2%	8 ms	443,056 odoo
`SELECT "mail_followers".id FROM "mail_followers" WHERE (("mail_followers"."res_model" = $1) AND ("mail_followers"."partner_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in ($2))))) ORDER BY "mail_followers"."id"`
56 min 1%	54 ms	62,309 odoo
SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."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,$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,$1812,$1813,$1814,$1815,$1816,$1817,$1818,$1819,$1820,$1821,$1822,$1823,$1824,$1825,$1826,$1827,$1828,$1829,$1830,$1831,$1832,$1833,$1834,$1835,$1836,$1837,$1838,$1839,
41 min 1%	128 ms	19,069 odoo
SELECT min("account_analytic_line".id) AS id, count("account_analytic_line".id) AS "timesheet_invoice_id_count" , "account_analytic_line"."timesheet_invoice_id" as "timesheet_invoice_id" FROM "account_analytic_line" LEFT JOIN "account_move" AS "account_analytic_line__timesheet_invoice_id" ON ("account_analytic_line"."timesheet_invoice_id" = "account_analytic_line__timesheet_invoice_id"."id") WHERE ("account_analytic_line"."timesheet_invoice_id" in ($1)) AND (("account_analytic_line"."company_id" IS NULL OR ("account_analytic_line"."company_id" in ($2))) AND "account_analytic_line"."project_id" IS NULL ) GROUP BY "account_analytic_line"."timesheet_invoice_id","account_analytic_line__timesheet_invoice_id"."date","account_analytic_line__timesheet_invoice_id"."name","account_analytic_line__timesheet_invoice_id"."id" ORDER BY "account_analytic_line__timesheet_invoice_id"."date" DESC,"account_analytic_line__timesheet_invoice_id"."name" DESC,"account_analytic_line__timesheet_invoice_id"."id" DESC
39 min 1%	253 ms	9,338 odoo
SELECT res_groups_users_rel.gid, res_groups_users_rel.uid FROM res_groups_users_rel, "res_users" LEFT JOIN "res_partner" AS "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (("res_users"."share" IS NULL or "res_users"."share" = $1 ) OR EXISTS ( SELECT $2 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN ($3) ) ) AND (((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = $4 ) OR ("res_users__partner_id"."company_id" in ($5))) OR "res_users__partner_id"."company_id" IS NULL ) AND (((("res_users__partner_id"."type" != $6) OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL ) OR (("res_users__partner_id"."type" = $7) AND ("res_users__partner_id"."create_uid" = $8)))) AND res_groups_users_rel.gid IN ($9) AND res_groups_users_rel.uid = res_users.id ORDER BY "res_users__partner_id"."name" ,"res_users"."login" OFFSET $10
31 min 0.8%	50 ms	37,048 odoo
SELECT "product_product".id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = $1 AND "product_product__product_tmpl_id__name"."name" = $2 AND "product_product__product_tmpl_id__name"."lang" = $3 AND "product_product__product_tmpl_id__name"."value" != $4) WHERE (((("product_product"."active" = $5) AND ("product_product__product_tmpl_id"."purchase_ok" = $6)) AND COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name") ilike $7) AND ($8 OR "product_product"."id" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in ($9)) OR "product_product__product_tmpl_id"."company_id" IS NULL ) ORDER BY "product_product"."default_code" ,COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name") ,"product_product"."id" LIMIT $10
18 min 0.5%	113 ms	9,685 odoo
`SELECT "account_analytic_line".id FROM "account_analytic_line" WHERE ((("account_analytic_line"."so_line" in ($1,$2)) AND ("account_analytic_line"."amount" <= $3)) AND "account_analytic_line"."project_id" IS NOT NULL) AND ("account_analytic_line"."company_id" IS NULL OR ("account_analytic_line"."company_id" in ($4))) ORDER BY "account_analytic_line"."date" DESC,"account_analytic_line"."id" DESC`
15 min 0.4%	122 ms	7,421 odoo
`SELECT "account_analytic_line".id FROM "account_analytic_line" WHERE ("account_analytic_line"."timesheet_invoice_id" in ($1)) ORDER BY "account_analytic_line"."date" DESC,"account_analytic_line"."id" DESC` Details `CREATE INDEX CONCURRENTLY ON account_analytic_line (timesheet_invoice_id)` `Rows: 853626 Row progression: 853626, 0 Row estimates - timesheet_invoice_id (=): 0 - date (sort): 1508 Existing indexes - id PRIMARY - account_id - date - move_id - task_id`
15 min 0.4%	12 ms	75,565 odoo
`SELECT "hr_employee_public".id FROM "hr_employee_public" WHERE ("hr_employee_public"."parent_id" in ($1)) ORDER BY "hr_employee_public"."name"`
15 min 0.4%	114 ms	7,647 odoo
`SELECT "account_analytic_line".id FROM "account_analytic_line" WHERE ((("account_analytic_line"."so_line" in ($1)) AND ("account_analytic_line"."amount" <= $2)) AND "account_analytic_line"."project_id" IS NOT NULL) AND ("account_analytic_line"."company_id" IS NULL OR ("account_analytic_line"."company_id" in ($3))) ORDER BY "account_analytic_line"."date" DESC,"account_analytic_line"."id" DESC`
15 min 0.4%	160 ms	5,458 odoo
SELECT "account_move_line".id FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN "account_account_type" AS "account_move_line__user_type_id" ON ("account_move_line"."user_type_id" = "account_move_line__user_type_id"."id") WHERE ((("account_move_line"."reconciled" IS NULL or "account_move_line"."reconciled" = $1 ) AND (("account_move_line"."account_id" in (SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in (SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."type" = $2))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in ($3))))) AND (("account_move_line__move_id"."state" != $4) OR "account_move_line__move_id"."state" IS NULL))) AND ("account_move_line"."partner_id" in ($5))) AND (("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in ($6))) AND ((("account_move_line__move_id"."move_type" in ($7,$8,$9,$10,$11)) AND (("account_move_line__move_id"."invoice_user_id" = $12) OR "account_move_line__move_id"."invoice_user_id" IS NULL )) OR (("account_move_line__move_id"."move_type" in ($13,$14,$15,$16,$17)) AND ((("account_move_line"."team_id" in (SELECT "crm_team".id FROM "crm_team" WHERE ("crm_team"."id" IN (SELECT "sale_team_id" FROM "res_users" WHERE "id" IN ($18) AND "sale_team_id" IS NOT NULL)))) OR ("account_move_line"."team_id" in (SELECT "crm_team".id FROM "crm_team" WHERE ("crm_team"."id" not in (SELECT "sale_team_id" FROM "res_users" WHERE "sale_team_id" IS NOT NULL))))) OR ("account_move_line"."team_id" in ($19)))))) ORDER BY "account_move_line__user_type_id"."sequence" ,"account_move_line"."date" DESC,"account_move_line"."move_name" DESC,"account_move_line"."id"
13 min 0.3%	9 ms	88,826 odoo
SELECT "hr_employee_public"."id" as "id", "hr_employee_public"."create_date" as "create_date", "hr_employee_public"."name" as "name", "hr_employee_public"."active" as "active", "hr_employee_public"."department_id" as "department_id", "hr_employee_public"."job_id" as "job_id", "hr_employee_public"."job_title" as "job_title", "hr_employee_public"."company_id" as "company_id", "hr_employee_public"."address_id" as "address_id", "hr_employee_public"."mobile_phone" as "mobile_phone", "hr_employee_public"."work_phone" as "work_phone", "hr_employee_public"."work_email" as "work_email", "hr_employee_public"."work_location" as "work_location", "hr_employee_public"."user_id" as "user_id", "hr_employee_public"."resource_id" as "resource_id", "hr_employee_public"."resource_calendar_id" as "resource_calendar_id", "hr_employee_public"."color" as "color", "hr_employee_public"."parent_id" as "parent_id", "hr_employee_public"."coach_id" as "coach_id", "hr_employee_public"."mobility_card" as "mobility_card", "hr_employee_public"."expense_manager_id" as "expense_manager_id", "hr_employee_public"."website_published" as "website_published", "hr_employee_public"."public_info" as "public_info", "hr_employee_public"."code" as "code", "hr_employee_public"."anciennete" as "anciennete", "hr_employee_public"."mode_reglement" as "mode_reglement", "hr_employee_public"."bank" as "bank", "hr_employee_public"."compte" as "compte", "hr_employee_public"."logement" as "logement", "hr_employee_public"."affilie" as "affilie", "hr_employee_public"."irsa" as "irsa", "hr_employee_public"."address_home" as "address_home", "hr_employee_public"."address" as "address", "hr_employee_public"."phone_home" as "phone_home", "hr_employee_public"."licexpiry" as "licexpiry", "hr_employee_public"."licenseno" as "licenseno", "hr_employee_public"."licensetyp" as "licensetyp", "hr_employee_public"."manager" as "manager", "hr_employee_public"."medic_exam" as "medic_exam", "hr_employee_public"."place_of_birth" as "place_of_birth", "hr_employee_public"."cin" as "cin", "hr_employee_public"."cin_date" as "cin_date", "hr_employee_public"."cin_place" as "cin_place", "hr_employee_public"."vehicle" as "vehicle", "hr_employee_public"."vehicle_distance" as "vehicle_distance", "hr_employee_public"."is_birthday" as "is_birthday", "hr_employee_public"."work_company_id" as "work_company_id", "hr_employee_public"."mother" as "mother", "hr_employee_public"."father" as "father", "hr_employee_public"."spouse" as "spouse", "hr_employee_public"."registration_number" as "registration_number", "hr_employee_public"."no_tips" as "no_tips", "hr_employee_public"."work_location_id" as "work_location_id", "hr_employee_public"."health_insurance" as "health_insurance", "hr_employee_public"."life_insurance" as "life_insurance", "hr_employee_public"."uniqueid" as "uniqueid", "hr_employee_public"."gratuity_amount_paid" as "gratuity_amount_paid", "hr_employee_public"."gratuity_amount_held" as "gratuity_amount_held", "hr_employee_public"."preavis" as "preavis", "hr_employee_public"."emergency_contact_id" as "emergency_contact_id", "hr_employee_public"."person_code" as "person_code", "hr_employee_public"."labour_card_number" as "labour_card_number", "hr_employee_public"."labour_card_expiry" as "labour_card_expiry", "hr_employee_public"."contract_id" as "contract_id", "hr_employee_public"."financial_classification" as "financial_classification", "hr_employee_public"."finacial_classification" as "finacial_classification", "hr_employee_public"."date" as "date", "hr_employee_public"."service_years" as "service_years", "hr_employee_public"."weekbirthday" as "weekbirthday", "hr_employee_public"."fingerprint_registered" as "fingerprint_registered", "hr_employee_public"."fingerprint_size" as "fingerprint_size", "hr_employee_public"."nationality" as "nationality", "hr_employee_public"."job" as "job", "hr_employee_public"."refer_partner_id" as "refer_partner_id", "hr_employee_public"."passport_expiry" as "passport_expiry", "hr_employee_public"."health_card" as "health_card", "hr_employee_public"."health_card_expiry" as "health_card_expiry", "hr_employee_public"."eid_expiry" as "eid_expiry", "hr_employee_public"."division_id" as "division_id", "hr_employee_public"."absconded_date" as "absconded_date", "hr_employee_public"."structure_type_id" as "structure_type_id", "hr_employee_public"."allocation_month" as "allocation_month", "hr_employee_public"."allocation_message" as "allocation_message", "hr_employee_public"."meal_provided" as "meal_provided", "hr_employee_public"."accomodation_asset_id" as "accomodation_asset_id", "hr_employee_public"."last_attendance_id" as "last_attendance_id", "hr_employee_public"."last_check_in" as "last_check_in", "hr_employee_public"."last_check_out" as "last_check_out", "hr_employee_public"."leave_manager_id" as "leave_manager_id", "hr_employee_public"."create_uid" as "create_uid", "hr_employee_public"."write_uid" as "write_uid", "hr_employee_public"."write_date" as "write_date" FROM "hr_employee_public" WHERE "hr_employee_public".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
13 min 0.3%	60 ms	13,155 odoo
SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count" , "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in ($1)) AND (("account_move"."company_id" IS NULL OR ("account_move"."company_id" in ($2))) AND (("account_move"."company_id" IS NULL OR ("account_move"."company_id" in ($3))) OR ("account_move"."move_type" in ($4,$5,$6)))) GROUP BY "account_move"."debit_origin_id","account_move__debit_origin_id"."date","account_move__debit_origin_id"."name","account_move__debit_origin_id"."id" ORDER BY "account_move__debit_origin_id"."date" DESC,"account_move__debit_origin_id"."name" DESC,"account_move__debit_origin_id"."id" DESC
13 min 0.3%	25 ms	31,134 odoo
`SELECT "purchase_requisition_line".id FROM "purchase_requisition_line" WHERE ("purchase_requisition_line"."requisition_id" in ($1)) AND ("purchase_requisition_line"."company_id" IS NULL OR ("purchase_requisition_line"."company_id" in ($2))) ORDER BY "purchase_requisition_line"."id"`
13 min 0.3%	3 ms	247,287 odoo
`SELECT "account_payment".id FROM "account_payment" WHERE ("account_payment"."move_id" in ($1)) ORDER BY "account_payment"."id"` Details `CREATE INDEX CONCURRENTLY ON account_payment (move_id)` `Rows: 29166 Row progression: 29166, 1 Row estimates - move_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - message_main_attachment_id`
12 min 0.3%	57 ms	13,155 odoo
`SELECT "account_move".id FROM "account_move" WHERE ("account_move"."prepayment_invoice_id" in ($1)) AND (("account_move"."company_id" IS NULL OR ("account_move"."company_id" in ($2))) AND (("account_move"."company_id" IS NULL OR ("account_move"."company_id" in ($3))) OR ("account_move"."move_type" in ($4,$5,$6)))) ORDER BY "account_move"."date" DESC,"account_move"."name" DESC,"account_move"."id" DESC`
11 min 0.3%	9 ms	75,147 odoo
SELECT "res_partner"."id" as "id", "res_partner"."name" as "name", "res_partner"."display_name" as "display_name", "res_partner"."date" as "date", "res_partner"."title" as "title", "res_partner"."parent_id" as "parent_id", "res_partner"."ref" as "ref", "res_partner"."lang" as "lang", "res_partner"."tz" as "tz", "res_partner"."vat" as "vat", "res_partner"."website" as "website", "res_partner"."comment" as "comment", "res_partner"."active" as "active", "res_partner"."employee" as "employee", "res_partner"."function" as "function", "res_partner"."type" as "type", "res_partner"."street" as "street", "res_partner"."street2" as "street2", "res_partner"."zip" as "zip", "res_partner"."mobile" as "mobile", "res_partner"."is_company" as "is_company", "res_partner"."industry_id" as "industry_id", "res_partner"."company_id" as "company_id", "res_partner"."color" as "color", "res_partner"."partner_share" as "partner_share", "res_partner"."commercial_partner_id" as "commercial_partner_id", "res_partner"."commercial_company_name" as "commercial_company_name", "res_partner"."company_name" as "company_name", "res_partner"."message_main_attachment_id" as "message_main_attachment_id", "res_partner"."email_normalized" as "email_normalized", "res_partner"."message_bounce" as "message_bounce", "res_partner"."email" as "email", "res_partner"."phone" as "phone", "res_partner"."user_id" as "user_id", "res_partner"."signup_token" as "signup_token", "res_partner"."signup_type" as "signup_type", "res_partner"."signup_expiration" as "signup_expiration", "res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack", "res_partner"."plan_to_change_car" as "plan_to_change_car", "res_partner"."phone_sanitized" as "phone_sanitized", "res_partner"."debit_limit" as "debit_limit", "res_partner"."last_time_entries_checked" as "last_time_entries_checked", "res_partner"."invoice_warn" as "invoice_warn", "res_partner"."invoice_warn_msg" as "invoice_warn_msg", "res_partner"."supplier_rank" as "supplier_rank", "res_partner"."customer_rank" as "customer_rank", "res_partner"."team_id" as "team_id", "res_partner"."picking_warn" as "picking_warn", "res_partner"."picking_warn_msg" as "picking_warn_msg", COALESCE("res_partner__website_meta_title"."value", "res_partner"."website_meta_title") as "website_meta_title", COALESCE("res_partner__website_meta_description"."value", "res_partner"."website_meta_description") as "website_meta_description", COALESCE("res_partner__website_meta_keywords"."value", "res_partner"."website_meta_keywords") as "website_meta_keywords", "res_partner"."website_meta_og_img" as "website_meta_og_img", COALESCE("res_partner__seo_name"."value", "res_partner"."seo_name") as "seo_name", "res_partner"."website_id" as "website_id", "res_partner"."is_published" as "is_published", "res_partner"."purchase_warn" as "purchase_warn", "res_partner"."purchase_warn_msg" as "purchase_warn_msg", COALESCE("res_partner__website_short_description"."value", "res_partner"."website_short_description") as "website_short_description", "res_partner"."sale_warn" as "sale_warn", "res_partner"."sale_warn_msg" as "sale_warn_msg", "res_partner"."available_in_pos" as "available_in_pos", "res_partner"."whatsapp_number" as "whatsapp_number", "res_partner"."whatsapp_device_id" as "whatsapp_device_id", "res_partner"."city_id" as "city_id", "res_partner"."delivery_area_id" as "delivery_area_id", "res_partner"."city" as "city", "res_partner"."warning_type" as "warning_type", "res_partner"."name_arabic" as "name_arabic", "res_partner"."credit_limit_days" as "credit_limit_days", "res_partner"."partner_latitude" as "partner_latitude", "res_partner"."partner_longitude" as "partner_longitude", "res_partner"."credit_limit" as "credit_limit", "res_partner"."over_credit" as "over_credit", "res_partner"."makani_number" as "makani_number", "res_partner"."stat" as "stat", "res_partner"."rcs" as "rcs", "res_partner"."date_birth" as "date_birth", "res_partner"."relation" as "relation", "res_partner"."nationality_country_id" as "nationality_country_id", "res_partner"."verified" as "verified", "res_partner"."country_id" as "country_id", "res_partner"."receivable_user_id" as "receivable_user_id", "res_partner"."state_id" as "state_id", "res_partner"."partner_group_id" as "partner_group_id", "res_partner"."commercial_group_id" as "commercial_group_id", "res_partner"."tax_id_not_applicable" as "tax_id_not_applicable", "res_partner"."create_uid" as "create_uid", "res_partner"."create_date" as "create_date", "res_partner"."write_uid" as "write_uid", "res_partner"."write_date" as "write_date" FROM "res_partner" LEFT JOIN "ir_translation" AS "res_partner__website_meta_title" ON ("res_partner"."id" = "res_partner__website_meta_title"."res_id" AND "res_partner__website_meta_title"."type" = $1 AND "res_partner__website_meta_title"."name" = $2 AND "res_partner__website_meta_title"."lang" = $3 AND "res_partner__website_meta_title"."value" != $4) LEFT JOIN "ir_translation" AS "res_partner__website_meta_description" ON ("res_partner"."id" = "res_partner__website_meta_description"."res_id" AND "res_partner__website_meta_description"."type" = $5 AND "res_partner__website_meta_description"."name" = $6 AND "res_partner__website_meta_description"."lang" = $7 AND "res_partner__website_meta_description"."value" != $8) LEFT JOIN "ir_translation" AS "res_partner__website_meta_keywords" ON ("res_partner"."id" = "res_partner__website_meta_keywords"."res_id" AND "res_partner__website_meta_keywords"."type" = $9 AND "res_partner__website_meta_keywords"."name" = $10 AND "res_partner__website_meta_keywords"."lang" = $11 AND "res_partner__website_meta_keywords"."value" != $12) LEFT JOIN "ir_translation" AS "res_partner__seo_name" ON ("res_partner"."id" = "res_partner__seo_name"."res_id" AND "res_partner__seo_name"."type" = $13 AND "res_partner__seo_name"."name" = $14 AND "res_partner__seo_name"."lang" = $15 AND "res_partner__seo_name"."value" != $16) LEFT JOIN "ir_translation" AS "res_partner__website_short_description" ON ("res_partner"."id" = "res_partner__website_short_description"."res_id" AND "res_partner__website_short_description"."type" = $17 AND "res_partner__website_short_description"."name" = $18 AND "res_partner__website_short_description"."lang" = $19 AND "res_partner__website_short_description"."value" != $20) WHERE "res_partner".id IN ($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, $6
11 min 0.3%	0 ms	23,766,151 odoo
`DISCARD ALL`
10 min 0.3%	168 ms	3,699 odoo
SELECT sum( l.balance ) AS balance, sum( COALESCE( (SELECT SUM(amount) FROM account_partial_reconcile WHERE credit_move_id = l.id AND max_date <= $1), $2 ) ) AS sum_debit, sum( COALESCE( (SELECT SUM(amount) FROM account_partial_reconcile WHERE debit_move_id = l.id AND max_date <= $3), $4 ) ) AS sum_credit FROM account_move_line AS l LEFT JOIN account_move AS m ON m.id = l.move_id LEFT JOIN account_account AS a ON a.id = l.account_id LEFT JOIN account_account_type AS ty ON a.user_type_id = ty.id WHERE l.balance <> $5 AND m.state = $6 AND ty.type IN ($7, $8) AND l.company_id = $9 AND l.account_id in ($10, $11, $12) AND l.date <= $13 AND m.commercial_partner_id = $14 AND COALESCE(l.date_maturity,l.date) BETWEEN $15 AND $16
10 min 0.3%	12 ms	50,035 odoo
SELECT "hr_attendance".id FROM "hr_attendance" WHERE ((("hr_attendance"."employee_id" = $1) AND ("hr_attendance"."check_in" <= $2)) AND (("hr_attendance"."id" != $3) OR "hr_attendance"."id" IS NULL)) AND (("hr_attendance"."employee_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE "hr_employee"."company_id" IS NULL )) OR ("hr_attendance"."employee_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."company_id" in ($4,$5,$6,$7,$8,$9,$10,$11))))) ORDER BY "hr_attendance"."check_in" DESC LIMIT $12
10 min 0.3%	47 ms	13,019 odoo
`SELECT mail_channel_partner.channel_id, mail_channel_partner.partner_id FROM mail_channel_partner, "res_partner" WHERE $1=$2 AND mail_channel_partner.channel_id IN ($3) AND mail_channel_partner.partner_id = res_partner.id ORDER BY "res_partner"."display_name" OFFSET $4`
10 min 0.3%	12 ms	48,998 odoo
SELECT "hr_attendance"."id" as "id", "hr_attendance"."check_in" as "check_in", "hr_attendance"."check_out" as "check_out", "hr_attendance"."overtime_check" as "overtime_check", "hr_attendance"."name" as "name", "hr_attendance"."method" as "method", "hr_attendance"."clock_id" as "clock_id", "hr_attendance"."employee_id" as "employee_id", "hr_attendance"."analytic_account_id" as "analytic_account_id", "hr_attendance"."worked_hours_manual" as "worked_hours_manual", "hr_attendance"."team_id" as "team_id", "hr_attendance"."create_uid" as "create_uid", "hr_attendance"."create_date" as "create_date", "hr_attendance"."write_uid" as "write_uid", "hr_attendance"."write_date" as "write_date" FROM "hr_attendance" WHERE (("hr_attendance"."employee_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE "hr_employee"."company_id" IS NULL )) OR ("hr_attendance"."employee_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."company_id" in ($1,$2,$3,$4,$5,$6,$7,$8))))) AND "hr_attendance".id IN ($9)
10 min 0.3%	12 ms	49,416 odoo
SELECT "hr_attendance".id FROM "hr_attendance" WHERE ((("hr_attendance"."employee_id" = $1) AND ("hr_attendance"."check_in" < $2)) AND (("hr_attendance"."id" != $3) OR "hr_attendance"."id" IS NULL)) AND (("hr_attendance"."employee_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE "hr_employee"."company_id" IS NULL )) OR ("hr_attendance"."employee_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."company_id" in ($4,$5,$6,$7,$8,$9,$10,$11))))) ORDER BY "hr_attendance"."check_in" DESC LIMIT $12
9 min 0.2%	19 ms	30,095 odoo
`SELECT "hr_employee_public".id FROM "hr_employee_public" WHERE ("hr_employee_public"."parent_id" in ($1,$2,$3)) ORDER BY "hr_employee_public"."name"`
9 min 0.2%	13 ms	42,508 odoo
`SELECT "hr_employee".id FROM "hr_employee" WHERE (("hr_employee"."active" = $1) AND (("hr_employee"."code" = $2) OR ("hr_employee"."name" = $3))) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($4,$5,$6,$7,$8,$9,$10,$11))) ORDER BY "hr_employee"."code" LIMIT $12`
8 min 0.2%	13 ms	37,474 odoo
SELECT "hr_employee_public".id FROM "hr_employee_public" WHERE ("hr_employee_public"."parent_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)) ORDER BY "hr_employee_public"."name"
7 min 0.2%	63 ms	6,811 odoo
SELECT "account_move_line".id FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN "account_account_type" AS "account_move_line__user_type_id" ON ("account_move_line"."user_type_id" = "account_move_line__user_type_id"."id") WHERE ((("account_move_line"."reconciled" IS NULL or "account_move_line"."reconciled" = $1 ) AND (("account_move_line"."account_id" in (SELECT "account_account".id FROM "account_account" WHERE ("account_account"."user_type_id" in (SELECT "account_account_type".id FROM "account_account_type" WHERE ("account_account_type"."type" = $2))) AND ("account_account"."company_id" IS NULL OR ("account_account"."company_id" in ($3))))) AND (("account_move_line__move_id"."state" != $4) OR "account_move_line__move_id"."state" IS NULL))) AND ("account_move_line"."partner_id" in ($5))) AND (("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in ($6))) AND ((("account_move_line__move_id"."move_type" in ($7,$8,$9,$10,$11)) AND (("account_move_line__move_id"."invoice_user_id" = $12) OR "account_move_line__move_id"."invoice_user_id" IS NULL )) OR (("account_move_line__move_id"."move_type" in ($13,$14,$15,$16,$17)) AND ((("account_move_line"."team_id" in (SELECT "crm_team".id FROM "crm_team" WHERE ("crm_team"."id" IN (SELECT "sale_team_id" FROM "res_users" WHERE "id" IN ($18) AND "sale_team_id" IS NOT NULL)))) OR ("account_move_line"."team_id" in (SELECT "crm_team".id FROM "crm_team" WHERE ("crm_team"."id" not in (SELECT "sale_team_id" FROM "res_users" WHERE "sale_team_id" IS NOT NULL))))) OR ("account_move_line"."team_id" in ($19,$20)))))) ORDER BY "account_move_line__user_type_id"."sequence" ,"account_move_line"."date" DESC,"account_move_line"."move_name" DESC,"account_move_line"."id"
7 min 0.2%	12 ms	34,097 odoo
`SELECT "stock_picking".id FROM "stock_picking" WHERE ("stock_picking"."sale_id" in ($1)) AND ("stock_picking"."company_id" in ($2)) ORDER BY "stock_picking"."priority" DESC,"stock_picking"."scheduled_date" ASC,"stock_picking"."id" DESC` Details `CREATE INDEX CONCURRENTLY ON stock_picking (sale_id)` `Rows: 39011 Row progression: 39011, 1 Row estimates - sale_id (=): 1 - company_id (=): 19506 - priority (sort): 39011 Existing indexes - id PRIMARY - backorder_id - company_id - date - message_main_attachment_id - name - name, company_id UNIQUE - origin - pos_order_id - pos_session_id - priority - scheduled_date - state`
7 min 0.2%	65 ms	6,102 odoo
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = $1) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $2 ) OR ("res_partner"."company_id" in ($3))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $4) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR (("res_partner"."type" = $5) AND ("res_partner"."create_uid" = $6)))) AND (res_partner.email ilike $7 OR res_partner.display_name ilike $8 OR res_partner.ref ilike $9 OR res_partner.vat ilike $10) -- don't panic, trust postgres bitmap ORDER BY COALESCE(res_partner.supplier_rank, $11) DESC, res_partner.display_name ilike $12 desc, res_partner.display_name limit $13
6 min 0.2%	809 ms	470 odoo
`SELECT "account_move".id FROM "account_move" WHERE (("account_move"."name"::text not ilike $1) OR "account_move"."name" IS NULL) AND (("account_move"."company_id" IS NULL OR ("account_move"."company_id" in ($2))) AND (("account_move"."company_id" IS NULL OR ("account_move"."company_id" in ($3))) OR ("account_move"."move_type" in ($4,$5,$6)))) ORDER BY "account_move"."date" DESC,"account_move"."name" DESC,"account_move"."id" DESC`
6 min 0.2%	39 ms	9,249 odoo
SELECT "account_analytic_account".id FROM "account_analytic_account" WHERE (("account_analytic_account"."active" = $1) AND ((("account_analytic_account"."code"::text ilike $2) OR ("account_analytic_account"."name"::text ilike $3)) OR ("account_analytic_account"."partner_id" in (SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = $4) AND ("res_partner"."name"::text ilike $5)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $6 ) OR ("res_partner"."company_id" in ($7))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $8) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR (("res_partner"."type" = $9) AND ("res_partner"."create_uid" = $10)))) ORDER BY "res_partner"."display_name" LIMIT $11)))) AND ("account_analytic_account"."company_id" IS NULL OR ("account_analytic_account"."company_id" in ($12))) ORDER BY "account_analytic_account"."code" ,"account_analytic_account"."name" ASC LIMIT $13
6 min 0.2%	10 ms	34,285 odoo
SELECT min("hr_expense".id) AS id, count("hr_expense".id) AS "sale_order_id_count" , "hr_expense"."sale_order_id" as "sale_order_id" FROM "hr_expense" LEFT JOIN "sale_order" AS "hr_expense__sale_order_id" ON ("hr_expense"."sale_order_id" = "hr_expense__sale_order_id"."id") WHERE ("hr_expense"."sale_order_id" in ($1)) GROUP BY "hr_expense"."sale_order_id","hr_expense__sale_order_id"."date_order","hr_expense__sale_order_id"."id" ORDER BY "hr_expense__sale_order_id"."date_order" DESC,"hr_expense__sale_order_id"."id" DESC
5 min 0.1%	14 ms	23,746 odoo
`SELECT "hr_employee_public".id FROM "hr_employee_public" WHERE ("hr_employee_public"."parent_id" in ($1,$2,$3,$4,$5,$6,$7)) ORDER BY "hr_employee_public"."name"`
5 min 0.1%	16 ms	20,158 odoo
`SELECT "hr_employee_public".id FROM "hr_employee_public" WHERE ("hr_employee_public"."parent_id" in ($1,$2,$3,$4,$5,$6)) ORDER BY "hr_employee_public"."name"`
5 min 0.1%	22 ms	14,175 odoo
`SELECT "hr_employee".id FROM "hr_employee" WHERE ((("hr_employee"."active" = $1) AND "hr_employee"."contract_id" IS NOT NULL) AND (("hr_employee"."allocation_month" != $2) OR "hr_employee"."allocation_month" IS NULL)) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21))) ORDER BY "hr_employee"."code" LIMIT $22`
5 min 0.1%	104 ms	2,858 odoo
SELECT res_partner.id FROM "res_partner" WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $1 ) OR ("res_partner"."company_id" in ($2))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $3) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR (("res_partner"."type" = $4) AND ("res_partner"."create_uid" = $5)))) AND (res_partner.email ilike $6 OR res_partner.display_name ilike $7 OR res_partner.ref ilike $8 OR res_partner.vat ilike $9) -- don't panic, trust postgres bitmap ORDER BY res_partner.display_name ilike $10 desc, res_partner.display_name
5 min 0.1%	69 ms	4,204 odoo
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = $1) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $2 ) OR ("res_partner"."company_id" in ($3))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $4) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR (("res_partner"."type" = $5) AND ("res_partner"."create_uid" = $6)))) AND (res_partner.email ilike $7 OR res_partner.display_name ilike $8 OR res_partner.ref ilike $9 OR res_partner.vat ilike $10) -- don't panic, trust postgres bitmap ORDER BY res_partner.display_name ilike $11 desc, res_partner.display_name limit $12
5 min 0.1%	63 ms	4,514 odoo
SELECT res_partner.id FROM "res_partner" WHERE (("res_partner"."active" = $1) AND "res_partner"."parent_id" IS NULL ) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $2 ) OR ("res_partner"."company_id" in ($3))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $4) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR (("res_partner"."type" = $5) AND ("res_partner"."create_uid" = $6)))) AND (res_partner.email ilike $7 OR res_partner.display_name ilike $8 OR res_partner.ref ilike $9 OR res_partner.vat ilike $10) -- don't panic, trust postgres bitmap ORDER BY COALESCE(res_partner.customer_rank, $11) DESC, res_partner.display_name ilike $12 desc, res_partner.display_name limit $13
5 min 0.1%	101 ms	2,835 odoo
SELECT res_partner.id FROM "res_partner" WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $1 ) OR ("res_partner"."company_id" in ($2,$3))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $4) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR (("res_partner"."type" = $5) AND ("res_partner"."create_uid" = $6)))) AND (res_partner.email ilike $7 OR res_partner.display_name ilike $8 OR res_partner.ref ilike $9 OR res_partner.vat ilike $10) -- don't panic, trust postgres bitmap ORDER BY res_partner.display_name ilike $11 desc, res_partner.display_name
4 min 0.1%	3 ms	92,449 odoo
SELECT "mail_channel_partner"."id" as "id", "mail_channel_partner"."custom_channel_name" as "custom_channel_name", "mail_channel_partner"."partner_id" as "partner_id", "mail_channel_partner"."channel_id" as "channel_id", "mail_channel_partner"."fetched_message_id" as "fetched_message_id", "mail_channel_partner"."seen_message_id" as "seen_message_id", "mail_channel_partner"."fold_state" as "fold_state", "mail_channel_partner"."is_minimized" as "is_minimized", "mail_channel_partner"."is_pinned" as "is_pinned", "mail_channel_partner"."create_uid" as "create_uid", "mail_channel_partner"."create_date" as "create_date", "mail_channel_partner"."write_uid" as "write_uid", "mail_channel_partner"."write_date" as "write_date" FROM "mail_channel_partner" WHERE "mail_channel_partner".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: 11146 Row progression: 11146, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - channel_id, partner_id, seen_message_id`
4 min 0.1%	0 ms	2,677,374 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) ORDER BY r.id`
4 min 0.1%	2 ms	111,519 odoo
`SELECT "ir_ui_view".id FROM "ir_ui_view" LEFT JOIN "website" AS "ir_ui_view__website_id" ON ("ir_ui_view"."website_id" = "ir_ui_view__website_id"."id") WHERE (("ir_ui_view"."active" = $1) AND (("ir_ui_view"."key" = $2) AND (("ir_ui_view"."website_id" in ($3)) OR "ir_ui_view"."website_id" IS NULL))) ORDER BY "ir_ui_view__website_id"."id" LIMIT $4`
4 min < 0.1%	3 ms	78,739 odoo
SELECT "hr_employee_public"."id" as "id", "hr_employee_public"."parent_id" as "parent_id" FROM "hr_employee_public" WHERE "hr_employee_public".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)
4 min < 0.1%	12 ms	17,769 odoo
`SELECT "hr_employee_public".id FROM "hr_employee_public" WHERE ("hr_employee_public"."parent_id" in ($1,$2)) ORDER BY "hr_employee_public"."name"`
4 min < 0.1%	45 ms	4,690 odoo
SELECT res_partner.id FROM "res_partner" WHERE (("res_partner"."active" = $1) AND (("res_partner"."company_id" IS NULL OR ("res_partner"."company_id" = $2)) AND ("res_partner"."employee" IS NULL or "res_partner"."employee" = $3 ))) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $4 ) OR ("res_partner"."company_id" in ($5))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $6) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR (("res_partner"."type" = $7) AND ("res_partner"."create_uid" = $8)))) AND (res_partner.email ilike $9 OR res_partner.display_name ilike $10 OR res_partner.ref ilike $11 OR res_partner.vat ilike $12) -- don't panic, trust postgres bitmap ORDER BY COALESCE(res_partner.supplier_rank, $13) DESC, res_partner.display_name ilike $14 desc, res_partner.display_name limit $15
4 min < 0.1%	6 ms	34,314 odoo
`SELECT "service_delivery".id FROM "service_delivery" WHERE ("service_delivery"."order_id" in ($1)) ORDER BY "service_delivery"."id"` Details `CREATE INDEX CONCURRENTLY ON service_delivery (order_id)` `Rows: 38820 Row progression: 38820, 3 Row estimates - order_id (=): 3 - id (sort): 1 Existing indexes - id PRIMARY`
3 min < 0.1%	284 ms	740 odoo
`SELECT COUNT(*) AS count FROM account_move_line AS l LEFT JOIN account_move AS m ON m.id = l.move_id LEFT JOIN account_account AS a ON a.id = l.account_id LEFT JOIN account_account_type AS ty ON a.user_type_id = ty.id WHERE l.balance <> $1 AND m.state = $2 AND ty.type IN ($3, $4) AND m.commercial_partner_id = $5 AND l.date <= $6 AND l.company_id = $7 AND l.account_id in ($8, $9, $10)`
3 min < 0.1%	13 ms	16,322 odoo
`SELECT "hr_employee_public".id FROM "hr_employee_public" WHERE ("hr_employee_public"."parent_id" in ($1,$2,$3,$4,$5)) ORDER BY "hr_employee_public"."name"`
3 min < 0.1%	13 ms	15,676 odoo
`SELECT "hr_employee_public".id FROM "hr_employee_public" WHERE ("hr_employee_public"."parent_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10)) ORDER BY "hr_employee_public"."name"`
3 min < 0.1%	39 ms	5,117 odoo
SELECT "account_analytic_account".id FROM "account_analytic_account" WHERE (("account_analytic_account"."active" = $1) AND (((("account_analytic_account"."code"::text ilike $2) OR ("account_analytic_account"."name"::text ilike $3)) OR ("account_analytic_account"."partner_id" in (SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = $4) AND ("res_partner"."name"::text ilike $5)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $6 ) OR ("res_partner"."company_id" in ($7))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $8) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR (("res_partner"."type" = $9) AND ("res_partner"."create_uid" = $10)))) ORDER BY "res_partner"."display_name" LIMIT $11))) AND (("account_analytic_account"."company_id" = $12) OR "account_analytic_account"."company_id" IS NULL ))) AND ("account_analytic_account"."company_id" IS NULL OR ("account_analytic_account"."company_id" in ($13))) ORDER BY "account_analytic_account"."code" ,"account_analytic_account"."name" ASC LIMIT $14
3 min < 0.1%	5 ms	40,256 odoo
`INSERT INTO "mail_message" ("id", "create_uid", "create_date", "write_uid", "write_date", "add_sign", "author_id", "body", "date", "email_from", "is_internal", "message_id", "message_type", "model", "record_name", "reply_to", "res_id", "subject", "subtype_id") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19) RETURNING id`
3 min < 0.1%	0 ms	4,345,933 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`
3 min < 0.1%	4 ms	53,278 odoo
SELECT "stock_move"."id" as "id", "stock_move"."purchase_line_id" as "purchase_line_id", "stock_move"."date" as "date" FROM "stock_move" WHERE ("stock_move"."company_id" in ($1)) AND "stock_move".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, $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) `Covered by index on (id) Rows: 221566 Row progression: 221566, 1 Row estimates - id (=): 1 - company_id (=): 221566 Existing indexes - id PRIMARY - company_id - create_date - created_purchase_line_id - date - group_id - location_dest_id - location_id - name - orderpoint_id - origin_returned_move_id - picking_id - priority - product_id - product_id, location_id, location_dest_id, company_id, state - production_id - purchase_line_id - raw_material_production_id - sale_line_id - state`
3 min < 0.1%	14 ms	13,017 odoo
`DELETE FROM mail_activity WHERE id IN ($1)` `Covered by index on (id) Rows: 36862 Row progression: 36862, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - date_deadline - res_id - res_model - res_model_id - user_id`
3 min < 0.1%	4 ms	51,159 odoo
SELECT "res_partner"."id" as "id", "res_partner"."name" as "name", "res_partner"."display_name" as "display_name", "res_partner"."date" as "date", "res_partner"."title" as "title", "res_partner"."parent_id" as "parent_id", "res_partner"."ref" as "ref", "res_partner"."lang" as "lang", "res_partner"."tz" as "tz", "res_partner"."vat" as "vat", "res_partner"."website" as "website", "res_partner"."comment" as "comment", "res_partner"."active" as "active", "res_partner"."employee" as "employee", "res_partner"."function" as "function", "res_partner"."type" as "type", "res_partner"."street" as "street", "res_partner"."street2" as "street2", "res_partner"."zip" as "zip", "res_partner"."mobile" as "mobile", "res_partner"."is_company" as "is_company", "res_partner"."industry_id" as "industry_id", "res_partner"."company_id" as "company_id", "res_partner"."color" as "color", "res_partner"."partner_share" as "partner_share", "res_partner"."commercial_partner_id" as "commercial_partner_id", "res_partner"."commercial_company_name" as "commercial_company_name", "res_partner"."company_name" as "company_name", "res_partner"."message_main_attachment_id" as "message_main_attachment_id", "res_partner"."email_normalized" as "email_normalized", "res_partner"."message_bounce" as "message_bounce", "res_partner"."email" as "email", "res_partner"."phone" as "phone", "res_partner"."user_id" as "user_id", "res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack", "res_partner"."plan_to_change_car" as "plan_to_change_car", "res_partner"."phone_sanitized" as "phone_sanitized", "res_partner"."debit_limit" as "debit_limit", "res_partner"."last_time_entries_checked" as "last_time_entries_checked", "res_partner"."invoice_warn" as "invoice_warn", "res_partner"."invoice_warn_msg" as "invoice_warn_msg", "res_partner"."supplier_rank" as "supplier_rank", "res_partner"."customer_rank" as "customer_rank", "res_partner"."team_id" as "team_id", "res_partner"."picking_warn" as "picking_warn", "res_partner"."picking_warn_msg" as "picking_warn_msg", COALESCE("res_partner__website_meta_title"."value", "res_partner"."website_meta_title") as "website_meta_title", COALESCE("res_partner__website_meta_description"."value", "res_partner"."website_meta_description") as "website_meta_description", COALESCE("res_partner__website_meta_keywords"."value", "res_partner"."website_meta_keywords") as "website_meta_keywords", "res_partner"."website_meta_og_img" as "website_meta_og_img", COALESCE("res_partner__seo_name"."value", "res_partner"."seo_name") as "seo_name", "res_partner"."website_id" as "website_id", "res_partner"."is_published" as "is_published", "res_partner"."purchase_warn" as "purchase_warn", "res_partner"."purchase_warn_msg" as "purchase_warn_msg", COALESCE("res_partner__website_short_description"."value", "res_partner"."website_short_description") as "website_short_description", "res_partner"."sale_warn" as "sale_warn", "res_partner"."sale_warn_msg" as "sale_warn_msg", "res_partner"."available_in_pos" as "available_in_pos", "res_partner"."whatsapp_number" as "whatsapp_number", "res_partner"."whatsapp_device_id" as "whatsapp_device_id", "res_partner"."city_id" as "city_id", "res_partner"."delivery_area_id" as "delivery_area_id", "res_partner"."city" as "city", "res_partner"."warning_type" as "warning_type", "res_partner"."name_arabic" as "name_arabic", "res_partner"."credit_limit_days" as "credit_limit_days", "res_partner"."partner_latitude" as "partner_latitude", "res_partner"."partner_longitude" as "partner_longitude", "res_partner"."credit_limit" as "credit_limit", "res_partner"."over_credit" as "over_credit", "res_partner"."makani_number" as "makani_number", "res_partner"."stat" as "stat", "res_partner"."rcs" as "rcs", "res_partner"."date_birth" as "date_birth", "res_partner"."relation" as "relation", "res_partner"."nationality_country_id" as "nationality_country_id", "res_partner"."verified" as "verified", "res_partner"."country_id" as "country_id", "res_partner"."receivable_user_id" as "receivable_user_id", "res_partner"."state_id" as "state_id", "res_partner"."partner_group_id" as "partner_group_id", "res_partner"."commercial_group_id" as "commercial_group_id", "res_partner"."tax_id_not_applicable" as "tax_id_not_applicable", "res_partner"."create_uid" as "create_uid", "res_partner"."create_date" as "create_date", "res_partner"."write_uid" as "write_uid", "res_partner"."write_date" as "write_date" FROM "res_partner" LEFT JOIN "ir_translation" AS "res_partner__website_meta_title" ON ("res_partner"."id" = "res_partner__website_meta_title"."res_id" AND "res_partner__website_meta_title"."type" = $1 AND "res_partner__website_meta_title"."name" = $2 AND "res_partner__website_meta_title"."lang" = $3 AND "res_partner__website_meta_title"."value" != $4) LEFT JOIN "ir_translation" AS "res_partner__website_meta_description" ON ("res_partner"."id" = "res_partner__website_meta_description"."res_id" AND "res_partner__website_meta_description"."type" = $5 AND "res_partner__website_meta_description"."name" = $6 AND "res_partner__website_meta_description"."lang" = $7 AND "res_partner__website_meta_description"."value" != $8) LEFT JOIN "ir_translation" AS "res_partner__website_meta_keywords" ON ("res_partner"."id" = "res_partner__website_meta_keywords"."res_id" AND "res_partner__website_meta_keywords"."type" = $9 AND "res_partner__website_meta_keywords"."name" = $10 AND "res_partner__website_meta_keywords"."lang" = $11 AND "res_partner__website_meta_keywords"."value" != $12) LEFT JOIN "ir_translation" AS "res_partner__seo_name" ON ("res_partner"."id" = "res_partner__seo_name"."res_id" AND "res_partner__seo_name"."type" = $13 AND "res_partner__seo_name"."name" = $14 AND "res_partner__seo_name"."lang" = $15 AND "res_partner__seo_name"."value" != $16) LEFT JOIN "ir_translation" AS "res_partner__website_short_description" ON ("res_partner"."id" = "res_partner__website_short_description"."res_id" AND "res_partner__website_short_description"."type" = $17 AND "res_partner__website_short_description"."name" = $18 AND "res_partner__website_short_description"."lang" = $19 AND "res_partner__website_short_description"."value" != $20) WHERE "res_partner".id IN ($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)
3 min < 0.1%	21 ms	7,969 odoo
`SELECT "sale_order".id FROM "sale_order" WHERE ("sale_order"."analytic_account_id" in ($1)) ORDER BY "sale_order"."id"` Details `CREATE INDEX CONCURRENTLY ON sale_order (analytic_account_id)` `Rows: 56712 Row progression: 56712, 11 Row estimates - analytic_account_id (=): 11 - id (sort): 1 Existing indexes - id PRIMARY - company_id - create_date - date_order - message_main_attachment_id - name - partner_id - state - user_id`
3 min < 0.1%	58 ms	2,883 odoo
SELECT min("hr_employee".id) AS id, count("hr_employee".id) AS "department_id_count" , "hr_employee"."department_id" as "department_id" FROM "hr_employee" LEFT JOIN "hr_department" AS "hr_employee__department_id" ON ("hr_employee"."department_id" = "hr_employee__department_id"."id") WHERE (("hr_employee"."active" = $1) AND ((((("hr_employee"."user_id" = $2) OR ("hr_employee"."parent_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."user_id" = $3) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($4)))))) OR ("hr_employee"."parent_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."parent_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."user_id" = $5) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($6))))) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($7)))))) OR ("hr_employee"."parent_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."parent_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."parent_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."user_id" = $8) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($9))))) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($10))))) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($11)))))) AND "hr_employee"."department_id" IS NOT NULL)) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($12))) GROUP BY "hr_employee"."department_id","hr_employee__department_id"."name" ORDER BY "hr_employee__department_id"."name"
3 min < 0.1%	25 ms	6,431 odoo
`SELECT "purchase_requisition_line".id FROM "purchase_requisition_line" WHERE ("purchase_requisition_line"."requisition_id" in ($1)) ORDER BY "purchase_requisition_line"."id"` Details `CREATE INDEX CONCURRENTLY ON purchase_requisition_line (requisition_id)` `Rows: 131722 Row progression: 131722, 9 Row estimates - requisition_id (=): 9 - id (sort): 1 Existing indexes - id PRIMARY`
3 min < 0.1%	53 ms	3,080 odoo
`SELECT min("hr_leave".id) AS id, count("hr_leave".id) AS "state_count" , "hr_leave"."state" as "state" FROM "hr_leave" WHERE "hr_leave"."state" IS NOT NULL AND (("hr_leave"."holiday_status_id" in (SELECT "hr_leave_type".id FROM "hr_leave_type" WHERE "hr_leave_type"."company_id" IS NULL )) OR ("hr_leave"."holiday_status_id" in (SELECT "hr_leave_type".id FROM "hr_leave_type" WHERE ("hr_leave_type"."company_id" in ($1))))) GROUP BY "hr_leave"."state" ORDER BY "state"`
3 min < 0.1%	40 ms	3,901 odoo
SELECT count($1) FROM "sale_order" WHERE (("sale_order"."state" not in ($2,$3,$4)) OR "sale_order"."state" IS NULL) AND (("sale_order"."company_id" in ($5)) AND ((("sale_order"."user_id" = $6) OR "sale_order"."user_id" IS NULL ) OR ((("sale_order"."team_id" in (SELECT "crm_team".id FROM "crm_team" WHERE ("crm_team"."id" IN (SELECT "sale_team_id" FROM "res_users" WHERE "id" IN ($7) AND "sale_team_id" IS NOT NULL)))) OR ("sale_order"."team_id" in (SELECT "crm_team".id FROM "crm_team" WHERE ("crm_team"."id" not in (SELECT "sale_team_id" FROM "res_users" WHERE "sale_team_id" IS NOT NULL))))) OR ("sale_order"."team_id" in ($8,$9)))))
3 min < 0.1%	5 ms	29,338 odoo
`SELECT "hr_contract".id FROM "hr_contract" WHERE ("hr_contract"."employee_id" in ($1)) ORDER BY "hr_contract"."date_start" DESC` Details `CREATE INDEX CONCURRENTLY ON hr_contract (employee_id)` `Rows: 29900 Row progression: 29900, 1 Row estimates - employee_id (=): 1 - date_start (sort): 7 Existing indexes - id PRIMARY - message_main_attachment_id - resource_calendar_id`
2 min < 0.1%	3 ms	42,847 odoo
SELECT "account_analytic_account".id FROM "account_analytic_account" WHERE (("account_analytic_account"."active" = $1) AND ((("account_analytic_account"."code" = $2) OR ("account_analytic_account"."name" = $3)) OR ("account_analytic_account"."partner_id" in (SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = $4) AND ("res_partner"."name" = $5)) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $6 ) OR ("res_partner"."company_id" in ($7,$8,$9,$10,$11,$12,$13,$14))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $15) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR (("res_partner"."type" = $16) AND ("res_partner"."create_uid" = $17)))) ORDER BY "res_partner"."display_name" LIMIT $18)))) AND ("account_analytic_account"."company_id" IS NULL OR ("account_analytic_account"."company_id" in ($19,$20,$21,$22,$23,$24,$25,$26))) ORDER BY "account_analytic_account"."code" ,"account_analytic_account"."name" ASC LIMIT $27
2 min < 0.1%	38 ms	3,871 odoo
SELECT count($1) FROM "sale_order" WHERE (("sale_order"."state" not in ($2,$3,$4)) OR "sale_order"."state" IS NULL) AND (("sale_order"."company_id" in ($5)) AND ((("sale_order"."user_id" = $6) OR "sale_order"."user_id" IS NULL ) OR ((("sale_order"."team_id" in (SELECT "crm_team".id FROM "crm_team" WHERE ("crm_team"."id" IN (SELECT "sale_team_id" FROM "res_users" WHERE "id" IN ($7) AND "sale_team_id" IS NOT NULL)))) OR ("sale_order"."team_id" in (SELECT "crm_team".id FROM "crm_team" WHERE ("crm_team"."id" not in (SELECT "sale_team_id" FROM "res_users" WHERE "sale_team_id" IS NOT NULL))))) OR ("sale_order"."team_id" in ($8)))))
2 min < 0.1%	34 ms	4,274 odoo
`SELECT "hr_employee".id FROM "hr_employee" WHERE (("hr_employee"."active" = $1) AND (((("hr_employee"."code"::text ilike $2) OR ("hr_employee"."work_email"::text ilike $3)) OR ("hr_employee"."name"::text ilike $4)) OR ("hr_employee"."identification_id"::text ilike $5))) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($6))) ORDER BY "hr_employee"."code" LIMIT $7`
2 min < 0.1%	49 ms	2,906 odoo
SELECT "hr_employee".id FROM "hr_employee" WHERE (("hr_employee"."active" = $1) AND (((("hr_employee"."user_id" = $2) OR ("hr_employee"."parent_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."user_id" = $3) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($4)))))) OR ("hr_employee"."parent_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."parent_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."user_id" = $5) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($6))))) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($7)))))) OR ("hr_employee"."parent_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."parent_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."parent_id" in (SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."user_id" = $8) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($9))))) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($10))))) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($11))))))) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($12))) ORDER BY "hr_employee"."code" LIMIT $13
2 min < 0.1%	0 ms	16,290,545 odoo
`BEGIN ISOLATION LEVEL REPEATABLE READ`
2 min < 0.1%	0 ms	7,272,550 odoo
`SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling`
2 min < 0.1%	1 ms	116,393 odoo
SELECT "mail_channel".id FROM "mail_channel" WHERE (("mail_channel"."active" = $1) AND EXISTS ( SELECT $2 FROM "mail_channel_partner" AS "mail_channel__channel_partner_ids" WHERE "mail_channel__channel_partner_ids"."channel_id" = "mail_channel".id AND "mail_channel__channel_partner_ids"."partner_id" IN ($3) ) ) AND ((("mail_channel"."public" = $4) OR (("mail_channel"."public" = $5) AND EXISTS ( SELECT $6 FROM "mail_channel_partner" AS "mail_channel__channel_partner_ids" WHERE "mail_channel__channel_partner_ids"."channel_id" = "mail_channel".id AND "mail_channel__channel_partner_ids"."partner_id" IN ($7) ) )) OR (("mail_channel"."public" = $8) AND ("mail_channel"."group_public_id" in ($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)))) ORDER BY "mail_channel"."id"
2 min < 0.1%	15 ms	8,887 odoo
`SELECT "hr_employee".id FROM "hr_employee" WHERE ("hr_employee"."parent_id" in ($1)) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($2))) ORDER BY "hr_employee"."code"`
2 min < 0.1%	1 ms	110,387 odoo
SELECT "mail_channel".id FROM "mail_channel" WHERE (("mail_channel"."active" = $1) AND EXISTS ( SELECT $2 FROM "mail_channel_partner" AS "mail_channel__channel_partner_ids" WHERE "mail_channel__channel_partner_ids"."channel_id" = "mail_channel".id AND "mail_channel__channel_partner_ids"."partner_id" IN ($3) ) ) AND ((("mail_channel"."public" = $4) OR (("mail_channel"."public" = $5) AND EXISTS ( SELECT $6 FROM "mail_channel_partner" AS "mail_channel__channel_partner_ids" WHERE "mail_channel__channel_partner_ids"."channel_id" = "mail_channel".id AND "mail_channel__channel_partner_ids"."partner_id" IN ($7) ) )) OR (("mail_channel"."public" = $8) AND ("mail_channel"."group_public_id" in ($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)))) ORDER BY "mail_channel"."id"
2 min < 0.1%	1 ms	100,905 odoo
`SELECT "hr_expense_sheet".id FROM "hr_expense_sheet" WHERE ("hr_expense_sheet"."account_move_id" in ($1)) ORDER BY "hr_expense_sheet"."id"` Details `CREATE INDEX CONCURRENTLY ON hr_expense_sheet (account_move_id)` `Rows: 6566 Row progression: 6566, 1 Row estimates - account_move_id (=): 1 - id (sort): 1 Existing indexes - id PRIMARY - message_main_attachment_id - state`
2 min < 0.1%	104 ms	1,203 odoo
SELECT res_partner.id FROM "res_partner" WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = $1 ) OR ("res_partner"."company_id" in ($2))) OR "res_partner"."company_id" IS NULL ) AND (((("res_partner"."type" != $3) OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL ) OR (("res_partner"."type" = $4) AND ("res_partner"."create_uid" = $5)))) AND (res_partner.email ilike $6 OR res_partner.display_name ilike $7 OR res_partner.ref ilike $8 OR res_partner.vat ilike $9) -- don't panic, trust postgres bitmap ORDER BY COALESCE(res_partner.customer_rank, $10) DESC, res_partner.display_name ilike $11 desc, res_partner.display_name
2 min < 0.1%	2 ms	64,881 odoo
SELECT "res_partner"."id" as "id", "res_partner"."name" as "name", "res_partner"."email" as "email" FROM "res_partner" WHERE "res_partner".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: 50510 Row progression: 50510, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - commercial_partner_id - company_id - date - display_name - is_published - message_main_attachment_id - name - parent_id - ref - vat - website_id`
2 min < 0.1%	13 ms	9,826 odoo
`SELECT "hr_employee_public".id FROM "hr_employee_public" WHERE ("hr_employee_public"."parent_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)) ORDER BY "hr_employee_public"."name"`
2 min < 0.1%	164 ms	737 odoo
SELECT sum( l.balance ) AS balance, sum( COALESCE( (SELECT SUM(amount) FROM account_partial_reconcile WHERE credit_move_id = l.id AND max_date <= $1), $2 ) ) AS sum_debit, sum( COALESCE( (SELECT SUM(amount) FROM account_partial_reconcile WHERE debit_move_id = l.id AND max_date <= $3), $4 ) ) AS sum_credit FROM account_move_line AS l LEFT JOIN account_move AS m ON m.id = l.move_id LEFT JOIN account_account AS a ON a.id = l.account_id LEFT JOIN account_account_type AS ty ON a.user_type_id = ty.id WHERE l.balance <> $5 AND m.state = $6 AND ty.type IN ($7, $8) AND l.company_id = $9 AND l.account_id in ($10, $11, $12) AND l.date <= $13 AND m.commercial_partner_id = $14 AND COALESCE(l.date_maturity,l.date) <= $15
2 min < 0.1%	5 ms	22,942 odoo
`INSERT INTO "mail_message" ("id", "create_uid", "create_date", "write_uid", "write_date", "add_sign", "author_id", "body", "date", "email_from", "message_id", "message_type", "model", "parent_id", "record_name", "reply_to", "res_id", "subject", "subtype_id") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19) RETURNING id`
2 min < 0.1%	4 ms	26,640 odoo
INSERT INTO "mail_message" ("id", "create_uid", "create_date", "write_uid", "write_date", "add_sign", "author_id", "body", "date", "email_from", "email_layout_xmlid", "mail_activity_type_id", "mail_server_id", "message_id", "message_type", "model", "no_auto_thread", "parent_id", "record_name", "reply_to", "res_id", "subject", "subtype_id") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23) RETURNING id
2 min < 0.1%	37 ms	3,021 odoo
SELECT min("hr_employee".id) AS id, count("hr_employee".id) AS "department_id_count" , "hr_employee"."department_id" as "department_id" FROM "hr_employee" LEFT JOIN "hr_department" AS "hr_employee__department_id" ON ("hr_employee"."department_id" = "hr_employee__department_id"."id") WHERE (("hr_employee"."active" = $1) AND ((((("hr_employee"."code"::text ilike $2) OR ("hr_employee"."work_email"::text ilike $3)) OR ("hr_employee"."name"::text ilike $4)) OR ("hr_employee"."identification_id"::text ilike $5)) AND "hr_employee"."department_id" IS NOT NULL)) AND ("hr_employee"."company_id" IS NULL OR ("hr_employee"."company_id" in ($6))) GROUP BY "hr_employee"."department_id","hr_employee__department_id"."name" ORDER BY "hr_employee__department_id"."name"
2 min < 0.1%	0 ms	1,856,253 odoo
SELECT "res_partner"."id" as "id", "res_partner"."name" as "name", "res_partner"."display_name" as "display_name", "res_partner"."date" as "date", "res_partner"."title" as "title", "res_partner"."parent_id" as "parent_id", "res_partner"."ref" as "ref", "res_partner"."lang" as "lang", "res_partner"."tz" as "tz", "res_partner"."vat" as "vat", "res_partner"."website" as "website", "res_partner"."comment" as "comment", "res_partner"."active" as "active", "res_partner"."employee" as "employee", "res_partner"."function" as "function", "res_partner"."type" as "type", "res_partner"."street" as "street", "res_partner"."street2" as "street2", "res_partner"."zip" as "zip", "res_partner"."mobile" as "mobile", "res_partner"."is_company" as "is_company", "res_partner"."industry_id" as "industry_id", "res_partner"."company_id" as "company_id", "res_partner"."color" as "color", "res_partner"."partner_share" as "partner_share", "res_partner"."commercial_partner_id" as "commercial_partner_id", "res_partner"."commercial_company_name" as "commercial_company_name", "res_partner"."company_name" as "company_name", "res_partner"."message_main_attachment_id" as "message_main_attachment_id", "res_partner"."email_normalized" as "email_normalized", "res_partner"."message_bounce" as "message_bounce", "res_partner"."email" as "email", "res_partner"."phone" as "phone", "res_partner"."user_id" as "user_id", "res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack", "res_partner"."plan_to_change_car" as "plan_to_change_car", "res_partner"."phone_sanitized" as "phone_sanitized", "res_partner"."debit_limit" as "debit_limit", "res_partner"."last_time_entries_checked" as "last_time_entries_checked", "res_partner"."invoice_warn" as "invoice_warn", "res_partner"."invoice_warn_msg" as "invoice_warn_msg", "res_partner"."supplier_rank" as "supplier_rank", "res_partner"."customer_rank" as "customer_rank", "res_partner"."team_id" as "team_id", "res_partner"."picking_warn" as "picking_warn", "res_partner"."picking_warn_msg" as "picking_warn_msg", COALESCE("res_partner__website_meta_title"."value", "res_partner"."website_meta_title") as "website_meta_title", COALESCE("res_partner__website_meta_description"."value", "res_partner"."website_meta_description") as "website_meta_description", COALESCE("res_partner__website_meta_keywords"."value", "res_partner"."website_meta_keywords") as "website_meta_keywords", "res_partner"."website_meta_og_img" as "website_meta_og_img", COALESCE("res_partner__seo_name"."value", "res_partner"."seo_name") as "seo_name", "res_partner"."website_id" as "website_id", "res_partner"."is_published" as "is_published", "res_partner"."purchase_warn" as "purchase_warn", "res_partner"."purchase_warn_msg" as "purchase_warn_msg", COALESCE("res_partner__website_short_description"."value", "res_partner"."website_short_description") as "website_short_description", "res_partner"."sale_warn" as "sale_warn", "res_partner"."sale_warn_msg" as "sale_warn_msg", "res_partner"."available_in_pos" as "available_in_pos", "res_partner"."whatsapp_number" as "whatsapp_number", "res_partner"."whatsapp_device_id" as "whatsapp_device_id", "res_partner"."city_id" as "city_id", "res_partner"."delivery_area_id" as "delivery_area_id", "res_partner"."city" as "city", "res_partner"."warning_type" as "warning_type", "res_partner"."name_arabic" as "name_arabic", "res_partner"."credit_limit_days" as "credit_limit_days", "res_partner"."partner_latitude" as "partner_latitude", "res_partner"."partner_longitude" as "partner_longitude", "res_partner"."credit_limit" as "credit_limit", "res_partner"."over_credit" as "over_credit", "res_partner"."makani_number" as "makani_number", "res_partner"."stat" as "stat", "res_partner"."rcs" as "rcs", "res_partner"."date_birth" as "date_birth", "res_partner"."relation" as "relation", "res_partner"."nationality_country_id" as "nationality_country_id", "res_partner"."verified" as "verified", "res_partner"."country_id" as "country_id", "res_partner"."receivable_user_id" as "receivable_user_id", "res_partner"."state_id" as "state_id", "res_partner"."partner_group_id" as "partner_group_id", "res_partner"."commercial_group_id" as "commercial_group_id", "res_partner"."tax_id_not_applicable" as "tax_id_not_applicable", "res_partner"."create_uid" as "create_uid", "res_partner"."create_date" as "create_date", "res_partner"."write_uid" as "write_uid", "res_partner"."write_date" as "write_date" FROM "res_partner" LEFT JOIN "ir_translation" AS "res_partner__website_meta_title" ON ("res_partner"."id" = "res_partner__website_meta_title"."res_id" AND "res_partner__website_meta_title"."type" = $1 AND "res_partner__website_meta_title"."name" = $2 AND "res_partner__website_meta_title"."lang" = $3 AND "res_partner__website_meta_title"."value" != $4) LEFT JOIN "ir_translation" AS "res_partner__website_meta_description" ON ("res_partner"."id" = "res_partner__website_meta_description"."res_id" AND "res_partner__website_meta_description"."type" = $5 AND "res_partner__website_meta_description"."name" = $6 AND "res_partner__website_meta_description"."lang" = $7 AND "res_partner__website_meta_description"."value" != $8) LEFT JOIN "ir_translation" AS "res_partner__website_meta_keywords" ON ("res_partner"."id" = "res_partner__website_meta_keywords"."res_id" AND "res_partner__website_meta_keywords"."type" = $9 AND "res_partner__website_meta_keywords"."name" = $10 AND "res_partner__website_meta_keywords"."lang" = $11 AND "res_partner__website_meta_keywords"."value" != $12) LEFT JOIN "ir_translation" AS "res_partner__seo_name" ON ("res_partner"."id" = "res_partner__seo_name"."res_id" AND "res_partner__seo_name"."type" = $13 AND "res_partner__seo_name"."name" = $14 AND "res_partner__seo_name"."lang" = $15 AND "res_partner__seo_name"."value" != $16) LEFT JOIN "ir_translation" AS "res_partner__website_short_description" ON ("res_partner"."id" = "res_partner__website_short_description"."res_id" AND "res_partner__website_short_description"."type" = $17 AND "res_partner__website_short_description"."name" = $18 AND "res_partner__website_short_description"."lang" = $19 AND "res_partner__website_short_description"."value" != $20) WHERE "res_partner".id IN ($21)
2 min < 0.1%	12 ms	8,859 odoo
`SELECT "hr_employee_public".id FROM "hr_employee_public" WHERE ("hr_employee_public"."parent_id" in ($1,$2,$3,$4,$5,$6,$7,$8,$9)) ORDER BY "hr_employee_public"."name"`
2 min < 0.1%	2 ms	43,109 odoo
SELECT "product_product".id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = $1 AND "product_product__product_tmpl_id__name"."name" = $2 AND "product_product__product_tmpl_id__name"."lang" = $3 AND "product_product__product_tmpl_id__name"."value" != $4) WHERE ((("product_product"."active" = $5) AND ("product_product__product_tmpl_id"."purchase_ok" = $6)) AND ("product_product"."default_code"::text ilike $7)) AND (("product_product__product_tmpl_id"."company_id" in ($8)) OR "product_product__product_tmpl_id"."company_id" IS NULL ) ORDER BY "product_product"."default_code" ,COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name") ,"product_product"."id" LIMIT $9
2 min < 0.1%	15 ms	7,171 odoo
`SELECT "hr_employee_public".id FROM "hr_employee_public" WHERE ("hr_employee_public"."parent_id" in ($1)) AND ("hr_employee_public"."company_id" IS NULL OR ("hr_employee_public"."company_id" in ($2))) ORDER BY "hr_employee_public"."name"`
2 min < 0.1%	137 ms	740 odoo
SELECT sum( l.balance ) AS balance, sum( COALESCE( (SELECT SUM(amount) FROM account_partial_reconcile WHERE credit_move_id = l.id AND max_date <= $1), $2 ) ) AS sum_debit, sum( COALESCE( (SELECT SUM(amount) FROM account_partial_reconcile WHERE debit_move_id = l.id AND max_date <= $3), $4 ) ) AS sum_credit FROM account_move_line AS l LEFT JOIN account_move AS m ON m.id = l.move_id LEFT JOIN account_account AS a ON a.id = l.account_id LEFT JOIN account_account_type AS ty ON a.user_type_id = ty.id WHERE l.balance <> $5 AND m.state = $6 AND ty.type IN ($7, $8) AND l.company_id = $9 AND l.account_id in ($10, $11, $12) AND l.date <= $13 AND m.commercial_partner_id = $14 AND COALESCE(l.date_maturity,l.date) >= $15
2 min < 0.1%	0 ms	825,227 odoo
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" LEFT JOIN "ir_translation" AS "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id" AND "res_groups__name"."type" = $1 AND "res_groups__name"."name" = $2 AND "res_groups__name"."lang" = $3 AND "res_groups__name"."value" != $4) WHERE $5=$6 AND res_groups_users_rel.uid IN ($7) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups__name"."value", "res_groups"."name") OFFSET $8
2 min < 0.1%	29 ms	3,463 odoo
`SELECT count($1) FROM "hr_leave" WHERE (("hr_leave"."holiday_status_id" in (SELECT "hr_leave_type".id FROM "hr_leave_type" WHERE "hr_leave_type"."company_id" IS NULL )) OR ("hr_leave"."holiday_status_id" in (SELECT "hr_leave_type".id FROM "hr_leave_type" WHERE ("hr_leave_type"."company_id" in ($2)))))`
2 min < 0.1%	13 ms	7,986 odoo
`SELECT "hr_employee_public".id FROM "hr_employee_public" WHERE ("hr_employee_public"."parent_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)) ORDER BY "hr_employee_public"."name"`