1

I work with PostgreSQL in the command line interface. I would like to activate a \timing command permanently for every database in the cluster so every time I connect to a database - this parameter is on. I searched in postgresql.conf file, but I haven't found anything like what I want to switch on.

My PostgreSQL is 9.5.4 on x86_64 Ubuntu 16.04.2.

4

\timing is specific to the client psql, not to the database server. You need to put that into the configuration file for psql which is ~/.psqlrc

See the manual for details: https://www.postgresql.org/docs/current/static/app-psql.html#AEN100589

psql attempts to read and execute commands from the system-wide startup file (psqlrc) and then the user's personal startup file (~/.psqlrc), after connecting to the database but before accepting normal commands

  • 1
    It worked. I created a file: touch ~/.psqlrc and added '\timing' string there. – Yaroslav Nov 22 '16 at 12:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.