search

AlexTatiyants / pev

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

No stats are shown on nodes #34

Open dkundo opened 6 years ago

dkundo commented 6 years ago

image

The plan: plan.txt

mbd-dbc-dk commented 6 years ago

The plan is missing two attributes, that I think pev needs to display the stats: "Planning Time": 0.278, "Execution Time": 54.130 I am not entirely sure how to get them. I noticed that they are missing from my own plans when using auto_explain and grabbing from the logs.

They appear to be present, if used like this in the console:

explain (ANALYZE, VERBOSE, FORMAT JSON) select ...