PgHero

Queries

Total Time Average Time Calls
1,640 min 35% 0 ms 238,952,932 mt5backup_main 
UPDATE "mt5_users" SET "Timestamp"=$1,"Group"=$2,"CertSerialNumber"=$3,"Rights"=$4,"Registration"=$5,"LastAccess"=$6,"LastPassChange"=$7,"FirstName"=$8,"LastName"=$9,"MiddleName"=$10,"Company"=$11,"Account"=$12,"Country"=$13,"Language"=$14,"ClientID"=$15,"City"=$16,"State"=$17,"ZipCode"=$18,"Address"=$19,"Phone"=$20,"Email"=$21,"ID"=$22,"Status"=$23,"Comment"=$24,"Color"=$25,"PhonePassword"=$26,"Leverage"=$27,"Agent"=$28,"TradeAccounts"=$29,"LimitPositions"=$30,"LimitOrders"=$31,"LeadCampaign"=$32,"LeadSource"=$33,"TimestampTrade"=$34,"Balance"=$35,"Credit"=$36,"InterestRate"=$37,"CommissionDaily"=$38,"CommissionMonthly"=$39,"BalancePrevDay"=$40,"BalancePrevMonth"=$41,"EquityPrevDay"=$42,"EquityPrevMonth"=$43,"Name"=$44,"MQID"=$45,"LastIP"=$46,"ApiData"=$47 WHERE ("Login"=$48)
1,114 min 24% 48,758 ms 1,371 odoo 
REFRESH MATERIALIZED VIEW mt5_orders_view
972 min 21% 42,552 ms 1,371 odoo 
REFRESH MATERIALIZED VIEW mt5_deals_view
152 min 3% 19 ms 470,488 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."partner_id" = $1)  AND  ("survey_user_input_line"."question_id" = $2)) ORDER BY "survey_user_input_line"."id"   limit $3
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
147 min 3% 36 ms 247,731 odoo 
select fxremindma0_.id as col_0_0_ from fx_remind_mail fxremindma0_ where fxremindma0_.partner_id=$1 and fxremindma0_.remind_trading_flg=$2 limit $3
Details
CREATE INDEX CONCURRENTLY ON fx_remind_mail (partner_id)
132 min 3% 35 ms 229,692 odoo 
select fxremindma0_.id as col_0_0_ from fx_remind_mail fxremindma0_ where fxremindma0_.partner_id=$1 and fxremindma0_.remind_funding_flg=$2 limit $3
Details
CREATE INDEX CONCURRENTLY ON fx_remind_mail (partner_id)
116 min 2% 20 ms 340,611 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."partner_id" = $1)  AND  ("survey_user_input_line"."question_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21))) ORDER BY "survey_user_input_line"."id"
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
112 min 2% 42 ms 159,921 afxprodapiusr 
select news_id, content_id, publish_date, category, subject, body, status 
            from fx_market_news where news_id > $1 and push_flg = $2 order by news_id desc
Details
CREATE INDEX CONCURRENTLY ON fx_market_news (news_id)
86 min 2% 32 ms 159,921 afxprodapiusr 
select MAX(news_id) from fx_market_news
46 min 1.0% 0 ms 165,966,005 mt5backup_main 
UPDATE "mt5_positions" SET "PriceCurrent"=$1,"Profit"=$2 WHERE ("Position_ID"=$3)
30 min 0.6% 34 ms 53,547 odoo 
select fxremindma0_.id as col_0_0_ from fx_remind_mail fxremindma0_ where fxremindma0_.partner_id=$1 and fxremindma0_.remind_finish_doc_flg=$2 limit $3
Details
CREATE INDEX CONCURRENTLY ON fx_remind_mail (partner_id, remind_finish_doc_flg)
30 min 0.6% 74 ms 24,716 afxprodapiusr 
update fx_market_news
                        set push_flg = $1 
                        where news_id = $2
Details
CREATE INDEX CONCURRENTLY ON fx_market_news (news_id)
23 min 0.5% 0 ms 90,319,871 mt5backup_main 
UPDATE "mt5_prices" SET "Digits"=$1,"BidDir"=$2,"AskDir"=$3,"LastDir"=$4,"Time"=$5,"BidLast"=$6,"BidHigh"=$7,"BidLow"=$8,"AskLast"=$9,"AskHigh"=$10,"AskLow"=$11,"LastLast"=$12,"LastHigh"=$13,"LastLow"=$14 WHERE ("Price_ID"=$15)
19 min 0.4% 43 ms 26,895 afxprodapiusr 
select content_id, category, subject, body
                        from fx_market_news
                        where news_id < $1 and content_id = $2
                        and category = $3 and subject = $4
                        and body = $5 and push_flg = $6
Details
CREATE INDEX CONCURRENTLY ON fx_market_news (content_id)
12 min 0.2% 20 ms 34,632 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."partner_id" = $1)  AND  ("survey_user_input_line"."question_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))) ORDER BY "survey_user_input_line"."id"
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
11 min 0.2% 0 ms 27,325,626 mt5backup_main 
UPDATE "mt5_accounts" SET "CurrencyDigits"=$1,"Balance"=$2,"Credit"=$3,"Margin"=$4,"MarginFree"=$5,"MarginLevel"=$6,"MarginLeverage"=$7,"MarginInitial"=$8,"MarginMaintenance"=$9,"Profit"=$10,"Storage"=$11,"Floating"=$12,"Equity"=$13,"Assets"=$14,"Liabilities"=$15,"BlockedCommission"=$16,"BlockedProfit"=$17 WHERE ("Login"=$18)
9 min 0.2% 21 ms 26,539 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."partner_id" = $1)  AND  ("survey_user_input_line"."question_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))) ORDER BY "survey_user_input_line"."id"
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
6 min 0.1% 1 ms 584,893 afxprodbakusr 
insert into fx_report_partner (account_type, create_date, file_name, file_path, file_type, partner_trading_id, read_flg, report_cd, report_date, report_title, report_type, company_id, partner_id, trading_account_id, write_date) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
RETURNING *
4 min < 0.1% 0 ms 604,179 afxprodbakusr 
insert into fx_report_funding_summary (account_type, base_currency_cd, create_date, eod_balance, eod_equity, eod_real_balance, eod_real_equity, prev_balance, prev_real_balance, report_date, company_id, total_com, total_deposit, total_pending_withdraw, total_realized_profit, total_swap, total_unrealized_profit, total_used_margin, total_withdraw, trading_account_id, trading_account_name, type, write_date) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23)
RETURNING *
3 min < 0.1% 0 ms 1,175,847 odoo 
UPDATE "bus_presence" SET "last_poll"=$1 WHERE id IN ($2)
2 min < 0.1% 0 ms 113,610,098 mt5backup_main 
BEGIN
2 min < 0.1% 21 ms 6,087 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."partner_id" = $1)  AND  ("survey_user_input_line"."question_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))) ORDER BY "survey_user_input_line"."id"
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
2 min < 0.1% 0 ms 6,914,732 odoo 
DISCARD ALL
2 min < 0.1% 20 ms 5,982 odoo 
SELECT "fx_swap_history".id FROM "fx_swap_history" WHERE ((("fx_swap_history"."symbol_id" = $1)  AND  ("fx_swap_history"."group_id" = $2))  AND  ("fx_swap_history"."effect_date" = $3)) AND ("fx_swap_history"."company_id" in ($4)) ORDER BY "fx_swap_history"."create_date" DESC  limit $5
Details
CREATE INDEX CONCURRENTLY ON fx_swap_history (effect_date, symbol_id)
2 min < 0.1% 0 ms 113,610,098 mt5backup_main 
COMMIT
2 min < 0.1% 2 ms 64,881 odoo 
SELECT "st_exchange_calendar"."id" as "id","st_exchange_calendar"."note" as "note","st_exchange_calendar"."write_uid" as "write_uid","st_exchange_calendar"."open_time" as "open_time","st_exchange_calendar"."national_holiday_flg" as "national_holiday_flg","st_exchange_calendar"."create_uid" as "create_uid","st_exchange_calendar"."exchange_sname" as "exchange_sname","st_exchange_calendar"."write_date" as "write_date","st_exchange_calendar"."front_date" as "front_date","st_exchange_calendar"."company_id" as "company_id","st_exchange_calendar"."holiday_flg" as "holiday_flg","st_exchange_calendar"."create_date" as "create_date","st_exchange_calendar"."exchange_id" as "exchange_id","st_exchange_calendar"."close_time" as "close_time" FROM "st_exchange_calendar" WHERE "st_exchange_calendar".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)
2 min < 0.1% 0 ms 6,303,827 mt5backup_main 
UPDATE "mt5_orders" SET "PriceCurrent"=$1 WHERE ("Order"=$2)
2 min < 0.1% 22 ms 4,500 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."question_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))  AND  ("survey_user_input_line"."partner_id" in ($33))) ORDER BY "survey_user_input_line"."id"
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
2 min < 0.1% 21 ms 4,500 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."question_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))  AND  ("survey_user_input_line"."partner_id" in ($41))) ORDER BY "survey_user_input_line"."id"
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
1 min < 0.1% 1 ms 121,881 odoo 
SELECT CAST("Symbol_ID" AS INTEGER), "Symbol" 
                   FROM   mt5_symbols
                   WHERE "Path" SIMILAR TO $1
