PgHero

Queries

Total Time Average Time Calls
6,669 min 38% 50,471 ms 7,928 odoo 
REFRESH MATERIALIZED VIEW mt5_orders_view
5,817 min 33% 44,021 ms 7,928 odoo 
REFRESH MATERIALIZED VIEW mt5_deals_view
2,964 min 17% 0 ms 406,952,897 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)
406 min 2% 42 ms 584,035 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)
369 min 2% 41 ms 543,095 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)
272 min 2% 20 ms 818,439 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)
261 min 1% 44 ms 356,748 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)
225 min 1% 21 ms 639,916 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)
198 min 1% 33 ms 356,748 afxprodapiusr 
select MAX(news_id) from fx_market_news
93 min 0.5% 0 ms 361,639,216 mt5backup_main 
UPDATE "mt5_positions" SET "PriceCurrent"=$1,"Profit"=$2 WHERE ("Position_ID"=$3)
83 min 0.5% 40 ms 125,964 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)
73 min 0.4% 77 ms 56,931 afxprodapiusr 
update fx_market_news
                        set push_flg = $1 
                        where news_id = $2
Details
CREATE INDEX CONCURRENTLY ON fx_market_news (news_id)
50 min 0.3% 0 ms 199,401,828 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)
47 min 0.3% 45 ms 61,956 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)
24 min 0.1% 0 ms 58,960,228 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)
11 min < 0.1% 21 ms 32,237 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)
11 min < 0.1% 0 ms 1,372,288 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 *
10 min < 0.1% 22 ms 26,521 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)
6 min < 0.1% 0 ms 1,412,378 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 *
6 min < 0.1% 0 ms 267,232,064 mt5backup_main 
BEGIN
4 min < 0.1% 1 ms 238,685 mt5backup_main 
SELECT "column_name"::varchar,"data_type"::varchar,"numeric_precision"::int4,"datetime_precision"::int4,"character_maximum_length"::int4,"is_nullable"::bool FROM information_schema.columns WHERE table_schema=current_schema() and table_name=$1
4 min < 0.1% 0 ms 13,839,167 odoo 
DISCARD ALL
4 min < 0.1% 0 ms 267,232,064 mt5backup_main 
COMMIT
4 min < 0.1% 0 ms 34,431,084 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())
3 min < 0.1% 1 ms 276,988 odoo 
SELECT CAST("Symbol_ID" AS INTEGER), "Symbol" 
                   FROM   mt5_symbols
                   WHERE "Path" SIMILAR TO $1
3 min < 0.1% 298 ms 643 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)
3 min < 0.1% 0 ms 3,732,396 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
2 min < 0.1% 2 ms 88,532 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"
2 min < 0.1% 22 ms 5,935 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)
2 min < 0.1% 2 ms 66,522 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)
2 min < 0.1% 0 ms 1,637,935 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)
2 min < 0.1% 0 ms 1,644,729 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
2 min < 0.1% 0 ms 639,916 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"
2 min < 0.1% 0 ms 797,832 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 356,748 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 199,458 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 61,967 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 14,076,126 odoo 
BEGIN ISOLATION LEVEL REPEATABLE READ
1 min < 0.1% 1 ms 110,675 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 924,699 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 5,088,177 mt5backup_main 
UPDATE "mt5_orders" SET "PriceCurrent"=$1 WHERE ("Order"=$2)
1 min < 0.1% 106 ms 627 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)
1 min < 0.1% 0 ms 3,668,790 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","Flags","PriceOrder","PriceTrigger","PriceCurrent","PriceSL","PriceTP","VolumeInitialExt","VolumeCurrentExt","ExpertID","PositionID","PositionByID","PartyID","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,$40,$41)
1 min < 0.1% 0 ms 2,474,120 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","PartyID","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,$47)
1 min < 0.1% 11 ms 5,946 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
1 min < 0.1% 0 ms 1,378,858 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 *
1 min < 0.1% 0 ms 4,301,799 odoo 
SELECT base_registry_signaling.last_value,
                                  base_cache_signaling.last_value
                           FROM base_registry_signaling, base_cache_signaling
