psycopg2 connection can be left idle in transaction
repro:
(1) make a psycopg2 conn
(2) make a pandas df
(3) call df.read_sql_query("SELECT pg_sleep(1000);", conn)
(4) kill the terminal

actual: connection on backend is left hanging as idle in transaction
