PgHero

Queries

Total Time Average Time Calls
2,335 min 54% 0 ms 829,177,071 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)
403 min 9% 15 ms 1,633,848 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)
240 min 6% 34 ms 425,856 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)
183 min 4% 26 ms 425,856 afxprodapiusr 
select MAX(news_id) from fx_market_news
182 min 4% 16 ms 696,372 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)
140 min 3% 0 ms 544,890,677 mt5backup_main 
UPDATE "mt5_positions" SET "PriceCurrent"=$1,"Profit"=$2 WHERE ("Position_ID"=$3)
74 min 2% 10 ms 446,696 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)
66 min 2% 10 ms 409,192 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)
63 min 1% 58 ms 65,364 afxprodapiusr 
update fx_market_news
                        set push_flg = $1 
                        where news_id = $2
Details
CREATE INDEX CONCURRENTLY ON fx_market_news (news_id)
60 min 1% 0 ms 238,998,208 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)
41 min 1.0% 35 ms 71,286 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)
31 min 0.7% 0 ms 300,486,295 odoo 
insert into fx_mt5_auditlog_2025 (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())
25 min 0.6% 0 ms 68,052,972 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)
22 min 0.5% 15 ms 85,931 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)
20 min 0.5% 948 ms 1,285 odoo 
SELECT count($1) FROM "fx_report_company" WHERE (("fx_report_company"."account_type" in ($2,$3,$4,$5))  AND  ("fx_report_company"."file_name"::text ilike $6)) AND ("fx_report_company"."company_id" in ($7))
16 min 0.4% 114 ms 8,619 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)
14 min 0.3% 15 ms 56,075 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)
14 min 0.3% 9 ms 97,314 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)
14 min 0.3% 15 ms 54,972 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)
14 min 0.3% 16 ms 51,388 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)
14 min 0.3% 16 ms 51,388 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)
13 min 0.3% 222 ms 3,540 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350)
13 min 0.3% 214 ms 3,611 odoo 
SELECT count($1) FROM "fx_report_partner" WHERE ("fx_report_partner"."account_type" in ($2,$3,$4,$5)) AND ("fx_report_partner"."company_id" in ($6))
Details
CREATE INDEX CONCURRENTLY ON fx_report_partner (account_type)
12 min 0.3% 16 ms 44,308 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)
11 min 0.3% 225 ms 2,979 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350)
10 min 0.2% 15 ms 40,559 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)
10 min 0.2% 60 ms 10,149 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
8 min 0.2% 0 ms 1,115,988 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 *
8 min 0.2% 200 ms 2,383 odoo 
SELECT count($1) FROM "fx_report_company" WHERE ("fx_report_company"."account_type" in ($2,$3,$4,$5)) AND ("fx_report_company"."company_id" in ($6))
Details
CREATE INDEX CONCURRENTLY ON fx_report_company (account_type)
6 min 0.1% 43 ms 8,309 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)
5 min 0.1% 0 ms 267,381,861 mt5backup_main 
BEGIN
5 min 0.1% 108 ms 2,709 afxprodapiusr 
SELECT * FROM (SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull OR (t.typtype = $1 AND t.typnotnull) AS attnotnull,a.atttypmod,a.attlen,t.typtypmod,row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif(a.attidentity, $2) as attidentity,nullif(a.attgenerated, $3) as attgenerated,pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc,dsc.description,t.typbasetype,t.typtype  FROM pg_catalog.pg_namespace n  JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid)  JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid)  JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid)  LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum)  LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid)  LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname=$4)  LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname=$5)  WHERE c.relkind in ($6,$7,$8,$9,$10) and a.attnum > $11 AND NOT a.attisdropped  AND n.nspname LIKE $12) c WHERE $13  AND attname LIKE $14 ORDER BY nspname,c.relname,attnum
5 min 0.1% 14 ms 21,218 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"
5 min 0.1% 7 ms 40,099 odoo 
SELECT "ir_translation"."id" as "id","ir_translation"."module" as "module","ir_translation"."src" as "src","ir_translation"."value" as "value","ir_translation"."lang" as "lang" FROM "ir_translation" WHERE "ir_translation".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)
5 min 0.1% 0 ms 1,153,664 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 *
4 min 0.1% 18,960 ms 14 odoo 
SELECT "mt5_deals_view"."id" as "id","mt5_deals_view"."Action" as "Action","mt5_deals_view"."ContractSize" as "ContractSize","mt5_deals_view"."PriceSL" as "PriceSL","mt5_deals_view"."Flags" as "Flags","mt5_deals_view"."Dealer" as "Dealer","mt5_deals_view"."Fee" as "Fee","mt5_deals_view"."RateMargin" as "RateMargin","mt5_deals_view"."Time" as "Time","mt5_deals_view"."Entry" as "Entry","mt5_deals_view"."PriceTP" as "PriceTP","mt5_deals_view"."PriceGateway" as "PriceGateway","mt5_deals_view"."Order" as "Order","mt5_deals_view"."ExpertID" as "ExpertID","mt5_deals_view"."PositionID" as "PositionID","mt5_deals_view"."TimeMsc" as "TimeMsc","mt5_deals_view"."ModifyFlags" as "ModifyFlags","mt5_deals_view"."Symbol" as "Symbol","mt5_deals_view"."Gateway" as "Gateway","mt5_deals_view"."Reason" as "Reason","mt5_deals_view"."VolumeClosedExt" as "VolumeClosedExt","mt5_deals_view"."Comment" as "Comment","mt5_deals_view"."trading_account_id" as "trading_account_id","mt5_deals_view"."VolumeExt" as "VolumeExt","mt5_deals_view"."Volume" as "Volume","mt5_deals_view"."Price" as "Price","mt5_deals_view"."Digits" as "Digits","mt5_deals_view"."TickValue" as "TickValue","mt5_deals_view"."Action_close" as "Action_close","mt5_deals_view"."ExternalID" as "ExternalID","mt5_deals_view"."ProfitRaw" as "ProfitRaw","mt5_deals_view"."Profit" as "Profit","mt5_deals_view"."Deal" as "Deal","mt5_deals_view"."VolumeClosed" as "VolumeClosed","mt5_deals_view"."Price_close" as "Price_close","mt5_deals_view"."DigitsCurrency" as "DigitsCurrency","mt5_deals_view"."Storage" as "Storage","mt5_deals_view"."TickSize" as "TickSize","mt5_deals_view"."Volume_close" as "Volume_close","mt5_deals_view"."Login" as "Login","mt5_deals_view"."PricePosition" as "PricePosition","mt5_deals_view"."Timestamp" as "Timestamp","mt5_deals_view"."Commission" as "Commission","mt5_deals_view"."ApiData" as "ApiData","mt5_deals_view"."RateProfit" as "RateProfit" FROM "mt5_deals_view" WHERE "mt5_deals_view".id IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000) AND ("mt5_deals_view"."trading_account_id" in ($1001,$1002,$1003,$1004,$1005,$1006,$1007,$1008,$1009,$1010,$1011,$1012,$1013,$1014,$1015,$1016,$1017,$1018,$1019,$1020,$1021,$1022,$1023,$1024,$1025,$1026,$1027,$1028,$1029,$1030,$1031,$1032,$1033,$1034,$1035,$1036,$1037,$1038,$1039,$1040,$1041,$1042,$1043,$1044,$1045,$1046,$1047,$1048,$1049,$1050,$1051,$1052,$1053,$1054,$1055,$1056,$1057,$1058,$1059,$1060,$1061,$1062,$1063,$1064,$1065,$1066,$1067,$1068,$1069,$1070,$1071,$1072,$1073,$1074,$1075,$1076,$1077,$1078,$1079,$1080,$1081,$1082,$1083,$1084,$1085,$1086,$1087,$1088,$1089,$1090,$1091,$1092,$1093,$1094,$1095,$1096,$1097,$1098,$1099,$1100,$1101,$1102,$1103,$1104,$1105,$1106,$1107,$1108,$1109,$1110,$1111,$1112,$1113,$1114,$1115,$1116,$1117,$1118,$1119,$1120,$1121,$1122,$1123,$1124,$1125,$1126,$1127,$1128,$1129,$1130,$1131,$1132,$1133,$1134,$1135,$1136,$1137,$1138,$1139,$1140,$1141,$1142,$1143,$1144,$1145,$1146,$1147,$1148,$1149,$1150,$1151,$1152,$1153,$1154,$1155,$1156,$1157,$1158,$1159,$1160,$1161,$1162,$1163,$1164,$1165,$1166,$1167,$1168,$1169,$1170,$1171,$1172,$1173,$1174,$1175,$1176,$1177,$1178,$1179,$1180,$1181,$1182,$1183,$1184,$1185,$1186,$1187,$1188,$1189,$1190,$1191,$1192,$1193,$1194,$1195,$1196,$1197,$1198,$1199,$1200,$1201,$1202,$1203,$1204,$1205,$1206,$1207,$1208,$1209,$1210,$1211,$1212,$1213,$1214,$1215,$1216,$1217,$1218,$1219,$1220,$1221,$1222,$1223,$1224,$1225,$1226,$1227,$1228,$1229,$1230,$1231,$1232,$1233,$1234,$1235,$1236,$1237,$1238,$1239,$1240,$1241,$1242,$1243,$1244,$1245,$1246,$1247,$1248,$1249,$1250,$1251,$1252,$1253,$1254,$1255,$1256,$1257,$1258,$1259,$1260,$1261,$1262,$1263,$1264,$1265,$1266,$1267,$1268,$1269,$1270,$1271,$1272,$1273,$1274,$1275,$1276,$1277,$1278,$1279,$1280,$1281,$1282,$1283,$1284,$1285,$1286,$1287,$1288,$1289,$1290,$1291,$1292,$1293,$1294,$1295,$1296,$1297,$1298,$1299,$1300,$1301,$1302,$1303,$1304,$1305,$1306,$1307,$1308,$1309,$1310,$1311,$1312,$1313,$1314,$1315,$1316,$1317,$1318,$1319,$1320,$1321,$1322,$1323,$1324,$1325,$1326,$1327,$1328,$1329,$1330,$1331,$1332,$1333,$1334,$1335,$1336,$1337,$1338,$1339,$1340,$1341,$1342,$1343,$1344,$1345,$1346,$1347,$13
4 min 0.1% 4 ms 65,697 odoo 
SELECT * FROM ir_translation
                    WHERE lang=$1 AND type=$2 AND name=$3 AND res_id IN ($4, $5, $6)
4 min < 0.1% 0 ms 6,753,476 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
4 min < 0.1% 0 ms 267,381,861 mt5backup_main 
COMMIT
4 min < 0.1% 0 ms 15,917,148 odoo 
DISCARD ALL
4 min < 0.1% 0 ms 14,914,084 mt5backup_main 
UPDATE "mt5_orders" SET "PriceCurrent"=$1 WHERE ("Order"=$2)
4 min < 0.1% 1 ms 339,321 odoo 
SELECT CAST("Symbol_ID" AS INTEGER), "Symbol" 
                   FROM   mt5_symbols
                   WHERE "Path" SIMILAR TO $1
3 min < 0.1% 0 ms 2,491,304 odoo 
SELECT value FROM ir_translation
                       WHERE lang=$1 AND type in ($2, $3) AND src=$4 AND md5(src)=md5($5)
3 min < 0.1% 243 ms 844 afxprodbakusr 
INSERT INTO fx_report_positions_daily (report_date, "Position_ID", "Position", "ExternalID", "Login", "Dealer", "Timestamp", "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", "Volume", "ApiData", "timing", company_id) SELECT $1 as report_date, mp."Position_ID" as position_id, mp."Position" as position, mp."ExternalID" as externalId, mp."Login" as login, mp."Dealer" as dealer, mp."Timestamp" as timestamp, mp."Symbol" as symbol, mp."Action" as action, mp."Digits" as digits, mp."DigitsCurrency" as digits_currency, mp."Reason" as reason, mp."ContractSize" as contract_size, mp."TimeCreate" as time_create, mp."TimeUpdate" as time_update, mp."TimeCreateMsc" as time_create_msc, mp."TimeUpdateMsc" as time_update_msc, mp."PriceOpen" as price_open, mp."PriceCurrent" as price_current, mp."PriceSL" as priceSl, mp."PriceTP" as priceTp, mp."VolumeExt" as volume_ext, mp."Profit" as profit, mp."Storage" as storage, mp."RateProfit" as rate_profit, mp."RateMargin" as rate_margin, mp."ExpertID" as expertId, mp."ExpertPositionID" as expert_positionId, mp."Comment" as comment, mp."ActivationMode" as activation_mode, mp."ActivationTime" as activation_time, mp."ActivationPrice" as activation_price, mp."ActivationFlags" as activation_flags, mp."Volume" as volume, mp."ApiData" as api_data, $2 as timing, $3 as company_id FROM mt5_positions as mp WHERE FLOOR(mp."Login" / $5) = $4
3 min < 0.1% 2 ms 121,754 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"
3 min < 0.1% 64 ms 3,102 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96)
3 min < 0.1% 146 ms 1,311 odoo 
SELECT "fx_report_company".id FROM "fx_report_company" WHERE (("fx_report_company"."account_type" in ($1,$2,$3,$4))  AND  ("fx_report_company"."file_name"::text ilike $5)) AND ("fx_report_company"."company_id" in ($6)) ORDER BY "fx_report_company"."report_date" DESC,"fx_report_company"."file_name"   limit $7
3 min < 0.1% 0 ms 1,620,432 odoo 
SELECT "survey_question".id FROM "survey_question" WHERE ("survey_question"."question_cd" = $1) ORDER BY "survey_question"."sequence" ,"survey_question"."id"   limit $2
3 min < 0.1% 0 ms 2,767,131 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)
3 min < 0.1% 0 ms 405,106 odoo 
SELECT "st_ticker".id FROM "st_ticker" WHERE "st_ticker"."ticker_code" IS NULL  ORDER BY "st_ticker"."ticker_code" ASC  limit $1
3 min < 0.1% 65 ms 2,638 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96)
3 min < 0.1% 4 ms 41,599 odoo 
SELECT * FROM ir_translation
                    WHERE lang=$1 AND type=$2 AND name=$3 AND res_id IN ($4, $5, $6, $7, $8)
