Re: Analyzing last run query in psql

I'd like the execution plan to be in the psql output, not in the postgres
log.

On Tue, Jul 2, 2013 at 11:20 PM, Andreas Kretschmer <
akretschmer(at)spamfence(dot)net> wrote:

> Joe Van Dyk <joe(at)tanga(dot)com> wrote:
>
> > I frequently need to analyze the last query in psql:
> > select * from table where id = 1;
> > explain analyze select * from table where id = 1;
> >
> > It would be nice to be able to do this:
> > explain analyze $LAST
> >
> > (or can I do something like that already?)
> >
> > I'm not using psql interactively, I pipe files into psql (if it matters).
>
> There is no history or something like that, but you can use autoexplain.
> http://www.postgresql.org/docs/9.2/interactive/auto-explain.html
>
>
>
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unintentional side effect. (Linus Torvalds)
> "If I was god, I would recompile penguin with --enable-fly." (unknown)
> Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>