1 min < 0.1% 21 ms 3,995 odoo 
SELECT "survey_user_input_line".id FROM "survey_user_input_line" WHERE (("survey_user_input_line"."partner_id" = $1)  AND  ("survey_user_input_line"."question_id" in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19))) ORDER BY "survey_user_input_line"."id"
Details
CREATE INDEX CONCURRENTLY ON survey_user_input_line (partner_id, question_id)
1 min < 0.1% 0 ms 2,263,203 mt5backup_main 
UPDATE "mt5_orders" SET "Timestamp"=$1,"ExternalID"=$2,"Login"=$3,"Dealer"=$4,"Symbol"=$5,"Digits"=$6,"DigitsCurrency"=$7,"ContractSize"=$8,"State"=$9,"Reason"=$10,"TimeSetup"=$11,"TimeExpiration"=$12,"TimeDone"=$13,"TimeSetupMsc"=$14,"TimeDoneMsc"=$15,"ModifyFlags"=$16,"Type"=$17,"TypeFill"=$18,"TypeTime"=$19,"PriceOrder"=$20,"PriceTrigger"=$21,"PriceCurrent"=$22,"PriceSL"=$23,"PriceTP"=$24,"VolumeInitialExt"=$25,"VolumeCurrentExt"=$26,"ExpertID"=$27,"PositionID"=$28,"PositionByID"=$29,"RateMargin"=$30,"Comment"=$31,"ActivationMode"=$32,"ActivationTime"=$33,"ActivationPrice"=$34,"ActivationFlags"=$35,"VolumeInitial"=$36,"VolumeCurrent"=$37,"ApiData"=$38 WHERE ("Order"=$39)
1 min < 0.1% 0 ms 1,960,663 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
1 min < 0.1% 2 ms 41,536 odoo 
SELECT "st_exchange_calendar".id FROM "st_exchange_calendar" WHERE (("st_exchange_calendar"."national_holiday_flg" IS NULL or "st_exchange_calendar"."national_holiday_flg" = $1 )  AND  ("st_exchange_calendar"."holiday_flg" IS NULL or "st_exchange_calendar"."holiday_flg" = $2 )) ORDER BY "st_exchange_calendar"."id"
1 min < 0.1% 2 ms 36,625 odoo 
SELECT "fx_res_partner".id FROM "fx_res_partner" WHERE (("fx_res_partner"."active" = $1)  AND  ("fx_res_partner"."partner_id" in ($2))) ORDER BY "fx_res_partner"."id"
Details
CREATE INDEX CONCURRENTLY ON fx_res_partner (partner_id)
1 min < 0.1% 0 ms 8,987,950 odoo 
insert into fx_mt5_auditlog_2026 (log_time, ip, log_level, log_type, log_category, message, create_uid, create_date, write_uid, write_date) values ($1, $2, $3, $4, $5, $6, $7, NOW(), $8, NOW())
1 min < 0.1% 0 ms 867,851 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)
1 min < 0.1% 0 ms 180,138 mt5backup_main 
INSERT INTO "mt5_deals" ("Deal","Timestamp","ExternalID","Login","Dealer","Order","Action","Entry","Reason","Digits","DigitsCurrency","ContractSize","Time","TimeMsc","Symbol","Price","VolumeExt","Profit","Storage","Commission","Fee","RateProfit","RateMargin","ExpertID","PositionID","Comment","ProfitRaw","PricePosition","PriceSL","PriceTP","VolumeClosedExt","TickValue","TickSize","Flags","Value","Gateway","PriceGateway","VolumeGatewayExt","ActionGateway","ModifyFlags","MarketBid","MarketAsk","MarketLast","Volume","VolumeClosed","ApiData") VALUES ($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)
1 min < 0.1% 0 ms 458,460 odoo 
SELECT "survey_question".id FROM "survey_question" WHERE ("survey_question"."question_cd" = $1) ORDER BY "survey_question"."sequence" ,"survey_question"."id"   limit $2
1 min < 0.1% 0 ms 340,611 odoo 
SELECT "survey_question".id FROM "survey_question" WHERE ("survey_question"."question_cd" in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)) ORDER BY "survey_question"."sequence" ,"survey_question"."id"
1 min < 0.1% 0 ms 114,615 odoo 
SELECT "st_ticker".id FROM "st_ticker" WHERE "st_ticker"."ticker_code" IS NULL  ORDER BY "st_ticker"."ticker_code" ASC  limit $1
1 min < 0.1% 1 ms 48,819 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", "no_auto_thread", "record_name", "reply_to", "res_id", "subject", "subtype_id", "website_published") 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) RETURNING id
1 min < 0.1% 0 ms 723,728 odoo 
INSERT INTO "auditlog_log_line" ("id", "create_uid", "create_date", "write_uid", "write_date", "field_id", "log_id", "new_value", "new_value_text", "old_value", "old_value_text") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10, $11) RETURNING id
1 min < 0.1% 0 ms 376,652 odoo 
SELECT "mail_channel".id FROM "mail_channel" WHERE ("mail_channel"."id" in (SELECT "channel_id" FROM "mail_channel_partner" WHERE "partner_id" IN ($1))) AND ((("mail_channel"."public" = $2)  OR  (("mail_channel"."public" = $3)  AND  ("mail_channel"."id" in (SELECT "channel_id" FROM "mail_channel_partner" WHERE "partner_id" IN ($4)))))  OR  (("mail_channel"."public" = $5)  AND  ("mail_channel"."group_public_id" in ($6,$7,$8,$9,$10,$11,$12,$13,$14,$15)))) ORDER BY "mail_channel"."id"
1 min < 0.1% 0 ms 159,922 afxprodapiusr 
SELECT res_partner.type AS res_partner_type, res_partner.id AS res_partner_id, res_partner.create_uid AS res_partner_create_uid, res_partner.create_date AS res_partner_create_date, res_partner.write_uid AS res_partner_write_uid, res_partner.write_date AS res_partner_write_date, res_partner.name AS res_partner_name, res_partner.fx_name1 AS res_partner_fx_name1, res_partner.fx_dob AS res_partner_fx_dob, res_partner.zip AS res_partner_zip, res_partner.street AS res_partner_street, res_partner.street2 AS res_partner_street2, res_partner.fx_street3 AS res_partner_fx_street3, res_partner.city AS res_partner_city, res_partner.company_id AS res_partner_company_id, res_partner.parent_id AS res_partner_parent_id, res_partner.country_id AS res_partner_country_id, res_partner.active AS res_partner_active, res_partner.is_company AS res_partner_is_company, res_partner.ose_examination_state AS res_partner_ose_examination_state, res_partner.stage_id AS res_partner_stage_id 
FROM res_partner 
WHERE res_partner.ose_examination_state = $1 AND res_partner.active = $2 AND res_partner.stage_id = $3 AND res_partner.company_id = $4 AND res_partner.type = $5
Details
CREATE INDEX CONCURRENTLY ON res_partner (stage_id, ose_examination_state)
1 min < 0.1% 0 ms 7,022,521 odoo 
BEGIN ISOLATION LEVEL REPEATABLE READ
1 min < 0.1% 1 ms 26,897 afxprodapiusr 
insert into fx_market_news (
            news_id, content_id, publish_date, category, subject, body, status, write_date, create_date, push_flg
            )
            values ($1, $2, $3, $4, $5, $6, $7, now(), now(), $8)
