On Thu, 2025-03-13 at 15:21 +0530, Prasanna Thirugnanasambandam wrote:
> How do I find the execution time of a query?
My Stackexchange answer didn't satisfy?
https://dba.stackexchange.com/a/345698/176905
Yours,
Laurenz Albe
Hello all,
How do I find the execution time of a query?
I tried these methods:
I used
pgbench - pgbench -n -t 1 -f ./query.sql
and got:
latency average = 9.787 ms <- should i take this as the execution time?
initial connection time = 12.481 ms
tps = 102.176356 (without initial conn