March 26th, 2011 by depesz | Tags: , , , , | No comments »
Did it help? If yes - maybe you can help me? Donate BTC to 19zPa5diT2LZqGtTi8f8bfApLn8rw9zBHx

Today, I released 2 new versions (new features in 0.5, and then quick bugfix in 0.51) of Pg::Explain Perl library.

This is the base of explain.depesz.com – the code that does heavy lifting of parsing plans, and providing them in uniform way (object).

There are basically three new features:

  • added filter which lets it parse explain analyze plans from pgAdmin3 (which quotes every line of plan separately)
  • added parsing of non-text plans (XML, JSON, YAML) as generated from new PostgreSQLs
  • added proper support for CTE in explains

So, feel free to test. I would especially like to ask for tests of new formats – I didn't have enough test cases of these, so there are probably some things that are not parsed/shown correctly. If you'd find something like this, I would very appreciate if you could send me the badly parsed plan plus the same plan (i.e. plan of the same query) in text format, so I could see what's wrong, and fix it.

Leave a comment