Is it possible to extract Query Plans generated by auto_explain?

[rdnkrkmz]

In our environment, we use auto_explain to see query plans. Plans are logged in postgressql.log file. We want to extact this query plans via pgBadger, if it is possible. Later on for examining. There may be new tab or link in the report.

[gleu]

pgBadger already does that.

[darold]

Right, auto_explain plan in log file are automatically detected by pgbadger. You will also have a link in the report to see the explain plan on Explain Depesz web site.

[rdnkrkmz]

It is great. So, where the plans are located?

[darold]

In the Top queries reports through the Examples button if I recall well.

[rdnkrkmz]

Yes, see them in report, in the examples section. Thank you very much for your guidane.