1 min < 0.1% 0 ms 740,687 mt5backup_main 
UPDATE "mt5_positions" SET "ExternalID"=$1,"Login"=$2,"Dealer"=$3,"Timestamp"=$4,"Symbol"=$5,"Action"=$6,"Digits"=$7,"DigitsCurrency"=$8,"Reason"=$9,"ContractSize"=$10,"TimeCreate"=$11,"TimeUpdate"=$12,"TimeCreateMsc"=$13,"TimeUpdateMsc"=$14,"PriceOpen"=$15,"PriceCurrent"=$16,"PriceSL"=$17,"PriceTP"=$18,"VolumeExt"=$19,"Profit"=$20,"Storage"=$21,"RateProfit"=$22,"RateMargin"=$23,"ExpertID"=$24,"ExpertPositionID"=$25,"Comment"=$26,"ActivationMode"=$27,"ActivationTime"=$28,"ActivationPrice"=$29,"ActivationFlags"=$30,"ActionGateway"=$31,"PriceGateway"=$32,"VolumeGatewayExt"=$33,"Volume"=$34,"ApiData"=$35 WHERE ("Position_ID"=$36)
1 min < 0.1% 0 ms 405,742 odoo 
INSERT INTO "fx_news_trace" ("id", "create_uid", "create_date", "write_uid", "write_date", "active", "agree_flg", "news_id", "partner_id", "read_flg") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10) RETURNING id
1 min < 0.1% 0 ms 297,819 odoo 
SELECT "mail_channel".id FROM "mail_channel" WHERE ("mail_channel"."id" in (SELECT "channel_id" FROM "mail_channel_partner" WHERE "partner_id" IN ($1))) AND ((("mail_channel"."public" = $2)  OR  (("mail_channel"."public" = $3)  AND  ("mail_channel"."id" in (SELECT "channel_id" FROM "mail_channel_partner" WHERE "partner_id" IN ($4)))))  OR  (("mail_channel"."public" = $5)  AND  ("mail_channel"."group_public_id" in ($6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44)))) ORDER BY "mail_channel"."id"
1 min < 0.1% 2 ms 21,627 odoo 
SELECT "st_exchange_calendar"."id" as "id","st_exchange_calendar"."note" as "note","st_exchange_calendar"."write_uid" as "write_uid","st_exchange_calendar"."open_time" as "open_time","st_exchange_calendar"."national_holiday_flg" as "national_holiday_flg","st_exchange_calendar"."create_uid" as "create_uid","st_exchange_calendar"."exchange_sname" as "exchange_sname","st_exchange_calendar"."write_date" as "write_date","st_exchange_calendar"."front_date" as "front_date","st_exchange_calendar"."company_id" as "company_id","st_exchange_calendar"."holiday_flg" as "holiday_flg","st_exchange_calendar"."create_date" as "create_date","st_exchange_calendar"."exchange_id" as "exchange_id","st_exchange_calendar"."close_time" as "close_time" FROM "st_exchange_calendar" WHERE "st_exchange_calendar".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)
1 min < 0.1% 0 ms 355,424 mt5backup_main 
INSERT INTO "mt5_orders_history" ("Order","Timestamp","ExternalID","Login","Dealer","Symbol","Digits","DigitsCurrency","ContractSize","State","Reason","TimeSetup","TimeExpiration","TimeDone","TimeSetupMsc","TimeDoneMsc","ModifyFlags","Type","TypeFill","TypeTime","PriceOrder","PriceTrigger","PriceCurrent","PriceSL","PriceTP","VolumeInitialExt","VolumeCurrentExt","ExpertID","PositionID","PositionByID","RateMargin","Comment","ActivationMode","ActivationTime","ActivationPrice","ActivationFlags","VolumeInitial","VolumeCurrent","ApiData") VALUES ($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)
0 min < 0.1% 0 ms 570,561 odoo 
SELECT
                U.partner_id as id,
                CASE WHEN age(now() AT TIME ZONE $1, max(B.last_poll)) > interval $2 THEN $3
                     WHEN age(now() AT TIME ZONE $4, max(B.last_presence)) > interval $5 THEN $6
                     ELSE $7
                END as status
            FROM bus_presence B
                JOIN res_users U ON B.user_id = U.id
            WHERE U.partner_id IN ($8) AND U.active = $9
         GROUP BY U.partner_id
