search

AlexTatiyants / pev

Postgres Explain Visualizer
MIT License
2.77k stars 194 forks source link

Exception: error during evaluation of "click" #8

Closed rossnick closed 8 years ago

rossnick commented 8 years ago

Here's the json : "[ { "Plan": { "Node Type": "Aggregate", "Strategy": "Plain", "Startup Cost": 1733.50, "Total Cost": 1733.51, "Plan Rows": 1, "Plan Width": 13, "Actual Startup Time": 33.197, "Actual Total Time": 33.197, "Actual Rows": 1, "Actual Loops": 1, "Output": ["count(DISTINCT produit.noproduit)"], "Shared Hit Blocks": 19337, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "InitPlan", "Subplan Name": "CTE listeintranet", "Join Type": "Inner", "Startup Cost": 402.76, "Total Cost": 586.29, "Plan Rows": 1, "Plan Width": 17, "Actual Startup Time": 2.921, "Actual Total Time": 3.497, "Actual Rows": 37, "Actual Loops": 1, "Output": ["vente.noproduit", "vente.datefacture"], "Join Filter": "(((vente.noproduit)::text = (produit_1.noproduit)::text) AND (client.nocompagnie = produit_1.nocompagnie))", "Rows Removed by Join Filter": 0, "Shared Hit Blocks": 215, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Join Type": "Inner", "Startup Cost": 402.33, "Total Cost": 581.06, "Plan Rows": 2, "Plan Width": 36, "Actual Startup Time": 2.894, "Actual Total Time": 2.940, "Actual Rows": 37, "Actual Loops": 1, "Output": ["client.nocompagnie", "vente.noproduit", "vente.datefacture", "inventaire.noproduit", "inventaire.nocompagnie"], "Hash Cond": "((vente.noproduit)::text = (inventaire.noproduit)::text)", "Shared Hit Blocks": 67, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Scan Direction": "Forward", "Index Name": "ii_vente_noclient", "Relation Name": "vente", "Schema": "intranet", "Alias": "vente", "Startup Cost": 0.42, "Total Cost": 178.02, "Plan Rows": 178, "Plan Width": 25, "Actual Startup Time": 0.029, "Actual Total Time": 0.046, "Actual Rows": 41, "Actual Loops": 1, "Output": ["vente.codeshipto", "vente.codeproduit", "vente.codecommande", "vente.nocompagnie", "vente.noclient", "vente.noshipto", "vente.noproduit", "vente.datefacture", "vente.nofacture", "vente.sequence", "vente.ventedirect", "vente.qtefacturee", "vente.prixvente", "vente.nocommande", "vente.nocommandeclient"], "Index Cond": "((vente.noclient)::text = '0450219'::text)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 6, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Startup Cost": 400.87, "Total Cost": 400.87, "Plan Rows": 83, "Plan Width": 27, "Actual Startup Time": 2.852, "Actual Total Time": 2.852, "Actual Rows": 2018, "Actual Loops": 1, "Output": ["client.noclient", "client.nocompagnie", "inventaire.noproduit", "inventaire.nocompagnie"], "Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 117, "Shared Hit Blocks": 61, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Join Type": "Inner", "Startup Cost": 63.00, "Total Cost": 400.87, "Plan Rows": 83, "Plan Width": 27, "Actual Startup Time": 0.467, "Actual Total Time": 2.167, "Actual Rows": 2018, "Actual Loops": 1, "Output": ["client.noclient", "client.nocompagnie", "inventaire.noproduit", "inventaire.nocompagnie"], "Hash Cond": "((inventaire.codeentrepot)::text = (entrepot.codeentrepot)::text)", "Shared Hit Blocks": 61, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Join Type": "Inner", "Startup Cost": 53.23, "Total Cost": 377.21, "Plan Rows": 3484, "Plan Width": 32, "Actual Startup Time": 0.328, "Actual Total Time": 1.299, "Actual Rows": 2114, "Actual Loops": 1, "Output": ["client.noclient", "client.nocompagnie", "inventaire.noproduit", "inventaire.nocompagnie", "inventaire.codeentrepot"], "Shared Hit Blocks": 57, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Scan Direction": "Forward", "Index Name": "idxinoclientunique", "Relation Name": "client", "Schema": "intranet", "Alias": "client", "Startup Cost": 0.29, "Total Cost": 8.30, "Plan Rows": 1, "Plan Width": 11, "Actual Startup Time": 0.011, "Actual Total Time": 0.012, "Actual Rows": 1, "Actual Loops": 1, "Output": ["client.codeclient", "client.codevendeur", "client.nocompagnie", "client.noclient", "client.nomclient", "client.adresse1", "client.adresse2", "client.adresse3", "client.codepostal", "client.telephone", "client.fax", "client.keyname", "client.vendeur", "client.devise", "client.codesic", "client.classeclient", "client.terme", "client.courriel", "client.dateouverture", "client.handling", "client.groupement", "client.status", "client.daterevisioncredit", "client.isactif", "client.isprospect", "client.codeclientcree", "client.tsupdate", "client.contactachat", "client.contactprincipal", "client.route", "client.limitecredit"], "Index Cond": "((client.noclient)::text = '0450219'::text)", "Rows Removed by Index Recheck": 0, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Node Type": "Bitmap Heap Scan", "Parent Relationship": "Inner", "Relation Name": "inventaire", "Schema": "intranet", "Alias": "inventaire", "Startup Cost": 52.94, "Total Cost": 342.25, "Plan Rows": 2665, "Plan Width": 21, "Actual Startup Time": 0.313, "Actual Total Time": 0.717, "Actual Rows": 2114, "Actual Loops": 1, "Output": ["inventaire.codeproduit", "inventaire.codeentrepot", "inventaire.nocompagnie", "inventaire.noproduit", "inventaire.noentrepot", "inventaire.lotsouscode", "inventaire.piecesenachat", "inventaire.coutremplacement", "inventaire.coutmoyen", "inventaire.piecesenmain", "inventaire.piecesreserves", "inventaire.piecesbo"], "Recheck Cond": "(inventaire.nocompagnie = client.nocompagnie)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 54, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Outer", "Index Name": "idxi316", "Startup Cost": 0.00, "Total Cost": 52.27, "Plan Rows": 2665, "Plan Width": 0, "Actual Startup Time": 0.298, "Actual Total Time": 0.298, "Actual Rows": 2114, "Actual Loops": 1, "Index Cond": "(inventaire.nocompagnie = client.nocompagnie)", "Shared Hit Blocks": 8, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Startup Cost": 9.65, "Total Cost": 9.65, "Plan Rows": 9, "Plan Width": 6, "Actual Startup Time": 0.123, "Actual Total Time": 0.123, "Actual Rows": 9, "Actual Loops": 1, "Output": ["entrepot.codeentrepot"], "Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 1, "Shared Hit Blocks": 4, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Relation Name": "entrepot", "Schema": "intranet", "Alias": "entrepot", "Startup Cost": 0.00, "Total Cost": 9.65, "Plan Rows": 9, "Plan Width": 6, "Actual Startup Time": 0.008, "Actual Total Time": 0.118, "Actual Rows": 9, "Actual Loops": 1, "Output": ["entrepot.codeentrepot"], "Filter": "(((entrepot.web)::text = 'P'::text) OR ((entrepot.web)::text = 'L'::text))", "Rows Removed by Filter": 368, "Shared Hit Blocks": 4, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] } ] } ] } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Scan Direction": "Forward", "Index Name": "idxi125", "Relation Name": "produit", "Schema": "intranet", "Alias": "produit_1", "Startup Cost": 0.42, "Total Cost": 2.60, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.013, "Actual Total Time": 0.014, "Actual Rows": 1, "Actual Loops": 37, "Output": ["produit_1.codeproduit", "produit_1.nocompagnie", "produit_1.noproduit", "produit_1.descfrancais", "produit_1.descanglais", "produit_1.codeinterne", "produit_1.facteurconversion", "produit_1.codealpha", "produit_1.classeproduit", "produit_1.prixunitaire", "produit_1.unitepaquet", "produit_1.prixventereg", "produit_1.prixventedirect", "produit_1.codensl", "produit_1.codesn", "produit_1.codeunitemesure", "produit_1.codelivraison", "produit_1.produitsubstituts", "produit_1.descunitemesure", "produit_1.tsupdate", "produit_1.isactif"], "Index Cond": "(((produit_1.noproduit)::text = (inventaire.noproduit)::text) AND (produit_1.nocompagnie = inventaire.nocompagnie))", "Rows Removed by Index Recheck": 0, "Filter": "(produit_1.isactif = 1)", "Rows Removed by Filter": 0, "Shared Hit Blocks": 148, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] }, { "Node Type": "Aggregate", "Strategy": "Hashed", "Parent Relationship": "InitPlan", "Subplan Name": "CTE listeinterne", "Startup Cost": 1130.40, "Total Cost": 1130.42, "Plan Rows": 1, "Plan Width": 21, "Actual Startup Time": 29.159, "Actual Total Time": 29.159, "Actual Rows": 0, "Actual Loops": 1, "Output": ["commandeligne.noproduit", "((commande.tsenvoye)::date)"], "Shared Hit Blocks": 19019, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Join Type": "Inner", "Startup Cost": 402.61, "Total Cost": 1130.40, "Plan Rows": 1, "Plan Width": 21, "Actual Startup Time": 29.158, "Actual Total Time": 29.158, "Actual Rows": 0, "Actual Loops": 1, "Output": ["commandeligne.noproduit", "(commande.tsenvoye)::date"], "Join Filter": "(client_1.nocompagnie = produit_2.nocompagnie)", "Rows Removed by Join Filter": 0, "Shared Hit Blocks": 19019, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Join Type": "Inner", "Startup Cost": 402.19, "Total Cost": 1128.03, "Plan Rows": 1, "Plan Width": 40, "Actual Startup Time": 29.158, "Actual Total Time": 29.158, "Actual Rows": 0, "Actual Loops": 1, "Output": ["commandeligne.noproduit", "commande.tsenvoye", "client_1.nocompagnie", "inventaire_1.noproduit", "inventaire_1.nocompagnie"], "Shared Hit Blocks": 19019, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Join Type": "Inner", "Startup Cost": 401.91, "Total Cost": 1013.93, "Plan Rows": 228, "Plan Width": 44, "Actual Startup Time": 2.821, "Actual Total Time": 13.386, "Actual Rows": 6232, "Actual Loops": 1, "Output": ["commandeligne.noproduit", "commandeligne.fidcommande", "inventaire_1.noproduit", "inventaire_1.nocompagnie", "client_1.noclient", "client_1.nocompagnie"], "Hash Cond": "((commandeligne.noproduit)::text = (inventaire_1.noproduit)::text)", "Shared Hit Blocks": 289, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Relation Name": "commandeligne", "Schema": "magasin", "Alias": "commandeligne", "Startup Cost": 0.00, "Total Cost": 462.92, "Plan Rows": 23492, "Plan Width": 17, "Actual Startup Time": 0.005, "Actual Total Time": 3.126, "Actual Rows": 23495, "Actual Loops": 1, "Output": ["commandeligne.idligne", "commandeligne.fidcommande", "commandeligne.noproduit", "commandeligne.qte", "commandeligne.prix", "commandeligne.qtebo", "commandeligne.qtecommandeetotal", "commandeligne.vignette"], "Shared Hit Blocks": 228, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Startup Cost": 400.87, "Total Cost": 400.87, "Plan Rows": 83, "Plan Width": 27, "Actual Startup Time": 2.798, "Actual Total Time": 2.798, "Actual Rows": 2018, "Actual Loops": 1, "Output": ["client_1.noclient", "client_1.nocompagnie", "inventaire_1.noproduit", "inventaire_1.nocompagnie"], "Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 117, "Shared Hit Blocks": 61, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Join Type": "Inner", "Startup Cost": 63.00, "Total Cost": 400.87, "Plan Rows": 83, "Plan Width": 27, "Actual Startup Time": 0.466, "Actual Total Time": 2.013, "Actual Rows": 2018, "Actual Loops": 1, "Output": ["client_1.noclient", "client_1.nocompagnie", "inventaire_1.noproduit", "inventaire_1.nocompagnie"], "Hash Cond": "((inventaire_1.codeentrepot)::text = (entrepot_1.codeentrepot)::text)", "Shared Hit Blocks": 61, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Join Type": "Inner", "Startup Cost": 53.23, "Total Cost": 377.21, "Plan Rows": 3484, "Plan Width": 32, "Actual Startup Time": 0.327, "Actual Total Time": 1.255, "Actual Rows": 2114, "Actual Loops": 1, "Output": ["client_1.noclient", "client_1.nocompagnie", "inventaire_1.noproduit", "inventaire_1.nocompagnie", "inventaire_1.codeentrepot"], "Shared Hit Blocks": 57, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Scan Direction": "Forward", "Index Name": "idxinoclientunique", "Relation Name": "client", "Schema": "intranet", "Alias": "client_1", "Startup Cost": 0.29, "Total Cost": 8.30, "Plan Rows": 1, "Plan Width": 11, "Actual Startup Time": 0.009, "Actual Total Time": 0.010, "Actual Rows": 1, "Actual Loops": 1, "Output": ["client_1.codeclient", "client_1.codevendeur", "client_1.nocompagnie", "client_1.noclient", "client_1.nomclient", "client_1.adresse1", "client_1.adresse2", "client_1.adresse3", "client_1.codepostal", "client_1.telephone", "client_1.fax", "client_1.keyname", "client_1.vendeur", "client_1.devise", "client_1.codesic", "client_1.classeclient", "client_1.terme", "client_1.courriel", "client_1.dateouverture", "client_1.handling", "client_1.groupement", "client_1.status", "client_1.daterevisioncredit", "client_1.isactif", "client_1.isprospect", "client_1.codeclientcree", "client_1.tsupdate", "client_1.contactachat", "client_1.contactprincipal", "client_1.route", "client_1.limitecredit"], "Index Cond": "((client_1.noclient)::text = '0450219'::text)", "Rows Removed by Index Recheck": 0, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Node Type": "Bitmap Heap Scan", "Parent Relationship": "Inner", "Relation Name": "inventaire", "Schema": "intranet", "Alias": "inventaire_1", "Startup Cost": 52.94, "Total Cost": 342.25, "Plan Rows": 2665, "Plan Width": 21, "Actual Startup Time": 0.312, "Actual Total Time": 0.682, "Actual Rows": 2114, "Actual Loops": 1, "Output": ["inventaire_1.codeproduit", "inventaire_1.codeentrepot", "inventaire_1.nocompagnie", "inventaire_1.noproduit", "inventaire_1.noentrepot", "inventaire_1.lotsouscode", "inventaire_1.piecesenachat", "inventaire_1.coutremplacement", "inventaire_1.coutmoyen", "inventaire_1.piecesenmain", "inventaire_1.piecesreserves", "inventaire_1.piecesbo"], "Recheck Cond": "(inventaire_1.nocompagnie = client_1.nocompagnie)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 54, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Outer", "Index Name": "idxi316", "Startup Cost": 0.00, "Total Cost": 52.27, "Plan Rows": 2665, "Plan Width": 0, "Actual Startup Time": 0.291, "Actual Total Time": 0.291, "Actual Rows": 2114, "Actual Loops": 1, "Index Cond": "(inventaire_1.nocompagnie = client_1.nocompagnie)", "Shared Hit Blocks": 8, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Startup Cost": 9.65, "Total Cost": 9.65, "Plan Rows": 9, "Plan Width": 6, "Actual Startup Time": 0.130, "Actual Total Time": 0.130, "Actual Rows": 9, "Actual Loops": 1, "Output": ["entrepot_1.codeentrepot"], "Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 1, "Shared Hit Blocks": 4, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Relation Name": "entrepot", "Schema": "intranet", "Alias": "entrepot_1", "Startup Cost": 0.00, "Total Cost": 9.65, "Plan Rows": 9, "Plan Width": 6, "Actual Startup Time": 0.005, "Actual Total Time": 0.127, "Actual Rows": 9, "Actual Loops": 1, "Output": ["entrepot_1.codeentrepot"], "Filter": "(((entrepot_1.web)::text = 'P'::text) OR ((entrepot_1.web)::text = 'L'::text))", "Rows Removed by Filter": 368, "Shared Hit Blocks": 4, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] } ] } ] } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Scan Direction": "Forward", "Index Name": "commande_pkey", "Relation Name": "commande", "Schema": "magasin", "Alias": "commande", "Startup Cost": 0.28, "Total Cost": 0.49, "Plan Rows": 1, "Plan Width": 19, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 6232, "Output": ["commande.idcommande", "commande.noclient", "commande.fidusager", "commande.tsinsert", "commande.tsenvoye", "commande.total", "commande.isactif", "commande.nom", "commande.modetransport", "commande.daterequise", "commande.fraistransport", "commande.montanttaxe", "commande.tslastmodification", "commande.montanttps", "commande.montanttvp", "commande.informationscommande", "commande.numerofacture", "commande.tsconfirmation", "commande.interrogation", "commande.nopo", "commande.notes", "commande.tsdelete", "commande.fraissuppl1", "commande.soustotal", "commande.fraissuppl1descriptionfr", "commande.fraissuppl1descriptionan", "commande.fraissuppl2descriptionfr", "commande.fraissuppl2descriptionan", "commande.fraissuppl2", "commande.shipto", "commande.idfournisseurexterne"], "Index Cond": "(commande.idcommande = commandeligne.fidcommande)", "Rows Removed by Index Recheck": 0, "Filter": "((commande.tsenvoye IS NOT NULL) AND ((commande.noclient)::text = '0450219'::text) AND (commande.tsenvoye <= now()) AND (commande.tsenvoye >= ((now() - '2 days'::interval))::timestamp without time zone))", "Rows Removed by Filter": 1, "Shared Hit Blocks": 18730, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Scan Direction": "Forward", "Index Name": "idxi125", "Relation Name": "produit", "Schema": "intranet", "Alias": "produit_2", "Startup Cost": 0.42, "Total Cost": 2.29, "Plan Rows": 6, "Plan Width": 16, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["produit_2.codeproduit", "produit_2.nocompagnie", "produit_2.noproduit", "produit_2.descfrancais", "produit_2.descanglais", "produit_2.codeinterne", "produit_2.facteurconversion", "produit_2.codealpha", "produit_2.classeproduit", "produit_2.prixunitaire", "produit_2.unitepaquet", "produit_2.prixventereg", "produit_2.prixventedirect", "produit_2.codensl", "produit_2.codesn", "produit_2.codeunitemesure", "produit_2.codelivraison", "produit_2.produitsubstituts", "produit_2.descunitemesure", "produit_2.tsupdate", "produit_2.isactif"], "Index Cond": "((produit_2.noproduit)::text = (commandeligne.noproduit)::text)", "Rows Removed by Index Recheck": 0, "Filter": "(produit_2.isactif = 1)", "Rows Removed by Filter": 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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] } ] }, { "Node Type": "Unique", "Parent Relationship": "InitPlan", "Subplan Name": "CTE listecomplete", "Startup Cost": 0.10, "Total Cost": 0.12, "Plan Rows": 2, "Plan Width": 46, "Actual Startup Time": 32.793, "Actual Total Time": 32.804, "Actual Rows": 34, "Actual Loops": 1, "Output": ["listeintranet.noproduit", "listeintranet.daterequise"], "Shared Hit Blocks": 19234, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Sort", "Parent Relationship": "Outer", "Startup Cost": 0.10, "Total Cost": 0.11, "Plan Rows": 2, "Plan Width": 46, "Actual Startup Time": 32.792, "Actual Total Time": 32.795, "Actual Rows": 34, "Actual Loops": 1, "Output": ["listeintranet.noproduit", "listeintranet.daterequise"], "Sort Key": ["listeintranet.noproduit", "listeintranet.daterequise"], "Sort Method": "quicksort", "Sort Space Used": 27, "Sort Space Type": "Memory", "Shared Hit Blocks": 19234, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Append", "Parent Relationship": "Outer", "Startup Cost": 0.03, "Total Cost": 0.09, "Plan Rows": 2, "Plan Width": 46, "Actual Startup Time": 3.552, "Actual Total Time": 32.721, "Actual Rows": 34, "Actual Loops": 1, "Shared Hit Blocks": 19234, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Aggregate", "Strategy": "Hashed", "Parent Relationship": "Member", "Startup Cost": 0.03, "Total Cost": 0.04, "Plan Rows": 1, "Plan Width": 46, "Actual Startup Time": 3.552, "Actual Total Time": 3.558, "Actual Rows": 34, "Actual Loops": 1, "Output": ["listeintranet.noproduit", "listeintranet.daterequise"], "Shared Hit Blocks": 215, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "CTE Scan", "Parent Relationship": "Outer", "CTE Name": "listeintranet", "Alias": "listeintranet", "Startup Cost": 0.00, "Total Cost": 0.02, "Plan Rows": 1, "Plan Width": 46, "Actual Startup Time": 2.923, "Actual Total Time": 3.523, "Actual Rows": 37, "Actual Loops": 1, "Output": ["listeintranet.noproduit", "listeintranet.daterequise"], "Shared Hit Blocks": 215, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] }, { "Node Type": "Aggregate", "Strategy": "Hashed", "Parent Relationship": "Member", "Startup Cost": 0.03, "Total Cost": 0.04, "Plan Rows": 1, "Plan Width": 46, "Actual Startup Time": 29.160, "Actual Total Time": 29.160, "Actual Rows": 0, "Actual Loops": 1, "Output": ["listeinterne.noproduit", "listeinterne.daterequise"], "Shared Hit Blocks": 19019, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "CTE Scan", "Parent Relationship": "Outer", "CTE Name": "listeinterne", "Alias": "listeinterne", "Startup Cost": 0.00, "Total Cost": 0.02, "Plan Rows": 1, "Plan Width": 46, "Actual Startup Time": 29.160, "Actual Total Time": 29.160, "Actual Rows": 0, "Actual Loops": 1, "Output": ["listeinterne.noproduit", "listeinterne.daterequise"], "Shared Hit Blocks": 19019, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] } ] } ] } ] }, { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Join Type": "Inner", "Startup Cost": 0.29, "Total Cost": 16.68, "Plan Rows": 1, "Plan Width": 13, "Actual Startup Time": 32.831, "Actual Total Time": 33.142, "Actual Rows": 31, "Actual Loops": 1, "Output": ["produit.noproduit"], "Shared Hit Blocks": 19337, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "CTE Scan", "Parent Relationship": "Outer", "CTE Name": "listecomplete", "Alias": "listecomplete", "Startup Cost": 0.00, "Total Cost": 0.04, "Plan Rows": 2, "Plan Width": 42, "Actual Startup Time": 32.795, "Actual Total Time": 32.827, "Actual Rows": 34, "Actual Loops": 1, "Output": ["listecomplete.noproduit", "listecomplete.daterequise"], "Shared Hit Blocks": 19234, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Scan Direction": "Forward", "Index Name": "produit_pkey", "Relation Name": "produit", "Schema": "magasin", "Alias": "produit", "Startup Cost": 0.29, "Total Cost": 8.31, "Plan Rows": 1, "Plan Width": 13, "Actual Startup Time": 0.008, "Actual Total Time": 0.008, "Actual Rows": 1, "Actual Loops": 34, "Output": ["produit.fidcategorie", "produit.typeproduit", "produit.isactif", "produit.nomfr", "produit.noman", "produit.descfr", "produit.descan", "produit.notes", "produit.noproduit", "produit.keyword", "produit.codefournisseur", "produit.lienfichetechnique", "produit.isphoto", "produit.searchtext", "produit.codeinterne", "produit.idsegment_image", "produit.nomfr_secondaire", "produit.noman_secondaire", "produit.tsupdate"], "Index Cond": "((produit.noproduit)::text = (listecomplete.noproduit)::text)", "Rows Removed by Index Recheck": 0, "Filter": "(produit.isactif = 1)", "Rows Removed by Filter": 0, "Shared Hit Blocks": 103, "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, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] } ] }, "Triggers": [ ], "Total Runtime": 33.656 } ]"

