Re: Analyzing last run query in psql

On Wed, Jul 3, 2013 at 6:43 AM, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> wrote:

> It was my dream to have something we already have in shell -
>
> explain analyze !$
>

It would probably be: explain analyze !!

(at least in bash syntax)

Joe

>
> I think it should be not very difficult.
>
> Oleg
>
> On Tue, 2 Jul 2013, Joe Van Dyk 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).
>>
>> Joe
>>
>>
> Regards,
> Oleg
> ______________________________**______________________________**_
> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
> Sternberg Astronomical Institute, Moscow University, Russia
> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> phone: +007(495)939-16-83, +007(495)939-23-83
>
>
>
> --
> 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<http://www.postgresql.org/mailpref/pgsql-general>
>