0 min < 0.1% 0 ms 355,441 mt5backup_main 
INSERT INTO "mt5_orders" ("Order","Timestamp","ExternalID","Login","Dealer","Symbol","Digits","DigitsCurrency","ContractSize","State","Reason","TimeSetup","TimeExpiration","TimeDone","TimeSetupMsc","TimeDoneMsc","ModifyFlags","Type","TypeFill","TypeTime","PriceOrder","PriceTrigger","PriceCurrent","PriceSL","PriceTP","VolumeInitialExt","VolumeCurrentExt","ExpertID","PositionID","PositionByID","RateMargin","Comment","ActivationMode","ActivationTime","ActivationPrice","ActivationFlags","VolumeInitial","VolumeCurrent","ApiData") VALUES ($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)
0 min < 0.1% 0 ms 1,966,339 odoo 
SELECT base_registry_signaling.last_value,
                                  base_cache_signaling.last_value
                           FROM base_registry_signaling, base_cache_signaling
0 min < 0.1% 0 ms 586,873 afxprodbakusr 
insert into fx_report_company (account_type, category, create_date, file_name, file_path, file_path_csv, file_type, report_cd, report_date, report_title, report_type, company_id, write_date) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)
RETURNING *
0 min < 0.1% 10 ms 2,665 odoo 
SELECT "mail_mail".id FROM "mail_mail" WHERE (("mail_mail"."state" = $1)  AND  (("mail_mail"."scheduled_date" < $2)  OR  "mail_mail"."scheduled_date" IS NULL )) ORDER BY "mail_mail"."id" DESC  limit $3
0 min < 0.1% 0 ms 1,299,050 odoo 
SELECT "bus_presence".id FROM "bus_presence" WHERE ("bus_presence"."user_id" = $1) ORDER BY "bus_presence"."id"   limit $2
0 min < 0.1% 0 ms 212,591 odoo 
SELECT "mail_channel".id FROM "mail_channel" WHERE ("mail_channel"."id" in (SELECT "channel_id" FROM "mail_channel_partner" WHERE "partner_id" IN ($1))) AND ((("mail_channel"."public" = $2)  OR  (("mail_channel"."public" = $3)  AND  ("mail_channel"."id" in (SELECT "channel_id" FROM "mail_channel_partner" WHERE "partner_id" IN ($4)))))  OR  (("mail_channel"."public" = $5)  AND  ("mail_channel"."group_public_id" in ($6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22)))) ORDER BY "mail_channel"."id"
0 min < 0.1% 0 ms 236,405 odoo 
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "res_groups__name" ON ("res_groups"."id" = "res_groups__name"."res_id")
                    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
