query execution time in query result in PostgreSQL

Question

Can i get query actual execution time (of all query) in query result PostgreSQL? Like this:

select __get_execution_time() some_column

return:

 some_column
 -----------
 1 sec

Is it possible to imlement such a function? I want to get result and execution time in one query.

Laurenz Albe · Accepted Answer · 2017-12-21 15:31:26Z

2

There is no such function in PostgreSQL.

What you can do is run

EXPLAIN (ANALYZE, FORMAT 'json') SELECT ...

and get the "Planning Time" and "Execution Time" properties from the result.

answered Dec 21, 2017 at 15:31

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Is it possible to imlement such a function? I want to get result and execution time in one query.

Yes, that is certainly possible.

I don't know how to do this. How to give all of query into function args? Can you help me?