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 < akretsch...@spamfence.net> wrote: > Joe Van Dyk <j...@tanga.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