0 min < 0.1% 1 ms 41,194 odoo 
SELECT "fx_res_partner_config".id FROM "fx_res_partner_config" WHERE ("fx_res_partner_config"."partner_id" = $1) ORDER BY "fx_res_partner_config"."id"
Details
CREATE INDEX CONCURRENTLY ON fx_res_partner_config (partner_id)
0 min < 0.1% 0 ms 128,219 afxprodbakusr 
select rescompany0_.id as id1_11_0_, rescompany0_.account_no as account_2_11_0_, rescompany0_.base_onboarding_company_state as base_onb3_11_0_, rescompany0_.company_registry as company_4_11_0_, rescompany0_.create_date as create_d5_11_0_, rescompany0_.demo_seq_number as demo_seq6_11_0_, rescompany0_.email as email7_11_0_, rescompany0_.fx_allow_change_pass as fx_allow8_11_0_, rescompany0_.fx_bjp_secret_key as fx_bjp_s9_11_0_, rescompany0_.fx_close_time as fx_clos10_11_0_, rescompany0_.fx_corp_group as fx_corp11_11_0_, rescompany0_.fx_corp_max_leverage as fx_corp12_11_0_, rescompany0_.fx_demo_group as fx_demo13_11_0_, rescompany0_.fx_demo_max_leverage as fx_demo14_11_0_, rescompany0_.fx_forex_seqnum as fx_fore15_11_0_, rescompany0_.fx_front_url as fx_fron16_11_0_, rescompany0_.fx_funding_max_deposit as fx_fund17_11_0_, rescompany0_.fx_funding_max_withdraw as fx_fund18_11_0_, rescompany0_.fx_funding_min_deposit as fx_fund19_11_0_, rescompany0_.fx_funding_min_withdraw as fx_fund20_11_0_, rescompany0_.fx_indv_group as fx_indv21_11_0_, rescompany0_.fx_indv_max_leverage as fx_indv22_11_0_, rescompany0_.fx_mail_back as fx_mail23_11_0_, rescompany0_.fx_mail_om as fx_mail24_11_0_, rescompany0_.fx_margin_call_mode as fx_marg25_11_0_, rescompany0_.fx_open_time as fx_open26_11_0_, rescompany0_.fx_schedule_date as fx_sche27_11_0_, rescompany0_.fx_webapi_account as fx_weba28_11_0_, rescompany0_.fx_webapi_pwd as fx_weba29_11_0_, rescompany0_.fx_webapi_url as fx_weba30_11_0_, rescompany0_.fx_whitelabel_code as fx_whit31_11_0_, rescompany0_.logo_web as logo_we32_11_0_, rescompany0_.name as name33_11_0_, rescompany0_.partner_gid as partner34_11_0_, rescompany0_.phone as phone35_11_0_, rescompany0_.phone_international_format as phone_i36_11_0_, rescompany0_.report_footer as report_37_11_0_, rescompany0_.report_header as report_38_11_0_, rescompany0_.sequence as sequenc39_11_0_, rescompany0_.snailmail_color as snailma40_11_0_, rescompany0_.snailmail_duplex as snailma41_11_0_, rescompany0_.social_facebook as social_42_11_0_, rescompany0_.social_github as social_43_11_0_, rescompany0_.social_googleplus as social_44_11_0_, rescompany0_.social_instagram as social_45_11_0_, rescompany0_.social_linkedin as social_46_11_0_, rescompany0_.social_twitter as social_47_11_0_, rescompany0_.social_youtube as social_48_11_0_, rescompany0_.write_date as write_d49_11_0_ from res_company rescompany0_ where rescompany0_.id=$1
0 min < 0.1% 0 ms 831,899 odoo 
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > $1)  AND  ("bus_bus"."channel" in ($2,$3,$4,$5))) ORDER BY "bus_bus"."id"
0 min < 0.1% 6 ms 3,828 odoo 
SELECT "fx_res_partner_trading".id FROM "fx_res_partner_trading" WHERE ("fx_res_partner_trading"."platform" = $1) ORDER BY "fx_res_partner_trading"."id"
Details
CREATE INDEX CONCURRENTLY ON fx_res_partner_trading (platform, id)
0 min < 0.1% 255 ms 76 afxprodapiusr 
UPDATE "fx_news_trace" SET "read_flg" = $1 WHERE ("fx_news_trace"."active" = $2 AND "fx_news_trace"."news_id" = $3 AND "fx_news_trace"."partner_id" = $4)
Details
CREATE INDEX CONCURRENTLY ON fx_news_trace (partner_id, news_id)
0 min < 0.1% 7 ms 2,771 afxprodapiusr 
SELECT trading_account_id FROM
            fx_res_partner_trading WHERE group_name IN ($1, $2, $3, $4, $5, $6) and active = $7
Details
CREATE INDEX CONCURRENTLY ON fx_res_partner_trading (group_name)
0 min < 0.1% 0 ms 237,546 mt5backup_main 
UPDATE "mt5_gateways" SET "SysConnection"=$1,"SysLastTime"=$2,"Company"=$3,"Issuer"=$4,"TickStatsCount"=$5,"TicksCount"=$6,"BooksCount"=$7,"TradeAverageTime"=$8,"TradeRequestsCount"=$9,"BytesReceived"=$10,"BytesSent"=$11,"StateFlags"=$12 WHERE ("Name"=$13)
0 min < 0.1% 0 ms 158,660 odoo 
SELECT "mail_channel".id FROM "mail_channel" WHERE ("mail_channel"."id" in (SELECT "channel_id" FROM "mail_channel_partner" WHERE "partner_id" IN ($1))) AND ((("mail_channel"."public" = $2)  OR  (("mail_channel"."public" = $3)  AND  ("mail_channel"."id" in (SELECT "channel_id" FROM "mail_channel_partner" WHERE "partner_id" IN ($4)))))  OR  (("mail_channel"."public" = $5)  AND  ("mail_channel"."group_public_id" in ($6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16)))) ORDER BY "mail_channel"."id"
0 min < 0.1% 787 ms 22 odoo 
SELECT "fx_report_partner".id FROM "fx_report_partner" WHERE ((("fx_report_partner"."account_type" in ($1,$2,$3,$4))  AND  ("fx_report_partner"."report_type"::text ilike $5))  AND  ("fx_report_partner"."partner_trading_id" in ($6))) AND ("fx_report_partner"."company_id" in ($7)) ORDER BY "fx_report_partner"."report_date" DESC,"fx_report_partner"."file_name"   limit $8
0 min < 0.1% 0 ms 315,905 odoo 
SELECT MAX(CASE WHEN perm_write THEN $1 ELSE $2 END)
		                              FROM ir_model_access a
		                              JOIN ir_model m ON (m.id = a.model_id)
		                              JOIN res_groups_users_rel gu ON (gu.gid = a.group_id)
		                             WHERE m.model = $3
		                               AND gu.uid = $4
		                               AND a.active IS TRUE
