Get execution time of PostgreSQL query

by

If you mean in psql, rather than some program you are writing, use \? for the help, and see:

\timing [on|off]       toggle timing of commands (currently off)

And then you get output like:

# \timing on
Timing is on.

# select 1234;        
 ?column? 
----------
     1234
(1 row)

Time: 0.203 ms

More Related Contents:

  1. Best way to select random rows PostgreSQL
  2. Optimise PostgreSQL for fast testing
  3. Normalize array subscripts so they start with 1
  4. SQL SELECT speed int vs varchar
  5. What is the fastest way to truncate timestamps to 5 minutes in Postgres?
  6. How to return result of a SELECT inside a function in PostgreSQL?
  7. Grouped LIMIT in PostgreSQL: show the first N rows for each group?
  8. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  9. Possible to perform cross-database queries with PostgreSQL?
  10. Reset auto increment counter in postgres
  11. Optimize query with OFFSET on large table
  12. GROUP BY and aggregate sequential numeric values
  13. Safely rename tables using serial primary key columns
  14. How to concatenate columns in a Postgres SELECT?
  15. How to use (install) dblink in PostgreSQL?
  16. get JOIN table as array of results with PostgreSQL/NodeJS
  17. updating table rows in postgres using subquery
  18. How can I send email from PostgreSQL trigger?
  19. Find overlapping date ranges in PostgreSQL
  20. Postgres manually alter sequence
  21. What’s the proper index for querying structures in arrays in Postgres jsonb?
  22. Postgres sql insert query syntax error from phpPgAdmin
  23. Combine two columns and add into one new column
  24. Bulk/batch update/upsert in PostgreSQL
  25. Update a column of a table with a column of another table in PostgreSQL
  26. Check if NULL exists in Postgres array
  27. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  28. PostgreSQL: Full Text Search – How to search partial words?
  29. Temporal database design, with a twist (live vs draft rows)
  30. How to bulk insert only new rows in PostreSQL

Leave a Comment