3 min < 0.1% 216 ms 781 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350)
3 min < 0.1% 1 ms 125,897 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)
3 min < 0.1% 220 ms 737 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."write_uid" as "write_uid","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."relation_field_id" as "relation_field_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."model_id" as "model_id","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."create_uid" as "create_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350)
2 min < 0.1% 0 ms 1,944,075 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% 4 ms 33,028 odoo 
SELECT * FROM ir_translation
                    WHERE lang=$1 AND type=$2 AND name=$3 AND res_id IN ($4, $5, $6, $7)
2 min < 0.1% 56 ms 2,348 stoprodbakusr 
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
2 min < 0.1% 2 ms 51,941 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)
2 min < 0.1% 0 ms 451,342 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","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)
2 min < 0.1% 0 ms 760,373 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
2 min < 0.1% 23 ms 5,233 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31)
2 min < 0.1% 11 ms 10,149 afxprodbakusr 
SELECT JOB_EXECUTION_ID, KEY_NAME, TYPE_CD, STRING_VAL, DATE_VAL, LONG_VAL, DOUBLE_VAL, IDENTIFYING from BATCH_JOB_EXECUTION_PARAMS where JOB_EXECUTION_ID = $1
Details
CREATE INDEX CONCURRENTLY ON batch_job_execution_params (job_execution_id)
2 min < 0.1% 44 ms 2,621 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63)
2 min < 0.1% 4 ms 28,848 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)
2 min < 0.1% 42 ms 2,611 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61)
2 min < 0.1% 20 ms 5,610 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24)
2 min < 0.1% 23 ms 4,528 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31)
2 min < 0.1% 4 ms 25,732 odoo 
SELECT * FROM ir_translation
                    WHERE lang=$1 AND type=$2 AND name=$3 AND res_id IN ($4, $5, $6, $7, $8, $9, $10, $11)
