database_connect_bench/dcb_python_psql

21 lines
376 B
Plaintext
Raw Permalink Normal View History

2021-05-06 22:35:03 +02:00
#!/usr/bin/python3
import time
t0 = time.monotonic()
import psycopg2
t1 = time.monotonic()
db = psycopg2.connect("")
t2 = time.monotonic()
csr = db.cursor()
csr.execute("select current_timestamp")
r = csr.fetchall()
t3 = time.monotonic()
db.close()
t4 = time.monotonic()
print(t1 - t0, "import")
print(t2 - t1, "connect")
print(t4 - t0, "total")
print(t4 - t1, "session")