Is this project abandoned?

[AbelVM]

Just curious.

There is no commit in the last 3 years, 1 year old PR with no answer and several issues without answer or action taken.

Is there any up-to-date fork, or alternative project that fully works with PostgreSQL 10+ features? I have started my own 10+ fork, indeed, just asking to avoid useless extra work if anybody has done it already.

[macobo]

Doesn't seem like there is an up-to-date fork according to https://github.com/AlexTatiyants/pev/network

[pgiraud]

@AbelVM I've been working on a fork/rewrite as well with a bunch on fixes and new stuff. I hope I can publish it soon.
What are the PostgreSQL 10+ features you are thinking of?

[AbelVM]

Parallelism mainly:

• complete and correct workers support (Parallel Sequential Scan "Workers" array objects displayed as [Object object] #26 and Actual Duration Loops Need to Divide by Workers + 1 #29 )
• parallel workers' sort activity
• parallel hash join

And also, as you are working on it 😁 , some nice to have features, not related to Postgres version:

• Color-coding the join methods( nested, merged, hash joins) and sort methods (external, quicksort, heapsort) based on its theoretical performance from fastest to slowest (green to red), to get a quick look of the selected strategy per node
• Big warning when a node operation is using disk!!
• Adding information of the selectivity of a node: output rows/ input rows ratio and visual clue when the ratio is close to 1
• Pack it as a component, to enable devs to integrate it into other projects instead of being standalone
• Ability to consume external JSONs, local or remote. This way, it can be connected to a pipeline instead of being an isolated piece where you need to copy&paste the explain results

[pgiraud]

@AbelVM As mentioned earlier, I worked on a rewrite of PEV given its inactivity with the hope to mainain and enhance it.
Please have a look at https://github.com/dalibo/pev2
Looking forward to getting feedback.

[AbelVM]

Looks über-coo @pgiraud l!

We should move the conversation to your repo, but:

• Is it planned to go through all the pending issues here? Roadmap? I have seen some of them already fixed in your examples! 😁
• This: Is this project abandoned?  #42 (comment) . There's a parallel branch so... 😬

Will give it an IRL test tomorrow at the office and any further feedback will be posted at your repo

[jpmckinney]

I came here to report the issues already reported in #26 #29 and stumbled on https://explain.dalibo.com/plan separately. It is a great replacement, @pgiraud!