0 min < 0.1% 3 ms 4,611 pspprodbakusr 
insert into auditlog_http_session (create_date, create_uid, write_date, write_uid, device_id, display_name, hostname_address, ip_address, module_type, name, partner_id, trading_account_id, user_id) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)
RETURNING *
0 min < 0.1% 4 ms 3,952 odoo 
SELECT "fx_funding".id FROM "fx_funding" WHERE (("fx_funding"."active" = $1)  AND  ("fx_funding"."partner_id" in ($2))) AND ("fx_funding"."company_id" in ($3)) ORDER BY "fx_funding"."write_date" DESC
Details
CREATE INDEX CONCURRENTLY ON fx_funding (partner_id)
0 min < 0.1% 0 ms 33,588 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  ($3 OR "ir_ui_view"."website_id" IS NULL))) ORDER BY "ir_ui_view__website_id"."id"   limit $4
0 min < 0.1% 0 ms 127,729 odoo 
SELECT "mail_channel".id FROM "mail_channel" WHERE ("mail_channel"."id" in (SELECT "channel_id" FROM "mail_channel_partner" WHERE "partner_id" IN ($1))) AND ((("mail_channel"."public" = $2)  OR  (("mail_channel"."public" = $3)  AND  ("mail_channel"."id" in (SELECT "channel_id" FROM "mail_channel_partner" WHERE "partner_id" IN ($4)))))  OR  (("mail_channel"."public" = $5)  AND  ("mail_channel"."group_public_id" in ($6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18)))) ORDER BY "mail_channel"."id"
0 min < 0.1% 5 ms 2,665 odoo 
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = $1)  AND  ("res_partner"."id" in (WITH temp_irt_current (id, name) as (
                            SELECT ct.id, coalesce(it.value,ct."stage_code")
                            FROM res_partner ct
                            LEFT JOIN ir_translation it ON (it.name = $2 and
                                        it.lang = $3 and
                                        it.type = $4 and
                                        it.res_id = ct.id and
                                        it.value != $5)
                            )
                            SELECT id FROM temp_irt_current WHERE name = $6 order by name
                            ))) ORDER BY "res_partner"."write_date" DESC
0 min < 0.1% 0 ms 122,995 odoo 
UPDATE "bus_presence" SET "last_poll"=$1,"last_presence"=$2 WHERE id IN ($3)
0 min < 0.1% 0 ms 106,616 odoo 
SELECT "mail_channel".id FROM "mail_channel" WHERE ("mail_channel"."id" in (SELECT "channel_id" FROM "mail_channel_partner" WHERE "partner_id" IN ($1))) AND ((("mail_channel"."public" = $2)  OR  (("mail_channel"."public" = $3)  AND  ("mail_channel"."id" in (SELECT "channel_id" FROM "mail_channel_partner" WHERE "partner_id" IN ($4)))))  OR  (("mail_channel"."public" = $5)  AND  ("mail_channel"."group_public_id" in ($6,$7,$8,$9,$10,$11,$12,$13)))) ORDER BY "mail_channel"."id"
0 min < 0.1% 3 ms 3,468 odoo 
SELECT "fx_res_partner_trading".id FROM "fx_res_partner_trading" WHERE (("fx_res_partner_trading"."active" = $1)  AND  ("fx_res_partner_trading"."group_name" = $2)) ORDER BY "fx_res_partner_trading"."id"
Details
CREATE INDEX CONCURRENTLY ON fx_res_partner_trading (group_name)
0 min < 0.1% 2 ms 7,068 odoo 
SELECT "st_exchange_calendar"."id" as "id","st_exchange_calendar"."note" as "note","st_exchange_calendar"."create_uid" as "create_uid","st_exchange_calendar"."open_time" as "open_time","st_exchange_calendar"."national_holiday_flg" as "national_holiday_flg","st_exchange_calendar"."company_id" as "company_id","st_exchange_calendar"."exchange_sname" as "exchange_sname","st_exchange_calendar"."write_date" as "write_date","st_exchange_calendar"."front_date" as "front_date","st_exchange_calendar"."exchange_id" as "exchange_id","st_exchange_calendar"."holiday_flg" as "holiday_flg","st_exchange_calendar"."create_date" as "create_date","st_exchange_calendar"."write_uid" as "write_uid","st_exchange_calendar"."close_time" as "close_time" FROM "st_exchange_calendar" WHERE "st_exchange_calendar".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)
0 min < 0.1% 11 ms 986 odoo 
SELECT "ir_translation".id FROM "ir_translation" WHERE ((((("ir_translation"."module" 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))  AND  ("ir_translation"."lang" = $61))  AND  ("ir_translation"."comments"::text like $62))  AND  "ir_translation"."value" IS NOT NULL)  AND  ("ir_translation"."value" != $63)) ORDER BY "ir_translation"."module"
0 min < 0.1% 0 ms 504,470 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)
		                                 WHERE a.group_id IS NULL
		                                   AND m.model = $3
		                                   AND a.active IS TRUE
0 min < 0.1% 0 ms 70,003 odoo 
SELECT t.tableoid, t.oid, t.relname AS indexname, inh.inhparent AS parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, i.indkey, i.indisclustered, i.indisreplident, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, $1) AS condef, (SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, (SELECT pg_catalog.array_agg(attnum ORDER BY attnum)   FROM pg_catalog.pg_attribute   WHERE attrelid = i.indexrelid AND     attstattarget >= $2) AS indstatcols,(SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum)   FROM pg_catalog.pg_attribute   WHERE attrelid = i.indexrelid AND     attstattarget >= $3) AS indstatvals FROM pg_catalog.pg_index i JOIN pg_catalog.pg_class t ON (t.oid = i.indexrelid) JOIN pg_catalog.pg_class t2 ON (t2.oid = i.indrelid) LEFT JOIN pg_catalog.pg_constraint c ON (i.indrelid = c.conrelid AND i.indexrelid = c.conindid AND c.contype IN ($4,$5,$6)) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE i.indrelid = $7::pg_catalog.oid AND (i.indisvalid OR t2.relkind = $8) AND i.indisready ORDER BY indexname
0 min < 0.1% 0 ms 781,462 odoo 
SELECT value FROM ir_translation
                       WHERE lang=$1 AND type in ($2, $3) AND src=$4 AND md5(src)=md5($5)