1 min < 0.1% 0 ms 285,199 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
1 min < 0.1% 0 ms 1,103,541 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 452,232 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
1 min < 0.1% 2 ms 25,188 odoo 
SELECT "st_exchange_calendar"."id" as "id","st_exchange_calendar"."national_holiday_flg" as "national_holiday_flg","st_exchange_calendar"."note" as "note","st_exchange_calendar"."write_uid" as "write_uid","st_exchange_calendar"."write_date" as "write_date","st_exchange_calendar"."front_date" as "front_date","st_exchange_calendar"."holiday_flg" as "holiday_flg","st_exchange_calendar"."create_uid" as "create_uid","st_exchange_calendar"."exchange_sname" as "exchange_sname","st_exchange_calendar"."create_date" as "create_date","st_exchange_calendar"."company_id" as "company_id","st_exchange_calendar"."close_time" as "close_time","st_exchange_calendar"."exchange_id" as "exchange_id","st_exchange_calendar"."open_time" as "open_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)
1 min < 0.1% 1 ms 30,314 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 ))
1 min < 0.1% 0 ms 601,825 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
1 min < 0.1% 5 ms 5,946 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
1 min < 0.1% 0 ms 430,277 odoo 
insert into fx_remind_mail ("create_date", email, partner_id, "remind_finish_doc_date", remind_finish_doc_flg, "remind_funding_date", remind_funding_flg, "remind_trading_date", remind_trading_flg, company_id, "write_date") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)
RETURNING *
1 min < 0.1% 6 ms 5,036 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)
1 min < 0.1% 0 ms 468,253 mt5backup_main 
FETCH FORWARD 10000 FROM "mt5_batch_reader"
1 min < 0.1% 0 ms 66,934 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% 1 ms 22,607 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% 23 ms 1,207 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)
0 min < 0.1% 22 ms 1,207 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)
0 min < 0.1% 0 ms 628,015 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,"Flags"=$20,"PriceOrder"=$21,"PriceTrigger"=$22,"PriceCurrent"=$23,"PriceSL"=$24,"PriceTP"=$25,"VolumeInitialExt"=$26,"VolumeCurrentExt"=$27,"ExpertID"=$28,"PositionID"=$29,"PositionByID"=$30,"PartyID"=$31,"RateMargin"=$32,"Comment"=$33,"ActivationMode"=$34,"ActivationTime"=$35,"ActivationPrice"=$36,"ActivationFlags"=$37,"VolumeInitial"=$38,"VolumeCurrent"=$39,"ApiData"=$40 WHERE ("Order"=$41)
0 min < 0.1% 0 ms 199,426 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% 23 ms 988 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)
0 min < 0.1% 22 ms 988 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)
0 min < 0.1% 0 ms 1,554,952 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,567,092 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 963,718 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 1,642,392 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% 1 ms 32,522 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% 78 ms 239 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% 0 ms 1,372,288 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 222,627 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 298,221 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 35,765 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
0 min < 0.1% 0 ms 1,963,582 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% 0 ms 1,531,494 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 646,831 odoo 
SELECT * FROM ir_cron
                              WHERE numbercall != $1
                                  AND active AND nextcall <= (now() at time zone $2)
                              ORDER BY priority
0 min < 0.1% 0 ms 259,573 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)
0 min < 0.1% 1 ms 8,248 odoo 
SELECT "st_exchange_calendar"."id" as "id","st_exchange_calendar"."national_holiday_flg" as "national_holiday_flg","st_exchange_calendar"."note" as "note","st_exchange_calendar"."write_uid" as "write_uid","st_exchange_calendar"."write_date" as "write_date","st_exchange_calendar"."front_date" as "front_date","st_exchange_calendar"."holiday_flg" as "holiday_flg","st_exchange_calendar"."create_uid" as "create_uid","st_exchange_calendar"."exchange_sname" as "exchange_sname","st_exchange_calendar"."create_date" as "create_date","st_exchange_calendar"."company_id" as "company_id","st_exchange_calendar"."close_time" as "close_time","st_exchange_calendar"."exchange_id" as "exchange_id","st_exchange_calendar"."open_time" as "open_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)
0 min < 0.1% 0 ms 260,698 odoo 
SELECT website_lang_rel.website_id, website_lang_rel.lang_id FROM website_lang_rel, "res_lang"
                    WHERE ("res_lang"."active" = $1) AND website_lang_rel.website_id IN ($2) AND website_lang_rel.lang_id = res_lang.id
                     ORDER BY COALESCE("res_lang"."active", $3) DESC,"res_lang"."name"    OFFSET $4
