Re: Finding execution time for a query

2025-03-13 Thread Laurenz Albe
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

Finding execution time for a query

2025-03-13 Thread Prasanna Thirugnanasambandam
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