On 2023-09-15 17:42:06 +0200, Albert-Jan Roskam via Python-list wrote: > This is more related to Postgresql than to Python, I hope this is ok. > I want to measure Postgres queries N times, much like Python timeit > (https://docs.python.org/3/library/timeit.html). I know about EXPLAIN > ANALYZE and psql \timing, but there's quite a bit of variation in the > times. Is there a timeit-like function in Postgresql?
Why not simply call it n times from Python?
(But be aware that calling the same query n times in a row is likely to be
unrealistically fast because most of the data will already be in
memory.)
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | [email protected] | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
-- https://mail.python.org/mailman/listinfo/python-list
