Обсуждение: EXPLAIN ANALYZE in batch file
hello, I am working with PostgreSQL 9 in windows (pgAdmin3) and I'm trying to execute EXPLAIN ANALYZE command on some queries that are really time consumming. I would like to do it at once and send the results to a single file. can anybody help me to solve this please? thanks
just make a text file with the sql commands in it.
end each command with a ;
the make a scheduled job that executes the program psql, taking the commands from the file.
so, i make text file calles test.sql. the contents are:
vacuum analyze;
create table test as select 'hello world'::text;
--the end
then make a scheduled job that executes this command:
psql -f test.sql -U itsme postgres
(psql is the command line client for postgresql, manual here: http://www.postgresql.org/docs/9.1/static/app-psql.html)
It would ask for a password, so you need to create a way to allow the script to run without you typing the password.
i use peer authentication, but that is not supported in windows.
you could use the password file for that:
On Microsoft Windows the file is named %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile).
It should look like this:
localhost:5432:postgres:itsme:secret
HTH
WBL
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
end each command with a ;
the make a scheduled job that executes the program psql, taking the commands from the file.
so, i make text file calles test.sql. the contents are:
vacuum analyze;
create table test as select 'hello world'::text;
--the end
then make a scheduled job that executes this command:
psql -f test.sql -U itsme postgres
(psql is the command line client for postgresql, manual here: http://www.postgresql.org/docs/9.1/static/app-psql.html)
It would ask for a password, so you need to create a way to allow the script to run without you typing the password.
i use peer authentication, but that is not supported in windows.
you could use the password file for that:
On Microsoft Windows the file is named %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile).
It should look like this:
hostname:port:database:username:passwordso for example:
localhost:5432:postgres:itsme:secret
HTH
WBL
On Sat, May 19, 2012 at 11:02 AM, michel wildcat <m.wildcat82@gmail.com> wrote:
hello,
I am working with PostgreSQL 9 in windows (pgAdmin3) and I'm trying to
execute EXPLAIN ANALYZE command on some queries that are
really time consumming. I would like to do it at once and send the
results to a single file.
can anybody help me to solve this please?
thanks
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth