Re: Analyzing last run query in psql
От | Andreas Kretschmer |
---|---|
Тема | Re: Analyzing last run query in psql |
Дата | |
Msg-id | 20130703062057.GA12998@tux обсуждение исходный текст |
Ответ на | Analyzing last run query in psql (Joe Van Dyk <joe@tanga.com>) |
Ответы |
Re: Analyzing last run query in psql
|
Список | pgsql-general |
Joe Van Dyk <joe@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°
В списке pgsql-general по дате отправления: