dalibo/pev2

Deduplicate " in JSON plans from pgAdmin

Krysztophe opened this issue · 2 comments

Krysztophe commented

When copying a plan from pgAdmin ( F7 to ask for an EXPLAIN, click on Sortie de données, click on the line with the JSON), pgAdmin creates duplicate ". Weird.
This leads to unparsable plans.

Is it possible to remove them automatically?

Example:

"[
  {
    ""Plan"": {
      ""Node Type"": ""ModifyTable"",
      ""Operation"": ""Delete"",
      ""Parallel Aware"": false,
      ""Async Capable"": false,
      ""Relation Name"": ""toto123456789"",
      ""Schema"": ""public"",
      ""Alias"": ""toto123456789"",
      ""Startup Cost"": 0.00,
      ""Total Cost"": 72124.00,
      ""Plan Rows"": 0,
      ""Plan Width"": 0,
      ""Plans"": [
        {
          ""Node Type"": ""Seq Scan"",
          ""Parent Relationship"": ""Outer"",
          ""Parallel Aware"": false,
          ""Async Capable"": false,
          ""Relation Name"": ""toto123456789"",
          ""Schema"": ""public"",
          ""Alias"": ""toto123456789"",
          ""Startup Cost"": 0.00,
          ""Total Cost"": 72124.00,
          ""Plan Rows"": 5000000,
          ""Plan Width"": 6,
          ""Output"": [""ctid""]
        }
      ]
    },
    ""Settings"": {
    },
    ""Planning Time"": 0.041
  }
]"
pgiraud commented

This one seem just *too crazy. I'm not even sure I want to try to take this into account.

Krysztophe commented

This one seem just *too crazy. I'm not even sure I want to try to take this into account.

Depends on where you click when coping the plan. In fact this happens when copying the whole line and not just the cell containing the output in pgadmin.