2 min < 0.1% 0 ms 696,372 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% 10 ms 10,149 afxprodbakusr 
SELECT STEP_EXECUTION_ID, STEP_NAME, START_TIME, END_TIME, STATUS, COMMIT_COUNT, READ_COUNT, FILTER_COUNT, WRITE_COUNT, EXIT_CODE, EXIT_MESSAGE, READ_SKIP_COUNT, WRITE_SKIP_COUNT, PROCESS_SKIP_COUNT, ROLLBACK_COUNT, LAST_UPDATED, VERSION from BATCH_STEP_EXECUTION where JOB_EXECUTION_ID = $1 order by STEP_EXECUTION_ID
Details
CREATE INDEX CONCURRENTLY ON batch_step_execution (job_execution_id)
2 min < 0.1% 44 ms 2,265 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63)
2 min < 0.1% 1 ms 132,240 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
2 min < 0.1% 2 ms 43,408 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)
2 min < 0.1% 1 ms 71,373 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)
2 min < 0.1% 36 ms 2,670 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51)
2 min < 0.1% 4 ms 27,017 odoo 
SELECT "fx_res_partner".id FROM "fx_res_partner" WHERE ("fx_res_partner"."customer_id"::text ilike $1) ORDER BY "fx_res_partner"."id"
2 min < 0.1% 4 ms 22,908 odoo 
SELECT * FROM ir_translation
                    WHERE lang=$1 AND type=$2 AND name=$3 AND res_id IN ($4, $5, $6, $7, $8, $9, $10, $11, $12)
