From: | Prasanna Thirugnanasambandam <balajipts07(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Finding execution time for a query |
Date: | 2025-03-13 09:51:27 |
Message-ID: | CAPhJzzWnGBbyOW4a5acgBqCgQef5Je-JSrjXBAnE86BukWHw+w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <database name>
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 connection time)
used *pg_stat_statements* to fetch execution time for that query.
SELECT total_exec_time FROM pg_stat_statements where query = '<query here>'
got:
total_exec_time
--------------------
12.242579000000001
(1 row)
used *EXPLAIN ANALYZE*, got:
QUERY PLAN
------------------------------------------------------------------------------------------------
<query description> (cost=0.00..0.01 rows=0 width=0) (actual
time=0.182..0.182 rows=0 loops=1)
-> Result (cost=0.00..0.01 rows=1 width=230) (actual time=0.034..0.034
rows=1 loops=1)
Planning Time: 0.021 ms
Execution Time: 0.195 ms
(4 rows)
Now, which among these gives me the actual execution time of the query? Or
rather, how can i find out the actual execution time of the query?
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Foerster | 2025-03-13 10:10:40 | Re: Moving from Linux to Linux? |
Previous Message | Paul Foerster | 2025-03-13 08:53:16 | Re: Moving from Linux to Linux? |