AlexTatiyants commented 8 years ago

I cannot reproduce the issue with this JSON, it seems to work fine. Are you getting any errors in the console?

rossnick commented 8 years ago

Il the javascript console :

Horodatage : 2016-01-27 18:08:21 Erreur : Error: EXCEPTION: Error during evaluation of "click" ORIGINAL EXCEPTION: SyntaxError: JSON.parse: bad control character in string literal at line 1 column 3 of the JSON data ORIGINAL STACKTRACE: g</a.prototype.createPlan@http://tatiyants.com/pev/bundles/app.js:2:5717 k</a.prototype.submitPlan@http://tatiyants.com/pev/bundles/app.js:2:8871 anonymous/ChangeDetector_a_0.prototype.handleEventInternal@http://tatiyants.com/pev/lib/angular2.min.js line 8 > Function:582:25 g</e.prototype.handleEvent@http://tatiyants.com/pev/lib/angular2.min.js:6:21386 y</e.prototype.dispatchEvent@http://tatiyants.com/pev/lib/angular2.min.js:7:6016 y</e.prototype.dispatchRenderEvent@http://tatiyants.com/pev/lib/angular2.min.js:7:5904 d</t.prototype.dispatchRenderEvent@http://tatiyants.com/pev/lib/angular2.min.js:5:30914 i/o@http://tatiyants.com/pev/lib/angular2.min.js:7:14519 o/<@http://tatiyants.com/pev/lib/angular2.min.js:7:14856 a/<@http://tatiyants.com/pev/lib/angular2.min.js:11:21754 p</t.prototype.addEventListener/i/<@http://tatiyants.com/pev/lib/angular2.min.js:6:214 run@http://tatiyants.com/pev/lib/angular2-polyfills.js:138:14 u</e.prototype._createInnerZone/<.$run/<@http://tatiyants.com/pev/lib/angular2.min.js:4:14655 u</e.prototype.run@http://tatiyants.com/pev/lib/angular2.min.js:4:14061 p</t.prototype.addEventListener/i@http://tatiyants.com/pev/lib/angular2.min.js:6:190 run@http://tatiyants.com/pev/lib/angular2-polyfills.js:138:14 zoneBoundFn@http://tatiyants.com/pev/lib/angular2-polyfills.js:111:14

ERROR CONTEXT: [object Object]

rossnick commented 8 years ago

Ha !

It was encased into double-quotes. I remove the quotes and it works !