2 min < 0.1% 42 ms 2,260 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61)
2 min < 0.1% 20 ms 4,790 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24)
2 min < 0.1% 2 ms 56,544 odoo 
SELECT "st_exchange_calendar"."id" as "id","st_exchange_calendar"."holiday_flg" as "holiday_flg","st_exchange_calendar"."national_holiday_flg" as "national_holiday_flg","st_exchange_calendar"."write_uid" as "write_uid","st_exchange_calendar"."create_date" as "create_date","st_exchange_calendar"."write_date" as "write_date","st_exchange_calendar"."exchange_sname" as "exchange_sname","st_exchange_calendar"."close_time" as "close_time","st_exchange_calendar"."create_uid" as "create_uid","st_exchange_calendar"."company_id" as "company_id","st_exchange_calendar"."open_time" as "open_time","st_exchange_calendar"."note" as "note","st_exchange_calendar"."exchange_id" as "exchange_id","st_exchange_calendar"."front_date" as "front_date" 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% 0 ms 16,161,685 odoo 
BEGIN ISOLATION LEVEL REPEATABLE READ
1 min < 0.1% 37 ms 2,298 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51)
1 min < 0.1% 0 ms 425,856 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, company_id)
1 min < 0.1% 2 ms 48,639 odoo 
SELECT "st_exchange_calendar"."id" as "id","st_exchange_calendar"."holiday_flg" as "holiday_flg","st_exchange_calendar"."national_holiday_flg" as "national_holiday_flg","st_exchange_calendar"."write_uid" as "write_uid","st_exchange_calendar"."create_date" as "create_date","st_exchange_calendar"."exchange_sname" as "exchange_sname","st_exchange_calendar"."close_time" as "close_time","st_exchange_calendar"."create_uid" as "create_uid","st_exchange_calendar"."write_date" as "write_date","st_exchange_calendar"."company_id" as "company_id","st_exchange_calendar"."open_time" as "open_time","st_exchange_calendar"."note" as "note","st_exchange_calendar"."exchange_id" as "exchange_id","st_exchange_calendar"."front_date" as "front_date" 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 120,496 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% 4 ms 19,077 odoo 
SELECT * FROM ir_translation
                    WHERE lang=$1 AND type=$2 AND name=$3 AND res_id IN ($4, $5)