0 min < 0.1% 0 ms 1,770,449 odoo 
SELECT "res_company".id FROM "res_company" WHERE ("res_company"."parent_id" in ($1)) ORDER BY "res_company"."sequence" ,"res_company"."name"
0 min < 0.1% 0 ms 47,039 odoo 
INSERT INTO "auditlog_log" ("id", "create_uid", "create_date", "write_uid", "write_date", "http_request_id", "http_session_id", "log_type", "method", "model_id", "name", "res_id", "user_id") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10, $11, $12, $13) RETURNING id
0 min < 0.1% 0 ms 199,753 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","Flags","PriceOrder","PriceTrigger","PriceCurrent","PriceSL","PriceTP","VolumeInitialExt","VolumeCurrentExt","ExpertID","PositionID","PositionByID","PartyID","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,$40,$41)
0 min < 0.1% 1 ms 11,204 pspprodbakusr 
update res_partner set lang=$1, write_date=$2 where id=$3
0 min < 0.1% 0 ms 109,221 odoo 
SELECT *
                                       FROM ir_cron
                                       WHERE numbercall != $1
                                          AND active
                                          AND nextcall <= (now() at time zone $2)
                                          AND id=$3
                                       FOR UPDATE NOWAIT
0 min < 0.1% 0 ms 70,880 afxprodbakusr 
select mt5groups0_."Group_ID" as group_id1_9_, mt5groups0_."AuthMode" as authmode2_9_, mt5groups0_."AuthOTPMode" as authotpm3_9_, mt5groups0_."AuthPasswordMin" as authpass4_9_, mt5groups0_."Company" as company5_9_, mt5groups0_."CompanyCatalog" as companyc6_9_, mt5groups0_."CompanyDepositURL" as companyd7_9_, mt5groups0_."CompanyEmail" as companye8_9_, mt5groups0_."CompanyPage" as companyp9_9_, mt5groups0_."CompanySupportEmail" as company10_9_, mt5groups0_."CompanySupportPage" as company11_9_, mt5groups0_."CompanyWithdrawalURL" as company12_9_, mt5groups0_."Currency" as currenc13_9_, mt5groups0_."CurrencyDigits" as currenc14_9_, mt5groups0_."DemoDeposit" as demodep15_9_, mt5groups0_."DemoLeverage" as demolev16_9_, mt5groups0_."DemoTradesClean" as demotra17_9_, mt5groups0_."Group" as group18_9_, mt5groups0_."LimitHistory" as limithi19_9_, mt5groups0_."LimitOrders" as limitor20_9_, mt5groups0_."LimitPositions" as limitpo21_9_, mt5groups0_."LimitSymbols" as limitsy22_9_, mt5groups0_."MailMode" as mailmod23_9_, mt5groups0_."MarginCall" as marginc24_9_, mt5groups0_."MarginFreeMode" as marginf25_9_, mt5groups0_."MarginFreeProfitMode" as marginf26_9_, mt5groups0_."MarginMode" as marginm27_9_, mt5groups0_."MarginSOMode" as margins28_9_, mt5groups0_."MarginStopOut" as margins29_9_, mt5groups0_."NewsCategory" as newscat30_9_, mt5groups0_."NewsMode" as newsmod31_9_, mt5groups0_."PermissionsFlags" as permiss32_9_, mt5groups0_."ReportsEmail" as reports33_9_, mt5groups0_."ReportsFlags" as reports34_9_, mt5groups0_."ReportsMode" as reports35_9_, mt5groups0_."Server" as server36_9_, mt5groups0_."Timestamp" as timesta37_9_, mt5groups0_."TradeFlags" as tradefl38_9_, mt5groups0_."TradeInterestrate" as tradein39_9_, mt5groups0_."TradeVirtualCredit" as tradevi40_9_, mt5groups0_."TransferMode" as transfe41_9_ from mt5_groups mt5groups0_ where mt5groups0_."Group" like $1
0 min < 0.1% 0 ms 646,831 odoo 
SELECT latest_version FROM ir_module_module WHERE name=$1
0 min < 0.1% 3 ms 2,539 pspprodbakusr 
select fxrespartn0_.id as id1_2_, fxrespartn0_.active as active2_2_, fxrespartn0_.buten_cd as buten_cd3_2_, fxrespartn0_.buten_id as buten_id4_2_, fxrespartn0_.device_id as device_i5_2_, fxrespartn0_.insider_ticker_code as insider_6_2_, fxrespartn0_.login_audit as login_au7_2_, fxrespartn0_.login_email as login_em8_2_, fxrespartn0_.login_id as login_id9_2_, fxrespartn0_.partner_id as partner10_2_, fxrespartn0_.passkey_required_at as passkey11_2_, fxrespartn0_.passkey_skip_at as passkey12_2_, fxrespartn0_.password as passwor13_2_, fxrespartn0_.pwd_change_flg as pwd_cha14_2_, fxrespartn0_.pwd_expired as pwd_exp15_2_, fxrespartn0_.skip_passkey_flg as skip_pa16_2_, fxrespartn0_.st_account_category as st_acco17_2_, fxrespartn0_.trading_pin as trading18_2_, fxrespartn0_.trading_pin_expired as trading19_2_, fxrespartn0_.user_passkey as user_pa20_2_, fxrespartn0_.withdraw_pin as withdra21_2_, fxrespartn0_.withdraw_pin_expired as withdra22_2_ from fx_res_partner fxrespartn0_ where fxrespartn0_.skip_passkey_flg=$1
0 min < 0.1% 0 ms 10,493,859 odoo 
COMMIT
0 min < 0.1% 0 ms 280,238 odoo 
SELECT active, id, login, password, (SELECT value FROM ir_config_parameter WHERE key=$1)
                                FROM res_users
                                WHERE id=$2