0 min < 0.1% 0 ms 122,245 odoo 
SELECT at.attname, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(at.attacl,pg_catalog.acldefault($1,c.relowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $2 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($3,c.relowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) AS attacl, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($4,c.relowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $5 FROM pg_catalog.unnest(coalesce(at.attacl,pg_catalog.acldefault($6,c.relowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) AS rattacl, $7 AS initattacl, $8 AS initrattacl FROM pg_catalog.pg_attribute at JOIN pg_catalog.pg_class c ON (at.attrelid = c.oid) LEFT JOIN pg_catalog.pg_init_privs pip ON (at.attrelid = pip.objoid AND pip.classoid = $9::pg_catalog.regclass AND at.attnum = pip.objsubid) WHERE at.attrelid = $10::pg_catalog.oid AND NOT at.attisdropped AND ((SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(at.attacl,pg_catalog.acldefault($11,c.relowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $12 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($13,c.relowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) IS NOT NULL OR (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($14,c.relowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $15 FROM pg_catalog.unnest(coalesce(at.attacl,pg_catalog.acldefault($16,c.relowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR $17 IS NOT NULL OR $18 IS NOT NULL)ORDER BY at.attnum
0 min < 0.1% 0 ms 306,235 odoo 
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > $1)  AND  ("bus_bus"."channel" in ($2,$3,$4,$5,$6))) ORDER BY "bus_bus"."id"
0 min < 0.1% 0 ms 662,840 afxprodbakusr 
select fxreportac0_."id" as id1_15_0_, fxreportac0_."Assets" as assets2_15_0_, fxreportac0_."Balance" as balance3_15_0_, fxreportac0_."BlockedCommission" as blockedc4_15_0_, fxreportac0_."BlockedProfit" as blockedp5_15_0_, fxreportac0_."Commission" as commissi6_15_0_, fxreportac0_."create_date" as create_d7_15_0_, fxreportac0_."Credit" as credit8_15_0_, fxreportac0_."CurrencyDigits" as currency9_15_0_, fxreportac0_."Equity" as equity10_15_0_, fxreportac0_."Floating" as floatin11_15_0_, fxreportac0_."Liabilities" as liabili12_15_0_, fxreportac0_."Login" as login13_15_0_, fxreportac0_."Margin" as margin14_15_0_, fxreportac0_."MarginFree" as marginf15_15_0_, fxreportac0_."MarginInitial" as margini16_15_0_, fxreportac0_."MarginLevel" as marginl17_15_0_, fxreportac0_."MarginLeverage" as marginl18_15_0_, fxreportac0_."MarginMaintenance" as marginm19_15_0_, fxreportac0_."Profit" as profit20_15_0_, fxreportac0_."report_date" as report_21_15_0_, fxreportac0_."Storage" as storage22_15_0_, fxreportac0_."write_date" as write_d23_15_0_ from fx_report_accounts_daily fxreportac0_ where fxreportac0_."id"=$1
0 min < 0.1% 0 ms 1,024,414 odoo 
SELECT "bus_presence"."id" as "id","bus_presence"."status" as "status","bus_presence"."last_presence" as "last_presence","bus_presence"."user_id" as "user_id","bus_presence"."last_poll" as "last_poll" FROM "bus_presence" WHERE "bus_presence".id IN ($1)
0 min < 0.1% 0 ms 89,011 mt5backup_main 
INSERT INTO "mt5_positions" ("Position_ID","Position","Timestamp","ExternalID","Login","Dealer","Symbol","Action","Digits","DigitsCurrency","Reason","ContractSize","TimeCreate","TimeUpdate","TimeCreateMsc","TimeUpdateMsc","PriceOpen","PriceCurrent","PriceSL","PriceTP","VolumeExt","Profit","Storage","RateProfit","RateMargin","ExpertID","ExpertPositionID","Comment","ActivationMode","ActivationTime","ActivationPrice","ActivationFlags","ActionGateway","PriceGateway","VolumeGatewayExt","Volume","ApiData") VALUES ($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)
0 min < 0.1% 0 ms 113,353 odoo 
SELECT "ir_model_fields".id FROM "ir_model_fields" WHERE ("ir_model_fields"."model" = $1) ORDER BY "ir_model_fields"."name"
0 min < 0.1% 0 ms 677,455 mt5backup_main 
INSERT INTO "mt5_daily" ("Datetime","Login","Timestamp","DatetimePrev","Name","Group","Currency","Company","EMail","Balance","Credit","InterestRate","CommissionDaily","CommissionMonthly","AgentDaily","AgentMonthly","BalancePrevDay","BalancePrevMonth","EquityPrevDay","EquityPrevMonth","Margin","MarginFree","MarginLevel","MarginLeverage","Profit","ProfitStorage","ProfitEquity","ProfitAssets","ProfitLiabilities","DailyProfit","DailyBalance","DailyCredit","DailyCharge","DailyCorrection","DailyBonus","DailyStorage","DailyCommInstant","DailyCommFee","DailyCommRound","DailyAgent","DailyInterest","DailyDividend","DailyTaxes","DailySOCompensation","DailySOCompensationCredit") VALUES ($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)
0 min < 0.1% 0 ms 157,534 odoo 
SELECT MAX(CASE WHEN perm_create THEN $1 ELSE $2 END)
		                              FROM ir_model_access a
		                              JOIN ir_model m ON (m.id = a.model_id)
		                              JOIN res_groups_users_rel gu ON (gu.gid = a.group_id)
		                             WHERE m.model = $3
		                               AND gu.uid = $4
		                               AND a.active IS TRUE
0 min < 0.1% 0 ms 111,135 odoo 
INSERT INTO "survey_user_input_transient" ("id", "create_uid", "create_date", "write_uid", "write_date", "answer", "partner_id", "question", "question_id", "survey_user_input_id") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10) RETURNING id
0 min < 0.1% 0 ms 784,409 odoo 
SELECT count($1) FROM "fx_res_partner_trading" WHERE (("fx_res_partner_trading"."active" = $2)  AND  ("fx_res_partner_trading"."partner_id" = $3))
0 min < 0.1% 0 ms 964,526 odoo 
SELECT value FROM ir_translation
                       WHERE lang=$1 AND type in ($2) AND src=$3 AND md5(src)=md5($4) AND name=$5
0 min < 0.1% 1 ms 6,089 odoo 
SELECT count($1) FROM "res_partner" WHERE (("res_partner"."active" = $2)  AND  (("res_partner"."stage_id" = $3)  AND  ("res_partner"."type" = $4))) AND (("res_partner"."company_id" in ($5))  AND  ((("res_partner"."type" != $6)  OR  "res_partner"."type" IS NULL )  OR  ("res_partner"."type" = $7)))
0 min < 0.1% 0 ms 584,893 afxprodbakusr 
select respartner_.id, respartner_.active as active2_42_, respartner_.additional_info as addition3_42_, respartner_.barcode as barcode4_42_, respartner_.calendar_last_notif_ack as calendar5_42_, respartner_.city as city6_42_, respartner_.color as color7_42_, respartner_.comment as comment8_42_, respartner_.commercial_company_name as commerci9_42_, respartner_.is_company as is_comp10_42_, respartner_.company_name as company11_42_, respartner_.create_date as create_12_42_, respartner_.credit_limit as credit_13_42_, respartner_.customer as custome14_42_, respartner_.date as date15_42_, respartner_.display_name as display16_42_, respartner_.email as email17_42_, respartner_.employee as employe18_42_, respartner_.first_deposit_date as first_d19_42_, respartner_.function as functio20_42_, respartner_.fx_dept as fx_dept21_42_, respartner_.fx_dob as fx_dob22_42_, respartner_.fx_fax as fx_fax23_42_, respartner_.fx_gender as fx_gend24_42_, respartner_.fx_industry_content as fx_indu25_42_, respartner_.fx_name1 as fx_name26_42_, respartner_.fx_occ_company_name as fx_occ_27_42_, respartner_.fx_occ_other as fx_occ_28_42_, respartner_.fx_occ_phone as fx_occ_29_42_, respartner_.fx_street3 as fx_stre30_42_, respartner_.fx_subruler_liveinjp_flg as fx_subr31_42_, respartner_.lang as lang32_42_, respartner_.message_bounce as message33_42_, respartner_.mobile as mobile34_42_, respartner_.name as name35_42_, respartner_.partner_gid as partner36_42_, respartner_.partner_share as partner37_42_, respartner_.password as passwor38_42_, respartner_.phone as phone39_42_, respartner_.ref as ref40_42_, respartner_.commercial_partner_id as commerc58_42_, respartner_.parent_id as parent_59_42_, respartner_.signup_expiration as signup_41_42_, respartner_.signup_token as signup_42_42_, respartner_.signup_type as signup_43_42_, respartner_.stage_code as stage_c44_42_, respartner_.status_applied_date as status_45_42_, respartner_.status_audit_date as status_46_42_, respartner_.status_completed_date as status_47_42_, respartner_.status_docwait_date as status_48_42_, respartner_.street as street49_42_, respartner_.street2 as street50_42_, respartner_.supplier as supplie51_42_, respartner_.type as type52_42_, respartner_.tz as tz53_42_, respartner_.vat as vat54_42_, respartner_.website as website55_42_, respartner_.write_date as write_d56_42_, respartner_.zip as zip57_42_ from res_partner respartner_ where respartner_.id=$1
0 min < 0.1% 0 ms 292,255 odoo 
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > $1)  AND  ("bus_bus"."channel" in ($2,$3,$4,$5,$6,$7))) ORDER BY "bus_bus"."id"
0 min < 0.1% 73 ms 95 afxprodbakusr 
SELECT  SE.STEP_EXECUTION_ID, SE.STEP_NAME, SE.START_TIME, SE.END_TIME, SE.STATUS, SE.COMMIT_COUNT, SE.READ_COUNT, SE.FILTER_COUNT, SE.WRITE_COUNT, SE.EXIT_CODE, SE.EXIT_MESSAGE, SE.READ_SKIP_COUNT, SE.WRITE_SKIP_COUNT, SE.PROCESS_SKIP_COUNT, SE.ROLLBACK_COUNT, SE.LAST_UPDATED, SE.VERSION, JE.JOB_EXECUTION_ID, JE.START_TIME, JE.END_TIME, JE.STATUS, JE.EXIT_CODE, JE.EXIT_MESSAGE, JE.CREATE_TIME, JE.LAST_UPDATED, JE.VERSION from BATCH_JOB_EXECUTION JE, BATCH_STEP_EXECUTION SE where       SE.JOB_EXECUTION_ID in (SELECT JOB_EXECUTION_ID from BATCH_JOB_EXECUTION where JE.JOB_INSTANCE_ID = $1)      and SE.JOB_EXECUTION_ID = JE.JOB_EXECUTION_ID       and SE.STEP_NAME = $2 order by SE.START_TIME desc, SE.STEP_EXECUTION_ID desc
0 min < 0.1% 91 ms 74 afxprodapiusr 
SELECT "fx_news_trace"."id", "fx_news_trace"."news_id", "fx_news_trace"."partner_id", "fx_news_trace"."active", "fx_news_trace"."read_flg", "fx_news_trace"."agree_flg", "fx_news_trace"."create_date", "fx_news_trace"."write_date", "fx_news_trace"."create_uid", "fx_news_trace"."write_uid", "fx_news_trace"."agree_date" FROM "fx_news_trace" WHERE ("fx_news_trace"."active" = $1 AND "fx_news_trace"."news_id" = $2 AND "fx_news_trace"."partner_id" = $3) ORDER BY "fx_news_trace"."id" ASC LIMIT $4
Details
CREATE INDEX CONCURRENTLY ON fx_news_trace (partner_id, news_id)
0 min < 0.1% 0 ms 117,616 mt5backup_main 
UPDATE "mt5_users" SET "TimestampTrade"=$1,"Balance"=$2,"Credit"=$3,"InterestRate"=$4,"CommissionDaily"=$5,"CommissionMonthly"=$6,"BalancePrevDay"=$7,"BalancePrevMonth"=$8,"EquityPrevDay"=$9,"EquityPrevMonth"=$10 WHERE ("Login"=$11)