1 min < 0.1% 0 ms 169,031 pspprodbakusr 
UPDATE st_ticker_daily SET base_price = $1 , ceiling_price = $2, write_uid = $3, write_date = CURRENT_TIMESTAMP, floor_price = $4, close_price = $5, bid = $6, ask = $7, high = $8, low = $9, bid_vol = $10, ask_vol = $11, vol_per_day = $12 WHERE exchange_code = $13 AND order_exchange = $14 AND ticker_code = $15
Details
CREATE INDEX CONCURRENTLY ON st_ticker_daily (ticker_code)
1 min < 0.1% 114 ms 632 hero 
WITH query_stats AS ( SELECT LEFT(query, $1) AS query, queryid AS query_hash, rolname AS user, (total_time / $2 / $3) AS total_minutes, (total_time / calls) AS average_time, calls FROM pg_stat_statements INNER JOIN pg_database ON pg_database.oid = pg_stat_statements.dbid INNER JOIN pg_roles ON pg_roles.oid = pg_stat_statements.userid WHERE calls > $4 AND pg_database.datname = current_database() ) SELECT query, query_hash, query_stats.user, total_minutes, average_time, calls, total_minutes * $5 / (SELECT SUM(total_minutes) FROM query_stats) AS total_percent, (SELECT SUM(total_minutes) FROM query_stats) AS all_queries_total_minutes FROM query_stats ORDER BY "total_minutes" DESC LIMIT $6 /*pghero*/
1 min < 0.1% 0 ms 824,628 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% 7 ms 10,149 afxprodbakusr 
SELECT JOB_EXECUTION_ID, START_TIME, END_TIME, STATUS, EXIT_CODE, EXIT_MESSAGE, CREATE_TIME, LAST_UPDATED, VERSION, JOB_CONFIGURATION_LOCATION from BATCH_JOB_EXECUTION where JOB_INSTANCE_ID = $1 order by JOB_EXECUTION_ID desc
Details
CREATE INDEX CONCURRENTLY ON batch_job_execution (job_instance_id)
1 min < 0.1% 0 ms 4,848,545 odoo 
SELECT base_registry_signaling.last_value,
                                  base_cache_signaling.last_value
                           FROM base_registry_signaling, base_cache_signaling
