]$ psql -c "SELECT pid, age(clock_timestamp(), query_start), usename, query FROM pg_stat_activity WHERE state = 'idle in transaction' AND query NOT LIKE '%pg_stat_activity%';"
   pid   |       age       |  usename  |                                        query
---------+-----------------+-----------+-------------------------------------------------------------------------------------
 2961991 | 00:09:44.941712 | candlepin | SELECT * FROM public.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
(1 row)