Is this project abandoned?

AlexTatiyants / pev

Postgres Explain Visualizer

MIT License

2.77k stars 194 forks source link

Is this project abandoned? #42

Open AbelVM opened 6 years ago

AbelVM commented 6 years ago

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 commented 6 years ago

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

pgiraud commented 5 years ago

@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 commented 5 years ago

Parallelism mainly:

complete and correct workers support (#26 and #29 )
parallel workers' sort activity
parallel hash join

And also, as you are working on it :grin: , 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 commented 5 years ago

@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 commented 5 years ago

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! :grin:
This: https://github.com/AlexTatiyants/pev/issues/42#issuecomment-509985745 . There's a parallel branch so... :grimacing:

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

jpmckinney commented 3 years ago

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!