1 min < 0.1% 94 ms 674 hero 
SELECT schemaname AS schema, t.relname AS table, ix.relname AS name, regexp_replace(pg_get_indexdef(i.indexrelid), $1, $2) AS columns, regexp_replace(pg_get_indexdef(i.indexrelid), $3, $4) AS using, indisunique AS unique, indisprimary AS primary, indisvalid AS valid, indexprs::text, indpred::text, pg_get_indexdef(i.indexrelid) AS definition FROM pg_index i INNER JOIN pg_class t ON t.oid = i.indrelid INNER JOIN pg_class ix ON ix.oid = i.indexrelid LEFT JOIN pg_stat_user_indexes ui ON ui.indexrelid = i.indexrelid WHERE schemaname IS NOT NULL ORDER BY 1, 2 /*pghero*/
1 min < 0.1% 0 ms 341,702 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% 4 ms 15,538 odoo 
SELECT * FROM ir_translation
                    WHERE lang=$1 AND type=$2 AND name=$3 AND res_id IN ($4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46)
1 min < 0.1% 57 ms 1,003 pspprodbakusr 
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
1 min < 0.1% 20 ms 2,624 odoo 
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25)
1 min < 0.1% 0 ms 122,528 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
1 min < 0.1% 0 ms 1,121,267 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% 16 ms 3,057 odoo 
SELECT "fx_swap_history".id FROM "fx_swap_history" WHERE (("fx_swap_history"."group_id" = $1)  AND  ("fx_swap_history"."effect_date" >= $2)) AND ("fx_swap_history"."company_id" in ($3)) ORDER BY "fx_swap_history"."effect_date" DESC,"fx_swap_history"."symbol_id" ASC  limit $4
Details
CREATE INDEX CONCURRENTLY ON fx_swap_history (group_id, effect_date)