Open mrm-david opened 7 months ago
Another plan that can't be parsed by the plugin. But it can be parsed on explain.dalibo.com so the problem lies probably in the plugin
[
{
"Plan": {
"Node Type": "Append",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 3919.56,
"Total Cost": 46005.38,
"Plan Rows": 84,
"Plan Width": 164,
"Actual Startup Time": 842.705,
"Actual Total Time": 989.428,
"Actual Rows": 1387,
"Actual Loops": 1,
"Shared Hit Blocks": 103113,
"Shared Read Blocks": 596,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 16,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Subplans Removed": 0,
"Plans": [
{
"Node Type": "WindowAgg",
"Parent Relationship": "InitPlan",
"Subplan Name": "CTE contacts",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 18415.13,
"Total Cost": 21186.76,
"Plan Rows": 20689,
"Plan Width": 30,
"Actual Startup Time": 29.804,
"Actual Total Time": 41.146,
"Actual Rows": 19452,
"Actual Loops": 1,
"Output": ["client.id", "contact.name", "row_number() OVER (?)"],
"Shared Hit Blocks": 61351,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Gather Merge",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 18415.13,
"Total Cost": 20824.70,
"Plan Rows": 20689,
"Plan Width": 22,
"Actual Startup Time": 29.791,
"Actual Total Time": 32.850,
"Actual Rows": 19452,
"Actual Loops": 1,
"Output": ["client.id", "contact.name"],
"Workers Planned": 2,
"Workers Launched": 2,
"Shared Hit Blocks": 61351,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 17415.10,
"Total Cost": 17436.65,
"Plan Rows": 8620,
"Plan Width": 22,
"Actual Startup Time": 23.884,
"Actual Total Time": 24.210,
"Actual Rows": 6484,
"Actual Loops": 3,
"Output": ["client.id", "contact.name"],
"Sort Key": ["client.id", "contact.name"],
"Sort Method": "quicksort",
"Sort Space Used": 938,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 61351,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Workers": [
{
"Worker Number": 0,
"Actual Startup Time": 21.609,
"Actual Total Time": 21.857,
"Actual Rows": 5374,
"Actual Loops": 1,
"Sort Method": "quicksort",
"Sort Space Used": 527,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 16438,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Worker Number": 1,
"Actual Startup Time": 21.482,
"Actual Total Time": 21.709,
"Actual Rows": 5247,
"Actual Loops": 1,
"Sort Method": "quicksort",
"Sort Space Used": 519,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 15789,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
],
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 0.29,
"Total Cost": 16851.64,
"Plan Rows": 8620,
"Plan Width": 22,
"Actual Startup Time": 0.041,
"Actual Total Time": 21.820,
"Actual Rows": 6484,
"Actual Loops": 3,
"Output": ["client.id", "contact.name"],
"Inner Unique": true,
"Shared Hit Blocks": 61321,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Workers": [
{
"Worker Number": 0,
"Actual Startup Time": 0.041,
"Actual Total Time": 19.869,
"Actual Rows": 5374,
"Actual Loops": 1,
"Shared Hit Blocks": 16423,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Worker Number": 1,
"Actual Startup Time": 0.053,
"Actual Total Time": 19.561,
"Actual Rows": 5247,
"Actual Loops": 1,
"Shared Hit Blocks": 15774,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
],
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": true,
"Async Capable": false,
"Relation Name": "res_partner",
"Schema": "public",
"Alias": "contact",
"Startup Cost": 0.00,
"Total Cost": 10826.15,
"Plan Rows": 8620,
"Plan Width": 22,
"Actual Startup Time": 0.009,
"Actual Total Time": 10.881,
"Actual Rows": 6917,
"Actual Loops": 3,
"Output": ["contact.name", "contact.parent_id"],
"Filter": "((contact.type)::text = 'contact'::text)",
"Rows Removed by Filter": 9861,
"Shared Hit Blocks": 10564,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Workers": [
{
"Worker Number": 0,
"Actual Startup Time": 0.007,
"Actual Total Time": 10.486,
"Actual Rows": 5732,
"Actual Loops": 1,
"Shared Hit Blocks": 2581,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Worker Number": 1,
"Actual Startup Time": 0.011,
"Actual Total Time": 10.316,
"Actual Rows": 5716,
"Actual Loops": 1,
"Shared Hit Blocks": 2775,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Index Only Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Scan Direction": "Forward",
"Index Name": "res_partner_pkey",
"Relation Name": "res_partner",
"Schema": "public",
"Alias": "client",
"Startup Cost": 0.29,
"Total Cost": 0.70,
"Plan Rows": 1,
"Plan Width": 4,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.001,
"Actual Rows": 1,
"Actual Loops": 20750,
"Output": ["client.id"],
"Index Cond": "(client.id = contact.parent_id)",
"Rows Removed by Index Recheck": 0,
"Heap Fetches": 12078,
"Shared Hit Blocks": 50757,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Workers": [
{
"Worker Number": 0,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.001,
"Actual Rows": 1,
"Actual Loops": 5732,
"Shared Hit Blocks": 13842,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Worker Number": 1,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.001,
"Actual Rows": 1,
"Actual Loops": 5716,
"Shared Hit Blocks": 12999,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
}
]
}
]
},
{
"Node Type": "Values Scan",
"Parent Relationship": "InitPlan",
"Subplan Name": "CTE map_states",
"Parallel Aware": false,
"Async Capable": false,
"Alias": "*VALUES*",
"Startup Cost": 0.00,
"Total Cost": 0.65,
"Plan Rows": 52,
"Plan Width": 96,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.023,
"Actual Rows": 52,
"Actual Loops": 1,
"Output": ["\"*VALUES*\".column1", "\"*VALUES*\".column2", "\"*VALUES*\".column3"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash Join",
"Parent Relationship": "InitPlan",
"Subplan Name": "CTE tags",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 3.17,
"Total Cost": 78.48,
"Plan Rows": 284,
"Plan Width": 46,
"Actual Startup Time": 0.037,
"Actual Total Time": 0.311,
"Actual Rows": 4,
"Actual Loops": 1,
"Output": ["p.partner_id", "c.code", "(c.short_name ->> 'en_US'::text)"],
"Inner Unique": true,
"Hash Cond": "(p.category_id = c.id)",
"Shared Hit Blocks": 73,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "res_partner_res_partner_category_rel",
"Schema": "public",
"Alias": "p",
"Startup Cost": 0.00,
"Total Cost": 73.84,
"Plan Rows": 284,
"Plan Width": 8,
"Actual Startup Time": 0.008,
"Actual Total Time": 0.278,
"Actual Rows": 4,
"Actual Loops": 1,
"Output": ["p.category_id", "p.partner_id"],
"Shared Hit Blocks": 71,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 2.52,
"Total Cost": 2.52,
"Plan Rows": 52,
"Plan Width": 44,
"Actual Startup Time": 0.024,
"Actual Total Time": 0.025,
"Actual Rows": 52,
"Actual Loops": 1,
"Output": ["c.code", "c.short_name", "c.id"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 12,
"Shared Hit Blocks": 2,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "res_partner_category",
"Schema": "public",
"Alias": "c",
"Startup Cost": 0.00,
"Total Cost": 2.52,
"Plan Rows": 52,
"Plan Width": 44,
"Actual Startup Time": 0.005,
"Actual Total Time": 0.015,
"Actual Rows": 52,
"Actual Loops": 1,
"Output": ["c.code", "c.short_name", "c.id"],
"Shared Hit Blocks": 2,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Aggregate",
"Strategy": "Sorted",
"Partial Mode": "Simple",
"Parent Relationship": "InitPlan",
"Subplan Name": "CTE pays_groups",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 10.86,
"Total Cost": 14.50,
"Plan Rows": 111,
"Plan Width": 36,
"Actual Startup Time": 0.131,
"Actual Total Time": 0.339,
"Actual Rows": 111,
"Actual Loops": 1,
"Output": ["r.res_country_id", "COALESCE((('|'::text || string_agg((g.name ->> 'en_US'::text), '|'::text ORDER BY (g.name ->> 'en_US'::text))) || '|'::text), ''::text)"],
"Group Key": ["r.res_country_id"],
"Shared Hit Blocks": 2,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 10.86,
"Total Cost": 11.28,
"Plan Rows": 170,
"Plan Width": 36,
"Actual Startup Time": 0.109,
"Actual Total Time": 0.120,
"Actual Rows": 170,
"Actual Loops": 1,
"Output": ["r.res_country_id", "g.name"],
"Sort Key": ["r.res_country_id"],
"Sort Method": "quicksort",
"Sort Space Used": 48,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 2,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 1.20,
"Total Cost": 4.56,
"Plan Rows": 170,
"Plan Width": 36,
"Actual Startup Time": 0.029,
"Actual Total Time": 0.066,
"Actual Rows": 170,
"Actual Loops": 1,
"Output": ["r.res_country_id", "g.name"],
"Inner Unique": true,
"Hash Cond": "(r.res_country_group_id = g.id)",
"Shared Hit Blocks": 2,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "res_country_res_country_group_rel",
"Schema": "public",
"Alias": "r",
"Startup Cost": 0.00,
"Total Cost": 2.70,
"Plan Rows": 170,
"Plan Width": 8,
"Actual Startup Time": 0.006,
"Actual Total Time": 0.014,
"Actual Rows": 170,
"Actual Loops": 1,
"Output": ["r.res_country_id", "r.res_country_group_id"],
"Shared Hit Blocks": 1,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 1.09,
"Total Cost": 1.09,
"Plan Rows": 9,
"Plan Width": 36,
"Actual Startup Time": 0.010,
"Actual Total Time": 0.010,
"Actual Rows": 9,
"Actual Loops": 1,
"Output": ["g.name", "g.id"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 10,
"Shared Hit Blocks": 1,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "res_country_group",
"Schema": "public",
"Alias": "g",
"Startup Cost": 0.00,
"Total Cost": 1.09,
"Plan Rows": 9,
"Plan Width": 36,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.005,
"Actual Rows": 9,
"Actual Loops": 1,
"Output": ["g.name", "g.id"],
"Shared Hit Blocks": 1,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
}
]
},
{
"Node Type": "Hash Join",
"Parent Relationship": "InitPlan",
"Subplan Name": "CTE o_cli",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 11847.94,
"Total Cost": 22961.83,
"Plan Rows": 3783,
"Plan Width": 634,
"Actual Startup Time": 90.552,
"Actual Total Time": 287.022,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["split_part((cli.ref)::text, '/'::text, 1)", "CASE WHEN ((cli.ref)::text ~ '/\\d+'::text) THEN (split_part((cli.ref)::text, '/'::text, 2))::integer ELSE 0 END", "(((('M,ADR,S#1='::text || quote_nullable(split_part((cli.ref)::text, '/'::text, 1))) || ',S#2='::text) || split_part((cli.ref)::text, '/'::text, 2)) || ','::text)", "cli.name", "(((cli.create_date AT TIME ZONE 'UTC'::text) AT TIME ZONE 'Europe/Paris'::text))::date", "cli.street", "cli.street2", "cli.zip", "cli.city", "(COALESCE(\"*VALUES*_1\".column2, (rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text)))", "cli.phone", "cli.mrm_fax", "(cli.mrm_default_delivery_address = cli.mrm_group_id)", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_payment_handling", "tts.code", "tcat.code", "tacc.code", "tseg.short_name", "CASE WHEN (cli.mrm_default_is_line_weighing IS TRUE) THEN 'O'::text ELSE 'N'::text END", "CASE WHEN (((COALESCE(ca.code, c_1.code, ''::character varying)))::text = 'FR'::text) THEN (\"left\"((cli.zip)::text, 2))::character varying WHEN ((COALESCE(msa.zone_admin, ms.zone_admin, ''::text)) > ''::text) THEN ((COALESCE(msa.zone_admin, ms.zone_admin, ''::text)))::character varying ELSE (COALESCE(ca.code, c_1.code, ''::character varying)) END", "COALESCE((COALESCE(sa.code, s.code, ''::character varying)), ''::character varying)", "cli.siret", "CASE WHEN (cli.mrm_has_shipping_mon AND cli.mrm_has_shipping_wed) THEN 'Lun + Mer'::text WHEN (cli.mrm_has_shipping_mon AND cli.mrm_has_shipping_thu) THEN 'Lun + Jeu'::text WHEN (cli.mrm_has_shipping_tue AND cli.mrm_has_shipping_thu) THEN 'Mar + Jeu'::text WHEN (cli.mrm_has_shipping_tue AND cli.mrm_has_shipping_fri) THEN 'Mar + Ven'::text WHEN (cli.mrm_has_shipping_wed AND cli.mrm_has_shipping_fri) THEN 'Mer + Ven'::text WHEN cli.mrm_has_shipping_mon THEN 'Lundi'::text WHEN cli.mrm_has_shipping_tue THEN 'Mardi'::text WHEN cli.mrm_has_shipping_wed THEN 'Mercredi'::text WHEN cli.mrm_has_shipping_thu THEN 'Jeudi'::text WHEN cli.mrm_has_shipping_fri THEN 'Vendredi'::text ELSE 'Sans'::text END", "CASE WHEN ((((COALESCE(ca.code, c_1.code, ''::character varying)))::text = 'FR'::text) AND (\"left\"(((COALESCE(rpa.zip, rp.zip, ''::character varying)))::text, 2) >= '01'::text) AND (\"left\"(((COALESCE(rpa.zip, rp.zip, ''::character varying)))::text, 2) <= '95'::text)) THEN 'N'::text WHEN (((COALESCE(ca.code, c_1.code, ''::character varying)))::text = 'MC'::text) THEN 'N'::text WHEN ((COALESCE(pga.groups, pg.groups, ''::text)) ~~ '%|DOM-TOM|%'::text) THEN 'D'::text WHEN ((COALESCE(pga.groups, pg.groups, ''::text)) ~~ '%|DROM|%'::text) THEN 'D'::text WHEN (((COALESCE(pga.groups, pg.groups, ''::text)) ~~ '%|Europe|%'::text) AND (concat((COALESCE(ca.code, c_1.code, ''::character varying)), '-', (COALESCE(sa.code, s.code, ''::character varying))) <> 'PM'::text)) THEN 'I'::text ELSE 'E'::text END", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "CASE COALESCE(cur.name, ''::character varying) WHEN 'EUR'::text THEN 'Euro'::text WHEN 'USD'::text THEN 'Dollar'::text ELSE NULL::text END", "CASE WHEN ((((COALESCE(ca.code, c_1.code, ''::character varying)))::text = 'FR'::text) AND (\"left\"(((COALESCE(rpa.zip, rp.zip, ''::character varying)))::text, 2) >= '01'::text) AND (\"left\"(((COALESCE(rpa.zip, rp.zip, ''::character varying)))::text, 2) <= '95'::text)) THEN 0 WHEN (((COALESCE(ca.code, c_1.code, ''::character varying)))::text = 'MC'::text) THEN 0 WHEN (((cli.ref)::text >= '48800'::text) AND ((cli.ref)::text <= '48999'::text)) THEN 0 WHEN ((COALESCE(pga.groups, pg.groups, ''::text)) ~~ '%|DROM|%'::text) THEN 3 WHEN ((COALESCE(pga.groups, pg.groups, ''::text)) ~~ '%|Europe|%'::text) THEN 1 ELSE 2 END", "tc.contrats"],
"Inner Unique": true,
"Hash Cond": "(cli.id = tc.partner_id)",
"Shared Hit Blocks": 59890,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 11840.74,
"Total Cost": 22547.49,
"Plan Rows": 3783,
"Plan Width": 525,
"Actual Startup Time": 90.487,
"Actual Total Time": 278.630,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "tts.code", "tcat.code", "tacc.code", "tseg.short_name", "cur.name", "(COALESCE(\"*VALUES*_1\".column2, (rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text)))", "(COALESCE(ca.code, c_1.code, ''::character varying))", "(COALESCE(msa.zone_admin, ms.zone_admin, ''::text))", "(COALESCE(sa.code, s.code, ''::character varying))", "(COALESCE(rpa.zip, rp.zip, ''::character varying))", "(COALESCE(pga.groups, pg.groups, ''::text))"],
"Inner Unique": true,
"Hash Cond": "(cli.mrm_sale_currency_id = cur.id)",
"Shared Hit Blocks": 59890,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 11833.94,
"Total Cost": 22530.51,
"Plan Rows": 3783,
"Plan Width": 525,
"Actual Startup Time": 90.424,
"Actual Total Time": 277.633,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "cli.mrm_sale_currency_id", "tts.code", "tcat.code", "tacc.code", "tseg.short_name", "(COALESCE(\"*VALUES*_1\".column2, (rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text)))", "(COALESCE(ca.code, c_1.code, ''::character varying))", "(COALESCE(msa.zone_admin, ms.zone_admin, ''::text))", "(COALESCE(sa.code, s.code, ''::character varying))", "(COALESCE(rpa.zip, rp.zip, ''::character varying))", "(COALESCE(pga.groups, pg.groups, ''::text))"],
"Inner Unique": false,
"Hash Cond": "(cli.id = tens.partner_id)",
"Shared Hit Blocks": 59887,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 11827.54,
"Total Cost": 22509.91,
"Plan Rows": 3783,
"Plan Width": 525,
"Actual Startup Time": 90.412,
"Actual Total Time": 276.807,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "cli.mrm_sale_currency_id", "tts.code", "tcat.code", "tacc.code", "tseg.short_name", "(COALESCE(\"*VALUES*_1\".column2, (rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text)))", "(COALESCE(ca.code, c_1.code, ''::character varying))", "(COALESCE(msa.zone_admin, ms.zone_admin, ''::text))", "(COALESCE(sa.code, s.code, ''::character varying))", "(COALESCE(rpa.zip, rp.zip, ''::character varying))", "(COALESCE(pga.groups, pg.groups, ''::text))"],
"Inner Unique": false,
"Hash Cond": "(cli.id = temp.partner_id)",
"Shared Hit Blocks": 59887,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 11821.14,
"Total Cost": 22489.31,
"Plan Rows": 3783,
"Plan Width": 525,
"Actual Startup Time": 90.403,
"Actual Total Time": 276.001,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "cli.mrm_sale_currency_id", "tts.code", "tcat.code", "tacc.code", "tseg.short_name", "(COALESCE(\"*VALUES*_1\".column2, (rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text)))", "(COALESCE(ca.code, c_1.code, ''::character varying))", "(COALESCE(msa.zone_admin, ms.zone_admin, ''::text))", "(COALESCE(sa.code, s.code, ''::character varying))", "(COALESCE(rpa.zip, rp.zip, ''::character varying))", "(COALESCE(pga.groups, pg.groups, ''::text))"],
"Inner Unique": false,
"Hash Cond": "(cli.id = tseg.partner_id)",
"Shared Hit Blocks": 59887,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 11814.73,
"Total Cost": 22468.71,
"Plan Rows": 3783,
"Plan Width": 493,
"Actual Startup Time": 90.385,
"Actual Total Time": 275.175,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "cli.mrm_sale_currency_id", "tts.code", "tcat.code", "tacc.code", "(COALESCE(\"*VALUES*_1\".column2, (rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text)))", "(COALESCE(ca.code, c_1.code, ''::character varying))", "(COALESCE(msa.zone_admin, ms.zone_admin, ''::text))", "(COALESCE(sa.code, s.code, ''::character varying))", "(COALESCE(rpa.zip, rp.zip, ''::character varying))", "(COALESCE(pga.groups, pg.groups, ''::text))"],
"Inner Unique": false,
"Shared Hit Blocks": 59887,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 11803.05,
"Total Cost": 12408.43,
"Plan Rows": 3783,
"Plan Width": 333,
"Actual Startup Time": 89.831,
"Actual Total Time": 94.649,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "cli.mrm_sale_currency_id", "tts.code", "tcat.code", "tacc.code", "(COALESCE(\"*VALUES*_1\".column2, (rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text)))"],
"Inner Unique": false,
"Hash Cond": "(cli.id = tacc.partner_id)",
"Shared Hit Blocks": 39771,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 11796.64,
"Total Cost": 12387.83,
"Plan Rows": 3783,
"Plan Width": 301,
"Actual Startup Time": 89.826,
"Actual Total Time": 93.989,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "cli.mrm_sale_currency_id", "tts.code", "tcat.code", "(COALESCE(\"*VALUES*_1\".column2, (rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text)))"],
"Inner Unique": false,
"Hash Cond": "(cli.id = tcat.partner_id)",
"Shared Hit Blocks": 39771,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 11790.24,
"Total Cost": 12367.23,
"Plan Rows": 3783,
"Plan Width": 269,
"Actual Startup Time": 89.820,
"Actual Total Time": 93.320,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "cli.mrm_sale_currency_id", "tts.code", "(COALESCE(\"*VALUES*_1\".column2, (rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text)))"],
"Inner Unique": false,
"Hash Cond": "(cli.id = tts.partner_id)",
"Shared Hit Blocks": 39771,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 11783.84,
"Total Cost": 12346.64,
"Plan Rows": 3783,
"Plan Width": 237,
"Actual Startup Time": 89.501,
"Actual Total Time": 92.324,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "cli.mrm_sale_currency_id", "(COALESCE(\"*VALUES*_1\".column2, (rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text)))"],
"Inner Unique": false,
"Hash Cond": "(cli.country_id = rc.id)",
"Shared Hit Blocks": 39698,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Right",
"Startup Cost": 11764.07,
"Total Cost": 12274.87,
"Plan Rows": 3783,
"Plan Width": 209,
"Actual Startup Time": 89.292,
"Actual Total Time": 91.252,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "cli.country_id", "cli.mrm_sale_currency_id"],
"Inner Unique": false,
"Hash Cond": "(ctc2.id = cli.id)",
"Join Filter": "(ctc1.rprank = 2)",
"Rows Removed by Join Filter": 2812,
"Shared Hit Blocks": 39687,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "contacts",
"Alias": "ctc2",
"Startup Cost": 0.00,
"Total Cost": 413.78,
"Plan Rows": 20689,
"Plan Width": 4,
"Actual Startup Time": 0.004,
"Actual Total Time": 1.328,
"Actual Rows": 19452,
"Actual Loops": 1,
"Output": ["ctc2.id", "ctc2.name", "ctc2.rprank"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 11716.78,
"Total Cost": 11716.78,
"Plan Rows": 3783,
"Plan Width": 217,
"Actual Startup Time": 84.883,
"Actual Total Time": 84.891,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "cli.country_id", "cli.mrm_sale_currency_id", "ctc1.rprank"],
"Hash Buckets": 4096,
"Original Hash Buckets": 4096,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 715,
"Shared Hit Blocks": 39687,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 466.79,
"Total Cost": 11716.78,
"Plan Rows": 3783,
"Plan Width": 217,
"Actual Startup Time": 55.534,
"Actual Total Time": 82.851,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "cli.country_id", "cli.mrm_sale_currency_id", "ctc1.rprank"],
"Inner Unique": false,
"Hash Cond": "(cli.id = ctc1.id)",
"Shared Hit Blocks": 39687,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "res_partner",
"Schema": "public",
"Alias": "cli",
"Startup Cost": 0.00,
"Total Cost": 11193.16,
"Plan Rows": 3783,
"Plan Width": 209,
"Actual Startup Time": 5.968,
"Actual Total Time": 31.843,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["cli.ref", "cli.name", "cli.create_date", "cli.street", "cli.street2", "cli.zip", "cli.city", "cli.phone", "cli.mrm_fax", "cli.mrm_default_delivery_address", "cli.mrm_group_id", "cli.mrm_group_membership", "cli.mrm_payment_handling", "cli.mrm_default_is_line_weighing", "cli.siret", "cli.mrm_has_shipping_mon", "cli.mrm_has_shipping_wed", "cli.mrm_has_shipping_thu", "cli.mrm_has_shipping_tue", "cli.mrm_has_shipping_fri", "cli.mrm_pro_password", "cli.mrm_has_free_permanent_shipping", "cli.mrm_force_transfo", "cli.mrm_invoice_template", "cli.mrm_nb_invoice_copy", "cli.mrm_label_code", "cli.mrm_use_customer_ref", "cli.mrm_fixed_shipping_price", "cli.mrm_product_case_mode", "cli.mrm_delivery_franco", "cli.vat", "cli.id", "cli.country_id", "cli.mrm_sale_currency_id"],
"Filter": "((cli.ref)::text ~ '^\\d{5}/\\d+$'::text)",
"Rows Removed by Filter": 46784,
"Shared Hit Blocks": 10563,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 465.50,
"Total Cost": 465.50,
"Plan Rows": 103,
"Plan Width": 12,
"Actual Startup Time": 49.547,
"Actual Total Time": 49.547,
"Actual Rows": 17497,
"Actual Loops": 1,
"Output": ["ctc1.id", "ctc1.rprank"],
"Hash Buckets": 32768,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 1077,
"Shared Hit Blocks": 29124,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "contacts",
"Alias": "ctc1",
"Startup Cost": 0.00,
"Total Cost": 465.50,
"Plan Rows": 103,
"Plan Width": 12,
"Actual Startup Time": 29.811,
"Actual Total Time": 46.715,
"Actual Rows": 17497,
"Actual Loops": 1,
"Output": ["ctc1.id", "ctc1.rprank"],
"Filter": "(ctc1.rprank = 1)",
"Rows Removed by Filter": 1955,
"Shared Hit Blocks": 29124,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 16.65,
"Total Cost": 16.65,
"Plan Rows": 250,
"Plan Width": 36,
"Actual Startup Time": 0.200,
"Actual Total Time": 0.201,
"Actual Rows": 250,
"Actual Loops": 1,
"Output": ["rc.id", "(COALESCE(\"*VALUES*_1\".column2, (rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text)))"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 20,
"Shared Hit Blocks": 11,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 0.23,
"Total Cost": 16.65,
"Plan Rows": 250,
"Plan Width": 36,
"Actual Startup Time": 0.031,
"Actual Total Time": 0.168,
"Actual Rows": 250,
"Actual Loops": 1,
"Output": ["rc.id", "COALESCE(\"*VALUES*_1\".column2, (rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text))"],
"Inner Unique": false,
"Hash Cond": "(COALESCE((rc.name ->> 'fr_FR'::text), (rc.name ->> 'en_US'::text)) = \"*VALUES*_1\".column1)",
"Shared Hit Blocks": 11,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "res_country",
"Schema": "public",
"Alias": "rc",
"Startup Cost": 0.00,
"Total Cost": 13.50,
"Plan Rows": 250,
"Plan Width": 149,
"Actual Startup Time": 0.007,
"Actual Total Time": 0.047,
"Actual Rows": 250,
"Actual Loops": 1,
"Output": ["rc.id", "rc.address_view_id", "rc.currency_id", "rc.phone_code", "rc.create_uid", "rc.write_uid", "rc.code", "rc.name_position", "rc.name", "rc.vat_label", "rc.address_format", "rc.state_required", "rc.zip_required", "rc.create_date", "rc.write_date"],
"Shared Hit Blocks": 11,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 0.11,
"Total Cost": 0.11,
"Plan Rows": 9,
"Plan Width": 64,
"Actual Startup Time": 0.017,
"Actual Total Time": 0.017,
"Actual Rows": 9,
"Actual Loops": 1,
"Output": ["\"*VALUES*_1\".column1", "\"*VALUES*_1\".column2"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 9,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Values Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Alias": "*VALUES*_1",
"Startup Cost": 0.00,
"Total Cost": 0.11,
"Plan Rows": 9,
"Plan Width": 64,
"Actual Startup Time": 0.011,
"Actual Total Time": 0.013,
"Actual Rows": 9,
"Actual Loops": 1,
"Output": ["\"*VALUES*_1\".column1", "\"*VALUES*_1\".column2"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 6.39,
"Total Cost": 6.39,
"Plan Rows": 1,
"Plan Width": 36,
"Actual Startup Time": 0.314,
"Actual Total Time": 0.314,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["tts.code", "tts.partner_id"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 8,
"Shared Hit Blocks": 73,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "tags",
"Alias": "tts",
"Startup Cost": 0.00,
"Total Cost": 6.39,
"Plan Rows": 1,
"Plan Width": 36,
"Actual Startup Time": 0.314,
"Actual Total Time": 0.314,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["tts.code", "tts.partner_id"],
"Filter": "((tts.code)::text ~~ 'sat_%'::text)",
"Rows Removed by Filter": 4,
"Shared Hit Blocks": 73,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 6.39,
"Total Cost": 6.39,
"Plan Rows": 1,
"Plan Width": 36,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.003,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["tcat.code", "tcat.partner_id"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 8,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "tags",
"Alias": "tcat",
"Startup Cost": 0.00,
"Total Cost": 6.39,
"Plan Rows": 1,
"Plan Width": 36,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.002,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["tcat.code", "tcat.partner_id"],
"Filter": "((tcat.code)::text ~~ 'cat_%'::text)",
"Rows Removed by Filter": 4,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 6.39,
"Total Cost": 6.39,
"Plan Rows": 1,
"Plan Width": 36,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.002,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["tacc.code", "tacc.partner_id"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 8,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "tags",
"Alias": "tacc",
"Startup Cost": 0.00,
"Total Cost": 6.39,
"Plan Rows": 1,
"Plan Width": 36,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.001,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["tacc.code", "tacc.partner_id"],
"Filter": "((tacc.code)::text ~~ 'acc_%'::text)",
"Rows Removed by Filter": 4,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Hash Join",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Right",
"Startup Cost": 11.69,
"Total Cost": 14.33,
"Plan Rows": 1,
"Plan Width": 164,
"Actual Startup Time": 0.050,
"Actual Total Time": 0.050,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["rp.id", "(COALESCE(ca.code, c_1.code, ''::character varying))", "(COALESCE(msa.zone_admin, ms.zone_admin, ''::text))", "(COALESCE(sa.code, s.code, ''::character varying))", "(COALESCE(rpa.zip, rp.zip, ''::character varying))", "COALESCE(pga.groups, pg.groups, ''::text)"],
"Inner Unique": false,
"Hash Cond": "(pga.id = ca.id)",
"Shared Hit Blocks": 20116,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "pays_groups",
"Alias": "pga",
"Startup Cost": 0.00,
"Total Cost": 2.22,
"Plan Rows": 111,
"Plan Width": 36,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.005,
"Actual Rows": 111,
"Actual Loops": 3549,
"Output": ["pga.id", "pga.groups"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 11.68,
"Total Cost": 11.68,
"Plan Rows": 1,
"Plan Width": 168,
"Actual Startup Time": 0.038,
"Actual Total Time": 0.038,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["rp.id", "pg.groups", "ca.id", "(COALESCE(ca.code, c_1.code, ''::character varying))", "(COALESCE(msa.zone_admin, ms.zone_admin, ''::text))", "(COALESCE(sa.code, s.code, ''::character varying))", "(COALESCE(rpa.zip, rp.zip, ''::character varying))"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 9,
"Shared Hit Blocks": 20116,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Right",
"Startup Cost": 10.24,
"Total Cost": 11.68,
"Plan Rows": 1,
"Plan Width": 168,
"Actual Startup Time": 0.037,
"Actual Total Time": 0.038,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["rp.id", "pg.groups", "ca.id", "(COALESCE(ca.code, c_1.code, ''::character varying))", "COALESCE(msa.zone_admin, ms.zone_admin, ''::text)", "(COALESCE(sa.code, s.code, ''::character varying))", "(COALESCE(rpa.zip, rp.zip, ''::character varying))"],
"Inner Unique": false,
"Hash Cond": "((msa.iso = (ca.code)::text) AND (msa.state = (sa.code)::text))",
"Shared Hit Blocks": 20116,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "map_states",
"Alias": "msa",
"Startup Cost": 0.00,
"Total Cost": 1.04,
"Plan Rows": 52,
"Plan Width": 96,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.002,
"Actual Rows": 52,
"Actual Loops": 3549,
"Output": ["msa.zone_admin", "msa.iso", "msa.state"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 10.22,
"Total Cost": 10.22,
"Plan Rows": 1,
"Plan Width": 174,
"Actual Startup Time": 0.029,
"Actual Total Time": 0.029,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["rp.id", "ms.zone_admin", "pg.groups", "ca.id", "ca.code", "sa.code", "(COALESCE(ca.code, c_1.code, ''::character varying))", "(COALESCE(sa.code, s.code, ''::character varying))", "(COALESCE(rpa.zip, rp.zip, ''::character varying))"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 9,
"Shared Hit Blocks": 20116,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 7.85,
"Total Cost": 10.22,
"Plan Rows": 1,
"Plan Width": 174,
"Actual Startup Time": 0.028,
"Actual Total Time": 0.029,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["rp.id", "ms.zone_admin", "pg.groups", "ca.id", "ca.code", "sa.code", "(COALESCE(ca.code, c_1.code, ''::character varying))", "COALESCE(sa.code, s.code, ''::character varying)", "(COALESCE(rpa.zip, rp.zip, ''::character varying))"],
"Inner Unique": true,
"Shared Hit Blocks": 20116,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 7.58,
"Total Cost": 9.92,
"Plan Rows": 1,
"Plan Width": 146,
"Actual Startup Time": 0.028,
"Actual Total Time": 0.028,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["rp.id", "s.code", "ms.zone_admin", "pg.groups", "rpa.state_id", "ca.id", "ca.code", "COALESCE(ca.code, c_1.code, ''::character varying)", "(COALESCE(rpa.zip, rp.zip, ''::character varying))"],
"Inner Unique": true,
"Shared Hit Blocks": 20116,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 7.43,
"Total Cost": 9.76,
"Plan Rows": 1,
"Plan Width": 114,
"Actual Startup Time": 0.028,
"Actual Total Time": 0.028,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["rp.id", "c_1.code", "s.code", "ms.zone_admin", "pg.groups", "rpa.country_id", "rpa.state_id", "COALESCE(rpa.zip, rp.zip, ''::character varying)"],
"Inner Unique": true,
"Shared Hit Blocks": 20116,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Right",
"Startup Cost": 7.14,
"Total Cost": 8.58,
"Plan Rows": 1,
"Plan Width": 83,
"Actual Startup Time": 0.027,
"Actual Total Time": 0.027,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["rp.mrm_default_delivery_address", "rp.id", "rp.zip", "c_1.code", "s.code", "ms.zone_admin", "pg.groups"],
"Inner Unique": false,
"Hash Cond": "((ms.iso = (c_1.code)::text) AND (ms.state = (s.code)::text))",
"Shared Hit Blocks": 20116,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "map_states",
"Alias": "ms",
"Startup Cost": 0.00,
"Total Cost": 1.04,
"Plan Rows": 52,
"Plan Width": 96,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.002,
"Actual Rows": 52,
"Actual Loops": 3549,
"Output": ["ms.zone_admin", "ms.iso", "ms.state"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 7.13,
"Total Cost": 7.13,
"Plan Rows": 1,
"Plan Width": 51,
"Actual Startup Time": 0.019,
"Actual Total Time": 0.019,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["rp.mrm_default_delivery_address", "rp.id", "rp.zip", "c_1.code", "s.code", "pg.groups"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 9,
"Shared Hit Blocks": 20116,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 0.74,
"Total Cost": 7.13,
"Plan Rows": 1,
"Plan Width": 51,
"Actual Startup Time": 0.010,
"Actual Total Time": 0.019,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["rp.mrm_default_delivery_address", "rp.id", "rp.zip", "c_1.code", "s.code", "pg.groups"],
"Inner Unique": true,
"Shared Hit Blocks": 20116,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Left",
"Startup Cost": 0.47,
"Total Cost": 6.83,
"Plan Rows": 1,
"Plan Width": 52,
"Actual Startup Time": 0.009,
"Actual Total Time": 0.018,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["rp.state_id", "rp.mrm_default_delivery_address", "rp.id", "rp.zip", "c_1.code", "pg.groups"],
"Inner Unique": false,
"Shared Hit Blocks": 20116,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Scan Direction": "Forward",
"Index Name": "res_partner_pkey",
"Relation Name": "res_partner",
"Schema": "public",
"Alias": "rp",
"Startup Cost": 0.29,
"Total Cost": 4.13,
"Plan Rows": 1,
"Plan Width": 21,
"Actual Startup Time": 0.004,
"Actual Total Time": 0.004,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["rp.country_id", "rp.state_id", "rp.mrm_default_delivery_address", "rp.id", "rp.zip"],
"Index Cond": "(rp.id = cli.id)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 13016,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash Join",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Right",
"Startup Cost": 0.18,
"Total Cost": 2.69,
"Plan Rows": 1,
"Plan Width": 39,
"Actual Startup Time": 0.005,
"Actual Total Time": 0.014,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["c_1.id", "c_1.code", "pg.groups"],
"Inner Unique": true,
"Hash Cond": "(pg.id = c_1.id)",
"Shared Hit Blocks": 7100,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "pays_groups",
"Alias": "pg",
"Startup Cost": 0.00,
"Total Cost": 2.22,
"Plan Rows": 111,
"Plan Width": 36,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.005,
"Actual Rows": 111,
"Actual Loops": 3549,
"Output": ["pg.id", "pg.groups"],
"Shared Hit Blocks": 2,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 0.16,
"Total Cost": 0.16,
"Plan Rows": 1,
"Plan Width": 7,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.001,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["c_1.id", "c_1.code"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 9,
"Shared Hit Blocks": 7098,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Scan Direction": "Forward",
"Index Name": "res_country_pkey",
"Relation Name": "res_country",
"Schema": "public",
"Alias": "c_1",
"Startup Cost": 0.14,
"Total Cost": 0.16,
"Plan Rows": 1,
"Plan Width": 7,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.001,
"Actual Rows": 1,
"Actual Loops": 3549,
"Output": ["c_1.id", "c_1.code"],
"Index Cond": "(c_1.id = rp.country_id)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 7098,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Scan Direction": "Forward",
"Index Name": "res_country_state_pkey",
"Relation Name": "res_country_state",
"Schema": "public",
"Alias": "s",
"Startup Cost": 0.28,
"Total Cost": 0.30,
"Plan Rows": 1,
"Plan Width": 7,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 3549,
"Output": ["s.id", "s.country_id", "s.create_uid", "s.write_uid", "s.name", "s.code", "s.create_date", "s.write_date"],
"Index Cond": "(s.id = rp.state_id)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Scan Direction": "Forward",
"Index Name": "res_partner_pkey",
"Relation Name": "res_partner",
"Schema": "public",
"Alias": "rpa",
"Startup Cost": 0.29,
"Total Cost": 1.18,
"Plan Rows": 1,
"Plan Width": 17,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 3549,
"Output": ["rpa.id", "rpa.country_id", "rpa.state_id", "rpa.zip"],
"Index Cond": "(rpa.id = rp.mrm_default_delivery_address)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Scan Direction": "Forward",
"Index Name": "res_country_pkey",
"Relation Name": "res_country",
"Schema": "public",
"Alias": "ca",
"Startup Cost": 0.14,
"Total Cost": 0.16,
"Plan Rows": 1,
"Plan Width": 7,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 3549,
"Output": ["ca.id", "ca.address_view_id", "ca.currency_id", "ca.phone_code", "ca.create_uid", "ca.write_uid", "ca.code", "ca.name_position", "ca.name", "ca.vat_label", "ca.address_format", "ca.state_required", "ca.zip_required", "ca.create_date", "ca.write_date"],
"Index Cond": "(ca.id = rpa.country_id)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Scan Direction": "Forward",
"Index Name": "res_country_state_pkey",
"Relation Name": "res_country_state",
"Schema": "public",
"Alias": "sa",
"Startup Cost": 0.28,
"Total Cost": 0.30,
"Plan Rows": 1,
"Plan Width": 7,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 3549,
"Output": ["sa.id", "sa.country_id", "sa.create_uid", "sa.write_uid", "sa.name", "sa.code", "sa.create_date", "sa.write_date"],
"Index Cond": "(sa.id = rpa.state_id)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
}
]
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 6.39,
"Total Cost": 6.39,
"Plan Rows": 1,
"Plan Width": 36,
"Actual Startup Time": 0.005,
"Actual Total Time": 0.006,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["tseg.short_name", "tseg.partner_id"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 8,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "tags",
"Alias": "tseg",
"Startup Cost": 0.00,
"Total Cost": 6.39,
"Plan Rows": 1,
"Plan Width": 36,
"Actual Startup Time": 0.004,
"Actual Total Time": 0.005,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["tseg.short_name", "tseg.partner_id"],
"Filter": "((tseg.code)::text ~~ 'seg_%'::text)",
"Rows Removed by Filter": 4,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 6.39,
"Total Cost": 6.39,
"Plan Rows": 1,
"Plan Width": 4,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.002,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["temp.partner_id"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 8,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "tags",
"Alias": "temp",
"Startup Cost": 0.00,
"Total Cost": 6.39,
"Plan Rows": 1,
"Plan Width": 4,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.001,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["temp.partner_id"],
"Filter": "((temp.code)::text ~~ 'emp_%'::text)",
"Rows Removed by Filter": 4,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 6.39,
"Total Cost": 6.39,
"Plan Rows": 1,
"Plan Width": 4,
"Actual Startup Time": 0.004,
"Actual Total Time": 0.004,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["tens.partner_id"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 8,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "tags",
"Alias": "tens",
"Startup Cost": 0.00,
"Total Cost": 6.39,
"Plan Rows": 1,
"Plan Width": 4,
"Actual Startup Time": 0.004,
"Actual Total Time": 0.004,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["tens.partner_id"],
"Filter": "((tens.code)::text ~~ 'ens_%'::text)",
"Rows Removed by Filter": 4,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 4.69,
"Total Cost": 4.69,
"Plan Rows": 169,
"Plan Width": 8,
"Actual Startup Time": 0.053,
"Actual Total Time": 0.053,
"Actual Rows": 169,
"Actual Loops": 1,
"Output": ["cur.name", "cur.id"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 15,
"Shared Hit Blocks": 3,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "res_currency",
"Schema": "public",
"Alias": "cur",
"Startup Cost": 0.00,
"Total Cost": 4.69,
"Plan Rows": 169,
"Plan Width": 8,
"Actual Startup Time": 0.011,
"Actual Total Time": 0.032,
"Actual Rows": 169,
"Actual Loops": 1,
"Output": ["cur.name", "cur.id"],
"Shared Hit Blocks": 3,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 7.17,
"Total Cost": 7.17,
"Plan Rows": 2,
"Plan Width": 36,
"Actual Startup Time": 0.019,
"Actual Total Time": 0.021,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["tc.contrats", "tc.partner_id"],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 8,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Subquery Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Alias": "tc",
"Startup Cost": 7.11,
"Total Cost": 7.17,
"Plan Rows": 2,
"Plan Width": 36,
"Actual Startup Time": 0.019,
"Actual Total Time": 0.020,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["tc.contrats", "tc.partner_id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Aggregate",
"Strategy": "Sorted",
"Partial Mode": "Simple",
"Parent Relationship": "Subquery",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 7.11,
"Total Cost": 7.15,
"Plan Rows": 2,
"Plan Width": 36,
"Actual Startup Time": 0.018,
"Actual Total Time": 0.019,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["t.partner_id", "string_agg(t.short_name, ','::text ORDER BY t.short_name)"],
"Group Key": ["t.partner_id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 7.11,
"Total Cost": 7.12,
"Plan Rows": 2,
"Plan Width": 36,
"Actual Startup Time": 0.017,
"Actual Total Time": 0.017,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["t.partner_id", "t.short_name"],
"Sort Key": ["t.partner_id"],
"Sort Method": "quicksort",
"Sort Space Used": 25,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "tags",
"Alias": "t",
"Startup Cost": 0.00,
"Total Cost": 7.10,
"Plan Rows": 2,
"Plan Width": 36,
"Actual Startup Time": 0.012,
"Actual Total Time": 0.012,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["t.partner_id", "t.short_name"],
"Filter": "(((t.code)::text ~ '^(bra|ctr)_'::text) OR ((t.code)::text = 'cnf'::text))",
"Rows Removed by Filter": 4,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
}
]
}
]
},
{
"Node Type": "Merge Join",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 3919.56,
"Total Cost": 4176.11,
"Plan Rows": 8,
"Plan Width": 154,
"Actual Startup Time": 368.717,
"Actual Total Time": 368.719,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["o.client", "o.num_adresse", "'name'::text", "o.raison_sociale", "a.destinataire", "(((o.mcli || '[i3='::text) || replace(quote_nullable(replace((o.raison_sociale)::text, ''''''::text, '\"'::text)), ''''''::text, '\\'''::text)) || ']'::text)"],
"Inner Unique": false,
"Merge Cond": "((o.client = (a.client)::text) AND (o.num_adresse = a.num_adresse))",
"Join Filter": "(unaccent(lower((o.raison_sociale)::text)) <> unaccent(lower((a.destinataire)::text)))",
"Rows Removed by Join Filter": 3549,
"Shared Hit Blocks": 60356,
"Shared Read Blocks": 596,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 16,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 300.47,
"Total Cost": 309.93,
"Plan Rows": 3783,
"Plan Width": 100,
"Actual Startup Time": 294.923,
"Actual Total Time": 295.990,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o.client", "o.num_adresse", "o.raison_sociale", "o.mcli"],
"Sort Key": ["o.client", "o.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 441,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 59890,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "o_cli",
"Alias": "o",
"Startup Cost": 0.00,
"Total Cost": 75.66,
"Plan Rows": 3783,
"Plan Width": 100,
"Actual Startup Time": 90.560,
"Actual Total Time": 291.405,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o.client", "o.num_adresse", "o.raison_sociale", "o.mcli"],
"Shared Hit Blocks": 59890,
"Shared Read Blocks": 1,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Sort",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 3619.08,
"Total Cost": 3695.04,
"Plan Rows": 30384,
"Plan Width": 35,
"Actual Startup Time": 58.261,
"Actual Total Time": 61.722,
"Actual Rows": 13894,
"Actual Loops": 1,
"Output": ["a.destinataire", "a.client", "a.num_adresse"],
"Sort Key": ["a.client", "a.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 3140,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 466,
"Shared Read Blocks": 595,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 16,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "adresses_livraison",
"Schema": "procol_prod",
"Alias": "a",
"Startup Cost": 0.00,
"Total Cost": 1356.84,
"Plan Rows": 30384,
"Plan Width": 35,
"Actual Startup Time": 0.007,
"Actual Total Time": 8.367,
"Actual Rows": 30384,
"Actual Loops": 1,
"Output": ["a.destinataire", "a.client", "a.num_adresse"],
"Shared Hit Blocks": 458,
"Shared Read Blocks": 595,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 16,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Subquery Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Async Capable": false,
"Alias": "*SELECT* 2",
"Startup Cost": 3919.56,
"Total Cost": 4176.07,
"Plan Rows": 8,
"Plan Width": 164,
"Actual Startup Time": 78.779,
"Actual Total Time": 78.781,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["\"*SELECT* 2\".client", "\"*SELECT* 2\".num_adresse", "'date_creation'::text", "\"*SELECT* 2\".v_odoo", "\"*SELECT* 2\".v_procol", "''::text"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Merge Join",
"Parent Relationship": "Subquery",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 3919.56,
"Total Cost": 4175.99,
"Plan Rows": 8,
"Plan Width": 164,
"Actual Startup Time": 78.777,
"Actual Total Time": 78.779,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["o_1.client", "o_1.num_adresse", "'date_creation'::text", "to_char((o_1.date_creation)::timestamp with time zone, 'DD/MM/YYYY'::text)", "to_char((a_1.date_creation)::timestamp with time zone, 'DD/MM/YYYY'::text)", "''::text"],
"Inner Unique": false,
"Merge Cond": "((o_1.client = (a_1.client)::text) AND (o_1.num_adresse = a_1.num_adresse))",
"Join Filter": "(o_1.date_creation <> a_1.date_creation)",
"Rows Removed by Join Filter": 3549,
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 300.47,
"Total Cost": 309.93,
"Plan Rows": 3783,
"Plan Width": 40,
"Actual Startup Time": 4.784,
"Actual Total Time": 5.443,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_1.client", "o_1.num_adresse", "o_1.date_creation"],
"Sort Key": ["o_1.client", "o_1.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 291,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "o_cli",
"Alias": "o_1",
"Startup Cost": 0.00,
"Total Cost": 75.66,
"Plan Rows": 3783,
"Plan Width": 40,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.454,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_1.client", "o_1.num_adresse", "o_1.date_creation"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Sort",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 3619.08,
"Total Cost": 3695.04,
"Plan Rows": 30384,
"Plan Width": 17,
"Actual Startup Time": 66.238,
"Actual Total Time": 68.604,
"Actual Rows": 13894,
"Actual Loops": 1,
"Output": ["a_1.date_creation", "a_1.client", "a_1.num_adresse"],
"Sort Key": ["a_1.client", "a_1.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 2667,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "adresses_livraison",
"Schema": "procol_prod",
"Alias": "a_1",
"Startup Cost": 0.00,
"Total Cost": 1356.84,
"Plan Rows": 30384,
"Plan Width": 17,
"Actual Startup Time": 0.025,
"Actual Total Time": 18.826,
"Actual Rows": 30384,
"Actual Loops": 1,
"Output": ["a_1.date_creation", "a_1.client", "a_1.num_adresse"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
},
{
"Node Type": "Merge Join",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 3919.56,
"Total Cost": 4176.03,
"Plan Rows": 8,
"Plan Width": 155,
"Actual Startup Time": 79.475,
"Actual Total Time": 79.477,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["o_2.client", "o_2.num_adresse", "'adresse'::text", "o_2.street", "a_2.adresse", "''::text"],
"Inner Unique": false,
"Merge Cond": "((o_2.client = (a_2.client)::text) AND (o_2.num_adresse = a_2.num_adresse))",
"Join Filter": "(TRIM(BOTH FROM unaccent(lower((o_2.street)::text))) <> TRIM(BOTH FROM unaccent(lower((a_2.adresse)::text))))",
"Rows Removed by Join Filter": 3549,
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 300.47,
"Total Cost": 309.93,
"Plan Rows": 3783,
"Plan Width": 68,
"Actual Startup Time": 4.800,
"Actual Total Time": 5.579,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_2.client", "o_2.num_adresse", "o_2.street"],
"Sort Key": ["o_2.client", "o_2.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 361,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "o_cli",
"Alias": "o_2",
"Startup Cost": 0.00,
"Total Cost": 75.66,
"Plan Rows": 3783,
"Plan Width": 68,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.468,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_2.client", "o_2.num_adresse", "o_2.street"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Sort",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 3619.08,
"Total Cost": 3695.04,
"Plan Rows": 30384,
"Plan Width": 36,
"Actual Startup Time": 60.391,
"Actual Total Time": 62.948,
"Actual Rows": 13894,
"Actual Loops": 1,
"Output": ["a_2.adresse", "a_2.client", "a_2.num_adresse"],
"Sort Key": ["a_2.client", "a_2.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 3162,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "adresses_livraison",
"Schema": "procol_prod",
"Alias": "a_2",
"Startup Cost": 0.00,
"Total Cost": 1356.84,
"Plan Rows": 30384,
"Plan Width": 36,
"Actual Startup Time": 0.035,
"Actual Total Time": 8.247,
"Actual Rows": 30384,
"Actual Loops": 1,
"Output": ["a_2.adresse", "a_2.client", "a_2.num_adresse"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Merge Join",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 3919.56,
"Total Cost": 4176.03,
"Plan Rows": 8,
"Plan Width": 135,
"Actual Startup Time": 77.702,
"Actual Total Time": 77.704,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["o_3.client", "o_3.num_adresse", "'complement_adresse'::text", "o_3.street2", "a_3.complement_adresse", "''::text"],
"Inner Unique": false,
"Merge Cond": "((o_3.client = (a_3.client)::text) AND (o_3.num_adresse = a_3.num_adresse))",
"Join Filter": "(TRIM(BOTH FROM unaccent(lower((o_3.street2)::text))) <> TRIM(BOTH FROM unaccent(lower((a_3.complement_adresse)::text))))",
"Rows Removed by Join Filter": 3549,
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 300.47,
"Total Cost": 309.93,
"Plan Rows": 3783,
"Plan Width": 68,
"Actual Startup Time": 5.209,
"Actual Total Time": 5.584,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_3.client", "o_3.num_adresse", "o_3.street2"],
"Sort Key": ["o_3.client", "o_3.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 320,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "o_cli",
"Alias": "o_3",
"Startup Cost": 0.00,
"Total Cost": 75.66,
"Plan Rows": 3783,
"Plan Width": 68,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.432,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_3.client", "o_3.num_adresse", "o_3.street2"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Sort",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 3619.08,
"Total Cost": 3695.04,
"Plan Rows": 30384,
"Plan Width": 16,
"Actual Startup Time": 62.835,
"Actual Total Time": 64.031,
"Actual Rows": 13894,
"Actual Loops": 1,
"Output": ["a_3.complement_adresse", "a_3.client", "a_3.num_adresse"],
"Sort Key": ["a_3.client", "a_3.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 2510,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "adresses_livraison",
"Schema": "procol_prod",
"Alias": "a_3",
"Startup Cost": 0.00,
"Total Cost": 1356.84,
"Plan Rows": 30384,
"Plan Width": 16,
"Actual Startup Time": 0.025,
"Actual Total Time": 6.135,
"Actual Rows": 30384,
"Actual Loops": 1,
"Output": ["a_3.complement_adresse", "a_3.client", "a_3.num_adresse"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Merge Join",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 3919.56,
"Total Cost": 4176.03,
"Plan Rows": 8,
"Plan Width": 137,
"Actual Startup Time": 80.212,
"Actual Total Time": 80.213,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["o_4.client", "o_4.num_adresse", "'code_postal'::text", "o_4.zip", "a_4.code_postal", "''::text"],
"Inner Unique": false,
"Merge Cond": "((o_4.client = (a_4.client)::text) AND (o_4.num_adresse = a_4.num_adresse))",
"Join Filter": "(TRIM(BOTH FROM unaccent(lower((o_4.zip)::text))) <> TRIM(BOTH FROM unaccent(lower((a_4.code_postal)::text))))",
"Rows Removed by Join Filter": 3549,
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 300.47,
"Total Cost": 309.93,
"Plan Rows": 3783,
"Plan Width": 68,
"Actual Startup Time": 5.179,
"Actual Total Time": 5.480,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_4.client", "o_4.num_adresse", "o_4.zip"],
"Sort Key": ["o_4.client", "o_4.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 318,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "o_cli",
"Alias": "o_4",
"Startup Cost": 0.00,
"Total Cost": 75.66,
"Plan Rows": 3783,
"Plan Width": 68,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.449,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_4.client", "o_4.num_adresse", "o_4.zip"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Sort",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 3619.08,
"Total Cost": 3695.04,
"Plan Rows": 30384,
"Plan Width": 18,
"Actual Startup Time": 65.856,
"Actual Total Time": 66.699,
"Actual Rows": 13894,
"Actual Loops": 1,
"Output": ["a_4.code_postal", "a_4.client", "a_4.num_adresse"],
"Sort Key": ["a_4.client", "a_4.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 2666,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "adresses_livraison",
"Schema": "procol_prod",
"Alias": "a_4",
"Startup Cost": 0.00,
"Total Cost": 1356.84,
"Plan Rows": 30384,
"Plan Width": 18,
"Actual Startup Time": 0.016,
"Actual Total Time": 8.796,
"Actual Rows": 30384,
"Actual Loops": 1,
"Output": ["a_4.code_postal", "a_4.client", "a_4.num_adresse"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Merge Join",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 3919.56,
"Total Cost": 4176.03,
"Plan Rows": 8,
"Plan Width": 144,
"Actual Startup Time": 63.247,
"Actual Total Time": 63.249,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["o_5.client", "o_5.num_adresse", "'ville'::text", "o_5.city", "a_5.ville", "''::text"],
"Inner Unique": false,
"Merge Cond": "((o_5.client = (a_5.client)::text) AND (o_5.num_adresse = a_5.num_adresse))",
"Join Filter": "(TRIM(BOTH FROM unaccent(lower((o_5.city)::text))) <> TRIM(BOTH FROM unaccent(lower((a_5.ville)::text))))",
"Rows Removed by Join Filter": 3549,
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 300.47,
"Total Cost": 309.93,
"Plan Rows": 3783,
"Plan Width": 68,
"Actual Startup Time": 5.080,
"Actual Total Time": 5.637,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_5.client", "o_5.num_adresse", "o_5.city"],
"Sort Key": ["o_5.client", "o_5.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 328,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "o_cli",
"Alias": "o_5",
"Startup Cost": 0.00,
"Total Cost": 75.66,
"Plan Rows": 3783,
"Plan Width": 68,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.467,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_5.client", "o_5.num_adresse", "o_5.city"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Sort",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 3619.08,
"Total Cost": 3695.04,
"Plan Rows": 30384,
"Plan Width": 25,
"Actual Startup Time": 51.823,
"Actual Total Time": 52.518,
"Actual Rows": 13894,
"Actual Loops": 1,
"Output": ["a_5.ville", "a_5.client", "a_5.num_adresse"],
"Sort Key": ["a_5.client", "a_5.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 2821,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "adresses_livraison",
"Schema": "procol_prod",
"Alias": "a_5",
"Startup Cost": 0.00,
"Total Cost": 1356.84,
"Plan Rows": 30384,
"Plan Width": 25,
"Actual Startup Time": 0.007,
"Actual Total Time": 8.601,
"Actual Rows": 30384,
"Actual Loops": 1,
"Output": ["a_5.ville", "a_5.client", "a_5.num_adresse"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Subquery Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Async Capable": false,
"Alias": "*SELECT* 7",
"Startup Cost": 3987.84,
"Total Cost": 4243.83,
"Plan Rows": 8,
"Plan Width": 139,
"Actual Startup Time": 54.689,
"Actual Total Time": 54.691,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["\"*SELECT* 7\".client", "\"*SELECT* 7\".num_adresse", "'pays'::text", "\"*SELECT* 7\".v_odoo", "\"*SELECT* 7\".v_procol", "\"*SELECT* 7\".correction"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Merge Join",
"Parent Relationship": "Subquery",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 3987.84,
"Total Cost": 4243.75,
"Plan Rows": 8,
"Plan Width": 139,
"Actual Startup Time": 54.687,
"Actual Total Time": 54.689,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["o_6.client", "o_6.num_adresse", "'pays'::text", "o_6.country", "a_6.pays", "(((o_6.mcli || '[i8='::text) || quote_nullable(TRIM(BOTH FROM \"left\"(o_6.country, 15)))) || ']'::text)"],
"Inner Unique": false,
"Merge Cond": "((o_6.client = (a_6.client)::text) AND (o_6.num_adresse = a_6.num_adresse))",
"Join Filter": "(\"left\"(TRIM(BOTH FROM unaccent(lower(o_6.country))), 15) <> TRIM(BOTH FROM unaccent(lower((a_6.pays)::text))))",
"Rows Removed by Join Filter": 3460,
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 300.47,
"Total Cost": 309.93,
"Plan Rows": 3783,
"Plan Width": 100,
"Actual Startup Time": 3.144,
"Actual Total Time": 3.788,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_6.client", "o_6.num_adresse", "o_6.country", "o_6.mcli"],
"Sort Key": ["o_6.client", "o_6.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 402,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "o_cli",
"Alias": "o_6",
"Startup Cost": 0.00,
"Total Cost": 75.66,
"Plan Rows": 3783,
"Plan Width": 100,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.497,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_6.client", "o_6.num_adresse", "o_6.country", "o_6.mcli"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Sort",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 3687.37,
"Total Cost": 3763.09,
"Plan Rows": 30290,
"Plan Width": 20,
"Actual Startup Time": 38.106,
"Actual Total Time": 41.682,
"Actual Rows": 13796,
"Actual Loops": 1,
"Output": ["a_6.pays", "a_6.client", "a_6.num_adresse"],
"Sort Key": ["a_6.client", "a_6.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 2664,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "adresses_livraison",
"Schema": "procol_prod",
"Alias": "a_6",
"Startup Cost": 0.00,
"Total Cost": 1432.80,
"Plan Rows": 30290,
"Plan Width": 20,
"Actual Startup Time": 0.012,
"Actual Total Time": 4.249,
"Actual Rows": 30286,
"Actual Loops": 1,
"Output": ["a_6.pays", "a_6.client", "a_6.num_adresse"],
"Filter": "((a_6.client)::text !~~ '9999%'::text)",
"Rows Removed by Filter": 98,
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
},
{
"Node Type": "Merge Join",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 3919.56,
"Total Cost": 4176.11,
"Plan Rows": 8,
"Plan Width": 145,
"Actual Startup Time": 39.871,
"Actual Total Time": 45.307,
"Actual Rows": 1387,
"Actual Loops": 1,
"Output": ["o_7.client", "o_7.num_adresse", "'telephone'::text", "o_7.phone", "a_7.telephone", "(((o_7.mcli || '[i9='::text) || quote_nullable((o_7.phone)::text)) || ']'::text)"],
"Inner Unique": false,
"Merge Cond": "((o_7.client = (a_7.client)::text) AND (o_7.num_adresse = a_7.num_adresse))",
"Join Filter": "(TRIM(BOTH FROM unaccent(lower((o_7.phone)::text))) <> TRIM(BOTH FROM unaccent(lower((a_7.telephone)::text))))",
"Rows Removed by Join Filter": 2162,
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 300.47,
"Total Cost": 309.93,
"Plan Rows": 3783,
"Plan Width": 100,
"Actual Startup Time": 3.051,
"Actual Total Time": 3.346,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_7.client", "o_7.num_adresse", "o_7.phone", "o_7.mcli"],
"Sort Key": ["o_7.client", "o_7.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 395,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "o_cli",
"Alias": "o_7",
"Startup Cost": 0.00,
"Total Cost": 75.66,
"Plan Rows": 3783,
"Plan Width": 100,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.399,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_7.client", "o_7.num_adresse", "o_7.phone", "o_7.mcli"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Sort",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 3619.08,
"Total Cost": 3695.04,
"Plan Rows": 30384,
"Plan Width": 26,
"Actual Startup Time": 36.803,
"Actual Total Time": 37.394,
"Actual Rows": 13894,
"Actual Loops": 1,
"Output": ["a_7.telephone", "a_7.client", "a_7.num_adresse"],
"Sort Key": ["a_7.client", "a_7.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 2791,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "adresses_livraison",
"Schema": "procol_prod",
"Alias": "a_7",
"Startup Cost": 0.00,
"Total Cost": 1356.84,
"Plan Rows": 30384,
"Plan Width": 26,
"Actual Startup Time": 0.005,
"Actual Total Time": 3.117,
"Actual Rows": 30384,
"Actual Loops": 1,
"Output": ["a_7.telephone", "a_7.client", "a_7.num_adresse"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Subquery Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Async Capable": false,
"Alias": "*SELECT* 9",
"Startup Cost": 3919.56,
"Total Cost": 4175.97,
"Plan Rows": 4,
"Plan Width": 133,
"Actual Startup Time": 48.196,
"Actual Total Time": 48.198,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["\"*SELECT* 9\".client", "\"*SELECT* 9\".num_adresse", "'free_shipping'::text", "'P'::character varying", "\"*SELECT* 9\".v_procol", "''::text"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Merge Join",
"Parent Relationship": "Subquery",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 3919.56,
"Total Cost": 4175.93,
"Plan Rows": 4,
"Plan Width": 133,
"Actual Startup Time": 48.195,
"Actual Total Time": 48.196,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["o_8.client", "o_8.num_adresse", "'free_shipping'::text", "'P'::text", "a_8.flag_port_gratuit", "''::text"],
"Inner Unique": false,
"Merge Cond": "((o_8.client = (a_8.client)::text) AND (o_8.num_adresse = a_8.num_adresse))",
"Join Filter": "(o_8.free_shipping_p <> ((a_8.flag_port_gratuit)::text = 'P'::text))",
"Rows Removed by Join Filter": 3549,
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 300.47,
"Total Cost": 309.93,
"Plan Rows": 3783,
"Plan Width": 37,
"Actual Startup Time": 3.266,
"Actual Total Time": 3.469,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_8.client", "o_8.num_adresse", "o_8.free_shipping_p"],
"Sort Key": ["o_8.client", "o_8.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 291,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "o_cli",
"Alias": "o_8",
"Startup Cost": 0.00,
"Total Cost": 75.66,
"Plan Rows": 3783,
"Plan Width": 37,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.507,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_8.client", "o_8.num_adresse", "o_8.free_shipping_p"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Sort",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 3619.08,
"Total Cost": 3695.04,
"Plan Rows": 30384,
"Plan Width": 14,
"Actual Startup Time": 41.896,
"Actual Total Time": 42.413,
"Actual Rows": 13894,
"Actual Loops": 1,
"Output": ["a_8.flag_port_gratuit", "a_8.client", "a_8.num_adresse"],
"Sort Key": ["a_8.client", "a_8.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 2430,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "adresses_livraison",
"Schema": "procol_prod",
"Alias": "a_8",
"Startup Cost": 0.00,
"Total Cost": 1356.84,
"Plan Rows": 30384,
"Plan Width": 14,
"Actual Startup Time": 0.005,
"Actual Total Time": 3.395,
"Actual Rows": 30384,
"Actual Loops": 1,
"Output": ["a_8.flag_port_gratuit", "a_8.client", "a_8.num_adresse"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
},
{
"Node Type": "Subquery Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Async Capable": false,
"Alias": "*SELECT* 10",
"Startup Cost": 3919.56,
"Total Cost": 4176.11,
"Plan Rows": 8,
"Plan Width": 136,
"Actual Startup Time": 43.902,
"Actual Total Time": 43.903,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["\"*SELECT* 10\".client", "\"*SELECT* 10\".num_adresse", "'segmentation'::text", "\"*SELECT* 10\".v_odoo", "\"*SELECT* 10\".v_procol", "''::text"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Merge Join",
"Parent Relationship": "Subquery",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 3919.56,
"Total Cost": 4176.03,
"Plan Rows": 8,
"Plan Width": 136,
"Actual Startup Time": 43.900,
"Actual Total Time": 43.902,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["o_9.client", "o_9.num_adresse", "'segmentation'::text", "o_9.segmentation", "a_9.segmentation", "''::text"],
"Inner Unique": false,
"Merge Cond": "((o_9.client = (a_9.client)::text) AND (o_9.num_adresse = a_9.num_adresse))",
"Join Filter": "(TRIM(BOTH FROM unaccent(lower(o_9.segmentation))) <> TRIM(BOTH FROM unaccent(lower((a_9.segmentation)::text))))",
"Rows Removed by Join Filter": 3549,
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 300.47,
"Total Cost": 309.93,
"Plan Rows": 3783,
"Plan Width": 68,
"Actual Startup Time": 3.297,
"Actual Total Time": 3.518,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_9.client", "o_9.num_adresse", "o_9.segmentation"],
"Sort Key": ["o_9.client", "o_9.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 291,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "o_cli",
"Alias": "o_9",
"Startup Cost": 0.00,
"Total Cost": 75.66,
"Plan Rows": 3783,
"Plan Width": 68,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.557,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_9.client", "o_9.num_adresse", "o_9.segmentation"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Sort",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 3619.08,
"Total Cost": 3695.04,
"Plan Rows": 30384,
"Plan Width": 17,
"Actual Startup Time": 35.806,
"Actual Total Time": 36.575,
"Actual Rows": 13894,
"Actual Loops": 1,
"Output": ["a_9.segmentation", "a_9.client", "a_9.num_adresse"],
"Sort Key": ["a_9.client", "a_9.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 2668,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "adresses_livraison",
"Schema": "procol_prod",
"Alias": "a_9",
"Startup Cost": 0.00,
"Total Cost": 1356.84,
"Plan Rows": 30384,
"Plan Width": 17,
"Actual Startup Time": 0.008,
"Actual Total Time": 3.383,
"Actual Rows": 30384,
"Actual Loops": 1,
"Output": ["a_9.segmentation", "a_9.client", "a_9.num_adresse"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
},
{
"Node Type": "Subquery Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Async Capable": false,
"Alias": "*SELECT* 11",
"Startup Cost": 3919.56,
"Total Cost": 4176.19,
"Plan Rows": 8,
"Plan Width": 136,
"Actual Startup Time": 48.968,
"Actual Total Time": 48.969,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["\"*SELECT* 11\".client", "\"*SELECT* 11\".num_adresse", "'departement'::text", "\"*SELECT* 11\".v_odoo", "\"*SELECT* 11\".v_procol", "\"*SELECT* 11\".correction"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Merge Join",
"Parent Relationship": "Subquery",
"Parallel Aware": false,
"Async Capable": false,
"Join Type": "Inner",
"Startup Cost": 3919.56,
"Total Cost": 4176.11,
"Plan Rows": 8,
"Plan Width": 136,
"Actual Startup Time": 48.966,
"Actual Total Time": 48.967,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["o_10.client", "o_10.num_adresse", "'departement'::text", "(((o_10.departement)::text || '/'::text) || (o_10.country_state)::text)", "a_10.zone_administrative", "concat(o_10.mcli, '[i22=', quote_nullable((o_10.departement)::text), ']')"],
"Inner Unique": false,
"Merge Cond": "((o_10.client = (a_10.client)::text) AND (o_10.num_adresse = a_10.num_adresse))",
"Join Filter": "(TRIM(BOTH FROM unaccent(lower((o_10.departement)::text))) <> TRIM(BOTH FROM unaccent(lower((a_10.zone_administrative)::text))))",
"Rows Removed by Join Filter": 3549,
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 300.47,
"Total Cost": 309.93,
"Plan Rows": 3783,
"Plan Width": 132,
"Actual Startup Time": 3.522,
"Actual Total Time": 3.807,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_10.client", "o_10.num_adresse", "o_10.departement", "o_10.country_state", "o_10.mcli"],
"Sort Key": ["o_10.client", "o_10.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 401,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "CTE Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"CTE Name": "o_cli",
"Alias": "o_10",
"Startup Cost": 0.00,
"Total Cost": 75.66,
"Plan Rows": 3783,
"Plan Width": 132,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.626,
"Actual Rows": 3549,
"Actual Loops": 1,
"Output": ["o_10.client", "o_10.num_adresse", "o_10.departement", "o_10.country_state", "o_10.mcli"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Sort",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Async Capable": false,
"Startup Cost": 3619.08,
"Total Cost": 3695.04,
"Plan Rows": 30384,
"Plan Width": 17,
"Actual Startup Time": 39.898,
"Actual Total Time": 40.583,
"Actual Rows": 13894,
"Actual Loops": 1,
"Output": ["a_10.zone_administrative", "a_10.client", "a_10.num_adresse"],
"Sort Key": ["a_10.client", "a_10.num_adresse"],
"Sort Method": "quicksort",
"Sort Space Used": 2668,
"Sort Space Type": "Memory",
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Async Capable": false,
"Relation Name": "adresses_livraison",
"Schema": "procol_prod",
"Alias": "a_10",
"Startup Cost": 0.00,
"Total Cost": 1356.84,
"Plan Rows": 30384,
"Plan Width": 17,
"Actual Startup Time": 0.028,
"Actual Total Time": 8.162,
"Actual Rows": 30384,
"Actual Loops": 1,
"Output": ["a_10.zone_administrative", "a_10.client", "a_10.num_adresse"],
"Shared Hit Blocks": 1053,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
}
]
},
"Planning": {
"Shared Hit Blocks": 294,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
"Planning Time": 9.736,
"Triggers": [
],
"Execution Time": 990.881
}
]
Sorry for missing this for so long. Will be looking into it as I've noticed it myself when using some newer features in postgres.
No problem ! It's already great that you noticed.
Using Pycharm 233.13763.11, on ubuntu 22.04, with postgresql 15. I have a query that returns this plan, but it couldn't be parsed by the plugin (version 0.9 installed) :
The plan was obtained with the query
EXPLAIN (FORMAT JSON, VERBOSE, COSTS, BUFFERS, ANALYSE) ...