0 min < 0.1% 0 ms 46,123 afxprodbakusr 
update fx_report_accounts_daily set "Assets"=$1, "Balance"=$2, "BlockedCommission"=$3, "BlockedProfit"=$4, "Commission"=$5, "create_date"=$6, "Credit"=$7, "CurrencyDigits"=$8, "Equity"=$9, "Floating"=$10, "Liabilities"=$11, "Login"=$12, "Margin"=$13, "MarginFree"=$14, "MarginInitial"=$15, "MarginLevel"=$16, "MarginLeverage"=$17, "MarginMaintenance"=$18, "Profit"=$19, "report_date"=$20, "Storage"=$21, "write_date"=$22 where "id"=$23
0 min < 0.1% 0 ms 199,603 mt5backup_main 
DELETE FROM "mt5_positions" WHERE ("Position_ID"=$1)
0 min < 0.1% 0 ms 475,359 odoo 
SELECT $1 FROM res_groups_users_rel WHERE uid=$2 AND gid IN
                            (SELECT res_id FROM ir_model_data WHERE module=$3 AND name=$4)
0 min < 0.1% 0 ms 44,540 odoo 
SELECT "ir_module_module".id FROM "ir_module_module" WHERE ("ir_module_module"."state" = $1) ORDER BY "ir_module_module"."sequence" ,"ir_module_module"."name"
Details
CREATE INDEX CONCURRENTLY ON ir_module_module (state, sequence)
0 min < 0.1% 0 ms 104,680 odoo 
INSERT INTO "mail_tracking_value" ("id", "create_uid", "create_date", "write_uid", "write_date", "field", "field_desc", "field_type", "mail_message_id", "new_value_float", "old_value_float", "track_sequence") VALUES (nextval($1), $2, (now() at time zone $3), $4, (now() at time zone $5), $6, $7, $8, $9, $10, $11, $12) RETURNING id
0 min < 0.1% 0 ms 646,831 odoo 
SELECT COUNT(*) FROM ir_module_module WHERE state LIKE $1
Details
CREATE INDEX CONCURRENTLY ON ir_module_module USING gist (state gist_trgm_ops)
0 min < 0.1% 0 ms 451,321 odoo 
SELECT * FROM ir_translation
                    WHERE lang=$1 AND type=$2 AND name=$3 AND res_id IN ($4)
0 min < 0.1% 0 ms 574,769 odoo 
SELECT "fx_report_template".id FROM "fx_report_template" WHERE (("fx_report_template"."report_cd" = $1)  AND  ("fx_report_template"."company_id" = $2)) ORDER BY "fx_report_template"."id"   limit $3
0 min < 0.1% 1 ms 5,951 afxprodapiusr 
SELECT id, news_title, news_content, news_scope, 
            trading_account_id, news_group, push_flg 
            FROM fx_news WHERE push_flg = $1 
            AND publish_date < now() 
            AND company_id = $2
            AND active = $3
Details
CREATE INDEX CONCURRENTLY ON fx_news (publish_date)